GRBD Swift Sqlite公司

Question

我在用GRDB库做Swift Sqlite。

我创建了一个连接类：

导入 GRDB

var dbQueue:数据库队列！

函数设置数据库（）{

var config = Configuration()
config.readonly = true
config.foreignKeysEnabled = true
config.trace = { print($0)}



let databasePath = NSBundle.mainBundle().pathForResource("mydb", ofType: "sqlite")!

dbQueue = try! DatabaseQueue(path: databasePath, configuration:  config)

}

我在方法中调用该类:

func trovaCitta(luogoNascita: String)->CittaVO{

    let citta:CittaVO = CittaVO()


    dbQueue.inDatabase { db in

        for row in Row.fetch(db, "SELECT * FROM comune where cod_catastale='" + luogoNascita + "'") {
            citta.codIstat = row.value(named: "cod_istat")
            citta.nome = row.value(named: "nome")

                    citta.codProvincia = row.value(named: "cod_provincia")
                    citta.codValidita = row.value(named: "cod_validita")
                    citta.codCap = row.value(named: "cod_cap")
                    citta.codCatastale = row.value(named: "cod_catastale")
          //  print(citta)
        }

    }

    return citta
}

应用程序返回：致命错误：在展开可选值时意外发现nil

0x1009f8764个

有人能给我建议吗？谢谢

Answer 1

我在SQLite上运气更好。swift框架，而不是GRDB。