Proyectos de Subversion Iphone Microlearning - Nuevo Interface

Rev

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

Rev 11 Rev 17
Línea 42... Línea 42...
42 
        query = query + Constants.TABLE_APP_FIELD_FCM_TOKEN + ", "
 42 
        query = query + Constants.TABLE_APP_FIELD_FCM_TOKEN + ", "
43 
        query = query + Constants.TABLE_APP_FIELD_TOPIC_UUID_ACTIVE + ", "
 43 
        query = query + Constants.TABLE_APP_FIELD_TOPIC_UUID_ACTIVE + ", "
44 
        query = query + Constants.TABLE_APP_FIELD_CAPSULE_UUID_ACTIVE + ", "
 44 
        query = query + Constants.TABLE_APP_FIELD_CAPSULE_UUID_ACTIVE + ", "
45 
        query = query + Constants.TABLE_APP_FIELD_CAPSULE_UUID_OLD + ", "
 45 
        query = query + Constants.TABLE_APP_FIELD_CAPSULE_UUID_OLD + ", "
46 
        query = query + Constants.TABLE_APP_FIELD_SLIDE_UUID_ACTIVE + ", "
 46 
        query = query + Constants.TABLE_APP_FIELD_SLIDE_UUID_ACTIVE + ", "
47 
        query = query + Constants.TABLE_APP_FIELD_SLIDE_POSITION_INITIAL + ", "
 - 
 
48 
        query = query + Constants.TABLE_APP_FIELD_MAX_DATE_CHANGES + ", "
 47 
        query = query + Constants.TABLE_APP_FIELD_MAX_DATE_CHANGES + ", "
49 
        query = query + Constants.TABLE_APP_FIELD_COMPANY_UUID_ACTIVE
 48 
        query = query + Constants.TABLE_APP_FIELD_COMPANY_UUID_ACTIVE + ", "
- 
 
 49 
        query = query + Constants.TABLE_APP_FIELD_URL_EXTERNAL_DOWNLOADED
50 
        query = query +  ") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);"
 50 
        query = query +  ") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);"
51 
        var statement : OpaquePointer?
 51 
        var statement : OpaquePointer?
Línea 52... Línea 52...
52 
 
 52 
 
