Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //This route will be used to fetch data from the mysql database
- routes.add(method: .get, uri: "/use", handler: useMysql)
- public func useMysql(_ request: HTTPRequest, response: HTTPResponse)
- {
- //function body
- }
- routes.add(method: .get, uri: "/use", handler: useMysql(request: object of HTTPRequest, response: object of HTTPResponse))
- // Register your own routes and handlers
- var routes = Routes()
- routes.add(method: .get, uri: "/", handler: {
- request, response in
- response.setHeader(.contentType, value: "text/html")
- response.appendBody(string: "<html><title>Hello, world!</title><body>Hello, world!</body></html>")
- //This route will be used to fetch data from the mysql database
- useMysql(request, response: response)
- response.completed()
- }
- )
- routes.add(method: .post, uri: "/admin/api/v1/login") { (request, response) in
- let email = request.param(name: "email")
- let password = request.param(name: "passwrod")
- let JSON = Login.checkLogin(email: email, password: password)
- do {
- try response.setBody(json: JSON)
- .completed()
- } catch {
- }
- }
- import Foundation
- import PerfectMySQL
- import PerfectLib
- class Login: NSObject {
- class func checkLogin(email: String?, password: String?)-> JSONConvertible {
- var JSON: JSONConvertible?
- if !ServerHelper.isValidEmail(candidate: email) {
- JSON = ServerHelper.getErrorJson(message: KMESSAGE_INVALID_EMAIL_ADDRESS)
- return JSON
- } else if !ServerHelper.isValidPassword(password: password!) {
- JSON = ServerHelper.getErrorJson(message: KMESSAGE_INVALID_PASSWORD)
- return JSON
- } else {
- let mySql = MySQL()
- let connect = mySql.connect(host: "127.0.0.1", user: "root", password: "mypassword", db:"SuperAdmin" , port: 3306, socket: "", flag: 0)
- if !connect {
- JSON = ServerHelper.getErrorJson(message: KMESSAGE_SERVER_ERROR)
- return JSON
- }
- let query = "select email, phone_number from SuperAdmin.Login where email='(String(describing: email!))' AND password='(String(describing: password!))'"
- if mySql.query(statement: query) {
- let result = mySql.storeResults
- var jsonResult = [Dictionary<String, Any>]()
- result()?.forEachRow(callback: { (element) in
- var dict = Dictionary<String, Any>()
- if let arrRow = element as? [String] {
- let email = arrRow[0]
- let phone_number = arrRow[1]
- dict["email"] = email
- dict["phone_number"] = phone_number
- jsonResult.append(dict)
- }
- })
- if jsonResult.count == 0 {
- JSON = ServerHelper.getErrorJson(message: KMESSAGE_NOT_AUTHORIZE)
- } else {
- JSON = ServerHelper.getJson(result: jsonResult)
- }
- } else {
- JSON = ServerHelper.getErrorJson(message: KMESSAGE_NOT_AUTHORIZE)
- return JSON
- }
- mySql.close()
- }
- return JSON
- }
- }
- {
- "status": 200,
- "succcess": true,
- "result": [
- {
- "phone_number": "84747474574",
- "email": "myemail@swift.com"
- }
- ]
- }
- let connect = mySql.connect(host: "127.0.0.1", user: "root", password: "mypassword", db:"SuperAdmin" , port: 3306, socket: "", flag: 0)
Add Comment
Please, Sign In to add comment