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

 import UIKit
 import SQLite3
 class ProgressDao {
     private let SQLITE_TRANSIENT = unsafeBitCast(-1, to: sqlite3_destructor_type.self)
-    private var database = Database.sharedInstance
-    static let sharedInstance: ProgressDao = {
-           let instance = ProgressDao()
-           // setup code
-           return instance
-    }()
+    private let db : OpaquePointer?
     func selectByTopicUuid(topicUuid: String)-> ProgressModel {
         let db = database.open()
         //var records = [ProgressModel]()
         var model = ProgressModel()
         var query = "SELECT "
                 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 {
         let db = database.open()
         //var records = [ProgressModel]()
         var model = ProgressModel()
         var query = "SELECT "
                 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.addedOn = String(describing: String(cString: sqlite3_column_text(statement, 13)))
                 model.updatedOn = String(describing: String(cString: sqlite3_column_text(statement, 14)))
+            }
-        } else {
+        } else {
             database.printError()
+        }
         sqlite3_finalize(statement)
         return model
-    }
+    }
     func selectByCapsuleUuidAndUserUuid(capsuleUuid: String, userUuid : String)-> ProgressModel {
         let db = database.open()
         //var records = [ProgressModel]()
         var model = ProgressModel()
                 model.addedOn = String(describing: String(cString: sqlite3_column_text(statement, 13)))
                 model.updatedOn = String(describing: String(cString: sqlite3_column_text(statement, 14)))
+            }
-        } else {
+        } else {
             database.printError()
+        }
         sqlite3_finalize(statement)
         return model
-    }
+    }
     func selectBySlideUuid(slideUuid: String)-> ProgressModel {
         let db = database.open()
         //var records = [ProgressModel]()
         var model = ProgressModel()
                 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 {
         let db = database.open()
         //var records = [ProgressModel]()
         var model = ProgressModel()
         var query = "SELECT "
                 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 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_step(statement) == SQLITE_ROW){
                 count = Int(sqlite3_column_int(statement, 0))
+            }
-        } else {
+        } else {
             database.printError()
+        }
         sqlite3_finalize(statement)
         return count;
+    }
     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_step(statement) == SQLITE_ROW){
                 count = Int(sqlite3_column_int(statement, 0))
+            }
-        } else {
+        } else {
             database.printError()
+        }
         sqlite3_finalize(statement)
         return count;
+    }
     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_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_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_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 SUM(" +  Constants.TABLE_PROGRESS_FIELD_RETURNING_AFTER_COMPLETED + ") 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_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_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_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_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) {
         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_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)")
             database.printError()
+        }
-        sqlite3_finalize(statement)
+        sqlite3_finalize(statement)
+    }
     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) {
         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)")
                 database.printError()
+            }
-        } else {
+        } else {
             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() {
         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 {
                 print("No se pudo borrar todos los registros en la tabla: \(Constants.TABLE_PROGRESS)")
                 database.printError()
-            }
+            }
         } else {
             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)
+    {
         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 {
                 print("No se pudo borrar todos los registros en la tabla: \(Constants.TABLE_PROGRESS)" +
                 " de los usuarios diferentes de : \(userUuid)" )
-                database.printError()
+            }
         } else {
             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 - Inconcert

(root)/twogetskills/Dao/ProgressDao.swift – Rev 1 → 15