Cannot make Connection to SQLite database Swift 3

Question

i'm using SQLite Library and in usage it says let db = try Connection("path/to/db.sqlite3") i have sqlite database located in documents. but when i try to make connection it throw an error call can throw but errors cannot be thrown out of a property initializer

here's my code :

import UIKit
import SQLite

class SearchViewController: UIViewController, UITextFieldDelegate {

let db = try Connection("/Users/macbookpro/Documents/db.sqlite") //error
let categoryVC = CategoryViewController()
let UseFullVC = UseFullViewController()
let MapVC = MapViewController()
let EventVC = SearchResultOnlineVC()

@IBOutlet weak var searchTextField: UITextField!

override func viewDidLoad() {
    super.viewDidLoad()

    self.title = "Search"

    searchTextField.delegate = self
}

override func didReceiveMemoryWarning() {
    super.didReceiveMemoryWarning()
}
}

i also try to put connection in viewDidLoad but still doesn't work

what's wrong?

why cant you go with the FMDB, why using raw sqlite ?

vaibhav
– vaibhav

2017-01-27 09:23:19 +00:00
Commented Jan 27, 2017 at 9:23 — vaibhav
– vaibhav, Commented Jan 27, 2017 at 9:23

Klaus Byskov Pedersen · Accepted Answer · 2017-01-27 11:54:12Z

1

Since the Connection initializer can throw an exception, you need to call it in a do/catch block.

So you should change the declaration to:

var db : Connection?

And initialize it in ViewDidLoad:

do{
    self.db = try Connection("/Users/macbookpro/Documents/db.sqlite")
} catch {
    print("Unable to create connection: \(error)")
}

edited Jan 27, 2017 at 11:54

answered Jan 27, 2017 at 9:58

Klaus Byskov Pedersen

122k31 gold badges192 silver badges223 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Sumona Salma · Accepted Answer · 2018-09-26 13:25:24Z

0

import UIKit
import SQLite

let sharedInstance = DBModelManager()

class DBModelManager: NSObject {
  var database: Connection!

 class func getInstance() -> DBModelManager
 {
     if(sharedInstance.database == nil)
     {
         do{
             let documentDirectory = try FileManager.default.url(for: .documentDirectory, in: .userDomainMask, appropriateFor: nil, create: true)
             let fileUrl = documentDirectory.appendingPathComponent("dbname").appendingPathExtension("sqlite3")
             sharedInstance.database = try Connection(fileUrl.path)

         }catch{
             print("DB Error \(error)")
         }
     }
     return sharedInstance
  }
}

Call DB instance this way

try DBModelManager.getInstance().database!.prepare()

edited Sep 26, 2018 at 13:25

answered Sep 26, 2018 at 13:16

Sumona Salma

1372 silver badges14 bronze badges

Collectives™ on Stack Overflow

Cannot make Connection to SQLite database Swift 3

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related