#include <sqlitelib.h>
using namespace sqlitelib;
auto db = Sqlite('./test.db');

db.prepare(
    "CREATE TABLE IF NOT EXISTS people ("
    "    id INTEGER PRIMARY KEY AUTOINCREMENT,"
    "    name TEXT,"
    "    age INTEGER,"
    "    data BLOB"
    ");"
    ).execute();

db_.prepare("DROP TABLE IF EXISTS people").execute();

auto stmt = db_.prepare("INSERT INTO people (name, age, data) VALUES (?, ?, ?)");
stmt.execute("john", 10, vector<char>({ 'A', 'B', 'C', 'D' }));
stmt.execute("paul", 20, vector<char>({ 'E', 'B', 'G', 'H' }));
stmt.execute("mark", 15, vector<char>({ 'I', 'J', 'K', 'L' }));
stmt.execute("luke", 25, vector<char>({ 'M', 'N', 'O', 'P' }));

auto sql = "SELECT age FROM people WHERE name='john'";
auto val = db_.prepare<Int>(sql).execute_value(); // 10

auto sql = "SELECT age, name FROM people";

auto rows = db_.prepare<Int, Text>(sql).execute(); 
rows.size(); // 4

auto row = rows[3];
get<0>(row); // 25
get<1>(row); // luke

auto sql = "SELECT name FROM people WHERE age > ?";
auto stmt = db_.prepare<Text>(sql);

{
    auto rows = stmt.execute(10);
    rows.size(); // 3
    rows[0];     // paul
}

{
    auto rows = stmt.bind(10).execute();
    rows.size(); // 3
    rows[0];     // paul
}

auto sql = "SELECT id FROM people WHERE name=? AND age=?";
auto val = db_.prepare<Int>(sql).execute_value("john", 10);
val; // 1

auto sql = "SELECT name, age FROM people";
auto stmt = db_.prepare<Text, Int>(sql);

auto cursor = stmt.execute_cursor();
auto it = cursor.begin();

while (it != cursor.end()) {
    get<0>(*it); 
    get<1>(*it); 
    ++it;
}

for (const auto& x: stmt.execute_cursor()) {
    get<0>(x); 
    get<1>(x); 
}

auto sql = "SELECT name FROM people";
auto stmt = db_.prepare<Text>(sql);

auto itData = data_.begin();
for (const auto& x: stmt.execute_cursor()) {
    x;
    ++itData;
}

auto sql = "SELECT COUNT(*) FROM people";
auto val = db_.prepare<Int>(sql).execute_value();
val; // 4

auto val = db_.execute_value<Int>("SELECT COUNT(*) FROM people");
auto rows = db_.execute<Text>("SELECT name FROM people WHERE age > ?", 10);
auto rows2 = db_.execute<Int, Text>("SELECT age, name FROM people");
db_.execute("DROP TABLE IF EXISTS test;");