SQLite 쿼리 실행
/*SQLite*/ //로컬에서 데이터 저장경로 //let db = try Connection("/Users/goodgods/Documents/development/MyApp/db.sqlite3") // Get document directory path from your phone -> 모바일에서 경로찾아 저장함 let path = NSSearchPathForDirectoriesInDomains(.DocumentDirectory, .UserDomainMask, true)[0] as String do { let db = try Connection("\(path)/db.sqlite3")
let users = Table("users") let id = Expression<String>("id")
try db.run(users.create(ifNotExists: true) { t in // CREATE TABLE "users" ( t.column(id, primaryKey: true) // "id" INTEGER PRIMARY KEY NOT NULL, // t.column(email, unique: true) // "email" TEXT UNIQUE NOT NULL, // t.column(name) // "name" TEXT })
try db.run(users.delete()) try db.run(users.insert(id <- authorizationCode!)) } catch let error as NSError { } |