WebSVN – Iphone Microlearning - Nuevo Interface – Diff – /twogetskills/Dao/ProgressDao.swift

 import UIKit
 import SQLite3
 class ProgressDao {
     private let SQLITE_TRANSIENT = unsafeBitCast(-1, to: sqlite3_destructor_type.self)
-    private var db : OpaquePointer?
+    private var database = Database.sharedInstance
     static let sharedInstance: ProgressDao = {
            let instance = ProgressDao()
            // setup code
-           return instance
-    }()
-    init() {
-        self.db = Database.sharedInstance.open()
+           return instance
+    }()
     func selectByTopicUuid(topicUuid: String)-> ProgressModel {
-    func selectByTopicUuid(topicUuid: String)-> ProgressModel {
+        let db = database.open()
         //var records = [ProgressModel]()
         var model = ProgressModel()
                 model.returningAfterCompleted = Int(sqlite3_column_int(statement, 11))
                 model.completed = Int(sqlite3_column_int(statement, 12))
                 model.addedOn = String(describing: String(cString: sqlite3_column_text(statement, 13)))
                 model.updatedOn = String(describing: String(cString: sqlite3_column_text(statement, 14)))
+            }
+        } else {
+            database.printError()
+        }
         sqlite3_finalize(statement)
         return model
+    }
     func selectByTopicUuidAndUserUuid(topicUuid: String, userUuid : String)-> ProgressModel {
-    func selectByTopicUuidAndUserUuid(topicUuid: String, userUuid : String)-> ProgressModel {
+        let db = database.open()
         //var records = [ProgressModel]()
         var model = ProgressModel()
         var query = "SELECT "
                 model.returningAfterCompleted = Int(sqlite3_column_int(statement, 11))
                 model.completed = Int(sqlite3_column_int(statement, 12))
                 model.addedOn = String(describing: String(cString: sqlite3_column_text(statement, 13)))
                 model.updatedOn = String(describing: String(cString: sqlite3_column_text(statement, 14)))
+            }
+        } else {
+            database.printError()
+        }
         sqlite3_finalize(statement)
         return model
+    }
+    func selectByCapsuleUuid(capsuleUuid: String)-> ProgressModel {
-    func selectByCapsuleUuid(capsuleUuid: String)-> ProgressModel {
+        let db = database.open()
         //var records = [ProgressModel]()
         var model = ProgressModel()
         var query = "SELECT "
         query = query +  Constants.TABLE_PROGRESS_FIELD_ID + " , "
                 model.type = String(describing: String(cString: sqlite3_column_text(statement, 9)))
                 model.returning = Int(sqlite3_column_int(statement, 10))
                 model.returningAfterCompleted = Int(sqlite3_column_int(statement, 11))
                 model.completed = Int(sqlite3_column_int(statement, 12))
                 model.addedOn = String(describing: String(cString: sqlite3_column_text(statement, 13)))
-                model.updatedOn = String(describing: String(cString: sqlite3_column_text(statement, 14)))            }
+                model.updatedOn = String(describing: String(cString: sqlite3_column_text(statement, 14)))
+            }
+        } else {
+            database.printError()
+        }
         sqlite3_finalize(statement)
         return model
+    }
     func selectByCapsuleUuidAndUserUuid(capsuleUuid: String, userUuid : String)-> ProgressModel {
-    func selectByCapsuleUuidAndUserUuid(capsuleUuid: String, userUuid : String)-> ProgressModel {
+        let db = database.open()
         //var records = [ProgressModel]()
         var model = ProgressModel()
         var query  = "SELECT "
                 model.type = String(describing: String(cString: sqlite3_column_text(statement, 9)))
                 model.returning = Int(sqlite3_column_int(statement, 10))
                 model.returningAfterCompleted = Int(sqlite3_column_int(statement, 11))
                 model.completed = Int(sqlite3_column_int(statement, 12))
                 model.addedOn = String(describing: String(cString: sqlite3_column_text(statement, 13)))
-                model.updatedOn = String(describing: String(cString: sqlite3_column_text(statement, 14)))            }
+                model.updatedOn = String(describing: String(cString: sqlite3_column_text(statement, 14)))
+            }
+        } else {
+            database.printError()
+        }
         sqlite3_finalize(statement)
         return model
