Module: MySQL-StORM
extension MySQLStORM
func delete() throws
Deletes one row, with an id.
Presumes first property in class is the id.
func delete(_ id: Any) throws
Deletes one row, with the id as set.
func get(_ id: Any) throws
Retrieves a single row with the supplied ID.
func get() throws
Retrieves a single row with the ID as set.
func find(_ data: [(String, Any)]) throws
Performs a find on mathing column name/value pairs.
extension MySQLStORM
func delete(_ id: Int, idName: String = "id") throws -> Bool
Deletes one row, with an id as an integer
func delete(_ id: String, idName: String = "id") throws -> Bool
Deletes one row, with an id as a String
func delete(_ id: UUID, idName: String = "id") throws -> Bool
Deletes one row, with an id as a UUID
extension MySQLStORM
func insert(_ data: [(String, Any)]) throws -> Any
Insert function where the suppled data is in [(String, Any)] format.
func insert(cols: [String], params: [Any]) throws -> Any
Insert function where the suppled data is in matching arrays of columns and parameter values.
func insert(cols: [String], params: [Any], idcolumn: String) throws -> Any
Insert function where the suppled data is in matching arrays of columns and parameter values, as well as specifying the name of the id column.
struct MySQLConnector
MySQLConnector sets the connection parameters for the PostgreSQL Server access
Usage:
MySQLConnector.host = "XXXXXX"
MySQLConnector.username = "XXXXXX"
MySQLConnector.password = "XXXXXX"
MySQLConnector.port = 3306
static var host: String = ""
static var username: String = ""
static var password: String = ""
static var database: String = ""
static var port: Int = 3306
extension MySQLStORM
func parseRows(_:resultSet:)
extension MySQLStORM
func findAll() throws
Retrieves all rows in the table, only limited by the cursor (9,999,999 rows)
func select(
whereclause: String,
params: [Any],
orderby: [String],
cursor: StORMCursor = StORMCursor(),
joins: [StORMDataSourceJoin] = [],
having: [String] = [],
groupBy: [String] = []
) throws
Select function with specific where clause.
Parameterized statements are used, so all params should be passed in using the [Any] params array.
The whereclause should be specified in the following format: "name = ? AND email LIKE ?"
An orderby array can be specified in a String array like ["name DESC","email ASC"]
A StORMCursor can be supplied, otherwise the default values are used.
Note that the joins, having and groupBy functionality is unimplemented at this time.
The select function will populate the object with the results of the query.
func select(
columns: [String],
whereclause: String,
params: [Any],
orderby: [String],
cursor: StORMCursor = StORMCursor(),
joins: [StORMDataSourceJoin] = [],
having: [String] = [],
groupBy: [String] = []
) throws
Select function with specific where clause, and spefified columns to return.
Parameterized statements are used, so all params should be passed in using the [Any] params array.
The whereclause should be specified in the following format: "name = ? AND email LIKE ?"
An orderby array can be specified in a String array like ["name DESC","email ASC"]
A StORMCursor can be supplied, otherwise the default values are used.
Note that the joins, having and groupBy functionality is unimplemented at this time.
The select function will populate the object with the results of the query.
extension MySQLStORM
func sql(_ statement: String, params: [String]) throws
Execute Raw SQL (with parameter binding)
func sqlRows(_ statement: String, params: [String]) throws -> [StORMRow]
Execute Raw SQL (with parameter binding)
Returns [StORMRow] (discardable)
extension MySQLStORM
func update(cols: [String], params: [Any], idName: String, idValue: Any) throws -> Bool
Updates the row with the specified data.
This is an alternative to the save() function.
Specify matching arrays of columns and parameters, as well as the id name and value.
func update(data: [(String, Any)], idName: String = "id", idValue: Any) throws -> Bool
Updates the row with the specified data.
This is an alternative to the save() function.
Specify a [(String, Any)] of columns and parameters, as well as the id name and value.
extension MySQLStORM
func upsert(cols: [String], params: [Any], conflictkeys: [String]) throws
Inserts the row with the specified data, on conflict (conflickkeys columns) it will perform an update.
Specify matching arrays of columns and parameters, and an array of conflict key columns.