values.put("value", notifications?1:0); this.mDB.update(PREFS_TABLE, values, "key=?", new String[] { "notifications" }); } public int getDBVersion() { return this.mDB.getVersion(); } public void close() { if (this.mDB.isOpen()) { this.mDB.close(); } } private static class DBOpenHelper extends SQLiteOpenHelper { private static final String CREATE_APPS = "CREATE TABLE IF NOT EXISTS " + APPS_TABLE + " (_id INTEGER, uid INTEGER, package TEXT, name TEXT, exec_uid INTEGER, " + "exec_cmd TEXT, allow INTEGER," + " PRIMARY KEY (_id), UNIQUE (uid,exec_uid,exec_cmd));";
Other popular examples for SQLiteDatabase
49: db.execSQL("CREATE TABLE orgs (id INTEGER PRIMARY KEY);");
50: db.execSQL("CREATE TABLE users (id INTEGER PRIMARY KEY, name TEXT, avatarurl TEXT);");
51: db.execSQL("CREATE TABLE repos (id INTEGER PRIMARY KEY, repoId INTEGER, orgId INTEGER, name TEXT, ownerId INTEGER, private INTEGER, fork INTEGER, description TEXT, forks INTEGER, watchers INTEGER, language TEXT, hasIssues INTEGER, mirrorUrl TEXT);");
-
57: db.execSQL("DROP TABLE IF EXISTS orgs");
58: db.execSQL("DROP TABLE IF EXISTS users");
59: db.execSQL("DROP TABLE IF EXISTS repos");
Full Snippet Info129: db.beginTransaction();
-
131: persistableResource.store(db, items);
132: db.setTransactionSuccessful();
-
134: db.endTransaction();
Full Snippet Info448: database.delete("exectable", null, null);
-
450: Cursor cursor = database.rawQuery("select * from exectable", null);
-
454: database.execSQL("insert into exectable (first_column) values (?);", new String[]{});
455: Cursor cursor2 = database.rawQuery("select * from exectable", new String[]{null});
Full Snippet Info