BandDatabase.swift

//
//  BandDatabase.swift
//  Sfest-swift
//
//  Created by Peter Zignego on 7/29/14.
//  Copyright (c) 2014 Launch Software. All rights reserved.

import Foundation

class BandDatabase {
    
    class var sharedInstance:BandDatabase {
        
        struct Static {
            static let instance : BandDatabase = BandDatabase()
        }
        
        return Static.instance
    }
    
    var handle: COpaquePointer = nil
    
    func open() {
        let location = NSBundle.mainBundle().pathForResource("sfdb", ofType: "sqlite3")
        let path = location?.cStringUsingEncoding(NSUTF8StringEncoding)
        sqlite3_open(path!, &handle)
    }
    
    func bandsPlayingAtStage(stage:String, date:String) -> [(band:String, time:String)] {
        var results: [(band:String, time:String)] = []
        let queryString = "SELECT UID, DATE, TIME, STAGE, BAND FROM sfinfo WHERE DATE='"+date+"' AND STAGE='"+stage+"'"
        let cString = queryString.cStringUsingEncoding(NSUTF8StringEncoding)
        var statement: COpaquePointer = nil
        var result: CInt = 0
        
        // Prepare statement
        result = sqlite3_prepare_v2(handle, cString!, -1, &statement, nil)
        
        if (result != SQLITE_OK) {
            sqlite3_finalize(statement)
            print("Error")
        }
        else
        {
            while (sqlite3_step(statement) == SQLITE_ROW) {
                let timeCharacters = UnsafePointer<Int8> (sqlite3_column_text(statement, 2))
                let bandCharacters = UnsafePointer<Int8> (sqlite3_column_text(statement, 4))
                let time = String.fromCString(timeCharacters)
                let band = String.fromCString(bandCharacters)
                let tuple = (band:band!, time:time!)
                results.append(tuple)
            }
        }
        
        return results
    }
}