NOT Maintained -

SQLiteManager

"Everything Should Be Made as Simple as Possible, But Not Simpler" - Albert Einstein

Idea is to have a simple Swift interface to run basic SQL statements/queries such as CREATE TABLE, SELECT, INSERT, UPDATE and DELETE. There are many iOS libraries that are well capable of doing complicated SQLite stuff but almost all of those libraries have more than what we need for small projects. Thus, the idea is to get rid of all the boilerplate code and keep things very simple. You write your own SQL.

Modeling, Handling objects, writing business logic is all up to the developers.

0.2.0

Read and Write queries are executed in two different database connections to make it faster<br /> Added functionality to execute array of queries in the same transaction block, (not supported for bind queries yet), this happens in an another database connection other than normal read/write connections<br /> NOTE:These new features are not available in swift2.3 version<br />

Example

To run the example project, clone the repo, and run pod install from the Example directory first.

Requirements

Min iOS SDK 8.0<br /> Min tvOS SDK 9.0<br />

Installation

SQLiteManager is available through CocoaPods. To install it, simply add the following line to your Podfile:

Usage

Drag and drop SQLite database file to project bundle. example database file name : app_test_database_1 and extension is db

pod "SQLiteManager"

import SQLiteManager

class ViewController: UIViewController {

	@IBOutlet weak var countLabel: UILabel!

	override func viewDidLoad() {

		super.viewDidLoad()

		let database =  try! SQLitePool.manager().initialize(database: "app_test_database_1", withExtension: "db")

		// on main thread
		let result = try! database.query("select count(*) as user_count from tb_user")
		if let r = result.results?.first!["user_count"] {
			self.countLabel.text = "\(r)"
		}

		// on background thread
		unowned let refSelf = self
		database.query("select count(*) as user_count from tb_user", successClosure: { (result) in

		if let r = result.results?.first!["user_count"] {
			refSelf.countLabel.text = "\(r)"
		}

		}, errorClosure: { (error) in
			print("Database Error",error)
		})

		//bind values
		let dob = Date(timeIntervalSince1970: 3600*24*3650)

		let imagePath = URL(fileURLWithPath: Bundle.main.path(forResource: "chamira_fernando", ofType: "jpg")!)
		let profilePic  = try! Data(contentsOf: imagePath)

		let _ = try! database.bindQuery("INSERT INTO 'tb_user' (first_name, last_name, username, date_of_birth, company_id, profile_picture) VALUES (?,?,?,?,?,?)", bindValues: [sqlStr("Chameera"),sqlStr("Fernando"),sqlStr("some_user_name"), sqlNumber(dob.timeIntervalSince1970),sqlNumber(1),sqlData(profilePic)])


		//batch
		let q1 = "SELECT * FROM tb_user"
		let q2 = "SELECT username FROM tb_user"

		database.query([q1,q2], successClosure: { (batchResult) in

			print("Time taken to proces",batchResult.timeTaken)
			for r in batchResult.results {
			print("Batch r:",r.results ?? "")
		}

		}, errorClosure: { (e) in
			print(e)
		})
	}
}

Legacy

If you want to hook up with swift 2.3 point to swift2.3 branch pod 'SQLiteManager', :git => 'https://github.com/chamira/SQLiteManager.git', :branch => 'swift2.3'

Author

Chamira Fernando, chamira.fdo@gmail.com, Twitter

Contributing

Contributions are very welcome.

• Before submitting any pull request, please ensure you have run the included tests and they have passed. <br />
• If you are including new functionality, please write test cases for it as well.

License

SQLiteManager is available under the MIT license. See the LICENSE file for more info.