Proyectos de Subversion Iphone Microlearning - Inconcert

//
//  AppDao.swift
//  twogetskills
//
//  Created by Efrain Yanez Recanatini on 8/3/22.
//

import Foundation

import UIKit
import SQLite3

class AppDao {
    private let SQLITE_TRANSIENT = unsafeBitCast(-1, to: sqlite3_destructor_type.self)
    private let db : OpaquePointer?
    
     func insert(model: AppModel)  ->Int {
        
        var result : Int = 0
        
        var query = "INSERT INTO " + Constants.TABLE_APP + " ( "
        query = query + Constants.TABLE_APP_FIELD_DEVICE_UUID + ", "
        query = query + Constants.TABLE_APP_FIELD_DEVICE_AES + ", "
        query = query + Constants.TABLE_APP_FIELD_DEVICE_PASSWORD + ", "
        query = query + Constants.TABLE_APP_FIELD_USER_UUID + ", "
        query = query + Constants.TABLE_APP_FIELD_USER_FIRSTNAME + ", "
        query = query + Constants.TABLE_APP_FIELD_USER_LASTNAME + ", "
        query = query + Constants.TABLE_APP_FIELD_USER_EMAIL + ", "
        query = query + Constants.TABLE_APP_FIELD_USER_IMAGE + ", "
        query = query + Constants.TABLE_APP_FIELD_FCM_TOKEN + ", "
        query = query + Constants.TABLE_APP_FIELD_TOPIC_UUID_ACTIVE + ", "
        query = query + Constants.TABLE_APP_FIELD_CAPSULE_UUID_ACTIVE + ", "
        query = query + Constants.TABLE_APP_FIELD_CAPSULE_UUID_OLD + ", "
        query = query + Constants.TABLE_APP_FIELD_SLIDE_UUID_ACTIVE + ", "
        query = query + Constants.TABLE_APP_FIELD_MAX_DATE_CHANGES + ", "
        query = query + Constants.TABLE_APP_FIELD_COMPANY_UUID_ACTIVE + ", "
        query = query + Constants.TABLE_APP_FIELD_URL_EXTERNAL_DOWNLOADED + ", "
        query = query + Constants.TABLE_APP_FIELD_REFRESH_CONTENT_MESSAGE + ", "
        query = query + Constants.TABLE_APP_FIELD_REFRESH_CONTENT_MESSAGE_SHOW_PENDING + ", "
        query = query + Constants.TABLE_APP_FIELD_REFRESH_CONTENT_ACTION_REQUIRED + ", "
        query = query + Constants.TABLE_APP_FIELD_SIGNOUT_ACTION_REQUIRED
        query = query +  ") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);"
        var statement : OpaquePointer?

        if sqlite3_prepare_v2(db, query, -1, &statement, nil) == SQLITE_OK {
            sqlite3_bind_text(statement, 1, model.deviceUuid, -1 , SQLITE_TRANSIENT)
            sqlite3_bind_text(statement, 2, model.deviceAes, -1, SQLITE_TRANSIENT)
            sqlite3_bind_text(statement, 3, model.devicePassword , -1, SQLITE_TRANSIENT)
            sqlite3_bind_text(statement, 4, model.userUuid , -1, SQLITE_TRANSIENT)
            sqlite3_bind_text(statement, 5, model.userFirstname , -1, SQLITE_TRANSIENT)
            sqlite3_bind_text(statement, 6, model.userLastname , -1, SQLITE_TRANSIENT)
            sqlite3_bind_text(statement, 7, model.userEmail , -1, SQLITE_TRANSIENT)
            sqlite3_bind_text(statement, 8, model.userImage , -1, SQLITE_TRANSIENT)
            sqlite3_bind_text(statement, 9, model.fcmToken , -1, SQLITE_TRANSIENT)
            sqlite3_bind_text(statement, 10, model.topicUuidActive , -1, SQLITE_TRANSIENT)
            sqlite3_bind_text(statement, 11, model.capsuleUuidActive , -1, SQLITE_TRANSIENT)
            sqlite3_bind_text(statement, 12, model.capsuleUuidOld , -1, SQLITE_TRANSIENT)
            sqlite3_bind_text(statement, 13, model.slideUuidActive , -1, SQLITE_TRANSIENT)
            sqlite3_bind_text(statement, 14, model.maxDateChanges , -1, SQLITE_TRANSIENT)
            sqlite3_bind_text(statement, 15, model.companyUuidActive , -1, SQLITE_TRANSIENT)
            sqlite3_bind_text(statement, 16, model.urlExternalDownloaded, -1, SQLITE_TRANSIENT)
            sqlite3_bind_text(statement, 17, model.refreshContentMessage, -1, SQLITE_TRANSIENT)
            sqlite3_bind_int(statement, 18, Int32(model.refreshContentMessageShowPending ?  1 : 0))
            sqlite3_bind_int(statement, 19, Int32(model.refreshContentActionRequired ? 1 : 0))
            sqlite3_bind_int(statement, 20, Int32(model.signoutActionRequired ? 1 : 0))
            
            if (sqlite3_step(statement) == SQLITE_DONE) {
                result = Int(sqlite3_last_insert_rowid(db))
           } else {
                print("No se pudo insertar un registro en la tabla: \(Constants.TABLE_APP) ")
               
           }
           
        } else {
            print("Fallo la preparación del insertar en la tabla: \(Constants.TABLE_APP)")
           
        }
       
        sqlite3_finalize(statement)
        
        return result
     }
    
    
    
