Home
last modified time | relevance | path

Searched refs:updateSql (Results 1 – 18 of 18) sorted by relevance

/ohos5.0/foundation/multimedia/ringtone_library/services/ringtone_setting/src/
H A Dringtone_setting_manager.cpp229 string updateSql = "UPDATE ToneFiles SET " + in UpdateShotSetting() local
234 int32_t rdbRet = ringtoneRdb_->ExecuteSql(updateSql); in UpdateShotSetting()
252 string updateSql = "UPDATE ToneFiles SET " + in UpdateRingtoneSetting() local
257 int32_t rdbRet = ringtoneRdb_->ExecuteSql(updateSql); in UpdateRingtoneSetting()
269 string updateSql = "UPDATE ToneFiles SET " + in UpdateNotificationSetting() local
286 string updateSql = "UPDATE ToneFiles SET " + in UpdateAlarmSetting() local
305 string updateSql = {}; in UpdateSettingsByPath() local
340 string updateSql = {}; in UpdateSettingsWithToneId() local
361 if (!updateSql.empty()) { in UpdateSettingsWithToneId()
382 string updateSql = {}; in CleanupSettingFromRdb() local
[all …]
/ohos5.0/foundation/multimedia/media_library/frameworks/innerkitsimpl/medialibrary_data_extension/src/operation/
H A Dphoto_day_month_year_operation.cpp119 std::stringstream updateSql; in UpdatePhotosDate() local
120 updateSql << UPDATE_DAY_MONTH_YEAR; in UpdatePhotosDate()
123 updateSql << ", "; in UpdatePhotosDate()
125 updateSql << needUpdateFileIds[i]; in UpdatePhotosDate()
127 updateSql << " );"; in UpdatePhotosDate()
205 std::stringstream updateSql; in UpdatePhotosDate() local
206 updateSql << UPDATE_DAY_MONTH_YEAR; in UpdatePhotosDate()
209 updateSql << ", "; in UpdatePhotosDate()
211 updateSql << needUpdateFileIds[i]; in UpdatePhotosDate()
213 updateSql << " );"; in UpdatePhotosDate()
[all …]
/ohos5.0/foundation/multimedia/media_library/frameworks/innerkitsimpl/test/unittest/background_cloud_file_processor_test/src/
H A Dbackground_cloud_file_processor_test.cpp137 string updateSql; in PrepareAbnormalPhotos() local
139 updateSql = "update " + PhotoColumn::PHOTOS_TABLE + " set " + column + " = '' "; in PrepareAbnormalPhotos()
141 updateSql = "update " + PhotoColumn::PHOTOS_TABLE + " set " + column + " = 0 "; in PrepareAbnormalPhotos()
143 vector<string> executeSqls = {updateSql}; in PrepareAbnormalPhotos()
/ohos5.0/foundation/distributeddatamgr/kv_store/frameworks/libs/distributeddb/test/unittest/common/interfaces/
H A Ddistributeddb_interfaces_relational_tracker_table_test.cpp1371 std::string updateSql = "update " + TABLE_NAME2 + " set age = 3 where id = ?;"; variable
1372 condition.sql = updateSql;
1439 std::string updateSql = "update " + TABLE_NAME2 + " set name = '3' where _rowid_ <= 5;"; variable
1440 condition.sql = updateSql;
1536 std::string updateSql = "update " + TABLE_NAME2 + " SET age = 100; "; variable
1537 updateSql += "update " + TABLE_NAME2 + " SET age = 50;";
1538 condition.sql = updateSql;
1556 updateSql = "update " + TABLE_NAME2 + " SET age = 88; ";
1557 updateSql += "select * from " + TABLE_NAME2;
1558 condition.sql = updateSql;
H A Ddistributeddb_interfaces_relational_sync_test.cpp505 std::string updateSql = "update student_1 set id = 1002 where name = 'xue';"; variable
506 EXPECT_EQ(RelationalTestUtils::ExecSql(db, updateSql), SQLITE_OK);
H A Ddistributeddb_interfaces_relational_test.cpp1659 std::string updateSql = "UPDATE 'create' SET 'create' = 1002 WHERE b = 'create'"; variable
1660 EXPECT_EQ(RelationalTestUtils::ExecSql(db, updateSql), SQLITE_OK);
/ohos5.0/foundation/multimedia/media_library/frameworks/services/media_backup_extension/src/
H A Dbackup_database_utils.cpp252 const string updateSql = in UpdateUniqueNumber() local
254 int32_t erroCode = BackupDatabaseUtils::ExecuteSQL(rdbStore, updateSql); in UpdateUniqueNumber()
339 std::string updateSql = "UPDATE tab_analysis_total SET face = CASE WHEN EXISTS \ in UpdateAnalysisTotalStatus() local
343 int32_t errCode = BackupDatabaseUtils::ExecuteSQL(rdbStore, updateSql); in UpdateAnalysisTotalStatus()
351 …std::string updateSql = "UPDATE tab_analysis_face_tag SET count = (SELECT count(1) from tab_analys… in UpdateAnalysisFaceTagStatus() local
353 int32_t errCode = BackupDatabaseUtils::ExecuteSQL(rdbStore, updateSql); in UpdateAnalysisFaceTagStatus()
363 std::string updateSql = in UpdateAnalysisTotalTblStatus() local
378 int32_t errCode = BackupDatabaseUtils::ExecuteSQL(rdbStore, updateSql); in UpdateAnalysisTotalTblStatus()
H A Dclone_restore.cpp2273 … std::string updateSql = GenCoverUriUpdateSql(tagIdToCoverInfo, oldToNewFileId, fileInfos, tagIds); in GenNewCoverUris() local
2274 if (updateSql.empty()) { in GenNewCoverUris()
2278 BackupDatabaseUtils::ExecuteSQL(mediaLibraryRdb_, updateSql); in GenNewCoverUris()
2302 std::string updateSql = "UPDATE AnalysisAlbum SET "; in GenCoverUriUpdateSql() local
2304 updateSql += "cover_uri = CASE "; in GenCoverUriUpdateSql()
2306 updateSql += "WHEN tag_id = '" + tagId + "' THEN '" + newUri + "' "; in GenCoverUriUpdateSql()
2308 updateSql += "ELSE cover_uri END"; in GenCoverUriUpdateSql()
2321 updateSql += isCoverSatisfiedSql; in GenCoverUriUpdateSql()
2324 updateSql += "WHERE tag_id IN ('" + in GenCoverUriUpdateSql()
2327 return updateSql; in GenCoverUriUpdateSql()
/ohos5.0/foundation/distributeddatamgr/kv_store/frameworks/libs/distributeddb/test/unittest/common/storage/cloud/
H A Ddistributeddb_cloud_reference_sync_test.cpp895 std::string updateSql = "UPDATE table_a SET name = '99' where id = 1"; variable
896 ASSERT_EQ(RelationalTestUtils::ExecSql(db_, updateSql), SQLITE_OK);
899 updateSql = "UPDATE table_a SET age = '99' where id = 3";
900 ASSERT_EQ(RelationalTestUtils::ExecSql(db_, updateSql), SQLITE_OK);
951 std::string updateSql = "UPDATE table_b SET name = '99' where id = 4"; variable
952 ASSERT_EQ(RelationalTestUtils::ExecSql(db_, updateSql), SQLITE_OK);
955 updateSql = "UPDATE table_b SET age = '99' where id = 7";
956 ASSERT_EQ(RelationalTestUtils::ExecSql(db_, updateSql), SQLITE_OK);
/ohos5.0/foundation/distributeddatamgr/relational_store/test/native/rdb/unittest/
H A Drdb_update_test.cpp627 …std::string updateSql = SqliteSqlBuilder::BuildUpdateString(values, "test", std::vector<std::strin… variable
629 EXPECT_EQ(updateSql, "UPDATE test SET age=?,name=?,salary=? WHERE age = ?");
631updateSql = SqliteSqlBuilder::BuildUpdateString(values, "test", std::vector<std::string>{}, "", ""…
633 EXPECT_EQ(updateSql, "UPDATE test SET age=?,name=?,salary=?");
/ohos5.0/foundation/multimedia/media_library/frameworks/innerkitsimpl/medialibrary_data_extension/src/
H A Dmedialibrary_data_manager.cpp1351 string updateSql; in generateUpdateSql() local
1354updateSql = "UPDATE " + PhotoColumn::PHOTOS_TABLE + " SET " + PhotoColumn::PHOTO_SUBTYPE + " = " + in generateUpdateSql()
1368updateSql = "UPDATE " + PhotoColumn::PHOTOS_TABLE + " AS p1 SET " + PhotoColumn::PHOTO_BURST_KEY + in generateUpdateSql()
1379 return updateSql; in generateUpdateSql()
1411 string updateSql = generateUpdateSql(isCover, title, ownerAlbumId); in UpdateBurstPhoto() local
1412 ret = rdbStore->ExecuteSql(updateSql); in UpdateBurstPhoto()
2150 …string updateSql = "UPDATE " + PhotoColumn::PHOTOS_TABLE + " SET " + MediaColumn::MEDIA_DATE_TAKEN… in UpdateDateTakenWhenZero() local
2154 ret = rdbStore_->ExecuteSql(updateSql); in UpdateDateTakenWhenZero()
H A Dmedialibrary_analysis_album_operations.cpp254 string updateSql = withSql + " UPDATE " + ANALYSIS_ALBUM_TABLE + " SET " + in BuildUpdateGroupPhotoAlbumSql() local
262 return updateSql; in BuildUpdateGroupPhotoAlbumSql()
866 … const string updateSql = "UPDATE " + ANALYSIS_ALBUM_TABLE + " SET " + IS_COVER_SATISFIED + " = " + in UpdatePortraitAlbumCoverSatisfied() local
871 int32_t ret = rdbStore->ExecuteSql(updateSql); in UpdatePortraitAlbumCoverSatisfied()
H A Dmedialibrary_rdbstore.cpp314 const vector<string> updateSql = { in UpdateDateTakenToMillionSecond() local
319 ExecSqls(updateSql, *store->GetRaw().get()); in UpdateDateTakenToMillionSecond()
350 const vector<string> updateSql = { in UpdateDateTakenAndDetalTime() local
354 ExecSqls(updateSql, *store->GetRaw().get()); in UpdateDateTakenAndDetalTime()
2265 const vector<string> updateSql = { in UpdateYearMonthDayData() local
2287 ExecSqls(updateSql, store); in UpdateYearMonthDayData()
2293 const vector<string> updateSql = { in FixIndexOrder() local
2306 ExecSqls(updateSql, store); in FixIndexOrder()
2700 const vector<string> updateSql = { in UpdateMillisecondDate() local
2715 ExecSqls(updateSql, store); in UpdateMillisecondDate()
H A Dmedialibrary_asset_operations.cpp1855 const string updateSql = "UPDATE " + ASSET_UNIQUE_NUMBER_TABLE + " SET " + UNIQUE_NUMBER + in CreateAssetUniqueId() local
1867 errCode = rdbStore->ExecuteSql(updateSql); in CreateAssetUniqueId()
1869 errCode = trans->ExecuteSql(updateSql); in CreateAssetUniqueId()
/ohos5.0/foundation/distributeddatamgr/kv_store/frameworks/libs/distributeddb/storage/src/sqlite/relational/
H A Dsqlite_single_ver_relational_storage_executor_extend.cpp899 std::string &updateSql) in GetUpdateSqlForCloudSync() argument
911 updateSql = sql; in GetUpdateSqlForCloudSync()
939 std::string updateSql; in GetUpdateDataTableStatement() local
940 errCode = GetUpdateSqlForCloudSync(updateFields, tableSchema, gidStr, pkSet, updateSql); in GetUpdateDataTableStatement()
945 errCode = SQLiteUtils::GetStatement(dbHandle_, updateSql, updateStmt); in GetUpdateDataTableStatement()
H A Dsqlite_single_ver_relational_storage_executor.h342 const std::string &gidStr, const std::set<std::string> &pkSet, std::string &updateSql);
/ohos5.0/foundation/distributeddatamgr/kv_store/frameworks/libs/distributeddb/storage/src/sqlite/
H A Dsqlite_single_ver_storage_executor.cpp1140 const std::string &updateSql, SaveRecordStatements &statements) const in PrepareForSavingData() argument
1154 errCode = SQLiteUtils::GetStatement(dbHandle_, updateSql, statements.updateStatement); in PrepareForSavingData()
1908 const std::string updateSql = "UPDATE local_data SET timestamp="; in UpdateLocalDataTimestamp() local
1909 std::string sql = updateSql + std::to_string(timestamp) + " WHERE timestamp=0;"; in UpdateLocalDataTimestamp()
H A Dsqlite_single_ver_storage_executor.h264 const std::string &updateSql, SaveRecordStatements &statements) const;