Proyectos de Subversion Iphone Microlearning - Nuevo Interface

    func selectAllByUserUuid(userUuid : String)-> [UserNotificationModel] {

        let db = database.open()

        var records = [UserNotificationModel]()

        var query = "SELECT "

        query = query + Constants.TABLE_USER_NOTIFICATION_FIELD_ID + ", "

        query = query + Constants.TABLE_USER_NOTIFICATION_FIELD_USER_UUID + ", "

        query = query + Constants.TABLE_USER_NOTIFICATION_FIELD_TITLE + ", "

        query = query + Constants.TABLE_USER_NOTIFICATION_FIELD_BODY + ", "

        query = query + Constants.TABLE_USER_NOTIFICATION_FIELD_URL + " , "

        query = query + Constants.TABLE_USER_NOTIFICATION_FIELD_VIEWED + " , "

        query = query + Constants.TABLE_USER_NOTIFICATION_FIELD_COMMAND + " , "

        query = query + Constants.TABLE_USER_NOTIFICATION_FIELD_DATE_ON + " , "

        query = query + Constants.TABLE_USER_NOTIFICATION_FIELD_TIME_ON

        query = query + " FROM " + Constants.TABLE_USER_NOTIFICATION

        query = query + " WHERE " + Constants.TABLE_USER_NOTIFICATION_FIELD_USER_UUID + " = '\(userUuid)'; "

        query = query + " ORDER BY  " + Constants.TABLE_USER_NOTIFICATION_FIELD_DATE_ON + " DESC,  "

        query = query + Constants.TABLE_USER_NOTIFICATION_FIELD_TIME_ON + " DESC; "

        var statement : OpaquePointer? = nil

        if (sqlite3_prepare_v2(db, query, -1, &statement, nil) == SQLITE_OK) {

            while (sqlite3_step(statement) == SQLITE_ROW) {

                var  model = UserNotificationModel()

                model.id = Int(sqlite3_column_int(statement, 0))

                model.userUuid = String(describing: String(cString: sqlite3_column_text(statement, 1)))

                model.title = String(describing: String(cString: sqlite3_column_text(statement, 2)))

                model.body = String(describing: String(cString: sqlite3_column_text(statement, 3)))

                model.url = String(describing: String(cString: sqlite3_column_text(statement, 4)))

                model.viewed = Int(sqlite3_column_int(statement, 5))

                model.command = String(describing: String(cString: sqlite3_column_text(statement, 6)))

                model.dateOn = String(describing: String(cString: sqlite3_column_text(statement, 7)))

                model.timeOn = String(describing: String(cString: sqlite3_column_text(statement, 8)))

                records.append(model)

            }

        } else {

            database.printError()

        }

        sqlite3_finalize(statement)

        return records

    }