README.md

sqlite-cpp-wrapper

Single header SQLite C++ Wrapper (yes, another one, there are many like it, but this one is mine).

Usage example:

#include <cstdio>
#include <iostream>

#include "sqlite.c++.h"

struct Record {
	sqlite3_int64 id;
	int price;
	std::string desc;
	std::vector<char> data;
};

int main () {
	
	// DB
	std::string dbName = "tmp.db";
	if (dbName != ":memory:")
		remove(dbName.c_str());
	SQLiteDB db(dbName);
	
	// DDL
	db.createQuery(
		"create table test ( "
			"id integer primary key, "
			"price bigint, "
			"desc varchar, "
			"data blob );").execute();
	
	// Insert
	Record r = {1, 998798, "item 1 description", {1,2,3,4,5}};
	auto insert = db.createQuery(
			"insert into test values (null, ?, ?, ?);",
			r.price, r.desc, r.data); // binded values (variables)
	insert.execute();
	std::cout << "Row ID: " << db.lastInsertRowID() << std::endl;
	
	insert.reset(); // bind one value at a time
	insert.bind(1, 203948394);
	insert.bind(2, "item 2 description");
	insert.bind(3, std::vector<char>{6, 7, 8, 9});
	insert.execute();
	std::cout << "Row ID: " << db.lastInsertRowID() << std::endl;
	
	{
		SQLiteTransationGuard transaction(db);

		insert.reset();
		insert.bindValues(999, "won't be inserted",std::vector<char>());
		insert.execute();
		std::cout << "Rollback Row ID: " << db.lastInsertRowID() << std::endl;
		// rollback
	}

	{
		auto transaction = db.startTransaction();

		insert.reset();
		insert.bindValues(777, "will be inserted",std::vector<char>());
		insert.execute();
		std::cout << "Commit Row ID: " << db.lastInsertRowID() << std::endl;
		transaction.commit();
	}

	insert.reset();
	insert.bindValues(
		102912938,
		"item 3 description",
		std::vector<char>{11, 12, 13, 14, 15}); // bind all values (literals)
	insert.execute();
	std::cout << "Row ID: " << db.lastInsertRowID() << std::endl;
	
	// Query
	auto result =
			db.
			createQuery("select id, price, desc, data from test where id <> ?;", 2).
			getResult();

	while (result.next()) {
		Record rec;
		
		result.fetch(rec.id, rec.price, rec.desc, rec.data);
		std::cout << rec.id << ", " << rec.price << ", " << rec.desc << ", data: ";
		for (auto &c:rec.data)
			std::cout << (int)c << " ";
		std::cout << std::endl;
	}
}

Output:

$ ./test.exe
Row ID: 1
Row ID: 2
Rollback Row ID: 3
Commit Row ID: 3
Row ID: 4
1, 998798, item 1 description, data: 1 2 3 4 5
3, 777, will be inserted, data:
4, 102912938, item 3 description, data: 11 12 13 14 15