samedi 25 juillet 2015

FMDB working with two tables - Swift

I suspect I'm doing something intrinsically wrong. I need multiple tables in my App. To achieve this I'm setting up two connections as shown below. The first Database works fine but when I try and update a record and get the result back to verify in the second it doesn't.

DatabaseLocationsFunctions.swift

let sharedInstanceLocations         = DatabaseLocationsFunctions()
class DatabaseLocationsFunctions: NSObject {
var database: FMDatabase? = nil
class var instanceLocations: DatabaseLocationsFunctions {
    sharedInstanceLocations.database = FMDatabase(path: Utilities.getPath("S1231.sqlite"))
    var path = Utilities.getPath("S123.sqlite")
    return sharedInstanceLocations
}

and

DatabaseSettingsFunctions.swift

let sharedInstanceSettings         = DatabaseSettingsFunctions()
class DatabaseSettingsFunctions: NSObject {
var databaseSettings: FMDatabase? = nil
class var instanceSettings: DatabaseSettingsFunctions {
    sharedInstanceSettings.databaseSettings = FMDatabase(path: Utilities.getPath("settings1.sqlite"))
    var path = Utilities.getPath("settings1.sqlite")
    return sharedInstanceSettings
}

Using calls along the lines of:

var isInserted      = DatabaseLocationsFunctions.instanceLocations.addLocationRecord(locationRecord) 

locationRecordID    = DatabaseSettingsFunctions.instanceSettings.getSettingsLocationSelectedRecord()

Both databases create correctly and say they accept data via an Update. The original database works, the second doesn't. Do I need to create tables as part of the same Database, and if so how? Any ideas?

Aucun commentaire:

Enregistrer un commentaire