Lines Matching defs:TABLE
71 * Internal database table used for account information
73 public static final String TABLE = "accounts";
77 public static final Uri CONTENT_URI = Uri.withAppendedPath(BASE_CONTENT_URI, TABLE);
94 /** Internal database table used for basic photo information. */
95 public static final String TABLE = "photos";
97 public static final Uri CONTENT_URI = Uri.withAppendedPath(BASE_CONTENT_URI, TABLE);
133 /** Internal database table used album information. */
134 public static final String TABLE = "albums";
136 public static final Uri CONTENT_URI = Uri.withAppendedPath(BASE_CONTENT_URI, TABLE);
170 /** Internal database table used metadata information. */
171 public static final String TABLE = "metadata";
173 public static final Uri CONTENT_URI = Uri.withAppendedPath(BASE_CONTENT_URI, TABLE);
218 + Albums.TABLE;
220 + Photos.TABLE;
221 protected static final String SELECT_PHOTO_COUNT = "SELECT COUNT(*) FROM " + Photos.TABLE;
222 protected static final String DELETE_PHOTOS = "DELETE FROM " + Photos.TABLE;
223 protected static final String DELETE_METADATA = "DELETE FROM " + Metadata.TABLE;
224 protected static final String SELECT_METADATA_COUNT = "SELECT COUNT(*) FROM " + Metadata.TABLE;
257 sUriMatcher.addURI(AUTHORITY, Photos.TABLE, MATCH_PHOTO);
259 sUriMatcher.addURI(AUTHORITY, Photos.TABLE + "/#", MATCH_PHOTO_ID);
260 sUriMatcher.addURI(AUTHORITY, Albums.TABLE, MATCH_ALBUM);
262 sUriMatcher.addURI(AUTHORITY, Albums.TABLE + "/#", MATCH_ALBUM_ID);
263 sUriMatcher.addURI(AUTHORITY, Metadata.TABLE, MATCH_METADATA);
265 sUriMatcher.addURI(AUTHORITY, Metadata.TABLE + "/#", MATCH_METADATA_ID);
266 sUriMatcher.addURI(AUTHORITY, Accounts.TABLE, MATCH_ACCOUNT);
268 sUriMatcher.addURI(AUTHORITY, Accounts.TABLE + "/#", MATCH_ACCOUNT_ID);
295 String table = getTableFromMatch(match, uri);
298 long id = db.insert(table, null, values);
300 // uri already matches the table.
320 String table = getTableFromMatch(match, uri);
321 Cursor c = query(table, projection, selection, selectionArgs, sortOrder, cancellationSignal);
339 String table = getTableFromMatch(match, uri);
340 rowsUpdated = db.update(table, values, selection, selectionArgs);
391 String table;
395 table = Photos.TABLE;
399 table = Albums.TABLE;
403 table = Metadata.TABLE;
407 table = Accounts.TABLE;
412 return table;
426 rowCount = db.delete(Metadata.TABLE, WHERE_METADATA_ID, selectionArgs);
428 long rowId = db.replace(Metadata.TABLE, null, values);
455 protected static String nestWhere(String matchColumn, String table, String nestedWhere) {
456 String query = SQLiteQueryBuilder.buildQueryString(false, table, BASE_COLUMNS_ID,
462 return nestWhere(Metadata.PHOTO_ID, Photos.TABLE, where);
466 return nestWhere(Photos.ALBUM_ID, Albums.TABLE, where);
470 return nestWhere(Photos.ACCOUNT_ID, Accounts.TABLE, where);
474 return nestWhere(Albums.ACCOUNT_ID, Accounts.TABLE, where);
498 String table = getTableFromMatch(match, uri);
499 int deleted = db.delete(table, selection, selectionArgs);
518 protected Cursor query(String table, String[] columns, String selection,
522 return db.query(false, table, columns, selection, selectionArgs, null, null,
525 return db.query(table, columns, selection, selectionArgs, null, null, orderBy);
