| /ohos5.0/foundation/distributeddatamgr/kv_store/frameworks/libs/distributeddb/storage/src/sqlite/relational/ |
| H A D | collaboration_log_table_manager.cpp | 30 …c_hash('" + identity + "'||calc_hash(" + references + std::string(DBConstant::SQLITE_INNER_ROWID) + in CalcPrimaryKeyHash()
59 insertTrigger += " VALUES (new." + std::string(DBConstant::SQLITE_INNER_ROWID) + ", '', '',"; in GetInsertTrigger()
81 … updateTrigger += " WHERE data_key = OLD." + std::string(DBConstant::SQLITE_INNER_ROWID) + ";"; in GetUpdateTrigger()
88 … updateTrigger += " WHERE data_key = OLD." + std::string(DBConstant::SQLITE_INNER_ROWID)+ ";\n"; in GetUpdateTrigger()
90 std::string(DBConstant::SQLITE_INNER_ROWID) + ", '', '', get_sys_time(0), " in GetUpdateTrigger()
111 deleteTrigger += " WHERE data_key = OLD." + std::string(DBConstant::SQLITE_INNER_ROWID) + ";"; in GetDeleteTrigger()
|
| H A D | cloud_sync_log_table_manager.cpp | 34 … sql = "calc_hash(" + references + "'" + std::string(DBConstant::SQLITE_INNER_ROWID) + "', " + in CalcPrimaryKeyHash()
105 insertTrigger += " VALUES (new." + std::string(DBConstant::SQLITE_INNER_ROWID) + ", '', '',"; in GetInsertTrigger()
117 …= "SELECT client_observer('" + tableName + "', NEW." + std::string(DBConstant::SQLITE_INNER_ROWID); in GetInsertTrigger()
144 updateTrigger += " WHERE data_key = OLD." + std::string(DBConstant::SQLITE_INNER_ROWID) + ";\n"; in GetUpdateTrigger()
147 updateTrigger += std::string(DBConstant::SQLITE_INNER_ROWID); in GetUpdateTrigger()
180 deleteTrigger += " WHERE data_key = OLD." + std::string(DBConstant::SQLITE_INNER_ROWID) + ";\n"; in GetDeleteTrigger()
|
| H A D | simple_tracker_log_table_manager.cpp | 74 insertTrigger += " VALUES (new." + std::string(DBConstant::SQLITE_INNER_ROWID) + ", '', '',"; in GetInsertTrigger()
106 updateTrigger += " WHERE data_key = OLD." + std::string(DBConstant::SQLITE_INNER_ROWID) + ";\n"; in GetUpdateTrigger()
107 …= "SELECT client_observer('" + tableName + "', OLD." + std::string(DBConstant::SQLITE_INNER_ROWID); in GetUpdateTrigger()
132 deleteTrigger += " WHERE data_key = OLD." + std::string(DBConstant::SQLITE_INNER_ROWID) + ";"; in GetDeleteTrigger()
|
| H A D | split_device_log_table_manager.cpp | 47 insertTrigger += " VALUES (new." + std::string(DBConstant::SQLITE_INNER_ROWID) + ", '', '',"; in GetInsertTrigger()
77 std::string(DBConstant::SQLITE_INNER_ROWID) + ", '', '', get_sys_time(0), " in GetUpdateTrigger()
|
| H A D | sqlite_single_ver_relational_storage_extend_executor.cpp | 77 sql += " WHERE " + std::string(DBConstant::SQLITE_INNER_ROWID) + " = ("; in GetFillDownloadAssetStatement()
1034 …g removeDataSql = "DELETE FROM " + tableName + " WHERE " + DBConstant::SQLITE_INNER_ROWID + " = " + in RemoveDataAndLog()
1154 std::string(DBConstant::SQLITE_INNER_ROWID) + " = " + std::to_string(rowId) + ";"; in UpdateAssetIdOnUserTable()
1191 … "' WHERE " + std::string(DBConstant::SQLITE_INNER_ROWID) + " = " + std::to_string(rowId) + ";"; in GetAssetsAndUpdateAssetsId()
1233 std::string(DBConstant::SQLITE_INNER_ROWID) + " = " + std::to_string(rowId) + ";"; in CleanAssetsIdOnUserTable()
1462 sql += " WHERE " + std::string(DBConstant::SQLITE_INNER_ROWID) + " = ?;"; in GetAndBindFillUploadAssetStatement()
1591 … "' WHERE " + std::string(DBConstant::SQLITE_INNER_ROWID) + " = " + std::to_string(dataKey) + ";"; in GetAssetOnTable()
1630 … "' WHERE " + std::string(DBConstant::SQLITE_INNER_ROWID) + " = " + std::to_string(dataKey) + ";"; in GetAssetsOnTable()
1729 …updateAssetIdSql += " WHERE " + std::string(DBConstant::SQLITE_INNER_ROWID) + " = " + std::to_stri… in UpdateAssetId()
|
| H A D | sqlite_single_ver_relational_storage_executor_extend.cpp | 493 … "' WHERE " + std::string(DBConstant::SQLITE_INNER_ROWID) + " = " + std::to_string(rowId) + ";"; in GetAssetOnTable()
539 … "' WHERE " + std::string(DBConstant::SQLITE_INNER_ROWID) + " = " + std::to_string(rowId) + ";"; in GetCloudAssetsOnTable()
881 where += " " + std::string(DBConstant::SQLITE_INNER_ROWID) + " = (SELECT data_key FROM " + in GetWhereConditionForDataTable()
1306 …= " FROM '" + tableSchema.name + "' WHERE " + std::string(DBConstant::SQLITE_INNER_ROWID) + " = " + in IsNeedUpdateAssetId()
|
| H A D | sqlite_single_ver_relational_storage_executor.cpp | 104 …ommon::CaseInsensitiveCompare(field.GetFieldName(), std::string(DBConstant::SQLITE_INNER_ROWID))) { in CheckTableConstraint()
150 …std::string sql = "SELECT get_sys_time(0) - max(" + std::string(DBConstant::SQLITE_INNER_ROWID) + … in GetExistedDataTimeOffset()
181 std::string rowid = std::string(DBConstant::SQLITE_INNER_ROWID); in GeneLogInfoForExistedData()
1728 …ring sql = "DELETE FROM '" + tableName + "' WHERE " + std::string(DBConstant::SQLITE_INNER_ROWID) + in CleanCloudDataAndLogOnUserTable()
|
| /ohos5.0/foundation/distributeddatamgr/kv_store/frameworks/libs/distributeddb/common/src/relational/ |
| H A D | tracker_table.cpp | 188 sql += " data_key = OLD." + std::string(DBConstant::SQLITE_INNER_ROWID) + ";\n"; in GetTempUpdateTriggerSql()
221 sql += " WHERE data_key = OLD." + std::string(DBConstant::SQLITE_INNER_ROWID) + ";\n"; in GetTempDeleteTriggerSql()
|
| /ohos5.0/foundation/distributeddatamgr/kv_store/frameworks/libs/distributeddb/common/include/ |
| H A D | db_constant.h | 183 static constexpr const char *SQLITE_INNER_ROWID = "_rowid_"; variable
|
| /ohos5.0/foundation/distributeddatamgr/kv_store/frameworks/libs/distributeddb/storage/src/relational/ |
| H A D | relational_sync_data_inserter.cpp | 194 …l = "DELETE FROM '" + insertTableName_ + "' WHERE " + std::string(DBConstant::SQLITE_INNER_ROWID) + in GetDeleteSyncDataStmt()
|
| /ohos5.0/foundation/distributeddatamgr/kv_store/frameworks/libs/distributeddb/storage/src/cloud/ |
| H A D | cloud_storage_utils.cpp | 800 std::string rowid = std::string(DBConstant::SQLITE_INNER_ROWID); in GetTableRefUpdateSql()
846 " ON (a.data_key = b." + std::string(DBConstant::SQLITE_INNER_ROWID) + ")"; in GetLeftJoinLogSql()
849 " ON (b.data_key = a." + std::string(DBConstant::SQLITE_INNER_ROWID) + ")"; in GetLeftJoinLogSql()
|
| /ohos5.0/foundation/distributeddatamgr/kv_store/frameworks/libs/distributeddb/storage/src/sqlite/ |
| H A D | sqlite_query_helper.cpp | 108 "ON a." + std::string(DBConstant::SQLITE_INNER_ROWID) + "=b.data_key "; in GetSelectAndFromClauseForRDB()
1047 sql += " AS b ON (a." + std::string(DBConstant::SQLITE_INNER_ROWID) + " = b.data_key)"; in GetRelationalSyncDataQuerySqlWithLimit()
|
| /ohos5.0/foundation/distributeddatamgr/kv_store/frameworks/libs/distributeddb/test/unittest/common/interfaces/ |
| H A D | distributeddb_cloud_interfaces_relational_remove_device_data_test.cpp | 518 "*," + std::string(DBConstant::SQLITE_INNER_ROWID) + ",''" + " FROM " + tableName; in CopySharedDataFromOriginalTable()
|