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