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.stringbyappendingpathco Mponent ("dbname.db") Let db = Database (databasepath) Let mytable = db["tablename"] db.create (table:l OGs, ifnotexists:true) {T in T.column (expression<int64> ("id"), PrimaryKey:. AutoIncrement) T.column (expression<string> ("Column1"), Unique:false) T.column (expression<s Tring> ("Column2")) T.column (expression<string> ("Column3"), Unique:false)}//INSERT, return the inserted rowID if let Insertid = Logs.insert (expression<string> ("Column1") <-"AAAAA",expression<string> ("Col Umn2 ") <-" bbbbb ", expression<string> (" Column3 ") <-" CCCCC ") {println (" inserted ID: \ (insertid) ") }//query, descending query 5 "cloumn1"The entry with the field "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")})}
Some usages in Sqlite.swift