Programming/Swift

SQLite 쿼리 실행

평생초보 2016. 3. 16. 17:13
반응형


/*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 {


}


반응형