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
-while db.step.is_row do
- print db.column_text(0)
- print db.column_text(1)
- print db.column_text(2)
+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"