End-to-end Swift Solution with IBM Bluemix Part four - 2

ProfileDatabase.swift

//
// ProfileDatabase.swift
// Microservice1
//
// Created by Siavash Abbasalipour on 28/9/16.
//
//
import Foundation
import PostgreSQL
enum DBError: Error {
     case fileError(String)
}
struct ProfileDatabase {
     
     let dbHost = “YOUR HOST”
     let dbName = “YOUR DB NAME”
     let dbUsername = “YOUR USER NAME”
     let dbPassword = “YOUR PASSWORD”
     let dbPort = //YOUR PORT
     init() {
         
         }
     
     func addToDB(fname: String, lname: String) throws -> Bool {
         
         //open postgre db
         let pgsl = PostgreSQL.PGConnection()
         _ = pgsl.connectdb(“host=’\(dbHost)’ port=’\(dbPort)’ dbname=’\(dbName)’ user=’\(dbUsername)’ password=’\(dbPassword)’”)
         
         defer {
             pgsl.close()
             }
         
         guard pgsl.status() != .bad else {
             throw DBError.fileError(“Internal Server Error — failed to connect to db”)
             }
         
         let query: String = “INSERT INTO account (fname, lname) VALUES (‘\(fname)’,’\(lname)’);”
         //execute query
         let queryResult = pgsl.exec(statement: query)
         
         guard queryResult.status() == .commandOK else {
             throw DBError.fileError(“Internal Server Error — db query error”)
             }
         
         return true
         }
     
}