ores.database.database_info

Table of Contents

Stores the schema version, git commit, and build environment inserted at database creation time. Used to correlate service behaviour with the database schema in use. Contains exactly one row.

Flags

Primary key

Fixed UUID identifying the singleton database info record.

A well-known UUID inserted by the creation script.

Natural keys

Columns

schema_version

Database schema version matching the application version.

Set to ORES_VERSION (e.g. '0.0.13') at database creation time.

std::string("0.0.1")

build_environment

Build environment identifier.

e.g. 'local', 'production', 'staging'. Prefix from ORES_BUILD_INFO.

std::string("local")

git_commit

Short git commit hash of the code that created this database.

e.g. 'c7681ac4' or 'c7681ac4-dirty'. From ORES_BUILD_INFO.

std::string("abc1234")

git_date

Date and time of the git commit that created this database.

e.g. '2026/02/25 22:43:31'. From ORES_BUILD_INFO.

std::string("2026/01/01 00:00:00")

SQL

Flags

C++

Repository

Domain includes

#include <chrono>
#include <string>
#include <boost/uuid/uuid.hpp>

Entity includes

#include <string>
#include "sqlgen/Timestamp.hpp"
#include "sqlgen/PrimaryKey.hpp"

Conventions

Custom repository methods

See also

Emacs 29.1 (Org mode 9.6.6)