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

 //
 //  Created by Efrain Yanez Recanatini on 7/31/22.
 //
-import UIKit
+import SwiftUI
+import SQLite3
 import SQLite3
 class UserNotificationDao {
-    private let SQLITE_TRANSIENT = unsafeBitCast(-1, to: sqlite3_destructor_type.self)
+    private var database = Environment(\.database).wrappedValue
-    public var db : OpaquePointer?
+    private let SQLITE_TRANSIENT = unsafeBitCast(-1, to: sqlite3_destructor_type.self)
     func selectById(id : Int)-> UserNotificationModel {
         let db = database.open()
         var model = UserNotificationModel ()
         sqlite3_finalize(statement)
         return model
+    }
-    func selectAllDistinctDateByUserUuid(userUuid : String) -> [String] {
+    func selectAllDistinctDateByUserUuid(userUuid : String) -> [String] {
         let db = database.open()
         var records = [String]()
         var query = "SELECT "
         return records
+    }
     func selectAllByUserUuidAndDate(userUuid : String, date : String)-> [UserNotificationModel] {
         let db = database.open()
         var records = [UserNotificationModel]()
         sqlite3_finalize(statement)
         return records
+    }
-    func selectAllByUserUuid(userUuid : String)-> [UserNotificationModel] {
+    func selectAllByUserUuid(userUuid : String)-> [UserNotificationModel] {
         let db = database.open()
         var records = [UserNotificationModel]()
         var query = "SELECT "
     func getCountByUserUuid(userUuid : String) -> Int {
         let db = database.open()
         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(conn))
+                result = Int(sqlite3_last_insert_rowid(db))
             } else {
         return result
+    }
     func markViewed(id : Int) {
         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_ID + " = '\(id)';"
+        }
         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 + " AND " + Constants.TABLE_USER_NOTIFICATION_FIELD_USER_UUID + " = '\(userUuid)'; "
+        }
         sqlite3_finalize(statement)
+    }
-    func markViewedAllPendingByUserUuidAndCommand(userUuid : String, command : String) {
+    func markViewedAllPendingByUserUuidAndCommand(userUuid : String, command : 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 + " AND " + Constants.TABLE_USER_NOTIFICATION_FIELD_USER_UUID + " = '\(userUuid)'; "
+    }
+    func removeExpired(userUuid : String)
     func removeExpired(userUuid : String)
         let db = database.open()
         let now = Date()
-    }
+    }
     func remove(id: Int) {
         let db = database.open()
         let query = "DELETE FROM " + Constants.TABLE_USER_NOTIFICATION
             + " WHERE " + Constants.TABLE_USER_NOTIFICATION_FIELD_ID + " = '\(id)' ;"
     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)' ;"

Proyectos de Subversion Iphone Microlearning - Inconcert

(root)/twogetskills/Dao/UserNotificationDao.swift – Rev 16 → 17