wir mussten ein paar Änderungen in den Flug-Richtungen per Hand setzen. Verantwortlicher: NFL, RKU Zeitpunkt: 2022-03-09 09:45-10:30 Uhr Kunden: FER Task: XRES-9008 SELECT count(*) from `flight` WHERE `type`='OW' and direction=4; => 1105 UPDATE `flight` SET `direction`=3 WHERE `type`='OW' and direction=4 [2022-03-09 10:15:57] 1,105 rows affected in 1 s 639 ms SELECT count(*) from `flight` WHERE `type` = "OW" AND direction = 3 AND `parsed_times` LIKE '%outward_flight%' AND `parsed_times` NOT LIKE '%"outward_flight";a:0:{}%' AND ( `parsed_times` NOT LIKE '%return_flight%' or `parsed_times` LIKE '%"return_flight";a:0:{}%' ); => 1107 UPDATE `flight` SET `direction`=1 WHERE `type` = "OW" AND direction = 3 AND `parsed_times` LIKE '%outward_flight%' AND `parsed_times` NOT LIKE '%"outward_flight";a:0:{}%' AND ( `parsed_times` NOT LIKE '%return_flight%' or `parsed_times` LIKE '%"return_flight";a:0:{}%' ) [2022-03-09 10:23:21] 1,107 rows affected in 1 s 685 ms -- Mit freundlichen Grüßen / Kind regards Rene Kühle - Entwickler - ___________________________________________________________________________ TraSo GmbH Nonnenstraße 42 D-04229 Leipzig Tel.: +49 341 355 740 20 Internet: http://traso.de E-Mail: r.kuehle@traso.de ___________________________________________________________________________ Geschäftsführer: Haiko Gerdes Handelsregister: Amtsgericht Leipzig, HRB 21850