entropic::SqliteDatabase Class Reference

Thread-safe SQLite database wrapper. More...

#include <entropic/storage/database.h>

Public Member Functions
	SqliteDatabase (const std::filesystem::path &db_path)
	Construct with database file path.
	~SqliteDatabase ()
	Destructor — closes connection if open.
	SqliteDatabase (const SqliteDatabase &)=delete
SqliteDatabase &	operator= (const SqliteDatabase &)=delete
bool	initialize ()
	Initialize database and run pending migrations.
void	close ()
	Close database connection.
bool	is_open () const
	Check if database is open.
bool	execute (std::string_view sql, std::function< void(sqlite3_stmt *)> binder=nullptr)
	Execute a write statement (INSERT, UPDATE, DELETE).
bool	execute_raw (std::string_view sql)
	Execute raw SQL (multiple statements, no binding).
bool	fetch_one (std::string_view sql, std::function< void(sqlite3_stmt *)> binder, std::function< void(sqlite3_stmt *)> extractor)
	Fetch a single row.
size_t	fetch_all (std::string_view sql, std::function< void(sqlite3_stmt *)> binder, std::function< void(sqlite3_stmt *)> row_handler)
	Fetch all matching rows.
sqlite3 *	raw_handle () const
	Get the underlying sqlite3 handle (for advanced use).

Detailed Description

Thread-safe SQLite database wrapper.

Opens a SQLite database with SQLITE_OPEN_FULLMUTEX as a safety net. Application-level std::mutex serializes all operations to prevent concurrent access patterns.

Lifecycle:

SqliteDatabase db("/path/to/entropic.db");
db.initialize();  // Creates file, runs migrations
db.execute("INSERT INTO ...", [](auto* s) { ... });
db.close();       // Or let destructor handle it

Version

1.8.8

Definition at line 42 of file database.h.

Constructor & Destructor Documentation

SqliteDatabase()

entropic::SqliteDatabase::SqliteDatabase ( const std::filesystem::path &  db_path )

explicit

Construct with database file path.

Parameters

db_path

Path to SQLite file. Created if absent.

Version

1.8.8

Parameters

db_path

Path to SQLite file. @dg_internal

Version

1.8.8

Definition at line 165 of file database.cpp.

~SqliteDatabase()

entropic::SqliteDatabase::~SqliteDatabase

(

)

Destructor — closes connection if open.

Version

1.8.8

@dg_internal

Version

1.8.8

Definition at line 173 of file database.cpp.

Member Function Documentation

close()

void entropic::SqliteDatabase::close

(

)

Close database connection.

@req REQ-STOR-001

Version

1.8.8

Definition at line 221 of file database.cpp.

execute()

bool entropic::SqliteDatabase::execute	(	std::string_view	sql,
		std::function< void(sqlite3_stmt *)>	binder = nullptr
	)

Execute a write statement (INSERT, UPDATE, DELETE).

Execute a write statement with optional parameter binding.

Parameters

sql	SQL statement with ? placeholders.
binder	Function to bind parameters to the prepared statement.

Returns

true on success. @req REQ-STOR-002

Version

1.8.8

Parameters

sql	SQL statement with ? placeholders.
binder	Function to bind parameters.

Returns

true on success. @req REQ-STOR-002

Version

2.0.0

Definition at line 269 of file database.cpp.

execute_raw()

bool entropic::SqliteDatabase::execute_raw

(

std::string_view

sql

)

Execute raw SQL (multiple statements, no binding).

Parameters

sql	SQL text (may contain multiple semicolon-separated statements).

Returns

true on success. @req REQ-STOR-002

Version

1.8.8

Parameters

sql

SQL text.

Returns

true on success. @req REQ-STOR-002

Version

2.0.0

Definition at line 295 of file database.cpp.

fetch_all()

size_t entropic::SqliteDatabase::fetch_all	(	std::string_view	sql,
		std::function< void(sqlite3_stmt *)>	binder,
		std::function< void(sqlite3_stmt *)>	row_handler
	)

Fetch all matching rows.

Parameters

sql	SQL SELECT statement.
binder	Function to bind parameters.
row_handler	Called for each result row.

Returns

Number of rows fetched. @req REQ-STOR-002

Version

1.8.8

Definition at line 353 of file database.cpp.

fetch_one()

bool entropic::SqliteDatabase::fetch_one	(	std::string_view	sql,
		std::function< void(sqlite3_stmt *)>	binder,
		std::function< void(sqlite3_stmt *)>	extractor
	)

Fetch a single row.

Parameters

sql	SQL SELECT statement.
binder	Function to bind parameters.
extractor	Function to extract columns from result row.

Returns

true if row found. @req REQ-STOR-002

Version

1.8.8

Definition at line 322 of file database.cpp.

initialize()

bool entropic::SqliteDatabase::initialize

(

)

Initialize database and run pending migrations.

Returns

true on success, false on error. @req REQ-STOR-001

Version

1.8.8

Returns

true on success. @req REQ-STOR-001

Version

2.0.0

Definition at line 183 of file database.cpp.

is_open()

bool entropic::SqliteDatabase::is_open

(

)

const

Check if database is open.

Returns

true if connection is active. @req REQ-STOR-001

Version

1.8.8

Definition at line 235 of file database.cpp.

raw_handle()

sqlite3 * entropic::SqliteDatabase::raw_handle

(

)

const

Get the underlying sqlite3 handle (for advanced use).

Get the underlying sqlite3 handle.

Returns

Raw sqlite3 pointer (may be nullptr if closed).

Version

1.8.8

Returns

Raw sqlite3 pointer. @dg_internal

Version

1.8.8

Definition at line 381 of file database.cpp.

---

The documentation for this class was generated from the following files:

• entropic/storage/database.h
• storage/database.cpp