I'm using GRDB library for Swift Sqlite.
I create a class for connection:
import GRDB
var dbQueue: DatabaseQueue!
func setupDatabase() {
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)
}
I call the class in the method:
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
}
The app returns: fatal error: unexpectedly found nil while unwrapping an Optional value
0x1009f8764 <+36>: mov x4, x5 0x1009f8768 <+40>: bl 0x100a3add0 ; function signature specialization of Swift.(_fatalErrorMessage (Swift.StaticString, Swift.StaticString, Swift.StaticString, Swift.UInt) -> ()).(closure #2)
someone can give me suggestions? thanks
Aucun commentaire:
Enregistrer un commentaire