Proyectos de Subversion Iphone Microlearning - Inconcert

Rev

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