53 
        if sqlite3_prepare_v2(db, query, -1, &statement, nil) == SQLITE_OK {
 53 
        if sqlite3_prepare_v2(db, query, -1, &statement, nil) == SQLITE_OK {
Línea 62... Línea 62...
62 
            sqlite3_bind_text(statement, 9, model.fcmToken , -1, SQLITE_TRANSIENT)
 62 
            sqlite3_bind_text(statement, 9, model.fcmToken , -1, SQLITE_TRANSIENT)
63 
            sqlite3_bind_text(statement, 10, model.topicUuidActive , -1, SQLITE_TRANSIENT)
 63 
            sqlite3_bind_text(statement, 10, model.topicUuidActive , -1, SQLITE_TRANSIENT)
64 
            sqlite3_bind_text(statement, 11, model.capsuleUuidActive , -1, SQLITE_TRANSIENT)
 64 
            sqlite3_bind_text(statement, 11, model.capsuleUuidActive , -1, SQLITE_TRANSIENT)
65 
            sqlite3_bind_text(statement, 12, model.capsuleUuidOld , -1, SQLITE_TRANSIENT)
 65 
            sqlite3_bind_text(statement, 12, model.capsuleUuidOld , -1, SQLITE_TRANSIENT)
66 
            sqlite3_bind_text(statement, 13, model.slideUuidActive , -1, SQLITE_TRANSIENT)
 66 
            sqlite3_bind_text(statement, 13, model.slideUuidActive , -1, SQLITE_TRANSIENT)
67 
            sqlite3_bind_int(statement, 14, Int32(model.slidePositionInitial))
 67 
            sqlite3_bind_text(statement, 14, model.maxDateChanges , -1, SQLITE_TRANSIENT)
68 
            sqlite3_bind_text(statement, 15, model.maxDateChanges , -1, SQLITE_TRANSIENT)
 68 
            sqlite3_bind_text(statement, 15, model.companyUuidActive , -1, SQLITE_TRANSIENT)
69 
            sqlite3_bind_text(statement, 16, model.companyUuidActive , -1, SQLITE_TRANSIENT)
 69 
            sqlite3_bind_text(statement, 16, model.urlExternalDownloaded, -1, SQLITE_TRANSIENT)
70 
 
 70
71 
            if (sqlite3_step(statement) == SQLITE_DONE) {
 71 
            if (sqlite3_step(statement) == SQLITE_DONE) {
72 
                result = Int(sqlite3_last_insert_rowid(db))
 72 
                result = Int(sqlite3_last_insert_rowid(db))
73 
           } else {
 73 
           } else {
74 
            print("No se pudo insertar un registro en la tabla: \(Constants.TABLE_APP) ")
 74 
            print("No se pudo insertar un registro en la tabla: \(Constants.TABLE_APP) ")
75 
           }
 75 
           }
Línea 100... Línea 100...
100 
        query = query + Constants.TABLE_APP_FIELD_FCM_TOKEN + ", "
 100 
        query = query + Constants.TABLE_APP_FIELD_FCM_TOKEN + ", "
101 
        query = query + Constants.TABLE_APP_FIELD_TOPIC_UUID_ACTIVE + ", "
 101 
        query = query + Constants.TABLE_APP_FIELD_TOPIC_UUID_ACTIVE + ", "
102 
        query = query + Constants.TABLE_APP_FIELD_CAPSULE_UUID_ACTIVE + ", "
 102 
        query = query + Constants.TABLE_APP_FIELD_CAPSULE_UUID_ACTIVE + ", "
103 
        query = query + Constants.TABLE_APP_FIELD_CAPSULE_UUID_OLD + ", "
 103 
        query = query + Constants.TABLE_APP_FIELD_CAPSULE_UUID_OLD + ", "
104 
        query = query + Constants.TABLE_APP_FIELD_SLIDE_UUID_ACTIVE + ", "
 104 
        query = query + Constants.TABLE_APP_FIELD_SLIDE_UUID_ACTIVE + ", "
105 
        query = query + Constants.TABLE_APP_FIELD_SLIDE_POSITION_INITIAL + ", "
 - 
 
106 
        query = query + Constants.TABLE_APP_FIELD_MAX_DATE_CHANGES + ", "
 105 
        query = query + Constants.TABLE_APP_FIELD_MAX_DATE_CHANGES + ", "
107 
        query = query + Constants.TABLE_APP_FIELD_COMPANY_UUID_ACTIVE
 106 
        query = query + Constants.TABLE_APP_FIELD_COMPANY_UUID_ACTIVE + ", "
- 
 
 107 
        query = query + Constants.TABLE_APP_FIELD_URL_EXTERNAL_DOWNLOADED
108 
        query = query + " FROM " + Constants.TABLE_APP
 108 
        query = query + " FROM " + Constants.TABLE_APP
109 
        query = query + " LIMIT 1;"
 109 
        query = query + " LIMIT 1;"
Línea 110... Línea 110...
110
110
Línea 111... Línea 111...
111 
        //print("selectOne : \(query)")
 111 
        //print("selectOne : \(query)")
112
112
113 
        var statement : OpaquePointer? = nil
 113 
        var statement : OpaquePointer? = nil
- 
 
 114 
        if sqlite3_prepare_v2(db, query, -1, &statement, nil) == SQLITE_OK{
114 
        if sqlite3_prepare_v2(db, query, -1, &statement, nil) == SQLITE_OK{
 115 
            while sqlite3_step(statement) == SQLITE_ROW {
Línea 115... Línea 116...
115 
            while sqlite3_step(statement) == SQLITE_ROW {
 116
Línea 116... Línea -...
116 
                model.id = Int(sqlite3_column_int(statement, 0))
 - 
 
117
117 
                model.id = Int(sqlite3_column_int(statement, 0))
- 
 
 118
118
119
Línea 119... Línea 120...
119 
                model.deviceUuid = String(describing: String(cString: sqlite3_column_text(statement, 1)))
 120 
                model.deviceUuid = String(describing: String(cString: sqlite3_column_text(statement, 1)))
120
121
121 
 
 122 
                model.deviceAes = String(describing: String(cString: sqlite3_column_text(statement, 2)))
Línea 130... Línea 131...
130
131
Línea 131... Línea 132...
131
132
- 
 
 133 
                model.fcmToken = String(describing: String(cString: sqlite3_column_text(statement, 9)))
132 
                model.fcmToken = String(describing: String(cString: sqlite3_column_text(statement, 9)))
 134
- 
 
 135 
                model.topicUuidActive = String(describing: String(cString: sqlite3_column_text(statement, 10)))
133
136
- 
 
 137 
                model.capsuleUuidActive = String(describing: String(cString: sqlite3_column_text(statement, 11)))
134 
                model.topicUuidActive = String(describing: String(cString: sqlite3_column_text(statement, 10)))
 138
135 
                model.capsuleUuidActive = String(describing: String(cString: sqlite3_column_text(statement, 11)))
 - 
 
Línea 136... Línea 139...
136 
                model.capsuleUuidOld = String(describing: String(cString: sqlite3_column_text(statement, 12)))
 139 
                model.capsuleUuidOld = String(describing: String(cString: sqlite3_column_text(statement, 12)))
Línea 137... Línea 140...
137 
                model.slideUuidActive = String(describing: String(cString: sqlite3_column_text(statement, 13)))
 140
Línea -... Línea 141...
- 
 
 141 
                model.slideUuidActive = String(describing: String(cString: sqlite3_column_text(statement, 13)))
- 
 
 142
- 
 
 143 
                model.maxDateChanges  = String(describing: String(cString: sqlite3_column_text(statement, 14)))
- 
 
 144
- 
 
 145 
                model.companyUuidActive  = String(describing: String(cString: sqlite3_column_text(statement, 15)))
138 
                model.slidePositionInitial = Int(sqlite3_column_int(statement, 14))
 146
Línea 139... Línea 147...
139
147 
                model.urlExternalDownloaded  = String(describing: String(cString: sqlite3_column_text(statement, 16)))
140 
                model.maxDateChanges  = String(describing: String(cString: sqlite3_column_text(statement, 14)))
 148
141
149 
 
Línea 166... Línea 174...
166 
        query = query + Constants.TABLE_APP_FIELD_FCM_TOKEN + " = '\(model.fcmToken)', "
 174 
        query = query + Constants.TABLE_APP_FIELD_FCM_TOKEN + " = '\(model.fcmToken)', "
167 
        query = query + Constants.TABLE_APP_FIELD_TOPIC_UUID_ACTIVE + " = '\(model.topicUuidActive)', "
 175 
        query = query + Constants.TABLE_APP_FIELD_TOPIC_UUID_ACTIVE + " = '\(model.topicUuidActive)', "
168 
        query = query + Constants.TABLE_APP_FIELD_CAPSULE_UUID_ACTIVE + " = '\(model.capsuleUuidActive)', "
 176 
        query = query + Constants.TABLE_APP_FIELD_CAPSULE_UUID_ACTIVE + " = '\(model.capsuleUuidActive)', "
169 
        query = query + Constants.TABLE_APP_FIELD_CAPSULE_UUID_OLD + " = '\(model.capsuleUuidOld)', "
 177 
        query = query + Constants.TABLE_APP_FIELD_CAPSULE_UUID_OLD + " = '\(model.capsuleUuidOld)', "
170 
        query = query + Constants.TABLE_APP_FIELD_SLIDE_UUID_ACTIVE + " = '\(model.slideUuidActive)', "
 178 
        query = query + Constants.TABLE_APP_FIELD_SLIDE_UUID_ACTIVE + " = '\(model.slideUuidActive)', "
171 
        query = query + Constants.TABLE_APP_FIELD_SLIDE_POSITION_INITIAL + " = '\(model.slidePositionInitial)', "
 - 
 
- 
 
 179 
 
172 
        query = query + Constants.TABLE_APP_FIELD_MAX_DATE_CHANGES + " = '\(model.maxDateChanges)', "
 180 
        query = query + Constants.TABLE_APP_FIELD_MAX_DATE_CHANGES + " = '\(model.maxDateChanges)', "
173 
        query = query + Constants.TABLE_APP_FIELD_COMPANY_UUID_ACTIVE + " = '\(model.companyUuidActive)' "
 181 
        query = query + Constants.TABLE_APP_FIELD_COMPANY_UUID_ACTIVE + " = '\(model.companyUuidActive)', "
- 
 
 182 
        query = query + Constants.TABLE_APP_FIELD_URL_EXTERNAL_DOWNLOADED + " = '\(model.urlExternalDownloaded)' "
174 
        query = query + " WHERE " + Constants.TABLE_APP_FIELD_ID + " = '\(model.id)' "
 183 
        query = query + " WHERE " + Constants.TABLE_APP_FIELD_ID + " = '\(model.id)' "