Proyectos de Subversion Iphone Microlearning - Nuevo Interface

Rev

Rev 19 | Rev 31 | Ir a la última revisión | | Comparar con el anterior | Ultima modificación | Ver Log |

Rev Autor Línea Nro. Línea
10 efrain 1 
//
2 
//  AppDao.swift
3 
//  twogetskills
4 
//
5 
//  Created by Efrain Yanez Recanatini on 8/3/22.
6 
//
7 
 
8 
import Foundation
9 
 
10 
import UIKit
11 
import SQLite3
12 
 
13 
class AppDao {
14 
    private let SQLITE_TRANSIENT = unsafeBitCast(-1, to: sqlite3_destructor_type.self)
19 efrain 15 
    private var database = Database.sharedInstance
10 efrain 16 
 
17 
    static let sharedInstance:AppDao = {
18 
           let instance = AppDao()
19 
 
20 
           // setup code
21 
           return instance
22 
    }()
23 
 
11 efrain 24 
    func insert(model: AppModel)  ->Int {
19 efrain 25 
        let db = database.open()
11 efrain 26 
        var result : Int = 0
27 
 
10 efrain 28 
        var query = "INSERT INTO " + Constants.TABLE_APP + " ( "
29 
        query = query + Constants.TABLE_APP_FIELD_DEVICE_UUID + ", "
30 
        query = query + Constants.TABLE_APP_FIELD_DEVICE_AES + ", "
31 
        query = query + Constants.TABLE_APP_FIELD_DEVICE_PASSWORD + ", "
32 
        query = query + Constants.TABLE_APP_FIELD_USER_UUID + ", "
33 
        query = query + Constants.TABLE_APP_FIELD_USER_FIRSTNAME + ", "
34 
        query = query + Constants.TABLE_APP_FIELD_USER_LASTNAME + ", "
35 
        query = query + Constants.TABLE_APP_FIELD_USER_EMAIL + ", "
36 
        query = query + Constants.TABLE_APP_FIELD_USER_IMAGE + ", "
37 
        query = query + Constants.TABLE_APP_FIELD_FCM_TOKEN + ", "
38 
        query = query + Constants.TABLE_APP_FIELD_TOPIC_UUID_ACTIVE + ", "
39 
        query = query + Constants.TABLE_APP_FIELD_CAPSULE_UUID_ACTIVE + ", "
40 
        query = query + Constants.TABLE_APP_FIELD_CAPSULE_UUID_OLD + ", "
41 
        query = query + Constants.TABLE_APP_FIELD_SLIDE_UUID_ACTIVE + ", "
11 efrain 42 
        query = query + Constants.TABLE_APP_FIELD_MAX_DATE_CHANGES + ", "
17 efrain 43 
        query = query + Constants.TABLE_APP_FIELD_COMPANY_UUID_ACTIVE + ", "
25 efrain 44 
        query = query + Constants.TABLE_APP_FIELD_URL_EXTERNAL_DOWNLOADED + ", "
45 
        query = query + Constants.TABLE_APP_FIELD_REFRESH_CONTENT_MESSAGE + ", "
46 
        query = query + Constants.TABLE_APP_FIELD_REFRESH_CONTENT_MESSAGE_SHOW_PENDING + ", "
47 
        query = query + Constants.TABLE_APP_FIELD_REFRESH_CONTENT_ACTION_REQUIRED
48 
        query = query +  ") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);"
10 efrain 49 
        var statement : OpaquePointer?
50 
 
51 
        if sqlite3_prepare_v2(db, query, -1, &statement, nil) == SQLITE_OK {
52 
            sqlite3_bind_text(statement, 1, model.deviceUuid, -1 , SQLITE_TRANSIENT)
53 
            sqlite3_bind_text(statement, 2, model.deviceAes, -1, SQLITE_TRANSIENT)
54 
            sqlite3_bind_text(statement, 3, model.devicePassword , -1, SQLITE_TRANSIENT)
55 
            sqlite3_bind_text(statement, 4, model.userUuid , -1, SQLITE_TRANSIENT)
56 
            sqlite3_bind_text(statement, 5, model.userFirstname , -1, SQLITE_TRANSIENT)
57 
            sqlite3_bind_text(statement, 6, model.userLastname , -1, SQLITE_TRANSIENT)
58 
            sqlite3_bind_text(statement, 7, model.userEmail , -1, SQLITE_TRANSIENT)
59 
            sqlite3_bind_text(statement, 8, model.userImage , -1, SQLITE_TRANSIENT)
60 
            sqlite3_bind_text(statement, 9, model.fcmToken , -1, SQLITE_TRANSIENT)
61 
            sqlite3_bind_text(statement, 10, model.topicUuidActive , -1, SQLITE_TRANSIENT)
62 
            sqlite3_bind_text(statement, 11, model.capsuleUuidActive , -1, SQLITE_TRANSIENT)
63 
            sqlite3_bind_text(statement, 12, model.capsuleUuidOld , -1, SQLITE_TRANSIENT)
64 
            sqlite3_bind_text(statement, 13, model.slideUuidActive , -1, SQLITE_TRANSIENT)
17 efrain 65 
            sqlite3_bind_text(statement, 14, model.maxDateChanges , -1, SQLITE_TRANSIENT)
66 
            sqlite3_bind_text(statement, 15, model.companyUuidActive , -1, SQLITE_TRANSIENT)
67 
            sqlite3_bind_text(statement, 16, model.urlExternalDownloaded, -1, SQLITE_TRANSIENT)
25 efrain 68 
            sqlite3_bind_text(statement, 17, model.refreshContentMessage, -1, SQLITE_TRANSIENT)
69 
            sqlite3_bind_int(statement, 18, Int32(model.refreshContentMessageShowPending ?  1 : 0))
70 
            sqlite3_bind_int(statement, 19, Int32(model.refreshContentActionRequired ? 1 : 0))
17 efrain 71 
 
10 efrain 72 
            if (sqlite3_step(statement) == SQLITE_DONE) {
73 
                result = Int(sqlite3_last_insert_rowid(db))
74 
           } else {
19 efrain 75 
                print("No se pudo insertar un registro en la tabla: \(Constants.TABLE_APP) ")
76 
                database.printError()
10 efrain 77 
           }
78 
 
79 
        } else {
80 
            print("Fallo la preparación del insertar en la tabla: \(Constants.TABLE_APP)")
19 efrain 81 
            database.printError()
10 efrain 82 
        }
83 
 
84 
        sqlite3_finalize(statement)
85 
 
86 
        return result
87 
     }
88 
 
89 
 
90 
 
11 efrain 91 
    func selectOne() -> AppModel {
19 efrain 92 
        let db = database.open()
10 efrain 93 
        var model = AppModel()
94 
 
11 efrain 95 
        var query = "SELECT " + Constants.TABLE_APP_FIELD_ID + ", "
96 
        query = query +  Constants.TABLE_APP_FIELD_DEVICE_UUID + ", "
10 efrain 97 
        query = query + Constants.TABLE_APP_FIELD_DEVICE_AES + ", "
98 
        query = query + Constants.TABLE_APP_FIELD_DEVICE_PASSWORD + ", "
99 
        query = query + Constants.TABLE_APP_FIELD_USER_UUID + ", "
100 
        query = query + Constants.TABLE_APP_FIELD_USER_FIRSTNAME + ", "
101 
        query = query + Constants.TABLE_APP_FIELD_USER_LASTNAME + ", "
102 
        query = query + Constants.TABLE_APP_FIELD_USER_EMAIL + ", "
103 
        query = query + Constants.TABLE_APP_FIELD_USER_IMAGE + ", "
104 
        query = query + Constants.TABLE_APP_FIELD_FCM_TOKEN + ", "
105 
        query = query + Constants.TABLE_APP_FIELD_TOPIC_UUID_ACTIVE + ", "
106 
        query = query + Constants.TABLE_APP_FIELD_CAPSULE_UUID_ACTIVE + ", "
107 
        query = query + Constants.TABLE_APP_FIELD_CAPSULE_UUID_OLD + ", "
108 
        query = query + Constants.TABLE_APP_FIELD_SLIDE_UUID_ACTIVE + ", "
11 efrain 109 
        query = query + Constants.TABLE_APP_FIELD_MAX_DATE_CHANGES + ", "
17 efrain 110 
        query = query + Constants.TABLE_APP_FIELD_COMPANY_UUID_ACTIVE + ", "
25 efrain 111 
        query = query + Constants.TABLE_APP_FIELD_URL_EXTERNAL_DOWNLOADED + ", "
112 
        query = query + Constants.TABLE_APP_FIELD_REFRESH_CONTENT_MESSAGE + ", "
113 
        query = query + Constants.TABLE_APP_FIELD_REFRESH_CONTENT_MESSAGE_SHOW_PENDING + ", "
114 
        query = query + Constants.TABLE_APP_FIELD_REFRESH_CONTENT_ACTION_REQUIRED
10 efrain 115 
        query = query + " FROM " + Constants.TABLE_APP
116 
        query = query + " LIMIT 1;"
117 
 
11 efrain 118 
        //print("selectOne : \(query)")
119 
 
10 efrain 120 
        var statement : OpaquePointer? = nil
121 
        if sqlite3_prepare_v2(db, query, -1, &statement, nil) == SQLITE_OK{
19 efrain 122 
            if sqlite3_step(statement) == SQLITE_ROW {
17 efrain 123 
 
10 efrain 124 
                model.id = Int(sqlite3_column_int(statement, 0))
125 
 
11 efrain 126 
 
10 efrain 127 
                model.deviceUuid = String(describing: String(cString: sqlite3_column_text(statement, 1)))
11 efrain 128 
 
10 efrain 129 
                model.deviceAes = String(describing: String(cString: sqlite3_column_text(statement, 2)))
17 efrain 130 
 
10 efrain 131 
                model.devicePassword = String(describing: String(cString: sqlite3_column_text(statement, 3)))
132 
 
133 
                model.userUuid = String(describing: String(cString: sqlite3_column_text(statement, 4)))
134 
                model.userFirstname = String(describing: String(cString: sqlite3_column_text(statement, 5)))
135 
                model.userLastname = String(describing: String(cString: sqlite3_column_text(statement, 6)))
136 
                model.userEmail = String(describing: String(cString: sqlite3_column_text(statement, 7)))
137 
                model.userImage = String(describing: String(cString: sqlite3_column_text(statement, 8)))
138 
 
139 
 
140 
                model.fcmToken = String(describing: String(cString: sqlite3_column_text(statement, 9)))
141 
 
142 
                model.topicUuidActive = String(describing: String(cString: sqlite3_column_text(statement, 10)))
17 efrain 143 
 
10 efrain 144 
                model.capsuleUuidActive = String(describing: String(cString: sqlite3_column_text(statement, 11)))
17 efrain 145 
 
10 efrain 146 
                model.capsuleUuidOld = String(describing: String(cString: sqlite3_column_text(statement, 12)))
17 efrain 147 
 
10 efrain 148 
                model.slideUuidActive = String(describing: String(cString: sqlite3_column_text(statement, 13)))
149 
 
150 
                model.maxDateChanges  = String(describing: String(cString: sqlite3_column_text(statement, 14)))
11 efrain 151 
 
152 
                model.companyUuidActive  = String(describing: String(cString: sqlite3_column_text(statement, 15)))
153 
 
17 efrain 154 
                model.urlExternalDownloaded  = String(describing: String(cString: sqlite3_column_text(statement, 16)))
155 
 
25 efrain 156 
                model.refreshContentMessage  = String(describing: String(cString: sqlite3_column_text(statement, 17)))
157 
 
158 
                model.refreshContentMessageShowPending = Int(sqlite3_column_int(statement, 18)) > 0
159 
                model.refreshContentActionRequired = Int(sqlite3_column_int(statement, 19)) > 0
10 efrain 160 
            }
19 efrain 161 
        } else {
162 
            database.printError()
10 efrain 163 
        }
19 efrain 164 
 
10 efrain 165 
        sqlite3_finalize(statement)
11 efrain 166 
 
10 efrain 167 
        return model
168 
    }
169 
 
170 
 
171 
 
11 efrain 172 
    func update(model: AppModel) {
19 efrain 173 
        let db = database.open()
11 efrain 174 
        var query = "UPDATE " + Constants.TABLE_APP + " SET "
175 
        query = query + Constants.TABLE_APP_FIELD_DEVICE_UUID + " = '\(model.deviceUuid)' , "
176 
        query = query + Constants.TABLE_APP_FIELD_DEVICE_AES + " = '\(model.deviceAes)' , "
177 
        query = query + Constants.TABLE_APP_FIELD_DEVICE_PASSWORD + " = '\(model.devicePassword)', "
178 
        query = query + Constants.TABLE_APP_FIELD_USER_UUID + " = '\(model.userUuid)', "
179 
        query = query + Constants.TABLE_APP_FIELD_USER_FIRSTNAME + " = '\(model.userFirstname)', "
180 
        query = query + Constants.TABLE_APP_FIELD_USER_LASTNAME + " = '\(model.userLastname)', "
181 
        query = query + Constants.TABLE_APP_FIELD_USER_EMAIL + " = '\(model.userEmail)', "
182 
        query = query + Constants.TABLE_APP_FIELD_USER_IMAGE + " = '\(model.userImage)', "
183 
        query = query + Constants.TABLE_APP_FIELD_FCM_TOKEN + " = '\(model.fcmToken)', "
184 
        query = query + Constants.TABLE_APP_FIELD_TOPIC_UUID_ACTIVE + " = '\(model.topicUuidActive)', "
185 
        query = query + Constants.TABLE_APP_FIELD_CAPSULE_UUID_ACTIVE + " = '\(model.capsuleUuidActive)', "
186 
        query = query + Constants.TABLE_APP_FIELD_CAPSULE_UUID_OLD + " = '\(model.capsuleUuidOld)', "
187 
        query = query + Constants.TABLE_APP_FIELD_SLIDE_UUID_ACTIVE + " = '\(model.slideUuidActive)', "
17 efrain 188 
 
11 efrain 189 
        query = query + Constants.TABLE_APP_FIELD_MAX_DATE_CHANGES + " = '\(model.maxDateChanges)', "
17 efrain 190 
        query = query + Constants.TABLE_APP_FIELD_COMPANY_UUID_ACTIVE + " = '\(model.companyUuidActive)', "
191 
        query = query + Constants.TABLE_APP_FIELD_URL_EXTERNAL_DOWNLOADED + " = '\(model.urlExternalDownloaded)' "
25 efrain 192 
        query = query + Constants.TABLE_APP_FIELD_REFRESH_CONTENT_MESSAGE + " = '\(model.refreshContentMessage)' "
193 
        query = query + Constants.TABLE_APP_FIELD_REFRESH_CONTENT_MESSAGE_SHOW_PENDING + " = '\(model.refreshContentMessageShowPending ? 1 : 0)' "
194 
        query = query + Constants.TABLE_APP_FIELD_REFRESH_CONTENT_ACTION_REQUIRED + " = '\(model.refreshContentActionRequired)' "
11 efrain 195 
        query = query + " WHERE " + Constants.TABLE_APP_FIELD_ID + " = '\(model.id)' "
10 efrain 196 
 
11 efrain 197 
 
198 
 
199 
 
19 efrain 200 
        //print("update query : \(query)")
11 efrain 201 
 
10 efrain 202 
        var statement : OpaquePointer? = nil
203 
        if sqlite3_prepare_v2(db, query, -1, &statement, nil) == SQLITE_OK{
204 
            if sqlite3_step(statement) != SQLITE_DONE {
205 
 
206 
                print("No se pudo actualizar un registro de la tabla: \(Constants.TABLE_APP)")
207 
 
19 efrain 208 
                database.printError()
209 
 
10 efrain 210 
            }
211 
        } else {
212 
            print("Fallo la preparación de actualizar un registro en la tabla: \(Constants.TABLE_APP)")
19 efrain 213 
 
214 
            database.printError()
10 efrain 215 
        }
216 
        sqlite3_finalize(statement)
217 
    }
218 
 
219 
 
220 
 
221 
 
222 
}