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 5... Línea 5...
5 
//  Created by Efrain Yanez Recanatini on 8/3/22.
 5 
//  Created by Efrain Yanez Recanatini on 8/3/22.
6 
//
 6 
//
Línea 7... Línea 7...
7 
 
 7 
 
Línea 8... Línea 8...
8 
import Foundation
 8 
import Foundation
9 
 
 9 
 
Línea 10... Línea 10...
10 
import UIKit
 10 
import SwiftUI
- 
 
 11 
import SQLite3
11 
import SQLite3
 12 
 
12 
 
 - 
 
13 
class AppDao {
 13 
class AppDao {
14 
    private let SQLITE_TRANSIENT = unsafeBitCast(-1, to: sqlite3_destructor_type.self)
 14 
    private var database = Environment(\.database).wrappedValue
15 
    public var db : OpaquePointer?
 - 
 
- 
 
 15 
    private let SQLITE_TRANSIENT = unsafeBitCast(-1, to: sqlite3_destructor_type.self)
16
16 
 
Línea 17... Línea 17...
17 
     func insert(model: AppModel)  ->Int {
 17 
     func insert(model: AppModel)  ->Int {
18
18 
         let db = database.open()
19 
        var result : Int = 0
 19 
        var result : Int = 0
Línea 39... Línea 39...
39 
        query = query + Constants.TABLE_APP_FIELD_REFRESH_CONTENT_MESSAGE_SHOW_PENDING + ", "
 39 
        query = query + Constants.TABLE_APP_FIELD_REFRESH_CONTENT_MESSAGE_SHOW_PENDING + ", "
40 
        query = query + Constants.TABLE_APP_FIELD_REFRESH_CONTENT_ACTION_REQUIRED + ", "
 40 
        query = query + Constants.TABLE_APP_FIELD_REFRESH_CONTENT_ACTION_REQUIRED + ", "
41 
        query = query + Constants.TABLE_APP_FIELD_SIGNOUT_ACTION_REQUIRED
 41 
        query = query + Constants.TABLE_APP_FIELD_SIGNOUT_ACTION_REQUIRED
42 
        query = query +  ") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);"
 42 
        query = query +  ") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);"
43 
        var statement : OpaquePointer?
 43 
        var statement : OpaquePointer?
44 
 
 44
45 
        if sqlite3_prepare_v2(db, query, -1, &statement, nil) == SQLITE_OK {
 45 
        if sqlite3_prepare_v2(db, query, -1, &statement, nil) == SQLITE_OK {
46 
            sqlite3_bind_text(statement, 1, model.deviceUuid, -1 , SQLITE_TRANSIENT)
 46 
            sqlite3_bind_text(statement, 1, model.deviceUuid, -1 , SQLITE_TRANSIENT)
47 
            sqlite3_bind_text(statement, 2, model.deviceAes, -1, SQLITE_TRANSIENT)
 47 
            sqlite3_bind_text(statement, 2, model.deviceAes, -1, SQLITE_TRANSIENT)
48 
            sqlite3_bind_text(statement, 3, model.devicePassword , -1, SQLITE_TRANSIENT)
 48 
            sqlite3_bind_text(statement, 3, model.devicePassword , -1, SQLITE_TRANSIENT)
49 
            sqlite3_bind_text(statement, 4, model.userUuid , -1, SQLITE_TRANSIENT)
 49 
            sqlite3_bind_text(statement, 4, model.userUuid , -1, SQLITE_TRANSIENT)
Línea 82... Línea 82...
82 
     }
 82 
     }
Línea 83... Línea 83...
83
83
84
- 
 
- 
 
 84
85
85
Línea 86... Línea 86...
86 
    func selectOne() -> AppModel {
 86 
    func selectOne() -> AppModel {
87
87 
        let db = database.open()
88 
        var model = AppModel()
 88 
        var model = AppModel()
Línea 165... Línea 165...
165 
    }
 165 
    }
Línea 166... Línea 166...
166
166
167
- 
 
- 
 
 167
168
168
169 
    func update(model: AppModel) {
 169 
    func update(model: AppModel) {
170
170 
        let db = database.open()
171 
        var query = "UPDATE " + Constants.TABLE_APP + " SET "
 171 
        var query = "UPDATE " + Constants.TABLE_APP + " SET "
172 
        query = query + Constants.TABLE_APP_FIELD_DEVICE_UUID + " = '\(model.deviceUuid)' , "
 172 
        query = query + Constants.TABLE_APP_FIELD_DEVICE_UUID + " = '\(model.deviceUuid)' , "