    func selectOne() -> AppModel {
        
        var model = AppModel()
        
        var query = "SELECT " + Constants.TABLE_APP_FIELD_ID + ", "
        query = query +  Constants.TABLE_APP_FIELD_DEVICE_UUID + ", "
        query = query + Constants.TABLE_APP_FIELD_DEVICE_AES + ", "
        query = query + Constants.TABLE_APP_FIELD_DEVICE_PASSWORD + ", "
        query = query + Constants.TABLE_APP_FIELD_USER_UUID + ", "
        query = query + Constants.TABLE_APP_FIELD_USER_FIRSTNAME + ", "
        query = query + Constants.TABLE_APP_FIELD_USER_LASTNAME + ", "
        query = query + Constants.TABLE_APP_FIELD_USER_EMAIL + ", "
        query = query + Constants.TABLE_APP_FIELD_USER_IMAGE + ", "
        query = query + Constants.TABLE_APP_FIELD_FCM_TOKEN + ", "
        query = query + Constants.TABLE_APP_FIELD_TOPIC_UUID_ACTIVE + ", "
        query = query + Constants.TABLE_APP_FIELD_CAPSULE_UUID_ACTIVE + ", "
        query = query + Constants.TABLE_APP_FIELD_CAPSULE_UUID_OLD + ", "
        query = query + Constants.TABLE_APP_FIELD_SLIDE_UUID_ACTIVE + ", "
        query = query + Constants.TABLE_APP_FIELD_MAX_DATE_CHANGES + ", "
        query = query + Constants.TABLE_APP_FIELD_COMPANY_UUID_ACTIVE + ", "
        query = query + Constants.TABLE_APP_FIELD_URL_EXTERNAL_DOWNLOADED + ", "
        query = query + Constants.TABLE_APP_FIELD_REFRESH_CONTENT_MESSAGE + ", "
        query = query + Constants.TABLE_APP_FIELD_REFRESH_CONTENT_MESSAGE_SHOW_PENDING + ", "
        query = query + Constants.TABLE_APP_FIELD_REFRESH_CONTENT_ACTION_REQUIRED + ", "
        query = query + Constants.TABLE_APP_FIELD_SIGNOUT_ACTION_REQUIRED
        query = query + " FROM " + Constants.TABLE_APP
        query = query + " LIMIT 1;"
        
        //print("selectOne : \(query)")
        
        var statement : OpaquePointer? = nil
        if sqlite3_prepare_v2(db, query, -1, &statement, nil) == SQLITE_OK{
            if sqlite3_step(statement) == SQLITE_ROW {
           
                model.id = Int(sqlite3_column_int(statement, 0))
                
                
                model.deviceUuid = String(describing: String(cString: sqlite3_column_text(statement, 1)))
                
                model.deviceAes = String(describing: String(cString: sqlite3_column_text(statement, 2)))
                
                model.devicePassword = String(describing: String(cString: sqlite3_column_text(statement, 3)))
               
                model.userUuid = String(describing: String(cString: sqlite3_column_text(statement, 4)))
                model.userFirstname = String(describing: String(cString: sqlite3_column_text(statement, 5)))
                model.userLastname = String(describing: String(cString: sqlite3_column_text(statement, 6)))
                model.userEmail = String(describing: String(cString: sqlite3_column_text(statement, 7)))
                model.userImage = String(describing: String(cString: sqlite3_column_text(statement, 8)))
                
                
                model.fcmToken = String(describing: String(cString: sqlite3_column_text(statement, 9)))
                
                model.topicUuidActive = String(describing: String(cString: sqlite3_column_text(statement, 10)))
                
                model.capsuleUuidActive = String(describing: String(cString: sqlite3_column_text(statement, 11)))
                
                model.capsuleUuidOld = String(describing: String(cString: sqlite3_column_text(statement, 12)))
                
                model.slideUuidActive = String(describing: String(cString: sqlite3_column_text(statement, 13)))
                
                model.maxDateChanges  = String(describing: String(cString: sqlite3_column_text(statement, 14)))
                
                model.companyUuidActive  = String(describing: String(cString: sqlite3_column_text(statement, 15)))
                
                model.urlExternalDownloaded  = String(describing: String(cString: sqlite3_column_text(statement, 16)))
                
                model.refreshContentMessage  = String(describing: String(cString: sqlite3_column_text(statement, 17)))
                
                model.refreshContentMessageShowPending = Int(sqlite3_column_int(statement, 18)) > 0
                model.refreshContentActionRequired = Int(sqlite3_column_int(statement, 19)) > 0
                model.signoutActionRequired = Int(sqlite3_column_int(statement, 20)) > 0
            }
        } else {
           
        }

        sqlite3_finalize(statement)
        
        return model
    }
    
  
    
