SQLite.Swift : https://github.com/stephencelis/SQLite.swift
let filemgr = NSFileManager.defaultManager()
let dirPaths = NSSearchPathForDirectoriesInDomains(.DocumentDirectory, .UserDomainMask, true)
let docsDir = dirPaths[0] as String
var databasePath = docsDir.stringByAppendingPathComponent("dbname.db")
let db = Database(databasePath)
let mytable = db["tablename"]
db.create(table: logs, ifNotExists: true){ t in
t.column(Expression<Int64>("id"), primaryKey: .Autoincrement)
t.column(Expression<String>("column1"), unique: false)
t.column(Expression<String>("column2"))
t.column(Expression<String>("column3"), unique: false)
}
//插入 , 返回插入的rowid
if let insertId = logs.insert( Expression<String>("column1") <- "aaaaa",Expression<String>("column2") <- "bbbbb", Expression<String>("column3") <- "ccccc") {
println("inserted id: \(insertId)")
}
//查询, 降序查询5条 "cloumn1"字段为“aaaaa”的条目
let result = mytable.filter(Expression<String>("cloumn1") == "aaaaa").order(Expression<Int64>("id").desc) .limit(5)
for log in result {
pritln(log[Expression<String>("column2")])
}