Home
last modified time | relevance | path

Searched refs:querySql (Results 1 – 25 of 100) sorted by relevance

1234

/ohos5.0/foundation/multimedia/media_library/frameworks/services/media_backup_extension/src/restore/
H A Ddb_upgrade_utils.cpp31 std::string querySql = this->SQL_SQLITE_MASTER_QUERY; in IsTableExists() local
33 auto resultSet = store.QuerySql(querySql, bindArgs); in IsTableExists()
50 std::string querySql = this->SQL_PRAGMA_TABLE_INFO_QUERY; in IsColumnExists() local
52 auto resultSet = store.QuerySql(querySql, bindArgs); in IsColumnExists()
70 std::string querySql = this->SQL_SQLITE_MASTER_QUERY_TRIGGER; in GetAllTriggers() local
72 auto resultSet = store.QuerySql(querySql, bindArgs); in GetAllTriggers()
100 std::string querySql = this->SQL_SQLITE_MASTER_QUERY_UNIQUE_INDEX; in GetAllUniqueIndex() local
102 auto resultSet = store.QuerySql(querySql, bindArgs); in GetAllUniqueIndex()
H A Dphoto_album_clone.cpp41 std::string querySql = this->SQL_PHOTO_ALBUM_COUNT_FOR_CLONE; in GetPhotoAlbumCountInOriginalDb() local
46 auto resultSet = this->mediaLibraryOriginalRdb_->QuerySql(querySql); in GetPhotoAlbumCountInOriginalDb()
48 MEDIA_ERR_LOG("Failed to query album! querySql = %{public}s", querySql.c_str()); in GetPhotoAlbumCountInOriginalDb()
59 std::string querySql = this->SQL_PHOTO_ALBUM_SELECT_FOR_CLONE; in GetPhotoAlbumInOriginalDb() local
65 auto resultSet = this->mediaLibraryOriginalRdb_->QuerySql(querySql, bindArgs); in GetPhotoAlbumInOriginalDb()
68 querySql.c_str(), in GetPhotoAlbumInOriginalDb()
H A Dphotos_dao.cpp40 std::string querySql = this->SQL_PHOTOS_FIND_SAME_FILE_IN_ALBUM; in FindSameFileInAlbum() local
45 auto resultSet = this->mediaLibraryRdb_->QuerySql(querySql, params); in FindSameFileInAlbum()
69 std::string querySql = this->SQL_PHOTOS_FIND_SAME_FILE_WITHOUT_ALBUM; in FindSameFileWithoutAlbum() local
74 auto resultSet = this->mediaLibraryRdb_->QuerySql(querySql, params); in FindSameFileWithoutAlbum()
91 std::string querySql = this->SQL_PHOTOS_BASIC_INFO; in GetBasicInfo() local
96 auto resultSet = this->mediaLibraryRdb_->QuerySql(querySql); in GetBasicInfo()
98 …_WARN_LOG("Media_Restore: GetBasicInfo resultSet is null. querySql: %{public}s", querySql.c_str()); in GetBasicInfo()
154 std::string querySql = this->SQL_PHOTOS_FIND_SAME_FILE_BY_SOURCE_PATH; in FindSameFileBySourcePath() local
159 auto resultSet = this->mediaLibraryRdb_->QuerySql(querySql, params); in FindSameFileBySourcePath()
H A Dphotos_clone.cpp49 std::string querySql = this->SQL_PHOTOS_TABLE_COUNT_IN_PHOTO_MAP; in GetPhotosRowCountInPhotoMap() local
54 auto resultSet = this->mediaLibraryOriginalRdb_->QuerySql(querySql); in GetPhotosRowCountInPhotoMap()
66 std::string querySql = this->SQL_PHOTOS_TABLE_COUNT_NOT_IN_PHOTO_MAP; in GetPhotosRowCountNotInPhotoMap() local
71 auto resultSet = this->mediaLibraryOriginalRdb_->QuerySql(querySql); in GetPhotosRowCountNotInPhotoMap()
193 std::string querySql = this->SQL_PHOTOS_TABLE_BURST_KEY_DUPLICATE_QUERY; in FindDuplicateBurstKey() local
203 auto resultSet = this->mediaLibraryTargetRdb_->QuerySql(querySql, bindArgs); in FindDuplicateBurstKey()
307 std::string querySql = this->SQL_PHOTOS_TABLE_COUNT_NO_NEED_MIGRATE; in GetNoNeedMigrateCount() local
312 auto resultSet = this->mediaLibraryOriginalRdb_->QuerySql(querySql); in GetNoNeedMigrateCount()
H A Dphoto_album_dao.cpp44 std::string querySql = this->SQL_PHOTO_ALBUM_CHECK_ALBUM_NAME_UNIQUE; in CheckAlbumNameUnique() local
49 auto resultSet = this->mediaLibraryRdb_->QuerySql(querySql, bindArgs); in CheckAlbumNameUnique()
95 std::string querySql = this->SQL_PHOTO_ALBUM_SELECT; in GetPhotoAlbums() local
105 auto resultSet = this->mediaLibraryRdb_->QuerySql(querySql, bindArgs); in GetPhotoAlbums()
145 std::string querySql = this->SQL_PHOTO_ALBUM_SELECT_BY_LPATH; in GetPhotoAlbum() local
150 auto resultSet = this->mediaLibraryRdb_->QuerySql(querySql, bindArgs); in GetPhotoAlbum()
/ohos5.0/foundation/distributeddatamgr/relational_store/test/js/relationalstore/unittest/src/
H A DRdbStoreResultSetGetValue.test.js75 let resultSet = await rdbStore.querySql('SELECT * FROM test')
105 let resultSet = await rdbStore.querySql('SELECT * FROM test')
136 let resultSet = await rdbStore.querySql('SELECT * FROM test')
166 let resultSet = await rdbStore.querySql('SELECT * FROM test')
196 let resultSet = await rdbStore.querySql('SELECT * FROM test')
226 let resultSet = await rdbStore.querySql('SELECT * FROM test')
255 let resultSet = await rdbStore.querySql('SELECT * FROM test')
285 let resultSet = await rdbStore.querySql('SELECT * FROM test')
315 let resultSet = await rdbStore.querySql('SELECT * FROM test')
344 let resultSet = await rdbStore.querySql('SELECT * FROM test')
H A DRdbstoreStoreExcuteSqlJsunit.test.js94 let querySqlPromise = rdbStore.querySql("SELECT * FROM test")
147 let querySqlPromise = rdbStore.querySql("SELECT * FROM test")
223 … let querySqlPromise = rdbStore.querySql("SELECT * FROM test WHERE name ='" + nameStr + "'")
300 let resultSet = await rdbStore.querySql("PRAGMA user_version");
315 let resultSet = await rdbStore.querySql("PRAGMA table_info(test)");
351 let resultSet = await rdbStore.querySql("PRAGMA user_version");
356 resultSet = await rdbStore.querySql("PRAGMA user_version");
H A DRdbstorePredicatesJoinJsunit.test.js126 let resultSet = await rdbStore.querySql(
151 let resultSet = await rdbStore.querySql(
176 let resultSet = await rdbStore.querySql(
192 let resultSet = await rdbStore.querySql(
H A DRdbstorePredicatesJoinBJsunit.test.js154 let resultSet = await rdbStore.querySql(
182 …let resultSet = await rdbStore.querySql("SELECT t1.id, t1.eName, t1.salary, t2.jName, t2.descript…
205 let resultSet = await rdbStore.querySql("SELECT t1.eName, t1.salary, t2.* " +
227 …let resultSet = await rdbStore.querySql("SELECT t1.eName, t1.salary, t2.jName, t2.description, t3.…
252 let resultSet = await rdbStore.querySql(
/ohos5.0/foundation/distributeddatamgr/kv_store/frameworks/libs/distributeddb/test/unittest/common/interfaces/
H A Ddistributeddb_interfaces_relational_tracker_table_test.cpp562 EXPECT_EQ(SQLiteUtils::GetStatement(g_db, querySql, stmt), E_OK);
1263 condition.sql = querySql;
1271 querySql = "select * from " + TABLE_NAME2 + " where id > ?;";
1272 condition.sql = querySql;
1281 condition.sql = querySql;
1312 condition.sql = querySql;
1429 querySql += "a.data_key where a.cursor > ?;";
1430 condition.sql = querySql;
1450 condition.sql = querySql;
1484 condition.sql = querySql;
[all …]
/ohos5.0/foundation/multimedia/media_library/frameworks/services/media_backup_extension/src/
H A Dbackup_database_utils.cpp213 return rdbStore->QuerySql(querySql, sqlArgs); in GetQueryResultSet()
221 auto resultSet = GetQueryResultSet(rdbStore, querySql); in GetColumnInfoMap()
264 return QueryInt(rdbStore, querySql, UNIQUE_NUMBER); in QueryUniqueNumber()
281 querySql += " AND " + EXCLUDE_SD; in UpdateSdWhereClause()
534 auto resultSet = GetQueryResultSet(rdbStore, querySql); in GetColumnInfoPairs()
635 void BackupDatabaseUtils::PrintQuerySql(const std::string& querySql) in PrintQuerySql() argument
639 MEDIA_INFO_LOG("%{public}s", querySql.c_str()); in PrintQuerySql()
717 std::string querySql = "SELECT " + IMAGE_FACE_COL_FILE_ID + in GetFileIdNewFilterClause() local
769 std::string querySql = "SELECT " + ANALYSIS_COL_TAG_ID + ", " + in QueryTagInfo() local
928 auto resultSet = GetQueryResultSet(rdbStore, querySql); in CheckDbIntegrity()
[all …]
H A Dclone_restore.cpp508 string querySql = "SELECT * FROM " + tableName; in QueryAlbumInfos() local
1069 querySql += " LIMIT " + to_string(fileIndexMap.size()); in BatchQueryPhoto()
1443 string querySql = "SELECT * FROM " + tableName; in QueryFileInfos() local
1576 querySql += whereClause.empty() ? "" : " AND " + whereClause; in QueryTotalNumberByMediaType()
1782 querySql += whereClause; in RestoreFromGalleryPortraitAlbum()
1817 std::string querySql = in QueryPortraitAlbumTbl() local
1825 querySql += whereClause; in QueryPortraitAlbumTbl()
1988 auto resultSet = mediaRdb_->QuerySql(querySql, bindArgs); in QueryAllPortraitAlbum()
2135 std::string querySql = "SELECT DISTINCT " + inClause + in QueryFaceTagTbl() local
2185 std::string querySql = QUERY_IMAGE_FACE_COUNT; in RestoreImageFaceInfo() local
[all …]
/ohos5.0/foundation/multimedia/ringtone_library/services/ringtone_setting/src/
H A Dringtone_setting_manager.cpp303 string querySql = QUERY_SETTINGS_BY_PATH + "\"" + tonePath + "\""; in UpdateSettingsByPath() local
304 auto ret = TravelQueryResultSet(querySql, [&](shared_ptr<RingtoneMetadata> &meta) -> bool { in UpdateSettingsByPath()
434 string querySql = {}; in CleanupSetting() local
436 … querySql = QUERY_SHOTTONE_SETTINGS_SQL + " AND " + RINGTONE_COLUMN_SHOT_TONE_SOURCE_TYPE + " = " + in CleanupSetting()
439 …querySql = QUERY_ALARMTONE_SETTINGS_SQL + " AND " + RINGTONE_COLUMN_ALARM_TONE_SOURCE_TYPE + " = "… in CleanupSetting()
442 querySql = QUERY_NOTIFICATIONTONE_SETTINGS_SQL + " AND " + in CleanupSetting()
445 … querySql = QUERY_RINGTONE_SETTINGS_SQL + " AND " + RINGTONE_COLUMN_RING_TONE_SOURCE_TYPE + " = " + in CleanupSetting()
452 TravelQueryResultSet(querySql, [&](shared_ptr<RingtoneMetadata> &meta) -> bool { in CleanupSetting()
474 int32_t RingtoneSettingManager::TravelQueryResultSet(string querySql, in TravelQueryResultSet() argument
477 auto resultSet = ringtoneRdb_->QuerySql(querySql); in TravelQueryResultSet()
/ohos5.0/foundation/multimedia/media_library/frameworks/innerkitsimpl/test/unittest/medialibrary_backup_clone_test/src/
H A Dmedialibrary_backup_clone_test.cpp145 return rdbStore->QuerySql(querySql); in GetResultSet()
152 auto resultSet = rdbStore->QuerySql(querySql); in QueryInt()
217 QueryInt(rdbStore, querySql, MEDIA_COLUMN_COUNT_1, result); in GetAlbumCountByCondition()
240 string querySql = "SELECT " + MEDIA_COLUMN_COUNT_1 + " FROM " + tableName; in GetCountByWhereClause() local
241 querySql += whereClause.empty() ? "" : " WHERE " + whereClause; in GetCountByWhereClause()
243 QueryInt(rdbStore, querySql, MEDIA_COLUMN_COUNT_1, result); in GetCountByWhereClause()
300 string querySql = "SELECT " + MEDIA_COLUMN_COUNT_1 + " FROM " + tableName; in GetMapCountByTable() local
302 QueryInt(rdbStore, querySql, MEDIA_COLUMN_COUNT_1, result); in GetMapCountByTable()
653 std::string querySql = "SELECT * FROM " + ANALYSIS_ALBUM_TABLE + in VerifyPortraitAlbumRestore() local
703 std::string querySql = "SELECT * FROM " + VISION_FACE_TAG_TABLE; in VerifyPortraitClusteringRestore() local
[all …]
/ohos5.0/foundation/multimedia/ringtone_library/services/ringtone_restore/src/
H A Dringtone_restore_db_utils.cpp78 const std::shared_ptr<NativeRdb::RdbStore> &rdbStore, const std::string &querySql) in GetQueryResultSet() argument
84 return rdbStore->QuerySql(querySql); in GetQueryResultSet()
91 std::string querySql = "SELECT name, type FROM pragma_table_info('" + tableName + "')"; in GetColumnInfoMap() local
92 auto resultSet = GetQueryResultSet(rdbStore, querySql); in GetColumnInfoMap()
H A Dringtone_restore.cpp69 string querySql = "SELECT * FROM " + RINGTONE_TABLE; in QueryFileInfos() local
71 querySql += " LIMIT " + to_string(offset) + ", " + to_string(QUERY_COUNT); in QueryFileInfos()
73 auto resultSet = restoreRdb_->QuerySql(querySql); in QueryFileInfos()
/ohos5.0/foundation/distributeddatamgr/relational_store/test/ndk/unittest/
H A Drdb_store_test.cpp120 char querySql[] = "SELECT * FROM store_test"; in SetUp() local
244 char querySql[] = "SELECT * FROM store_test"; variable
304 char querySql[] = "SELECT * FROM store_test"; variable
336 char querySql[] = "SELECT * FROM store_test"; variable
383 char querySql[] = "SELECT * FROM store_test"; variable
392 cursor = OH_Rdb_ExecuteQuery(storeTestRdbStore_, querySql);
423 char querySql[] = "SELECT * FROM store_test"; variable
470 char querySql[] = "SELECT * FROM store_test"; variable
548 char querySql[] = "SELECT * FROM store_test"; variable
633 char *querySql = NULL; variable
[all …]
/ohos5.0/foundation/multimedia/ringtone_library/services/ringtone_scanner/src/
H A Dringtone_default_setting.cpp51 string querySql = "SELECT data FROM ToneFiles WHERE display_name = "s + "\"" + name + "\""; in GetTonePathByDisplayName() local
52 settingMgr_->TravelQueryResultSet(querySql, [&](shared_ptr<RingtoneMetadata> &meta) -> bool { in GetTonePathByDisplayName()
172 …const string querySql = "SELECT tone_id FROM ToneFiles WHERE display_name = "s + "\"" + info.secon… in UpdateDefaultSystemTone() local
174 … settingMgr_->TravelQueryResultSet(querySql, [&](shared_ptr<RingtoneMetadata> &meta) -> bool { in UpdateDefaultSystemTone()
/ohos5.0/foundation/distributeddatamgr/relational_store/test/js/rdb/unittest/src/
H A DRdbstorePredicatesJoinJsunit.test.js122 let resultSet = await rdbStore.querySql(
147 let resultSet = await rdbStore.querySql(
172 let resultSet = await rdbStore.querySql(
188 let resultSet = await rdbStore.querySql(
H A DRdbstorePredicatesJoinBJsunit.test.js151 let resultSet = await rdbStore.querySql(
179 …let resultSet = await rdbStore.querySql("SELECT t1.id, t1.eName, t1.salary, t2.jName, t2.descript…
202 let resultSet = await rdbStore.querySql("SELECT t1.eName, t1.salary, t2.* " +
224 …let resultSet = await rdbStore.querySql("SELECT t1.eName, t1.salary, t2.jName, t2.description, t3.…
249 let resultSet = await rdbStore.querySql(
H A DRdbstoreStoreExcuteSqlJsunit.test.js89 let querySqlPromise = rdbStore.querySql("SELECT * FROM test")
140 let querySqlPromise = rdbStore.querySql("SELECT * FROM test")
213 … let querySqlPromise = rdbStore.querySql("SELECT * FROM test WHERE name ='" + nameStr + "'")
/ohos5.0/foundation/multimedia/media_library/frameworks/innerkitsimpl/medialibrary_data_extension/src/photo_album_operation/
H A Dphoto_album_lpath_operation.cpp104 std::string querySql = this->SQL_PHOTO_ALBUM_EMPTY_QUERY; in GetInvalidPhotoAlbums() local
105 auto resultSet = this->rdbStorePtr_->QuerySql(querySql); in GetInvalidPhotoAlbums()
317 std::string querySql = this->SQL_PHOTO_ALBUM_DUPLICATE_LPATH_MAIN_QUERY; in GetDuplicatelPathAlbumInfoMain() local
318 auto resultSet = this->rdbStorePtr_->QuerySql(querySql); in GetDuplicatelPathAlbumInfoMain()
353 std::string querySql = this->SQL_PHOTO_ALBUM_FIX_LPATH_QUERY; in GetEmptylPathAlbumInfo() local
354 auto resultSet = this->rdbStorePtr_->QuerySql(querySql); in GetEmptylPathAlbumInfo()
/ohos5.0/foundation/multimedia/media_library/frameworks/innerkitsimpl/medialibrary_data_extension/src/operation/
H A Dphoto_burst_operation.cpp121 std::string querySql = this->SQL_PHOTOS_TABLE_QUERY_BURST_KEY; in QueryBurstKeyFromDB() local
124 auto resultSet = rdbStore->QuerySql(querySql, bindArgs); in QueryBurstKeyFromDB()
128 querySql.c_str(), in QueryBurstKeyFromDB()
H A Dphoto_displayname_operation.cpp65 std::string querySql = this->SQL_PHOTOS_TABLE_QUERY_DISPLAY_NAME; in IsDisplayNameExists() local
67 auto resultSet = rdbStore->QuerySql(querySql, bindArgs); in IsDisplayNameExists()
/ohos5.0/foundation/multimedia/media_library/frameworks/innerkitsimpl/medialibrary_data_extension/src/event_handler/
H A Dalbum_plugin_table_event_handler.cpp98 std::string querySql = this->SQL_SELECT_DATA_COUNT; in GetAlbumPluginDataCount() local
99 auto resultSet = store.QuerySql(querySql); in GetAlbumPluginDataCount()
101 MEDIA_WARN_LOG("resultSet is null! querySql = %{public}s", querySql.c_str()); in GetAlbumPluginDataCount()

1234