+    }
     func selectBySlideUuid(slideUuid: String)-> ProgressModel {
-    func selectBySlideUuid(slideUuid: String)-> ProgressModel {
+        let db = database.open()
         //var records = [ProgressModel]()
         var model = ProgressModel()
         var query = "SELECT "
                 model.returningAfterCompleted = Int(sqlite3_column_int(statement, 11))
                 model.completed = Int(sqlite3_column_int(statement, 12))
                 model.addedOn = String(describing: String(cString: sqlite3_column_text(statement, 13)))
                 model.updatedOn = String(describing: String(cString: sqlite3_column_text(statement, 14)))
+            }
+        } else {
+            database.printError()
+        }
         sqlite3_finalize(statement)
         return model
+    }
     func selectBySlideUuidAndUserUuid(slideUuid: String, userUuid : String)-> ProgressModel {
-    func selectBySlideUuidAndUserUuid(slideUuid: String, userUuid : String)-> ProgressModel {
+        let db = database.open()
         //var records = [ProgressModel]()
         var model = ProgressModel()
         var query = "SELECT "
                 model.returningAfterCompleted = Int(sqlite3_column_int(statement, 11))
                 model.completed = Int(sqlite3_column_int(statement, 12))
                 model.addedOn = String(describing: String(cString: sqlite3_column_text(statement, 13)))
                 model.updatedOn = String(describing: String(cString: sqlite3_column_text(statement, 14)))
+            }
+        } else {
+            database.printError()
+        }
         sqlite3_finalize(statement)
         return model
