SQLite-StORM/Sources/SQL.swift at 506d35ef85d046d056ec85241358886910dec0e9 · SwiftORM/SQLite-StORM · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
//
//  SQL.swift
//  SQLiteStORM
//
//  Created by Jonathan Guthrie on 2016-10-07.
//
//

import StORM
import PerfectSQLite
import PerfectLogger

/// An extension to the main class providing SQL statement functions
extension SQLiteStORM {

	/// Execute Raw SQL statement

	public func sqlExec(_ statement: String) throws {
		do {
			try execStatement(statement)
		} catch {
			LogFile.error("Error msg: \(error)", logFile: StORMDebug.location)
			self.error = StORMError.error("\(error)")
			throw error
		}
	}

	/// Execute Raw SQL statement with parameter binding from the params array.
	/// Returns an array of [SQLiteStmt]
	@discardableResult
	public func sql(_ statement: String, params: [String]) throws -> [SQLiteStmt] {
		do {
			return try exec(statement, params: params)
		} catch {
			LogFile.error("Error msg: \(error)", logFile: StORMDebug.location)
			self.error = StORMError.error("\(error)")
			throw error
		}
	}

	/// Execute Raw SQL statement with parameter binding from the params array.
	/// Returns an ID column
	@discardableResult
	public func sqlAny(_ statement: String, params: [String]) throws -> Any {
		do {
			return try execReturnID(statement, params: params)
		} catch {
			LogFile.error("Error msg: \(error)", logFile: StORMDebug.location)
			self.error = StORMError.error("\(error)")
			throw error
		}
	}

	/// Execute Raw SQL statement with parameter binding from the params array.
	/// Returns an array of [StORMRow]
	@discardableResult
	public func sqlRows(_ statement: String, params: [String]) throws -> [StORMRow] {
		do {
			return try execRows(statement, params: params)
		} catch {
			LogFile.error("Error msg: \(error)", logFile: StORMDebug.location)
			self.error = StORMError.error("\(error)")
			throw error
		}
	}

}