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

 import UIKit
 import SQLite3
 class CapsuleDao {
     private let SQLITE_TRANSIENT = unsafeBitCast(-1, to: sqlite3_destructor_type.self)
-    private var database = Database.sharedInstance
-    static let sharedInstance: CapsuleDao = {
-           let instance = CapsuleDao()
-           // setup code
-           return instance
-    }()
     private let db : OpaquePointer?
     func getCountAll() -> Int {
         let db = database.open()
         var count = 0
         sqlite3_finalize(statement)
         return count
+    }
-    func getCountByTopicUuid(topicUuid: String) -> Int {
+    func getCountByTopicUuid(topicUuid: String) -> Int {
         let db = database.open()
         var count = 0
         let query = "SELECT COUNT(*) AS total FROM " +  Constants.TABLE_CAPSULE +
             " WHERE " +  Constants.TABLE_CAPSULE_FIELD_TOPIC_UUID + " = \(topicUuid) LIMIT 1"
+        }
         sqlite3_finalize(statement)
         return count
+    }
-    func selectAll()-> [CapsuleModel] {
+    func selectAll() -> [CapsuleModel] {
         let db = database.open()
         var records = [CapsuleModel]()
         var query = "SELECT "
         query = query + Constants.TABLE_CAPSULE_FIELD_UUID + ", "
         query = query + Constants.TABLE_CAPSULE_FIELD_TOPIC_UUID + " , "
         sqlite3_finalize(statement)
         return records
+    }
-    func selectAllByTopicUuid(topicUuid: String)-> [CapsuleModel] {
+    func selectAllByTopicUuid(topicUuid: String)-> [CapsuleModel] {
         let db = database.open()
         var records = [CapsuleModel]()
         var query = "SELECT "
         query = query + Constants.TABLE_CAPSULE_FIELD_UUID + ", "
         query = query + Constants.TABLE_CAPSULE_FIELD_TOPIC_UUID + " , "
         sqlite3_finalize(statement)
         return records
+    }
-    func selectLastPendingByUserUuid(userUuid: String)-> [CapsuleModel] {
+    func selectLastPendingByUserUuid(userUuid: String)-> [CapsuleModel] {
         let db = database.open()
         var records = [CapsuleModel]()
         var query = "SELECT "
         query = query + Constants.TABLE_CAPSULE_FIELD_UUID + ", "
         query = query + Constants.TABLE_CAPSULE_FIELD_TOPIC_UUID + " , "
         sqlite3_finalize(statement)
         return records
+    }
-    func selectAllPendingByUserUuid(userUuid: String, search : String = "")-> [CapsuleModel] {
+    func selectAllPendingByUserUuid(userUuid: String, search : String = "")-> [CapsuleModel] {
         let db = database.open()
         var records = [CapsuleModel]()
         var query = "SELECT "
         query = query + Constants.TABLE_CAPSULE_FIELD_UUID + ", "
         query = query + Constants.TABLE_CAPSULE_FIELD_TOPIC_UUID + " , "
         sqlite3_finalize(statement)
         return records
+    }
-    func selectAllInProgressByUserUuid(userUuid: String, search : String = "")-> [CapsuleModel] {
+    func selectAllInProgressByUserUuid(userUuid: String, search : String = "")-> [CapsuleModel] {
         let db = database.open()
         var records = [CapsuleModel]()
         var query = "SELECT "
         query = query + Constants.TABLE_CAPSULE_FIELD_UUID + ", "
         query = query + Constants.TABLE_CAPSULE_FIELD_TOPIC_UUID + " , "
         sqlite3_finalize(statement)
         return records
+    }
-    func selectAllCompletedByUserUuid(userUuid: String, search : String = "")-> [CapsuleModel] {
+    func selectAllCompletedByUserUuid(userUuid: String, search : String = "")-> [CapsuleModel] {
         let db = database.open()
         var records = [CapsuleModel]()
         var query = "SELECT "
         query = query + Constants.TABLE_CAPSULE_FIELD_UUID + ", "
         query = query + Constants.TABLE_CAPSULE_FIELD_TOPIC_UUID + " , "
         sqlite3_finalize(statement)
         return records
+    }
-    func selectLastInProgress(userUuid: String)-> CapsuleModel {
+    func selectLastInProgress(userUuid: String)-> CapsuleModel {
         let db = database.open()
         var model = CapsuleModel()
         var query = "SELECT " + Constants.TABLE_CAPSULE_FIELD_UUID + ", "
         query = query + Constants.TABLE_CAPSULE_FIELD_TOPIC_UUID + " , "
         query = query + Constants.TABLE_CAPSULE_FIELD_NAME + "  ,  "
      WHERE uuid IN (SELECT capsule_uuid FROM tb_progress WHERE type = 'c' AND user_uuid = '4cf9fb4b-0190-4bb4-9369-15eb68e9cace' AND completed = 0)
      ORDER BY name
      */
-    func selectByUuid(uuid: String)-> CapsuleModel {
+    func selectByUuid(uuid: String)-> CapsuleModel {
         let db = database.open()
         var model = CapsuleModel()
         var query = "SELECT " + Constants.TABLE_CAPSULE_FIELD_UUID + ", "
         query = query + Constants.TABLE_CAPSULE_FIELD_TOPIC_UUID + " , "
         query = query + Constants.TABLE_CAPSULE_FIELD_NAME + "  ,  "
                 model.addedOn = String(describing: String(cString: sqlite3_column_text(statement, 10)))
                 model.updatedOn  = String(describing: String(cString: sqlite3_column_text(statement, 11)))
+            }
-        } else {
+        } else {
             database.printError()
+        }
         sqlite3_finalize(statement)
         return model
+    }
     func insert(capsule: CapsuleModel) {
         let db = database.open()
         var query = "INSERT INTO " + Constants.TABLE_CAPSULE + " ( "
         query = query + Constants.TABLE_CAPSULE_FIELD_UUID + ", "
         query = query + Constants.TABLE_CAPSULE_FIELD_TOPIC_UUID + ", "
             sqlite3_bind_text(statement, 12, capsule.updatedOn , -1, SQLITE_TRANSIENT)
            if (sqlite3_step(statement) != SQLITE_DONE) {
-                print("No se pudo insertar un registro en la tabla: \(Constants.TABLE_CAPSULE)")
+                print("No se pudo insertar un registro en la tabla: \(Constants.TABLE_CAPSULE)")
                 database.printError()
+           }
-        } else {
+        } else {
             print("Fallo la prepración de insertar un registro en la tabla: \(Constants.TABLE_CAPSULE)")
             database.printError()
+        }
         sqlite3_finalize(statement)
+    }
     func update(capsule : CapsuleModel) {
         let db = database.open()
         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_CAPSULE)")
                 database.printError()
+            }
         } else {
-            print("Fallo la preparación para actualizar un registro en la tabla: \(Constants.TABLE_CAPSULE)")
+            print("Fallo la preparación para actualizar un registro en la tabla: \(Constants.TABLE_CAPSULE)")
             database.printError()
+        }
         sqlite3_finalize(statement)
-    }
+    }
     func remove(uuid: String) {
         let db = database.open()
         let query = "DELETE FROM " + Constants.TABLE_CAPSULE +
-            " WHERE " + Constants.TABLE_CAPSULE_FIELD_UUID + " = " + "\(uuid) ;"
+            " WHERE " + Constants.TABLE_CAPSULE_FIELD_UUID + " = " + "\(uuid) ;"
         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 borrar el registro con el uuid: \(uuid) en la tabla: \(Constants.TABLE_CAPSULE)")
+                print("No se pudo borrar el registro con el uuid: \(uuid) en la tabla: \(Constants.TABLE_CAPSULE)")
                 database.printError()
+            }
         } else {
-            print("Fallo la preparación de borrar un registro con el uuid: \(uuid) en la tabla: \(Constants.TABLE_CAPSULE)")
+            print("Fallo la preparación de borrar un registro con el uuid: \(uuid) en la tabla: \(Constants.TABLE_CAPSULE)")
             database.printError()
+        }
         sqlite3_finalize(statement)
+    }
     func removeAll() {
         let db = database.open()
         let query = "DELETE FROM " + Constants.TABLE_CAPSULE + ";"
-        var statement : OpaquePointer? = nil
+        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 borrar todos los registros en la tabla: \(Constants.TABLE_CAPSULE)")

Proyectos de Subversion Iphone Microlearning - Inconcert

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