Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- func openDatabase(_ databasePath: String) -> OpaquePointer? {
- var db: OpaquePointer? = nil
- if sqlite3_open(databasePath, &db) == SQLITE_OK {
- print("Successfully opened connection to database at (Constants.dbName)")
- return db
- } else {
- print("Unable to open database. Verify that you created the directory described " +
- "in the Getting Started section.")
- return nil
- }
- }
- func readQuestionsFromDB(_ dbpointer: OpaquePointer) -> [Question] {
- let querySql = "select * from Questions;"
- var sqliteStatement: OpaquePointer? = nil
- var questions = [Question]()
- if sqlite3_prepare_v2(dbpointer, querySql, -1, &sqliteStatement, nil) == SQLITE_OK {
- // does not execute
- }
- sqlite3_finalize(sqliteStatement)
- return nil
- }
- func testReadDatabase() {
- let sq = SQLiteManager()
- let db = sq.openDatabase("sociologydb")
- let test = sq.readQuestionsFromDB(db!)
- XCTAssertEqual(test.count, 1) // returns zero even when the code above is correctly filled in to populate the array
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement