{"id":2310,"date":"2025-09-24T07:35:01","date_gmt":"2025-09-24T07:35:01","guid":{"rendered":"https:\/\/vladislavkudriashev23.thkit.ee\/WP\/?page_id=2310"},"modified":"2025-09-25T10:00:54","modified_gmt":"2025-09-25T10:00:54","slug":"xml-reis","status":"publish","type":"page","link":"https:\/\/vladislavkudriashev23.thkit.ee\/WP\/xml-reis\/","title":{"rendered":"XML Reis"},"content":{"rendered":"\n<ol class=\"wp-block-list\">\n<li>Andmete loomiseks kasutame <a href=\"https:\/\/www.mockaroo.com\/\">Mockaroo<\/a>&#8217;d.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-large wp-duotone-unset-1\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"520\" src=\"https:\/\/vladislavkudriashev23.thkit.ee\/WP\/wp-content\/uploads\/2025\/09\/77F9431F-8E42-48F7-8B57-2114CD223E5D-1024x520.png\" alt=\"\" class=\"wp-image-2311\" srcset=\"https:\/\/vladislavkudriashev23.thkit.ee\/WP\/wp-content\/uploads\/2025\/09\/77F9431F-8E42-48F7-8B57-2114CD223E5D-1024x520.png 1024w, https:\/\/vladislavkudriashev23.thkit.ee\/WP\/wp-content\/uploads\/2025\/09\/77F9431F-8E42-48F7-8B57-2114CD223E5D-300x152.png 300w, https:\/\/vladislavkudriashev23.thkit.ee\/WP\/wp-content\/uploads\/2025\/09\/77F9431F-8E42-48F7-8B57-2114CD223E5D-768x390.png 768w, https:\/\/vladislavkudriashev23.thkit.ee\/WP\/wp-content\/uploads\/2025\/09\/77F9431F-8E42-48F7-8B57-2114CD223E5D-150x76.png 150w, https:\/\/vladislavkudriashev23.thkit.ee\/WP\/wp-content\/uploads\/2025\/09\/77F9431F-8E42-48F7-8B57-2114CD223E5D-1536x779.png 1536w, https:\/\/vladislavkudriashev23.thkit.ee\/WP\/wp-content\/uploads\/2025\/09\/77F9431F-8E42-48F7-8B57-2114CD223E5D.png 1543w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li>Loome andmebaas.<\/li>\n<\/ol>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:clamp(16px, 1rem, 24px);font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#e1e4e8;--cbp-line-number-width:calc(1 * 0.6 * 1rem);line-height:clamp(20px, 1.25rem, 30px);--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:flex;align-items:center;padding:10px 0px 10px 16px;margin-bottom:-2px;width:100%;text-align:left;background-color:#2f363c;color:#d3d7dd\">SQL<\/span><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>CREATE DATABASE XMLReis<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F97583\">CREATE<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">DATABASE<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">XMLReis<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li>Kasutame andmebaas<\/li>\n<\/ol>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:clamp(16px, 1rem, 24px);font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#e1e4e8;--cbp-line-number-width:calc(1 * 0.6 * 1rem);line-height:clamp(20px, 1.25rem, 30px);--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:flex;align-items:center;padding:10px 0px 10px 16px;margin-bottom:-2px;width:100%;text-align:left;background-color:#2f363c;color:#d3d7dd\">SQL<\/span><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>USE XMLReis<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F97583\">USE<\/span><span style=\"color: #E1E4E8\"> XMLReis<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<ol start=\"4\" class=\"wp-block-list\">\n<li>Loome tabel<\/li>\n<\/ol>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:clamp(16px, 1rem, 24px);font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#e1e4e8;--cbp-line-number-width:calc(2 * 0.6 * 1rem);line-height:clamp(20px, 1.25rem, 30px);--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:flex;align-items:center;padding:10px 0px 10px 16px;margin-bottom:-2px;width:100%;text-align:left;background-color:#2f363c;color:#d3d7dd\">SQL<\/span><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>create table MOCK_DATA (\n\ttrip_id INT,\n\tdeparture_airport VARCHAR(100),\n\tarrival_airport VARCHAR(100),\n\tdeparture_date DATE,\n\tarrival_date DATE,\n\ttransport_type VARCHAR(5),\n\tdistance_km DECIMAL(7,2),\n\tduration_hours DECIMAL(4,2),\n\tpassenger_count INT,\n\tairline_name VARCHAR(50),\n\tticket_price DECIMAL(6,2)\n);\ninsert into MOCK_DATA (trip_id, departure_airport, arrival_airport, departure_date, arrival_date, transport_type, distance_km, duration_hours, passenger_count, airline_name, ticket_price) values (1, 'Alexandria Homestead Airport', 'Dos Lagunas Airport', '4\/13\/2022', '9\/22\/2022', 'train', 4811.95, 3.98, 1, 'Lazz', 932.92);\ninsert into MOCK_DATA (trip_id, departure_airport, arrival_airport, departure_date, arrival_date, transport_type, distance_km, duration_hours, passenger_count, airline_name, ticket_price) values (2, 'Telegraph Harbour Seaplane Base', 'Luxembourg-Findel International Airport', '7\/28\/2022', '3\/1\/2022', 'plane', 4855.23, 5.94, 8, 'Fatz', 559.84);\ninsert into MOCK_DATA (trip_id, departure_airport, arrival_airport, departure_date, arrival_date, transport_type, distance_km, duration_hours, passenger_count, airline_name, ticket_price) values (3, 'Santa Rosa Airport', 'Licenciado Gustavo D\u00edaz Ordaz International Airport', '3\/8\/2022', '5\/17\/2022', 'train', 3974.36, 12.77, 8, 'Bubblebox', 441.21);\ninsert into MOCK_DATA (trip_id, departure_airport, arrival_airport, departure_date, arrival_date, transport_type, distance_km, duration_hours, passenger_count, airline_name, ticket_price) values (4, 'H\u00f3lmav\u00edk Airport', 'Karl Stefan Memorial Airport', '3\/31\/2022', '1\/30\/2022', 'car', 4156.16, 2.57, 8, 'Geba', 386.47);\ninsert into MOCK_DATA (trip_id, departure_airport, arrival_airport, departure_date, arrival_date, transport_type, distance_km, duration_hours, passenger_count, airline_name, ticket_price) values (5, 'Mustique Airport', 'Juanda International Airport', '11\/20\/2022', '9\/20\/2022', 'plane', 2584.44, 4.91, 5, 'Quaxo', 247.13);\ninsert into MOCK_DATA (trip_id, departure_airport, arrival_airport, departure_date, arrival_date, transport_type, distance_km, duration_hours, passenger_count, airline_name, ticket_price) values (6, 'Creston Valley Regional Airport - Art Sutcliffe Field', 'Los Alamos Airport', '7\/11\/2022', '2\/19\/2022', 'plane', 6000.88, 18.62, 10, 'Feedspan', 225.28);\ninsert into MOCK_DATA (trip_id, departure_airport, arrival_airport, departure_date, arrival_date, transport_type, distance_km, duration_hours, passenger_count, airline_name, ticket_price) values (7, 'Mong Hsat Airport', 'Tsumeb Airport', '8\/13\/2022', '11\/25\/2022', 'train', 502.29, 18.17, 8, 'Jabbersphere', 496.07);\ninsert into MOCK_DATA (trip_id, departure_airport, arrival_airport, departure_date, arrival_date, transport_type, distance_km, duration_hours, passenger_count, airline_name, ticket_price) values (8, 'Tuscaloosa Regional Airport', 'Juan Mendoza Airport', '7\/8\/2022', '7\/11\/2022', 'car', 4911.61, 13.43, 5, 'Mudo', 617.61);\ninsert into MOCK_DATA (trip_id, departure_airport, arrival_airport, departure_date, arrival_date, transport_type, distance_km, duration_hours, passenger_count, airline_name, ticket_price) values (9, 'Chicago Rockford International Airport', 'Negage Airport', '12\/23\/2022', '11\/2\/2022', 'plane', 8447.41, 1.04, 6, 'Ntags', 173.12);\ninsert into MOCK_DATA (trip_id, departure_airport, arrival_airport, departure_date, arrival_date, transport_type, distance_km, duration_hours, passenger_count, airline_name, ticket_price) values (10, 'Tekin Airport', 'Kashechewan Airport', '8\/6\/2022', '9\/14\/2022', 'car', 3586.65, 13.62, 3, 'Skimia', 568.61);\ninsert into MOCK_DATA (trip_id, departure_airport, arrival_airport, departure_date, arrival_date, transport_type, distance_km, duration_hours, passenger_count, airline_name, ticket_price) values (11, 'Kunua Airport', 'Diavik Airport', '3\/9\/2022', '9\/30\/2022', 'train', 2103.32, 11.9, 4, 'Cogibox', 862.38);\ninsert into MOCK_DATA (trip_id, departure_airport, arrival_airport, departure_date, arrival_date, transport_type, distance_km, duration_hours, passenger_count, airline_name, ticket_price) values (12, 'Benito Salas Airport', 'Mid Delta Regional Airport', '8\/30\/2022', '3\/9\/2022', 'plane', 8780.32, 1.58, 1, 'Brainsphere', 334.21);\ninsert into MOCK_DATA (trip_id, departure_airport, arrival_airport, departure_date, arrival_date, transport_type, distance_km, duration_hours, passenger_count, airline_name, ticket_price) values (13, 'Mission Field', 'Fazenda Barra do Agudo Airport', '1\/5\/2022', '7\/30\/2022', 'car', 2792.03, 23.51, 10, 'Zazio', 669.13);\ninsert into MOCK_DATA (trip_id, departure_airport, arrival_airport, departure_date, arrival_date, transport_type, distance_km, duration_hours, passenger_count, airline_name, ticket_price) values (14, 'Palanga International Airport', 'Kingaroy Airport', '11\/20\/2022', '7\/11\/2022', 'train', 9145.35, 8.08, 9, 'Yadel', 397.22);\ninsert into MOCK_DATA (trip_id, departure_airport, arrival_airport, departure_date, arrival_date, transport_type, distance_km, duration_hours, passenger_count, airline_name, ticket_price) values (15, 'Three Rivers Municipal Dr Haines Airport', 'Skagit Regional Airport', '2\/8\/2022', '11\/14\/2022', 'car', 2709.62, 3.75, 4, 'Quinu', 388.82);\ninsert into MOCK_DATA (trip_id, departure_airport, arrival_airport, departure_date, arrival_date, transport_type, distance_km, duration_hours, passenger_count, airline_name, ticket_price) values (16, 'Luang Phabang International Airport', 'Sardar-e-Jangal Airport', '4\/3\/2022', '3\/28\/2022', 'train', 9360.4, 16.72, 4, 'Babbleblab', 838.25);\ninsert into MOCK_DATA (trip_id, departure_airport, arrival_airport, departure_date, arrival_date, transport_type, distance_km, duration_hours, passenger_count, airline_name, ticket_price) values (17, 'Cuneo International Airport', 'Qazvin Airport', '1\/21\/2022', '11\/15\/2022', 'car', 8154.86, 19.39, 1, 'Flipstorm', 283.49);\ninsert into MOCK_DATA (trip_id, departure_airport, arrival_airport, departure_date, arrival_date, transport_type, distance_km, duration_hours, passenger_count, airline_name, ticket_price) values (18, 'Hato International Airport', 'Cotswold Airport', '11\/12\/2022', '12\/1\/2022', 'plane', 135.19, 10.61, 5, 'Skivee', 785.84);\ninsert into MOCK_DATA (trip_id, departure_airport, arrival_airport, departure_date, arrival_date, transport_type, distance_km, duration_hours, passenger_count, airline_name, ticket_price) values (19, 'Londolozi Airport', 'Croydon Airport', '6\/2\/2022', '1\/29\/2022', 'train', 6185.03, 1.08, 2, 'Realbridge', 697.2);\ninsert into MOCK_DATA (trip_id, departure_airport, arrival_airport, departure_date, arrival_date, transport_type, distance_km, duration_hours, passenger_count, airline_name, ticket_price) values (20, 'Tel\u00eamaco Borba Airport', 'Dabo Airport', '1\/21\/2022', '4\/16\/2022', 'plane', 3150.76, 10.58, 2, 'Kwilith', 722.22);\ninsert into MOCK_DATA (trip_id, departure_airport, arrival_airport, departure_date, arrival_date, transport_type, distance_km, duration_hours, passenger_count, airline_name, ticket_price) values (21, 'Travis Air Force Base', 'Mitchell Municipal Airport', '10\/30\/2022', '8\/24\/2022', 'train', 7339.92, 8.88, 2, 'Quinu', 955.13);\ninsert into MOCK_DATA (trip_id, departure_airport, arrival_airport, departure_date, arrival_date, transport_type, distance_km, duration_hours, passenger_count, airline_name, ticket_price) values (22, 'Ames Municipal Airport', 'Ganzhou Airport', '8\/22\/2022', '6\/7\/2022', 'train', 5033.51, 10.68, 10, 'Thoughtsphere', 215.02);\ninsert into MOCK_DATA (trip_id, departure_airport, arrival_airport, departure_date, arrival_date, transport_type, distance_km, duration_hours, passenger_count, airline_name, ticket_price) values (23, 'Leaf Rapids Airport', 'Kasompe Airport', '6\/27\/2022', '7\/3\/2022', 'car', 510.21, 12.15, 8, 'Aivee', 398.0);\ninsert into MOCK_DATA (trip_id, departure_airport, arrival_airport, departure_date, arrival_date, transport_type, distance_km, duration_hours, passenger_count, airline_name, ticket_price) values (24, 'Serui Airport', 'Bakkafj\u00f6r\u00f0ur Airport', '5\/22\/2022', '6\/17\/2022', 'train', 1605.65, 2.45, 3, 'Babbleset', 303.6);\ninsert into MOCK_DATA (trip_id, departure_airport, arrival_airport, departure_date, arrival_date, transport_type, distance_km, duration_hours, passenger_count, airline_name, ticket_price) values (25, 'Miraflores Airport', 'Awar Airport', '3\/2\/2022', '4\/4\/2022', 'plane', 2064.85, 4.39, 8, 'Flashset', 604.79);\ninsert into MOCK_DATA (trip_id, departure_airport, arrival_airport, departure_date, arrival_date, transport_type, distance_km, duration_hours, passenger_count, airline_name, ticket_price) values (26, 'Mayaguana Airport', 'Dongsha Island Airport', '7\/15\/2022', '1\/27\/2022', 'train', 2709.21, 0.17, 10, 'Dabshots', 280.29);\ninsert into MOCK_DATA (trip_id, departure_airport, arrival_airport, departure_date, arrival_date, transport_type, distance_km, duration_hours, passenger_count, airline_name, ticket_price) values (27, 'Cambridge Dorchester Airport', 'Eduardo Gomes International Airport', '11\/3\/2022', '7\/8\/2022', 'car', 8402.5, 9.32, 8, 'Bubblebox', 530.97);\ninsert into MOCK_DATA (trip_id, departure_airport, arrival_airport, departure_date, arrival_date, transport_type, distance_km, duration_hours, passenger_count, airline_name, ticket_price) values (28, 'Vung Tau Airport', 'Dimmit County Airport', '11\/20\/2022', '10\/1\/2022', 'train', 5183.67, 7.66, 9, 'Browsebug', 300.43);\ninsert into MOCK_DATA (trip_id, departure_airport, arrival_airport, departure_date, arrival_date, transport_type, distance_km, duration_hours, passenger_count, airline_name, ticket_price) values (29, 'Vanua Balavu Airport', 'Gush Katif Airport', '4\/18\/2022', '11\/26\/2022', 'car', 2566.6, 20.6, 1, 'Rhynyx', 435.12);\ninsert into MOCK_DATA (trip_id, departure_airport, arrival_airport, departure_date, arrival_date, transport_type, distance_km, duration_hours, passenger_count, airline_name, ticket_price) values (30, 'Lusambo Airport', 'Tocumwal Airport', '1\/16\/2022', '9\/15\/2022', 'car', 4101.41, 3.54, 4, 'Gigashots', 81.45);<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F97583\">create<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">table<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">MOCK_DATA<\/span><span style=\"color: #E1E4E8\"> (<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">\ttrip_id <\/span><span style=\"color: #F97583\">INT<\/span><span style=\"color: #E1E4E8\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">\tdeparture_airport <\/span><span style=\"color: #F97583\">VARCHAR<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #79B8FF\">100<\/span><span style=\"color: #E1E4E8\">),<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">\tarrival_airport <\/span><span style=\"color: #F97583\">VARCHAR<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #79B8FF\">100<\/span><span style=\"color: #E1E4E8\">),<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">\tdeparture_date <\/span><span style=\"color: #F97583\">DATE<\/span><span style=\"color: #E1E4E8\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">\tarrival_date <\/span><span style=\"color: #F97583\">DATE<\/span><span style=\"color: #E1E4E8\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">\ttransport_type <\/span><span style=\"color: #F97583\">VARCHAR<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #79B8FF\">5<\/span><span style=\"color: #E1E4E8\">),<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">\tdistance_km <\/span><span style=\"color: #F97583\">DECIMAL<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #79B8FF\">7<\/span><span style=\"color: #E1E4E8\">,<\/span><span style=\"color: #79B8FF\">2<\/span><span style=\"color: #E1E4E8\">),<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">\tduration_hours <\/span><span style=\"color: #F97583\">DECIMAL<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #79B8FF\">4<\/span><span style=\"color: #E1E4E8\">,<\/span><span style=\"color: #79B8FF\">2<\/span><span style=\"color: #E1E4E8\">),<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">\tpassenger_count <\/span><span style=\"color: #F97583\">INT<\/span><span style=\"color: #E1E4E8\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">\tairline_name <\/span><span style=\"color: #F97583\">VARCHAR<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #79B8FF\">50<\/span><span style=\"color: #E1E4E8\">),<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">\tticket_price <\/span><span style=\"color: #F97583\">DECIMAL<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #79B8FF\">6<\/span><span style=\"color: #E1E4E8\">,<\/span><span style=\"color: #79B8FF\">2<\/span><span style=\"color: #E1E4E8\">)<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">insert into<\/span><span style=\"color: #E1E4E8\"> MOCK_DATA (trip_id, departure_airport, arrival_airport, departure_date, arrival_date, transport_type, distance_km, duration_hours, passenger_count, airline_name, ticket_price) <\/span><span style=\"color: #F97583\">values<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #79B8FF\">1<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Alexandria Homestead Airport&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Dos Lagunas Airport&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;4\/13\/2022&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;9\/22\/2022&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;train&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">4811<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">95<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">3<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">98<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">1<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Lazz&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">932<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">92<\/span><span style=\"color: #E1E4E8\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">insert into<\/span><span style=\"color: #E1E4E8\"> MOCK_DATA (trip_id, departure_airport, arrival_airport, departure_date, arrival_date, transport_type, distance_km, duration_hours, passenger_count, airline_name, ticket_price) <\/span><span style=\"color: #F97583\">values<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #79B8FF\">2<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Telegraph Harbour Seaplane Base&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Luxembourg-Findel International Airport&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;7\/28\/2022&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;3\/1\/2022&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;plane&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">4855<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">23<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">5<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">94<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">8<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Fatz&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">559<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">84<\/span><span style=\"color: #E1E4E8\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">insert into<\/span><span style=\"color: #E1E4E8\"> MOCK_DATA (trip_id, departure_airport, arrival_airport, departure_date, arrival_date, transport_type, distance_km, duration_hours, passenger_count, airline_name, ticket_price) <\/span><span style=\"color: #F97583\">values<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #79B8FF\">3<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Santa Rosa Airport&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Licenciado Gustavo D\u00edaz Ordaz International Airport&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;3\/8\/2022&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;5\/17\/2022&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;train&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">3974<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">36<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">12<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">77<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">8<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Bubblebox&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">441<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">21<\/span><span style=\"color: #E1E4E8\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">insert into<\/span><span style=\"color: #E1E4E8\"> MOCK_DATA (trip_id, departure_airport, arrival_airport, departure_date, arrival_date, transport_type, distance_km, duration_hours, passenger_count, airline_name, ticket_price) <\/span><span style=\"color: #F97583\">values<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #79B8FF\">4<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;H\u00f3lmav\u00edk Airport&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Karl Stefan Memorial Airport&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;3\/31\/2022&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;1\/30\/2022&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;car&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">4156<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">16<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">2<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">57<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">8<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Geba&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">386<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">47<\/span><span style=\"color: #E1E4E8\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">insert into<\/span><span style=\"color: #E1E4E8\"> MOCK_DATA (trip_id, departure_airport, arrival_airport, departure_date, arrival_date, transport_type, distance_km, duration_hours, passenger_count, airline_name, ticket_price) <\/span><span style=\"color: #F97583\">values<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #79B8FF\">5<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Mustique Airport&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Juanda International Airport&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;11\/20\/2022&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;9\/20\/2022&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;plane&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">2584<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">44<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">4<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">91<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">5<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Quaxo&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">247<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">13<\/span><span style=\"color: #E1E4E8\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">insert into<\/span><span style=\"color: #E1E4E8\"> MOCK_DATA (trip_id, departure_airport, arrival_airport, departure_date, arrival_date, transport_type, distance_km, duration_hours, passenger_count, airline_name, ticket_price) <\/span><span style=\"color: #F97583\">values<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #79B8FF\">6<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Creston Valley Regional Airport - Art Sutcliffe Field&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Los Alamos Airport&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;7\/11\/2022&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;2\/19\/2022&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;plane&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">6000<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">88<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">18<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">62<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">10<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Feedspan&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">225<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">28<\/span><span style=\"color: #E1E4E8\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">insert into<\/span><span style=\"color: #E1E4E8\"> MOCK_DATA (trip_id, departure_airport, arrival_airport, departure_date, arrival_date, transport_type, distance_km, duration_hours, passenger_count, airline_name, ticket_price) <\/span><span style=\"color: #F97583\">values<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #79B8FF\">7<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Mong Hsat Airport&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Tsumeb Airport&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;8\/13\/2022&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;11\/25\/2022&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;train&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">502<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">29<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">18<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">17<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">8<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Jabbersphere&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">496<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">07<\/span><span style=\"color: #E1E4E8\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">insert into<\/span><span style=\"color: #E1E4E8\"> MOCK_DATA (trip_id, departure_airport, arrival_airport, departure_date, arrival_date, transport_type, distance_km, duration_hours, passenger_count, airline_name, ticket_price) <\/span><span style=\"color: #F97583\">values<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #79B8FF\">8<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Tuscaloosa Regional Airport&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Juan Mendoza Airport&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;7\/8\/2022&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;7\/11\/2022&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;car&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">4911<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">61<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">13<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">43<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">5<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Mudo&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">617<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">61<\/span><span style=\"color: #E1E4E8\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">insert into<\/span><span style=\"color: #E1E4E8\"> MOCK_DATA (trip_id, departure_airport, arrival_airport, departure_date, arrival_date, transport_type, distance_km, duration_hours, passenger_count, airline_name, ticket_price) <\/span><span style=\"color: #F97583\">values<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #79B8FF\">9<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Chicago Rockford International Airport&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Negage Airport&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;12\/23\/2022&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;11\/2\/2022&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;plane&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">8447<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">41<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">1<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">04<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">6<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Ntags&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">173<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">12<\/span><span style=\"color: #E1E4E8\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">insert into<\/span><span style=\"color: #E1E4E8\"> MOCK_DATA (trip_id, departure_airport, arrival_airport, departure_date, arrival_date, transport_type, distance_km, duration_hours, passenger_count, airline_name, ticket_price) <\/span><span style=\"color: #F97583\">values<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #79B8FF\">10<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Tekin Airport&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Kashechewan Airport&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;8\/6\/2022&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;9\/14\/2022&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;car&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">3586<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">65<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">13<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">62<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">3<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Skimia&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">568<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">61<\/span><span style=\"color: #E1E4E8\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">insert into<\/span><span style=\"color: #E1E4E8\"> MOCK_DATA (trip_id, departure_airport, arrival_airport, departure_date, arrival_date, transport_type, distance_km, duration_hours, passenger_count, airline_name, ticket_price) <\/span><span style=\"color: #F97583\">values<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #79B8FF\">11<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Kunua Airport&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Diavik Airport&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;3\/9\/2022&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;9\/30\/2022&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;train&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">2103<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">32<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">11<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">9<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">4<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Cogibox&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">862<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">38<\/span><span style=\"color: #E1E4E8\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">insert into<\/span><span style=\"color: #E1E4E8\"> MOCK_DATA (trip_id, departure_airport, arrival_airport, departure_date, arrival_date, transport_type, distance_km, duration_hours, passenger_count, airline_name, ticket_price) <\/span><span style=\"color: #F97583\">values<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #79B8FF\">12<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Benito Salas Airport&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Mid Delta Regional Airport&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;8\/30\/2022&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;3\/9\/2022&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;plane&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">8780<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">32<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">1<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">58<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">1<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Brainsphere&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">334<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">21<\/span><span style=\"color: #E1E4E8\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">insert into<\/span><span style=\"color: #E1E4E8\"> MOCK_DATA (trip_id, departure_airport, arrival_airport, departure_date, arrival_date, transport_type, distance_km, duration_hours, passenger_count, airline_name, ticket_price) <\/span><span style=\"color: #F97583\">values<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #79B8FF\">13<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Mission Field&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Fazenda Barra do Agudo Airport&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;1\/5\/2022&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;7\/30\/2022&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;car&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">2792<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">03<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">23<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">51<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">10<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Zazio&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">669<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">13<\/span><span style=\"color: #E1E4E8\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">insert into<\/span><span style=\"color: #E1E4E8\"> MOCK_DATA (trip_id, departure_airport, arrival_airport, departure_date, arrival_date, transport_type, distance_km, duration_hours, passenger_count, airline_name, ticket_price) <\/span><span style=\"color: #F97583\">values<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #79B8FF\">14<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Palanga International Airport&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Kingaroy Airport&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;11\/20\/2022&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;7\/11\/2022&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;train&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">9145<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">35<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">8<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">08<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">9<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Yadel&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">397<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">22<\/span><span style=\"color: #E1E4E8\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">insert into<\/span><span style=\"color: #E1E4E8\"> MOCK_DATA (trip_id, departure_airport, arrival_airport, departure_date, arrival_date, transport_type, distance_km, duration_hours, passenger_count, airline_name, ticket_price) <\/span><span style=\"color: #F97583\">values<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #79B8FF\">15<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Three Rivers Municipal Dr Haines Airport&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Skagit Regional Airport&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;2\/8\/2022&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;11\/14\/2022&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;car&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">2709<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">62<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">3<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">75<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">4<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Quinu&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">388<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">82<\/span><span style=\"color: #E1E4E8\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">insert into<\/span><span style=\"color: #E1E4E8\"> MOCK_DATA (trip_id, departure_airport, arrival_airport, departure_date, arrival_date, transport_type, distance_km, duration_hours, passenger_count, airline_name, ticket_price) <\/span><span style=\"color: #F97583\">values<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #79B8FF\">16<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Luang Phabang International Airport&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Sardar-e-Jangal Airport&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;4\/3\/2022&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;3\/28\/2022&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;train&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">9360<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">4<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">16<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">72<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">4<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Babbleblab&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">838<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">25<\/span><span style=\"color: #E1E4E8\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">insert into<\/span><span style=\"color: #E1E4E8\"> MOCK_DATA (trip_id, departure_airport, arrival_airport, departure_date, arrival_date, transport_type, distance_km, duration_hours, passenger_count, airline_name, ticket_price) <\/span><span style=\"color: #F97583\">values<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #79B8FF\">17<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Cuneo International Airport&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Qazvin Airport&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;1\/21\/2022&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;11\/15\/2022&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;car&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">8154<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">86<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">19<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">39<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">1<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Flipstorm&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">283<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">49<\/span><span style=\"color: #E1E4E8\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">insert into<\/span><span style=\"color: #E1E4E8\"> MOCK_DATA (trip_id, departure_airport, arrival_airport, departure_date, arrival_date, transport_type, distance_km, duration_hours, passenger_count, airline_name, ticket_price) <\/span><span style=\"color: #F97583\">values<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #79B8FF\">18<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Hato International Airport&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Cotswold Airport&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;11\/12\/2022&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;12\/1\/2022&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;plane&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">135<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">19<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">10<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">61<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">5<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Skivee&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">785<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">84<\/span><span style=\"color: #E1E4E8\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">insert into<\/span><span style=\"color: #E1E4E8\"> MOCK_DATA (trip_id, departure_airport, arrival_airport, departure_date, arrival_date, transport_type, distance_km, duration_hours, passenger_count, airline_name, ticket_price) <\/span><span style=\"color: #F97583\">values<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #79B8FF\">19<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Londolozi Airport&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Croydon Airport&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;6\/2\/2022&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;1\/29\/2022&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;train&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">6185<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">03<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">1<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">08<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">2<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Realbridge&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">697<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">2<\/span><span style=\"color: #E1E4E8\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">insert into<\/span><span style=\"color: #E1E4E8\"> MOCK_DATA (trip_id, departure_airport, arrival_airport, departure_date, arrival_date, transport_type, distance_km, duration_hours, passenger_count, airline_name, ticket_price) <\/span><span style=\"color: #F97583\">values<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #79B8FF\">20<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Tel\u00eamaco Borba Airport&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Dabo Airport&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;1\/21\/2022&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;4\/16\/2022&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;plane&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">3150<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">76<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">10<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">58<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">2<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Kwilith&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">722<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">22<\/span><span style=\"color: #E1E4E8\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">insert into<\/span><span style=\"color: #E1E4E8\"> MOCK_DATA (trip_id, departure_airport, arrival_airport, departure_date, arrival_date, transport_type, distance_km, duration_hours, passenger_count, airline_name, ticket_price) <\/span><span style=\"color: #F97583\">values<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #79B8FF\">21<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Travis Air Force Base&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Mitchell Municipal Airport&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;10\/30\/2022&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;8\/24\/2022&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;train&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">7339<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">92<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">8<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">88<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">2<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Quinu&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">955<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">13<\/span><span style=\"color: #E1E4E8\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">insert into<\/span><span style=\"color: #E1E4E8\"> MOCK_DATA (trip_id, departure_airport, arrival_airport, departure_date, arrival_date, transport_type, distance_km, duration_hours, passenger_count, airline_name, ticket_price) <\/span><span style=\"color: #F97583\">values<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #79B8FF\">22<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Ames Municipal Airport&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Ganzhou Airport&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;8\/22\/2022&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;6\/7\/2022&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;train&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">5033<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">51<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">10<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">68<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">10<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Thoughtsphere&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">215<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">02<\/span><span style=\"color: #E1E4E8\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">insert into<\/span><span style=\"color: #E1E4E8\"> MOCK_DATA (trip_id, departure_airport, arrival_airport, departure_date, arrival_date, transport_type, distance_km, duration_hours, passenger_count, airline_name, ticket_price) <\/span><span style=\"color: #F97583\">values<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #79B8FF\">23<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Leaf Rapids Airport&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Kasompe Airport&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;6\/27\/2022&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;7\/3\/2022&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;car&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">510<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">21<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">12<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">15<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">8<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Aivee&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">398<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">0<\/span><span style=\"color: #E1E4E8\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">insert into<\/span><span style=\"color: #E1E4E8\"> MOCK_DATA (trip_id, departure_airport, arrival_airport, departure_date, arrival_date, transport_type, distance_km, duration_hours, passenger_count, airline_name, ticket_price) <\/span><span style=\"color: #F97583\">values<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #79B8FF\">24<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Serui Airport&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Bakkafj\u00f6r\u00f0ur Airport&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;5\/22\/2022&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;6\/17\/2022&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;train&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">1605<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">65<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">2<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">45<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">3<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Babbleset&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">303<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">6<\/span><span style=\"color: #E1E4E8\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">insert into<\/span><span style=\"color: #E1E4E8\"> MOCK_DATA (trip_id, departure_airport, arrival_airport, departure_date, arrival_date, transport_type, distance_km, duration_hours, passenger_count, airline_name, ticket_price) <\/span><span style=\"color: #F97583\">values<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #79B8FF\">25<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Miraflores Airport&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Awar Airport&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;3\/2\/2022&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;4\/4\/2022&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;plane&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">2064<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">85<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">4<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">39<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">8<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Flashset&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">604<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">79<\/span><span style=\"color: #E1E4E8\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">insert into<\/span><span style=\"color: #E1E4E8\"> MOCK_DATA (trip_id, departure_airport, arrival_airport, departure_date, arrival_date, transport_type, distance_km, duration_hours, passenger_count, airline_name, ticket_price) <\/span><span style=\"color: #F97583\">values<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #79B8FF\">26<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Mayaguana Airport&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Dongsha Island Airport&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;7\/15\/2022&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;1\/27\/2022&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;train&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">2709<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">21<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">0<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">17<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">10<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Dabshots&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">280<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">29<\/span><span style=\"color: #E1E4E8\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">insert into<\/span><span style=\"color: #E1E4E8\"> MOCK_DATA (trip_id, departure_airport, arrival_airport, departure_date, arrival_date, transport_type, distance_km, duration_hours, passenger_count, airline_name, ticket_price) <\/span><span style=\"color: #F97583\">values<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #79B8FF\">27<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Cambridge Dorchester Airport&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Eduardo Gomes International Airport&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;11\/3\/2022&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;7\/8\/2022&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;car&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">8402<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">5<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">9<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">32<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">8<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Bubblebox&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">530<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">97<\/span><span style=\"color: #E1E4E8\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">insert into<\/span><span style=\"color: #E1E4E8\"> MOCK_DATA (trip_id, departure_airport, arrival_airport, departure_date, arrival_date, transport_type, distance_km, duration_hours, passenger_count, airline_name, ticket_price) <\/span><span style=\"color: #F97583\">values<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #79B8FF\">28<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Vung Tau Airport&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Dimmit County Airport&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;11\/20\/2022&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;10\/1\/2022&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;train&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">5183<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">67<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">7<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">66<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">9<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Browsebug&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">300<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">43<\/span><span style=\"color: #E1E4E8\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">insert into<\/span><span style=\"color: #E1E4E8\"> MOCK_DATA (trip_id, departure_airport, arrival_airport, departure_date, arrival_date, transport_type, distance_km, duration_hours, passenger_count, airline_name, ticket_price) <\/span><span style=\"color: #F97583\">values<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #79B8FF\">29<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Vanua Balavu Airport&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Gush Katif Airport&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;4\/18\/2022&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;11\/26\/2022&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;car&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">2566<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">6<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">20<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">6<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">1<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Rhynyx&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">435<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">12<\/span><span style=\"color: #E1E4E8\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">insert into<\/span><span style=\"color: #E1E4E8\"> MOCK_DATA (trip_id, departure_airport, arrival_airport, departure_date, arrival_date, transport_type, distance_km, duration_hours, passenger_count, airline_name, ticket_price) <\/span><span style=\"color: #F97583\">values<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #79B8FF\">30<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Lusambo Airport&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Tocumwal Airport&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;1\/16\/2022&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;9\/15\/2022&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;car&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">4101<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">41<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">3<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">54<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">4<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Gigashots&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">81<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">45<\/span><span style=\"color: #E1E4E8\">);<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<ol start=\"5\" class=\"wp-block-list\">\n<li>Loome SELECT p\u00e4ring<\/li>\n<\/ol>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:clamp(16px, 1rem, 24px);font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#e1e4e8;--cbp-line-number-width:calc(2 * 0.6 * 1rem);line-height:clamp(20px, 1.25rem, 30px);--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:flex;align-items:center;padding:10px 0px 10px 16px;margin-bottom:-2px;width:100%;text-align:left;background-color:#2f363c;color:#d3d7dd\">SQL<\/span><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>SELECT \n    'Reisid' AS Root, \n    (\n        SELECT \n            trip_id AS 'reis_id',\n            (\n                SELECT \n                    departure_airport AS 'V\u00e4ljumis_lennujaam', \n                    arrival_airport AS 'S\u00f5idukoha_lennujaam'\n                FOR XML PATH('Lennujaamad'), TYPE\n            ),\n            (\n                SELECT \n                    transport_type AS 'Transpordi_liik',\n                    distance_km AS 'Kaugus_km',\n                    duration_hours AS 'Kestus_tunnid',\n                    passenger_count AS 'Reisijate_arv',\n                    airline_name AS 'Lennufirma_nimi',\n                    ticket_price AS 'Piletihind'\n                FOR XML PATH('Andmed'), TYPE\n            )\n        FROM MOCK_DATA\n        FOR XML PATH('Reis'), TYPE\n    ) AS Reisid\nFOR XML PATH('Reis'), ROOT('Reisid')<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F97583\">SELECT<\/span><span style=\"color: #E1E4E8\"> <\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">    <\/span><span style=\"color: #9ECBFF\">&#39;Reisid&#39;<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">AS<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">Root<\/span><span style=\"color: #E1E4E8\">, <\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">    (<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">        <\/span><span style=\"color: #F97583\">SELECT<\/span><span style=\"color: #E1E4E8\"> <\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">            trip_id <\/span><span style=\"color: #F97583\">AS<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">&#39;reis_id&#39;<\/span><span style=\"color: #E1E4E8\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">            (<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                <\/span><span style=\"color: #F97583\">SELECT<\/span><span style=\"color: #E1E4E8\"> <\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                    departure_airport <\/span><span style=\"color: #F97583\">AS<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">&#39;V\u00e4ljumis_lennujaam&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                    arrival_airport <\/span><span style=\"color: #F97583\">AS<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">&#39;S\u00f5idukoha_lennujaam&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                <\/span><span style=\"color: #F97583\">FOR<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">XML<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">PATH<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #9ECBFF\">&#39;Lennujaamad&#39;<\/span><span style=\"color: #E1E4E8\">), <\/span><span style=\"color: #F97583\">TYPE<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">            ),<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">            (<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                <\/span><span style=\"color: #F97583\">SELECT<\/span><span style=\"color: #E1E4E8\"> <\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                    transport_type <\/span><span style=\"color: #F97583\">AS<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">&#39;Transpordi_liik&#39;<\/span><span style=\"color: #E1E4E8\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                    distance_km <\/span><span style=\"color: #F97583\">AS<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">&#39;Kaugus_km&#39;<\/span><span style=\"color: #E1E4E8\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                    duration_hours <\/span><span style=\"color: #F97583\">AS<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">&#39;Kestus_tunnid&#39;<\/span><span style=\"color: #E1E4E8\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                    passenger_count <\/span><span style=\"color: #F97583\">AS<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">&#39;Reisijate_arv&#39;<\/span><span style=\"color: #E1E4E8\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                    airline_name <\/span><span style=\"color: #F97583\">AS<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">&#39;Lennufirma_nimi&#39;<\/span><span style=\"color: #E1E4E8\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                    ticket_price <\/span><span style=\"color: #F97583\">AS<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">&#39;Piletihind&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                <\/span><span style=\"color: #F97583\">FOR<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">XML<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">PATH<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #9ECBFF\">&#39;Andmed&#39;<\/span><span style=\"color: #E1E4E8\">), <\/span><span style=\"color: #F97583\">TYPE<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">            )<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">        <\/span><span style=\"color: #F97583\">FROM<\/span><span style=\"color: #E1E4E8\"> MOCK_DATA<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">        <\/span><span style=\"color: #F97583\">FOR<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">XML<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">PATH<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #9ECBFF\">&#39;Reis&#39;<\/span><span style=\"color: #E1E4E8\">), <\/span><span style=\"color: #F97583\">TYPE<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">    ) <\/span><span style=\"color: #F97583\">AS<\/span><span style=\"color: #E1E4E8\"> Reisid<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">FOR<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">XML<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">PATH<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #9ECBFF\">&#39;Reis&#39;<\/span><span style=\"color: #E1E4E8\">), <\/span><span style=\"color: #F97583\">ROOT<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #9ECBFF\">&#39;Reisid&#39;<\/span><span style=\"color: #E1E4E8\">)<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<ol start=\"6\" class=\"wp-block-list\">\n<li>C# kood<\/li>\n<\/ol>\n\n\n\n<p>Funktsioon GetXmlFromQuery loob \u00fchenduse SQL Serveri andmebaasiga nimega XMLReis.<\/p>\n\n\n\n<p>Seej\u00e4rel k\u00e4ivitab see SQL-p\u00e4ringu, mis teisendab MOCK_DATA tabeli andmed XML-vormingusse.<\/p>\n\n\n\n<p>OnGet meetod v\u00f5tab andmebaasist saadud XML-i ja rakendab sellele Reisid.xslt failis m\u00e4\u00e4ratletud XSLT teisenduse.<\/p>\n\n\n\n<p>Teisendatud XML salvestatakse TransformedXml atribuuti, mis kuvatakse veebilehel.<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:clamp(16px, 1rem, 24px);font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#e1e4e8;--cbp-line-number-width:calc(3 * 0.6 * 1rem);line-height:clamp(20px, 1.25rem, 30px);--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:flex;align-items:center;padding:10px 0px 10px 16px;margin-bottom:-2px;width:100%;text-align:left;background-color:#2f363c;color:#d3d7dd\">C#<\/span><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>using Microsoft.AspNetCore.Mvc;\nusing Microsoft.AspNetCore.Mvc.RazorPages;\nusing Microsoft.Data.SqlClient;\nusing System.Text;\nusing System.Xml;\nusing System.Xml.Xsl;\n\nnamespace XML_Reis.Pages\n{\n    public class IndexModel : PageModel\n    {\n        public string TransformedXml { get; private set; }\n\n        private readonly IWebHostEnvironment _hostingEnvironment;\n\n        public IndexModel(IWebHostEnvironment hostingEnvironment)\n        {\n            _hostingEnvironment = hostingEnvironment;\n        }\n\n        public void OnGet()\n        {\n            try\n            {\n                var xml = GetXmlFromQuery();\n                var xsltPath = Path.Combine(_hostingEnvironment.ContentRootPath, \"wwwroot\", \"Reisid.xslt\");\n\n                var xslt = new XslCompiledTransform();\n                xslt.Load(xsltPath);\n\n                using (var stringReader = new StringReader(xml))\n                using (var xmlReader = XmlReader.Create(stringReader))\n                using (var sw = new StringWriter())\n                {\n                    xslt.Transform(xmlReader, null, sw);\n                    TransformedXml = sw.ToString();\n                }\n            }\n            catch (Exception e)\n            {\n                Console.WriteLine(e);\n            }\n        }\n\n        public static string GetXmlFromQuery()\n        {\n            string connectionString = \"Server=(localdb)\\\\MSSQLLocalDB;Database=XMLReis;\";\n\n            string queryString = @\"\n            SELECT \n                'Reisid' AS Root, \n                (\n                    SELECT \n                        trip_id AS 'reis_id',\n                        (\n                            SELECT \n                                departure_airport AS 'V\u00e4ljumis_lennujaam', \n                                arrival_airport AS 'S\u00f5idukoha_lennujaam'\n                            FOR XML PATH('Lennujaamad'), TYPE\n                        ),\n                        (\n                            SELECT \n                                transport_type AS 'Transpordi_liik',\n                                distance_km AS 'Kaugus_km',\n                                duration_hours AS 'Kestus_tunnid',\n                                passenger_count AS 'Reisijate_arv',\n                                airline_name AS 'Lennufirma_nimi',\n                                ticket_price AS 'Piletihind'\n                            FOR XML PATH('Andmed'), TYPE\n                        )\n                    FROM MOCK_DATA\n                    FOR XML PATH('Reis'), TYPE\n                ) AS Reisid\n            FOR XML PATH('Reis'), ROOT('Reisid')\";\n\n            StringBuilder xmlOutput = new StringBuilder();\n\n            using (SqlConnection connection = new SqlConnection(connectionString))\n            {\n                try\n                {\n                    connection.Open();\n                    using (SqlCommand command = new SqlCommand(queryString, connection))\n                    {\n                        using (XmlReader reader = command.ExecuteXmlReader())\n                        {\n                            while (reader.Read())\n                            {\n                                xmlOutput.Append(reader.ReadOuterXml());\n                            }\n                        }\n                    }\n                }\n                catch (Exception e)\n                {\n                    Console.WriteLine(e);\n                }\n            }\n\n            string xmlResult = xmlOutput.ToString();\n\n            return xmlResult;\n        }\n    }\n}<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F97583\">using<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">Microsoft<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #B392F0\">AspNetCore<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #B392F0\">Mvc<\/span><span style=\"color: #E1E4E8\">;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">using<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">Microsoft<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #B392F0\">AspNetCore<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #B392F0\">Mvc<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #B392F0\">RazorPages<\/span><span style=\"color: #E1E4E8\">;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">using<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">Microsoft<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #B392F0\">Data<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #B392F0\">SqlClient<\/span><span style=\"color: #E1E4E8\">;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">using<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">System<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #B392F0\">Text<\/span><span style=\"color: #E1E4E8\">;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">using<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">System<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #B392F0\">Xml<\/span><span style=\"color: #E1E4E8\">;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">using<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">System<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #B392F0\">Xml<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #B392F0\">Xsl<\/span><span style=\"color: #E1E4E8\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">namespace<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">XML_Reis<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #B392F0\">Pages<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">{<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">    <\/span><span style=\"color: #F97583\">public<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">class<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">IndexModel<\/span><span style=\"color: #E1E4E8\"> : <\/span><span style=\"color: #B392F0\">PageModel<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">    {<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">        <\/span><span style=\"color: #F97583\">public<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">string<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">TransformedXml<\/span><span style=\"color: #E1E4E8\"> { <\/span><span style=\"color: #F97583\">get<\/span><span style=\"color: #E1E4E8\">; <\/span><span style=\"color: #F97583\">private<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">set<\/span><span style=\"color: #E1E4E8\">; }<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">        <\/span><span style=\"color: #F97583\">private<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">readonly<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">IWebHostEnvironment<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">_hostingEnvironment<\/span><span style=\"color: #E1E4E8\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">        <\/span><span style=\"color: #F97583\">public<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">IndexModel<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #B392F0\">IWebHostEnvironment<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">hostingEnvironment<\/span><span style=\"color: #E1E4E8\">)<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">        {<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">            _hostingEnvironment <\/span><span style=\"color: #F97583\">=<\/span><span style=\"color: #E1E4E8\"> hostingEnvironment;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">        }<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">        <\/span><span style=\"color: #F97583\">public<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">void<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">OnGet<\/span><span style=\"color: #E1E4E8\">()<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">        {<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">            <\/span><span style=\"color: #F97583\">try<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">            {<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                <\/span><span style=\"color: #F97583\">var<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">xml<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">=<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">GetXmlFromQuery<\/span><span style=\"color: #E1E4E8\">();<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                <\/span><span style=\"color: #F97583\">var<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">xsltPath<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">=<\/span><span style=\"color: #E1E4E8\"> Path.<\/span><span style=\"color: #B392F0\">Combine<\/span><span style=\"color: #E1E4E8\">(_hostingEnvironment.ContentRootPath, <\/span><span style=\"color: #9ECBFF\">&quot;wwwroot&quot;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&quot;Reisid.xslt&quot;<\/span><span style=\"color: #E1E4E8\">);<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                <\/span><span style=\"color: #F97583\">var<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">xslt<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">=<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">new<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">XslCompiledTransform<\/span><span style=\"color: #E1E4E8\">();<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                xslt.<\/span><span style=\"color: #B392F0\">Load<\/span><span style=\"color: #E1E4E8\">(xsltPath);<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                <\/span><span style=\"color: #F97583\">using<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #F97583\">var<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">stringReader<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">=<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">new<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">StringReader<\/span><span style=\"color: #E1E4E8\">(xml))<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                <\/span><span style=\"color: #F97583\">using<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #F97583\">var<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">xmlReader<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">=<\/span><span style=\"color: #E1E4E8\"> XmlReader.<\/span><span style=\"color: #B392F0\">Create<\/span><span style=\"color: #E1E4E8\">(stringReader))<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                <\/span><span style=\"color: #F97583\">using<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #F97583\">var<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">sw<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">=<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">new<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">StringWriter<\/span><span style=\"color: #E1E4E8\">())<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                {<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                    xslt.<\/span><span style=\"color: #B392F0\">Transform<\/span><span style=\"color: #E1E4E8\">(xmlReader, <\/span><span style=\"color: #79B8FF\">null<\/span><span style=\"color: #E1E4E8\">, sw);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                    TransformedXml <\/span><span style=\"color: #F97583\">=<\/span><span style=\"color: #E1E4E8\"> sw.<\/span><span style=\"color: #B392F0\">ToString<\/span><span style=\"color: #E1E4E8\">();<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                }<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">            }<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">            <\/span><span style=\"color: #F97583\">catch<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #B392F0\">Exception<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">e<\/span><span style=\"color: #E1E4E8\">)<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">            {<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                Console.<\/span><span style=\"color: #B392F0\">WriteLine<\/span><span style=\"color: #E1E4E8\">(e);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">            }<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">        }<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">        <\/span><span style=\"color: #F97583\">public<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">static<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">string<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">GetXmlFromQuery<\/span><span style=\"color: #E1E4E8\">()<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">        {<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">            <\/span><span style=\"color: #F97583\">string<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">connectionString<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">=<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">&quot;Server=(localdb)<\/span><span style=\"color: #79B8FF\">\\\\<\/span><span style=\"color: #9ECBFF\">MSSQLLocalDB;Database=XMLReis;&quot;<\/span><span style=\"color: #E1E4E8\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">            <\/span><span style=\"color: #F97583\">string<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">queryString<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">=<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">@&quot;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #9ECBFF\">            SELECT <\/span><\/span>\n<span class=\"line\"><span style=\"color: #9ECBFF\">                &#39;Reisid&#39; AS Root, <\/span><\/span>\n<span class=\"line\"><span style=\"color: #9ECBFF\">                (<\/span><\/span>\n<span class=\"line\"><span style=\"color: #9ECBFF\">                    SELECT <\/span><\/span>\n<span class=\"line\"><span style=\"color: #9ECBFF\">                        trip_id AS &#39;reis_id&#39;,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #9ECBFF\">                        (<\/span><\/span>\n<span class=\"line\"><span style=\"color: #9ECBFF\">                            SELECT <\/span><\/span>\n<span class=\"line\"><span style=\"color: #9ECBFF\">                                departure_airport AS &#39;V\u00e4ljumis_lennujaam&#39;, <\/span><\/span>\n<span class=\"line\"><span style=\"color: #9ECBFF\">                                arrival_airport AS &#39;S\u00f5idukoha_lennujaam&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #9ECBFF\">                            FOR XML PATH(&#39;Lennujaamad&#39;), TYPE<\/span><\/span>\n<span class=\"line\"><span style=\"color: #9ECBFF\">                        ),<\/span><\/span>\n<span class=\"line\"><span style=\"color: #9ECBFF\">                        (<\/span><\/span>\n<span class=\"line\"><span style=\"color: #9ECBFF\">                            SELECT <\/span><\/span>\n<span class=\"line\"><span style=\"color: #9ECBFF\">                                transport_type AS &#39;Transpordi_liik&#39;,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #9ECBFF\">                                distance_km AS &#39;Kaugus_km&#39;,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #9ECBFF\">                                duration_hours AS &#39;Kestus_tunnid&#39;,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #9ECBFF\">                                passenger_count AS &#39;Reisijate_arv&#39;,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #9ECBFF\">                                airline_name AS &#39;Lennufirma_nimi&#39;,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #9ECBFF\">                                ticket_price AS &#39;Piletihind&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #9ECBFF\">                            FOR XML PATH(&#39;Andmed&#39;), TYPE<\/span><\/span>\n<span class=\"line\"><span style=\"color: #9ECBFF\">                        )<\/span><\/span>\n<span class=\"line\"><span style=\"color: #9ECBFF\">                    FROM MOCK_DATA<\/span><\/span>\n<span class=\"line\"><span style=\"color: #9ECBFF\">                    FOR XML PATH(&#39;Reis&#39;), TYPE<\/span><\/span>\n<span class=\"line\"><span style=\"color: #9ECBFF\">                ) AS Reisid<\/span><\/span>\n<span class=\"line\"><span style=\"color: #9ECBFF\">            FOR XML PATH(&#39;Reis&#39;), ROOT(&#39;Reisid&#39;)&quot;<\/span><span style=\"color: #E1E4E8\">;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">            <\/span><span style=\"color: #B392F0\">StringBuilder<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">xmlOutput<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">=<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">new<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">StringBuilder<\/span><span style=\"color: #E1E4E8\">();<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">            <\/span><span style=\"color: #F97583\">using<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #B392F0\">SqlConnection<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">connection<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">=<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">new<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">SqlConnection<\/span><span style=\"color: #E1E4E8\">(connectionString))<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">            {<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                <\/span><span style=\"color: #F97583\">try<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                {<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                    connection.<\/span><span style=\"color: #B392F0\">Open<\/span><span style=\"color: #E1E4E8\">();<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                    <\/span><span style=\"color: #F97583\">using<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #B392F0\">SqlCommand<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">command<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">=<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">new<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">SqlCommand<\/span><span style=\"color: #E1E4E8\">(queryString, connection))<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                    {<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                        <\/span><span style=\"color: #F97583\">using<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #B392F0\">XmlReader<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">reader<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">=<\/span><span style=\"color: #E1E4E8\"> command.<\/span><span style=\"color: #B392F0\">ExecuteXmlReader<\/span><span style=\"color: #E1E4E8\">())<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                        {<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                            <\/span><span style=\"color: #F97583\">while<\/span><span style=\"color: #E1E4E8\"> (reader.<\/span><span style=\"color: #B392F0\">Read<\/span><span style=\"color: #E1E4E8\">())<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                            {<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                                xmlOutput.<\/span><span style=\"color: #B392F0\">Append<\/span><span style=\"color: #E1E4E8\">(reader.<\/span><span style=\"color: #B392F0\">ReadOuterXml<\/span><span style=\"color: #E1E4E8\">());<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                            }<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                        }<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                    }<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                }<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                <\/span><span style=\"color: #F97583\">catch<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #B392F0\">Exception<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">e<\/span><span style=\"color: #E1E4E8\">)<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                {<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                    Console.<\/span><span style=\"color: #B392F0\">WriteLine<\/span><span style=\"color: #E1E4E8\">(e);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                }<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">            }<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">            <\/span><span style=\"color: #F97583\">string<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">xmlResult<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">=<\/span><span style=\"color: #E1E4E8\"> xmlOutput.<\/span><span style=\"color: #B392F0\">ToString<\/span><span style=\"color: #E1E4E8\">();<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">            <\/span><span style=\"color: #F97583\">return<\/span><span style=\"color: #E1E4E8\"> xmlResult;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">        }<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">    }<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">}<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<figure class=\"wp-block-image size-full wp-duotone-unset-2\"><img loading=\"lazy\" decoding=\"async\" width=\"948\" height=\"890\" src=\"https:\/\/vladislavkudriashev23.thkit.ee\/WP\/wp-content\/uploads\/2025\/09\/8CE145CF-F8E3-463E-A832-B2872B51027C.png\" alt=\"\" class=\"wp-image-2316\" srcset=\"https:\/\/vladislavkudriashev23.thkit.ee\/WP\/wp-content\/uploads\/2025\/09\/8CE145CF-F8E3-463E-A832-B2872B51027C.png 948w, https:\/\/vladislavkudriashev23.thkit.ee\/WP\/wp-content\/uploads\/2025\/09\/8CE145CF-F8E3-463E-A832-B2872B51027C-300x282.png 300w, https:\/\/vladislavkudriashev23.thkit.ee\/WP\/wp-content\/uploads\/2025\/09\/8CE145CF-F8E3-463E-A832-B2872B51027C-768x721.png 768w, https:\/\/vladislavkudriashev23.thkit.ee\/WP\/wp-content\/uploads\/2025\/09\/8CE145CF-F8E3-463E-A832-B2872B51027C-150x141.png 150w\" sizes=\"auto, (max-width: 948px) 100vw, 948px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large wp-duotone-unset-3\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"715\" src=\"https:\/\/vladislavkudriashev23.thkit.ee\/WP\/wp-content\/uploads\/2025\/09\/6529264D-B0F0-4005-8C5B-FE74B2652032-1024x715.png\" alt=\"\" class=\"wp-image-2318\" srcset=\"https:\/\/vladislavkudriashev23.thkit.ee\/WP\/wp-content\/uploads\/2025\/09\/6529264D-B0F0-4005-8C5B-FE74B2652032-1024x715.png 1024w, https:\/\/vladislavkudriashev23.thkit.ee\/WP\/wp-content\/uploads\/2025\/09\/6529264D-B0F0-4005-8C5B-FE74B2652032-300x210.png 300w, https:\/\/vladislavkudriashev23.thkit.ee\/WP\/wp-content\/uploads\/2025\/09\/6529264D-B0F0-4005-8C5B-FE74B2652032-768x537.png 768w, https:\/\/vladislavkudriashev23.thkit.ee\/WP\/wp-content\/uploads\/2025\/09\/6529264D-B0F0-4005-8C5B-FE74B2652032-150x105.png 150w, https:\/\/vladislavkudriashev23.thkit.ee\/WP\/wp-content\/uploads\/2025\/09\/6529264D-B0F0-4005-8C5B-FE74B2652032.png 1337w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ol start=\"7\" class=\"wp-block-list\">\n<li>XML-skeem:<\/li>\n<\/ol>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:clamp(16px, 1rem, 24px);font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#e1e4e8;--cbp-line-number-width:calc(2 * 0.6 * 1rem);line-height:clamp(20px, 1.25rem, 30px);--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:flex;align-items:center;padding:10px 0px 10px 16px;margin-bottom:-2px;width:100%;text-align:left;background-color:#2f363c;color:#d3d7dd\">XML<\/span><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>&lt;?xml version=\"1.0\" encoding=\"utf-8\"?>\n&lt;xs:schema attributeFormDefault=\"unqualified\" elementFormDefault=\"qualified\" xmlns:xs=\"http:\/\/www.w3.org\/2001\/XMLSchema\">\n\t&lt;xs:element name=\"Reisid\">\n\t\t&lt;xs:complexType>\n\t\t\t&lt;xs:sequence>\n\t\t\t\t&lt;xs:element name=\"Reis\">\n\t\t\t\t\t&lt;xs:complexType>\n\t\t\t\t\t\t&lt;xs:sequence>\n\t\t\t\t\t\t\t&lt;xs:element name=\"Root\" type=\"xs:string\" \/>\n\t\t\t\t\t\t\t&lt;xs:element name=\"Reisid\">\n\t\t\t\t\t\t\t\t&lt;xs:complexType>\n\t\t\t\t\t\t\t\t\t&lt;xs:sequence>\n\t\t\t\t\t\t\t\t\t\t&lt;xs:element maxOccurs=\"unbounded\" name=\"Reis\">\n\t\t\t\t\t\t\t\t\t\t\t&lt;xs:complexType>\n\t\t\t\t\t\t\t\t\t\t\t\t&lt;xs:sequence>\n\t\t\t\t\t\t\t\t\t\t\t\t\t&lt;xs:element name=\"reis_id\" type=\"xs:unsignedByte\" \/>\n\t\t\t\t\t\t\t\t\t\t\t\t\t&lt;xs:element name=\"Lennujaamad\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t&lt;xs:complexType>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t&lt;xs:sequence>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t&lt;xs:element name=\"V\u00e4ljumis_lennujaam\" type=\"xs:string\" \/>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t&lt;xs:element name=\"S\u00f5idukoha_lennujaam\" type=\"xs:string\" \/>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t&lt;\/xs:sequence>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t&lt;\/xs:complexType>\n\t\t\t\t\t\t\t\t\t\t\t\t\t&lt;\/xs:element>\n\t\t\t\t\t\t\t\t\t\t\t\t\t&lt;xs:element name=\"Andmed\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t&lt;xs:complexType>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t&lt;xs:sequence>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t&lt;xs:element name=\"Transpordi_liik\" type=\"xs:string\" \/>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t&lt;xs:element name=\"Kaugus_km\" type=\"xs:decimal\" \/>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t&lt;xs:element name=\"Kestus_tunnid\" type=\"xs:decimal\" \/>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t&lt;xs:element name=\"Reisijate_arv\" type=\"xs:unsignedByte\" \/>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t&lt;xs:element name=\"Lennufirma_nimi\" type=\"xs:string\" \/>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t&lt;xs:element name=\"Piletihind\" type=\"xs:decimal\" \/>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t&lt;\/xs:sequence>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t&lt;\/xs:complexType>\n\t\t\t\t\t\t\t\t\t\t\t\t\t&lt;\/xs:element>\n\t\t\t\t\t\t\t\t\t\t\t\t&lt;\/xs:sequence>\n\t\t\t\t\t\t\t\t\t\t\t&lt;\/xs:complexType>\n\t\t\t\t\t\t\t\t\t\t&lt;\/xs:element>\n\t\t\t\t\t\t\t\t\t&lt;\/xs:sequence>\n\t\t\t\t\t\t\t\t&lt;\/xs:complexType>\n\t\t\t\t\t\t\t&lt;\/xs:element>\n\t\t\t\t\t\t&lt;\/xs:sequence>\n\t\t\t\t\t&lt;\/xs:complexType>\n\t\t\t\t&lt;\/xs:element>\n\t\t\t&lt;\/xs:sequence>\n\t\t&lt;\/xs:complexType>\n\t&lt;\/xs:element>\n&lt;\/xs:schema><\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #E1E4E8\">&lt;?<\/span><span style=\"color: #85E89D\">xml<\/span><span style=\"color: #B392F0\"> version<\/span><span style=\"color: #E1E4E8\">=<\/span><span style=\"color: #9ECBFF\">&quot;1.0&quot;<\/span><span style=\"color: #B392F0\"> encoding<\/span><span style=\"color: #E1E4E8\">=<\/span><span style=\"color: #9ECBFF\">&quot;utf-8&quot;<\/span><span style=\"color: #E1E4E8\">?&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">&lt;<\/span><span style=\"color: #85E89D\">xs:schema<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">attributeFormDefault<\/span><span style=\"color: #E1E4E8\">=<\/span><span style=\"color: #9ECBFF\">&quot;unqualified&quot;<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">elementFormDefault<\/span><span style=\"color: #E1E4E8\">=<\/span><span style=\"color: #9ECBFF\">&quot;qualified&quot;<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">xmlns:xs<\/span><span style=\"color: #E1E4E8\">=<\/span><span style=\"color: #9ECBFF\">&quot;http:\/\/www.w3.org\/2001\/XMLSchema&quot;<\/span><span style=\"color: #E1E4E8\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">\t&lt;<\/span><span style=\"color: #85E89D\">xs:element<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">name<\/span><span style=\"color: #E1E4E8\">=<\/span><span style=\"color: #9ECBFF\">&quot;Reisid&quot;<\/span><span style=\"color: #E1E4E8\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">\t\t&lt;<\/span><span style=\"color: #85E89D\">xs:complexType<\/span><span style=\"color: #E1E4E8\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">\t\t\t&lt;<\/span><span style=\"color: #85E89D\">xs:sequence<\/span><span style=\"color: #E1E4E8\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">\t\t\t\t&lt;<\/span><span style=\"color: #85E89D\">xs:element<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">name<\/span><span style=\"color: #E1E4E8\">=<\/span><span style=\"color: #9ECBFF\">&quot;Reis&quot;<\/span><span style=\"color: #E1E4E8\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">\t\t\t\t\t&lt;<\/span><span style=\"color: #85E89D\">xs:complexType<\/span><span style=\"color: #E1E4E8\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">\t\t\t\t\t\t&lt;<\/span><span style=\"color: #85E89D\">xs:sequence<\/span><span style=\"color: #E1E4E8\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">\t\t\t\t\t\t\t&lt;<\/span><span style=\"color: #85E89D\">xs:element<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">name<\/span><span style=\"color: #E1E4E8\">=<\/span><span style=\"color: #9ECBFF\">&quot;Root&quot;<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">type<\/span><span style=\"color: #E1E4E8\">=<\/span><span style=\"color: #9ECBFF\">&quot;xs:string&quot;<\/span><span style=\"color: #E1E4E8\"> \/&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">\t\t\t\t\t\t\t&lt;<\/span><span style=\"color: #85E89D\">xs:element<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">name<\/span><span style=\"color: #E1E4E8\">=<\/span><span style=\"color: #9ECBFF\">&quot;Reisid&quot;<\/span><span style=\"color: #E1E4E8\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">\t\t\t\t\t\t\t\t&lt;<\/span><span style=\"color: #85E89D\">xs:complexType<\/span><span style=\"color: #E1E4E8\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">\t\t\t\t\t\t\t\t\t&lt;<\/span><span style=\"color: #85E89D\">xs:sequence<\/span><span style=\"color: #E1E4E8\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">\t\t\t\t\t\t\t\t\t\t&lt;<\/span><span style=\"color: #85E89D\">xs:element<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">maxOccurs<\/span><span style=\"color: #E1E4E8\">=<\/span><span style=\"color: #9ECBFF\">&quot;unbounded&quot;<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">name<\/span><span style=\"color: #E1E4E8\">=<\/span><span style=\"color: #9ECBFF\">&quot;Reis&quot;<\/span><span style=\"color: #E1E4E8\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">\t\t\t\t\t\t\t\t\t\t\t&lt;<\/span><span style=\"color: #85E89D\">xs:complexType<\/span><span style=\"color: #E1E4E8\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">\t\t\t\t\t\t\t\t\t\t\t\t&lt;<\/span><span style=\"color: #85E89D\">xs:sequence<\/span><span style=\"color: #E1E4E8\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">\t\t\t\t\t\t\t\t\t\t\t\t\t&lt;<\/span><span style=\"color: #85E89D\">xs:element<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">name<\/span><span style=\"color: #E1E4E8\">=<\/span><span style=\"color: #9ECBFF\">&quot;reis_id&quot;<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">type<\/span><span style=\"color: #E1E4E8\">=<\/span><span style=\"color: #9ECBFF\">&quot;xs:unsignedByte&quot;<\/span><span style=\"color: #E1E4E8\"> \/&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">\t\t\t\t\t\t\t\t\t\t\t\t\t&lt;<\/span><span style=\"color: #85E89D\">xs:element<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">name<\/span><span style=\"color: #E1E4E8\">=<\/span><span style=\"color: #9ECBFF\">&quot;Lennujaamad&quot;<\/span><span style=\"color: #E1E4E8\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t&lt;<\/span><span style=\"color: #85E89D\">xs:complexType<\/span><span style=\"color: #E1E4E8\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t&lt;<\/span><span style=\"color: #85E89D\">xs:sequence<\/span><span style=\"color: #E1E4E8\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t&lt;<\/span><span style=\"color: #85E89D\">xs:element<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">name<\/span><span style=\"color: #E1E4E8\">=<\/span><span style=\"color: #9ECBFF\">&quot;V\u00e4ljumis_lennujaam&quot;<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">type<\/span><span style=\"color: #E1E4E8\">=<\/span><span style=\"color: #9ECBFF\">&quot;xs:string&quot;<\/span><span style=\"color: #E1E4E8\"> \/&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t&lt;<\/span><span style=\"color: #85E89D\">xs:element<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">name<\/span><span style=\"color: #E1E4E8\">=<\/span><span style=\"color: #9ECBFF\">&quot;S\u00f5idukoha_lennujaam&quot;<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">type<\/span><span style=\"color: #E1E4E8\">=<\/span><span style=\"color: #9ECBFF\">&quot;xs:string&quot;<\/span><span style=\"color: #E1E4E8\"> \/&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t&lt;\/<\/span><span style=\"color: #85E89D\">xs:sequence<\/span><span style=\"color: #E1E4E8\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t&lt;\/<\/span><span style=\"color: #85E89D\">xs:complexType<\/span><span style=\"color: #E1E4E8\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">\t\t\t\t\t\t\t\t\t\t\t\t\t&lt;\/<\/span><span style=\"color: #85E89D\">xs:element<\/span><span style=\"color: #E1E4E8\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">\t\t\t\t\t\t\t\t\t\t\t\t\t&lt;<\/span><span style=\"color: #85E89D\">xs:element<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">name<\/span><span style=\"color: #E1E4E8\">=<\/span><span style=\"color: #9ECBFF\">&quot;Andmed&quot;<\/span><span style=\"color: #E1E4E8\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t&lt;<\/span><span style=\"color: #85E89D\">xs:complexType<\/span><span style=\"color: #E1E4E8\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t&lt;<\/span><span style=\"color: #85E89D\">xs:sequence<\/span><span style=\"color: #E1E4E8\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t&lt;<\/span><span style=\"color: #85E89D\">xs:element<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">name<\/span><span style=\"color: #E1E4E8\">=<\/span><span style=\"color: #9ECBFF\">&quot;Transpordi_liik&quot;<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">type<\/span><span style=\"color: #E1E4E8\">=<\/span><span style=\"color: #9ECBFF\">&quot;xs:string&quot;<\/span><span style=\"color: #E1E4E8\"> \/&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t&lt;<\/span><span style=\"color: #85E89D\">xs:element<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">name<\/span><span style=\"color: #E1E4E8\">=<\/span><span style=\"color: #9ECBFF\">&quot;Kaugus_km&quot;<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">type<\/span><span style=\"color: #E1E4E8\">=<\/span><span style=\"color: #9ECBFF\">&quot;xs:decimal&quot;<\/span><span style=\"color: #E1E4E8\"> \/&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t&lt;<\/span><span style=\"color: #85E89D\">xs:element<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">name<\/span><span style=\"color: #E1E4E8\">=<\/span><span style=\"color: #9ECBFF\">&quot;Kestus_tunnid&quot;<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">type<\/span><span style=\"color: #E1E4E8\">=<\/span><span style=\"color: #9ECBFF\">&quot;xs:decimal&quot;<\/span><span style=\"color: #E1E4E8\"> \/&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t&lt;<\/span><span style=\"color: #85E89D\">xs:element<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">name<\/span><span style=\"color: #E1E4E8\">=<\/span><span style=\"color: #9ECBFF\">&quot;Reisijate_arv&quot;<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">type<\/span><span style=\"color: #E1E4E8\">=<\/span><span style=\"color: #9ECBFF\">&quot;xs:unsignedByte&quot;<\/span><span style=\"color: #E1E4E8\"> \/&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t&lt;<\/span><span style=\"color: #85E89D\">xs:element<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">name<\/span><span style=\"color: #E1E4E8\">=<\/span><span style=\"color: #9ECBFF\">&quot;Lennufirma_nimi&quot;<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">type<\/span><span style=\"color: #E1E4E8\">=<\/span><span style=\"color: #9ECBFF\">&quot;xs:string&quot;<\/span><span style=\"color: #E1E4E8\"> \/&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t&lt;<\/span><span style=\"color: #85E89D\">xs:element<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">name<\/span><span style=\"color: #E1E4E8\">=<\/span><span style=\"color: #9ECBFF\">&quot;Piletihind&quot;<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">type<\/span><span style=\"color: #E1E4E8\">=<\/span><span style=\"color: #9ECBFF\">&quot;xs:decimal&quot;<\/span><span style=\"color: #E1E4E8\"> \/&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t&lt;\/<\/span><span style=\"color: #85E89D\">xs:sequence<\/span><span style=\"color: #E1E4E8\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t&lt;\/<\/span><span style=\"color: #85E89D\">xs:complexType<\/span><span style=\"color: #E1E4E8\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">\t\t\t\t\t\t\t\t\t\t\t\t\t&lt;\/<\/span><span style=\"color: #85E89D\">xs:element<\/span><span style=\"color: #E1E4E8\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">\t\t\t\t\t\t\t\t\t\t\t\t&lt;\/<\/span><span style=\"color: #85E89D\">xs:sequence<\/span><span style=\"color: #E1E4E8\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">\t\t\t\t\t\t\t\t\t\t\t&lt;\/<\/span><span style=\"color: #85E89D\">xs:complexType<\/span><span style=\"color: #E1E4E8\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">\t\t\t\t\t\t\t\t\t\t&lt;\/<\/span><span style=\"color: #85E89D\">xs:element<\/span><span style=\"color: #E1E4E8\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">\t\t\t\t\t\t\t\t\t&lt;\/<\/span><span style=\"color: #85E89D\">xs:sequence<\/span><span style=\"color: #E1E4E8\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">\t\t\t\t\t\t\t\t&lt;\/<\/span><span style=\"color: #85E89D\">xs:complexType<\/span><span style=\"color: #E1E4E8\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">\t\t\t\t\t\t\t&lt;\/<\/span><span style=\"color: #85E89D\">xs:element<\/span><span style=\"color: #E1E4E8\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">\t\t\t\t\t\t&lt;\/<\/span><span style=\"color: #85E89D\">xs:sequence<\/span><span style=\"color: #E1E4E8\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">\t\t\t\t\t&lt;\/<\/span><span style=\"color: #85E89D\">xs:complexType<\/span><span style=\"color: #E1E4E8\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">\t\t\t\t&lt;\/<\/span><span style=\"color: #85E89D\">xs:element<\/span><span style=\"color: #E1E4E8\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">\t\t\t&lt;\/<\/span><span style=\"color: #85E89D\">xs:sequence<\/span><span style=\"color: #E1E4E8\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">\t\t&lt;\/<\/span><span style=\"color: #85E89D\">xs:complexType<\/span><span style=\"color: #E1E4E8\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">\t&lt;\/<\/span><span style=\"color: #85E89D\">xs:element<\/span><span style=\"color: #E1E4E8\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">&lt;\/<\/span><span style=\"color: #85E89D\">xs:schema<\/span><span style=\"color: #E1E4E8\">&gt;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<ol start=\"8\" class=\"wp-block-list\">\n<li>Konverteerime fail XML&#8217;ist JSON&#8217;iks<\/li>\n<\/ol>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:clamp(16px, 1rem, 24px);font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#e1e4e8;--cbp-line-number-width:calc(2 * 0.6 * 1rem);line-height:clamp(20px, 1.25rem, 30px);--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:flex;align-items:center;padding:10px 0px 10px 16px;margin-bottom:-2px;width:100%;text-align:left;background-color:#2f363c;color:#d3d7dd\">PHP<\/span><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>&lt;?php\n\/\/ Laeme XML faili\n$xml = simplexml_load_file(\"XMLFile.xml\");\n\n\/\/ Teisendame XML objektist JSON-iks\n$json = json_encode($xml, JSON_PRETTY_PRINT | JSON_UNESCAPED_SLASHES);\n\n\/\/ Salvestame faili\nfile_put_contents(\"XMLFile.xml\", $json);\n\necho \"Konverteerimine valmis! Vaata faili XMLFile.xml\";<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F97583\">&lt;?<\/span><span style=\"color: #79B8FF\">php<\/span><\/span>\n<span class=\"line\"><span style=\"color: #6A737D\">\/\/ Laeme XML faili<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">$xml <\/span><span style=\"color: #F97583\">=<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #79B8FF\">simplexml_load_file<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #9ECBFF\">&quot;XMLFile.xml&quot;<\/span><span style=\"color: #E1E4E8\">);<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #6A737D\">\/\/ Teisendame XML objektist JSON-iks<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">$json <\/span><span style=\"color: #F97583\">=<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #79B8FF\">json_encode<\/span><span style=\"color: #E1E4E8\">($xml, <\/span><span style=\"color: #79B8FF\">JSON_PRETTY_PRINT<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">|<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #79B8FF\">JSON_UNESCAPED_SLASHES<\/span><span style=\"color: #E1E4E8\">);<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #6A737D\">\/\/ Salvestame faili<\/span><\/span>\n<span class=\"line\"><span style=\"color: #79B8FF\">file_put_contents<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #9ECBFF\">&quot;XMLFile.xml&quot;<\/span><span style=\"color: #E1E4E8\">, $json);<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #79B8FF\">echo<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">&quot;Konverteerimine valmis! Vaata faili XMLFile.xml&quot;<\/span><span style=\"color: #E1E4E8\">;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<ol start=\"9\" class=\"wp-block-list\">\n<li>Kuvame JSON <code>jQuery<\/code>&#8216;st<\/li>\n<\/ol>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:clamp(16px, 1rem, 24px);font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#e1e4e8;--cbp-line-number-width:calc(2 * 0.6 * 1rem);line-height:clamp(20px, 1.25rem, 30px);--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:flex;align-items:center;padding:10px 0px 10px 16px;margin-bottom:-2px;width:100%;text-align:left;background-color:#2f363c;color:#d3d7dd\">HTML<\/span><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>&lt;!DOCTYPE html>\n&lt;html>\n&lt;head>\n    &lt;meta charset=\"UTF-8\">\n    &lt;meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\n    &lt;title>jquery ja JSON&lt;\/title>\n    &lt;script src=\"\/\/code.jquery.com\/jquery-1.11.2.min.js\">&lt;\/script>\n    &lt;script>\n        $(document).ready(function(){\n            $.ajax({\n                type: \"GET\",\n                url: \"JSONFile.json\",\n                dataType: \"json\",\n                success: kuvaJSON,\n                error: vigaJSON\n            });\n        });\n\n        function vigaJSON(){\n            $(\"#container\").append('&lt;p style=\"color:red;\">Probleemid JSON failiga!&lt;\/p>');\n        }\n\n        function kuvaJSON(json){\n            $.each(json.Reis.Reisid.Reis, function(index, reis){\n                var reis_id = reis.reis_id;\n                var valjumis_lennujaam = reis.Lennujaamad&#91;\"V\\u00e4ljumis_lennujaam\"&#93;;\n                var soidukoha_lennujaam = reis.Lennujaamad&#91;\"S\\u00f5idukoha_lennujaam\"&#93;;\n                var transpordi_liik = reis.Andmed.Transpordi_liik;\n                var kaugus_km = reis.Andmed.Kaugus_km;\n                var kestus_tunnid = reis.Andmed.Kestus_tunnid;\n                var reisijate_arv = reis.Andmed.Reisijate_arv;\n                var lennufirma_nimi = reis.Andmed.Lennufirma_nimi;\n                var piletihind = reis.Andmed.Piletihind;\n\n                $(\"#container\").append(\n                    '&lt;div style=\"border: 1px solid;\">' +\n                    '&lt;h3>Reis ID: ' + reis_id + '&lt;\/h3>' +\n                    '&lt;p>&lt;strong>V\u00e4ljumis lennujaam:&lt;\/strong> ' + valjumis_lennujaam + '&lt;\/p>' +\n                    '&lt;p>&lt;strong>S\u00f5idukoha lennujaam:&lt;\/strong> ' + soidukoha_lennujaam + '&lt;\/p>' +\n                    '&lt;p>&lt;strong>Transpordi liik:&lt;\/strong> ' + transpordi_liik + '&lt;\/p>' +\n                    '&lt;p>&lt;strong>Kaugus (km):&lt;\/strong> ' + kaugus_km + '&lt;\/p>' +\n                    '&lt;p>&lt;strong>Kestus (tunnid):&lt;\/strong> ' + kestus_tunnid + '&lt;\/p>' +\n                    '&lt;p>&lt;strong>Reisijate arv:&lt;\/strong> ' + reisijate_arv + '&lt;\/p>' +\n                    '&lt;p>&lt;strong>Lennufirma nimi:&lt;\/strong> ' + lennufirma_nimi + '&lt;\/p>' +\n                    '&lt;p>&lt;strong>Piletihind:&lt;\/strong> ' + piletihind + '&lt;\/p>' +\n                    '&lt;\/div>'\n                );\n            });\n        }\n    &lt;\/script>\n&lt;\/head>\n&lt;body>\n&lt;div id=\"container\">\n\n&lt;\/div>\n&lt;\/body>\n&lt;\/html><\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #E1E4E8\">&lt;!<\/span><span style=\"color: #85E89D\">DOCTYPE<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">html<\/span><span style=\"color: #E1E4E8\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">&lt;<\/span><span style=\"color: #85E89D\">html<\/span><span style=\"color: #E1E4E8\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">&lt;<\/span><span style=\"color: #85E89D\">head<\/span><span style=\"color: #E1E4E8\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">    &lt;<\/span><span style=\"color: #85E89D\">meta<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">charset<\/span><span style=\"color: #E1E4E8\">=<\/span><span style=\"color: #9ECBFF\">&quot;UTF-8&quot;<\/span><span style=\"color: #E1E4E8\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">    &lt;<\/span><span style=\"color: #85E89D\">meta<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">name<\/span><span style=\"color: #E1E4E8\">=<\/span><span style=\"color: #9ECBFF\">&quot;viewport&quot;<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">content<\/span><span style=\"color: #E1E4E8\">=<\/span><span style=\"color: #9ECBFF\">&quot;width=device-width, initial-scale=1.0&quot;<\/span><span style=\"color: #E1E4E8\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">    &lt;<\/span><span style=\"color: #85E89D\">title<\/span><span style=\"color: #E1E4E8\">&gt;jquery ja JSON&lt;\/<\/span><span style=\"color: #85E89D\">title<\/span><span style=\"color: #E1E4E8\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">    &lt;<\/span><span style=\"color: #85E89D\">script<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">src<\/span><span style=\"color: #E1E4E8\">=<\/span><span style=\"color: #9ECBFF\">&quot;\/\/code.jquery.com\/jquery-1.11.2.min.js&quot;<\/span><span style=\"color: #E1E4E8\">&gt;&lt;\/<\/span><span style=\"color: #85E89D\">script<\/span><span style=\"color: #E1E4E8\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">    &lt;<\/span><span style=\"color: #85E89D\">script<\/span><span style=\"color: #E1E4E8\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">        <\/span><span style=\"color: #B392F0\">$<\/span><span style=\"color: #E1E4E8\">(document).<\/span><span style=\"color: #B392F0\">ready<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #F97583\">function<\/span><span style=\"color: #E1E4E8\">(){<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">            $.<\/span><span style=\"color: #B392F0\">ajax<\/span><span style=\"color: #E1E4E8\">({<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                type: <\/span><span style=\"color: #9ECBFF\">&quot;GET&quot;<\/span><span style=\"color: #E1E4E8\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                url: <\/span><span style=\"color: #9ECBFF\">&quot;JSONFile.json&quot;<\/span><span style=\"color: #E1E4E8\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                dataType: <\/span><span style=\"color: #9ECBFF\">&quot;json&quot;<\/span><span style=\"color: #E1E4E8\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                success: kuvaJSON,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                error: vigaJSON<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">            });<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">        });<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">        <\/span><span style=\"color: #F97583\">function<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">vigaJSON<\/span><span style=\"color: #E1E4E8\">(){<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">            <\/span><span style=\"color: #B392F0\">$<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #9ECBFF\">&quot;#container&quot;<\/span><span style=\"color: #E1E4E8\">).<\/span><span style=\"color: #B392F0\">append<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #9ECBFF\">&#39;&lt;p style=&quot;color:red;&quot;&gt;Probleemid JSON failiga!&lt;\/p&gt;&#39;<\/span><span style=\"color: #E1E4E8\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">        }<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">        <\/span><span style=\"color: #F97583\">function<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">kuvaJSON<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #FFAB70\">json<\/span><span style=\"color: #E1E4E8\">){<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">            $.<\/span><span style=\"color: #B392F0\">each<\/span><span style=\"color: #E1E4E8\">(json.Reis.Reisid.Reis, <\/span><span style=\"color: #F97583\">function<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #FFAB70\">index<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #FFAB70\">reis<\/span><span style=\"color: #E1E4E8\">){<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                <\/span><span style=\"color: #F97583\">var<\/span><span style=\"color: #E1E4E8\"> reis_id <\/span><span style=\"color: #F97583\">=<\/span><span style=\"color: #E1E4E8\"> reis.reis_id;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                <\/span><span style=\"color: #F97583\">var<\/span><span style=\"color: #E1E4E8\"> valjumis_lennujaam <\/span><span style=\"color: #F97583\">=<\/span><span style=\"color: #E1E4E8\"> reis.Lennujaamad&#91;<\/span><span style=\"color: #9ECBFF\">&quot;V<\/span><span style=\"color: #79B8FF\">\\u00e4<\/span><span style=\"color: #9ECBFF\">ljumis_lennujaam&quot;<\/span><span style=\"color: #E1E4E8\">&#93;;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                <\/span><span style=\"color: #F97583\">var<\/span><span style=\"color: #E1E4E8\"> soidukoha_lennujaam <\/span><span style=\"color: #F97583\">=<\/span><span style=\"color: #E1E4E8\"> reis.Lennujaamad&#91;<\/span><span style=\"color: #9ECBFF\">&quot;S<\/span><span style=\"color: #79B8FF\">\\u00f5<\/span><span style=\"color: #9ECBFF\">idukoha_lennujaam&quot;<\/span><span style=\"color: #E1E4E8\">&#93;;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                <\/span><span style=\"color: #F97583\">var<\/span><span style=\"color: #E1E4E8\"> transpordi_liik <\/span><span style=\"color: #F97583\">=<\/span><span style=\"color: #E1E4E8\"> reis.Andmed.Transpordi_liik;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                <\/span><span style=\"color: #F97583\">var<\/span><span style=\"color: #E1E4E8\"> kaugus_km <\/span><span style=\"color: #F97583\">=<\/span><span style=\"color: #E1E4E8\"> reis.Andmed.Kaugus_km;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                <\/span><span style=\"color: #F97583\">var<\/span><span style=\"color: #E1E4E8\"> kestus_tunnid <\/span><span style=\"color: #F97583\">=<\/span><span style=\"color: #E1E4E8\"> reis.Andmed.Kestus_tunnid;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                <\/span><span style=\"color: #F97583\">var<\/span><span style=\"color: #E1E4E8\"> reisijate_arv <\/span><span style=\"color: #F97583\">=<\/span><span style=\"color: #E1E4E8\"> reis.Andmed.Reisijate_arv;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                <\/span><span style=\"color: #F97583\">var<\/span><span style=\"color: #E1E4E8\"> lennufirma_nimi <\/span><span style=\"color: #F97583\">=<\/span><span style=\"color: #E1E4E8\"> reis.Andmed.Lennufirma_nimi;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                <\/span><span style=\"color: #F97583\">var<\/span><span style=\"color: #E1E4E8\"> piletihind <\/span><span style=\"color: #F97583\">=<\/span><span style=\"color: #E1E4E8\"> reis.Andmed.Piletihind;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                <\/span><span style=\"color: #B392F0\">$<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #9ECBFF\">&quot;#container&quot;<\/span><span style=\"color: #E1E4E8\">).<\/span><span style=\"color: #B392F0\">append<\/span><span style=\"color: #E1E4E8\">(<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                    <\/span><span style=\"color: #9ECBFF\">&#39;&lt;div style=&quot;border: 1px solid;&quot;&gt;&#39;<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">+<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                    <\/span><span style=\"color: #9ECBFF\">&#39;&lt;h3&gt;Reis ID: &#39;<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">+<\/span><span style=\"color: #E1E4E8\"> reis_id <\/span><span style=\"color: #F97583\">+<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">&#39;&lt;\/h3&gt;&#39;<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">+<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                    <\/span><span style=\"color: #9ECBFF\">&#39;&lt;p&gt;&lt;strong&gt;V\u00e4ljumis lennujaam:&lt;\/strong&gt; &#39;<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">+<\/span><span style=\"color: #E1E4E8\"> valjumis_lennujaam <\/span><span style=\"color: #F97583\">+<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">&#39;&lt;\/p&gt;&#39;<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">+<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                    <\/span><span style=\"color: #9ECBFF\">&#39;&lt;p&gt;&lt;strong&gt;S\u00f5idukoha lennujaam:&lt;\/strong&gt; &#39;<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">+<\/span><span style=\"color: #E1E4E8\"> soidukoha_lennujaam <\/span><span style=\"color: #F97583\">+<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">&#39;&lt;\/p&gt;&#39;<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">+<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                    <\/span><span style=\"color: #9ECBFF\">&#39;&lt;p&gt;&lt;strong&gt;Transpordi liik:&lt;\/strong&gt; &#39;<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">+<\/span><span style=\"color: #E1E4E8\"> transpordi_liik <\/span><span style=\"color: #F97583\">+<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">&#39;&lt;\/p&gt;&#39;<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">+<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                    <\/span><span style=\"color: #9ECBFF\">&#39;&lt;p&gt;&lt;strong&gt;Kaugus (km):&lt;\/strong&gt; &#39;<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">+<\/span><span style=\"color: #E1E4E8\"> kaugus_km <\/span><span style=\"color: #F97583\">+<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">&#39;&lt;\/p&gt;&#39;<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">+<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                    <\/span><span style=\"color: #9ECBFF\">&#39;&lt;p&gt;&lt;strong&gt;Kestus (tunnid):&lt;\/strong&gt; &#39;<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">+<\/span><span style=\"color: #E1E4E8\"> kestus_tunnid <\/span><span style=\"color: #F97583\">+<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">&#39;&lt;\/p&gt;&#39;<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">+<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                    <\/span><span style=\"color: #9ECBFF\">&#39;&lt;p&gt;&lt;strong&gt;Reisijate arv:&lt;\/strong&gt; &#39;<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">+<\/span><span style=\"color: #E1E4E8\"> reisijate_arv <\/span><span style=\"color: #F97583\">+<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">&#39;&lt;\/p&gt;&#39;<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">+<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                    <\/span><span style=\"color: #9ECBFF\">&#39;&lt;p&gt;&lt;strong&gt;Lennufirma nimi:&lt;\/strong&gt; &#39;<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">+<\/span><span style=\"color: #E1E4E8\"> lennufirma_nimi <\/span><span style=\"color: #F97583\">+<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">&#39;&lt;\/p&gt;&#39;<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">+<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                    <\/span><span style=\"color: #9ECBFF\">&#39;&lt;p&gt;&lt;strong&gt;Piletihind:&lt;\/strong&gt; &#39;<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">+<\/span><span style=\"color: #E1E4E8\"> piletihind <\/span><span style=\"color: #F97583\">+<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">&#39;&lt;\/p&gt;&#39;<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">+<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                    <\/span><span style=\"color: #9ECBFF\">&#39;&lt;\/div&gt;&#39;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">                );<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">            });<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">        }<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">    &lt;\/<\/span><span style=\"color: #85E89D\">script<\/span><span style=\"color: #E1E4E8\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">&lt;\/<\/span><span style=\"color: #85E89D\">head<\/span><span style=\"color: #E1E4E8\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">&lt;<\/span><span style=\"color: #85E89D\">body<\/span><span style=\"color: #E1E4E8\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">&lt;<\/span><span style=\"color: #85E89D\">div<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">id<\/span><span style=\"color: #E1E4E8\">=<\/span><span style=\"color: #9ECBFF\">&quot;container&quot;<\/span><span style=\"color: #E1E4E8\">&gt;<\/span><\/span>\n<span class=\"line\"><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">&lt;\/<\/span><span style=\"color: #85E89D\">div<\/span><span style=\"color: #E1E4E8\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">&lt;\/<\/span><span style=\"color: #85E89D\">body<\/span><span style=\"color: #E1E4E8\">&gt;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">&lt;\/<\/span><span style=\"color: #85E89D\">html<\/span><span style=\"color: #E1E4E8\">&gt;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p><a href=\"https:\/\/github.com\/FantomTchi7\/Andmevahetusvormingud\/tree\/master\">https:\/\/github.com\/FantomTchi7\/Andmevahetusvormingud\/tree\/master<\/a><\/p>\n\n\n\n<figure class=\"wp-block-image size-large wp-duotone-unset-4\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"494\" src=\"https:\/\/vladislavkudriashev23.thkit.ee\/WP\/wp-content\/uploads\/2025\/09\/B1DB022A-5B28-42A9-8D9D-E251D3D2C7E6-1024x494.png\" alt=\"\" class=\"wp-image-2387\" srcset=\"https:\/\/vladislavkudriashev23.thkit.ee\/WP\/wp-content\/uploads\/2025\/09\/B1DB022A-5B28-42A9-8D9D-E251D3D2C7E6-1024x494.png 1024w, https:\/\/vladislavkudriashev23.thkit.ee\/WP\/wp-content\/uploads\/2025\/09\/B1DB022A-5B28-42A9-8D9D-E251D3D2C7E6-300x145.png 300w, https:\/\/vladislavkudriashev23.thkit.ee\/WP\/wp-content\/uploads\/2025\/09\/B1DB022A-5B28-42A9-8D9D-E251D3D2C7E6-768x370.png 768w, https:\/\/vladislavkudriashev23.thkit.ee\/WP\/wp-content\/uploads\/2025\/09\/B1DB022A-5B28-42A9-8D9D-E251D3D2C7E6-150x72.png 150w, https:\/\/vladislavkudriashev23.thkit.ee\/WP\/wp-content\/uploads\/2025\/09\/B1DB022A-5B28-42A9-8D9D-E251D3D2C7E6-1536x741.png 1536w, https:\/\/vladislavkudriashev23.thkit.ee\/WP\/wp-content\/uploads\/2025\/09\/B1DB022A-5B28-42A9-8D9D-E251D3D2C7E6.png 1916w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Funktsioon GetXmlFromQuery loob \u00fchenduse SQL Serveri andmebaasiga nimega XMLReis. Seej\u00e4rel k\u00e4ivitab see SQL-p\u00e4ringu, mis teisendab MOCK_DATA tabeli andmed XML-vormingusse. OnGet meetod v\u00f5tab andmebaasist saadud XML-i ja rakendab sellele Reisid.xslt failis m\u00e4\u00e4ratletud XSLT teisenduse. Teisendatud XML salvestatakse TransformedXml atribuuti, mis kuvatakse veebilehel. https:\/\/github.com\/FantomTchi7\/Andmevahetusvormingud\/tree\/master<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-2310","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/vladislavkudriashev23.thkit.ee\/WP\/wp-json\/wp\/v2\/pages\/2310","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/vladislavkudriashev23.thkit.ee\/WP\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/vladislavkudriashev23.thkit.ee\/WP\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/vladislavkudriashev23.thkit.ee\/WP\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/vladislavkudriashev23.thkit.ee\/WP\/wp-json\/wp\/v2\/comments?post=2310"}],"version-history":[{"count":23,"href":"https:\/\/vladislavkudriashev23.thkit.ee\/WP\/wp-json\/wp\/v2\/pages\/2310\/revisions"}],"predecessor-version":[{"id":2388,"href":"https:\/\/vladislavkudriashev23.thkit.ee\/WP\/wp-json\/wp\/v2\/pages\/2310\/revisions\/2388"}],"wp:attachment":[{"href":"https:\/\/vladislavkudriashev23.thkit.ee\/WP\/wp-json\/wp\/v2\/media?parent=2310"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}