SQLite.Swift 中的一些用法

標籤：

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")])        }

 

        

SQLite.Swift 中的一些用法