    func update(model: AppModel) {
        
        var query = "UPDATE " + Constants.TABLE_APP + " SET "
        query = query + Constants.TABLE_APP_FIELD_DEVICE_UUID + " = '\(model.deviceUuid)' , "
        query = query + Constants.TABLE_APP_FIELD_DEVICE_AES + " = '\(model.deviceAes)' , "
        query = query + Constants.TABLE_APP_FIELD_DEVICE_PASSWORD + " = '\(model.devicePassword)', "
        query = query + Constants.TABLE_APP_FIELD_USER_UUID + " = '\(model.userUuid)', "
        query = query + Constants.TABLE_APP_FIELD_USER_FIRSTNAME + " = '\(model.userFirstname)', "
        query = query + Constants.TABLE_APP_FIELD_USER_LASTNAME + " = '\(model.userLastname)', "
        query = query + Constants.TABLE_APP_FIELD_USER_EMAIL + " = '\(model.userEmail)', "
        query = query + Constants.TABLE_APP_FIELD_USER_IMAGE + " = '\(model.userImage)', "
        query = query + Constants.TABLE_APP_FIELD_FCM_TOKEN + " = '\(model.fcmToken)', "
        query = query + Constants.TABLE_APP_FIELD_TOPIC_UUID_ACTIVE + " = '\(model.topicUuidActive)', "
        query = query + Constants.TABLE_APP_FIELD_CAPSULE_UUID_ACTIVE + " = '\(model.capsuleUuidActive)', "
        query = query + Constants.TABLE_APP_FIELD_CAPSULE_UUID_OLD + " = '\(model.capsuleUuidOld)', "
        query = query + Constants.TABLE_APP_FIELD_SLIDE_UUID_ACTIVE + " = '\(model.slideUuidActive)', "

        query = query + Constants.TABLE_APP_FIELD_MAX_DATE_CHANGES + " = '\(model.maxDateChanges)', "
        query = query + Constants.TABLE_APP_FIELD_COMPANY_UUID_ACTIVE + " = '\(model.companyUuidActive)', "
        query = query + Constants.TABLE_APP_FIELD_URL_EXTERNAL_DOWNLOADED + " = '\(model.urlExternalDownloaded)', "
        query = query + Constants.TABLE_APP_FIELD_REFRESH_CONTENT_MESSAGE + " = '\(model.refreshContentMessage)', "
        query = query + Constants.TABLE_APP_FIELD_REFRESH_CONTENT_MESSAGE_SHOW_PENDING + " = '\(model.refreshContentMessageShowPending ? 1 : 0)', "
        query = query + Constants.TABLE_APP_FIELD_REFRESH_CONTENT_ACTION_REQUIRED + " = '\(model.refreshContentActionRequired ? 1 : 0)', "
        query = query + Constants.TABLE_APP_FIELD_SIGNOUT_ACTION_REQUIRED + " = '\(model.signoutActionRequired ? 1 : 0)' "
        query = query + " WHERE " + Constants.TABLE_APP_FIELD_ID + " = '\(model.id)' "
        
        
        
        
        //print("update query : \(query)")
        
        var statement : OpaquePointer? = nil
        if sqlite3_prepare_v2(db, query, -1, &statement, nil) == SQLITE_OK{
            if sqlite3_step(statement) != SQLITE_DONE {
                
                print("No se pudo actualizar un registro de la tabla: \(Constants.TABLE_APP)")
                
               
                
            }
        } else {
            print("Fallo la preparación de actualizar un registro en la tabla: \(Constants.TABLE_APP)")
            
           
        }
        sqlite3_finalize(statement)
    }

    
  
    
}