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

 import UIKit
 import SQLite3
 class UserNotificationDao {
     private let SQLITE_TRANSIENT = unsafeBitCast(-1, to: sqlite3_destructor_type.self)
-    private var database = Database.sharedInstance
-    static let sharedInstance: UserNotificationDao = {
-           let instance = UserNotificationDao()
-           // setup code
-           return instance
-    }()
+    private let db : OpaquePointer?
     func selectById(id : Int)-> UserNotificationModel {
         let db = database.open()
         var model = UserNotificationModel ()
                //print("\nSuccessfully get record")
-            }
+            }
         } else {
             database.printError()
+        }
         sqlite3_finalize(statement)
         return model
-    }
+    }
     func selectAllDistinctDateByUserUuid(userUuid : String) -> [String] {
         let db = database.open()
         var records = [String]()
                 records.append(date)
-            }
+            }
         } else {
             database.printError()
+        }
         sqlite3_finalize(statement)
         return records
-    }
+    }
     func selectAllByUserUuidAndDate(userUuid : String, date : String)-> [UserNotificationModel] {
         let db = database.open()
                 records.append(model)
-            }
+            }
         } else {
             database.printError()
+        }
         sqlite3_finalize(statement)
         return records
-    }
+    }
     func selectAllByUserUuid(userUuid : String)-> [UserNotificationModel] {
         let db = database.open()
         var records = [UserNotificationModel]()
                 records.append(model)
-            }
+            }
         } else {
             database.printError()
+        }
         sqlite3_finalize(statement)
         return records
-    }
+    }
                 count = Int(sqlite3_column_int(statement, 0))
                 //print("\(count)")
+            }
         } else {
             count = -1
-            database.printError()
+        }
         sqlite3_finalize(statement)
         return count
+    }
-    func insert(userNotification : UserNotificationModel) -> Int {
+    func insert(userNotification : UserNotificationModel) -> Int {
         let db = database.open()
         var result : Int = 0
         var query = "INSERT INTO " + Constants.TABLE_USER_NOTIFICATION + " ( "
         query = query + Constants.TABLE_USER_NOTIFICATION_FIELD_USER_UUID + ", "
         query = query + Constants.TABLE_USER_NOTIFICATION_FIELD_TITLE + ", "
             sqlite3_bind_text(statement, 6, userNotification.command, -1, SQLITE_TRANSIENT)
             sqlite3_bind_text(statement, 7, userNotification.dateOn, -1, SQLITE_TRANSIENT)
             sqlite3_bind_text(statement, 8, userNotification.timeOn , -1, SQLITE_TRANSIENT)
             if (sqlite3_step(statement) == SQLITE_DONE) {
-                result = Int(sqlite3_last_insert_rowid(db))
+                result = Int(sqlite3_last_insert_rowid(conn))
             } else {
-                 print("No se pudo insertar el registro en la tabla: \(Constants.TABLE_USER_NOTIFICATION)")
+                 print("No se pudo insertar el registro en la tabla: \(Constants.TABLE_USER_NOTIFICATION)")
                 database.printError()
-            }
+            }
         } else {
             print("Fallo la preparación del insertar un registro en la tabla: \(Constants.TABLE_USER_NOTIFICATION)")
             database.printError()
+        }
         sqlite3_finalize(statement)
         return result
+    }
     func markViewed(id : Int) {
         let db = database.open()
-        var query = "UPDATE " + Constants.TABLE_USER_NOTIFICATION
+        var query = "UPDATE " + Constants.TABLE_USER_NOTIFICATION
         query = query + " SET " + Constants.TABLE_USER_NOTIFICATION_FIELD_VIEWED + "  1 "
         query = query + " WHERE " + Constants.TABLE_USER_NOTIFICATION_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 actualizar un registro en la tabla: \(Constants.TABLE_USER_NOTIFICATION) ")
                 database.printError()
-            }
+            }
         } else {
             print("Fallo la preparación de la actualización de un registro en la tabla \(Constants.TABLE_USER_NOTIFICATION) ")
             database.printError()
+        }
         sqlite3_finalize(statement)
