Searched refs:logTblName (Results 1 – 5 of 5) sorted by relevance
40 std::string logTblName = DBConstant::RELATIONAL_PREFIX + table.GetTableName() + "_log"; in GetInsertTrigger() local45 insertTrigger += "\t INSERT OR REPLACE INTO " + logTblName; in GetInsertTrigger()49 insertTrigger += " CASE WHEN (SELECT count(*)<>0 FROM " + logTblName + " WHERE hash_key=" + in GetInsertTrigger()58 std::string logTblName = DBConstant::RELATIONAL_PREFIX + table.GetTableName() + "_log"; in GetUpdateTrigger() local73 updateTrigger += "\t UPDATE " + logTblName; in GetUpdateTrigger()76 updateTrigger += "\t INSERT OR REPLACE INTO " + logTblName + " VALUES (NEW." + in GetUpdateTrigger()
50 std::string logTblName = DBConstant::RELATIONAL_PREFIX + table.GetTableName() + "_log"; in GetInsertTrigger() local57 insertTrigger += "\t INSERT OR REPLACE INTO " + logTblName; in GetInsertTrigger()61 insertTrigger += " CASE WHEN (SELECT count(*)<>0 FROM " + logTblName + " WHERE hash_key=" + in GetInsertTrigger()70 std::string logTblName = DBConstant::RELATIONAL_PREFIX + table.GetTableName() + "_log"; in GetUpdateTrigger() local86 updateTrigger += "\t UPDATE " + logTblName; in GetUpdateTrigger()89 updateTrigger += "\t INSERT OR REPLACE INTO " + logTblName + " VALUES (NEW." + in GetUpdateTrigger()
93 std::string logTblName = GetLogTableName(table); in GetInsertTrigger() local102 insertTrigger += "\t INSERT OR REPLACE INTO " + logTblName; in GetInsertTrigger()108 … insertTrigger += logTblName + " WHERE hash_key = " + CalcPrimaryKeyHash("NEW.", table, identity); in GetInsertTrigger()109 insertTrigger += ") THEN (SELECT cloud_gid FROM " + logTblName + " WHERE hash_key = "; in GetInsertTrigger()113 … insertTrigger += "(SELECT CASE WHEN version IS NULL THEN '' ELSE version END FROM " + logTblName; in GetInsertTrigger()128 std::string logTblName = GetLogTableName(table); in GetUpdateTrigger() local137 updateTrigger += "\t UPDATE " + logTblName; in GetUpdateTrigger()158 std::string logTblName = GetLogTableName(table); in GetDeleteTrigger() local
63 std::string logTblName = GetLogTableName(table); in GetInsertTrigger() local71 insertTrigger += "\t INSERT OR REPLACE INTO " + logTblName; in GetInsertTrigger()92 std::string logTblName = GetLogTableName(table); in GetUpdateTrigger() local102 updateTrigger += "\t UPDATE " + logTblName; in GetUpdateTrigger()
1255 std::string logTblName = "naturalbase_rdb_aux_" + tableName + "_log"; in HandleDropCloudSyncTable() local1256 …std::string sql = "UPDATE " + logTblName + " SET data_key=-1, flag=0x03, timestamp=get_raw_sys_tim… in HandleDropCloudSyncTable()1279 std::string logTblName = DBCommon::GetLogTableName(tableName); in HandleDropLogicDeleteData() local1287 …sql = "DELETE FROM " + tableName + " WHERE _rowid_ IN (SELECT data_key FROM " + logTblName + " WHE… in HandleDropLogicDeleteData()1294 sql = "DELETE FROM " + logTblName + " WHERE (flag&0x08=0x08 " + in HandleDropLogicDeleteData()1359 std::string logTblName = DBCommon::GetLogTableName(tableStr); in ClearTheLogAfterDropTable() local1360 if (CheckTableExists(db, logTblName)) { in ClearTheLogAfterDropTable()1372 …std::string sql = "UPDATE " + logTblName + " SET data_key=-1, flag=0x03, timestamp=get_sys_time(0)… in ClearTheLogAfterDropTable()1446 std::string logTblName = DBCommon::GetLogTableName(tableName); in HandleDataLock() local1447 if (!CheckTableExists(db, logTblName)) { in HandleDataLock()[all …]