DATA MANAGEMENT IN MOBILE APPS

7. Example (Swift with SQLite.swift): Swift

Example (Swift with SQLite.swift):

Swift

import SQLite

 

let db = try Connection(.inMemory) // Or path to file: Connection("/path/to/database.sqlite")

 

let users = Table("users")

let id = Expression<Int64>("id")

let name = Expression<String>("name")

let email = Expression<String>("email")

 

try db.run(users.create { t in</p> <p>    t.column(id, primaryKey: true)</p> <p>    t.column(name)</p> <p>    t.column(email)</p> <p>})

 

try db.run(users.insert(name <- "John Doe", email <- "john.doe@example.com"))

 

for user in try db.prepare(users) {</p> <p>    print("id: \(user[id]), name: \(user[name]), email: \(user[email])")</p> <p>}