Proyectos de Subversion Iphone Microlearning - Inconcert

Rev

Rev 16 | Mostrar el archivo completo | | | Autoría | Ultima modificación | Ver Log |

Rev 16 Rev 17
Línea 3... Línea 3...
3 
//  twogetskills
 3 
//  twogetskills
4 
//
 4 
//
5 
//  Created by Efrain Yanez Recanatini on 2/21/22.
 5 
//  Created by Efrain Yanez Recanatini on 2/21/22.
6 
//
 6 
//
Línea 7... Línea 7...
7 
 
 7 
 
8 
import UIKit
 8 
import SwiftUI
Línea 9... Línea 9...
9 
import SQLite3
 9 
import SQLite3
- 
 
 10 
 
10 
 
 11 
class UserLogDao {
11 
class UserLogDao {
 - 
 
Línea 12... Línea 12...
12 
    private let SQLITE_TRANSIENT = unsafeBitCast(-1, to: sqlite3_destructor_type.self)
 12 
    private var database = Environment(\.database).wrappedValue
13 
    public var db : OpaquePointer?
 - 
 
- 
 
 13 
    private let SQLITE_TRANSIENT = unsafeBitCast(-1, to: sqlite3_destructor_type.self)
14
14
15 
    func selectByUserUuidAndActivityAndAddedOn(userUuid: String, activity : String, addedOn : String)-> UserLogModel {
 15 
    func selectByUserUuidAndActivityAndAddedOn(userUuid: String, activity : String, addedOn : String)-> UserLogModel {
16
16 
        let db = database.open()
17 
        var model = UserLogModel()
 17 
        var model = UserLogModel()
18 
        var sql = "SELECT "
 18 
        var sql = "SELECT "
Línea 54... Línea 54...
54 
    }
 54 
    }
Línea 55... Línea 55...
55
55
56
- 
 
- 
 
 56
57
57
58 
    func selectAll()-> [UserLogModel] {
 58 
    func selectAll()-> [UserLogModel] {
59
59 
        let db = database.open()
60 
        var records = [UserLogModel]()
 60 
        var records = [UserLogModel]()
61 
        var query = "SELECT "
 61 
        var query = "SELECT "
Línea 92... Línea 92...
92 
        sqlite3_finalize(statement)
 92 
        sqlite3_finalize(statement)
93 
        return records
 93 
        return records
94 
    }
 94 
    }
Línea 95... Línea 95...
95
95
96 
    func selectAllByUserUuid(userUuid : String)-> [UserLogModel] {
 - 
 
- 
 
 96 
    func selectAllByUserUuid(userUuid : String)-> [UserLogModel] {
97
97 
        let db = database.open()
98 
        var records = [UserLogModel]()
 98 
        var records = [UserLogModel]()
99 
        var query = "SELECT "
 99 
        var query = "SELECT "
100 
        query = query +  Constants.TABLE_USER_LOG_FIELD_ID + " , "
 100 
        query = query +  Constants.TABLE_USER_LOG_FIELD_ID + " , "
101 
        query = query +  Constants.TABLE_USER_LOG_FIELD_USER_UUID + " , "
 101 
        query = query +  Constants.TABLE_USER_LOG_FIELD_USER_UUID + " , "
Línea 132... Línea 132...
132 
        sqlite3_finalize(statement)
 132 
        sqlite3_finalize(statement)
133 
        return records
 133 
        return records
134 
    }
 134 
    }
Línea 135... Línea 135...
135
135
136 
    func insert(record : UserLogModel) {
 - 
 
- 
 
 136 
    func insert(record : UserLogModel) {
137
137 
        let db = database.open()
138 
        var query = "INSERT INTO " + Constants.TABLE_USER_LOG + " ( "
 138 
        var query = "INSERT INTO " + Constants.TABLE_USER_LOG + " ( "
139 
        query = query + Constants.TABLE_USER_LOG_FIELD_COMPANY_UUID + " , "
 139 
        query = query + Constants.TABLE_USER_LOG_FIELD_COMPANY_UUID + " , "
140 
        query = query + Constants.TABLE_USER_LOG_FIELD_USER_UUID + " , "
 140 
        query = query + Constants.TABLE_USER_LOG_FIELD_USER_UUID + " , "
141 
        query = query + Constants.TABLE_USER_LOG_FIELD_TOPIC_UUID + ", "
 141 
        query = query + Constants.TABLE_USER_LOG_FIELD_TOPIC_UUID + ", "
Línea 172... Línea 172...
172
172
173 
        sqlite3_finalize(statement)
 173 
        sqlite3_finalize(statement)
Línea 174... Línea 174...
174 
    }
 174 
    }
175 
 
 - 
 
- 
 
 175 
 
176 
    func remove(id: Int) {
 176 
    func remove(id: Int) {
177
177 
        let db = database.open()
178 
        let query = "DELETE FROM " + Constants.TABLE_USER_LOG + " WHERE " + Constants.TABLE_USER_LOG_FIELD_ID + " = " + "\(id) ;"
 178 
        let query = "DELETE FROM " + Constants.TABLE_USER_LOG + " WHERE " + Constants.TABLE_USER_LOG_FIELD_ID + " = " + "\(id) ;"
179 
        var statement : OpaquePointer? = nil
 179 
        var statement : OpaquePointer? = nil
180 
        if sqlite3_prepare_v2(db, query, -1, &statement, nil) == SQLITE_OK{
 180 
        if sqlite3_prepare_v2(db, query, -1, &statement, nil) == SQLITE_OK{
Línea 188... Línea 188...
188 
        }
 188 
        }
189 
        sqlite3_finalize(statement)
 189 
        sqlite3_finalize(statement)
190 
    }
 190 
    }
Línea 191... Línea 191...
191 
 
 191 
 
192 
    func removeAll() {
 - 
 
- 
 
 192 
    func removeAll() {
193
193 
        let db = database.open()
194 
        let query = "DELETE FROM " + Constants.TABLE_USER_LOG + ";"
 194 
        let query = "DELETE FROM " + Constants.TABLE_USER_LOG + ";"
195 
        var statement : OpaquePointer? = nil
 195 
        var statement : OpaquePointer? = nil
196 
        if sqlite3_prepare_v2(db, query, -1, &statement, nil) == SQLITE_OK{
 196 
        if sqlite3_prepare_v2(db, query, -1, &statement, nil) == SQLITE_OK{
197 
            if sqlite3_step(statement) != SQLITE_DONE {
 197 
            if sqlite3_step(statement) != SQLITE_DONE {
Línea 204... Línea 204...
204 
        }
 204 
        }
205 
        sqlite3_finalize(statement)
 205 
        sqlite3_finalize(statement)
206 
    }
 206 
    }
Línea 207... Línea 207...
207
207
208 
    func removeAllUserUuidNotEqual(userUuid : String) {
 - 
 
- 
 
 208 
    func removeAllUserUuidNotEqual(userUuid : String) {
209
209 
        let db = database.open()
210 
        let query = "DELETE FROM " + Constants.TABLE_USER_LOG
 210 
        let query = "DELETE FROM " + Constants.TABLE_USER_LOG
Línea 211... Línea 211...
211 
            + " WHERE " + Constants.TABLE_USER_LOG_FIELD_USER_UUID + " <> '" + userUuid + "' ";
 211 
            + " WHERE " + Constants.TABLE_USER_LOG_FIELD_USER_UUID + " <> '" + userUuid + "' ";
212
212