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

 //  twogetskills
 //
 //  Created by Efrain Yanez Recanatini on 2/21/22.
 //
-import UIKit
+import SwiftUI
 import SQLite3
 class CapsuleDao {
-class CapsuleDao {
+    private var database = Environment(\.database).wrappedValue
     private let SQLITE_TRANSIENT = unsafeBitCast(-1, to: sqlite3_destructor_type.self)
-    private var db : Database.sharedInstance.open()
     func getCountAll() -> Int {
         let db = database.open()
         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 + "  ,  "
         sqlite3_finalize(statement)
         return model
+    }
-    func insert(capsule: CapsuleModel) {
+    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 + ", "
         query = query + Constants.TABLE_CAPSULE_FIELD_NAME + ", "
         sqlite3_finalize(statement)
+    }
     func update(capsule : CapsuleModel) {
         let db = database.open()
         var query = "UPDATE " + Constants.TABLE_CAPSULE
         query = query + " SET " + Constants.TABLE_CAPSULE_FIELD_NAME + " = '\(capsule.name)', "
         query = query + Constants.TABLE_CAPSULE_FIELD_DESCRIPTION + " = '\(capsule.description)', "
+    }
     func remove(uuid: String) {
         let db = database.open()
         let query = "DELETE FROM " + Constants.TABLE_CAPSULE +
             " WHERE " + Constants.TABLE_CAPSULE_FIELD_UUID + " = " + "\(uuid) ;"
+        }
         sqlite3_finalize(statement)
+    }
-    func removeAll() {
+    func removeAll() {
         let db = database.open()
         let query = "DELETE FROM " + Constants.TABLE_CAPSULE + ";"
         var statement : OpaquePointer? = nil
         if (sqlite3_prepare_v2(db, query, -1, &statement, nil) == SQLITE_OK) {
             if (sqlite3_step(statement) != SQLITE_DONE) {

Proyectos de Subversion Iphone Microlearning - Inconcert

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