- 授权协议: MIT
- 开发语言: Swift
- 操作系统: iOS
- 软件首页: https://github.com/colatusso/canDB.swift
软件介绍
canDB.swift 是一个框架，作用类似 nonSQL 的数据库，但运作在 sqlite(FMDB) 。
// loading the json
let filePath = NSBundle.mainBundle().pathForResource("data", ofType:"json") let data = NSData(contentsOfFile:filePath!, options:NSDataReadingOptions.DataReadingUncached, error:nil) let dataArray:Array = NSJSONSerialization.JSONObjectWithData(data!, options: NSJSONReadingOptions.allZeros, error: nil) as! Array<Dictionary<String, String>>
// singleton instance
let storeInstance = canDB.sharedInstance // saving the data, the can is automatically created if not exists
storeInstance.saveData("Person", data: dataArray, idString: kCanDBDefaultIdString, error: nil) // adding the index for future queries and reindexing the table
storeInstance.addIndex("Person", indexes: ["Name"], error: nil)
storeInstance.reIndex("Person", idString: kCanDBDefaultIdString) let result = storeInstance.loadData("Person") for item in result { for (key, value) in (item as! NSDictionary) {
println("\(key): \(value)")
}
} // custom query using the previous created index "Name"
let resultWithQuery = storeInstance.loadDataWithQuery("SELECT * FROM Person WHERE Name='John'") for item in resultWithQuery { for (key, value) in (item as! NSDictionary) {
println("\(key): \(value)")
}
}
storeInstance.removeDataForId("Person", idString: kCanDBDefaultIdString, idsToDelete: ["17", "19"], error: nil)
