This is an old revision of the document!
Table of Contents
Chapter 11
Under development.
You may hear the expression “CRUD” used in relation to databases. And if you haven't, you have now. CRUD is a acronym for Create, Read, Update, and Delete—the four main operations that are done on database records. It's also helpful to think in terms of database schema—the plan or layout of the database table(s).
The book consistently uses “a” as the indefinite article ahead of “SQLite”—most probably because they assume a pronunciation of “sequel lite.” The primary author of “SQLite” sees things differently, so the indefinite article should be “an”.
p. 444: Code block
- StarbuzzDatabaseHelper.java
package com.hfad.starbuzz; import android.database.sqlite.SQLiteOpenHelper; import android.content.Context; import android.database.sqlite.SQLiteDatabase; class StarbuzzDatabaseHelper extends SQLiteOpenHelper { StarbuzzDatabaseHelper(Context context) { // This constructor isn't liked by the compiler. // It'll be fixed shortly. } @Override public void onCreate(SQLiteDatabase db) { } @Override public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { } }
Note that the constructor in the above class definition creates compiler rage. It gets fixed on the following page.
p. 447
You create the schema for your database in the SQLiteOpenHelper
's onCreate
method using plain old SQL on the SQLite database that's passed in.
/** * Create a DRINK table with an _id PK, * and fields for NAME, DESCRIPTION, and * IMAGE_RESOURCE_ID. * @param db */ @Override public void onCreate(SQLiteDatabase db) { db.execSQL("CREATE TABLE DRINK (" + "_id INTEGER PRIMARY KEY AUTOINCREMENT, " + "NAME TEXT, " + "DESCRIPTION TEXT, " + "IMAGE_RESOURCE_ID INTEGER);"); }