+    }
-    func markViewedAllPendingByUserUuid(userUuid : String) {
+    func markViewedAllPendingByUserUuid(userUuid : String) {
         let db = database.open()
         var query = "UPDATE " + Constants.TABLE_USER_NOTIFICATION
         query = query + " SET " + Constants.TABLE_USER_NOTIFICATION_FIELD_VIEWED + "  1 "
-        query = query + " WHERE " + Constants.TABLE_USER_NOTIFICATION_FIELD_VIEWED + " = 0 "
+        query = query + " WHERE " + Constants.TABLE_USER_NOTIFICATION_FIELD_VIEWED + " = 0 "
         query = query + " AND " + Constants.TABLE_USER_NOTIFICATION_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 actualizar un registro en la tabla: \(Constants.TABLE_USER_NOTIFICATION) ")
+                print("No se pudo actualizar un registro en la tabla: \(Constants.TABLE_USER_NOTIFICATION) ")
                 database.printError()
+            }
         } else {
             print("Fallo la preparación de la actualización de un registro en la tabla \(Constants.TABLE_USER_NOTIFICATION) ")
             database.printError()
+        }
         sqlite3_finalize(statement)
-    }
+    }
     func markViewedAllPendingByUserUuidAndCommand(userUuid : String, command : String) {
         let db = database.open()
-        var query = "UPDATE " + Constants.TABLE_USER_NOTIFICATION
+        var query = "UPDATE " + Constants.TABLE_USER_NOTIFICATION
         query = query + " SET " + Constants.TABLE_USER_NOTIFICATION_FIELD_VIEWED + " = 1 "
         query = query + " WHERE " + Constants.TABLE_USER_NOTIFICATION_FIELD_VIEWED + " = 0 "
         query = query + " AND " + Constants.TABLE_USER_NOTIFICATION_FIELD_USER_UUID + " = '\(userUuid)'; "
         let dateFormatter = DateFormatter()
         dateFormatter.dateFormat = Constants.FORMAT_DATE_YMD
-        let sDate = dateFormatter.string(from: date)
+        let sDate = dateFormatter.string(from: date)
         let db = database.open()
         var query = "DELETE FROM " + Constants.TABLE_USER_NOTIFICATION
         query = query + " WHERE " + Constants.TABLE_USER_NOTIFICATION_FIELD_USER_UUID + " = '\(userUuid)' "
         query = query + " AND " + Constants.TABLE_USER_NOTIFICATION_FIELD_DATE_ON + " < '\(sDate)' "
         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 los registros con fecha menor a : \(sDate) en la tabla: \(Constants.TABLE_USER_NOTIFICATION)")
-                database.printError()
+            }
         } else {
             print("Fallo la preparación del borrado de los registros con fecha menor a : \(sDate) en la tabla: \(Constants.TABLE_USER_NOTIFICATION)" )
-            database.printError()
+        }
         sqlite3_finalize(statement)
+    }
-    func remove(id: Int) {
+    func remove(id: Int) {
         let db = database.open()
         let query = "DELETE FROM " + Constants.TABLE_USER_NOTIFICATION
             + " WHERE " + Constants.TABLE_USER_NOTIFICATION_FIELD_ID + " = '\(id)' ;"
-        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 el registro con el id: \(id) en la tabla: \(Constants.TABLE_USER_NOTIFICATION)")
                 database.printError()
-            }
+            }
         } else {
             print("Fallo la preparación del borrado del registro con el id: \(id) en la tabla: \(Constants.TABLE_USER_NOTIFICATION)" )
             database.printError()
+        }
         sqlite3_finalize(statement)
+    }
     func removeAllUserUuidNotEqual(userUuid : String)
-    {
+    {
         let db = database.open()
         let query = "DELETE FROM " +  Constants.TABLE_USER_NOTIFICATION +
             " WHERE " + Constants.TABLE_USER_NOTIFICATION_FIELD_USER_UUID + " <> '\(userUuid)' ;"
         var statement : OpaquePointer? = nil

Proyectos de Subversion Iphone Microlearning - Inconcert

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