Method createDatabase

app/src/Sessions/Export.cpp:214–261

* @brief Creates the SQLite database file and writes the schema and session. */

 * @brief Creates the SQLite database file and writes the schema and session.
 */
void Sessions::ExportWorker::createDatabase(const DataModel::Frame& frame)
{
  Q_ASSERT(!m_dbOpen);

  const auto dbPath  = Sessions::DatabaseManager::canonicalDbPath(frame.title);
  const auto dirPath = QFileInfo(dbPath).absolutePath();
  QDir dir(dirPath);
  if (!dir.exists() && !dir.mkpath(".")) {
    qWarning() << "[SQLite] Failed to create directory:" << dirPath;
    return;
  }

  const auto dt          = QDateTime::currentDateTime();
  const QString connName = QStringLiteral("ss_sqlite_%1").arg(dt.toMSecsSinceEpoch());
  m_db.emplace(QSqlDatabase::addDatabase("QSQLITE", connName));
  m_db->setDatabaseName(dbPath);
  if (!m_db->open()) {
    qWarning() << "[SQLite] Cannot open database:" << m_db->lastError().text();
    m_db.reset();
    QSqlDatabase::removeDatabase(connName);
    return;
  }

  QSqlQuery pragma(*m_db);
  pragma.exec("PRAGMA journal_mode=WAL");
  pragma.exec("PRAGMA synchronous=NORMAL");
  pragma.exec("PRAGMA busy_timeout=5000");

  createSchema(pragma);

  insertSession(frame, dt);
  if (m_sessionId < 0) [[unlikely]] {
    qWarning() << "[SQLite] Aborting database open -- session row was not inserted";
    m_db->close();
    m_db.reset();
    QSqlDatabase::removeDatabase(connName);
    return;
  }

  writeColumnDefs(frame);

  storeProjectMetadata(frame);

  prepareHotpathQueries();

  m_dbOpen = true;
  Q_EMIT resourceOpenChanged();
}

/**
 * @brief Delegates to DatabaseManager::createSchema for a single source of truth.