Have you ever wanted to connect to a MySQL Database from Swift without using the C client? Well, now you can. MySQLDriver for Swift is a native driver, written in Swift programming language. Using this driver you can connect directly to a MySQL Database Server from your Swift code. You can use it on a Mac, iOS Device and Linux.
//create the connection object
let con = MySQL.Connection()
let db_name = "swift_test"
do{
// open a new connection
try con.open("localhost", user: "test", passwd: "test")
// create a new database for tests, use exec since we don't expect any results
try con.exec("DROP DATABASE IF EXISTS " + db_name)
try con.exec("CREATE DATABASE IF NOT EXISTS " + db_name)
// select the database
try con.use(db_name)
// create a table for our tests
try con.exec("CREATE TABLE test (id INT NOT NULL AUTO_INCREMENT, age INT, cash FLOAT, name VARCHAR(30), PRIMARY KEY (id))")
// prepare a new statement for insert
let ins_stmt = try con.prepare("INSERT INTO test(age, cash, name) VALUES(?,?,?)")
// prepare a new statement for select
let select_stmt = try con.prepare("SELECT * FROM test WHERE Id=?")
// insert 300 rows
for i in 1...300 {
// use a int, float and a string
try ins_stmt.exec([10+i, Float(i)/3.0, "name for \(i)"])
}
// read rows 30 to 60
for i in 30...60 {
do {
// send query
let res = try select_stmt.query([i])
//read all rows from the resultset
let rows = try res.readAllRows()
// print the rows
print(rows)
}
catch (let err) {
// if we get a error print it out
print(err)
}
}
try con.close()
}
catch (let e) {
print(e)
}// create a new Table object with name on a connection
let table = MySQL.Table(tableName: "createtable_obj", connection: con)
// drop the table if it exists
try table.drop()
// declare a new Swft Object with various types
struct obj {
var iint8 : Int8 = -1
var uint8: UInt8 = 1
var int16 : Int16 = -1
var uint16: UInt16 = 1
var id:Int = 1
var count:UInt = 10
var uint64 : UInt64 = 19999999999
var int64 : Int64 = -19999999999
var ffloat : Float = 1.1
var ddouble : Double = 1.1
var ddate = NSDate()
var str = "test string"
var ddata = "test data".dataUsingEncoding(NSUTF8StringEncoding)!
}
// create a new object
let o = obj()
// create the MySQL Table based on the Swift object
try table.create(o)
// create a table with given primaryKey and auto_increment set to true
try table.create(o, primaryKey: "id", autoInc: true)// create a new Table object with name on a connection
let table = MySQL.Table(tableName: "createtable_row", connection: con)
// drop the table if it exists
try table.drop()
// declare a new MySQL.Row with various types
let obj : MySQL.Row = [
"oint": Int?(0),
"iint8" : Int8(-1),
"uint8": UInt8(1),
"int16" : Int16(-1),
"uint16": UInt16(100),
"id":Int(1),
"count":UInt?(10),
"uint64" : UInt64(19999999999),
"int64" : Int64(-19999999999),
"ffloat" : Float(1.1),
"ddouble" : Double(1.1),
"ddate" : NSDate(dateString: "2015-11-10"),
"str" : "test string",
"nsdata" : "test data".dataUsingEncoding(NSUTF8StringEncoding)!,
"uint8_array" : [UInt8]("test data uint8 array".utf8),
]
// create the MySQL Table based on MySQL.Row object
try table.create(obj)
// create a table with given primaryKey and auto_increment set to true
try table.create(o, primaryKey: "id", autoInc: true)try table.insert(o)o.iint8 = -100
o.uint8 = 100
o.int16 = -100
o.iint32 = -200
try table.update(o, key:"id")obj["iint32"] = 4000
obj["iint16"] = Int16(-100)
try table.update(obj, key: "id")// insert 100 objects
for i in 1...100 {
o.str = "test string \(i)"
try table.insert(o)
}
// select all rows from the table given a condition
if let rows = try table.select(Where: ["id=",90, "or id=",91, "or id>",95]) {
print(rows)
}
// select rows specifying the columns we want and a select condition
if let rows = try table.select(["str", "uint8_array"], Where: ["id=",90, "or id=",91, "or id>",95]) {
print(rows)
}// create a connection pool with 10 connections using con as prototype
let connPool = try MySQL.ConnectionPool(num: 10, connection: con)
//create a table object using the connection
let table = MySQL.Table(tableName: "xctest_conn_pool", connection: con)
// drop the table if it exists
try table.drop()
// declare a Swift object
class obj {
var id:Int?
var val : Int = 1
}
// create a new object
let o = obj()
// create a new MySQL Table using the object
try table.create(o, primaryKey: "id", autoInc: true)
// do 500 async inserts using the connections pool
for i in 1...500 {
dispatch_async(dispatch_get_global_queue(DISPATCH_QUEUE_PRIORITY_BACKGROUND, 0), {
//get a connection from the pool
if let c = connPool.getConnection() {
// get a Table reference using the connection from the pool
let t = MySQL.Table(tableName: "xctest_conn_pool", connection: c)
do {
let o = obj()
o.val = i
// insert the object
try t.insert(o)
}
catch {
print(error)
XCTAssertNil(error)
connPool.free(c)
}
// release the connection to the pool
connPool.free(c)
}
})
}use_frameworks!
pod 'MySqlSwiftNative', '~> 1.0.10'
github "mcorega/MySqlSwiftNative" == 1.4.0
Copyright (c) 2015, Marius Corega All rights reserved.
Permission is granted to anyone to use this software for any purpose, including commercial applications, and to alter it and redistribute it freely. Redistribution and use in source and binary forms, with or without modification, are permitted provided that the following conditions are met:
-
Redistributions of source code must retain the above copyright notice, this list of conditions and the following disclaimer.
-
Redistributions in binary form must reproduce the above copyright notice, this list of conditions and the following disclaimer in the documentation and/or other materials provided with the distribution.
-
Neither the name of the {organization} nor the names of its contributors may be used to endorse or promote products derived from this software without specific prior written permission.
-
If you use this software in a product, an acknowledgment in the product documentation is required.Altered source versions must be plainly marked as such, and must not be misrepresented as being the original software. This notice may not be removed or altered from any source or binary distribution.
THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.