Proyectos de Subversion Iphone Microlearning - Nuevo Interface

Rev

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

Rev 19 Rev 25
Línea 39... Línea 39...
39 
        query = query + Constants.TABLE_APP_FIELD_CAPSULE_UUID_ACTIVE + ", "
 39 
        query = query + Constants.TABLE_APP_FIELD_CAPSULE_UUID_ACTIVE + ", "
40 
        query = query + Constants.TABLE_APP_FIELD_CAPSULE_UUID_OLD + ", "
 40 
        query = query + Constants.TABLE_APP_FIELD_CAPSULE_UUID_OLD + ", "
41 
        query = query + Constants.TABLE_APP_FIELD_SLIDE_UUID_ACTIVE + ", "
 41 
        query = query + Constants.TABLE_APP_FIELD_SLIDE_UUID_ACTIVE + ", "
42 
        query = query + Constants.TABLE_APP_FIELD_MAX_DATE_CHANGES + ", "
 42 
        query = query + Constants.TABLE_APP_FIELD_MAX_DATE_CHANGES + ", "
43 
        query = query + Constants.TABLE_APP_FIELD_COMPANY_UUID_ACTIVE + ", "
 43 
        query = query + Constants.TABLE_APP_FIELD_COMPANY_UUID_ACTIVE + ", "
44 
        query = query + Constants.TABLE_APP_FIELD_URL_EXTERNAL_DOWNLOADED
 44 
        query = query + Constants.TABLE_APP_FIELD_URL_EXTERNAL_DOWNLOADED + ", "
- 
 
 45 
        query = query + Constants.TABLE_APP_FIELD_REFRESH_CONTENT_MESSAGE + ", "
- 
 
 46 
        query = query + Constants.TABLE_APP_FIELD_REFRESH_CONTENT_MESSAGE_SHOW_PENDING + ", "
- 
 
 47 
        query = query + Constants.TABLE_APP_FIELD_REFRESH_CONTENT_ACTION_REQUIRED
45 
        query = query +  ") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);"
 48 
        query = query +  ") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);"
46 
        var statement : OpaquePointer?
 49 
        var statement : OpaquePointer?
Línea 47... Línea 50...
47 
 
 50 
 
