INACTIVE - A type-safe, Swift-language layer over SQLite3.
Перейти к файлу
Stephen Celis 03b27f9a5f Fix General Query.delete() documentation
Fixes #179.

Signed-off-by: Stephen Celis <stephen@stephencelis.com>
2015-08-18 19:16:28 -07:00
Documentation Fix General Query.delete() documentation 2015-08-18 19:16:28 -07:00
SQLite Add select functions with array param for query builder 2015-07-15 09:41:56 +07:00
SQLite Tests Coverage improvements 2015-08-18 19:07:48 -07:00
SQLite.playground Playground updates 2015-05-17 21:50:42 -04:00
SQLite.xcodeproj Remove dummy framework 2015-05-17 19:08:23 -04:00
SQLiteCipher Remove dummy framework 2015-05-17 19:08:23 -04:00
SQLiteCipher Tests Swift 1.2 beta 1 2015-03-28 13:28:54 -07:00
Vendor Move fts3_tokenizer to ease Frameworkless Target install 2015-04-24 09:30:31 -04:00
.gitignore SQLite.swift 2014-10-05 18:29:39 -07:00
.gitmodules Universal Framework 2015-02-15 19:43:08 -08:00
.travis.yml Restore Travis 2015-05-30 21:28:23 -04:00
CONTRIBUTING.md Update Contributing Guidelines 2015-05-06 18:31:26 -04:00
LICENSE.txt 2015: The year of header cleanup 2015-02-04 21:01:08 -08:00
Makefile SwiftCov support 2015-06-07 12:21:53 -04:00
README.md Indent manual SQLCipher instructions under manual 2015-05-30 21:33:01 -04:00
SQLite.swift.podspec SQLCipher CocoaPods support 2015-05-19 22:25:26 -04:00

README.md

SQLite.swift Build Status

A type-safe, Swift-language layer over SQLite3.

SQLite.swift provides compile-time confidence in SQL statement syntax and intent.

Features

  • A pure-Swift interface
  • A type-safe, optional-aware SQL expression builder
  • A flexible, chainable, lazy-executing query layer
  • Automatically-typed data access
  • A lightweight, uncomplicated query and parameter binding interface
  • Developer-friendly error handling and debugging
  • Full-text search support
  • SQLCipher support
  • Well-documented
  • Extensively tested

Usage

import SQLite

let db = Database("path/to/db.sqlite3")

let users = db["users"]
let id = Expression<Int64>("id")
let name = Expression<String?>("name")
let email = Expression<String>("email")

db.create(table: users) { t in
    t.column(id, primaryKey: true)
    t.column(name)
    t.column(email, unique: true)
}
// CREATE TABLE "users" (
//     "id" INTEGER PRIMARY KEY NOT NULL,
//     "name" TEXT,
//     "email" TEXT NOT NULL UNIQUE
// )

var alice: Query?
if let rowid = users.insert(name <- "Alice", email <- "alice@mac.com").rowid {
    println("inserted id: \(rowid)")
    // inserted id: 1
    alice = users.filter(id == rowid)
}
// INSERT INTO "users" ("name", "email") VALUES ('Alice', 'alice@mac.com')

for user in users {
    println("id: \(user[id]), name: \(user[name]), email: \(user[email])")
    // id: 1, name: Optional("Alice"), email: alice@mac.com
}
// SELECT * FROM "users"

alice?.update(email <- replace(email, "mac.com", "me.com"))
// UPDATE "users" SET "email" = replace("email", 'mac.com', 'me.com')
// WHERE ("id" = 1)

alice?.delete()
// DELETE FROM "users" WHERE ("id" = 1)

users.count
// SELECT count(*) FROM "users"

SQLite.swift also works as a lightweight, Swift-friendly wrapper over the C API.

let stmt = db.prepare("INSERT INTO users (email) VALUES (?)")
for email in ["betty@icloud.com", "cathy@icloud.com"] {
    stmt.run(email)
}

db.totalChanges    // 3
db.changes         // 1
db.lastInsertRowid // 3

for row in db.prepare("SELECT id, email FROM users") {
    println("id: \(row[0]), email: \(row[1])")
    // id: Optional(2), email: Optional("betty@icloud.com")
    // id: Optional(3), email: Optional("cathy@icloud.com")
}

db.scalar("SELECT count(*) FROM users") // 2

Read the documentation or explore more, interactively, from the Xcode projects playground.

SQLite.playground Screen Shot

Installation

Note: SQLite.swift requires Swift 1.2 (and Xcode 6.3) or greater.

The following instructions apply to targets that support embedded Swift frameworks. To use SQLite.swift in iOS 7 or an OS X command line tool, please read the Frameworkless Targets section of the documentation.

CocoaPods

CocoaPods is a dependency manager for Cocoa projects. To install SQLite.swift with CocoaPods:

  1. Make sure CocoaPods is installed (SQLite.swift requires version 0.37 or greater).

  2. Update your Podfile to include the following:

    use_frameworks!
    pod 'SQLite.swift', git: 'https://github.com/stephencelis/SQLite.swift.git'
    # pod 'SQLite.swift/Cipher', git: ... # instead, for SQLCipher support
    
  3. Run pod install.

Manual

To install SQLite.swift as an Xcode sub-project:

  1. Drag the SQLite.xcodeproj file into your own project. (Submodule, clone, or download the project first.)

  2. In your targets Build Phases, add SQLite to the Target Dependencies build phase.

  3. Add SQLite.framework to the Link Binary With Libraries build phase.

  4. Add SQLite.framework to a Copy Files build phase with a Frameworks destination. (Add a new build phase if need be.)

SQLCipher

Note: To install with CocoaPods, see above.

To install SQLite.swift with SQLCipher support:

  1. Make sure the sqlcipher working copy is checked out in Xcode. If sqlcipher.xcodeproj is unavailable (i.e., it appears red), go to the Source Control menu and select Check Out sqlcipher… from the sqlcipher menu item.

  2. Follow the instructions above with the SQLiteCipher target, instead.

Note: By default, SQLCipher compiles without support for full-text search. If you intend to use FTS4, make sure you add the following to Other C Flags in the Build Settings of the sqlcipher target (in the sqlcipher.xcodeproj project):

  • -DSQLITE_ENABLE_FTS4
  • -DSQLITE_ENABLE_FTS3_PARENTHESIS

Communication

Read the contributing guidelines. The TL;DR (but please; R):

Author

License

SQLite.swift is available under the MIT license. See the LICENSE file for more information.

Alternatives

Looking for something else? Try another Swift wrapper (or FMDB):