<\/a>
1)<\/b> \u0414\u043e\u0431\u0430\u0432\u044c\u0442\u0435 ‘libsqlite3’ \u0441\u0442\u0430\u043d\u0434\u0430\u0440\u0442\u043d\u0443\u044e \u0431\u0438\u0431\u043b\u0438\u043e\u0442\u0435\u043a\u0443 \u0432 \u043d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0430\u0445 \u043f\u0440\u043e\u0435\u043a\u0442\u0430 \u0438 \u0441\u043a\u043e\u043f\u0438\u0440\u0443\u0439\u0442\u0435 FMDB \u0444\u0430\u0439\u043b\u044b \u0432 \u0432\u0430\u0448 \u043f\u0440\u043e\u0435\u043a\u0442. (\u0434\u0430, \u043e\u043d\u0438 \u043d\u0430 objective-c).<\/p>\n 2)<\/b> \u0421\u043e\u0437\u0434\u0430\u0439\u0442\u0435 \u043d\u043e\u0432\u044b\u0439 \u0444\u0430\u0439\u043b, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u0431\u0443\u0434\u0435\u0442 \u043d\u0430\u0437\u044b\u0432\u0430\u0442\u044c\u0441\u044f \u00abFMDB-Bridging-Header.h\u00bb. \u0412\u043d\u0443\u0442\u0440\u0438 \u00abBridging-Header.h\u00bb \u043d\u0430\u043f\u0438\u0448\u0438\u0442\u0435 \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0435\u0435: #import \u00abFMDB.h\u00bb.<\/p>\n
3)<\/b> \u0417\u0430\u0439\u0434\u0438\u0442\u0435 \u0432 Build Settings -> Swift Compiler \u2014 Code Generation \u0438 \u0434\u043e\u0431\u0430\u0432\u044c\u0442\u0435 \u043a ‘Objective-C Bridging Header’: FMDB-Bridging-Header.h.<\/p>\n
\u0415\u0441\u043b\u0438 \u0444\u0430\u0439\u043b \u0432 \u043f\u0430\u043f\u043a\u0435 \u0432\u0430\u0448\u0435\u0433\u043e \u043f\u0440\u043e\u0435\u043a\u0442\u0430, \u0442\u043e \u0442\u0430\u043a: \u0418\u041c\u042f_\u041f\u0410\u041f\u041a\u0418\/FMDB-Bridging-Header.h<\/p>\n
4)<\/b> \u0421\u043a\u043e\u043f\u0438\u0440\u0443\u0439\u0442\u0435 \u0432 \u0412\u0430\u0448 \u043f\u0440\u043e\u0435\u043a\u0442 SQLite database. \u0412 \u044d\u0442\u043e\u043c \u0433\u0430\u0439\u0434\u0435 \u044f \u0431\u0443\u0434\u0443 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c \u043d\u0430\u0437\u0432\u0430\u043d\u0438\u0435 ‘tempdb.sqlite’ \u0432\u0441\u0435\u0433\u043e \u043b\u0438\u0448\u044c \u0441 \u043e\u0434\u043d\u043e\u0439 \u0442\u0430\u0431\u043b\u0438\u0446\u0435\u0439 \u0432\u043d\u0443\u0442\u0440\u0438:<\/p>\n
CREATE TABLE test_tb ( test_id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT, keywordtext TEXT)<\/p>\n
5) <\/b>\u0412 \u0432\u0430\u0448\u0435\u043c AppDelegate.swift’s class AppDelegate \u0434\u043e\u0431\u0430\u0432\u044c\u0442\u0435 \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u0435 \u043f\u0435\u0440\u0435\u043c\u0435\u043d\u043d\u044b\u0435: var dbFilePath: NSString = NSString()<\/p>\n
\u041f\u0440\u0438\u043c\u0435\u0440: <\/p>\n
import UIKit @UIApplicationMain class AppDelegate: UIResponder, UIApplicationDelegate { var window: UIWindow? var navi: UINavigationController? var dbFilePath: NSString = NSString() func application(application: UIApplication, didFinishLaunchingWithOptions launchOptions: NSDictionary?) -> Bool { .... <\/code><\/pre>\n 6)<\/b> \u0414\u043e\u0431\u0430\u0432\u044c\u0442\u0435 \u044d\u0442\u043e\u0442 \u043c\u0435\u0442\u043e\u0434 \u0432 AppDelegate.swift’s class AppDelegate:<\/p>\n\/\/ MARK: - FMDB \u00a0 let DATABASE_RESOURCE_NAME = "tempdb" let DATABASE_RESOURCE_TYPE = "sqlite" let DATABASE_FILE_NAME = "tempdb.sqlite" \u00a0 func initializeDb() -> Bool { let documentFolderPath = NSSearchPathForDirectoriesInDomains(.DocumentDirectory, .UserDomainMask, true)[0] as String \u00a0 let dbfile = "\/" + DATABASE_FILE_NAME; \u00a0 self.dbFilePath = documentFolderPath.stringByAppendingString(dbfile) \u00a0 let filemanager = NSFileManager.defaultManager() if (!filemanager.fileExistsAtPath(dbFilePath) ) { \u00a0 let backupDbPath = NSBundle.mainBundle().pathForResource(DATABASE_RESOURCE_NAME, ofType: DATABASE_RESOURCE_TYPE) \u00a0 if (backupDbPath == nil) { return false } else { var error: NSError? let copySuccessful = filemanager.copyItemAtPath(backupDbPath, toPath:dbFilePath, error: &error) if !copySuccessful { println("copy failed: \\(error?.localizedDescription)") return false } \u00a0 } \u00a0 } return true \u00a0 } <\/code><\/pre>\n 7)<\/b> \u0412\u044b\u0437\u043e\u0432\u0438\u0442\u0435 \u0432 AppDelegate.swift’s func application:<\/p>\nfunc application(application: UIApplication, didFinishLaunchingWithOptions launchOptions: NSDictionary?) -> Bool { if self.initializeDb() { NSLog("Successful db copy") } <\/code><\/pre>\n 8)<\/b> \u0412 \u044d\u0442\u043e\u043c \u043f\u0440\u0438\u043c\u0435\u0440\u0435 \u043c\u044b \u0440\u0430\u0431\u043e\u0442\u0430\u0435\u043c \u0441 \u0434\u0430\u043d\u043d\u044b\u043c\u0438 UITableViewController) \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044f FMDB:<\/p>\nimport UIKit \u00a0 class SecondViewController: UIViewController { \u00a0 \/\/ MARK: - .H \u00a0 @IBOutlet var dataTable: UITableView? var dataArray:[MultiField] = [] \u00a0 \/\/ MARK: - .M \u00a0 required init(coder: NSCoder) { fatalError("NSCoding not supported") } \u00a0 override init(nibName nibNameOrNil: String?, bundle nibBundleOrNil: NSBundle?) { super.init(nibName: nibNameOrNil, bundle: nibBundleOrNil) \/\/ Custom initialization } \u00a0 override func viewDidLoad() { super.viewDidLoad() \u00a0 \/\/ Do any additional setup after loading the view. self.title = "FMDB Using Swift" \u00a0 let mainDelegate: AppDelegate = UIApplication.sharedApplication().delegate as AppDelegate \u00a0 \/\/ initialize FMDB let db: FMDatabase = FMDatabase(path:mainDelegate.dbFilePath) if (db.open() == nil) { NSLog("error opening db") } \u00a0 \/\/ \u0432\u0441\u0442\u0430\u0432\u043a\u0430 \u0434\u0430\u043d\u043d\u044b\u0445 let addQuery = "INSERT INTO test_tb (name, keywordtext) VALUES ('excalibur', 'hot')" let addSuccessful = db.executeUpdate(addQuery, withArgumentsInArray: nil) if !addSuccessful { println("insert failed: \\(db.lastErrorMessage())") } \/\/ \u0432\u0441\u0442\u0430\u0432\u043a\u0430 \u0434\u0430\u043d\u043d\u044b\u0445 - \u043a\u043e\u043d\u0435\u0446 \u00a0 \/\/ update \u0434\u0430\u043d\u043d\u044b\u0445 let updateQuery = "UPDATE test_tb SET keywordtext = 'cool' WHERE name = 'excalibur' " let updateSuccessful = db.executeUpdate(updateQuery, withArgumentsInArray: nil) if !updateSuccessful { println("update failed: \\(db.lastErrorMessage())") } \/\/ update \u0434\u0430\u043d\u043d\u044b\u0445 - \u043a\u043e\u043d\u0435\u0446 \u00a0 \/\/ \u041f\u043e\u043b\u0443\u0447\u0435\u043d\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 \u0438\u0437 \u043d\u0430\u0448\u0435\u0439 \u0431\u0430\u0437\u044b \u0438 \u0441\u043e\u0445\u0440\u0430\u043d\u0435\u043d\u0438\u0435 \u0438\u0445 \u0432 \u043c\u0430\u0441\u0441\u0438\u0432 UITableView let mainQuery = "SELECT name, keywordtext FROM test_tb" let rsMain: FMResultSet? = db.executeQuery(mainQuery, withArgumentsInArray: []) \u00a0 while (rsMain!.next() == true) { let productName = rsMain?.stringForColumn("name") let keywords = rsMain?.stringForColumn("keywordtext") \u00a0 let multiField = MultiField(aField1: productName!, aField2: keywords!) self.dataArray.append(multiField) \u00a0 } \/\/ \u043f\u043e\u043b\u0443\u0447\u0435\u043d\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 - \u043a\u043e\u043d\u0435\u0446 \u00a0 \/\/ \u0443\u0434\u0430\u043b\u0435\u043d\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 let delQuery = "DELETE FROM test_tb WHERE name = 'excalibur' " let deleteSuccessful = db.executeUpdate(delQuery, withArgumentsInArray: nil) if !deleteSuccessful { println("delete failed: \\(db.lastErrorMessage())") } \/\/ \u0443\u0434\u0430\u043b\u0435\u043d\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 - \u043a\u043e\u043d\u0435\u0446 \u00a0 \/\/ \u043f\u0440\u0438\u043c\u0435\u0440: \u043f\u043e\u043b\u0443\u0447\u0435\u043d\u0438\u0435 \u043d\u043e\u043c\u0435\u0440 \u0441\u0442\u0440\u043e\u043a let rsTemp: FMResultSet? = db.executeQuery("SELECT count(*) AS numrows FROM test_tb", withArgumentsInArray: []) rsTemp!.next() let numrows = rsTemp?.intForColumn("numrows") \u00a0 NSLog("numrows: \\(numrows)") \/\/\u043f\u0440\u0438\u043c\u0435\u0440: \u043f\u043e\u043b\u0443\u0447\u0435\u043d\u0438\u0435 \u043d\u043e\u043c\u0435\u0440 \u0441\u0442\u0440\u043e\u043a\u0438 - \u043a\u043e\u043d\u0435\u0446 \u00a0 db.close() \u00a0 } \u00a0 override func didReceiveMemoryWarning() { super.didReceiveMemoryWarning() \/\/ Dispose of any resources that can be recreated. } \u00a0 \/\/ MARK: - TableView DataSource \u00a0 func numberOfSectionsInTableView(tableView: UITableView!) -> Int { return 1 } \u00a0 func tableView(tableView: UITableView!, numberOfRowsInSection section: Int) -> Int { \u00a0 return self.dataArray.count } \u00a0 func tableView(tableView: UITableView!, cellForRowAtIndexPath indexPath: NSIndexPath!) -> UITableViewCell! { \u00a0 let cell: UITableViewCell = UITableViewCell(style: UITableViewCellStyle.Subtitle, reuseIdentifier: "FMDBTest") \u00a0 let multiField: MultiField = self.dataArray[indexPath.row] \u00a0 let num = indexPath.row + 1 \u00a0 cell.textLabel.text = "\\(num). \\(multiField.field1!)" cell.detailTextLabel.text = multiField.field2 \u00a0 return cell } \/\/ MARK: - UITableViewDelegate \u00a0 func tableView(tableView: UITableView!, didSelectRowAtIndexPath indexPath: NSIndexPath!) { tableView.deselectRowAtIndexPath(indexPath, animated: true) } }<\/code><\/pre>\n 9)<\/b> \u041d\u0435\u043c\u043d\u043e\u0433\u043e \u0440\u0430\u0437\u043d\u044b\u0445 \u0444\u0438\u0448\u0435\u043a, \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0435 \u043c\u0443\u043b\u044c\u0442\u0438\u043f\u043e\u0442\u043e\u043a\u0430 FMDB \u0447\u0435\u0440\u0435\u0437 FMDatabaseQueue.<\/p>\nvar queue: FMDatabaseQueue? \u00a0 func testDatabaseQueue() { let documentsFolder = NSSearchPathForDirectoriesInDomains(.DocumentDirectory, .UserDomainMask, true)[0] as String let databasePath = documentsFolder.stringByAppendingPathComponent("test.sqlite") \u00a0 queue = FMDatabaseQueue(path: databasePath) \u00a0 \/\/ \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u0442\u0430\u0431\u043b\u0438\u0446\u044b <source lang="objectivec">\u00a0 queue?.inDatabase() { db in \u00a0 var success = db.executeUpdate("create table test (id integer primary key autoincrement, a text)", withArgumentsInArray:nil) \u00a0 if !success { println("table create failure: \\(db.lastErrorMessage())") return } } <\/code><\/pre>\n \/\/ \u0432\u0441\u0442\u0430\u0432\u043a\u0430 \u043f\u044f\u0442\u0438 \u0441\u0442\u0440\u043e\u043a<\/p>\n
queue?.inTransaction() { db, rollback in \u00a0 for i in 0 ..< 5 { if !db.executeUpdate("insert into test (a) values (?)", withArgumentsInArray: ["Row \\(i)"]) { println("insert \\(i) failure: \\(db.lastErrorMessage())") rollback.initialize(true) return } } }<\/code><\/pre>\n \u00a0 \/\/\u0434\u0430\u0432\u0430\u0439\u0442\u0435 \u043f\u043e\u043f\u0440\u043e\u0431\u0443\u0435\u043c \u0432\u0441\u0442\u0430\u0432\u0438\u0442\u044c \u0441\u0442\u0440\u043e\u043a\u0438, \u043d\u043e \u0441\u043e\u0437\u043d\u0430\u0442\u0435\u043b\u044c\u043d\u043e \u043e\u0448\u0438\u0431\u0435\u043c\u0441\u044f \u0438 \u043f\u043e\u0441\u043c\u043e\u0442\u0440\u0438\u043c, \u0447\u0442\u043e \u043e\u043d \u043e\u0442\u043a\u0430\u0442\u044b\u0432\u0430\u0435\u0442 \u043f\u0440\u0430\u0432\u0438\u043b\u044c\u043d\u043e<\/p>\n
queue?.inTransaction() { db, rollback in \u00a0 for i in 5 ..< 10 { let success = db.executeUpdate("insert into test (a) values (?)", withArgumentsInArray: ["Row \\(i)"]) \u00a0 if !success { println("insert \\(i) failure: \\(db.lastErrorMessage())") rollback.initialize(true) return } \u00a0 if (i == 7) { rollback.initialize(true) } } }<\/code><\/pre>\n \/\/ \u043f\u0440\u043e\u0432\u0435\u0440\u0438\u043c, \u0447\u0442\u043e \u0442\u043e\u043b\u044c\u043a\u043e \u043f\u0435\u0440\u0432\u044b\u0435 \u043f\u044f\u0442\u044c \u0441\u0442\u0440\u043e\u043a \u0442\u0430\u043c<\/p>\n
queue?.inDatabase() { db in \u00a0 if let rs = db.executeQuery("select * from test", withArgumentsInArray:nil) { \u00a0 while rs.next() { println(rs.resultDictionary()) } } else { println("select failure: \\(db.lastErrorMessage())") } \u00a0 } <\/code><\/pre>\n\u00a0
\/\/ \u0443\u0434\u0430\u043b\u044f\u0435\u043c \u0442\u0430\u0431\u043b\u0438\u0446\u0443<\/p>\n
\u00a0<\/p>\n
queue?.inDatabase() { db in \u00a0 let success = db.executeUpdate("drop table test", withArgumentsInArray:nil) \u00a0 if !success { println("table drop failure: \\(db.lastErrorMessage())") return } } } <\/code><\/pre>\n 10)<\/b> \u0421\u0442\u0430\u043d\u0434\u0430\u0440\u0442\u043d\u043e\u0433\u043e \u043d\u0430 \u0437\u0430\u043a\u0443\u0441\u043a\u0443. \u0418\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0435 \u043a\u043b\u0430\u0441\u0441\u0430 executeUpdate(values:) \u0432 Swift2:<\/p>\ndo { let identifier = 42 let name = "Liam O'Flaherty (\\"the famous Irish author\\")" let date = NSDate() let comment: String? = nil try db.executeUpdate("INSERT INTO authors (identifier, name, date, comment) VALUES (?, ?, ?, ?)", values: [identifier, name, date, comment ?? NSNull()]) } catch { print("error = \\(error)") } <\/code><\/pre>\n \u0418\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0435 queue:<\/p>\n
queue.inTransaction { db, rollback in do { try db.executeUpdate("INSERT INTO myTable VALUES (?)", values: [1]) try db.executeUpdate("INSERT INTO myTable VALUES (?)", values: [2]) try db.executeUpdate("INSERT INTO myTable VALUES (?)", values: [3]) if whoopsSomethingWrongHappened { rollback.memory = true return } try db.executeUpdate("INSERT INTO myTable VALUES (?)", values: [4]) } catch { rollback.memory = true print(error) } } <\/code><\/pre>\n \u041f\u0440\u0438\u043c\u0435\u0440 \u0438\u0437 \u0441\u0442\u0430\u043d\u0434\u0430\u0440\u0442\u043d\u043e\u0433\u043e \u043e\u043f\u0438\u0441\u0430\u043d\u0438\u044f:<\/p>\n
let documents = try! NSFileManager.defaultManager().URLForDirectory(.DocumentDirectory, inDomain: .UserDomainMask, appropriateForURL: nil, create: false) let fileURL = documents.URLByAppendingPathComponent("test.sqlite") let database = FMDatabase(path: fileURL.path) if !database.open() { print("Unable to open database") return } do { try database.executeUpdate("create table test(x text, y text, z text)", values: nil) try database.executeUpdate("insert into test (x, y, z) values (?, ?, ?)", values: ["a", "b", "c"]) try database.executeUpdate("insert into test (x, y, z) values (?, ?, ?)", values: ["e", "f", "g"]) let rs = try database.executeQuery("select x, y, z from test", values: nil) while rs.next() { let x = rs.stringForColumn("x") let y = rs.stringForColumn("y") let z = rs.stringForColumn("z") print("x = \\(x); y = \\(y); z = \\(z)") } } catch let error as NSError { print("failed: \\(error.localizedDescription)") } database.close() <\/code><\/pre>\n \u0415\u0441\u043b\u0438 \u0447\u0442\u043e-\u0442\u043e \u043d\u0435 \u043f\u043e\u043b\u0443\u0447\u0430\u0435\u0442\u0441\u044f, \u043f\u0438\u0448\u0435\u0442\u0435, \u043f\u043e\u0441\u0442\u0430\u0440\u0430\u044e\u0441\u044c \u043f\u043e\u043c\u043e\u0447\u044c. <\/p>\n