compat.sqlite3

// Behavioral test for compat.sqlite3 (SQLite 3.45.3, C API): assert the
// resolved library version, then open an in-memory database, create a table,
// insert a row, and read it back through both sqlite3_exec and a prepared
// statement.
#include <sqlite3.h>
#include <cassert>
#include <cstring>

int main() {
    // The index pins 3.45.3; prove the resolved package is that version.
    assert(std::strcmp(sqlite3_libversion(), "3.45.3") == 0);

    sqlite3* db = nullptr;
    assert(sqlite3_open(":memory:", &db) == SQLITE_OK);
    assert(db != nullptr);

    // DDL + DML through the convenience API.
    char* errmsg = nullptr;
    int rc = sqlite3_exec(db,
        "CREATE TABLE t(id INTEGER PRIMARY KEY, name TEXT NOT NULL);"
        "INSERT INTO t(name) VALUES ('mcpp');",
        nullptr, nullptr, &errmsg);
// …