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 3/1/22.
 5 
//  Created by Efrain Yanez Recanatini on 3/1/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 UserExtendedDao {
11 
class UserExtendedDao {
 - 
 
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 selectAll()-> [UserExtendedModel] {
 15 
    func selectAll()-> [UserExtendedModel] {
Línea 16... Línea 16...
16
16 
        let db = database.open()
17 
         var records = [UserExtendedModel]()
 17 
         var records = [UserExtendedModel]()
18
18
Línea 45... Línea 45...
45 
         return records
 45 
         return records
46 
     }
 46 
     }
Línea 47... Línea 47...
47
47
48
- 
 
- 
 
 48
49 
    func selectAllByCompanyUuid(companyUuid : String)-> [UserExtendedModel] {
 49 
    func selectAllByCompanyUuid(companyUuid : String)-> [UserExtendedModel] {
Línea 50... Línea 50...
50
50 
        let db = database.open()
51 
         var records = [UserExtendedModel]()
 51 
         var records = [UserExtendedModel]()
52
52
Línea 80... Línea 80...
80 
         sqlite3_finalize(statement)
 80 
         sqlite3_finalize(statement)
81 
         return records
 81 
         return records
82 
     }
 82 
     }
Línea 83... Línea 83...
83
83
84 
    func insert(record : UserExtendedModel) {
 - 
 
- 
 
 84 
    func insert(record : UserExtendedModel) {
85
85 
        let db = database.open()
86 
        var query = "INSERT INTO " + Constants.TABLE_USER_EXTENDED + " ( "
 86 
        var query = "INSERT INTO " + Constants.TABLE_USER_EXTENDED + " ( "
87 
        query = query + Constants.TABLE_USER_EXTENDED_FIELD_UUID + " , "
 87 
        query = query + Constants.TABLE_USER_EXTENDED_FIELD_UUID + " , "
88 
        query = query + Constants.TABLE_USER_EXTENDED_FIELD_COMPANY_UUID + " , "
 88 
        query = query + Constants.TABLE_USER_EXTENDED_FIELD_COMPANY_UUID + " , "
89 
        query = query + Constants.TABLE_USER_EXTENDED_FIELD_LABEL + ", "
 89 
        query = query + Constants.TABLE_USER_EXTENDED_FIELD_LABEL + ", "
Línea 114... Línea 114...
114 
        sqlite3_finalize(statement)
 114 
        sqlite3_finalize(statement)
115 
    }
 115 
    }
Línea 116... Línea 116...
116 
 
 116 
 
117
- 
 
- 
 
 117
118 
    func removeAll() {
 118 
    func removeAll() {
119
119 
        let db = database.open()
120 
        let query = "DELETE FROM " + Constants.TABLE_USER_EXTENDED + ";"
 120 
        let query = "DELETE FROM " + Constants.TABLE_USER_EXTENDED + ";"
121 
        var statement : OpaquePointer? = nil
 121 
        var statement : OpaquePointer? = nil
122 
        if sqlite3_prepare_v2(db, query, -1, &statement, nil) == SQLITE_OK{
 122 
        if sqlite3_prepare_v2(db, query, -1, &statement, nil) == SQLITE_OK{