+    }
-    /*
-    func getCountBycapsuleUuid(capsuleUuid: String) -> Int {
-        let query = "SELECT COUNT(*) AS total FROM " +  Constants.TABLE_PROGRESS +
-        " WHERE " +  Constants.TABLE_PROGRESS_FIELD_CAPSULE_ID + " = '\(capsuleUuid)' "  +
-        " AND " +  Constants.TABLE_PROGRESS_FIELD_TYPE + "= '\( Constants.PROGRESS_TYPE_SLIDE)'"
-        var statement : OpaquePointer? = nil
-        var count = 0;
-        if (sqlite3_prepare(db, query, -1, &statement, nil) == SQLITE_OK) {
-            if(sqlite3_step(statement) == SQLITE_ROW){
-                count = Int(sqlite3_column_int(statement, 0))
-            }
-         }
-        sqlite3_finalize(statement)
-        return count;
-    }
-    func getCountWithoutBycapsuleUuid(capsuleUuid: String) -> Int {
-        let query = "SELECT COUNT(*) AS total FROM " +  Constants.TABLE_PROGRESS +
-        " WHERE " +  Constants.TABLE_PROGRESS_FIELD_CAPSULE_ID + " = '\(capsuleUuid)' "  +
-            " AND " + Constants.TABLE_PROGRESS_FIELD_RETURNING + " = 0 " +
-        " AND " +  Constants.TABLE_PROGRESS_FIELD_TYPE + "= '\( Constants.PROGRESS_TYPE_SLIDE)'"
-        var statement : OpaquePointer? = nil
-        var count = 0;
-        if (sqlite3_prepare(db, query, -1, &statement, nil) == SQLITE_OK) {
-            if(sqlite3_step(statement) == SQLITE_ROW){
-                count = Int(sqlite3_column_int(statement, 0))
-            }
-         }
-        sqlite3_finalize(statement)
-        return count;
-    }
-    func getCountWithReturningBycapsuleUuid(capsuleUuid: String) -> Int {
-        let query = "SELECT COUNT(*) AS total FROM " +  Constants.TABLE_PROGRESS +
-        " WHERE " +  Constants.TABLE_PROGRESS_FIELD_CAPSULE_ID + " = '\(capsuleUuid)' "  +
-        " AND " + Constants.TABLE_PROGRESS_FIELD_RETURNING + " > 0 " +
-        " AND " +  Constants.TABLE_PROGRESS_FIELD_TYPE + "= '\( Constants.PROGRESS_TYPE_SLIDE)'"
-        var statement : OpaquePointer? = nil
-        var count = 0;
-        if (sqlite3_prepare(db, query, -1, &statement, nil) == SQLITE_OK) {
-            if(sqlite3_step(statement) == SQLITE_ROW){
-                count = Int(sqlite3_column_int(statement, 0))
-            }
-         }
-        sqlite3_finalize(statement)
-        return count;
-    }
-    func getCountCompletedBycapsuleUuid(capsuleUuid: String) -> Int {
-        let query = "SELECT COUNT(*) AS total FROM " +  Constants.TABLE_PROGRESS +
-        " WHERE " +  Constants.TABLE_PROGRESS_FIELD_CAPSULE_ID + " = '\(capsuleUuid)' "  +
-        " AND " +  Constants.TABLE_PROGRESS_FIELD_TYPE + "= '\( Constants.PROGRESS_TYPE_SLIDE)'" +
-        " AND " +  Constants.TABLE_PROGRESS_FIELD_COMPLETED + "  =  1 "
-        var statement : OpaquePointer? = nil
-        var count = 0;
-        if (sqlite3_prepare(db, query, -1, &statement, nil) == SQLITE_OK) {
-            if(sqlite3_step(statement) == SQLITE_ROW){
-                count = Int(sqlite3_column_int(statement, 0))
-            }
-         }
-        sqlite3_finalize(statement)
-        return count;
-    }
-    func getCountCompletedWithReturningBycapsuleUuid(capsuleUuid: String) -> Int {
-        let query = "SELECT COUNT(*) AS total FROM " +  Constants.TABLE_PROGRESS +
-        " WHERE " +  Constants.TABLE_PROGRESS_FIELD_CAPSULE_ID + " = '\(capsuleUuid)' "  +
-        " AND " +  Constants.TABLE_PROGRESS_FIELD_TYPE + "= '\( Constants.PROGRESS_TYPE_SLIDE)'" +
-            " AND " +  Constants.TABLE_PROGRESS_FIELD_RETURNING_AFTER_COMPLETED + " > 0 " +
-        " AND " +  Constants.TABLE_PROGRESS_FIELD_COMPLETED + "  =  1 "
-        var statement : OpaquePointer? = nil
-        var count = 0;
-        if (sqlite3_prepare(db, query, -1, &statement, nil) == SQLITE_OK) {
-            if(sqlite3_step(statement) == SQLITE_ROW){
-                count = Int(sqlite3_column_int(statement, 0))
-            }
-         }
-        sqlite3_finalize(statement)
-        return count;
-    }
-    func getCountCompletedWithoutReturningBycapsuleUuid(capsuleUuid: String) -> Int {
-        let query = "SELECT COUNT(*) AS total FROM " +  Constants.TABLE_PROGRESS +
-        " WHERE " +  Constants.TABLE_PROGRESS_FIELD_CAPSULE_ID + " = '\(capsuleUuid)' "  +
-        " AND " +  Constants.TABLE_PROGRESS_FIELD_TYPE + "= '\( Constants.PROGRESS_TYPE_SLIDE)'" +
-            " AND " +  Constants.TABLE_PROGRESS_FIELD_RETURNING_AFTER_COMPLETED + " = 0 " +
-        " AND " +  Constants.TABLE_PROGRESS_FIELD_COMPLETED + "  =  1 "
-        var statement : OpaquePointer? = nil
-        var count = 0;
-        if (sqlite3_prepare(db, query, -1, &statement, nil) == SQLITE_OK) {
-            if(sqlite3_step(statement) == SQLITE_ROW){
-                count = Int(sqlite3_column_int(statement, 0))
-            }
-         }
-        sqlite3_finalize(statement)
-        return count;
-    }
-    func getCountBytopicUuidWithReturning(topicUuid: String) -> Int {
-        var count = 0
-        var query = "SELECT COUNT(*) AS total FROM " +  Constants.TABLE_PROGRESS
-            query = query + " WHERE " +  Constants.TABLE_PROGRESS_FIELD_TOPIC_ID + " = \(topicUuid) AND "
-        +  Constants.TABLE_PROGRESS_FIELD_TYPE + "= '\( Constants.PROGRESS_TYPE_SLIDE)' AND " +  Constants.TABLE_PROGRESS_FIELD_RETURNING + " > 1 LIMIT 1"
-        var statement : OpaquePointer? = nil
-        if (sqlite3_prepare(db, query, -1, &statement, nil) == SQLITE_OK){
-            if(sqlite3_step(statement) == SQLITE_ROW){
-                count = Int(sqlite3_column_int(statement, 0))
-                //print("\(count)")
-            }
-        }
-        sqlite3_finalize(statement)
-        return count
-    }
-    func getCountBytopicUuidWithoutReturning(topicUuid: String) -> Int{
-        var count = 0
-        let query = "SELECT COUNT(*) AS total FROM " +  Constants.TABLE_PROGRESS + " WHERE " +  Constants.TABLE_PROGRESS_FIELD_TOPIC_ID + " = \(topicUuid) AND "
-        +  Constants.TABLE_PROGRESS_FIELD_TYPE + "= '\( Constants.PROGRESS_TYPE_SLIDE)' AND " +  Constants.TABLE_PROGRESS_FIELD_RETURNING + " = 0 LIMIT 1"
-        var statement : OpaquePointer? = nil
-        if (sqlite3_prepare(db, query, -1, &statement, nil) == SQLITE_OK) {
-            if(sqlite3_step(statement) == SQLITE_ROW){
-                count = Int(sqlite3_column_int(statement, 0))
-                //print("\(count)")/
-            }
-        }
-        sqlite3_finalize(statement)
-        return count
-    }
-    func getCountCompletedBytopicUuidWithoutReturning(topicUuid: String) -> Int{
-        var count = 0
-        let query = "SELECT COUNT(*) AS total FROM " +  Constants.TABLE_PROGRESS + " WHERE " +  Constants.TABLE_PROGRESS_FIELD_TOPIC_ID + " = \(topicUuid) " +
-            " AND " +  Constants.TABLE_PROGRESS_FIELD_TYPE + "= '\( Constants.PROGRESS_TYPE_SLIDE)' " +
-            " AND " +  Constants.TABLE_PROGRESS_FIELD_COMPLETED + "=  1 " +
-            " AND " +  Constants.TABLE_PROGRESS_FIELD_RETURNING_AFTER_COMPLETED + " = 0 LIMIT 1"
-        var statement : OpaquePointer? = nil
-        if (sqlite3_prepare(db, query, -1, &statement, nil) == SQLITE_OK) {
-            if(sqlite3_step(statement) == SQLITE_ROW){
-                count = Int(sqlite3_column_int(statement, 0))
-                //print("\(count)")
-            }
-        }
-        sqlite3_finalize(statement)
-        return count
-    }
-    func getCountCompletedBytopicUuidWithReturning(topicUuid: String) -> Int{
-        var count = 0
-        let query = "SELECT COUNT(*) AS total FROM " +  Constants.TABLE_PROGRESS + " WHERE " +  Constants.TABLE_PROGRESS_FIELD_TOPIC_ID + " = \(topicUuid) " +
-            " AND " +  Constants.TABLE_PROGRESS_FIELD_TYPE + "= '\( Constants.PROGRESS_TYPE_SLIDE)' " +
-            " AND " +  Constants.TABLE_PROGRESS_FIELD_COMPLETED + "= 1 " +
-            " AND " +  Constants.TABLE_PROGRESS_FIELD_RETURNING_AFTER_COMPLETED + " > 0 LIMIT 1"
-        var statement : OpaquePointer? = nil
-        if (sqlite3_prepare(db, query, -1, &statement, nil) == SQLITE_OK) {
-            if(sqlite3_step(statement) == SQLITE_ROW){
-                count = Int(sqlite3_column_int(statement, 0))
-                //print("\(count)")
-            }
-        }
-        sqlite3_finalize(statement)
-        return count
-    }
     */
