Proyectos de Subversion Iphone Microlearning - Nuevo Interface

    }

    func removeExpired(userUuid : String)

    {

        let now = Date()

        let date = Calendar.current.date(byAdding: .day, value: -5, to: now)!

        let dateFormatter = DateFormatter()

        dateFormatter.dateFormat = Constants.FORMAT_DATE_YMD

        let sDate = dateFormatter.string(from: date)

        let db = database.open()

        var query = "DELETE FROM " + Constants.TABLE_USER_NOTIFICATION

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

        query = query + " AND " + Constants.TABLE_USER_NOTIFICATION_FIELD_DATE_ON + " < '\(sDate)' "

        var statement : OpaquePointer? = nil

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

            if (sqlite3_step(statement) != SQLITE_DONE) {

                print("No se pudo borrar los registros con fecha menor a : \(sDate) en la tabla: \(Constants.TABLE_USER_NOTIFICATION)")

                database.printError()

            }

        } else {

            print("Fallo la preparación del borrado de los registros con fecha menor a : \(sDate) en la tabla: \(Constants.TABLE_USER_NOTIFICATION)" )

            database.printError()

        }

        sqlite3_finalize(statement)