Proyectos de Subversion Iphone Microlearning - Nuevo Interface

Rev

Rev 10 | Rev 17 | Ir a la última revisión | Mostrar el archivo completo | | | Autoría | Ultima modificación | Ver Log |

Rev 10 Rev 11
Línea 24... Línea 24...
24 
    init() {
 24 
    init() {
25 
        self.db = Database.sharedInstance.open()
 25 
        self.db = Database.sharedInstance.open()
26 
    }
 26 
    }
Línea 27... Línea 27...
27
27
- 
 
 28
28
29 
    func insert(model: AppModel)  ->Int {
- 
 
 30
29 
    func insert(model : AppModel) -> Int {
 31 
        var result : Int = 0
30 
        var result = 0
 32
31 
        var query = "INSERT INTO " + Constants.TABLE_APP + " ( "
 33 
        var query = "INSERT INTO " + Constants.TABLE_APP + " ( "
32 
        query = query + Constants.TABLE_APP_FIELD_DEVICE_UUID + ", "
 34 
        query = query + Constants.TABLE_APP_FIELD_DEVICE_UUID + ", "
33 
        query = query + Constants.TABLE_APP_FIELD_DEVICE_AES + ", "
 35 
        query = query + Constants.TABLE_APP_FIELD_DEVICE_AES + ", "
Línea 41... Línea 43...
41 
        query = query + Constants.TABLE_APP_FIELD_TOPIC_UUID_ACTIVE + ", "
 43 
        query = query + Constants.TABLE_APP_FIELD_TOPIC_UUID_ACTIVE + ", "
42 
        query = query + Constants.TABLE_APP_FIELD_CAPSULE_UUID_ACTIVE + ", "
 44 
        query = query + Constants.TABLE_APP_FIELD_CAPSULE_UUID_ACTIVE + ", "
43 
        query = query + Constants.TABLE_APP_FIELD_CAPSULE_UUID_OLD + ", "
 45 
        query = query + Constants.TABLE_APP_FIELD_CAPSULE_UUID_OLD + ", "
44 
        query = query + Constants.TABLE_APP_FIELD_SLIDE_UUID_ACTIVE + ", "
 46 
        query = query + Constants.TABLE_APP_FIELD_SLIDE_UUID_ACTIVE + ", "
45 
        query = query + Constants.TABLE_APP_FIELD_SLIDE_POSITION_INITIAL + ", "
 47 
        query = query + Constants.TABLE_APP_FIELD_SLIDE_POSITION_INITIAL + ", "
46 
        query = query + Constants.TABLE_APP_FIELD_MAX_DATE_CHANGES
 48 
        query = query + Constants.TABLE_APP_FIELD_MAX_DATE_CHANGES + ", "
- 
 
 49 
        query = query + Constants.TABLE_APP_FIELD_COMPANY_UUID_ACTIVE
47 
        query = query +  ") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);"
 50 
        query = query +  ") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);"
48 
        var statement : OpaquePointer?
 51 
        var statement : OpaquePointer?
Línea 49... Línea 52...
49 
 
 52 
 
50 
        if sqlite3_prepare_v2(db, query, -1, &statement, nil) == SQLITE_OK {
 53 
        if sqlite3_prepare_v2(db, query, -1, &statement, nil) == SQLITE_OK {
51 
            sqlite3_bind_text(statement, 1, model.deviceUuid, -1 , SQLITE_TRANSIENT)
 54 
            sqlite3_bind_text(statement, 1, model.deviceUuid, -1 , SQLITE_TRANSIENT)
Línea 61... Línea 64...
61 
            sqlite3_bind_text(statement, 11, model.capsuleUuidActive , -1, SQLITE_TRANSIENT)
 64 
            sqlite3_bind_text(statement, 11, model.capsuleUuidActive , -1, SQLITE_TRANSIENT)
62 
            sqlite3_bind_text(statement, 12, model.capsuleUuidOld , -1, SQLITE_TRANSIENT)
 65 
            sqlite3_bind_text(statement, 12, model.capsuleUuidOld , -1, SQLITE_TRANSIENT)
63 
            sqlite3_bind_text(statement, 13, model.slideUuidActive , -1, SQLITE_TRANSIENT)
 66 
            sqlite3_bind_text(statement, 13, model.slideUuidActive , -1, SQLITE_TRANSIENT)
64 
            sqlite3_bind_int(statement, 14, Int32(model.slidePositionInitial))
 67 
            sqlite3_bind_int(statement, 14, Int32(model.slidePositionInitial))
65 
            sqlite3_bind_text(statement, 15, model.maxDateChanges , -1, SQLITE_TRANSIENT)
 68 
            sqlite3_bind_text(statement, 15, model.maxDateChanges , -1, SQLITE_TRANSIENT)
- 
 
 69 
            sqlite3_bind_text(statement, 16, model.companyUuidActive , -1, SQLITE_TRANSIENT)
Línea 66... Línea 70...
66 
 
 70 
 
67 
            if (sqlite3_step(statement) == SQLITE_DONE) {
 71 
            if (sqlite3_step(statement) == SQLITE_DONE) {
68 
                result = Int(sqlite3_last_insert_rowid(db))
 72 
                result = Int(sqlite3_last_insert_rowid(db))
69 
           } else {
 73 
           } else {
Línea 79... Línea 83...
79 
        return result
 83 
        return result
80 
     }
 84 
     }
Línea 81... Línea 85...
81
85
82
86
Línea 83... Línea 87...
83
87
- 
 
 88 
    func selectOne() -> AppModel {
84 
    func selectOne()-> AppModel {
 89 
        var model = AppModel()
85 
        var model = AppModel()
 90
86
91 
        var query = "SELECT " + Constants.TABLE_APP_FIELD_ID + ", "
87 
        var query = "SELECT " + Constants.TABLE_APP_FIELD_DEVICE_UUID + ", "
 92 
        query = query +  Constants.TABLE_APP_FIELD_DEVICE_UUID + ", "
88 
        query = query + Constants.TABLE_APP_FIELD_DEVICE_AES + ", "
 93 
        query = query + Constants.TABLE_APP_FIELD_DEVICE_AES + ", "
Línea 96... Línea 101...
96 
        query = query + Constants.TABLE_APP_FIELD_TOPIC_UUID_ACTIVE + ", "
 101 
        query = query + Constants.TABLE_APP_FIELD_TOPIC_UUID_ACTIVE + ", "
97 
        query = query + Constants.TABLE_APP_FIELD_CAPSULE_UUID_ACTIVE + ", "
 102 
        query = query + Constants.TABLE_APP_FIELD_CAPSULE_UUID_ACTIVE + ", "
98 
        query = query + Constants.TABLE_APP_FIELD_CAPSULE_UUID_OLD + ", "
 103 
        query = query + Constants.TABLE_APP_FIELD_CAPSULE_UUID_OLD + ", "
99 
        query = query + Constants.TABLE_APP_FIELD_SLIDE_UUID_ACTIVE + ", "
 104 
        query = query + Constants.TABLE_APP_FIELD_SLIDE_UUID_ACTIVE + ", "
100 
        query = query + Constants.TABLE_APP_FIELD_SLIDE_POSITION_INITIAL + ", "
 105 
        query = query + Constants.TABLE_APP_FIELD_SLIDE_POSITION_INITIAL + ", "
101 
        query = query + Constants.TABLE_APP_FIELD_MAX_DATE_CHANGES
 106 
        query = query + Constants.TABLE_APP_FIELD_MAX_DATE_CHANGES + ", "
- 
 
 107 
        query = query + Constants.TABLE_APP_FIELD_COMPANY_UUID_ACTIVE
102 
        query = query + " FROM " + Constants.TABLE_APP
 108 
        query = query + " FROM " + Constants.TABLE_APP
103 
        query = query + " LIMIT 1;"
 109 
        query = query + " LIMIT 1;"
Línea -... Línea 110...
- 
 
 110
- 
 
 111 
        //print("selectOne : \(query)")
104
112
105 
        var statement : OpaquePointer? = nil
 113 
        var statement : OpaquePointer? = nil
106 
        if sqlite3_prepare_v2(db, query, -1, &statement, nil) == SQLITE_OK{
 114 
        if sqlite3_prepare_v2(db, query, -1, &statement, nil) == SQLITE_OK{
107 
            if sqlite3_step(statement) == SQLITE_DONE {
 115 
            while sqlite3_step(statement) == SQLITE_ROW {
Línea -... Línea 116...
- 
 
 116 
                model.id = Int(sqlite3_column_int(statement, 0))
108 
                model.id = Int(sqlite3_column_int(statement, 0))
 117
- 
 
 118
- 
 
 119 
                model.deviceUuid = String(describing: String(cString: sqlite3_column_text(statement, 1)))
109
120
110 
                model.deviceUuid = String(describing: String(cString: sqlite3_column_text(statement, 1)))
 121 
 
Línea 111... Línea 122...
111 
                model.deviceAes = String(describing: String(cString: sqlite3_column_text(statement, 2)))
 122 
                model.deviceAes = String(describing: String(cString: sqlite3_column_text(statement, 2)))
112 
                model.devicePassword = String(describing: String(cString: sqlite3_column_text(statement, 3)))
 123 
                model.devicePassword = String(describing: String(cString: sqlite3_column_text(statement, 3)))
Línea 125... Línea 136...
125 
                model.capsuleUuidOld = String(describing: String(cString: sqlite3_column_text(statement, 12)))
 136 
                model.capsuleUuidOld = String(describing: String(cString: sqlite3_column_text(statement, 12)))
126 
                model.slideUuidActive = String(describing: String(cString: sqlite3_column_text(statement, 13)))
 137 
                model.slideUuidActive = String(describing: String(cString: sqlite3_column_text(statement, 13)))
127 
                model.slidePositionInitial = Int(sqlite3_column_int(statement, 14))
 138 
                model.slidePositionInitial = Int(sqlite3_column_int(statement, 14))
Línea 128... Línea 139...
128
139
129 
                model.maxDateChanges  = String(describing: String(cString: sqlite3_column_text(statement, 14)))
 140 
                model.maxDateChanges  = String(describing: String(cString: sqlite3_column_text(statement, 14)))
- 
 
 141
- 
 
 142 
                model.companyUuidActive  = String(describing: String(cString: sqlite3_column_text(statement, 15)))
- 
 
 143
Línea 130... Línea 144...
130 
 
 144 
                break;
131
145
132 
            }
 146 
            }
- 
 
 147 
        }
133 
        }
 148 
        sqlite3_finalize(statement)
134 
        sqlite3_finalize(statement)
 149
Línea 135... Línea 150...
135 
        return model
 150 
        return model
- 
 
 151 
    }
136 
    }
 152
137
153
138
154
139
155 
    func update(model: AppModel) {
140 
    func update( model : AppModel) {
 156
141 
        var query = "UPDATE" + Constants.TABLE_APP + " SET "
 157 
        var query = "UPDATE " + Constants.TABLE_APP + " SET "
142 
        query = query + Constants.TABLE_APP_FIELD_DEVICE_UUID + " = ? , "
 158 
        query = query + Constants.TABLE_APP_FIELD_DEVICE_UUID + " = '\(model.deviceUuid)' , "
143 
        query = query + Constants.TABLE_APP_FIELD_DEVICE_AES + " = ? , "
 159 
        query = query + Constants.TABLE_APP_FIELD_DEVICE_AES + " = '\(model.deviceAes)' , "
144 
        query = query + Constants.TABLE_APP_FIELD_DEVICE_PASSWORD + " = ?, "
 160 
        query = query + Constants.TABLE_APP_FIELD_DEVICE_PASSWORD + " = '\(model.devicePassword)', "
145 
        query = query + Constants.TABLE_APP_FIELD_USER_UUID + " = ?, "
 161 
        query = query + Constants.TABLE_APP_FIELD_USER_UUID + " = '\(model.userUuid)', "
146 
        query = query + Constants.TABLE_APP_FIELD_USER_FIRSTNAME + " = ?, "
 162 
        query = query + Constants.TABLE_APP_FIELD_USER_FIRSTNAME + " = '\(model.userFirstname)', "
147 
        query = query + Constants.TABLE_APP_FIELD_USER_LASTNAME + " = ?, "
 163 
        query = query + Constants.TABLE_APP_FIELD_USER_LASTNAME + " = '\(model.userLastname)', "
148 
        query = query + Constants.TABLE_APP_FIELD_USER_EMAIL + " = ?, "
 164 
        query = query + Constants.TABLE_APP_FIELD_USER_EMAIL + " = '\(model.userEmail)', "
149 
        query = query + Constants.TABLE_APP_FIELD_USER_IMAGE + " = ?, "
 165 
        query = query + Constants.TABLE_APP_FIELD_USER_IMAGE + " = '\(model.userImage)', "
150 
        query = query + Constants.TABLE_APP_FIELD_FCM_TOKEN + " = ?, "
 166 
        query = query + Constants.TABLE_APP_FIELD_FCM_TOKEN + " = '\(model.fcmToken)', "
151 
        query = query + Constants.TABLE_APP_FIELD_TOPIC_UUID_ACTIVE + " = ?, "
 167 
        query = query + Constants.TABLE_APP_FIELD_TOPIC_UUID_ACTIVE + " = '\(model.topicUuidActive)', "
- 
 
 168 
        query = query + Constants.TABLE_APP_FIELD_CAPSULE_UUID_ACTIVE + " = '\(model.capsuleUuidActive)', "
- 
 
 169 
        query = query + Constants.TABLE_APP_FIELD_CAPSULE_UUID_OLD + " = '\(model.capsuleUuidOld)', "
- 
 
 170 
        query = query + Constants.TABLE_APP_FIELD_SLIDE_UUID_ACTIVE + " = '\(model.slideUuidActive)', "
- 
 
 171 
        query = query + Constants.TABLE_APP_FIELD_SLIDE_POSITION_INITIAL + " = '\(model.slidePositionInitial)', "
- 
 
 172 
        query = query + Constants.TABLE_APP_FIELD_MAX_DATE_CHANGES + " = '\(model.maxDateChanges)', "
- 
 
 173 
        query = query + Constants.TABLE_APP_FIELD_COMPANY_UUID_ACTIVE + " = '\(model.companyUuidActive)' "
- 
 
 174 
        query = query + " WHERE " + Constants.TABLE_APP_FIELD_ID + " = '\(model.id)' "
Línea 152... Línea -...
152 
        query = query + Constants.TABLE_APP_FIELD_CAPSULE_UUID_ACTIVE + " = ?, "
 - 
 
153 
        query = query + Constants.TABLE_APP_FIELD_CAPSULE_UUID_OLD + " = ?, "
 175
154 
        query = query + Constants.TABLE_APP_FIELD_SLIDE_UUID_ACTIVE + " = ?, "
 176
155 
        query = query + Constants.TABLE_APP_FIELD_SLIDE_POSITION_INITIAL + " = ?, "
 - 
 
156 
        query = query + Constants.TABLE_APP_FIELD_MAX_DATE_CHANGES + " = ? "
 - 
 
157
- 
 
158 
        query = query + " WHERE " + Constants.TABLE_APP_FIELD_ID + " = ? "
 - 
 
159 
        var statement : OpaquePointer? = nil
 - 
 
160 
        if sqlite3_prepare_v2(db, query, -1, &statement, nil) == SQLITE_OK{
 - 
 
161
- 
 
162 
            sqlite3_bind_text(statement, 0, model.deviceUuid, -1 , SQLITE_TRANSIENT)
 - 
 
163 
            sqlite3_bind_text(statement, 1, model.deviceAes, -1, SQLITE_TRANSIENT)
 - 
 
164 
            sqlite3_bind_text(statement, 2, model.devicePassword , -1, SQLITE_TRANSIENT)
 - 
 
165 
            sqlite3_bind_text(statement, 3, model.userUuid , -1, SQLITE_TRANSIENT)
 - 
 
166 
            sqlite3_bind_text(statement, 4, model.userFirstname , -1, SQLITE_TRANSIENT)
 - 
 
167 
            sqlite3_bind_text(statement, 5, model.userLastname , -1, SQLITE_TRANSIENT)
 - 
 
168 
            sqlite3_bind_text(statement, 6, model.userEmail , -1, SQLITE_TRANSIENT)
 - 
 
169 
            sqlite3_bind_text(statement, 7, model.userImage , -1, SQLITE_TRANSIENT)
 - 
 
170 
            sqlite3_bind_text(statement, 8, model.fcmToken , -1, SQLITE_TRANSIENT)
 - 
 
171 
            sqlite3_bind_text(statement, 9, model.topicUuidActive , -1, SQLITE_TRANSIENT)
 - 
 
172 
            sqlite3_bind_text(statement, 10, model.capsuleUuidActive , -1, SQLITE_TRANSIENT)
 - 
 
173 
            sqlite3_bind_text(statement, 11, model.capsuleUuidOld , -1, SQLITE_TRANSIENT)
 177
Línea 174... Línea 178...
174 
            sqlite3_bind_text(statement, 12, model.slideUuidActive , -1, SQLITE_TRANSIENT)
 178
Línea 175... Línea 179...
175 
            sqlite3_bind_int(statement, 13, Int32(model.slidePositionInitial))
 179 
        print("update query : \(query)")