+    func getCountSlideCompletedByCapsuleUuidAndUserUuid(capsuleUuid: String, userUuid: String) -> Int {
-    func getCountSlideCompletedByCapsuleUuidAndUserUuid(capsuleUuid: String, userUuid: String) -> Int {
+        let db = database.open()
         let query = "SELECT COUNT(*) AS total FROM " +  Constants.TABLE_PROGRESS +
         " WHERE " +  Constants.TABLE_PROGRESS_FIELD_CAPSULE_UUID + " = '\(capsuleUuid)' "  +
         " AND " +  Constants.TABLE_PROGRESS_FIELD_USER_UUID + "= '\(userUuid)'" +
         " AND " +  Constants.TABLE_PROGRESS_FIELD_TYPE + "= '\(Constants.PROGRESS_TYPE_SLIDE)'" +
         if (sqlite3_prepare(db, query, -1, &statement, nil) == SQLITE_OK) {
             if(sqlite3_step(statement) == SQLITE_ROW){
                 count = Int(sqlite3_column_int(statement, 0))
+            }
+        } else {
-            }
+            database.printError()
+        }
         sqlite3_finalize(statement)
         return count;
+    }
     func getCountSlideCompletedByTopicUuidAndUserUuid(topicUuid: String, userUuid: String) -> Int {
-    func getCountSlideCompletedByTopicUuidAndUserUuid(topicUuid: String, userUuid: String) -> Int {
+        let db = database.open()
         let query = "SELECT COUNT(*) AS total FROM " +  Constants.TABLE_PROGRESS +
         " WHERE " +  Constants.TABLE_PROGRESS_FIELD_TOPIC_UUID + " = '\(topicUuid)' "  +
         " AND " +  Constants.TABLE_PROGRESS_FIELD_USER_UUID + "= '\(userUuid)'" +
         if (sqlite3_prepare(db, query, -1, &statement, nil) == SQLITE_OK) {
             if(sqlite3_step(statement) == SQLITE_ROW){
                 count = Int(sqlite3_column_int(statement, 0))
+            }
+        } else {
-            }
+            database.printError()
+        }
         sqlite3_finalize(statement)
         return count;
+    }
     func getCountCapsulesCompletedByUserUuid(userUuid : String) -> Int {
-    func getCountCapsulesCompletedByUserUuid(userUuid : String) -> Int {
+        let db = database.open()
         var count = 0
         let query = "SELECT COUNT(*) AS total FROM " +  Constants.TABLE_PROGRESS +
             " WHERE " +  Constants.TABLE_PROGRESS_FIELD_USER_UUID + " = '\(userUuid)' " +
         if (sqlite3_prepare(db, query, -1, &statement, nil) == SQLITE_OK) {
             if(sqlite3_step(statement) == SQLITE_ROW){
                 count = Int(sqlite3_column_int(statement, 0))
                 //print("\(count)")
+            }
+        } else {
+            database.printError()
+        }
         sqlite3_finalize(statement)
         return count
+    }
+    func getCountCapsulesIncompletedByUserUuid(userUuid : String) -> Int {
-    func getCountCapsulesIncompletedByUserUuid(userUuid : String) -> Int {
+        let db = database.open()
         var count = 0
         let query = "SELECT COUNT(*) AS total FROM " +  Constants.TABLE_PROGRESS +
             " WHERE " +  Constants.TABLE_PROGRESS_FIELD_USER_UUID + " = '\(userUuid)' " +
             " AND " +  Constants.TABLE_PROGRESS_FIELD_TYPE + "= '\( Constants.PROGRESS_TYPE_CAPSULE)' " +
         if (sqlite3_prepare(db, query, -1, &statement, nil) == SQLITE_OK) {
             if(sqlite3_step(statement) == SQLITE_ROW){
                 count = Int(sqlite3_column_int(statement, 0))
                 //print("\(count)")
+            }
+        } else {
+            database.printError()
+        }
         sqlite3_finalize(statement)
         return count
+    }
+    func getCountCapsulesCompletedByTopicUuid(topicUuid : String) -> Int {
-    func getCountCapsulesCompletedByTopicUuid(topicUuid : String) -> Int {
+        let db = database.open()
         var count = 0
         let query = "SELECT COUNT(*) AS total FROM " +  Constants.TABLE_PROGRESS +
             " WHERE " +  Constants.TABLE_PROGRESS_FIELD_TOPIC_UUID + " = '\(topicUuid)' " +
             " AND " +  Constants.TABLE_PROGRESS_FIELD_TYPE + "= '\( Constants.PROGRESS_TYPE_CAPSULE)' " +
         if (sqlite3_prepare(db, query, -1, &statement, nil) == SQLITE_OK) {
             if(sqlite3_step(statement) == SQLITE_ROW){
                 count = Int(sqlite3_column_int(statement, 0))
                 //print("\(count)")
+            }
+        } else {
+            database.printError()
+        }
         sqlite3_finalize(statement)
         return count
+    }
+    func getCountCapsulesCompletedWithReturningByUserUuid(userUuid : String) -> Int {
-    func getCountCapsulesCompletedWithReturningByUserUuid(userUuid : String) -> Int {
+        let db = database.open()
         var count = 0
         let query = "SELECT COUNT(*) AS total FROM " +  Constants.TABLE_PROGRESS
             + " WHERE " +  Constants.TABLE_PROGRESS_FIELD_USER_UUID + " = '\(userUuid)' " +
             " AND " +  Constants.TABLE_PROGRESS_FIELD_TYPE + "= '\( Constants.PROGRESS_TYPE_CAPSULE)' " +
         if (sqlite3_prepare(db, query, -1, &statement, nil) == SQLITE_OK) {
             if(sqlite3_step(statement) == SQLITE_ROW){
                 count = Int(sqlite3_column_int(statement, 0))
                 //print("\(count)")
+            }
+        } else {
+            database.printError()
+        }
         sqlite3_finalize(statement)
         return count
+    }
+    func getCountCapsulesCompletedWithoutReturningByUserUuid(userUuid : String) -> Int {
-    func getCountCapsulesCompletedWithoutReturningByUserUuid(userUuid : String) -> Int {
+        let db = database.open()
         var count = 0
         let query = "SELECT COUNT(*) AS total FROM " +  Constants.TABLE_PROGRESS + " WHERE "
             +  Constants.TABLE_PROGRESS_FIELD_USER_UUID + " = '\(userUuid)' " +
             " AND " +  Constants.TABLE_PROGRESS_FIELD_TYPE + "= '\( Constants.PROGRESS_TYPE_CAPSULE)' " +
         if (sqlite3_prepare(db, query, -1, &statement, nil) == SQLITE_OK) {
             if(sqlite3_step(statement) == SQLITE_ROW){
                 count = Int(sqlite3_column_int(statement, 0))
                 //print("\(count)")
+            }
+        } else {
+            database.printError()
+        }
         sqlite3_finalize(statement)
         return count
+    }
+    func getCountCapsulesCompletedWithReturningByTopicUuid(topicUuid : String) -> Int {
-    func getCountCapsulesCompletedWithReturningByTopicUuid(topicUuid : String) -> Int {
+        let db = database.open()
         var count = 0
         let query = "SELECT COUNT(*) AS total FROM " +  Constants.TABLE_PROGRESS
             + " WHERE " +  Constants.TABLE_PROGRESS_FIELD_TOPIC_UUID + " = '\(topicUuid)' " +
             " AND " +  Constants.TABLE_PROGRESS_FIELD_TYPE + "= '\( Constants.PROGRESS_TYPE_CAPSULE)' " +
         if (sqlite3_prepare(db, query, -1, &statement, nil) == SQLITE_OK) {
             if(sqlite3_step(statement) == SQLITE_ROW){
                 count = Int(sqlite3_column_int(statement, 0))
                 //print("\(count)")
+            }
+        } else {
+            database.printError()
+        }
         sqlite3_finalize(statement)
         return count
+    }
+    func getCountCapsulesCompletedWithoutReturningByTopicUuid(topicUuid : String) -> Int {
-    func getCountCapsulesCompletedWithoutReturningByTopicUuid(topicUuid : String) -> Int {
+        let db = database.open()
         var count = 0
         let query = "SELECT COUNT(*) AS total FROM " +  Constants.TABLE_PROGRESS + " WHERE "
             +  Constants.TABLE_PROGRESS_FIELD_TOPIC_UUID + " = '\(topicUuid)' " +
             " AND " +  Constants.TABLE_PROGRESS_FIELD_TYPE + "= '\( Constants.PROGRESS_TYPE_CAPSULE)' " +
         if (sqlite3_prepare(db, query, -1, &statement, nil) == SQLITE_OK) {
             if(sqlite3_step(statement) == SQLITE_ROW){
                 count = Int(sqlite3_column_int(statement, 0))
                 //print("\(count)")
+            }
+        } else {
+            database.printError()
+        }
         sqlite3_finalize(statement)
         return count
+    }
     func insert( record : ProgressModel) {
-    func insert( record : ProgressModel) {
+        let db = database.open()
         var query = "INSERT INTO " +  Constants.TABLE_PROGRESS + " ( "
         query = query +  Constants.TABLE_PROGRESS_FIELD_COMPANY_UUID + ", "
         query = query +  Constants.TABLE_PROGRESS_FIELD_USER_UUID + ", "
             sqlite3_bind_int(statement, 12, Int32(record.completed))
             sqlite3_bind_text(statement, 13, record.addedOn, -1, SQLITE_TRANSIENT)
             sqlite3_bind_text(statement, 14, record.updatedOn, -1, SQLITE_TRANSIENT)
            if sqlite3_step(statement) != SQLITE_DONE {
+                print("No se pudo insertar un registro en la tabla: \(Constants.TABLE_PROGRESS)")
-            print("No se pudo insertar un registro en la tabla: \(Constants.TABLE_PROGRESS)")
+                database.printError()
            } else {
              print("insertamos un registro de progreso")
+           }
+        } else {
-        } else {
+            print("No se pudo preparar insertar un registro en la tabla: \(Constants.TABLE_PROGRESS)")
-            print("No se pudo preparar insertar un registro en la tabla: \(Constants.TABLE_PROGRESS)")
+            database.printError()
+        }
+        sqlite3_finalize(statement)
         sqlite3_finalize(statement)
     func update(record : ProgressModel) {
-    func update(record : ProgressModel) {
+        let db = database.open()
         var query = "UPDATE " +  Constants.TABLE_PROGRESS
         var statement : OpaquePointer? = nil
         if (sqlite3_prepare_v2(db, query, -1, &statement, nil) == SQLITE_OK) {
             if sqlite3_step(statement) != SQLITE_DONE {
+                print("No se pudo actualizar un registro en la tabla: \(Constants.TABLE_PROGRESS)")
-                print("No se pudo actualizar un registro en la tabla: \(Constants.TABLE_PROGRESS)")
+                database.printError()
+            }
         } else {
+            print("Fallo la preparación de actualizar un registro en la tabla: \(Constants.TABLE_PROGRESS)")
-            print("Fallo la preparación de actualizar un registro en la tabla: \(Constants.TABLE_PROGRESS)")
+            database.printError()
+        }
         sqlite3_finalize(statement)
+    }
     func remove(id: Int) {
-    func remove(id: Int) {
+        let db = database.open()
         let query = "DELETE FROM " +  Constants.TABLE_PROGRESS + " WHERE " +  Constants.TABLE_PROGRESS_FIELD_ID + " = " + "\(id) ;"
         var statement : OpaquePointer? = nil
         if (sqlite3_prepare_v2(db, query, -1, &statement, nil) == SQLITE_OK) {
+            if sqlite3_step(statement) != SQLITE_DONE {
-            if sqlite3_step(statement) != SQLITE_DONE {
+                print("No se pudo borrar un registro con el id: \(id) en la tabla: \(Constants.TABLE_PROGRESS)")
-                print("No se pudo borrar un registro con el id: \(id) en la tabla: \(Constants.TABLE_PROGRESS)")
+                database.printError()
+            }
+        } else {
-        } else {
+            print("Fallo la preparación de borrar un registro con el id: \(id) en la tabla: \(Constants.TABLE_PROGRESS)")
-            print("Fallo la preparación de borrar un registro con el id: \(id) en la tabla: \(Constants.TABLE_PROGRESS)")
+            database.printError()
+        }
         sqlite3_finalize(statement)
+    }
     func removeAll() {
-    func removeAll() {
+        let db = database.open()
         let query = "DELETE FROM " +  Constants.TABLE_PROGRESS + ";"
         var statement : OpaquePointer? = nil
+        if (sqlite3_prepare_v2(db, query, -1, &statement, nil) == SQLITE_OK) {
-        if (sqlite3_prepare_v2(db, query, -1, &statement, nil) == SQLITE_OK) {
+            if sqlite3_step(statement) != SQLITE_DONE {
-            if sqlite3_step(statement) != SQLITE_DONE {
+                print("No se pudo borrar todos los registros en la tabla: \(Constants.TABLE_PROGRESS)")
-                print("No se pudo borrar todos los registros en la tabla: \(Constants.TABLE_PROGRESS)")
+                database.printError()
+            }
         } else {
-        } else {
+            print("Fallo la preparación de borrar todos los registros en la tabla: \(Constants.TABLE_PROGRESS)")
-            print("Fallo la preparación de borrar todos los registros en la tabla: \(Constants.TABLE_PROGRESS)")
+            database.printError()
+        }
         sqlite3_finalize(statement)
+    }
     func removeAllUserUuidNotEqual(userUuid : String)
     func removeAllUserUuidNotEqual(userUuid : String)
         let db = database.open()
         let query = "DELETE FROM " +  Constants.TABLE_PROGRESS +
             " WHERE " + Constants.TABLE_PROGRESS_FIELD_USER_UUID + " <> '\(userUuid)' ;"
         var statement : OpaquePointer? = nil
+        if (sqlite3_prepare_v2(db, query, -1, &statement, nil) == SQLITE_OK) {
-        if (sqlite3_prepare_v2(db, query, -1, &statement, nil) == SQLITE_OK) {
+            if sqlite3_step(statement) != SQLITE_DONE {
-            if sqlite3_step(statement) != SQLITE_DONE {
+                print("No se pudo borrar todos los registros en la tabla: \(Constants.TABLE_PROGRESS)" +
-                print("No se pudo borrar todos los registros en la tabla: \(Constants.TABLE_PROGRESS)" +
+                " de los usuarios diferentes de : \(userUuid)" )
+                database.printError()
                 " de los usuarios diferentes de : \(userUuid)" )
         } else {
-        } else {
+            print("Fallo la preparación de borrar todos los registros en la tabla: \(Constants.TABLE_PROGRESS) de los usuarios diferentes de : \(userUuid) ")
-            print("Fallo la preparación de borrar todos los registros en la tabla: \(Constants.TABLE_PROGRESS) de los usuarios diferentes de : \(userUuid) ")
+            database.printError()

Proyectos de Subversion Iphone Microlearning - Nuevo Interface

(root)/twogetskills/Dao/ProgressDao.swift – Rev 11 → 19