Lines Matching refs:insert
220 * This is used for simulating an import failure. Insert a row into the "settings"
252 String INSERT_SQL = "INSERT INTO " + Tables.GROUPS + "(" +
276 SQLiteStatement insert = mTargetDb.compileStatement(GroupsInsert.INSERT_SQL);
281 insertGroup(c, insert);
285 insert.close();
289 private void insertGroup(Cursor c, SQLiteStatement insert) {
292 insert.bindLong(GroupsInsert.ID, id);
293 bindString(insert, GroupsInsert.TITLE, c.getString(GroupsQuery.NAME));
294 bindString(insert, GroupsInsert.NOTES, c.getString(GroupsQuery.NOTES));
295 bindString(insert, GroupsInsert.SYSTEM_ID, c.getString(GroupsQuery.SYSTEM_ID));
296 insert.bindLong(GroupsInsert.DIRTY, c.getLong(GroupsQuery._SYNC_DIRTY));
297 insert.bindLong(GroupsInsert.GROUP_VISIBLE, 1);
301 bindString(insert, GroupsInsert.ACCOUNT_NAME, account);
302 bindString(insert, GroupsInsert.ACCOUNT_TYPE, DEFAULT_ACCOUNT_TYPE);
303 bindString(insert, GroupsInsert.SOURCE_ID, c.getString(GroupsQuery._SYNC_ID));
305 insert.bindNull(GroupsInsert.ACCOUNT_NAME);
306 insert.bindNull(GroupsInsert.ACCOUNT_TYPE);
307 insert.bindNull(GroupsInsert.SOURCE_ID);
309 insert(insert);
388 String INSERT_SQL = "INSERT INTO " + Tables.RAW_CONTACTS + "(" +
424 String INSERT_SQL = "INSERT
446 String INSERT_SQL = "INSERT INTO " + Tables.DATA + "(" +
478 String INSERT_SQL = "INSERT INTO " + Tables.DATA + "(" +
536 private long insertRawContact(Cursor c, SQLiteStatement insert) {
538 insert.bindLong(RawContactsInsert.ID, id);
539 insert.bindLong(RawContactsInsert.CONTACT_ID, id);
540 bindString(insert, RawContactsInsert.CUSTOM_RINGTONE,
542 bindString(insert, RawContactsInsert.DIRTY,
544 insert.bindLong(RawContactsInsert.LAST_TIME_CONTACTED,
546 insert.bindLong(RawContactsInsert.SEND_TO_VOICEMAIL,
548 insert.bindLong(RawContactsInsert.STARRED,
550 insert.bindLong(RawContactsInsert.TIMES_CONTACTED,
552 bindString(insert, RawContactsInsert.SYNC1,
554 bindString(insert, RawContactsInsert.SYNC2,
556 bindString(insert, RawContactsInsert.DISPLAY_NAME,
558 insert.bindLong(RawContactsInsert.CONTACT_IN_VISIBLE_GROUP, 1);
562 bindString(insert, RawContactsInsert.ACCOUNT_NAME, account);
563 bindString(insert, RawContactsInsert.ACCOUNT_TYPE, DEFAULT_ACCOUNT_TYPE);
564 bindString(insert, RawContactsInsert.SOURCE_ID, c.getString(PeopleQuery._SYNC_ID));
566 insert.bindNull(RawContactsInsert.ACCOUNT_NAME);
567 insert.bindNull(RawContactsInsert.ACCOUNT_TYPE);
568 insert.bindNull(RawContactsInsert.SOURCE_ID);
570 insert(insert);
574 private void insertContact(Cursor c, SQLiteStatement insert) {
576 insert.bindLong(ContactsInsert.ID, id);
577 bindString(insert, ContactsInsert.CUSTOM_RINGTONE,
579 insert.bindLong(ContactsInsert.LAST_TIME_CONTACTED,
581 insert.bindLong(ContactsInsert.SEND_TO_VOICEMAIL,
583 insert.bindLong(ContactsInsert.STARRED,
585 insert.bindLong(ContactsInsert.TIMES_CONTACTED,
587 insert.bindLong(ContactsInsert.NAME_RAW_CONTACT_ID, id);
588 insert.bindLong(ContactsInsert.IN_VISIBLE_GROUP, 1);
590 insert(insert);
593 private void insertStructuredName(Cursor c, SQLiteStatement insert) {
601 insert.bindLong(StructuredNameInsert.RAW_CONTACT_ID, id);
602 insert.bindLong(StructuredNameInsert.MIMETYPE_ID, mStructuredNameMimetypeId);
603 bindString(insert, StructuredNameInsert.DISPLAY_NAME, name);
608 bindString(insert, StructuredNameInsert.PREFIX,
610 bindString(insert, StructuredNameInsert.GIVEN_NAME,
612 bindString(insert, StructuredNameInsert.MIDDLE_NAME,
614 bindString(insert, StructuredNameInsert.FAMILY_NAME,
616 bindString(insert, StructuredNameInsert.SUFFIX,
619 bindString(insert, StructuredNameInsert.DISPLAY_NAME, joined);
637 insert.bindLong(StructuredNameInsert.FULL_NAME_STYLE,
639 bindString(insert, StructuredNameInsert.PHONETIC_FAMILY_NAME,
641 bindString(insert, StructuredNameInsert.PHONETIC_MIDDLE_NAME,
643 bindString(insert, StructuredNameInsert.PHONETIC_GIVEN_NAME,
645 insert.bindLong(StructuredNameInsert.PHONETIC_NAME_STYLE,
648 long dataId = insert(insert);
662 private void insertNote(Cursor c, SQLiteStatement insert) {
670 insert.bindLong(NoteInsert.RAW_CONTACT_ID, id);
671 insert.bindLong(NoteInsert.MIMETYPE_ID, mNoteMimetypeId);
672 bindString(insert, NoteInsert.NOTE, notes);
673 insert(insert);
692 String INSERT_SQL = "INSERT INTO " + Tables.DATA + "(" +
714 SQLiteStatement insert = mTargetDb.compileStatement(OrganizationInsert.INSERT_SQL);
719 insertOrganization(c, insert);
723 insert.close();
727 private void insertOrganization(Cursor c, SQLiteStatement insert) {
729 insert.bindLong(OrganizationInsert.RAW_CONTACT_ID, id);
730 insert.bindLong(OrganizationInsert.MIMETYPE_ID, mOrganizationMimetypeId);
731 bindString(insert, OrganizationInsert.IS_PRIMARY, c.getString(OrganizationsQuery.ISPRIMARY));
732 bindString(insert, OrganizationInsert.IS_SUPER_PRIMARY,
734 bindString(insert, OrganizationInsert.COMPANY, c.getString(OrganizationsQuery.COMPANY));
735 bindString(insert, OrganizationInsert.TITLE, c.getString(OrganizationsQuery.TITLE));
736 bindString(insert, OrganizationInsert.TYPE, c.getString(OrganizationsQuery.TYPE));
737 bindString(insert, OrganizationInsert.LABEL, c.getString(OrganizationsQuery.LABEL));
738 insert(insert);
758 String INSERT_SQL = "INSERT INTO " + Tables.DATA + "(" +
780 String INSERT_SQL = "INSERT INTO " + Tables.DATA + "(" +
802 String INSERT_SQL = "INSERT INTO " + Tables.DATA + "(" +
855 private void insertEmail(Cursor c, SQLiteStatement insert) {
859 insert.bindLong(EmailInsert.RAW_CONTACT_ID, personId);
860 insert.bindLong(EmailInsert.MIMETYPE_ID, mEmailMimetypeId);
861 bindString(insert, EmailInsert.IS_PRIMARY, c.getString(ContactMethodsQuery.ISPRIMARY));
862 bindString(insert, EmailInsert.IS_SUPER_PRIMARY, c.getString(ContactMethodsQuery.ISPRIMARY));
863 bindString(insert, EmailInsert.DATA, email);
864 bindString(insert, EmailInsert.AUX_DATA, c.getString(ContactMethodsQuery.AUX_DATA));
865 bindString(insert, EmailInsert.TYPE, c.getString(ContactMethodsQuery.TYPE));
866 bindString(insert, EmailInsert.LABEL, c.getString(ContactMethodsQuery.LABEL));
868 long dataId = insert(insert);
872 private void insertIm(Cursor c, SQLiteStatement insert) {
875 insert.bindLong(ImInsert.RAW_CONTACT_ID, personId);
876 insert.bindLong(ImInsert.MIMETYPE_ID, mImMimetypeId);
877 bindString(insert, ImInsert.IS_PRIMARY, c.getString(ContactMethodsQuery.ISPRIMARY));
878 bindString(insert, ImInsert.IS_SUPER_PRIMARY, c.getString(ContactMethodsQuery.ISPRIMARY));
879 bindString(insert, ImInsert.DATA, c.getString(ContactMethodsQuery.DATA));
880 bindString(insert, ImInsert.AUX_DATA, c.getString(ContactMethodsQuery.AUX_DATA));
881 bindString(insert, ImInsert.TYPE, c.getString(ContactMethodsQuery.TYPE));
882 bindString(insert, ImInsert.LABEL, c.getString(ContactMethodsQuery.LABEL));
883 insert(insert);
886 private void insertPostal(Cursor c, SQLiteStatement insert) {
889 insert.bindLong(PostalInsert.RAW_CONTACT_ID, personId);
890 insert.bindLong(PostalInsert.MIMETYPE_ID, mPostalMimetypeId);
891 bindString(insert, PostalInsert.IS_PRIMARY, c.getString(ContactMethodsQuery.ISPRIMARY));
892 bindString(insert, PostalInsert.IS_SUPER_PRIMARY,
894 bindString(insert, PostalInsert.DATA, c.getString(ContactMethodsQuery.DATA));
895 bindString(insert, PostalInsert.AUX_DATA, c.getString(ContactMethodsQuery.AUX_DATA));
896 bindString(insert, PostalInsert.TYPE, c.getString(ContactMethodsQuery.TYPE));
897 bindString(insert, PostalInsert.LABEL, c.getString(ContactMethodsQuery.LABEL));
898 insert(insert);
916 String INSERT_SQL = "INSERT INTO " + Tables.DATA + "(" +
938 String INSERT_SQL = "INSERT INTO " + Tables.PHONE_LOOKUP + "(" +
996 long dataId = insert(phoneInsert);
1003 insert(phoneLookupInsert);
1027 String INSERT_SQL = "INSERT INTO " + Tables.DATA + "(" +
1049 SQLiteStatement insert = mTargetDb.compileStatement(PhotoInsert.INSERT_SQL);
1055 insertPhoto(c, insert, photoIdUpdate);
1059 insert.close();
1064 private void insertPhoto(Cursor c, SQLiteStatement insert, SQLiteStatement photoIdUpdate) {
1071 insert.bindLong(PhotoInsert.RAW_CONTACT_ID, personId);
1072 insert.bindLong(PhotoInsert.MIMETYPE_ID, mPhotoMimetypeId);
1073 insert.bindBlob(PhotoInsert.PHOTO, c.getBlob(PhotosQuery.DATA));
1077 bindString(insert, PhotoInsert.SYNC1, c.getString(PhotosQuery._SYNC_ID));
1079 insert.bindNull(PhotoInsert.SYNC1);
1082 long rowId = insert(insert);
1102 String INSERT_SQL = "INSERT INTO " + Tables.DATA + "(" +
1114 SQLiteStatement insert = mTargetDb.compileStatement(GroupMembershipInsert.INSERT_SQL);
1119 insertGroupMembership(c, insert);
1123 insert.close();
1127 private void insertGroupMembership(Cursor c, SQLiteStatement insert) {
1153 groupId = mTargetDb.insert(Tables.GROUPS, null, values);
1160 insert.bindLong(GroupMembershipInsert.RAW_CONTACT_ID, personId);
1161 insert.bindLong(GroupMembershipInsert.MIMETYPE_ID, mGroupMembershipMimetypeId);
1162 insert.bindLong(GroupMembershipInsert.GROUP_ROW_ID, groupId);
1163 insert(insert);
1213 mResolver.insert(Calls.CONTENT_URI, mValues);
1243 String INSERT_SQL = "INSERT INTO " + Tables.RAW_CONTACTS + "(" +
1260 SQLiteStatement insert = mTargetDb.compileStatement(DeletedRawContactInsert.INSERT_SQL);
1265 insert);
1269 insert.close();
1273 private void insertDeletedPerson(Cursor c, SQLiteStatement insert) {
1279 insert.bindString(DeletedRawContactInsert.ACCOUNT_NAME, account);
1280 insert.bindString(DeletedRawContactInsert.ACCOUNT_TYPE, DEFAULT_ACCOUNT_TYPE);
1281 bindString(insert, DeletedRawContactInsert.SOURCE_ID,
1283 insert.bindLong(DeletedRawContactInsert.DELETED, 1);
1284 insert.bindLong(DeletedRawContactInsert.AGGREGATION_MODE,
1286 insert(insert);
1289 private void bindString(SQLiteStatement insert, int index, String string) {
1291 insert.bindNull(index);
1293 insert.bindString(index, string);
1297 private long insert(SQLiteStatement insertStatement) {
1300 throw new RuntimeException("Insert failed");
