Database

1. Connect
2. Create table
3. Delete table
4. Insert objects
5. Query objects
6. Transactions

Connect

To connect to database create its object and connect it with standard connection string:

orm::Database database;
database.connect("sqlite3://test.db");

Create table

To create table in database use createTable method and pass model as template argument:

struct ObjectModel
{
    int id;
    std::string name;
    std::string email;
    std::string password;
    std::string created_at;
    std::string updated_at;
};
 
database.createTable<ObjectModel>();

Delete table

To delete table from database use deleteTable method and pass model as template argument:

database.deleteTable<ObjectModel>();

Insert objects

To insert objects into database use insert method and pass vector of objects as argument:

std::vector<ObjectModel> objects{
    {1, "name", "email", "password", "created_at", "updated_at"}, 
    {2, "name2", "email2", "password2", "created_at2", "updated_at2"}
};
 
database.insert(objects);

You can also insert single object:

ObjectModel object{1, "name", "email", "password", "created_at", "updated_at"};
 
database.insert(object);

Query objects

To select objects from database use select method and pass select as argument:

orm::Query<ObjectModel> query;
 
auto queriedObjects = database.select(query);

Transactions

To use transaction use database's transactionBegin method followed by transactionCommit or transactionRollback:

database.transactionBegin();
 
database.insert(objects);
 
database.transactionCommit();

or:

database.transactionBegin();
 
database.insert(objects);
 
database.transactionRollback();