Home
last modified time | relevance | path

Searched refs:whereClause (Results 1 - 25 of 67) sorted by relevance

123

/foundation/distributeddatamgr/relational_store/frameworks/native/rdb/src/
H A Dabs_predicates.cpp74 whereClause += "AND "; in EqualTo()
79 whereClause += newField + " = ? "; in EqualTo()
82 whereClause += "(" + newField + " & 0x02 = " + flagVal + ")"; in EqualTo()
97 whereClause += field + " <> ? "; in NotEqualTo()
105 whereClause += "AND "; in BeginWrap()
108 whereClause += " ( "; in BeginWrap()
118 whereClause += " ) "; in EndWrap()
128 whereClause += " OR "; in Or()
147 whereClause += field + " LIKE ? "; in Contains()
161 whereClause in NotContains()
576 SetWhereClause(const std::string &whereClause) SetWhereClause() argument
[all...]
H A Dsqlite_sql_builder.cpp43 const std::vector<std::string> &whereArgs, const std::string &index, const std::string &whereClause, in BuildUpdateString()
67 sql.append(BuildSqlStringFromPredicates(index, "", whereClause, group, order, limit, offset)); in BuildUpdateString()
75 const std::vector<std::string> &columns, const std::string &whereClause, const std::string &groupBy, in BuildQueryString()
94 .append(BuildSqlStringFromPredicates(indexName, joinClause, whereClause, groupBy, orderBy, limit, offset)); in BuildQueryString()
101 const std::string &whereClause, const std::string &group, const std::string &order, int limit, int offset) in BuildSqlStringFromPredicates()
110 AppendClause(sqlString, " WHERE ", whereClause); in BuildSqlStringFromPredicates()
234 auto whereClause = predicates.GetWhereClause(); in BuildCursorQueryString() local
235 SqliteUtils::Replace(whereClause, SqliteUtils::REP, logName + "."); in BuildCursorQueryString()
236 AppendClause(sql, " WHERE ", whereClause); in BuildCursorQueryString()
272 auto whereClause in BuildLockRowQueryString() local
42 BuildUpdateString(const ValuesBucket &values, const std::string &tableName, const std::vector<std::string> &whereArgs, const std::string &index, const std::string &whereClause, const std::string &group, const std::string &order, int limit, int offset, std::vector<ValueObject> &bindArgs, ConflictResolution conflictResolution) BuildUpdateString() argument
74 BuildQueryString(bool distinct, const std::string &table, const std::string &joinClause, const std::vector<std::string> &columns, const std::string &whereClause, const std::string &groupBy, const std::string &indexName, const std::string &orderBy, const int &limit, const int &offset, std::string &outSql) BuildQueryString() argument
100 BuildSqlStringFromPredicates(const std::string &index, const std::string &joinClause, const std::string &whereClause, const std::string &group, const std::string &order, int limit, int offset) BuildSqlStringFromPredicates() argument
[all...]
H A Drdb_store.cpp170 int RdbStore::Update(int &changedRows, const std::string &table, const Row &row, const std::string &whereClause, in Update() argument
173 auto [errCode, changes] = Update(table, row, whereClause, args, NO_ACTION); in Update()
185 int RdbStore::Update(int &changedRows, const std::string &table, const Row &row, const std::string &whereClause, in Update() argument
188 return Update(changedRows, table, row, whereClause, ToValues(args)); in Update()
192 const std::string &whereClause, const Olds &args, Resolution resolution) in UpdateWithConflictResolution()
194 auto [errCode, changes] = Update(table, row, whereClause, ToValues(args), resolution); in UpdateWithConflictResolution()
202 const std::string &whereClause, const Values &args, Resolution resolution) in UpdateWithConflictResolution()
204 auto [errCode, changes] = Update(table, row, whereClause, args, resolution); in UpdateWithConflictResolution()
211 int RdbStore::Delete(int &deletedRows, const std::string &table, const std::string &whereClause, const Olds &args) in Delete() argument
213 return Delete(deletedRows, table, whereClause, ToValue in Delete()
191 UpdateWithConflictResolution(int &changedRows, const std::string &table, const Row &row, const std::string &whereClause, const Olds &args, Resolution resolution) UpdateWithConflictResolution() argument
201 UpdateWithConflictResolution(int &changedRows, const std::string &table, const Row &row, const std::string &whereClause, const Values &args, Resolution resolution) UpdateWithConflictResolution() argument
221 Query(int &errCode, bool distinct, const std::string &table, const Fields &columns, const std::string &whereClause, const Values &args, const std::string &groupBy, const std::string &indexName, const std::string &orderBy, const int &limit, const int &offset) Query() argument
[all...]
/foundation/distributeddatamgr/relational_store/frameworks/native/dataability/src/
H A Dpredicates_utils.cpp27 * Set the param of whereClause and bindArgs of the specified Predicates.
30 AbsPredicates *predicates, const std::string &whereClause, const std::vector<std::string> &whereArgs) in SetWhereClauseAndArgs()
32 predicates->SetWhereClause(whereClause); in SetWhereClauseAndArgs()
37 * Set the param of whereClause and bindArgs of the specified Predicates.
39 void PredicatesUtils::SetWhereClauseAndArgs(AbsPredicates *predicates, const std::string &whereClause, in SetWhereClauseAndArgs() argument
42 predicates->SetWhereClause(whereClause); in SetWhereClauseAndArgs()
29 SetWhereClauseAndArgs( AbsPredicates *predicates, const std::string &whereClause, const std::vector<std::string> &whereArgs) SetWhereClauseAndArgs() argument
/foundation/multimedia/media_library/frameworks/innerkitsimpl/medialibrary_data_extension/src/
H A Dmedialibrary_file_operations.cpp179 string whereClause = predicates->GetWhereClause(); in SolvePendingInQuery() local
180 size_t groupByPoint = whereClause.rfind("GROUP BY"); in SolvePendingInQuery()
183 groupBy = whereClause.substr(groupByPoint); in SolvePendingInQuery()
184 whereClause = whereClause.substr(0, groupByPoint); in SolvePendingInQuery()
187 predicates->SetWhereClause(whereClause); in SolvePendingInQuery()
421 string whereClause = cmd.GetAbsRdbPredicates()->GetWhereClause(); in BuildCompatQuerySql() local
424 ReplaceSelectionAndArgsInQuery(whereClause, whereArgs, table, MEDIA_DATA_DB_BUCKET_NAME, in BuildCompatQuerySql()
427 ReplaceSelectionAndArgsInQuery(whereClause, whereArgs, table, MEDIA_DATA_DB_ID); in BuildCompatQuerySql()
429 if (!whereClause in BuildCompatQuerySql()
441 string whereClause = cmd.GetAbsRdbPredicates()->GetWhereClause(); RemoveWhereSuffix() local
[all...]
/foundation/multimedia/ringtone_library/test/unittest/ringtone_scanner_test/src/
H A Dringtone_scanner_db_test.cpp79 string whereClause = {}; in HWTEST_F() local
83 int ret = ringtoneScannerDb.QueryRingtoneRdb(whereClause, whereArgs, columns, resultSet); in HWTEST_F()
86 ret = ringtoneScannerDb.QueryRingtoneRdb(whereClause, whereArgs, columns, resultSet); in HWTEST_F()
129 string whereClause = {}; in HWTEST_F() local
131 int ret = ringtoneScannerDb.UpdateRingtoneRdb(valuesBucket, whereClause, whereArgs); in HWTEST_F()
134 ret = ringtoneScannerDb.UpdateRingtoneRdb(valuesBucket, whereClause, whereArgs); in HWTEST_F()
/foundation/multimedia/media_library/frameworks/services/media_mtp/src/
H A Dmtp_medialibrary_manager.cpp119 string whereClause; in GetHandles() local
122 whereClause = MEDIA_DATA_DB_PARENT_ID + " = ? AND " + MEDIA_DATA_DB_NAME + " Like ? AND " + in GetHandles()
126 whereClause = MEDIA_DATA_DB_PARENT_ID + " = ? AND " + MEDIA_DATA_DB_DATE_TRASHED + in GetHandles()
130 whereClause = MEDIA_DATA_DB_PARENT_ID + " = ? AND " + MEDIA_DATA_DB_MEDIA_TYPE + " = ? AND " + in GetHandles()
134 predicates.SetWhereClause(whereClause); in GetHandles()
165 string whereClause = MEDIA_DATA_DB_ID + " = ? AND " + MEDIA_DATA_DB_DATE_TRASHED + " = 0"; in GetObjectInfo() local
167 predicates.SetWhereClause(whereClause); in GetObjectInfo()
300 string whereClause = MEDIA_DATA_DB_ID + " = ? AND " + MEDIA_DATA_DB_DATE_TRASHED + " = 0"; in GetAssetById() local
302 predicates.SetWhereClause(whereClause); in GetAssetById()
337 string whereClause in GetIdByPath() local
571 string whereClause; GetAllRootsChildren() local
593 string whereClause; GetHandle() local
613 string whereClause; GetRootIdList() local
640 string whereClause; GetRootsDepthChildren() local
666 string whereClause; GetHandleDepthChildren() local
[all...]
/foundation/deviceprofile/device_info_manager/services/core/test/unittest/
H A Drdb_adapter_test.cpp296 std::string whereClause = "deviceId = ?"; in HWTEST_F() local
300 int32_t deleteErrCode = store->Delete(deleteRows, table, whereClause, bindArgs); in HWTEST_F()
327 std::string whereClause = "deviceId = ?"; in HWTEST_F() local
331 int32_t deleteErrCode = store->Delete(deleteRows, deleteTable, whereClause, bindArgs); in HWTEST_F()
357 std::string whereClause = "xxxdeviceId = ?"; in HWTEST_F() local
361 int32_t deleteErrCode = store->Delete(deleteRows, deleteTable, whereClause, bindArgs); in HWTEST_F()
386 std::string whereClause = "deviceId = ?"; in HWTEST_F() local
391 int32_t deleteErrCode = store->Delete(deleteRows, table, whereClause, bindArgs); in HWTEST_F()
431 std::string whereClause = "deviceId = ?"; in HWTEST_F() local
435 int32_t updateErrCode = store->Update(changedRows, table, newValues, whereClause, bindArg in HWTEST_F()
474 std::string whereClause = "deviceId = ?"; HWTEST_F() local
510 std::string whereClause = "xxxdeviceId = ?"; HWTEST_F() local
554 std::string whereClause = "deviceId = ?"; HWTEST_F() local
[all...]
/foundation/multimedia/ringtone_library/services/ringtone_restore/src/
H A Dringtone_dualfwk_restore.cpp204 string whereClause = MakeBatchQueryWhereClause(names, predicateColumn) + " AND " + in QueryMediaLibForFileInfo() local
206 RINGTONE_INFO_LOG("Querying media_library where %{public}s", whereClause.c_str()); in QueryMediaLibForFileInfo()
207 predicates.SetWhereClause(whereClause); in QueryMediaLibForFileInfo()
216 RINGTONE_WARN_LOG("resultset for %{public}s is null", whereClause.c_str()); in QueryMediaLibForFileInfo()
222 queryFileUri.c_str(), whereClause.c_str(), count); in QueryMediaLibForFileInfo()
225 RINGTONE_WARN_LOG("resultset for %{public}s is empty", whereClause.c_str()); in QueryMediaLibForFileInfo()
254 string whereClause = MakeBatchQueryWhereClause(names, predicateColumn); in QueryRingToneDbForFileInfo() local
256 " WHERE " + whereClause + " AND " + in QueryRingToneDbForFileInfo()
258 RINGTONE_INFO_LOG("Querying ringtonedb where %{public}s", whereClause.c_str()); in QueryRingToneDbForFileInfo()
262 RINGTONE_WARN_LOG("resultset for %{public}s is null", whereClause in QueryRingToneDbForFileInfo()
[all...]
/foundation/multimedia/ringtone_library/services/ringtone_scanner/src/
H A Dringtone_scanner_db.cpp34 string whereClause = RINGTONE_COLUMN_DATA + " = ?"; in GetFileBasicInfo() local
39 cmd.GetAbsRdbPredicates()->SetWhereClause(whereClause); in GetFileBasicInfo()
58 string whereClause = VIBRATE_COLUMN_DATA + " = ?"; in GetVibrateFileBasicInfo() local
63 cmd.GetAbsRdbPredicates()->SetWhereClause(whereClause); in GetVibrateFileBasicInfo()
76 int32_t RingtoneScannerDb::QueryRingtoneRdb(const string &whereClause, vector<string> &whereArgs, in QueryRingtoneRdb() argument
86 absRdbPredicates.SetWhereClause(whereClause); in QueryRingtoneRdb()
97 int32_t RingtoneScannerDb::UpdateRingtoneRdb(ValuesBucket &values, const string &whereClause, in UpdateRingtoneRdb() argument
106 int32_t result = rawRdb->Update(updateCount, tableName, values, whereClause, whereArgs); in UpdateRingtoneRdb()
320 string whereClause = RINGTONE_COLUMN_TONE_ID + " = ?"; in UpdateMetadata() local
331 int32_t result = rawRdb->Update(updateCount, tableName, values, whereClause, whereArg in UpdateMetadata()
343 string whereClause = VIBRATE_COLUMN_VIBRATE_ID + " = ?"; UpdateVibrateMetadata() local
[all...]
/foundation/deviceprofile/device_info_manager/services/core/src/persistenceadapter/rdbadapter/
H A Drdb_adapter.cpp104 int32_t RdbAdapter::Delete(int32_t& deleteRows, const std::string& table, const std::string& whereClause, in Delete() argument
117 int32_t ret = store_->Delete(deleteRows, table, whereClause, bindArgs); in Delete()
125 ret = store_->Delete(deleteRows, table, whereClause, bindArgs); in Delete()
136 const std::string& whereClause, const std::vector<ValueObject>& bindArgs) in Update()
148 int32_t ret = store_->Update(changedRows, table, values, whereClause, bindArgs); in Update()
156 ret = store_->Update(changedRows, table, values, whereClause, bindArgs); in Update()
135 Update(int32_t& changedRows, const std::string& table, const ValuesBucket& values, const std::string& whereClause, const std::vector<ValueObject>& bindArgs) Update() argument
/foundation/distributeddatamgr/relational_store/interfaces/inner_api/dataability/include/
H A Dpredicates_utils.h44 * @brief Set the parameter of whereClause and bindArgs of the specified Predicates.
48 API_EXPORT static void SetWhereClauseAndArgs(AbsPredicates *predicates, const std::string &whereClause,
52 * @brief Set the parameter of whereClause and bindArgs of the specified Predicates.
54 API_EXPORT static void SetWhereClauseAndArgs(AbsPredicates *predicates, const std::string &whereClause,
/foundation/multimedia/media_library/frameworks/innerkitsimpl/test/unittest/medialibrary_rdb_callback_test/include/
H A Drdbstore_mock.h47 const std::string &whereClause, const std::vector<std::string> &whereArgs));
49 const std::string &whereClause, const std::vector<OHOS::Media::ValueObject> &bindArgs));
52 const OHOS::Media::ValuesBucket &values, const std::string &whereClause,
60 const std::string &whereClause,
67 const std::string &whereClause,
72 const std::string &whereClause,
102 const std::string &whereClause, const std::vector<OHOS::Media::ValueObject> &bindArgs,
/foundation/multimedia/media_library/frameworks/utils/src/
H A Dmedialibrary_common_utils.cpp301 bool MediaLibraryCommonUtils::CheckWhereClause(const std::string &whereClause) in CheckWhereClause() argument
305 if (whereClause.empty() || (whereClause.size() == 1 && whereClause == " ")) { in CheckWhereClause()
309 if (!CheckIllegalCharacter(whereClause)) { in CheckWhereClause()
315 if (!CheckKeyWord(whereClause)) { in CheckWhereClause()
321 auto args = whereClause; in CheckWhereClause()
/foundation/filemanagement/dfs_service/test/unittests/clouddisk_database/mock/
H A Drdb_assistant.h50 const std::string &whereClause,
56 const std::string &whereClause,
63 const std::string &whereClause,
71 const std::string &whereClause,
78 const std::string &whereClause,
84 const std::string &whereClause,
115 const std::string &whereClause,
/foundation/filemanagement/dfs_service/test/unittests/clouddisk_database/include/
H A Dclouddisk_rdbstore_mock.h50 const std::string &whereClause,
56 const std::string &whereClause,
63 const std::string &whereClause,
71 const std::string &whereClause,
78 const std::string &whereClause,
84 const std::string &whereClause,
116 const std::string &whereClause,
/foundation/filemanagement/dfs_service/test/unittests/cloudsync_sa/mock/
H A Drdb_store_mock.h50 const std::string &whereClause,
56 const std::string &whereClause,
63 const std::string &whereClause,
71 const std::string &whereClause,
78 const std::string &whereClause,
84 const std::string &whereClause,
115 const std::string &whereClause,
/foundation/deviceprofile/device_info_manager/services/core/include/persistenceadapter/rdbadapter/
H A Drdb_adapter.h33 int32_t Delete(int32_t& deleteRows, const std::string& table, const std::string& whereClause,
36 const std::string& whereClause, const std::vector<ValueObject>& bindArgs = {}) override;
H A Dirdb_adapter.h38 virtual int32_t Delete(int32_t& deleteRows, const std::string& table, const std::string& whereClause = "",
41 const ValuesBucket& values, const std::string& whereClause = "",
/foundation/distributeddatamgr/datamgr_service/services/distributeddataservice/service/data_share/
H A Ddata_share_types_util.cpp26 std::string whereClause = ""; in Unmarshalling() local
30 if (!ITypesUtil::Unmarshal(parcel, operations, whereClause, whereArgs, order, mode)) { in Unmarshalling()
31 ZLOGE("predicate read whereClause failed"); in Unmarshalling()
35 tmpPredicates.SetWhereClause(whereClause); in Unmarshalling()
/foundation/distributeddatamgr/relational_store/frameworks/native/rdb/include/
H A Dsqlite_sql_builder.h34 const std::vector<std::string> &whereArgs, const std::string &index, const std::string &whereClause,
38 const std::vector<std::string> &columns, const std::string &whereClause, const std::string &groupBy,
42 const std::string &whereClause, const std::string &group, const std::string &order, int limit, int offset);
/foundation/bundlemanager/app_domain_verify/test/unittest/mock/include/
H A Dmock_rdb.h42 (int& deletedRows, const std::string& table, const std::string& whereClause,
47 (int& deletedRows, const std::string& table, const std::string& whereClause,
75 int Update(int& changedRows, const std::string& table, const ValuesBucket& values, const std::string& whereClause,
81 const std::string& whereClause, const std::vector<std::string>& whereArgs,
87 const std::string& whereClause, const std::vector<ValueObject>& bindArgs,
94 const std::vector<std::string>& columns, const std::string& whereClause,
/foundation/bundlemanager/bundle_framework/services/bundlemgr/test/mock/include/
H A Dmock_app_provision_info.h53 const std::string &whereClause = "", in Update()
59 const std::string &whereClause, const std::vector<std::string> &whereArgs, in UpdateWithConflictResolution()
65 const std::string &whereClause = "", const std::vector<ValueObject> &bindArgs = {}, in UpdateWithConflictResolution()
70 virtual int Delete(int &deletedRows, const std::string &table, const std::string &whereClause, in Delete() argument
75 virtual int Delete(int &deletedRows, const std::string &table, const std::string &whereClause = "", in Delete()
81 const std::vector<std::string> &columns, const std::string &whereClause = "", in Query()
58 UpdateWithConflictResolution(int &changedRows, const std::string &table, const ValuesBucket &values, const std::string &whereClause, const std::vector<std::string> &whereArgs, ConflictResolution conflictResolution) UpdateWithConflictResolution() argument
/foundation/communication/netmanager_ext/services/netfirewallmanager/src/
H A Dnetfirewall_database.cpp140 const OHOS::NativeRdb::ValuesBucket &values, const std::string &whereClause, in Update()
144 NETMGR_EXT_LOG_E("Update(whereClause) store_ is nullptr"); in Update()
147 int32_t ret = store_->Update(changedRows, tableName, values, whereClause, whereArgs); in Update()
151 int32_t ret = store_->Update(changedRows, tableName, values, whereClause, whereArgs); in Update()
155 NETMGR_EXT_LOG_E("Update(whereClause) ret :%{public}d", ret); in Update()
165 int32_t NetFirewallDataBase::Delete(const std::string &tableName, int32_t &changedRows, const std::string &whereClause, in Delete() argument
172 int32_t ret = store_->Delete(changedRows, tableName, whereClause, whereArgs); in Delete()
176 int32_t ret = store_->Delete(changedRows, tableName, whereClause, whereArgs); in Delete()
180 NETMGR_EXT_LOG_E("Delete(whereClause) ret :%{public}d", ret); in Delete()
139 Update(const std::string &tableName, int32_t &changedRows, const OHOS::NativeRdb::ValuesBucket &values, const std::string &whereClause, const std::vector<std::string> &whereArgs) Update() argument
/foundation/distributeddatamgr/relational_store/interfaces/inner_api/rdb/include/
H A Drdb_store.h205 * @param whereClause Indicates the where clause.
217 * @param whereClause Indicates the where clause.
220 virtual int Update(int &changedRows, const std::string &table, const Row &row, const std::string &whereClause = "",
238 * @param whereClause Indicates the where clause.
242 virtual int Update(int &changedRows, const std::string &table, const Row &row, const std::string &whereClause,
251 * @param whereClause Indicates the where clause.
258 const std::string &whereClause, const Olds &args, Resolution resolution = NO_ACTION);
266 * @param whereClause Indicates the where clause.
271 const std::string &whereClause = "", const Values &args = {}, Resolution resolution = NO_ACTION);
277 * @param whereClause Indicate
[all...]

Completed in 14 milliseconds

123