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 17
Línea 70... Línea 70...
70 
        }
 70 
        }
71 
        sqlite3_finalize(statement)
 71 
        sqlite3_finalize(statement)
72 
        return record
 72 
        return record
73 
    }
 73 
    }
Línea -... Línea 74...
- 
 
 74
- 
 
 75
- 
 
 76 
    func countPendingRecords()-> Int {
- 
 
 77 
        var count = 0
- 
 
 78 
        let query = "SELECT COUNT(*) AS total FROM " +  Constants.TABLE_SYNC
- 
 
 79 
        var statement : OpaquePointer? = nil
- 
 
 80
- 
 
 81
- 
 
 82 
        if (sqlite3_prepare(db, query, -1, &statement, nil) == SQLITE_OK) {
- 
 
 83 
            if(sqlite3_step(statement) == SQLITE_ROW){
- 
 
 84 
                count = Int(sqlite3_column_int(statement, 0))
- 
 
 85 
            }
- 
 
 86 
        }
- 
 
 87 
        sqlite3_finalize(statement)
- 
 
 88 
        return count
- 
 
 89 
    }
74
90
75 
    func selectBatch()-> [SyncModel] {
 91 
    func selectBatch()-> [SyncModel] {
Línea 76... Línea 92...
76 
        var records = [SyncModel]()
 92 
        var records = [SyncModel]()
77
93
78 
        let query = "SELECT "
 94 
        var query = "SELECT "
79 
            + Constants.TABLE_SYNC_FIELD_ID + "  , "
 95 
        query = query + Constants.TABLE_SYNC_FIELD_ID + "  , "
80 
            + Constants.TABLE_SYNC_FIELD_TYPE + " , "
 96 
        query = query + Constants.TABLE_SYNC_FIELD_TYPE + " , "
- 
 
 97 
        query = query + Constants.TABLE_SYNC_FIELD_DATA
- 
 
 98 
        query = query + " FROM " + Constants.TABLE_SYNC
81 
            + Constants.TABLE_SYNC_FIELD_DATA
 99 
        query = query + " ORDER BY " + Constants.TABLE_SYNC_FIELD_ID + " ASC "
Línea 82... Línea 100...
82 
            + "  FROM " + Constants.TABLE_SYNC + " LIMIT 5; "
 100 
        query = query + " LIMIT 10; "
83 
        var statement : OpaquePointer? = nil
 101 
        var statement : OpaquePointer? = nil
84
102
85
103
86 
        if (sqlite3_prepare_v2(db, query, -1, &statement, nil) == SQLITE_OK) {
 104 
        if (sqlite3_prepare_v2(db, query, -1, &statement, nil) == SQLITE_OK) {
87 
            if (sqlite3_step(statement) == SQLITE_ROW) {
 105 
            while (sqlite3_step(statement) == SQLITE_ROW) {