Swift 2 SQLite.swift module reference

Question

Since I have updated to Xcode 7 and swift 2, I'm getting this errors:

No type named 'Query' in module 'SQLite' Use of undeclared type 'Database'

using this code:

let table:SQLite.Query

init(db:Database){

    table = db["BucketType"]
}

I'm using the swift2 branch of SQLite.swift, but it looks like my project, it can't find the reference SQLite.swift module. Also have import SQLite on every file I use SQLite.swift with. I've tried the manual integration and the cocoa pods, but with the same results.

It was working with Xcode 6.4.

Answer 1

I have something like this...

class DBHelper {

static let instance = DBHelper() // singleton

var db : Connection

init() {
    do {
        self.db = try Connection("\(Util.getDBPath())/db.sqlite3")
        createTablesIfNotExists()
    } catch {
        Logger.error("Could not create a connection to database")
    }
}

func createTablesIfNotExists() {

    // Logs

    let logs = Table(TLog.TABLE_NAME) // just the name of your table
    do {
        try db.run(logs.create(ifNotExists: true) { t in
                t.column(TLog.ID, primaryKey: true) // Expression<Int>("id")
                t.column(TLog.TS) // Expression<String>("ts")
                t.column(TLog.TAG) // Expression<String>("tag")
                t.column(TLog.TYPE) ...
                t.column(TLog.CONTENT) ...
        })
    } catch {
        Logger.error("Could not create table Logs")
    }

}

And.. Util.getDBPath would be...

import SystemConfiguration

class Util {

class func getDBPath() -> String {
    let path = NSSearchPathForDirectoriesInDomains(
        .DocumentDirectory, .UserDomainMask, true
    ).first

    return path!
}

}

Hope this help you.