dependencies: [ .package(url: "https://github.com/denissimon/SQLiteAdapter.git", from: "0.8.1") ]

import SQLiteAdapter // The sqlite file will be created if it does not already exist guard let dbPath = try? (FileManager.default.url(for: .documentDirectory, in: .userDomainMask, appropriateFor: nil, create: false) .appendingPathComponent("db.sqlite")).path else { return } guard let sqlite = try? SQLite(path: dbPath) else { return } print(sqlite.dbPath) // -> path of the sqlite file

let sqlTable = SQLTable( name: "ExampleTable", columns: [ ("id", .INT), ("json", .TEXT), ("isDeleted", .BOOL), ("updated", .DATE) ], primaryKey: "id" // "id" by default ) let statementCreateTable = """  CREATE TABLE IF NOT EXISTS "\(sqlTable.name)"(  "\(sqlTable.primaryKey)" INTEGER NOT NULL,  "json" TEXT NULL,  "isDeleted" BOOLEAN DEFAULT 0 NOT NULL CHECK (isDeleted IN (0, 1)),  "updated" DATETIME NOT NULL,  PRIMARY KEY("\(sqlTable.primaryKey)" AUTOINCREMENT)  );  """ try? sqlite.createTable(sql: statementCreateTable)

do { var sql = "INSERT INTO \(sqlTable.name) (json, updated) VALUES (?, ?);" try sqlite.insertRow(sql: sql, params: ["someJson", Date()]) sql = "INSERT INTO \(sqlTable.name) (json, updated) VALUES (?, ?), (?, ?), (?, ?);" let date = Date() let (changes, lastInsertID) = try sqlite.insertRow(sql: sql, params: [nil, date, nil, date, nil, date]) assert((changes, lastInsertID) == (3, 4)) sql = "UPDATE \(sqlTable.name) SET isDeleted = ?, updated = ? WHERE \(sqlTable.primaryKey) IN (2, 3)" try sqlite.updateRow(sql: sql, params: [true, Date()]) assert(sqlite.changes == 2) sql = "SELECT * FROM \(sqlTable.name) WHERE isDeleted = ?" if let rows = try sqlite.getRow(from: sqlTable, sql: sql, params: [true]) { assert(rows.count == 2) } try sqlite.deleteByID(in: sqlTable, id: 2) try sqlite.deleteByID(in: sqlTable, id: 3) let rowCount = try sqlite.getRowCount(in: sqlTable) assert(rowCount == 2) if let row = try sqlite.getFirstRow(from: sqlTable) { assert(row[0].value as! Int == 1) // "id" assert(row[1].value as? String == "someJson") // "json" assert(row[2].value as! Bool == false) // "isDeleted" } if let row = try sqlite.getLastRow(from: sqlTable) { assert(row[0].value as! Int == 4) // "id" assert(row[1].value as? String == nil) // "json" assert(row[2].value as! Bool == false) // "isDeleted" } } catch { print(error.localizedDescription) }

let row = try sqlite.getByID(from: sqlTable, id: 10) // -> nil

let changes = try sqlite.deleteAllRows(in: sqlTable) // -> 2

sqlite.dateFormatter.locale = Locale(identifier: "en_US_POSIX") sqlite.dateFormatter.timeZone = TimeZone(secondsFromGMT: 0) sqlite.dateFormatter.dateFormat = "yyyy-MM-dd HH:mm:ss"

INT // Includes INT, INTEGER, INT2, INT8, BIGINT, MEDIUMINT, SMALLINT, TINYINT BOOL // Includes BOOL, BOOLEAN, BIT TEXT // Includes TEXT, CHAR, CHARACTER, VARCHAR, CLOB, VARIANT, VARYING_CHARACTER, NATIONAL_VARYING_CHARACTER, NATIVE_CHARACTER, NCHAR, NVARCHAR REAL // Includes REAL, DOUBLE, FLOAT, NUMERIC, DECIMAL, DOUBLE_PRECISION BLOB // Includes BLOB, BINARY, VARBINARY DATE // Includes DATE, DATETIME, TIME, TIMESTAMP

func createTable(sql: String) throws func checkIfTableExists(_ table: SQLTable) throws -> Bool func dropTable(_ table: SQLTable, vacuum: Bool) throws func addIndex(to table: SQLTable, forColumn columnName: String, unique: Bool, order: SQLOrder) throws func checkIfIndexExists(in table: SQLTable, indexName: String) throws -> Bool func dropIndex(in table: SQLTable, forColumn columnName: String) throws func beginTransaction() throws func endTransaction() throws func insertRow(sql: String, params: [Any]?) throws -> (changes: Int, lastInsertID: Int) func updateRow(sql: String, params: [Any]?) throws -> Int func deleteRow(sql: String, params: [Any]?) throws -> Int func deleteByID(in table: SQLTable, id: Int) throws -> Int func deleteAllRows(in table: SQLTable, vacuum: Bool, resetAutoincrement: Bool) throws -> Int func getRowCount(in table: SQLTable) throws -> Int func getRowCountWithCondition(sql: String, params: [Any]?) throws -> Int func getRow(from table: SQLTable, sql: String, params: [Any]?) throws -> [SQLValues]? func getAllRows(from table: SQLTable) throws -> [SQLValues]? func getByID(from table: SQLTable, id: Int) throws -> SQLValues? func getFirstRow(from table: SQLTable) throws -> SQLValues? func getLastRow(from table: SQLTable) throws -> SQLValues? func vacuum() throws func query(sql: String, params: [Any]?) throws -> Int