Proyectos de Subversion Iphone Microlearning - Nuevo Interface

Rev

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

Rev 1 Rev 11
Línea 48... Línea 48...
48
                model.description = String(describing: String(cString: sqlite3_column_text(statement, 3)))
48
                model.description = String(describing: String(cString: sqlite3_column_text(statement, 3)))
49
                model.image = String(describing: String(cString: sqlite3_column_text(statement, 4)))
49
                model.image = String(describing: String(cString: sqlite3_column_text(statement, 4)))
50
                model.position = Int(sqlite3_column_int(statement, 5))
50
                model.position = Int(sqlite3_column_int(statement, 5))
51
                model.addedOn = String(describing: String(cString: sqlite3_column_text(statement, 6)))
51
                model.addedOn = String(describing: String(cString: sqlite3_column_text(statement, 6)))
52
                model.updatedOn = String(describing: String(cString: sqlite3_column_text(statement, 7)))
52
                model.updatedOn = String(describing: String(cString: sqlite3_column_text(statement, 7)))
53
                print("\nSuccessfully get record")
53
                //print("\nSuccessfully get record")
Línea 54... Línea 54...
54
                
54
                
55
            }
55
            }
56
        }
56
        }
57
        sqlite3_finalize(statement)
57
        sqlite3_finalize(statement)
Línea 111... Línea 111...
111
        query = query + Constants.TABLE_TOPIC_FIELD_ADDED_ON + " , "
111
        query = query + Constants.TABLE_TOPIC_FIELD_ADDED_ON + " , "
112
        query = query + Constants.TABLE_TOPIC_FIELD_UPDATED_ON
112
        query = query + Constants.TABLE_TOPIC_FIELD_UPDATED_ON
113
        query = query + " FROM " + Constants.TABLE_TOPIC
113
        query = query + " FROM " + Constants.TABLE_TOPIC
114
        query = query + " ORDER BY  " + Constants.TABLE_TOPIC_FIELD_NAME + " ;"
114
        query = query + " ORDER BY  " + Constants.TABLE_TOPIC_FIELD_NAME + " ;"
Línea 115... Línea 115...
115
        
115
        
116
        print("query = \(query) ")
116
        //print("query = \(query) ")
Línea 117... Línea 117...
117
        var statement : OpaquePointer? = nil
117
        var statement : OpaquePointer? = nil
118
        
118
        
Línea 147... Línea 147...
147
        
147
        
148
        
148
        
149
        if (sqlite3_prepare(db, query, -1, &statement, nil) == SQLITE_OK) {
149
        if (sqlite3_prepare(db, query, -1, &statement, nil) == SQLITE_OK) {
150
            if(sqlite3_step(statement) == SQLITE_ROW){
150
            if(sqlite3_step(statement) == SQLITE_ROW){
151
                count = Int(sqlite3_column_int(statement, 0))
151
                count = Int(sqlite3_column_int(statement, 0))
152
                print("\(count)")
152
                //print("\(count)")
153
            }
153
            }
154
        } else {
154
        } else {
155
            count = -1
155
            count = -1