/packages/apps/Gallery2/src/com/android/photos/data/ |
H A D | PhotoProvider.java | 73 public static final String TABLE = "accounts"; field in interface:PhotoProvider.Accounts 77 public static final Uri CONTENT_URI = Uri.withAppendedPath(BASE_CONTENT_URI, TABLE); 95 public static final String TABLE = "photos"; field in interface:PhotoProvider.Photos 97 public static final Uri CONTENT_URI = Uri.withAppendedPath(BASE_CONTENT_URI, TABLE); 134 public static final String TABLE = "albums"; field in interface:PhotoProvider.Albums 136 public static final Uri CONTENT_URI = Uri.withAppendedPath(BASE_CONTENT_URI, TABLE); 171 public static final String TABLE = "metadata"; field in interface:PhotoProvider.Metadata 173 public static final Uri CONTENT_URI = Uri.withAppendedPath(BASE_CONTENT_URI, TABLE); 218 + Albums.TABLE; 220 + Photos.TABLE; [all...] |
H A D | PhotoDatabase.java | 39 private static final String SQL_CREATE_TABLE = "CREATE TABLE "; 88 createTable(db, Accounts.TABLE, getAccountTableDefinition()); 89 createTable(db, Albums.TABLE, getAlbumTableDefinition()); 90 createTable(db, Photos.TABLE, getPhotoTableDefinition()); 91 createTable(db, Metadata.TABLE, getMetadataTableDefinition()); 113 dropTable(db, Metadata.TABLE); 114 dropTable(db, Photos.TABLE); 115 dropTable(db, Albums.TABLE); 116 dropTable(db, Accounts.TABLE);
|
/packages/apps/Gallery2/src/com/android/gallery3d/filtershow/data/ |
H A D | FilterStackDBHelper.java | 27 private static final String SQL_CREATE_TABLE = "CREATE TABLE "; 33 public static final String TABLE = "filterstack"; field in interface:FilterStackDBHelper.FilterStack 60 createTable(db, FilterStack.TABLE, CREATE_FILTER_STACK); 65 dropTable(db, FilterStack.TABLE);
|
H A D | FilterStackSource.java | 63 ret = (-1 != database.insert(FilterStack.TABLE, null, val)); 76 database.update(FilterStack.TABLE, val, FilterStack._ID + " = ?", 88 ret = (0 != database.delete(FilterStack.TABLE, FilterStack._ID + " = ?", 100 database.delete(FilterStack.TABLE, null, null); 112 c = database.query(FilterStack.TABLE, 136 c = database.query(FilterStack.TABLE, 173 c = database.query(FilterStack.TABLE,
|
/packages/providers/ContactsProvider/src/com/android/providers/contacts/aggregation/util/ |
H A D | CommonNicknameCache.java | 48 public final static String TABLE = Tables.NICKNAME_LOOKUP; field in class:CommonNicknameCache.NicknameLookupPreloadQuery 71 Cursor cursor = mDb.query(NicknameLookupPreloadQuery.TABLE, 123 String TABLE = Tables.NICKNAME_LOOKUP; field in interface:CommonNicknameCache.NicknameLookupQuery 134 Cursor cursor = mDb.query(NicknameLookupQuery.TABLE, NicknameLookupQuery.COLUMNS,
|
/packages/providers/ContactsProvider/tests/assets/testUnsynced/ |
H A D | legacy_contacts.sql | 3 CREATE TABLE _deleted_groups (_sync_version TEXT,_sync_id TEXT,_sync_account TEXT,_sync_mark INTEGER); 4 CREATE TABLE _deleted_people (_sync_version TEXT,_sync_id TEXT,_sync_account TEXT,_sync_mark INTEGER); 5 CREATE TABLE _sync_state (_id INTEGER PRIMARY KEY,_sync_account TEXT,data TEXT,UNIQUE(_sync_account)); 6 CREATE TABLE _sync_state_metadata (version INTEGER); 8 CREATE TABLE android_metadata (locale TEXT); 10 CREATE TABLE calls (_id INTEGER PRIMARY KEY AUTOINCREMENT,number TEXT,date INTEGER,duration INTEGER,type INTEGER,new INTEGER,name TEXT,numbertype INTEGER,numberlabel TEXT); 11 CREATE TABLE contact_methods (_id INTEGER PRIMARY KEY AUTOINCREMENT,person INTEGER REFERENCES people(_id),kind INTEGER NOT NULL,data TEXT,aux_data TEXT,type INTEGER NOT NULL,label TEXT,isprimary INTEGER NOT NULL DEFAULT 0); 15 CREATE TABLE extensions (_id INTEGER PRIMARY KEY AUTOINCREMENT,name TEXT NOT NULL,value TEXT NOT NULL,person INTEGER REFERENCES people(_id),UNIQUE(person, name)); 16 CREATE TABLE fave_msg_status (_id INTEGER PRIMARY KEY, msg TEXT, next_retry INTEGER, num_retries INTEGER); 17 CREATE TABLE fave_phone_change [all...] |
/packages/apps/UnifiedEmail/tests/src/com/android/mail/browse/ |
H A D | TestProvider.java | 68 /* package */static final int TABLE = 100; field in class:TestProvider 120 sURIMatcher.addURI(AUTHORITY, table, TABLE); 140 case TABLE: 179 case TABLE: 217 case TABLE:
|
H A D | TestProviderTests.java | 107 assertEquals(TestProvider.TABLE, TestProvider.sURIMatcher.match(uri));
|
/packages/providers/ContactsProvider/tests/assets/test1/ |
H A D | legacy_contacts.sql | 3 CREATE TABLE _deleted_groups (_sync_version TEXT,_sync_id TEXT,_sync_account TEXT,_sync_mark INTEGER); 4 CREATE TABLE _deleted_people (_sync_version TEXT,_sync_id TEXT,_sync_account TEXT,_sync_mark INTEGER); 6 CREATE TABLE _sync_state (_id INTEGER PRIMARY KEY,_sync_account TEXT,data TEXT,UNIQUE(_sync_account)); 8 CREATE TABLE _sync_state_metadata (version INTEGER); 10 CREATE TABLE android_metadata (locale TEXT); 12 CREATE TABLE calls (_id INTEGER PRIMARY KEY AUTOINCREMENT,number TEXT,date INTEGER,duration INTEGER,type INTEGER,new INTEGER,name TEXT,numbertype INTEGER,numberlabel TEXT); 14 CREATE TABLE contact_methods (_id INTEGER PRIMARY KEY AUTOINCREMENT,person INTEGER REFERENCES people(_id),kind INTEGER NOT NULL,data TEXT,aux_data TEXT,type INTEGER NOT NULL,label TEXT,isprimary INTEGER NOT NULL DEFAULT 0); 31 CREATE TABLE extensions (_id INTEGER PRIMARY KEY AUTOINCREMENT,name TEXT NOT NULL,value TEXT NOT NULL,person INTEGER REFERENCES people(_id),UNIQUE(person, name)); 32 CREATE TABLE fave_msg_status (_id INTEGER PRIMARY KEY, msg TEXT, next_retry INTEGER, num_retries INTEGER); 33 CREATE TABLE fave_phone_change [all...] |
/packages/providers/ContactsProvider/tests/assets/testSynced/ |
H A D | legacy_contacts.sql | 3 CREATE TABLE _deleted_groups (_sync_version TEXT,_sync_id TEXT,_sync_account TEXT,_sync_mark INTEGER); 4 CREATE TABLE _deleted_people (_sync_version TEXT,_sync_id TEXT,_sync_account TEXT,_sync_mark INTEGER); 5 CREATE TABLE _sync_state (_id INTEGER PRIMARY KEY,_sync_account TEXT,data TEXT,UNIQUE(_sync_account)); 7 CREATE TABLE _sync_state_metadata (version INTEGER); 9 CREATE TABLE android_metadata (locale TEXT); 11 CREATE TABLE calls (_id INTEGER PRIMARY KEY AUTOINCREMENT,number TEXT,date INTEGER,duration INTEGER,type INTEGER,new INTEGER,name TEXT,numbertype INTEGER,numberlabel TEXT); 12 CREATE TABLE contact_methods (_id INTEGER PRIMARY KEY AUTOINCREMENT,person INTEGER REFERENCES people(_id),kind INTEGER NOT NULL,data TEXT,aux_data TEXT,type INTEGER NOT NULL,label TEXT,isprimary INTEGER NOT NULL DEFAULT 0); 18 CREATE TABLE extensions (_id INTEGER PRIMARY KEY AUTOINCREMENT,name TEXT NOT NULL,value TEXT NOT NULL,person INTEGER REFERENCES people(_id),UNIQUE(person, name)); 19 CREATE TABLE fave_msg_status (_id INTEGER PRIMARY KEY, msg TEXT, next_retry INTEGER, num_retries INTEGER); 21 CREATE TABLE fave_phone_change [all...] |
/packages/providers/ContactsProvider/tests/assets/upgradeTest/ |
H A D | contacts2_1108.sql | 3 CREATE TABLE _sync_state (_id INTEGER PRIMARY KEY,account_name TEXT NOT NULL,account_type TEXT NOT NULL,data TEXT,UNIQUE(account_name, account_type)); 4 CREATE TABLE _sync_state_metadata (version INTEGER); 6 CREATE TABLE properties (property_key TEXT PRIMARY KEY, property_value TEXT ); 14 CREATE TABLE accounts (_id INTEGER PRIMARY KEY AUTOINCREMENT,account_name TEXT, account_type TEXT, data_set TEXT); 15 CREATE TABLE contacts (_id INTEGER PRIMARY KEY AUTOINCREMENT,name_raw_contact_id INTEGER REFERENCES raw_contacts(_id),photo_id INTEGER REFERENCES data(_id),photo_file_id INTEGER REFERENCES photo_files(_id),custom_ringtone TEXT,send_to_voicemail INTEGER NOT NULL DEFAULT 0,times_contacted INTEGER NOT NULL DEFAULT 0,last_time_contacted INTEGER,starred INTEGER NOT NULL DEFAULT 0,pinned INTEGER NOT NULL DEFAULT 0,has_phone_number INTEGER NOT NULL DEFAULT 0,lookup TEXT,status_update_id INTEGER REFERENCES data(_id),contact_last_updated_timestamp INTEGER); 16 CREATE TABLE deleted_contacts (contact_id INTEGER PRIMARY KEY,contact_deleted_timestamp INTEGER NOT NULL default 0); 17 CREATE TABLE raw_contacts (_id INTEGER PRIMARY KEY AUTOINCREMENT,account_id INTEGER REFERENCES accounts(_id),sourceid TEXT,backup_id TEXT,raw_contact_is_read_only INTEGER NOT NULL DEFAULT 0,version INTEGER NOT NULL DEFAULT 1,dirty INTEGER NOT NULL DEFAULT 0,deleted INTEGER NOT NULL DEFAULT 0,metadata_dirty INTEGER NOT NULL DEFAULT 0,contact_id INTEGER REFERENCES contacts(_id),aggregation_mode INTEGER NOT NULL DEFAULT 0,aggregation_needed INTEGER NOT NULL DEFAULT 1,custom_ringtone TEXT,send_to_voicemail INTEGER NOT NULL DEFAULT 0,times_contacted INTEGER NOT NULL DEFAULT 0,last_time_contacted INTEGER,starred INTEGER NOT NULL DEFAULT 0,pinned INTEGER NOT NULL DEFAULT 0,display_name TEXT,display_name_alt TEXT,display_name_source INTEGER NOT NULL DEFAULT 0,phonetic_name TEXT,phonetic_name_style TEXT,sort_key TEXT COLLATE PHONEBOOK,phonebook_label TEXT,phonebook_bucket INTEGER,sort_key_alt TEXT COLLATE PHONEBOOK,phonebook_label_alt TEXT,phonebook_bucket_alt INTEGER,name_verified INTEGER NOT NULL DEFAULT 0,sync1 TEXT, sync2 TEXT, sync3 TEXT, sync4 TEXT ); 18 CREATE TABLE stream_items (_id INTEGER PRIMARY KEY AUTOINCREMENT, raw_contact_id INTEGER NOT NULL, res_package TEXT, icon TEXT, label TEXT, text TEXT, timestamp INTEGER NOT NULL, comments TEXT, stream_item_sync1 TEXT, stream_item_sync2 TEXT, stream_item_sync3 TEXT, stream_item_sync4 TEXT, FOREIGN KEY(raw_contact_id) REFERENCES raw_contacts(_id)); 19 CREATE TABLE stream_item_photos (_id INTEGER PRIMARY KEY AUTOINCREMENT, stream_item_id INTEGER NOT NULL, sort_index INTEGER, photo_file_id INTEGER NOT NULL, stream_item_photo_sync1 TEXT, stream_item_photo_sync2 TEXT, stream_item_photo_sync3 TEXT, stream_item_photo_sync4 TEXT, FOREIGN KEY(stream_item_id) REFERENCES stream_items(_id)); 20 CREATE TABLE photo_file [all...] |
/packages/providers/ContactsProvider/src/com/android/providers/contacts/aggregation/ |
H A D | ContactAggregator2.java | 468 Cursor cursor = db.query(RawContactIdQuery.TABLE, RawContactIdQuery.COLUMNS, 513 final Cursor c = db.query(AggregateExceptionQuery.TABLE, 559 Cursor c = db.query(IdentityLookupMatchQuery.TABLE, IdentityLookupMatchQuery.COLUMNS, 583 Cursor c = db.query(NameLookupMatchQuery.TABLE, NameLookupMatchQuery.COLUMNS, 613 Cursor c = db.query(EmailLookupQuery.TABLE, EmailLookupQuery.COLUMNS, 644 Cursor c = db.query(NameLookupMatchQueryWithParameter.TABLE, 670 Cursor c = db.query(PhoneLookupQuery.TABLE, PhoneLookupQuery.COLUMNS, 717 String TABLE = Tables.NAME_LOOKUP_JOIN_RAW_CONTACTS; field in interface:ContactAggregator2.ContactNameLookupQuery 740 final Cursor c = db.query(ContactNameLookupQuery.TABLE, ContactNameLookupQuery.COLUMNS, 814 final Cursor c = db.query(RawContactIdQuery.TABLE, RawContactIdQuer 935 final String TABLE = Tables.DATA + " dataA" field in interface:ContactAggregator2.IdentityLookupMatchQuery 961 String TABLE = Tables.NAME_LOOKUP + " nameA" field in interface:ContactAggregator2.NameLookupMatchQuery 990 String TABLE = Tables.DATA + " dataA" field in interface:ContactAggregator2.EmailLookupQuery 1015 String TABLE = Tables.PHONE_LOOKUP + " phoneA" field in interface:ContactAggregator2.PhoneLookupQuery 1044 final String TABLE = Tables.RAW_CONTACTS + " LEFT OUTER JOIN " + Tables.NAME_LOOKUP field in interface:ContactAggregator2.NullNameRawContactsIdsQuery [all...] |
H A D | ContactAggregator.java | 483 Cursor cursor = db.query(RawContactIdQuery.TABLE, RawContactIdQuery.COLUMNS, 523 String TABLE = Tables.AGGREGATION_EXCEPTIONS field in interface:ContactAggregator.AggregateExceptionQuery 562 final Cursor c = db.query(AggregateExceptionQuery.TABLE, 687 final String TABLE = Tables.DATA + " dataA" field in interface:ContactAggregator.IdentityLookupMatchQuery 717 Cursor c = db.query(IdentityLookupMatchQuery.TABLE, IdentityLookupMatchQuery.COLUMNS, 732 String TABLE = Tables.NAME_LOOKUP + " nameA" field in interface:ContactAggregator.NameLookupMatchQuery 763 Cursor c = db.query(NameLookupMatchQuery.TABLE, NameLookupMatchQuery.COLUMNS, 788 Cursor c = db.query(EmailLookupQuery.TABLE, EmailLookupQuery.COLUMNS, 805 Cursor c = db.query(PhoneLookupQuery.TABLE, PhoneLookupQuery.COLUMNS, 847 String TABLE field in interface:ContactAggregator.ContactNameLookupQuery [all...] |
H A D | AbstractContactAggregator.java | 562 public static final String TABLE = Tables.RAW_CONTACTS; field in class:AbstractContactAggregator.RawContactIdAndAggregationModeQuery 577 Cursor cursor = db.query(RawContactIdAndAggregationModeQuery.TABLE, 657 public static final String TABLE = Tables.RAW_CONTACTS; field in class:AbstractContactAggregator.RawContactIdAndAccountQuery 682 Cursor cursor = db.query(RawContactIdAndAccountQuery.TABLE, 889 public static final String TABLE = Tables.RAW_CONTACTS; field in class:AbstractContactAggregator.RawContactIdQuery 942 String TABLE = Tables.AGGREGATION_EXCEPTIONS; field in interface:AbstractContactAggregator.AggregateExceptionPrefetchQuery 969 final Cursor c = db.query(AggregateExceptionPrefetchQuery.TABLE, 988 String TABLE = Tables.NAME_LOOKUP; field in interface:AbstractContactAggregator.NameLookupQuery 1007 Cursor c = db.query(NameLookupQuery.TABLE, NameLookupQuery.COLUMNS, 1024 String TABLE field in interface:AbstractContactAggregator.AggregateExceptionQuery 1054 String TABLE = Tables.NAME_LOOKUP field in interface:AbstractContactAggregator.NameLookupMatchQueryWithParameter 1154 String TABLE = Tables.DATA + " dataA" field in interface:AbstractContactAggregator.EmailLookupQuery 1180 String TABLE = Tables.PHONE_LOOKUP + " phoneA" field in interface:AbstractContactAggregator.PhoneLookupQuery 1210 String TABLE = Tables.NAME_LOOKUP_JOIN_RAW_CONTACTS; field in interface:AbstractContactAggregator.ContactNameLookupQuery 1850 String TABLE = Views.RAW_CONTACTS; field in interface:AbstractContactAggregator.LookupKeyQuery [all...] |
/packages/providers/ContactsProvider/src/com/android/providers/contacts/ |
H A D | DataRowHandlerForGroupMembership.java | 44 String TABLE = Tables.RAW_CONTACTS; field in interface:DataRowHandlerForGroupMembership.RawContactsQuery 193 Cursor c = db.query(RawContactsQuery.TABLE, RawContactsQuery.COLUMNS,
|
H A D | DataRowHandler.java | 45 public static final String TABLE = Tables.DATA_JOIN_MIMETYPES; field in interface:DataRowHandler.DataDeleteQuery 343 Cursor c = db.query(DataDeleteQuery.TABLE,
|
H A D | ContactsProvider2.java | 498 public static final String TABLE = "data " field in interface:ContactsProvider2.DataContactsQuery 523 String TABLE = Tables.RAW_CONTACTS_JOIN_ACCOUNTS; field in interface:ContactsProvider2.RawContactsQuery 2564 String TABLE = Tables.RAW_CONTACTS_JOIN_METADATA_SYNC; field in interface:ContactsProvider2.MetadataSyncQuery 2582 final Cursor cursor = db.query(MetadataSyncQuery.TABLE, 3442 cursor = db.query(DataContactsQuery.TABLE, DataContactsQuery.PROJECTION, 4379 String TABLE = Views.GROUPS; field in interface:ContactsProvider2.GroupAccountQuery 4427 final Cursor c = db.query(GroupAccountQuery.TABLE, GroupAccountQuery.COLUMNS, 4570 Cursor cursor = db.query(RawContactsQuery.TABLE, RawContactsQuery.COLUMNS, 4949 String TABLE = Tables.RAW_CONTACTS; field in interface:ContactsProvider2.RawContactsBackupQuery 4970 final Cursor cursor = db.query(RawContactsBackupQuery.TABLE, 4984 String TABLE = Tables.DATA; field in interface:ContactsProvider2.DataHashQuery 5039 String TABLE = Tables.AGGREGATION_EXCEPTIONS; field in interface:ContactsProvider2.AggregationExceptionQuery 7813 String TABLE = Views.RAW_CONTACTS; field in interface:ContactsProvider2.LookupBySourceIdQuery 7869 String TABLE = Views.RAW_CONTACTS; field in interface:ContactsProvider2.LookupByRawContactIdQuery 7924 String TABLE = Tables.NAME_LOOKUP_JOIN_RAW_CONTACTS; field in interface:ContactsProvider2.LookupByDisplayNameQuery 9906 String TABLE = Tables.DATA_USAGE_STAT; field in interface:ContactsProvider2.DataUsageStatQuery [all...] |
H A D | ContactsDatabaseHelper.java | 792 public static final String TABLE = Tables.DATA; field in interface:ContactsDatabaseHelper.EmailQuery 808 public static final String TABLE = Tables.DATA; field in interface:ContactsDatabaseHelper.StructuredNameQuery 825 public static final String TABLE = Tables.DATA; field in interface:ContactsDatabaseHelper.NicknameQuery 1141 db.execSQL("CREATE TABLE IF NOT EXISTS " + Tables.PRESENCE + " ("+ 1160 db.execSQL("CREATE TABLE IF NOT EXISTS " 1233 db.execSQL("CREATE TABLE " + Tables.ACCOUNTS + " (" + 1255 db.execSQL("CREATE TABLE " + Tables.CONTACTS + " (" + 1283 db.execSQL("CREATE TABLE " + Tables.RAW_CONTACTS + " (" + 1349 db.execSQL("CREATE TABLE " + Tables.STREAM_ITEMS + " (" + 1365 db.execSQL("CREATE TABLE " [all...] |