Lines Matching refs:db
94 private static final String DATABASE_NAME = "accounts.db";
282 final SQLiteDatabase db = accounts.openHelper.getWritableDatabase();
283 final Cursor cursor = db.query(TABLE_GRANTS,
295 db.delete(TABLE_GRANTS, GRANTS_GRANTEE_UID + "=?",
333 final SQLiteDatabase db = accounts.openHelper.getWritableDatabase();
335 Cursor cursor = db.query(TABLE_ACCOUNTS,
350 db.delete(TABLE_ACCOUNTS, ACCOUNTS_ID + "=" + accountId, null);
452 final SQLiteDatabase db = accounts.openHelper.getReadableDatabase();
453 Cursor cursor = db.query(TABLE_ACCOUNTS, new String[]{ACCOUNTS_PASSWORD},
536 final SQLiteDatabase db = accounts.openHelper.getWritableDatabase();
537 db.beginTransaction();
539 long numMatches = DatabaseUtils.longForQuery(db,
552 long accountId = db.insert(TABLE_ACCOUNTS, ACCOUNTS_NAME, values);
561 if (insertExtraLocked(db, accountId, key, value) < 0) {
568 db.setTransactionSuccessful();
571 db.endTransaction();
578 private long insertExtraLocked(SQLiteDatabase db, long accountId, String key, String value) {
583 return db.insert(TABLE_EXTRAS, EXTRAS_KEY, values);
743 final SQLiteDatabase db = accounts.openHelper.getWritableDatabase();
744 db.delete(TABLE_ACCOUNTS, ACCOUNTS_NAME + "=? AND " + ACCOUNTS_TYPE+ "=?",
764 final SQLiteDatabase db = accounts.openHelper.getWritableDatabase();
765 db.beginTransaction();
767 invalidateAuthTokenLocked(accounts, db, accountType, authToken);
768 db.setTransactionSuccessful();
770 db.endTransaction();
778 private void invalidateAuthTokenLocked(UserAccounts accounts, SQLiteDatabase db,
783 Cursor cursor = db.rawQuery(
799 db.delete(TABLE_AUTHTOKENS, AUTHTOKENS_ID + "=" + authTokenId, null);
800 writeAuthTokenIntoCacheLocked(accounts, db, new Account(accountName, accountType),
816 final SQLiteDatabase db = accounts.openHelper.getWritableDatabase();
817 db.beginTransaction();
819 long accountId = getAccountIdLocked(db, account);
823 db.delete(TABLE_AUTHTOKENS,
830 if (db.insert(TABLE_AUTHTOKENS, AUTHTOKENS_AUTHTOKEN, values) >= 0) {
831 db.setTransactionSuccessful();
832 writeAuthTokenIntoCacheLocked(accounts, db, account, type, authToken);
837 db.endTransaction();
902 final SQLiteDatabase db = accounts.openHelper.getWritableDatabase();
903 db.beginTransaction();
907 final long accountId = getAccountIdLocked(db, account);
910 db.update(TABLE_ACCOUNTS, values, ACCOUNTS_ID + "=?", argsAccountId);
911 db.delete(TABLE_AUTHTOKENS, AUTHTOKENS_ACCOUNTS_ID + "=?", argsAccountId);
913 db.setTransactionSuccessful();
916 db.endTransaction();
970 final SQLiteDatabase db = accounts.openHelper.getWritableDatabase();
971 db.beginTransaction();
973 long accountId = getAccountIdLocked(db, account);
977 long extrasId = getExtrasIdLocked(db, accountId, key);
979 extrasId = insertExtraLocked(db, accountId, key, value);
986 if (1 != db.update(TABLE_EXTRAS, values, EXTRAS_ID + "=" + extrasId, null)) {
991 writeUserDataIntoCacheLocked(accounts, db, account, key, value);
992 db.setTransactionSuccessful();
994 db.endTransaction();
1622 private long getAccountIdLocked(SQLiteDatabase db, Account account) {
1623 Cursor cursor = db.query(TABLE_ACCOUNTS, new String[]{ACCOUNTS_ID},
1635 private long getExtrasIdLocked(SQLiteDatabase db, long accountId, String key) {
1636 Cursor cursor = db.query(TABLE_EXTRAS, new String[]{EXTRAS_ID},
1960 * @param db The database.
1963 public void onCreate(SQLiteDatabase db) {
1964 db.execSQL("CREATE TABLE " + TABLE_ACCOUNTS + " ( "
1971 db.execSQL("CREATE TABLE " + TABLE_AUTHTOKENS + " ( "
1978 createGrantsTable(db);
1980 db.execSQL("CREATE TABLE " + TABLE_EXTRAS + " ( "
1987 db.execSQL("CREATE TABLE " + TABLE_META + " ( "
1991 createAccountsDeletionTrigger(db);
1994 private void createAccountsDeletionTrigger(SQLiteDatabase db) {
1995 db.execSQL(""
2007 private void createGrantsTable(SQLiteDatabase db) {
2008 db.execSQL("CREATE TABLE " + TABLE_GRANTS + " ( "
2017 public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
2027 createGrantsTable(db);
2028 db.execSQL("DROP TRIGGER " + TABLE_ACCOUNTS + "Delete");
2029 createAccountsDeletionTrigger(db);
2034 db.execSQL("UPDATE " + TABLE_ACCOUNTS + " SET " + ACCOUNTS_TYPE +
2041 public void onOpen(SQLiteDatabase db) {
2092 final SQLiteDatabase db = userAccounts.openHelper.getReadableDatabase();
2096 Cursor cursor = db.query(TABLE_ACCOUNTS, ACCOUNT_TYPE_COUNT_PROJECTION,
2257 final SQLiteDatabase db = accounts.openHelper.getReadableDatabase();
2261 DatabaseUtils.longForQuery(db, COUNT_OF_MATCHING_GRANTS, args) != 0;
2333 final SQLiteDatabase db = accounts.openHelper.getWritableDatabase();
2334 db.beginTransaction();
2336 long accountId = getAccountIdLocked(db, account);
2342 db.insert(TABLE_GRANTS, GRANTS_ACCOUNTS_ID, values);
2343 db.setTransactionSuccessful();
2346 db.endTransaction();
2368 final SQLiteDatabase db = accounts.openHelper.getWritableDatabase();
2369 db.beginTransaction();
2371 long accountId = getAccountIdLocked(db, account);
2373 db.delete(TABLE_GRANTS,
2378 db.setTransactionSuccessful();
2381 db.endTransaction();
2454 protected void writeUserDataIntoCacheLocked(UserAccounts accounts, final SQLiteDatabase db,
2458 userDataForAccount = readUserDataForAccountFromDatabaseLocked(db, account);
2468 protected void writeAuthTokenIntoCacheLocked(UserAccounts accounts, final SQLiteDatabase db,
2472 authTokensForAccount = readAuthTokensForAccountFromDatabaseLocked(db, account);
2488 final SQLiteDatabase db = accounts.openHelper.getReadableDatabase();
2489 authTokensForAccount = readAuthTokensForAccountFromDatabaseLocked(db, account);
2501 final SQLiteDatabase db = accounts.openHelper.getReadableDatabase();
2502 userDataForAccount = readUserDataForAccountFromDatabaseLocked(db, account);
2510 final SQLiteDatabase db, Account account) {
2512 Cursor cursor = db.query(TABLE_EXTRAS,
2530 final SQLiteDatabase db, Account account) {
2532 Cursor cursor = db.query(TABLE_AUTHTOKENS,