module sample;
import taskdesigns.sqlite;
import std.stdio;

void main()
{
    auto users = new Table("novels");

    writeln(users.create( (it) {
        auto id = new Column!int("id");
        auto name = new Column!string("name");
        auto email = new Column!string("email");
        it.column(id, true, false, true);
        it.column(name);
        it.column(email);
    }).asSQL());
    writeln(users.insert( (it) {
        auto name = new Column!string("name");
        auto email = new Column!string("email");
        it[name] = "John Smith";
        it[email] = "john.smith@example.com";
    }).asSQL());
    auto email = new Column!string("email");
    writeln(users.select().where(email.eq("john.smith@example.com")).asSQL());
}