48 
        if sqlite3_prepare_v2(db, query, -1, &statement, nil) == SQLITE_OK {
 51 
        if sqlite3_prepare_v2(db, query, -1, &statement, nil) == SQLITE_OK {
49 
            sqlite3_bind_text(statement, 1, model.deviceUuid, -1 , SQLITE_TRANSIENT)
 52 
            sqlite3_bind_text(statement, 1, model.deviceUuid, -1 , SQLITE_TRANSIENT)
Línea 60... Línea 63...
60 
            sqlite3_bind_text(statement, 12, model.capsuleUuidOld , -1, SQLITE_TRANSIENT)
 63 
            sqlite3_bind_text(statement, 12, model.capsuleUuidOld , -1, SQLITE_TRANSIENT)
61 
            sqlite3_bind_text(statement, 13, model.slideUuidActive , -1, SQLITE_TRANSIENT)
 64 
            sqlite3_bind_text(statement, 13, model.slideUuidActive , -1, SQLITE_TRANSIENT)
62 
            sqlite3_bind_text(statement, 14, model.maxDateChanges , -1, SQLITE_TRANSIENT)
 65 
            sqlite3_bind_text(statement, 14, model.maxDateChanges , -1, SQLITE_TRANSIENT)
63 
            sqlite3_bind_text(statement, 15, model.companyUuidActive , -1, SQLITE_TRANSIENT)
 66 
            sqlite3_bind_text(statement, 15, model.companyUuidActive , -1, SQLITE_TRANSIENT)
64 
            sqlite3_bind_text(statement, 16, model.urlExternalDownloaded, -1, SQLITE_TRANSIENT)
 67 
            sqlite3_bind_text(statement, 16, model.urlExternalDownloaded, -1, SQLITE_TRANSIENT)
- 
 
 68 
            sqlite3_bind_text(statement, 17, model.refreshContentMessage, -1, SQLITE_TRANSIENT)
- 
 
 69 
            sqlite3_bind_int(statement, 18, Int32(model.refreshContentMessageShowPending ?  1 : 0))
- 
 
 70 
            sqlite3_bind_int(statement, 19, Int32(model.refreshContentActionRequired ? 1 : 0))
Línea 65... Línea 71...
65
71
66 
            if (sqlite3_step(statement) == SQLITE_DONE) {
 72 
            if (sqlite3_step(statement) == SQLITE_DONE) {
67 
                result = Int(sqlite3_last_insert_rowid(db))
 73 
                result = Int(sqlite3_last_insert_rowid(db))
68 
           } else {
 74 
           } else {
Línea 100... Línea 106...
100 
        query = query + Constants.TABLE_APP_FIELD_CAPSULE_UUID_ACTIVE + ", "
 106 
        query = query + Constants.TABLE_APP_FIELD_CAPSULE_UUID_ACTIVE + ", "
101 
        query = query + Constants.TABLE_APP_FIELD_CAPSULE_UUID_OLD + ", "
 107 
        query = query + Constants.TABLE_APP_FIELD_CAPSULE_UUID_OLD + ", "
102 
        query = query + Constants.TABLE_APP_FIELD_SLIDE_UUID_ACTIVE + ", "
 108 
        query = query + Constants.TABLE_APP_FIELD_SLIDE_UUID_ACTIVE + ", "
103 
        query = query + Constants.TABLE_APP_FIELD_MAX_DATE_CHANGES + ", "
 109 
        query = query + Constants.TABLE_APP_FIELD_MAX_DATE_CHANGES + ", "
104 
        query = query + Constants.TABLE_APP_FIELD_COMPANY_UUID_ACTIVE + ", "
 110 
        query = query + Constants.TABLE_APP_FIELD_COMPANY_UUID_ACTIVE + ", "
105 
        query = query + Constants.TABLE_APP_FIELD_URL_EXTERNAL_DOWNLOADED
 111 
        query = query + Constants.TABLE_APP_FIELD_URL_EXTERNAL_DOWNLOADED + ", "
- 
 
 112 
        query = query + Constants.TABLE_APP_FIELD_REFRESH_CONTENT_MESSAGE + ", "
- 
 
 113 
        query = query + Constants.TABLE_APP_FIELD_REFRESH_CONTENT_MESSAGE_SHOW_PENDING + ", "
- 
 
 114 
        query = query + Constants.TABLE_APP_FIELD_REFRESH_CONTENT_ACTION_REQUIRED
106 
        query = query + " FROM " + Constants.TABLE_APP
 115 
        query = query + " FROM " + Constants.TABLE_APP
107 
        query = query + " LIMIT 1;"
 116 
        query = query + " LIMIT 1;"
Línea 108... Línea 117...
108
117
Línea 142... Línea 151...
142
151
Línea 143... Línea 152...
143 
                model.companyUuidActive  = String(describing: String(cString: sqlite3_column_text(statement, 15)))
 152 
                model.companyUuidActive  = String(describing: String(cString: sqlite3_column_text(statement, 15)))
Línea -... Línea 153...
- 
 
 153
- 
 
 154 
                model.urlExternalDownloaded  = String(describing: String(cString: sqlite3_column_text(statement, 16)))
- 
 
 155
- 
 
 156 
                model.refreshContentMessage  = String(describing: String(cString: sqlite3_column_text(statement, 17)))
144
157
145 
                model.urlExternalDownloaded  = String(describing: String(cString: sqlite3_column_text(statement, 16)))
 158 
                model.refreshContentMessageShowPending = Int(sqlite3_column_int(statement, 18)) > 0
146
159 
                model.refreshContentActionRequired = Int(sqlite3_column_int(statement, 19)) > 0
147 
            }
 160 
            }
Línea 174... Línea 187...
174 
        query = query + Constants.TABLE_APP_FIELD_SLIDE_UUID_ACTIVE + " = '\(model.slideUuidActive)', "
 187 
        query = query + Constants.TABLE_APP_FIELD_SLIDE_UUID_ACTIVE + " = '\(model.slideUuidActive)', "
Línea 175... Línea 188...
175 
 
 188 
 
176 
        query = query + Constants.TABLE_APP_FIELD_MAX_DATE_CHANGES + " = '\(model.maxDateChanges)', "
 189 
        query = query + Constants.TABLE_APP_FIELD_MAX_DATE_CHANGES + " = '\(model.maxDateChanges)', "
177 
        query = query + Constants.TABLE_APP_FIELD_COMPANY_UUID_ACTIVE + " = '\(model.companyUuidActive)', "
 190 
        query = query + Constants.TABLE_APP_FIELD_COMPANY_UUID_ACTIVE + " = '\(model.companyUuidActive)', "
- 
 
 191 
        query = query + Constants.TABLE_APP_FIELD_URL_EXTERNAL_DOWNLOADED + " = '\(model.urlExternalDownloaded)' "
- 
 
 192 
        query = query + Constants.TABLE_APP_FIELD_REFRESH_CONTENT_MESSAGE + " = '\(model.refreshContentMessage)' "
- 
 
 193 
        query = query + Constants.TABLE_APP_FIELD_REFRESH_CONTENT_MESSAGE_SHOW_PENDING + " = '\(model.refreshContentMessageShowPending ? 1 : 0)' "
178 
        query = query + Constants.TABLE_APP_FIELD_URL_EXTERNAL_DOWNLOADED + " = '\(model.urlExternalDownloaded)' "
 194 
        query = query + Constants.TABLE_APP_FIELD_REFRESH_CONTENT_ACTION_REQUIRED + " = '\(model.refreshContentActionRequired)' "