Sqlitecpp Testing Practices
Testing & Qualitysqlitecpp-testing-practicesSqlitecpp Testing Practices is an Agent Skill for testing & quality published in the SRombauts/SQLiteCpp repository on GitHub: a SKILL.md instruction file an AI agent can load to do this task.
GoogleTest patterns and testing practices for SQLiteCpp test coverage and structure.
QUICK START
How to use this skill
Bring this guide into your coding agent with a prompt tailored to the tool you use.
- Open your project in Codex.
- Copy and paste the prompt below.
- Review files and risks before approving any action.
Prompt to paste
Inspect the Agent Skill at https://github.com/SRombauts/SQLiteCpp/blob/HEAD/.claude/skills/sqlitecpp-testing-practices/SKILL.md and all supporting files. Report provenance, permissions, scripts, dependencies, and security risks. Propose an exact installation into .agents/skills/sqlitecpp-testing-practices, but wait for my approval before writing files or running scripts.
Copying this prompt does not install or run the skill. Review third-party files before use.
SQLiteCpp Testing Practices
Scope
- Uses GoogleTest (system if found, otherwise
googletest/fallback). - Test files live in
tests/*_test.cpp(seetests/Database_test.cpp). - File headers use
@ingroup tests.
Test File Structure
#include <gtest/gtest.h>
#include <SQLiteCpp/Database.h>
TEST(DatabaseTest, CanOpenReadWriteDatabase)
{
// Arrange: setup test database
SQLite::Database db(":memory:", SQLite::OPEN_READWRITE | SQLite::OPEN_CREATE);
// Act: perform operation
db.exec("CREATE TABLE test (id INTEGER PRIMARY KEY)");
// Assert: verify behavior
EXPECT_EQ(1, db.exec("INSERT INTO test DEFAULT VALUES"));
}
Adding a New Test File
- Create
tests/NewClass_test.cpp. - Register it in
CMakeLists.txtunderSQLITECPP_TESTS. - Register it in
meson.buildundersqlitecpp_test_srcs.
Common Patterns
- Prefer
:memory:databases when possible. - Use file-based databases when testing file I/O behavior (see
tests/Database_test.cpp). - Use
TEST()for independent tests; useTEST_F()only when a shared fixture is needed.
Running Tests
# CMake (from build dir)
ctest --output-on-failure
bin/SQLiteCpp_tests --gtest_filter=Database.*
# Meson
meson test -C builddir
meson test -C builddir --test-args="--gtest_filter=Database.*"
Canonical References
- Test style:
tests/Database_test.cpp - CMake test list:
CMakeLists.txt(SQLITECPP_TESTS) - Meson test list:
meson.build(sqlitecpp_test_srcs)
Cross-References
- Workflow checklist:
sqlitecpp-workflow - Build configuration:
sqlitecpp-build-cmake,sqlitecpp-build-meson