Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- // Change below parameters to match your Environment
- struct Constants: ConnectionOption {
- var host: String = "127.0.0.1"
- var port: Int = 3306
- var user: String = "root"
- var password: String = "CHANGE_TO_YOUR_PASSWORD"
- var database: String = "CHANGE_TO_YOUR_PASSWORD"
- var encoding: MySQL.Connection.Encoding = .UTF8MB4
- var timeZone: MySQL.Connection.TimeZone = MySQL.Connection.TimeZone(GMTOffset: 60 * 60 * 9) // JST
- }
- do {
- let constants = Constants()
- let pool = ConnectionPool(options: constants)
- try pool.execute { conn in
- let tables : [TableList] = try conn.query("select * from tblList")
- print(tables)
- }
- print("successfully finished")
- } catch let error {
- print("error\(error)")
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement