Proyectos de Subversion Iphone Microlearning - Inconcert

Rev

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