Proyectos de Subversion Iphone Microlearning - Nuevo Interface

Rev

Rev 19 | Ir a la última revisión | | Ultima modificación | Ver Log |

Rev Autor Línea Nro. Línea
1 efrain 1 
//
2 
//  AnswerDao.swift
3 
//  twogetskills
4 
//
5 
//  Created by Efrain Yanez Recanatini on 2/21/22.
6 
//
7 
 
8 
import UIKit
9 
import SQLite3
10 
 
11 
class AnswerDao {
12 
    private let SQLITE_TRANSIENT = unsafeBitCast(-1, to: sqlite3_destructor_type.self)
13 
    private var db : OpaquePointer?
14 
 
15 
    static let sharedInstance: AnswerDao = {
16 
           let instance = AnswerDao()
17 
 
18 
           // setup code
19 
           return instance
20 
    }()
21 
 
22 
    init() {
23 
        self.db = Database.sharedInstance.open()
24 
    }
25 
 
26 
 
27 
    func insert(answer : AnswerModel) {
28 
        var query = "INSERT INTO " + Constants.TABLE_ANSWER + " ( "
29 
        query = query + Constants.TABLE_ANSWER_FIELD_UUID + ", "
30 
        query = query + Constants.TABLE_ANSWER_FIELD_QUESTION_UUID + ", "
31 
        query = query + Constants.TABLE_ANSWER_FIELD_TEXT + ", "
32 
        query = query + Constants.TABLE_ANSWER_FIELD_POINTS + ", "
33 
        query = query + Constants.TABLE_ANSWER_FIELD_CORRECT + ", "
34 
        query = query + Constants.TABLE_ANSWER_FIELD_ADDED_ON + ", "
35 
        query = query + Constants.TABLE_ANSWER_FIELD_UPDATED_ON
36 
        query = query +  ") VALUES (?, ?, ?, ?, ?, ?, ?);"
37 
        var statement : OpaquePointer?
38 
 
39 
        if sqlite3_prepare_v2(db, query, -1, &statement, nil) == SQLITE_OK {
40 
            sqlite3_bind_text(statement, 1, answer.uuid, -1 , SQLITE_TRANSIENT)
41 
            sqlite3_bind_text(statement, 2, answer.questionUuid, -1, SQLITE_TRANSIENT)
42 
            sqlite3_bind_text(statement, 3, answer.text , -1, SQLITE_TRANSIENT)
43 
            sqlite3_bind_int(statement, 4, Int32(answer.points))
44 
            sqlite3_bind_int(statement, 5, Int32(answer.correct))
45 
            sqlite3_bind_text(statement, 6, answer.addedOn , -1, SQLITE_TRANSIENT)
46 
            sqlite3_bind_text(statement, 7, answer.updatedOn , -1, SQLITE_TRANSIENT)
47 
 
48 
 
49 
           if sqlite3_step(statement) != SQLITE_DONE {
50 
            print("No se pudo insertar un registro en la tabla: \(Constants.TABLE_ANSWER) ")
51 
           }
52 
 
53 
        } else {
54 
            print("Fallo la preparación del insertar en la tabla: \(Constants.TABLE_ANSWER)")
55 
        }
56 
 
57 
        sqlite3_finalize(statement)
58 
     }
59 
 
60 
 
61 
 
62 
    func selectAllByQuestionUuid(questionUuid: String)-> [AnswerModel] {
63 
        var records = [AnswerModel]()
64 
 
65 
        var query = "SELECT " + Constants.TABLE_ANSWER_FIELD_UUID + " , "
66 
        query = query + Constants.TABLE_ANSWER_FIELD_QUESTION_UUID + ", "
67 
        query = query + Constants.TABLE_ANSWER_FIELD_TEXT + ", "
68 
        query = query + Constants.TABLE_ANSWER_FIELD_POINTS + " , "
69 
        query = query + Constants.TABLE_ANSWER_FIELD_CORRECT + " , "
70 
        query = query + Constants.TABLE_ANSWER_FIELD_ADDED_ON + " , "
71 
        query = query + Constants.TABLE_ANSWER_FIELD_UPDATED_ON
72 
        query = query + " FROM " + Constants.TABLE_ANSWER
73 
        query = query + " WHERE " + Constants.TABLE_ANSWER_FIELD_QUESTION_UUID + " = '\(questionUuid)' ;"
74 
 
75 
        var statement : OpaquePointer? = nil
76 
 
77 
        if sqlite3_prepare_v2(db, query, -1, &statement, nil) == SQLITE_OK{
78 
            while sqlite3_step(statement) == SQLITE_ROW {
79 
                var model = AnswerModel()
80 
                model.uuid = String(describing: String(cString: sqlite3_column_text(statement, 0)))
81 
                model.questionUuid = String(describing: String(cString: sqlite3_column_text(statement, 1)))
82 
                model.text = String(describing: String(cString: sqlite3_column_text(statement, 2)))
83 
                model.points = Int(sqlite3_column_int(statement, 3))
84 
                model.correct = Int(sqlite3_column_int(statement, 4))
85 
                model.addedOn = String(describing: String(cString: sqlite3_column_text(statement, 5)))
86 
                model.updatedOn = String(describing: String(cString: sqlite3_column_text(statement, 6)))
87 
 
88 
                records.append(model)
89 
 
90 
            }
91 
        }
92 
        sqlite3_finalize(statement)
93 
        return records
94 
    }
95 
 
96 
    func selectByUuid(uuid : String) -> AnswerModel {
97 
        var model = AnswerModel()
98 
        var query = "SELECT " + Constants.TABLE_ANSWER_FIELD_UUID + " , "
99 
        query = query + Constants.TABLE_ANSWER_FIELD_QUESTION_UUID + ", "
100 
        query = query + Constants.TABLE_ANSWER_FIELD_TEXT + ", "
101 
        query = query + Constants.TABLE_ANSWER_FIELD_POINTS + " , "
102 
        query = query + Constants.TABLE_ANSWER_FIELD_CORRECT + " , "
103 
        query = query + Constants.TABLE_ANSWER_FIELD_ADDED_ON + " , "
104 
        query = query + Constants.TABLE_ANSWER_FIELD_UPDATED_ON
105 
        query = query + " FROM " + Constants.TABLE_ANSWER
106 
        query = query + " WHERE " + Constants.TABLE_ANSWER_FIELD_UUID + " = '\(uuid)' ;"
107 
 
108 
        var statement : OpaquePointer? = nil
109 
        if sqlite3_prepare_v2(db, query, -1, &statement, nil) == SQLITE_OK{
110 
            if sqlite3_step(statement) == SQLITE_DONE {
111 
                model.uuid = String(describing: String(cString: sqlite3_column_text(statement, 0)))
112 
                model.questionUuid = String(describing: String(cString: sqlite3_column_text(statement, 1)))
113 
                model.text = String(describing: String(cString: sqlite3_column_text(statement, 2)))
114 
                model.points = Int(sqlite3_column_int(statement, 3))
115 
                model.correct = Int(sqlite3_column_int(statement, 4))
116 
                model.addedOn = String(describing: String(cString: sqlite3_column_text(statement, 5)))
117 
                model.updatedOn = String(describing: String(cString: sqlite3_column_text(statement, 6)))
118 
 
119 
            }
120 
        }
121 
        sqlite3_finalize(statement)
122 
        return model
123 
    }
124 
 
125 
    func update( answerModel: AnswerModel) {
126 
        var query = "UPDATE" + Constants.TABLE_SYNC
127 
        query = query + " SET " + Constants.TABLE_ANSWER_FIELD_TEXT + " =  ?, "
128 
        query = query + Constants.TABLE_ANSWER_FIELD_POINTS + " = ?, "
129 
        query = query + Constants.TABLE_ANSWER_FIELD_CORRECT + " = ?, "
130 
        query = query + Constants.TABLE_ANSWER_FIELD_ADDED_ON + " = ?, "
131 
        query = query + Constants.TABLE_ANSWER_FIELD_UPDATED_ON + " = ? "
132 
        query = query + "  WHERE " + Constants.TABLE_ANSWER_FIELD_UUID + "  = ? "
133 
        var statement : OpaquePointer? = nil
134 
        if sqlite3_prepare_v2(db, query, -1, &statement, nil) == SQLITE_OK{
135 
 
136 
            sqlite3_bind_text(statement, 0, answerModel.text , -1, SQLITE_TRANSIENT)
137 
            sqlite3_bind_int(statement, 1, Int32(answerModel.points))
138 
            sqlite3_bind_int(statement, 2, Int32(answerModel.correct))
139 
            sqlite3_bind_text(statement, 3, answerModel.addedOn, -1, SQLITE_TRANSIENT)
140 
            sqlite3_bind_text(statement, 4, answerModel.updatedOn, -1, SQLITE_TRANSIENT)
141 
            sqlite3_bind_text(statement, 5, answerModel.uuid, -1, SQLITE_TRANSIENT)
142 
 
143 
            if sqlite3_step(statement) != SQLITE_DONE {
144 
 
145 
                print("No se pudo actualizar un registro de la tabla: \(Constants.TABLE_ANSWER)")
146 
 
147 
            }
148 
        } else {
149 
            print("Fallo la preparación de actualizar un registro en la tabla: \(Constants.TABLE_ANSWER)")
150 
        }
151 
        sqlite3_finalize(statement)
152 
    }
153 
 
154 
 
155 
    func remove(uuid : String) {
156 
        let query = "DELETE FROM " + Constants.TABLE_ANSWER +
157 
            " WHERE " + Constants.TABLE_ANSWER_FIELD_UUID + " = '\(uuid)' ;"
158 
        var statement : OpaquePointer? = nil
159 
        if (sqlite3_prepare_v2(db, query, -1, &statement, nil) == SQLITE_OK) {
160 
            if (sqlite3_step(statement) != SQLITE_DONE) {
161 
                print("No se pudo borrar el registro con el uuid: \(uuid) de la tabla: \(Constants.TABLE_ANSWER) ")
162 
            }
163 
        } else {
164 
            print("Fallo la preparación para borrar un registro de la tabla \(Constants.TABLE_ANSWER) ")
165 
        }
166 
        sqlite3_finalize(statement)
167 
    }
168 
 
169 
    func removeAll() {
170 
        let query = "DELETE FROM " + Constants.TABLE_ANSWER + ";"
171 
        var statement : OpaquePointer? = nil
172 
        if sqlite3_prepare_v2(db, query, -1, &statement, nil) == SQLITE_OK{
173 
            if sqlite3_step(statement) != SQLITE_DONE {
174 
                print("No se pudieron borrar todos los registros de la tabla: \(Constants.TABLE_ANSWER) ")
175 
            }
176 
        } else {
177 
            print("Fallo la preparación para borrar todos los registros de la tabla: \(Constants.TABLE_ANSWER)")
178 
        }
179 
        sqlite3_finalize(statement)
180 
    }
181 
 
182 
}