 let rdbc = RDBC()
 rdbc.register(driver: SQLiteDriver())
 
-rdbc.pool(url: "sqlite:///tmp/crlrsdc.sqlite")
-    .execute(query: "SELECT * FROM test1;", parameters: [], named: [:]).flatMap{$0}
+let pool = rdbc.pool(url: "sqlite:///tmp/crlrsdc.sqlite")
+
+pool.execute(query: "SELECT * FROM test1;", parameters: [], named: [:]).flatMap{$0}
 .flatMap { results in
     results.columns.zip(results.all())
 }.onSuccess { (cols, rows) in

import Future

import RDBC

//let driver = SQLiteDriver()
//let connection = try driver.connect(url: "sqlite:///tmp/crlrsdc.sqlite", params: [:])

    }
}.onFailure { e in
    print("!!!Error:", e)
}

pool
    .select(["id", "firstname"], from: "test1")
    .where("firstname" == "Daniel" && "lastname" == "Leping")
    .execute().flatMap{$0}
    .flatMap { results in
        results.columns.zip(results.all())
    }.onSuccess { (cols, rows) in
        print(cols)
        for row in rows {
            print(row)
        }
    }.onFailure { e in
        print("!!!Error:", e)
}

/*
