Advertisement
Guest User

Untitled

a guest
Jun 15th, 2019
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.07 KB | None | 0 0
  1. func openDatabase(_ databasePath: String) -> OpaquePointer? {
  2. var db: OpaquePointer? = nil
  3. if sqlite3_open(databasePath, &db) == SQLITE_OK {
  4. print("Successfully opened connection to database at (Constants.dbName)")
  5. return db
  6. } else {
  7. print("Unable to open database. Verify that you created the directory described " +
  8. "in the Getting Started section.")
  9. return nil
  10. }
  11. }
  12.  
  13. func readQuestionsFromDB(_ dbpointer: OpaquePointer) -> [Question] {
  14. let querySql = "select * from Questions;"
  15. var sqliteStatement: OpaquePointer? = nil
  16. var questions = [Question]()
  17. if sqlite3_prepare_v2(dbpointer, querySql, -1, &sqliteStatement, nil) == SQLITE_OK {
  18. // does not execute
  19. }
  20. sqlite3_finalize(sqliteStatement)
  21. return nil
  22. }
  23.  
  24. func testReadDatabase() {
  25. let sq = SQLiteManager()
  26. let db = sq.openDatabase("sociologydb")
  27. let test = sq.readQuestionsFromDB(db!)
  28. XCTAssertEqual(test.count, 1) // returns zero even when the code above is correctly filled in to populate the array
  29. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement