var insert_req_2 = "INSERT INTO users VALUES('Guillaume', 'xxx', 1)"
var select_req = "SELECT * FROM users"
-var db = new Sqlite3
-
-db.open(filename)
-assert sqlite_open: db.get_error == 0
+var db = new Sqlite3.open(filename)
+assert sqlite_open: db.error.is_ok
db.exec(create_req)
-assert sqlite_create_table: db.get_error == 0
+assert sqlite_create_table: db.error.is_ok
db.exec(insert_req_1)
-assert sqlite_insert_1: db.get_error == 0
+assert sqlite_insert_1: db.error.is_ok
db.exec(insert_req_2)
-assert sqlite_insert_2: db.get_error == 0
+assert sqlite_insert_2: db.error.is_ok
-db.prepare(select_req)
-assert sqlite_select: db.get_error == 0
+var stmt = db.prepare(select_req)
+assert sqlite_select: db.error.is_ok
+if stmt == null then
+ print "Prepared failed got: {db.error.to_s}"
+ abort
+end
-# Get first row
-db.step
-assert sqlite_column_0_0: db.column_text(0) == "Bob"
-assert sqlite_column_0_1: db.column_text(1) == "zzz"
-assert sqlite_column_0_2: db.column_text(2) == "1"
-db.step
-assert sqlite_column_1_0: db.column_text(0) == "Guillaume"
-assert sqlite_column_1_1: db.column_text(1) == "xxx"
-assert sqlite_column_1_2: db.column_text(2) == "1"
+while stmt.step.is_row do
+ print stmt.column_text(0)
+ print stmt.column_text(1)
+ print stmt.column_text(2)
+end
db.close
-db = new Sqlite3
-db.open(filename)
-assert sqlite_reopen: db.get_error == 0
+db = new Sqlite3.open(filename)
+assert sqlite_reopen: db.error.is_ok
-db.prepare(select_req)
-assert sqlite_reselect: db.get_error == 0
-db.step
-assert sqlite_column_0_0_reopened: db.column_text(0) == "Bob"
+stmt = db.prepare(select_req)
+assert sqlite_reselect: db.error.is_ok
+assert stmt != null
+stmt.step
+assert sqlite_column_0_0_reopened: stmt.column_text(0) == "Bob"