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

 import UIKit
 import SQLite3
 class UserLogDao {
     private let SQLITE_TRANSIENT = unsafeBitCast(-1, to: sqlite3_destructor_type.self)
-    private var database = Database.sharedInstance
-    static let sharedInstance: UserLogDao = {
-           let instance = UserLogDao()
-           // setup code
-           return instance
-    }()
     private let db : OpaquePointer?
     func selectByUserUuidAndActivityAndAddedOn(userUuid: String, activity : String, addedOn : String)-> UserLogModel {
         let db = database.open()
         var model = UserLogModel()
         var sql = "SELECT "
         sql = sql +  Constants.TABLE_USER_LOG_FIELD_ID + " , "
                 model.activity = String(describing: String(cString: sqlite3_column_text(statement, 6)))
                 model.addedOn = String(describing: String(cString: sqlite3_column_text(statement, 7)))
+            }
-        } else {
+        } else {
             database.printError()
+        }
         sqlite3_finalize(statement)
         return model
+    }
     func selectAll()-> [UserLogModel] {
         let db = database.open()
         var records = [UserLogModel]()
                 model.addedOn = String(describing: String(cString: sqlite3_column_text(statement, 7)))
                 records.append(model)
+            }
-        } else {
+        } else {
             database.printError()
+        }
         sqlite3_finalize(statement)
         return records
+    }
     func selectAllByUserUuid(userUuid : String)-> [UserLogModel] {
         let db = database.open()
         var records = [UserLogModel]()
         var query = "SELECT "
         query = query +  Constants.TABLE_USER_LOG_FIELD_ID + " , "
                 model.addedOn = String(describing: String(cString: sqlite3_column_text(statement, 7)))
                 records.append(model)
+            }
-        } else {
+        } else {
             database.printError()
+        }
         sqlite3_finalize(statement)
         return records
+    }
     func insert(record : UserLogModel) {
         let db = database.open()
         var query = "INSERT INTO " + Constants.TABLE_USER_LOG + " ( "
         query = query + Constants.TABLE_USER_LOG_FIELD_COMPANY_UUID + " , "
         query = query + Constants.TABLE_USER_LOG_FIELD_USER_UUID + " , "
             sqlite3_bind_text(statement, 6, record.activity , -1, SQLITE_TRANSIENT)
             sqlite3_bind_text(statement, 7, record.addedOn , -1, SQLITE_TRANSIENT)
             if (sqlite3_step(statement) != SQLITE_DONE) {
-                print("No se pudo insertar un registro en la tabla: \(Constants.TABLE_USER_LOG)")
+                print("No se pudo insertar un registro en la tabla: \(Constants.TABLE_USER_LOG)")
                 database.printError()
             } else {
-                print("Insertamos un registo de log")
+                print("Insertamos un registo de log")
                 database.printError()
+            }
         } else {
-            print("Fallo la preparación en el insertar un registro en la tabla: \(Constants.TABLE_USER_LOG)")
+            print("Fallo la preparación en el insertar un registro en la tabla: \(Constants.TABLE_USER_LOG)")
             database.printError()
+        }
         sqlite3_finalize(statement)
-    }
+    }
     func remove(id: Int) {
         let db = database.open()
         let query = "DELETE FROM " + Constants.TABLE_USER_LOG + " WHERE " + Constants.TABLE_USER_LOG_FIELD_ID + " = " + "\(id) ;"
         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 el registro con el id: \(id) en la tabla: \(Constants.TABLE_USER_LOG)")
                 database.printError()
-            }
+            }
         } else {
             print("No se pudo borrar el registro con id: \(id) en la tabla: \(Constants.TABLE_USER_LOG)")
             database.printError()
+        }
-        sqlite3_finalize(statement)
+        sqlite3_finalize(statement)
+    }
     func removeAll() {
         let db = database.open()
         let query = "DELETE FROM " + Constants.TABLE_USER_LOG + ";"
-        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_USER_LOG)")
-                database.printError()
+            }
         } else {
             print("Fallo la preparación de borrar todos los registros en la tabla: \(Constants.TABLE_USER_LOG)")
             database.printError()
-        }
+        }
         sqlite3_finalize(statement)
+    }
     func removeAllUserUuidNotEqual(userUuid : String) {
         let db = database.open()
         let query = "DELETE FROM " + Constants.TABLE_USER_LOG
             + " WHERE " + Constants.TABLE_USER_LOG_FIELD_USER_UUID + " <> '" + userUuid + "' ";
         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_USER_LOG) " +
+                print("No se pudo borrar todos los registros en la tabla: \(Constants.TABLE_USER_LOG) " +
                         " de usuarios diferents a : \(userUuid) ")
                 database.printError()
-            } else {
+            } else {
                 print("Se borraron todos los registros en la tabla: \(Constants.TABLE_USER_LOG) " +
                         " de usuarios diferents a : \(userUuid) ")
                 database.printError()

Proyectos de Subversion Iphone Microlearning - Inconcert

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