compat.sqlitecpp

// Behavioral test: a real database session through the RAII wrapper.
//
// The load-bearing question for this package is whether the dependency edge on
// compat.sqlite3 actually replaces upstream's git submodule — and that is a LINK
// question, so every assertion below is chosen to reach sqlite3 symbols: the
// version string, prepared statements with bound parameters, a transaction that
// rolls back, and the exception path (which carries an sqlite3 error code).
#include <SQLiteCpp/SQLiteCpp.h>

#include <cassert>
#include <string>

int main() {
    // The wrapper reports the SQLite it was linked against, which is the
    // cheapest proof that the dependency edge resolved to a real library.
    const std::string version = SQLite::getLibVersion();
    assert(!version.empty() && version[0] == '3');

    SQLite::Database db(":memory:", SQLite::OPEN_READWRITE | SQLite::OPEN_CREATE);

    db.exec("CREATE TABLE note (id INTEGER PRIMARY KEY, title TEXT NOT NULL, size INTEGER)");
    assert(db.tableExists("note"));
// …