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

 import UIKit
 import SQLite3
 class TopicDao {
     private let SQLITE_TRANSIENT = unsafeBitCast(-1, to: sqlite3_destructor_type.self)
-    private var database = Database.sharedInstance
-    static let sharedInstance: TopicDao = {
-           let instance = TopicDao()
-           // setup code
-           return instance
-    }()
     private let db : OpaquePointer?
     func selectByUuid(uuid: String)-> TopicModel {
         let db = database.open()
         var model = TopicModel()
                 model.updatedOn = String(describing: String(cString: sqlite3_column_text(statement, 7)))
                 //print("\nSuccessfully get record")
+            }
-        } else {
+        } else {
             database.printError()
+        }
         sqlite3_finalize(statement)
         return model
+    }
     func selectAllBycompanyUuid(companyUuid: String)-> [TopicModel] {
         let db = database.open()
         var records = [TopicModel]()
                 records.append(model)
-            }
+            }
         } else {
             database.printError()
+        }
         sqlite3_finalize(statement)
         return records
-    }
+    }
     func selectAll()-> [TopicModel] {
         let db = database.open()
         var records = [TopicModel]()
         var query = "SELECT "
                 records.append(model)
-            }
+            }
         } else {
             database.printError()
+        }
         sqlite3_finalize(statement)
         return records
-    }
+    }
     func getCount() -> Int {
         let db = database.open()
                 count = Int(sqlite3_column_int(statement, 0))
                 //print("\(count)")
+            }
         } else {
             count = -1
-            database.printError()
+        }
         sqlite3_finalize(statement)
         return count
+    }
-    func insert(topic : TopicModel) {
+    func insert(topic : TopicModel) {
         let db = database.open()
         var query = "INSERT INTO " + Constants.TABLE_TOPIC + " ( "
         query = query + Constants.TABLE_TOPIC_FIELD_UUID + ", "
         query = query + Constants.TABLE_TOPIC_FIELD_COMPANY_UUID + ", "
         query = query + Constants.TABLE_TOPIC_FIELD_NAME + ", "
             sqlite3_bind_text(statement, 7, topic.addedOn , -1, SQLITE_TRANSIENT)
             sqlite3_bind_text(statement, 8, topic.updatedOn , -1, SQLITE_TRANSIENT)
            if (sqlite3_step(statement) != SQLITE_DONE) {
-                print("No se pudo insertar un registro en la tabla: \(Constants.TABLE_TOPIC)")
+                print("No se pudo insertar un registro en la tabla: \(Constants.TABLE_TOPIC)")
                 database.printError()
+           }
-        } else {
+        } else {
             print("Fallo la preparación del insertar un registro en la tabla: \(Constants.TABLE_TOPIC)")
             database.printError()
+        }
         sqlite3_finalize(statement)
+    }
     func update(topic: TopicModel) {
         let db = database.open()
         query = query + " WHERE " + Constants.TABLE_TOPIC_FIELD_UUID + " = '\(topic.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 actualizar un registro en la tabla: \(Constants.TABLE_TOPIC) ")
-                database.printError()
+            }
         } else {
             print("Fallo la preparación de la actualización de un registro en la tabla \(Constants.TABLE_TOPIC) ")
-            database.printError()
+        }
         sqlite3_finalize(statement)
+    }
-    func remove(uuid: String) {
+    func remove(uuid: String) {
         let db = database.open()
         let query = "DELETE FROM " + Constants.TABLE_TOPIC
             + " WHERE " + Constants.TABLE_TOPIC_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_TOPIC)")
+                print("No se pudo borrar el registro con el uuid: \(uuid) en la tabla: \(Constants.TABLE_TOPIC)")
                 database.printError()
+            }
         } else {
-            print("Fallo la preparación del borrado del registro con el uuid: \(uuid) en la tabla: \(Constants.TABLE_TOPIC)" )
+            print("Fallo la preparación del borrado del registro con el uuid: \(uuid) en la tabla: \(Constants.TABLE_TOPIC)" )
             database.printError()
+        }
         sqlite3_finalize(statement)
+    }
     func removeAll() {
         let db = database.open()
         let query = "DELETE FROM " + Constants.TABLE_TOPIC + ";"
         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("Fallo el borrado de todos los registros en la tabla: \(Constants.TABLE_TOPIC)")
                 database.printError()
+            }
-        } else {
+        } else {
             print("No se pudo preparar el borrado de todos los registros en la tabla: \(Constants.TABLE_TOPIC) ")
             database.printError()
+        }
         sqlite3_finalize(statement)

Proyectos de Subversion Iphone Microlearning - Inconcert

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