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

 //  twogetskills
 //
 //  Created by Efrain Yanez Recanatini on 2/21/22.
 //
-import UIKit
+import SwiftUI
 import SQLite3
 class ProgressDao {
-class ProgressDao {
-    private let SQLITE_TRANSIENT = unsafeBitCast(-1, to: sqlite3_destructor_type.self)
+    private var database = Environment(\.database).wrappedValue
+    private let SQLITE_TRANSIENT = unsafeBitCast(-1, to: sqlite3_destructor_type.self)
     private var db : Database.sharedInstance.open()
     func selectByTopicUuid(topicUuid: String)-> ProgressModel {
         let db = database.open()
         //var records = [ProgressModel]()
         var model = ProgressModel()
         var query = "SELECT "
         return model
+    }
     func selectByTopicUuidAndUserUuid(topicUuid: String, userUuid : String)-> ProgressModel {
         let db = database.open()
         //var records = [ProgressModel]()
         var model = ProgressModel()
         var query = "SELECT "
         sqlite3_finalize(statement)
         return model
+    }
-    func selectByCapsuleUuid(capsuleUuid: String)-> ProgressModel {
+    func selectByCapsuleUuid(capsuleUuid: String)-> ProgressModel {
         let db = database.open()
         //var records = [ProgressModel]()
         var model = ProgressModel()
         var query = "SELECT "
         query = query +  Constants.TABLE_PROGRESS_FIELD_ID + " , "
         return model
+    }
     func selectByCapsuleUuidAndUserUuid(capsuleUuid: String, userUuid : String)-> ProgressModel {
         let db = database.open()
         //var records = [ProgressModel]()
         var model = ProgressModel()
         var query  = "SELECT "
         return model
+    }
     func selectBySlideUuid(slideUuid: String)-> ProgressModel {
         let db = database.open()
         //var records = [ProgressModel]()
         var model = ProgressModel()
         var query = "SELECT "
         return model
+    }
     func selectBySlideUuidAndUserUuid(slideUuid: String, userUuid : String)-> ProgressModel {
         let db = database.open()
         //var records = [ProgressModel]()
         var model = ProgressModel()
         var query = "SELECT "
         sqlite3_finalize(statement)
         return model
+    }
-    func getCountSlideCompletedByCapsuleUuidAndUserUuid(capsuleUuid: String, userUuid: String) -> Int {
+    func getCountSlideCompletedByCapsuleUuidAndUserUuid(capsuleUuid: String, userUuid: String) -> Int {
         let db = database.open()
         let query = "SELECT COUNT(*) AS total FROM " +  Constants.TABLE_PROGRESS +
         " WHERE " +  Constants.TABLE_PROGRESS_FIELD_CAPSULE_UUID + " = '\(capsuleUuid)' "  +
         " AND " +  Constants.TABLE_PROGRESS_FIELD_USER_UUID + "= '\(userUuid)'" +
         " AND " +  Constants.TABLE_PROGRESS_FIELD_TYPE + "= '\(Constants.PROGRESS_TYPE_SLIDE)'" +
         sqlite3_finalize(statement)
         return count;
+    }
-    func getCountSlideCompletedByTopicUuidAndUserUuid(topicUuid: String, userUuid: String) -> Int {
+    func getCountSlideCompletedByTopicUuidAndUserUuid(topicUuid: String, userUuid: String) -> Int {
         let db = database.open()
         let query = "SELECT COUNT(*) AS total FROM " +  Constants.TABLE_PROGRESS +
         " WHERE " +  Constants.TABLE_PROGRESS_FIELD_TOPIC_UUID + " = '\(topicUuid)' "  +
         " AND " +  Constants.TABLE_PROGRESS_FIELD_USER_UUID + "= '\(userUuid)'" +
         " AND " +  Constants.TABLE_PROGRESS_FIELD_TYPE + "= '\(Constants.PROGRESS_TYPE_SLIDE)'" +
         sqlite3_finalize(statement)
         return count;
+    }
-    func getCountCapsulesCompletedByUserUuid(userUuid : String) -> Int {
+    func getCountCapsulesCompletedByUserUuid(userUuid : String) -> Int {
         let db = database.open()
         var count = 0
         let query = "SELECT COUNT(*) AS total FROM " +  Constants.TABLE_PROGRESS +
             " WHERE " +  Constants.TABLE_PROGRESS_FIELD_USER_UUID + " = '\(userUuid)' " +
             " AND " +  Constants.TABLE_PROGRESS_FIELD_TYPE + "= '\( Constants.PROGRESS_TYPE_CAPSULE)' " +
         sqlite3_finalize(statement)
         return count
+    }
-    func getCountCapsulesIncompletedByUserUuid(userUuid : String) -> Int {
+    func getCountCapsulesIncompletedByUserUuid(userUuid : String) -> Int {
         let db = database.open()
         var count = 0
         let query = "SELECT COUNT(*) AS total FROM " +  Constants.TABLE_PROGRESS +
             " WHERE " +  Constants.TABLE_PROGRESS_FIELD_USER_UUID + " = '\(userUuid)' " +
             " AND " +  Constants.TABLE_PROGRESS_FIELD_TYPE + "= '\( Constants.PROGRESS_TYPE_CAPSULE)' " +
         sqlite3_finalize(statement)
         return count
+    }
-    func getCountCapsulesCompletedByTopicUuid(topicUuid : String) -> Int {
+    func getCountCapsulesCompletedByTopicUuid(topicUuid : String) -> Int {
         let db = database.open()
         var count = 0
         let query = "SELECT COUNT(*) AS total FROM " +  Constants.TABLE_PROGRESS +
             " WHERE " +  Constants.TABLE_PROGRESS_FIELD_TOPIC_UUID + " = '\(topicUuid)' " +
             " AND " +  Constants.TABLE_PROGRESS_FIELD_TYPE + "= '\( Constants.PROGRESS_TYPE_CAPSULE)' " +
         sqlite3_finalize(statement)
         return count
+    }
-    func getCountCapsulesCompletedWithReturningByUserUuid(userUuid : String) -> Int {
+    func getCountCapsulesCompletedWithReturningByUserUuid(userUuid : String) -> Int {
         let db = database.open()
         var count = 0
         let query = "SELECT SUM(" +  Constants.TABLE_PROGRESS_FIELD_RETURNING_AFTER_COMPLETED + ") AS total FROM " +  Constants.TABLE_PROGRESS
             + " WHERE " +  Constants.TABLE_PROGRESS_FIELD_USER_UUID + " = '\(userUuid)' " +
             " AND " +  Constants.TABLE_PROGRESS_FIELD_TYPE + "= '\( Constants.PROGRESS_TYPE_CAPSULE)' " +
         sqlite3_finalize(statement)
         return count
+    }
-    func getCountCapsulesCompletedWithoutReturningByUserUuid(userUuid : String) -> Int {
+    func getCountCapsulesCompletedWithoutReturningByUserUuid(userUuid : String) -> Int {
         let db = database.open()
         var count = 0
         let query = "SELECT COUNT(*) AS total FROM " +  Constants.TABLE_PROGRESS + " WHERE "
             +  Constants.TABLE_PROGRESS_FIELD_USER_UUID + " = '\(userUuid)' " +
             " AND " +  Constants.TABLE_PROGRESS_FIELD_TYPE + "= '\( Constants.PROGRESS_TYPE_CAPSULE)' " +
         sqlite3_finalize(statement)
         return count
+    }
-    func getCountCapsulesCompletedWithReturningByTopicUuid(topicUuid : String) -> Int {
+    func getCountCapsulesCompletedWithReturningByTopicUuid(topicUuid : String) -> Int {
         let db = database.open()
         var count = 0
         let query = "SELECT COUNT(*) AS total FROM " +  Constants.TABLE_PROGRESS
             + " WHERE " +  Constants.TABLE_PROGRESS_FIELD_TOPIC_UUID + " = '\(topicUuid)' " +
             " AND " +  Constants.TABLE_PROGRESS_FIELD_TYPE + "= '\( Constants.PROGRESS_TYPE_CAPSULE)' " +
         sqlite3_finalize(statement)
         return count
+    }
-    func getCountCapsulesCompletedWithoutReturningByTopicUuid(topicUuid : String) -> Int {
+    func getCountCapsulesCompletedWithoutReturningByTopicUuid(topicUuid : String) -> Int {
         let db = database.open()
         var count = 0
         let query = "SELECT COUNT(*) AS total FROM " +  Constants.TABLE_PROGRESS + " WHERE "
             +  Constants.TABLE_PROGRESS_FIELD_TOPIC_UUID + " = '\(topicUuid)' " +
             " AND " +  Constants.TABLE_PROGRESS_FIELD_TYPE + "= '\( Constants.PROGRESS_TYPE_CAPSULE)' " +
         return count
+    }
     func insert( record : ProgressModel) {
         let db = database.open()
         var query = "INSERT INTO " +  Constants.TABLE_PROGRESS + " ( "
         query = query +  Constants.TABLE_PROGRESS_FIELD_COMPANY_UUID + ", "
         query = query +  Constants.TABLE_PROGRESS_FIELD_USER_UUID + ", "
         sqlite3_finalize(statement)
+    }
     func update(record : ProgressModel) {
         let db = database.open()
         var query = "UPDATE " +  Constants.TABLE_PROGRESS
         query = query + " SET " +  Constants.TABLE_PROGRESS_FIELD_TOTAL_SLIDES + " = '\(record.totalSlides)', "
         query = query +  Constants.TABLE_PROGRESS_FIELD_VIEW_SLIDES + " = '\(record.viewSlides)', "
+        }
         sqlite3_finalize(statement)
+    }
-    func remove(id: Int) {
+    func remove(id: Int) {
         let db = database.open()
         let query = "DELETE FROM " +  Constants.TABLE_PROGRESS + " WHERE " +  Constants.TABLE_PROGRESS_FIELD_ID + " = " + "\(id) ;"
         var statement : OpaquePointer? = nil
         if (sqlite3_prepare_v2(db, query, -1, &statement, nil) == SQLITE_OK) {
             if sqlite3_step(statement) != SQLITE_DONE {
+        }
         sqlite3_finalize(statement)
+    }
-    func removeAll() {
+    func removeAll() {
         let db = database.open()
         let query = "DELETE FROM " +  Constants.TABLE_PROGRESS + ";"
         var statement : OpaquePointer? = nil
         if (sqlite3_prepare_v2(db, query, -1, &statement, nil) == SQLITE_OK) {
             if sqlite3_step(statement) != SQLITE_DONE {
         sqlite3_finalize(statement)
+    }
     func removeAllUserUuidNotEqual(userUuid : String)
-    {
+    {
         let db = database.open()
         let query = "DELETE FROM " +  Constants.TABLE_PROGRESS +
             " WHERE " + Constants.TABLE_PROGRESS_FIELD_USER_UUID + " <> '\(userUuid)' ;"
         var statement : OpaquePointer? = nil
         if (sqlite3_prepare_v2(db, query, -1, &statement, nil) == SQLITE_OK) {

Proyectos de Subversion Iphone Microlearning - Inconcert

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