import std.stdio;
import std.string;

import ddbc.common;
import ddbc.core;
import ddbc.drivers.sqliteddbc;

import etc.c.sqlite3;

void main(){

    SQLITEDriver driver = new SQLITEDriver();


    // creating Connection
    auto conn = driver.connect("IP.db", null);
    scope(exit) conn.close();

    // creating Statement
    auto stmt = conn.createStatement();
    scope(exit) stmt.close();

    // execute simple queries to create and fill table
    stmt.executeUpdate("CREATE TABLE IF NOT EXISTS ddbct1 (id bigint not null primary key AUTO_INCREMENT, name varchar(250), comment mediumtext, ts datetime)");
    stmt.executeUpdate("INSERT INTO ddbct1 SET id=1, name='name1', comment='comment for line 1', ts='20130202123025'");
    stmt.executeUpdate("INSERT INTO ddbct1 SET id=2, name='name2', comment='comment for line 2 - can be very long'");

    // reading DB
    auto rs = stmt.executeQuery("SELECT id, name name_alias, comment, ts FROM ddbct1 ORDER BY id");
    while (rs.next())
        writeln(rs.getLong(1) , "\t" , rs.getString(2) , "\t" , rs.getString(3));
}