Proyectos de Subversion Iphone Microlearning - Nuevo Interface

Rev

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

Rev 31 Rev 32
Línea 42... Línea 42...
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 + ", "
 45 
        query = query + Constants.TABLE_APP_FIELD_REFRESH_CONTENT_MESSAGE + ", "
46 
        query = query + Constants.TABLE_APP_FIELD_REFRESH_CONTENT_MESSAGE_SHOW_PENDING + ", "
 46 
        query = query + Constants.TABLE_APP_FIELD_REFRESH_CONTENT_MESSAGE_SHOW_PENDING + ", "
47 
        query = query + Constants.TABLE_APP_FIELD_REFRESH_CONTENT_ACTION_REQUIRED
 47 
        query = query + Constants.TABLE_APP_FIELD_REFRESH_CONTENT_ACTION_REQUIRED + ", "
- 
 
 48 
        query = query + Constants.TABLE_APP_FIELD_SIGNOUT_ACTION_REQUIRED
48 
        query = query +  ") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);"
 49 
        query = query +  ") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);"
49 
        var statement : OpaquePointer?
 50 
        var statement : OpaquePointer?
Línea 50... Línea 51...
50 
 
 51 
 
51 
        if sqlite3_prepare_v2(db, query, -1, &statement, nil) == SQLITE_OK {
 52 
        if sqlite3_prepare_v2(db, query, -1, &statement, nil) == SQLITE_OK {
52 
            sqlite3_bind_text(statement, 1, model.deviceUuid, -1 , SQLITE_TRANSIENT)
 53 
            sqlite3_bind_text(statement, 1, model.deviceUuid, -1 , SQLITE_TRANSIENT)
Línea 66... Línea 67...
66 
            sqlite3_bind_text(statement, 15, model.companyUuidActive , -1, SQLITE_TRANSIENT)
 67 
            sqlite3_bind_text(statement, 15, model.companyUuidActive , -1, SQLITE_TRANSIENT)
67 
            sqlite3_bind_text(statement, 16, model.urlExternalDownloaded, -1, SQLITE_TRANSIENT)
 68 
            sqlite3_bind_text(statement, 16, model.urlExternalDownloaded, -1, SQLITE_TRANSIENT)
68 
            sqlite3_bind_text(statement, 17, model.refreshContentMessage, -1, SQLITE_TRANSIENT)
 69 
            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, 18, Int32(model.refreshContentMessageShowPending ?  1 : 0))
70 
            sqlite3_bind_int(statement, 19, Int32(model.refreshContentActionRequired ? 1 : 0))
 71 
            sqlite3_bind_int(statement, 19, Int32(model.refreshContentActionRequired ? 1 : 0))
- 
 
 72 
            sqlite3_bind_int(statement, 20, Int32(model.signoutActionRequired ? 1 : 0))
Línea 71... Línea 73...
71
73
72 
            if (sqlite3_step(statement) == SQLITE_DONE) {
 74 
            if (sqlite3_step(statement) == SQLITE_DONE) {
73 
                result = Int(sqlite3_last_insert_rowid(db))
 75 
                result = Int(sqlite3_last_insert_rowid(db))
74 
           } else {
 76 
           } else {
Línea 109... Línea 111...
109 
        query = query + Constants.TABLE_APP_FIELD_MAX_DATE_CHANGES + ", "
 111 
        query = query + Constants.TABLE_APP_FIELD_MAX_DATE_CHANGES + ", "
110 
        query = query + Constants.TABLE_APP_FIELD_COMPANY_UUID_ACTIVE + ", "
 112 
        query = query + Constants.TABLE_APP_FIELD_COMPANY_UUID_ACTIVE + ", "
111 
        query = query + Constants.TABLE_APP_FIELD_URL_EXTERNAL_DOWNLOADED + ", "
 113 
        query = query + Constants.TABLE_APP_FIELD_URL_EXTERNAL_DOWNLOADED + ", "
112 
        query = query + Constants.TABLE_APP_FIELD_REFRESH_CONTENT_MESSAGE + ", "
 114 
        query = query + Constants.TABLE_APP_FIELD_REFRESH_CONTENT_MESSAGE + ", "
113 
        query = query + Constants.TABLE_APP_FIELD_REFRESH_CONTENT_MESSAGE_SHOW_PENDING + ", "
 115 
        query = query + Constants.TABLE_APP_FIELD_REFRESH_CONTENT_MESSAGE_SHOW_PENDING + ", "
114 
        query = query + Constants.TABLE_APP_FIELD_REFRESH_CONTENT_ACTION_REQUIRED
 116 
        query = query + Constants.TABLE_APP_FIELD_REFRESH_CONTENT_ACTION_REQUIRED + ", "
- 
 
 117 
        query = query + Constants.TABLE_APP_FIELD_SIGNOUT_ACTION_REQUIRED
115 
        query = query + " FROM " + Constants.TABLE_APP
 118 
        query = query + " FROM " + Constants.TABLE_APP
116 
        query = query + " LIMIT 1;"
 119 
        query = query + " LIMIT 1;"
Línea 117... Línea 120...
117
120
Línea 155... Línea 158...
155
158
Línea 156... Línea 159...
156 
                model.refreshContentMessage  = String(describing: String(cString: sqlite3_column_text(statement, 17)))
 159 
                model.refreshContentMessage  = String(describing: String(cString: sqlite3_column_text(statement, 17)))
157
160
- 
 
 161 
                model.refreshContentMessageShowPending = Int(sqlite3_column_int(statement, 18)) > 0
158 
                model.refreshContentMessageShowPending = Int(sqlite3_column_int(statement, 18)) > 0
 162 
                model.refreshContentActionRequired = Int(sqlite3_column_int(statement, 19)) > 0
159 
                model.refreshContentActionRequired = Int(sqlite3_column_int(statement, 19)) > 0
 163 
                model.signoutActionRequired = Int(sqlite3_column_int(statement, 20)) > 0
160 
            }
 164 
            }
161 
        } else {
 165 
        } else {
Línea 189... Línea 193...
189 
        query = query + Constants.TABLE_APP_FIELD_MAX_DATE_CHANGES + " = '\(model.maxDateChanges)', "
 193 
        query = query + Constants.TABLE_APP_FIELD_MAX_DATE_CHANGES + " = '\(model.maxDateChanges)', "
190 
        query = query + Constants.TABLE_APP_FIELD_COMPANY_UUID_ACTIVE + " = '\(model.companyUuidActive)', "
 194 
        query = query + Constants.TABLE_APP_FIELD_COMPANY_UUID_ACTIVE + " = '\(model.companyUuidActive)', "
191 
        query = query + Constants.TABLE_APP_FIELD_URL_EXTERNAL_DOWNLOADED + " = '\(model.urlExternalDownloaded)', "
 195 
        query = query + Constants.TABLE_APP_FIELD_URL_EXTERNAL_DOWNLOADED + " = '\(model.urlExternalDownloaded)', "
192 
        query = query + Constants.TABLE_APP_FIELD_REFRESH_CONTENT_MESSAGE + " = '\(model.refreshContentMessage)', "
 196 
        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)', "
 197 
        query = query + Constants.TABLE_APP_FIELD_REFRESH_CONTENT_MESSAGE_SHOW_PENDING + " = '\(model.refreshContentMessageShowPending ? 1 : 0)', "
194 
        query = query + Constants.TABLE_APP_FIELD_REFRESH_CONTENT_ACTION_REQUIRED + " = '\(model.refreshContentActionRequired ? 1 : 0)' "
 198 
        query = query + Constants.TABLE_APP_FIELD_REFRESH_CONTENT_ACTION_REQUIRED + " = '\(model.refreshContentActionRequired ? 1 : 0)', "
- 
 
 199 
        query = query + Constants.TABLE_APP_FIELD_SIGNOUT_ACTION_REQUIRED + " = '\(model.signoutActionRequired ? 1 : 0)' "
195 
        query = query + " WHERE " + Constants.TABLE_APP_FIELD_ID + " = '\(model.id)' "
 200 
        query = query + " WHERE " + Constants.TABLE_APP_FIELD_ID + " = '\(model.id)' "