Create DELETE trigger

DROP TRIGGER IF EXISTS DELETED_ROUTE;
CREATE TRIGGER DELETED_ROUTE
    AFTER DELETE
    ON routes
    FOR EACH ROW
BEGIN
    CALL mysql.lambda_async(
            'arn:aws:lambda:eu-west-1:XXXXXXXXXX:function:RDS-EVENTS-CONSUMER',
            JSON_OBJECT(
                    'old', JSON_OBJECT(
                            'airportFrom', OLD.airportFrom,
                            'airportTo', OLD.airportTo,
                            'connectingAirport', OLD.connectingAirport,
                            'newRoute', OLD.newRoute is true,
                            'seasonalRoute', OLD.seasonalRoute is true,
                            'operator', OLD.operator,
                            'group', OLD.group,
                            'tags', OLD.tags,
                            'similarArrivalAirportCodes', OLD.similarArrivalAirportCodes,
                            'carrierCode', OLD.carrierCode)
                )
        );
end;

# Test delete
DELETE FROM flights.routes WHERE airportFrom = 'FOO' AND airportTo = 'BAR';