Home
last modified time | relevance | path

Searched defs:sql (Results 1 – 25 of 220) sorted by relevance

123456789

/ohos5.0/foundation/multimedia/media_library/frameworks/services/media_backup_extension/src/restore/
H A Dgallery_db_upgrade.cpp61 std::string sql = this->SQL_GALLERY_MEDIA_TABLE_ADD_PHOTO_QUALITY; in AddPhotoQualityOfGalleryMedia() local
81 std::string sql = this->SQL_GALLERY_ALBUM_TABLE_ADD_RELATIVE_BUCKET_ID; in AddRelativeBucketIdOfGalleryAlbum() local
105 std::string sql = this->SQL_GARBAGE_ALBUM_TABLE_ADD_RELATIVE_BUCKET_ID; in GarbageAlbumCheckOrAddRelativeBucketId() local
121 std::string sql = this->SQL_GARBAGE_ALBUM_TABLE_ADD_TYPE; in GarbageAlbumCheckOrAddType() local
133 std::string sql = this->SQL_GALLERY_ALBUM_INDEX_RELATIVE_BUCKET_ID; in AddIndexOfGalleryAlbum() local
146 std::string sql = this->SQL_ALBUM_PLUGIN_INDEX_ALBUM_NAME; in AddIndexOfAlbumPlugin() local
/ohos5.0/foundation/distributeddatamgr/kv_store/frameworks/libs/distributeddb/test/unittest/common/storage/
H A Ddistributeddb_relational_encrypted_db_test.cpp85 void ExecSqlAndAssertOK(sqlite3 *db, const std::string &sql) in ExecSqlAndAssertOK()
161 string sql = variable
195 string sql = variable
229 string sql = variable
287 string sql = variable
331 string sql = variable
389 string sql = variable
409 std::string sql = "PARGMA rekey=" + REKEY_KEY; in __anon259049c50202() local
465 string sql = variable
525 string sql = variable
[all …]
H A Ddistributeddb_relational_get_data_test.cpp63 const string sql = in CreateDBAndTable() local
80 const string sql = in AddOrUpdateRecord() local
93 const string sql = "SELECT timestamp, flag \ in GetLogData() local
153 int GetCount(sqlite3 *db, const string &sql, size_t &count) in GetCount()
169 void ExpectCount(sqlite3 *db, const string &sql, size_t expectCount) in ExpectCount()
176 std::string GetOneText(sqlite3 *db, const string &sql) in GetOneText()
196 const string sql = "INSERT INTO " + g_tableName + " VALUES(?,?);"; in PutBatchData() local
231 void ExecSqlAndAssertOK(sqlite3 *db, const std::string &sql) in ExecSqlAndAssertOK()
238 for (const auto &sql : sqlList) { in ExecSqlAndAssertOK() local
1104 std::string sql = "INSERT INTO " + g_tableName + " VALUES(1, 101);"; // k1v101 variable
[all …]
H A Ddistributeddb_sqlite_relational_utils_test.cpp91 void DistributedDBSqliteRelationalUtilsTest::PrepareStatement(const std::string &sql, sqlite3_stmt … in PrepareStatement()
171 …std::string sql = "INSERT OR REPLACE INTO worker1(id, name, height, married, photo, asset, assets)… variable
200 …std::string sql = "INSERT OR REPLACE INTO worker1(id, name, height, married, photo, asset, assets)… variable
/ohos5.0/foundation/communication/netmanager_base/services/netstatsmanager/src/
H A Dnet_stats_database_helper.cpp71 int32_t NetStatsDatabaseHelper::ExecSql(const std::string &sql, void *recv, SqlCallback callback) in ExecSql()
85 std::string sql = "CREATE TABLE IF NOT EXISTS " + tableName + "(" + tableInfo + ");"; in CreateTable() local
145 …std::string sql = "SELECT * FROM " + tableName + " t WHERE 1=1 AND t.Date >= ?" + " AND t.Date <= … in SelectData() local
193 std::string sql = "SELECT * FROM " + std::string(IFACE_TABLE) + " t WHERE 1=1 AND t.IFace = ?" + in SelectData() local
246 std::string sql = in QueryData() local
297 std::string sql = in DeleteData() local
304 std::string sql = "DELETE FROM " + tableName + " WHERE UID = ?"; in DeleteData() local
329 std::string sql = "DELETE FROM " + tableName; in ClearData() local
450 … std::string sql = "ALTER TABLE " + tableName + " ADD COLUMN Flag INTEGER NOT NULL DEFAULT 0;"; in ExecTableUpgrade() local
472 std::string sql = "SELECT * FROM " + std::string(VERSION_TABLE) + " WHERE Name = ?;"; in GetTableVersion() local
[all …]
/ohos5.0/base/hiviewdfx/hiview/base/utility/
H A Dsql_util.cpp23 std::string sql; in GenerateCreateSql() local
40 std::string sql = "SELECT name FROM sqlite_sequence WHERE name = '" + table + "'"; in GenerateExistSql() local
46 std::string sql; in GenerateDropSql() local
/ohos5.0/foundation/distributeddatamgr/kv_store/frameworks/libs/distributeddb/storage/src/sqlite/
H A Dsqlite_query_helper.cpp92 std::string sql = "SELECT b.data_key," in GetSelectAndFromClauseForRDB() local
437 std::string sql; in GetQuerySqlStatement() local
589 std::string sql; in GetQuerySyncStatement() local
663 std::string sql; in MapKeywordSymbolToSql() local
971 std::string sql; in GetRelationalMissQueryStatement() local
991 std::string sql = "SELECT b.data_key," in GetRelationalSyncDataQueryHeader() local
1011 std::string sql = "SELECT b.data_key," in GetRelationalCloudSyncDataQueryHeader() local
1034 std::string &sql) in GetRelationalSyncDataQuerySqlWithLimit()
1065 std::string sql; in GetRelationalQueryStatement() local
1164 std::string sql = "SELECT COUNT(*) "; in GetCountRelationalCloudQuerySql() local
[all …]
H A Dsqlite_single_ver_storage_executor_cache.cpp102 std::string sql = (executorState_ == ExecutorState::MAIN_ATTACH_CACHE) ? in RemoveDeviceDataInCacheMode() local
129 std::string sql; in GetMinVersionCacheData() local
161 std::string sql; in MigrateRmDevData() local
230 std::string sql; in GetMaxVersionInCacheDb() local
310 std::string sql; in CheckDataWithQuery() local
428 std::string sql; in DelCacheDbDataByVersion() local
462 std::string sql; in VacuumLocalData() local
600 std::string sql; in GetExpandedCheckSql() local
785 std::string sql = ((executorState_ == ExecutorState::CACHE_ATTACH_MAIN) ? in GetMinTimestampInCacheDB() local
943 const std::string sql = attachMetaMode_ ? REMOVE_ATTACH_META_VALUE_SQL : REMOVE_META_VALUE_SQL; in DeleteMetaData() local
[all …]
/ohos5.0/base/security/access_token/services/accesstokenmanager/main/cpp/src/database/
H A Daccess_token_open_callback.cpp43 std::string sql = "create table if not exists " + tableName; in CreateHapTokenInfoTable() local
81 std::string sql = "create table if not exists " + tableName; in CreateNativeTokenInfoTable() local
109 std::string sql = "create table if not exists " + tableName; in CreatePermissionDefinitionTable() local
149 std::string sql = "create table if not exists " + tableName; in CreatePermissionStateTable() local
179 std::string sql = "create table if not exists " + tableName; in CreatePermissionRequestToggleStatusTable() local
265 std::string sql = "alter table " + tableName + " add column " + in AddAvailableTypeColumn() local
291 std::string sql = "alter table " + tableName + " add column " + in AddRequestToggleStatusColumn() local
317 std::string sql = "alter table " + tableName + " add column " + in AddPermDialogCapColumn() local
/ohos5.0/foundation/distributeddatamgr/datamgr_service/services/distributeddataservice/service/test/
H A Drdb_query_test.cpp54 std::string sql = "SELECT * FROM table"; variable
79 std::string sql = "SELECT * FROM table"; variable
107 std::string sql = "SELECT * FROM table"; variable
145 std::string sql = "SELECT * FROM table"; variable
/ohos5.0/foundation/distributeddatamgr/kv_store/frameworks/libs/distributeddb/test/unittest/common/interfaces/
H A Ddistributeddb_cloud_interfaces_reference_test.cpp313 …std::string sql = "create table " + sourceTableName + "(id int);create table " + targetTableName +… variable
343 …std::string sql = "create table " + sourceTableName + "(id int);create table " + targetTableName +… variable
380 …std::string sql = "create table " + sourceTableName + "(id int);create table " + targetTableName +… variable
409 …std::string sql = "select value from " + DBConstant::RELATIONAL_PREFIX + "metadata where key = ?;"; in CheckResult() local
434 …std::string sql = "create table " + sourceTableName + "(id int);create table " + targetTableName +… in NormalSetReferenceTest() local
511 std::string sql = "create table " + sourceTableName + "(id int, value text);create table " + in ReferenceChangeTest() local
606 std::string sql = "create table " + sourceTableName + "(id int, value text);create table " + variable
682 …std::string sql = "create table " + sourceTableName + "(id int, value text, name text);create tabl… variable
768 …std::string sql = "create table " + sourceTableName + "(id int, value text, name text);create tabl… variable
813 … std::string sql = "create table t1(id int, value text);create table t2(id int, value text);" \ variable
[all …]
H A Ddistributeddb_cloud_interfaces_relational_ext_test.cpp188 const std::string sql = "select get_raw_sys_time();"; variable
212 std::string sql; in PrepareData() local
259 std::string sql = "insert into " + tableName + " VALUES(2, 1, 'zhangsan');"; in InsertTriggerTest() local
346 std::string sql = "insert into " + tableName + " VALUES(2, 1, 'zhangsan1');"; variable
399 std::string sql = "insert into " + tableName + " VALUES(2, 1, 'zhangsan');"; in UpdateTriggerTest() local
497 std::string sql = "insert into " + tableName + " VALUES(2, 1, 'zhangsan');"; variable
723 std::string sql; variable
786 std::string sql = "begin;"; variable
1403 std::string sql = "update " + DBCommon::GetLogTableName(tableName) + " SET status=0"; variable
1436 std::string sql = "update " + tableName + " SET name='1' where id in (1,11,21,31)"; variable
[all …]
H A Ddistributeddb_cloud_interfaces_set_cloud_schema_test.cpp196 std::string sql = "SELECT name FROM sqlite_master WHERE type = 'table' AND " \ in CheckSharedTable() local
218 std::string sql = "SELECT name FROM sqlite_master WHERE type = 'table' AND " \ in CheckDistributedSharedTable() local
243 string sql = ""; in InsertLocalSharedTableRecords() local
1268 std::string sql = "SELECT asset from " + g_sharedTableName1; variable
1537 std::string sql = QueryResourceCountSql(g_tableName2); variable
1580 std::string sql = QueryResourceCountSql(g_tableName2); variable
1643 std::string sql = "update " + tableName + " SET height='199';"; variable
1656 std::string sql = QueryResourceCountSql(g_tableName2); variable
1706 std::string sql = QueryResourceCountSql(g_tableName2); variable
1763 std::string sql = "update " + tableName + " SET height='199';"; variable
[all …]
/ohos5.0/foundation/distributeddatamgr/relational_store/frameworks/native/rdb/src/
H A Dtrans_db.cpp43 std::string sql("INSERT"); in Insert() local
116 std::string sql("UPDATE"); in Update() local
158 std::string sql; in Delete() local
175 std::shared_ptr<AbsSharedResultSet> TransDB::QuerySql(const std::string &sql, const Values &args) in QuerySql()
187 std::shared_ptr<ResultSet> TransDB::QueryByStep(const std::string &sql, const Values &args, bool pr… in QueryByStep()
193 std::pair<int32_t, ValueObject> TransDB::Execute(const std::string &sql, const Values &args, int64_… in Execute()
/ohos5.0/base/hiviewdfx/hiappevent/frameworks/native/libhiappevent/utility/
H A Dsql_util.cpp23 …std::string sql = "CREATE TABLE IF NOT EXISTS " + table + "(" + "seq INTEGER PRIMARY KEY AUTOINCRE… in CreateTable() local
33 std::string sql = "DROP TABLE IF EXISTS " + table; in DropTable() local
/ohos5.0/foundation/multimedia/media_library/frameworks/innerkitsimpl/medialibrary_data_extension/src/photo_album_operation/
H A Dphoto_album_merge_operation.cpp64 std::string sql = this->SQL_PHOTO_MAP_DUPLICATE_RELATIONSHIP_DELETE; in DeleteDuplicateRelationshipInPhotoMap() local
82 std::string sql = this->SQL_PHOTO_MAP_MOVE_RELATIONSHIP_UPDATE; in UpdateRelationshipInPhotoMap() local
100 std::string sql = this->SQL_PHOTOS_MOVE_RELATIONSHIP_UPDATE; in UpdateRelationshipInPhotos() local
118 std::string sql = this->SQL_PHOTO_ALBUM_DELETE; in DeleteOldAlbum() local
/ohos5.0/foundation/distributeddatamgr/kv_store/frameworks/libs/distributeddb/common/src/relational/
H A Dtracker_table.cpp60 std::string sql = " CASE WHEN ("; in GetDiffTrackerValSql() local
78 std::string sql = ", cursor = CASE WHEN ("; in GetDiffIncCursorSql() local
151 …std::string sql = "CREATE TEMP TRIGGER IF NOT EXISTS " + DBConstant::RELATIONAL_PREFIX + tableName… in GetTempInsertTriggerSql() local
173 …std::string sql = "CREATE TEMP TRIGGER IF NOT EXISTS " + DBConstant::RELATIONAL_PREFIX + tableName… in GetTempUpdateTriggerSql() local
198 …std::string sql = "CREATE TEMP TRIGGER IF NOT EXISTS " + DBConstant::RELATIONAL_PREFIX + tableName… in GetTempDeleteTriggerSql() local
/ohos5.0/base/security/asset/services/db_operator/src/
H A Dtable.rs206 …let sql = format!("select * from sqlite_master where type ='table' and name = '{}'", self.table_na… in exist() localVariable
218 let sql = format!("DROP TABLE {}", self.table_name); in delete() localVariable
229 let mut sql = format!("CREATE TABLE IF NOT EXISTS {}(", self.table_name); in create_with_version() localVariable
291 let mut sql = format!("insert into {} (", self.table_name); in insert_row() localVariable
325 let mut sql = format!("delete from {}", self.table_name); in delete_row() localVariable
350 let sql: String = format!("delete from {} where {}", self.table_name, specific_cond); in delete_with_specific_cond() localVariable
370 let mut sql = format!("update {} set ", self.table_name); in update_row() localVariable
406 let mut sql = String::from("select "); in query_row() localVariable
450 let mut sql = format!("select count(*) as count from {}", self.table_name); in count_datas() localVariable
504 … let mut sql = format!("ALTER TABLE {} ADD COLUMN {} {}", self.table_name, column.name, data_type); in add_column() localVariable
/ohos5.0/foundation/distributeddatamgr/kv_store/frameworks/libs/distributeddb/test/unittest/common/syncer/cloud/
H A Ddistributeddb_cloud_syncer_download_assets_test.cpp200 const string sql = "update " + tableName + " set assets=?;"; in UpdateLocalData() local
345 std::string sql = "SELECT assets from " + ASSETS_TABLE_NAME; in CheckDownloadFailedForTest002() local
495 std::string sql = "SELECT assets FROM " + tableName + ";"; in CheckLocaLAssets() local
519 std::string sql = "SELECT asset FROM " + tableName + ";"; in CheckLocalAssetIsEmpty() local
532 std::string sql = "SELECT cursor FROM " + logTableName + ";"; in CheckCursorData() local
668 std::string sql = "delete from " + ASSETS_TABLE_NAME + " WHERE id=0"; in DataStatusTest004() local
1263 std::string sql = "SELECT assets FROM " + ASSETS_TABLE_NAME + ";"; variable
1551 std::string sql = "SELECT assets from " + ASSETS_TABLE_NAME + " where id = 6;"; variable
1593 std::string sql = "update " + DBCommon::GetLogTableName(ASSETS_TABLE_NAME) variable
2268 std::string sql = "update " + logName + " SET status = 2 where data_key >=20;"; variable
[all …]
/ohos5.0/base/hiviewdfx/hiview/adapter/plugins/eventservice/service/idl/src/
H A Ddata_share_dao.cpp50 std::string sql; in IsUidExists() local
124 std::string sql; in GetEventListByUid() local
149 std::string sql; in GetUidByBundleName() local
174 std::string sql; in GetTotalSubscriberInfo() local
/ohos5.0/base/request/request/services/src/manage/
H A Ddatabase.rs146 let sql = format!( in contains_task() localVariable
161 let sql = format!( in query_task_token_id() localVariable
220 let sql = format!( in insert_task() localVariable
289 let sql = format!( in clear_invalid_records() localVariable
308 let sql = format!( in update_task() localVariable
317 let sql = format!( in update_task_state() localVariable
328 let sql = format!( in update_task_sizes() localVariable
466 let sql = format!( in delete_early_records() localVariable
485 let sql = format!( in get_task_qos_info() localVariable
501 let sql = format!( in get_task_qos_info() localVariable
[all …]
/ohos5.0/foundation/distributeddatamgr/kv_store/frameworks/libs/distributeddb/test/unittest/common/common/
H A Dnative_sqlite.cpp34 int NativeSqlite::ExecSql(sqlite3 *db, const std::string &sql) in ExecSql()
48 int NativeSqlite::ExecSql(sqlite3 *db, const std::string &sql, const std::function<int (sqlite3_stm… in ExecSql()
/ohos5.0/foundation/distributeddatamgr/kv_store/frameworks/libs/distributeddb/gaussdb_rd/src/oh_adapter/src/
H A Dsqlite_store_executor_impl.cpp115 std::string sql = "INSERT OR REPLACE INTO '" + collName + "' VALUES (?,?);"; in PutData() local
144 std::string sql = "INSERT INTO '" + collName + "' VALUES (?,?);"; in InsertData() local
171 std::string sql = "SELECT value FROM '" + collName + "' WHERE key=?;"; in GetDataByKey() local
198 std::string sql = "SELECT value FROM '" + collName + "' WHERE key=?;"; in GetDataById() local
250 std::string sql = GeneralInsertSql(collName, key, isIdExist); in GetDataByFilter() local
302 std::string sql = "DELETE FROM '" + collName + "' WHERE key=?;"; in DelData() local
337 …std::string sql = "CREATE TABLE IF NOT EXISTS '" + collName + "' (key BLOB PRIMARY KEY, value BLOB… in CreateCollection() local
370 std::string sql = "DROP TABLE IF EXISTS '" + collName + "';"; in DropCollection() local
381 std::string sql = "SELECT tbl_name FROM sqlite_master WHERE tbl_name=?;"; in IsCollectionExists() local
/ohos5.0/foundation/distributeddatamgr/kv_store/frameworks/libs/distributeddb/test/fuzztest/storage_fuzzer/
H A Dstorage_fuzzer.cpp125 const std::string sql = "PRAGMA journal_mode=WAL;"; in CreateDB() local
262 std::string sql = "create table " + tableName + "(id INTEGER primary key, name TEXT);"; in CreateTableForStoreObserver() local
274 …std::string sql = "insert or replace into " + tableName + " VALUES('" + std::to_string(i) + "', 'z… in InitLogicDeleteData() local
277 std::string sql = "update " + g_prefix + tableName + "_log" + " SET flag = flag | 0x08"; in InitLogicDeleteData() local
285 … std::string sql = "INSERT INTO " + tableName + " VALUES(" + std::to_string(i) + ", 'zhangsan" + in InitDataStatus() local
290 …std::string sql = "UPDATE " + DBCommon::GetLogTableName(tableName) + " SET status=(CASE WHEN data_… in InitDataStatus() local
300 …std::string sql = "select hash_key from " + DBCommon::GetLogTableName(tableName) + " where " + con… in GetHashKey() local
316 …std::string sql = "insert into " + tableName + " VALUES(1, 'zhangsan'), (2, 'lisi'), (3, 'wangwu')… in ClientObserverFuzz() local
/ohos5.0/base/security/access_token/services/privacymanager/src/database/
H A Dpermission_used_record_db.cpp380 std::string sql = "insert into " + it->second.tableName_ + " values("; in CreateInsertPrepareSqlCmd() local
400 std::string sql = "select * from " + it->second.tableName_ + WHERE_1_STR; in CreateQueryPrepareSqlCmd() local
417 std::string sql = "delete from " + it->second.tableName_ + WHERE_1_STR; in CreateDeletePrepareSqlCmd() local
437 std::string sql = "update " + it->second.tableName_ + " set "; in CreateUpdatePrepareSqlCmd() local
509 std::string sql = "select count(*) from " + it->second.tableName_; in CreateCountPrepareSqlCmd() local
520 std::string sql = "delete from " + it->second.tableName_ + " where "; in CreateDeleteExpireRecordsPrepareSqlCmd() local
550 std::string sql = "delete from " + it->second.tableName_ + " where "; in CreateDeleteExcessiveRecordsPrepareSqlCmd() local
567 std::string sql = CREATE_TABLE_STR; in CreatePermissionRecordTable() local
607 std::string sql = CREATE_TABLE_STR; in CreatePermissionUsedTypeTable() local
638 std::string sql = "alter table "; in InsertLockScreenStatusColumn() local
[all …]

123456789