X-Git-Url: http://nitlanguage.org diff --git a/tests/test_sqlite3.nit b/tests/test_sqlite3.nit index b012a6f..6ddb8a7 100644 --- a/tests/test_sqlite3.nit +++ b/tests/test_sqlite3.nit @@ -26,36 +26,38 @@ var insert_req_1 = "INSERT INTO users VALUES('Bob', 'zzz', 1)" 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"