Wir haben etwas nach der Migration aufgeräumt... Verantwortlicher: JFL, SPE, CZI, KSE, RKU Zeitpunkt: 2021-12-17 10:25:11 Uhr Kunden: FER Details: xres_fer_flights> update xres_fer_flights.contflights_booked set status = 2 where filekey in ( SELECT b.filekey from xres_fer_flights.contflights_booked AS b inner JOIN xres_fer_flights.contflights_booked_oneway AS bo ON bo.booking_id = b.id LEFT JOIN xres_fer_bookings.flight AS bf ON bf.vorgang = b.filekey WHERE bf.flight_id IS NULL AND b.`status` = 1 ) [2021-12-17 10:25:11] 5,964 rows affected in 4 s 157 ms
Manchmal hatte (aus Gründen) eine Flugleistung keinen Provider, über den TOC haben wir aber erkannt, dass es sich um einen KONT-Flug handelt. Deshalb haben wir den Provider auf "KONT" gesetzt.. Verantwortlicher: NFL, CZI, RKU Zeitpunkt: 2021-12-20 13:36:26 Uhr Kunden: FER Details:
select count(*) from xres_fer_bookings.flight where arr_date >= '2021-12-20' and (provider is null or provider = '') and operator in ( select toc from xres_fer_flights.toc_settings where provider = 'KONT' ) ORDER BY dep_date ASC [2021-12-20 13:33:29] 1 row retrieved starting from 1 in 1 s 129 ms (execution: 1 s 53 ms, fetching: 76 ms)
+--------+ |count(*)| +--------+ |2531 | +--------+
UPDATE xres_fer_bookings.flight SET provider = "KONT" where arr_date >= '2021-12-20' and (provider is null or provider = '') and operator in ( select toc from xres_fer_flights.toc_settings where provider = 'KONT' ) [2021-12-20 13:36:26] 2,531 rows affected in 6 s 908 ms
participants (1)
-
René Kühle