#include "libsqlite.hpp"
#include <iostream>
#include <string>

class DataBase {
    public int tryDatabase() {
        std::string sqliteFile = "osg";
        try {
            sqlite::sqlite db( sqliteFile );
            auto cur = db.get_statement();

            std::cout << "connected to database" << std::endl;
            cur->set_sql("insert into players values ('5', 'qw');");
            // cur->set_sql("CREATE TABLE asda (player_id NUMBER(4) PRIMARY KEY, playerName CHAR(16))");
            // cur->prepare();
            // cur->set_sql("desc asda");
            cur->prepare();
            while( cur->step()) {
                std::cout << cur->get_int(0) << std::endl;
            }
        }
        catch ( sqlite::exception e ) {
            std::cerr << e.what() << std::endl;
            return 1;
        }
        return 0;
    }
};

int main() {

        DataBase db;
        db.tryDatabase();

        return 0;
    }