Swift SQLite 예제

iphone 앱을 개발할 때 SQLite를 사용하여 데이터를 저장할 수 있다.

 

1. DB파일 생성

private func createSQLiteFile() {
let fileURL = try! FileManager.default.url(for: .documentDirectory, in: .userDomainMask, appropriateFor: nil, create: false)
.appendingPathComponent(“db.sqlite”)
if sqlite3_open(fileURL.path, &db) != SQLITE_OK {
print(“error opening database”)
}else{
print(“SUCESS opening database”)
}
}

 

2. 데이터 insert

let queryString = “INSERT INTO tb1 (a, b,c,d) VALUES (?,?,?,?)”
private func insertInto(queryString:String ,a :NSString, b:NSString,c:NSString, d : NSString){
var insertStatement: OpaquePointer? = nil
if sqlite3_prepare_v2(db, queryString, -1, &insertStatement, nil) == SQLITE_OK {
let title: NSString = a
let message: NSString = b
let type: NSString = c
let date: NSString = d
sqlite3_bind_text(insertStatement, 1, a.utf8String, -1, nil)
sqlite3_bind_text(insertStatement, 2, b.utf8String, -1, nil)
sqlite3_bind_text(insertStatement, 3, c.utf8String, -1, nil)
sqlite3_bind_text(insertStatement, 4, d.utf8String, -1, nil)
if sqlite3_step(insertStatement) == SQLITE_DONE {
print("Successfully inserted row.")
} else {
print("Could not insert row.")
}
} else {
print("INSERT statement could not be prepared.")
}
// 5
sqlite3_finalize(insertStatement)
}