Method replaceMessage

native/cpp/CommonCpp/DatabaseManagers/SQLiteQueryExecutor.cpp:333–364

}

void SQLiteQueryExecutor::replaceMessage(
    const Message &message,
    bool backupItem) const {
  int sidebarSourceTypeInt = static_cast<int>(MessageType::SIDEBAR_SOURCE);
  std::string sidebarSourceType = std::to_string(sidebarSourceTypeInt);

  std::string tableName = backupItem ? "backup_messages" : "messages";
  std::string replaceMessageSQL = "REPLACE INTO " + tableName +
      "("
      "  id, local_id, thread, user, type, future_type, content, time, "
      "  target_message"
      ")"
      "VALUES ( "
      "  :id, :local_id, :thread, :user, :type, :future_type, :content, :time,"
      "  IIF("
      "    JSON_VALID(:content),"
      "    COALESCE("
      "      JSON_EXTRACT(:content, '$.targetMessageID'),"
      "      IIF("
      "        :type = " +
      sidebarSourceType +
      ","
      "        JSON_EXTRACT(:content, '$.id'),"
      "        NULL"
      "      )"
      "    ),"
      "    NULL"
      "  )"
      ");";

  replaceEntity<Message>(this->getConnection(), replaceMessageSQL, message);
}

void SQLiteQueryExecutor::updateMessageSearchIndex(
    std::string originalMessageID,