SQLite in iOS
SQL in iOS
SQLite
- open
- prepare
- step
- finalize
- close
execute an SQL query, it must first be compiled into a byte-code program
```sqlite3_exec() = ‘ sqlite3_prepare_v2(), sqlite3_step(), and sqlite3_finalize(),’
//Open
if (sqlite3_open((self.databasePath as NSString).UTF8String, &mySqliteDB) == SQLITE_OK) {
}
//Close
sqlite3_close(mySqliteDB)
//Execute SQL
if (sqlite3_exec(mySqliteDB, (query as NSString).UTF8String, nil, nil, &errMsg) != SQLITE_OK) {}
var stmt:COpaquePointer = nil
if(sqlite3_prepare_v2(mySqliteDB, (selectSql as NSString).UTF8String, -1, &stmt, nil) == SQLITE_OK) {
if(sqlite3_step(stmt) == SQLITE_ROW) {
rowid = String(sqlite3_column_int(stmt, 0))
}
sqlite3_finalize(stmt)
}
sqlite3_close(mySqliteDB)