Lines Matching refs:store
95 int SqliteOpenHelperProfileCallback::OnCreate(OHOS::NativeRdb::RdbStore &store)
97 store.ExecuteSql(CREATE_CONTACT);
98 store.ExecuteSql(CREATE_CONTACT_INDEX);
99 store.ExecuteSql(CREATE_RAW_CONTACT);
100 store.ExecuteSql(CREATE_RAW_CONTACT_INDEX);
101 store.ExecuteSql(CREATE_CONTACT_DATA);
102 store.ExecuteSql(CREATE_CONTACT_INDEX_DATA1);
103 store.ExecuteSql(CREATE_CONTACT_INDEX_DATA2);
104 store.ExecuteSql(CREATE_CONTACT_BLOCKLIST);
105 store.ExecuteSql(CREATE_LOCAL_LANG);
106 store.ExecuteSql(CREATE_ACCOUNT);
107 store.ExecuteSql(CREATE_PHOTO_FILES);
108 store.ExecuteSql(CREATE_CONTACT_TYPE);
109 store.ExecuteSql(CREATE_GROUPS);
110 store.ExecuteSql(CREATE_DELETED_RAW_CONTACT);
111 store.ExecuteSql(CREATE_SEARCH_CONTACT);
112 store.ExecuteSql(CREATE_SEARCH_CONTACT_INDEX1);
113 store.ExecuteSql(CREATE_SEARCH_CONTACT_INDEX2);
114 store.ExecuteSql(CREATE_SEARCH_CONTACT_VIEW);
115 store.ExecuteSql(MERGE_INFO);
116 store.ExecuteSql(CREATE_VIEW_CONTACT_DATA);
117 store.ExecuteSql(CREATE_VIEW_RAW_CONTACT);
118 store.ExecuteSql(CREATE_VIEW_CONTACT);
119 store.ExecuteSql(CREATE_VIEW_GROUPS);
120 store.ExecuteSql(CREATE_VIEW_DELETED);
121 store.ExecuteSql(INSERT_DELETE_RAW_CONTACT);
122 store.ExecuteSql(UPDATE_RAW_CONTACT_VERSION);
123 store.ExecuteSql(UPDATE_CONTACT_DATA_VERSION);
124 store.ExecuteSql(INSERT_CONTACT_QUICK_SEARCH);
125 store.ExecuteSql(CREATE_DATABASE_BACKUP_TASK);
126 store.ExecuteSql(CREATE_INSERT_BACKUP_TIME);
127 store.ExecuteSql(UPDATE_CONTACT_BY_INSERT_CONTACT_DATA);
128 store.ExecuteSql(UPDATE_CONTACT_BY_DELETE_CONTACT_DATA);
129 store.ExecuteSql(UPDATE_CONTACT_BY_UPDATE_CONTACT_DATA);
130 store.ExecuteSql(MERGE_INFO_INDEX);
134 int SqliteOpenHelperProfileCallback::OnUpgrade(OHOS::NativeRdb::RdbStore &store, int oldVersion, int newVersion)
138 store.ExecuteSql("ALTER TABLE database_backup_task ADD COLUMN sync TEXT");
141 UpgradeToV2(store, oldVersion, newVersion);
143 store.SetVersion(newVersion);
147 void SqliteOpenHelperProfileCallback::UpgradeToV2(OHOS::NativeRdb::RdbStore &store, int oldVersion, int newVersion)
153 store.ExecuteSql("ALTER TABLE raw_contact ADD COLUMN primary_contact INTEGER DEFAULT 0;");
154 store.ExecuteSql("ALTER TABLE raw_contact ADD COLUMN extra1 TEXT;");
155 store.ExecuteSql("ALTER TABLE raw_contact ADD COLUMN extra2 TEXT;");
156 store.ExecuteSql("ALTER TABLE raw_contact ADD COLUMN extra3 TEXT;");
157 store.ExecuteSql("ALTER TABLE raw_contact ADD COLUMN extra4 TEXT;");
159 store.ExecuteSql("ALTER TABLE contact_data ADD COLUMN extend8 TEXT;");
160 store.ExecuteSql("ALTER TABLE contact_data ADD COLUMN extend9 TEXT;");
161 store.ExecuteSql("ALTER TABLE contact_data ADD COLUMN extend10 TEXT;");
162 store.ExecuteSql("ALTER TABLE contact_data ADD COLUMN extend11 TEXT;");
164 store.ExecuteSql("DROP VIEW view_contact;");
165 store.ExecuteSql("DROP VIEW view_contact_data;");
166 store.ExecuteSql("DROP VIEW search_contact_view;");
167 store.ExecuteSql("DROP VIEW view_deleted;");
169 store.ExecuteSql(CREATE_VIEW_CONTACT);
170 store.ExecuteSql(CREATE_VIEW_CONTACT_DATA);
171 store.ExecuteSql(CREATE_SEARCH_CONTACT_VIEW);
172 store.ExecuteSql(CREATE_VIEW_DELETED);
175 int SqliteOpenHelperProfileCallback::OnDowngrade(OHOS::NativeRdb::RdbStore &store, int oldVersion, int newVersion)
179 store.ExecuteSql(
182 store.ExecuteSql(
185 store.ExecuteSql("DROP table database_backup_task");
186 store.ExecuteSql("ALTER table database_backup RENAME TO database_backup_task");
187 store.ExecuteSql(CREATE_INSERT_BACKUP_TIME);
189 int ret = store.SetVersion(newVersion);