Home
last modified time | relevance | path

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

/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
274 int32_t rdbRet = ringtoneRdb_->ExecuteSql(updateSql); in UpdateNotificationSetting()
286 string updateSql = "UPDATE ToneFiles SET " + in UpdateAlarmSetting() local
291 int32_t rdbRet = ringtoneRdb_->ExecuteSql(updateSql); in UpdateAlarmSetting()
305 string updateSql = {}; in UpdateSettingsByPath()
335 string updateSql in UpdateSettingsWithToneId() local
382 string updateSql = {}; CleanupSettingFromRdb() local
[all...]
/foundation/multimedia/media_library/frameworks/innerkitsimpl/test/unittest/background_cloud_file_processor_test/src/
H A Dbackground_cloud_file_processor_test.cpp145 string updateSql; in PrepareAbnormalPhotos() local
147 updateSql = "update " + PhotoColumn::PHOTOS_TABLE + " set " + column + " = '' "; in PrepareAbnormalPhotos()
149 updateSql = "update " + PhotoColumn::PHOTOS_TABLE + " set " + column + " = 0 "; in PrepareAbnormalPhotos()
151 vector<string> executeSqls = {updateSql}; in PrepareAbnormalPhotos()
/foundation/multimedia/media_library/frameworks/services/media_backup_extension/src/
H A Dbackup_database_utils.cpp311 const string updateSql = in UpdateUniqueNumber() local
313 int32_t erroCode = rdbStore->ExecuteSql(updateSql); in UpdateUniqueNumber()
416 std::string updateSql = "UPDATE tab_analysis_total SET face = CASE WHEN EXISTS \ in UpdateAnalysisTotalStatus() local
420 int32_t errCode = rdbStore->ExecuteSql(updateSql); in UpdateAnalysisTotalStatus()
428 std::string updateSql = "UPDATE tab_analysis_face_tag SET count = (SELECT count(1) from tab_analysis_image_face \ in UpdateAnalysisFaceTagStatus() local
430 int32_t errCode = rdbStore->ExecuteSql(updateSql); in UpdateAnalysisFaceTagStatus()
440 std::string updateSql = in UpdateAnalysisTotalTblStatus() local
455 int32_t errCode = rdbStore->ExecuteSql(updateSql); in UpdateAnalysisTotalTblStatus()
H A Dclone_restore.cpp2090 std::string updateSql = GenCoverUriUpdateSql(tagIdToCoverInfo, oldToNewFileId, fileInfos, tagIds); in GenNewCoverUris() local
2091 if (updateSql.empty()) { in GenNewCoverUris()
2095 BackupDatabaseUtils::ExecuteSQL(mediaLibraryRdb_, updateSql); in GenNewCoverUris()
2119 std::string updateSql = "UPDATE AnalysisAlbum SET "; in GenCoverUriUpdateSql() local
2121 updateSql += "cover_uri = CASE "; in GenCoverUriUpdateSql()
2123 updateSql += "WHEN tag_id = '" + tagId + "' THEN '" + newUri + "' "; in GenCoverUriUpdateSql()
2125 updateSql += "ELSE cover_uri END"; in GenCoverUriUpdateSql()
2138 updateSql += isCoverSatisfiedSql; in GenCoverUriUpdateSql()
2141 updateSql += "WHERE tag_id IN ('" + in GenCoverUriUpdateSql()
2144 return updateSql; in GenCoverUriUpdateSql()
[all...]
/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"; in HWTEST_F() local
896 ASSERT_EQ(RelationalTestUtils::ExecSql(db_, updateSql), SQLITE_OK); in HWTEST_F()
899 updateSql = "UPDATE table_a SET age = '99' where id = 3"; in HWTEST_F()
900 ASSERT_EQ(RelationalTestUtils::ExecSql(db_, updateSql), SQLITE_OK); in HWTEST_F()
951 std::string updateSql = "UPDATE table_b SET name = '99' where id = 4"; in HWTEST_F() local
952 ASSERT_EQ(RelationalTestUtils::ExecSql(db_, updateSql), SQLITE_OK); in HWTEST_F()
955 updateSql = "UPDATE table_b SET age = '99' where id = 7"; in HWTEST_F()
956 ASSERT_EQ(RelationalTestUtils::ExecSql(db_, updateSql), SQLITE_OK); in HWTEST_F()
/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 = ?;"; in HWTEST_F() local
1372 condition.sql = updateSql; in HWTEST_F()
1439 std::string updateSql = "update " + TABLE_NAME2 + " set name = '3' where _rowid_ <= 5;"; in HWTEST_F() local
1440 condition.sql = updateSql; in HWTEST_F()
1536 std::string updateSql = "update " + TABLE_NAME2 + " SET age = 100; "; in HWTEST_F() local
1537 updateSql += "update " + TABLE_NAME2 + " SET age = 50;"; in HWTEST_F()
1538 condition.sql = updateSql; in HWTEST_F()
1556 updateSql = "update " + TABLE_NAME2 + " SET age = 88; "; in HWTEST_F()
1557 updateSql += "select * from " + TABLE_NAME2; in HWTEST_F()
1558 condition.sql = updateSql; in HWTEST_F()
[all...]
H A Ddistributeddb_interfaces_relational_test.cpp1659 std::string updateSql = "UPDATE 'create' SET 'create' = 1002 WHERE b = 'create'"; in HWTEST_F() local
1660 EXPECT_EQ(RelationalTestUtils::ExecSql(db, updateSql), SQLITE_OK); in HWTEST_F()
H A Ddistributeddb_interfaces_relational_sync_test.cpp505 std::string updateSql = "update student_1 set id = 1002 where name = 'xue';"; in HWTEST_F() local
506 EXPECT_EQ(RelationalTestUtils::ExecSql(db, updateSql), SQLITE_OK); in HWTEST_F()
/foundation/multimedia/media_library/frameworks/innerkitsimpl/medialibrary_data_extension/src/
H A Dmedialibrary_analysis_album_operations.cpp255 string updateSql = withSql + " UPDATE " + ANALYSIS_ALBUM_TABLE + " SET " + in BuildUpdateGroupPhotoAlbumSql() local
263 return updateSql; in BuildUpdateGroupPhotoAlbumSql()
856 const string updateSql = "UPDATE " + ANALYSIS_ALBUM_TABLE + " SET " + IS_COVER_SATISFIED + " = " + in UpdatePortraitAlbumCoverSatisfied() local
867 int32_t ret = rdbStorePtr->ExecuteSql(updateSql); in UpdatePortraitAlbumCoverSatisfied()
H A Dmedialibrary_data_manager.cpp1300 string updateSql; in generateUpdateSql() local
1303 updateSql = "UPDATE " + PhotoColumn::PHOTOS_TABLE + " SET " + PhotoColumn::PHOTO_SUBTYPE + " = " + in generateUpdateSql()
1317 updateSql = "UPDATE " + PhotoColumn::PHOTOS_TABLE + " AS p1 SET " + PhotoColumn::PHOTO_BURST_KEY + in generateUpdateSql()
1328 return updateSql; in generateUpdateSql()
1360 string updateSql = generateUpdateSql(isCover, title, ownerAlbumId); in UpdateBurstPhoto() local
1361 ret = rdbStore->ExecuteSql(updateSql); in UpdateBurstPhoto()
H A Dmedialibrary_rdbstore.cpp516 const vector<string> updateSql = { in UpdateDateTakenToMillionSecond() local
521 ExecSqls(updateSql, store); in UpdateDateTakenToMillionSecond()
2456 const vector<string> updateSql = { in UpdateYearMonthDayData() local
2478 ExecSqls(updateSql, store); in UpdateYearMonthDayData()
2484 const vector<string> updateSql = { in FixIndexOrder() local
2497 ExecSqls(updateSql, store); in FixIndexOrder()
2897 const vector<string> updateSql = { in UpdateMillisecondDate() local
2912 ExecSqls(updateSql, store); in UpdateMillisecondDate()
H A Dmedialibrary_asset_operations.cpp2021 const string updateSql = "UPDATE " + ASSET_UNIQUE_NUMBER_TABLE + " SET " + UNIQUE_NUMBER + in CreateAssetUniqueId() local
2031 int32_t errCode = rdbStore->ExecuteSql(updateSql); in CreateAssetUniqueId()
/foundation/distributeddatamgr/relational_store/test/native/rdb/unittest/
H A Drdb_update_test.cpp788 std::string updateSql = SqliteSqlBuilder::BuildUpdateString(values, "test", std::vector<std::string>{ "19" }, "", in HWTEST_F() local
790 EXPECT_EQ(updateSql, "UPDATE test SET age=?,name=?,salary=? WHERE age = ?"); in HWTEST_F()
792 updateSql = SqliteSqlBuilder::BuildUpdateString(values, "test", std::vector<std::string>{}, "", "", "", "", in HWTEST_F()
794 EXPECT_EQ(updateSql, "UPDATE test SET age=?,name=?,salary=?"); in HWTEST_F()
/foundation/distributeddatamgr/kv_store/frameworks/libs/distributeddb/storage/src/sqlite/relational/
H A Dsqlite_single_ver_relational_storage_executor_extend.cpp900 std::string &updateSql) in GetUpdateSqlForCloudSync()
912 updateSql = sql; in GetUpdateSqlForCloudSync()
940 std::string updateSql; in GetUpdateDataTableStatement() local
941 errCode = GetUpdateSqlForCloudSync(updateFields, tableSchema, gidStr, pkSet, updateSql); in GetUpdateDataTableStatement()
946 errCode = SQLiteUtils::GetStatement(dbHandle_, updateSql, updateStmt); in GetUpdateDataTableStatement()
898 GetUpdateSqlForCloudSync(const std::vector<Field> &updateFields, const TableSchema &tableSchema, const std::string &gidStr, const std::set<std::string> &pkSet, std::string &updateSql) GetUpdateSqlForCloudSync() argument
H A Dsqlite_single_ver_relational_storage_executor.h342 const std::string &gidStr, const std::set<std::string> &pkSet, std::string &updateSql);
/foundation/distributeddatamgr/kv_store/frameworks/libs/distributeddb/storage/src/sqlite/
H A Dsqlite_single_ver_storage_executor.h277 const std::string &updateSql, SaveRecordStatements &statements) const;
H A Dsqlite_single_ver_storage_executor.cpp1140 const std::string &updateSql, SaveRecordStatements &statements) const in PrepareForSavingData()
1154 errCode = SQLiteUtils::GetStatement(dbHandle_, updateSql, statements.updateStatement); in PrepareForSavingData()
1169 // currently, Local type has not been optimized, so pass updateSql parameter with INSERT_LOCAL_SQL in PrepareForSavingData()
1907 const std::string updateSql = "UPDATE local_data SET timestamp="; in UpdateLocalDataTimestamp() local
1908 std::string sql = updateSql + std::to_string(timestamp) + " WHERE timestamp=0;"; in UpdateLocalDataTimestamp()
1139 PrepareForSavingData(const std::string &readSql, const std::string &insertSql, const std::string &updateSql, SaveRecordStatements &statements) const PrepareForSavingData() argument
/foundation/distributeddatamgr/relational_store/test/native/relational_store_test/unittest/
H A Drelational_store_test.cpp1919 std::string updateSql = SqliteSqlBuilder::BuildUpdateString(values, "test", std::vector<std::string>{ "19" }, "", in HWTEST_F() local
1921 EXPECT_EQ(updateSql, "UPDATE test SET age=?,name=?,salary=? WHERE age = ?"); in HWTEST_F()
1923 updateSql = SqliteSqlBuilder::BuildUpdateString(values, "test", std::vector<std::string>{}, "", "", "", "", in HWTEST_F()
1925 EXPECT_EQ(updateSql, "UPDATE test SET age=?,name=?,salary=?"); in HWTEST_F()

Completed in 41 milliseconds