SQL.swift

//
//  SQL.swift
//  PostgresStORM
//
//  Created by Jonathan Guthrie on 2016-09-24.
//
//

import StORM
import PerfectMySQL
import PerfectLogger

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

	/// Execute Raw SQL (with parameter binding)
	public func sql(_ statement: String, params: [String]) throws {
		do {
			try exec(statement, params: params)
		} catch {
			if !MySQLConnector.quiet {
				LogFile.error("Error msg: \(error)", logFile: StORMDebug.location)
			}
			self.error = StORMError.error("\(error)")
			throw error
		}
	}

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

}