import SQLiteManager

class ViewController: UIViewController {

    @IBOutlet weak var countLabel: UILabel!

    override func viewDidLoad() {

        super.viewDidLoad()

        let database =  try! SQLitePool.manager().initialize(database: "app_test_database_1", withExtension: "db")

        // on main thread
        let result = try! database.query("select count(*) as user_count from tb_user")
        if let r = result.results?.first!["user_count"] {
            self.countLabel.text = "\(r)"
        }

        // on background thread
        unowned let refSelf = self
        database.query("select count(*) as user_count from tb_user", successClosure: { (result) in

        if let r = result.results?.first!["user_count"] {
            refSelf.countLabel.text = "\(r)"
        }

        }, errorClosure: { (error) in
            print("Database Error",error)
        })

        //bind values
        let dob = Date(timeIntervalSince1970: 3600*24*3650)

        let imagePath = URL(fileURLWithPath: Bundle.main.path(forResource: "chamira_fernando", ofType: "jpg")!)
        let profilePic  = try! Data(contentsOf: imagePath)

        let _ = try! database.bindQuery("INSERT INTO 'tb_user' (first_name, last_name, username, date_of_birth, company_id, profile_picture) VALUES (?,?,?,?,?,?)", bindValues: [sqlStr("Chameera"),sqlStr("Fernando"),sqlStr("some_user_name"), sqlNumber(dob.timeIntervalSince1970),sqlNumber(1),sqlData(profilePic)])


        //batch
        let q1 = "SELECT * FROM tb_user"
        let q2 = "SELECT username FROM tb_user"

        database.query([q1,q2], successClosure: { (batchResult) in

            print("Time taken to proces",batchResult.timeTaken)
            for r in batchResult.results {
            print("Batch r:",r.results ?? "")
        }

        }, errorClosure: { (e) in
            print(e)
        })
    }
}