Method storeProjectMetadata

app/src/Sessions/DatabaseWorker.cpp:445–494

* @brief Stores the live project JSON snapshot in project_metadata. */

 * @brief Stores the live project JSON snapshot in project_metadata.
 */
void Sessions::DatabaseWorker::storeProjectMetadata(const QString& projectJson,
                                                    const QString& projectTitle,
                                                    quint64 token)
{
  if (!m_db.isOpen()) {
    Q_EMIT mutationFinished(token, false, tr("Database not open"));
    return;
  }

  if (!m_db.transaction()) {
    Q_EMIT mutationFinished(token, false, m_db.lastError().text());
    return;
  }

  const auto now = QDateTime::currentDateTime().toString(Qt::ISODate);

  QSqlQuery q(m_db);
  bool ok = true;

  q.prepare("INSERT OR REPLACE INTO project_metadata (key, value) VALUES ('project_json', ?)");
  q.bindValue(0, projectJson);
  ok = ok && q.exec();

  q.prepare("INSERT OR REPLACE INTO project_metadata (key, value) VALUES ('project_title', ?)");
  q.bindValue(0, projectTitle);
  ok = ok && q.exec();

  q.prepare("INSERT OR REPLACE INTO project_metadata (key, value) VALUES ('last_modified_at', ?)");
  q.bindValue(0, now);
  ok = ok && q.exec();

  q.prepare("INSERT INTO project_metadata (key, value) VALUES ('created_at', ?) "
            "ON CONFLICT(key) DO NOTHING");
  q.bindValue(0, now);
  ok = ok && q.exec();

  if (!ok) {
    m_db.rollback();
    Q_EMIT mutationFinished(token, false, q.lastError().text());
    return;
  }

  if (!m_db.commit()) {
    m_db.rollback();
    Q_EMIT mutationFinished(token, false, m_db.lastError().text());
    return;
  }

  Q_EMIT mutationFinished(token, true, QString());
}

/**
 * @brief Reads the global project JSON snapshot back to the manager.