// Flight routes and layovers graph traversal practice dataset (flight-routes-and-layovers-graph-traversal-practice-dataset) v1 — Prisma seed // Synthetic sample data, CC0-1.0. Generated deterministically; re-running the // generator with the same spec and seed reproduces this file exactly. // // Delegates are named after the tables (prisma.airports), which assumes models // mapped to those table names. Rename the delegates if your models differ. import { PrismaClient } from '@prisma/client'; const prisma = new PrismaClient(); async function main() { await prisma.airports.createMany({ data: [ { id: 1, airport_code: "INQ", city: "Schmittshire", reach_minutes: 137 }, { id: 2, airport_code: "RBS", city: "Westmouth", reach_minutes: 116 }, { id: 3, airport_code: "BLE", city: "West Braxtonboro", reach_minutes: 122 }, { id: 4, airport_code: "PAM", city: "Farmington", reach_minutes: 142 }, { id: 5, airport_code: "BBU", city: "Fort Imogene", reach_minutes: 127 }, { id: 6, airport_code: "BKM", city: "West Jodi", reach_minutes: 128 }, { id: 7, airport_code: "LEB", city: "Kalamazoo", reach_minutes: 112 }, { id: 8, airport_code: "WUM", city: "Philadelphia", reach_minutes: 109 }, { id: 9, airport_code: "KXH", city: "Reingertown", reach_minutes: 71 }, { id: 10, airport_code: "KBS", city: "Wehnerfort", reach_minutes: 97 }, { id: 11, airport_code: "HHM", city: "New Traviston", reach_minutes: 174 }, { id: 12, airport_code: "MAE", city: "Port Alexanderberg", reach_minutes: 96 }, { id: 13, airport_code: "QXD", city: "Schimmelboro", reach_minutes: 116 }, { id: 14, airport_code: "IGU", city: "Bonniebury", reach_minutes: 141 }, { id: 15, airport_code: "ZXM", city: "Reichelshire", reach_minutes: 83 }, { id: 16, airport_code: "FTH", city: "Vandervortside", reach_minutes: 123 }, { id: 17, airport_code: "SUE", city: "North Kelley", reach_minutes: 96 }, { id: 18, airport_code: "MJQ", city: "Bahringerton", reach_minutes: 76 }, { id: 19, airport_code: "RUA", city: "Hermanworth", reach_minutes: 174 }, { id: 20, airport_code: "RSQ", city: "Lottiecester", reach_minutes: 154 }, { id: 21, airport_code: "KXB", city: "Annettahaven", reach_minutes: 60 }, { id: 22, airport_code: "EBW", city: "New Jasper", reach_minutes: 92 }, { id: 23, airport_code: "NOW", city: "Koelpinshire", reach_minutes: 101 }, { id: 24, airport_code: "SFR", city: "North Else", reach_minutes: 152 }, { id: 25, airport_code: "SYL", city: "Gleichner-Mayertview", reach_minutes: 124 }, { id: 26, airport_code: "XHY", city: "East Kaylahside", reach_minutes: 112 }, { id: 27, airport_code: "YYT", city: "Lake Jamilboro", reach_minutes: 106 }, { id: 28, airport_code: "YOZ", city: "Dundalk", reach_minutes: 99 }, { id: 29, airport_code: "RNX", city: "Kuhicfurt", reach_minutes: 104 }, { id: 30, airport_code: "MHZ", city: "Rosettamouth", reach_minutes: 114 }, { id: 31, airport_code: "TLR", city: "Bernierbury", reach_minutes: 108 }, { id: 32, airport_code: "LCA", city: "Kuhlmanshire", reach_minutes: 111 }, { id: 33, airport_code: "SAL", city: "Starkworth", reach_minutes: 79 }, { id: 34, airport_code: "LXF", city: "Lake Barbarastead", reach_minutes: 108 }, { id: 35, airport_code: "VKQ", city: "Clearwater", reach_minutes: 97 }, { id: 36, airport_code: "QBL", city: "East Keltonburgh", reach_minutes: 114 }, { id: 37, airport_code: "OGS", city: "Gislasontown", reach_minutes: 106 }, { id: 38, airport_code: "FRA", city: "Henriettestad", reach_minutes: 84 }, { id: 39, airport_code: "PGX", city: "North Phil", reach_minutes: 110 }, { id: 40, airport_code: "MSQ", city: "Sadyeburgh", reach_minutes: 122 }, { id: 41, airport_code: "NER", city: "West David", reach_minutes: 120 }, { id: 42, airport_code: "LZJ", city: "Rempelstead", reach_minutes: 152 }, { id: 43, airport_code: "DZK", city: "Danielland", reach_minutes: 74 }, { id: 44, airport_code: "PLS", city: "Lake Tedfield", reach_minutes: 140 }, { id: 45, airport_code: "VOF", city: "Iowa City", reach_minutes: 95 }, { id: 46, airport_code: "OOK", city: "North Jaquan", reach_minutes: 163 }, { id: 47, airport_code: "PBY", city: "South Zelda", reach_minutes: 61 }, { id: 48, airport_code: "OVT", city: "Redmond", reach_minutes: 180 }, ], }); await prisma.carriers.createMany({ data: [ { id: 1, name: "Daniel - Dicki", founded_year: 2002 }, { id: 2, name: "Mayert - Hartmann", founded_year: 1974 }, { id: 3, name: "McCullough - Schinner", founded_year: 2009 }, { id: 4, name: "Steuber - Schmeler", founded_year: 1985 }, { id: 5, name: "Boehm LLC", founded_year: 2009 }, { id: 6, name: "Dietrich, Lubowitz and McCullough", founded_year: 1974 }, ], }); await prisma.routes.createMany({ data: [ { id: 1, origin_id: 42, destination_id: 35, carrier_id: 2, flight_no: "FL0194", block_minutes: "249", aircraft: "turboprop", weekly_flights: 40 }, { id: 2, origin_id: 14, destination_id: 1, carrier_id: 3, flight_no: "FL0558", block_minutes: "278", aircraft: "regional_jet", weekly_flights: 31 }, { id: 3, origin_id: 32, destination_id: 27, carrier_id: 6, flight_no: "FL5697", block_minutes: "217", aircraft: "narrowbody", weekly_flights: 28 }, { id: 4, origin_id: 47, destination_id: 42, carrier_id: 2, flight_no: "FL7945", block_minutes: "213", aircraft: "regional_jet", weekly_flights: 2 }, { id: 5, origin_id: 20, destination_id: 11, carrier_id: 3, flight_no: "FL1526", block_minutes: "328", aircraft: "turboprop", weekly_flights: 30 }, { id: 6, origin_id: 31, destination_id: 5, carrier_id: 3, flight_no: "FL7443", block_minutes: "235", aircraft: "regional_jet", weekly_flights: 8 }, { id: 7, origin_id: 45, destination_id: 26, carrier_id: 4, flight_no: "FL9329", block_minutes: "207", aircraft: "narrowbody", weekly_flights: 17 }, { id: 8, origin_id: 11, destination_id: 26, carrier_id: 6, flight_no: "FL6639", block_minutes: "286", aircraft: "regional_jet", weekly_flights: 5 }, { id: 9, origin_id: 42, destination_id: 18, carrier_id: 4, flight_no: "FL0039", block_minutes: "228", aircraft: "regional_jet", weekly_flights: 9 }, { id: 10, origin_id: 5, destination_id: 47, carrier_id: 1, flight_no: "FL1002", block_minutes: "188", aircraft: "regional_jet", weekly_flights: 2 }, { id: 11, origin_id: 5, destination_id: 4, carrier_id: 1, flight_no: "FL0653", block_minutes: "269", aircraft: "turboprop", weekly_flights: 4 }, { id: 12, origin_id: 24, destination_id: 11, carrier_id: 6, flight_no: "FL7950", block_minutes: "326", aircraft: "turboprop", weekly_flights: 15 }, { id: 13, origin_id: 26, destination_id: 24, carrier_id: 4, flight_no: "FL1771", block_minutes: "264", aircraft: "regional_jet", weekly_flights: 29 }, { id: 14, origin_id: 36, destination_id: 12, carrier_id: 6, flight_no: "FL9703", block_minutes: "210", aircraft: "turboprop", weekly_flights: 22 }, { id: 15, origin_id: 21, destination_id: 11, carrier_id: 4, flight_no: "FL7176", block_minutes: "234", aircraft: "narrowbody", weekly_flights: 9 }, { id: 16, origin_id: 8, destination_id: 21, carrier_id: 4, flight_no: "FL9405", block_minutes: "169", aircraft: "regional_jet", weekly_flights: 8 }, { id: 17, origin_id: 21, destination_id: 32, carrier_id: 5, flight_no: "FL1544", block_minutes: "171", aircraft: "regional_jet", weekly_flights: 9 }, { id: 18, origin_id: 42, destination_id: 26, carrier_id: 4, flight_no: "FL8929", block_minutes: "264", aircraft: "regional_jet", weekly_flights: 25 }, { id: 19, origin_id: 42, destination_id: 11, carrier_id: 5, flight_no: "FL5350", block_minutes: "326", aircraft: "regional_jet", weekly_flights: 7 }, { id: 20, origin_id: 20, destination_id: 25, carrier_id: 1, flight_no: "FL7523", block_minutes: "278", aircraft: "regional_jet", weekly_flights: 9 }, { id: 21, origin_id: 47, destination_id: 5, carrier_id: 1, flight_no: "FL6193", block_minutes: "188", aircraft: "turboprop", weekly_flights: 8 }, { id: 22, origin_id: 42, destination_id: 25, carrier_id: 5, flight_no: "FL8357", block_minutes: "276", aircraft: "regional_jet", weekly_flights: 4 }, { id: 23, origin_id: 27, destination_id: 28, carrier_id: 5, flight_no: "FL6600", block_minutes: "205", aircraft: "turboprop", weekly_flights: 20 }, { id: 24, origin_id: 22, destination_id: 5, carrier_id: 2, flight_no: "FL6616", block_minutes: "219", aircraft: "regional_jet", weekly_flights: 2 }, { id: 25, origin_id: 4, destination_id: 42, carrier_id: 5, flight_no: "FL2158", block_minutes: "294", aircraft: "regional_jet", weekly_flights: 4 }, { id: 26, origin_id: 6, destination_id: 25, carrier_id: 3, flight_no: "FL4575", block_minutes: "252", aircraft: "regional_jet", weekly_flights: 3 }, { id: 27, origin_id: 11, destination_id: 28, carrier_id: 6, flight_no: "FL7263", block_minutes: "273", aircraft: "regional_jet", weekly_flights: 31 }, { id: 28, origin_id: 29, destination_id: 26, carrier_id: 1, flight_no: "FL4637", block_minutes: "216", aircraft: "regional_jet", weekly_flights: 24 }, { id: 29, origin_id: 40, destination_id: 28, carrier_id: 1, flight_no: "FL6165", block_minutes: "221", aircraft: "narrowbody", weekly_flights: 7 }, { id: 30, origin_id: 36, destination_id: 19, carrier_id: 6, flight_no: "FL6670", block_minutes: "288", aircraft: "regional_jet", weekly_flights: 2 }, { id: 31, origin_id: 6, destination_id: 30, carrier_id: 4, flight_no: "FL2283", block_minutes: "242", aircraft: "narrowbody", weekly_flights: 14 }, { id: 32, origin_id: 4, destination_id: 36, carrier_id: 2, flight_no: "FL3372", block_minutes: "256", aircraft: "narrowbody", weekly_flights: 40 }, { id: 33, origin_id: 2, destination_id: 39, carrier_id: 6, flight_no: "FL5926", block_minutes: "226", aircraft: "regional_jet", weekly_flights: 16 }, { id: 34, origin_id: 17, destination_id: 37, carrier_id: 1, flight_no: "FL2772", block_minutes: "202", aircraft: "regional_jet", weekly_flights: 2 }, { id: 35, origin_id: 28, destination_id: 44, carrier_id: 5, flight_no: "FL0465", block_minutes: "239", aircraft: "regional_jet", weekly_flights: 15 }, { id: 36, origin_id: 6, destination_id: 27, carrier_id: 6, flight_no: "FL6464", block_minutes: "234", aircraft: "narrowbody", weekly_flights: 4 }, { id: 37, origin_id: 2, destination_id: 26, carrier_id: 3, flight_no: "FL0971", block_minutes: "228", aircraft: "narrowbody", weekly_flights: 11 }, { id: 38, origin_id: 40, destination_id: 3, carrier_id: 5, flight_no: "FL9263", block_minutes: "244", aircraft: "turboprop", weekly_flights: 27 }, { id: 39, origin_id: 20, destination_id: 18, carrier_id: 2, flight_no: "FL3750", block_minutes: "230", aircraft: "narrowbody", weekly_flights: 11 }, { id: 40, origin_id: 21, destination_id: 19, carrier_id: 6, flight_no: "FL0657", block_minutes: "234", aircraft: "regional_jet", weekly_flights: 9 }, { id: 41, origin_id: 23, destination_id: 20, carrier_id: 5, flight_no: "FL9444", block_minutes: "255", aircraft: "turboprop", weekly_flights: 2 }, { id: 42, origin_id: 22, destination_id: 26, carrier_id: 4, flight_no: "FL8427", block_minutes: "204", aircraft: "regional_jet", weekly_flights: 19 }, { id: 43, origin_id: 37, destination_id: 3, carrier_id: 1, flight_no: "FL6752", block_minutes: "228", aircraft: "regional_jet", weekly_flights: 21 }, { id: 44, origin_id: 35, destination_id: 1, carrier_id: 1, flight_no: "FL6538", block_minutes: "234", aircraft: "narrowbody", weekly_flights: 10 }, { id: 45, origin_id: 36, destination_id: 25, carrier_id: 3, flight_no: "FL8735", block_minutes: "238", aircraft: "narrowbody", weekly_flights: 12 }, { id: 46, origin_id: 24, destination_id: 17, carrier_id: 6, flight_no: "FL5849", block_minutes: "248", aircraft: "regional_jet", weekly_flights: 13 }, { id: 47, origin_id: 12, destination_id: 14, carrier_id: 4, flight_no: "FL1225", block_minutes: "237", aircraft: "narrowbody", weekly_flights: 11 }, { id: 48, origin_id: 39, destination_id: 11, carrier_id: 3, flight_no: "FL8452", block_minutes: "284", aircraft: "narrowbody", weekly_flights: 2 }, { id: 49, origin_id: 30, destination_id: 26, carrier_id: 3, flight_no: "FL1965", block_minutes: "226", aircraft: "regional_jet", weekly_flights: 6 }, { id: 50, origin_id: 28, destination_id: 43, carrier_id: 4, flight_no: "FL9403", block_minutes: "173", aircraft: "narrowbody", weekly_flights: 4 }, { id: 51, origin_id: 15, destination_id: 31, carrier_id: 2, flight_no: "FL3418", block_minutes: "191", aircraft: "regional_jet", weekly_flights: 3 }, { id: 52, origin_id: 36, destination_id: 26, carrier_id: 3, flight_no: "FL2234", block_minutes: "226", aircraft: "regional_jet", weekly_flights: 17 }, { id: 53, origin_id: 40, destination_id: 29, carrier_id: 1, flight_no: "FL3231", block_minutes: "226", aircraft: "turboprop", weekly_flights: 2 }, { id: 54, origin_id: 5, destination_id: 25, carrier_id: 1, flight_no: "FL9455", block_minutes: "251", aircraft: "regional_jet", weekly_flights: 11 }, { id: 55, origin_id: 47, destination_id: 32, carrier_id: 1, flight_no: "FL0244", block_minutes: "172", aircraft: "narrowbody", weekly_flights: 30 }, { id: 56, origin_id: 5, destination_id: 20, carrier_id: 2, flight_no: "FL0231", block_minutes: "281", aircraft: "turboprop", weekly_flights: 3 }, { id: 57, origin_id: 4, destination_id: 27, carrier_id: 2, flight_no: "FL6072", block_minutes: "248", aircraft: "regional_jet", weekly_flights: 5 }, { id: 58, origin_id: 21, destination_id: 6, carrier_id: 1, flight_no: "FL5159", block_minutes: "188", aircraft: "turboprop", weekly_flights: 5 }, { id: 59, origin_id: 17, destination_id: 10, carrier_id: 1, flight_no: "FL8522", block_minutes: "193", aircraft: "narrowbody", weekly_flights: 16 }, { id: 60, origin_id: 40, destination_id: 4, carrier_id: 6, flight_no: "FL7832", block_minutes: "264", aircraft: "regional_jet", weekly_flights: 17 }, { id: 61, origin_id: 11, destination_id: 34, carrier_id: 1, flight_no: "FL5986", block_minutes: "282", aircraft: "turboprop", weekly_flights: 17 }, { id: 62, origin_id: 31, destination_id: 25, carrier_id: 5, flight_no: "FL3723", block_minutes: "232", aircraft: "regional_jet", weekly_flights: 2 }, { id: 63, origin_id: 43, destination_id: 23, carrier_id: 4, flight_no: "FL4212", block_minutes: "175", aircraft: "regional_jet", weekly_flights: 7 }, { id: 64, origin_id: 24, destination_id: 14, carrier_id: 4, flight_no: "FL7812", block_minutes: "293", aircraft: "regional_jet", weekly_flights: 17 }, { id: 65, origin_id: 31, destination_id: 15, carrier_id: 2, flight_no: "FL6016", block_minutes: "191", aircraft: "turboprop", weekly_flights: 5 }, { id: 66, origin_id: 26, destination_id: 40, carrier_id: 1, flight_no: "FL2959", block_minutes: "234", aircraft: "narrowbody", weekly_flights: 14 }, { id: 67, origin_id: 37, destination_id: 5, carrier_id: 1, flight_no: "FL6482", block_minutes: "233", aircraft: "regional_jet", weekly_flights: 39 }, { id: 68, origin_id: 7, destination_id: 25, carrier_id: 2, flight_no: "FL5678", block_minutes: "236", aircraft: "turboprop", weekly_flights: 7 }, { id: 69, origin_id: 6, destination_id: 42, carrier_id: 5, flight_no: "FL5885", block_minutes: "280", aircraft: "turboprop", weekly_flights: 7 }, { id: 70, origin_id: 26, destination_id: 32, carrier_id: 3, flight_no: "FL2657", block_minutes: "223", aircraft: "turboprop", weekly_flights: 6 }, { id: 71, origin_id: 6, destination_id: 47, carrier_id: 1, flight_no: "FL1931", block_minutes: "189", aircraft: "regional_jet", weekly_flights: 3 }, { id: 72, origin_id: 26, destination_id: 28, carrier_id: 5, flight_no: "FL1068", block_minutes: "211", aircraft: "regional_jet", weekly_flights: 29 }, { id: 73, origin_id: 12, destination_id: 36, carrier_id: 3, flight_no: "FL6158", block_minutes: "210", aircraft: "turboprop", weekly_flights: 36 }, { id: 74, origin_id: 4, destination_id: 45, carrier_id: 2, flight_no: "FL8862", block_minutes: "237", aircraft: "narrowbody", weekly_flights: 4 }, { id: 75, origin_id: 37, destination_id: 28, carrier_id: 6, flight_no: "FL2737", block_minutes: "205", aircraft: "turboprop", weekly_flights: 28 }, { id: 76, origin_id: 39, destination_id: 5, carrier_id: 4, flight_no: "FL8659", block_minutes: "237", aircraft: "regional_jet", weekly_flights: 29 }, { id: 77, origin_id: 30, destination_id: 42, carrier_id: 5, flight_no: "FL9139", block_minutes: "266", aircraft: "regional_jet", weekly_flights: 20 }, { id: 78, origin_id: 5, destination_id: 34, carrier_id: 3, flight_no: "FL4706", block_minutes: "235", aircraft: "regional_jet", weekly_flights: 9 }, { id: 79, origin_id: 30, destination_id: 21, carrier_id: 2, flight_no: "FL4531", block_minutes: "174", aircraft: "regional_jet", weekly_flights: 2 }, { id: 80, origin_id: 38, destination_id: 24, carrier_id: 1, flight_no: "FL9881", block_minutes: "236", aircraft: "narrowbody", weekly_flights: 18 }, { id: 81, origin_id: 27, destination_id: 26, carrier_id: 3, flight_no: "FL5976", block_minutes: "218", aircraft: "turboprop", weekly_flights: 13 }, { id: 82, origin_id: 31, destination_id: 18, carrier_id: 6, flight_no: "FL4285", block_minutes: "184", aircraft: "regional_jet", weekly_flights: 16 }, { id: 83, origin_id: 22, destination_id: 29, carrier_id: 2, flight_no: "FL9233", block_minutes: "196", aircraft: "regional_jet", weekly_flights: 26 }, { id: 84, origin_id: 29, destination_id: 20, carrier_id: 6, flight_no: "FL8104", block_minutes: "258", aircraft: "narrowbody", weekly_flights: 28 }, { id: 85, origin_id: 17, destination_id: 28, carrier_id: 2, flight_no: "FL7922", block_minutes: "195", aircraft: "regional_jet", weekly_flights: 32 }, { id: 86, origin_id: 15, destination_id: 26, carrier_id: 4, flight_no: "FL7595", block_minutes: "195", aircraft: "regional_jet", weekly_flights: 13 }, { id: 87, origin_id: 12, destination_id: 45, carrier_id: 1, flight_no: "FL5616", block_minutes: "191", aircraft: "turboprop", weekly_flights: 2 }, { id: 88, origin_id: 7, destination_id: 26, carrier_id: 3, flight_no: "FL7928", block_minutes: "224", aircraft: "regional_jet", weekly_flights: 4 }, { id: 89, origin_id: 41, destination_id: 28, carrier_id: 1, flight_no: "FL9492", block_minutes: "219", aircraft: "regional_jet", weekly_flights: 6 }, { id: 90, origin_id: 12, destination_id: 35, carrier_id: 1, flight_no: "FL8359", block_minutes: "193", aircraft: "regional_jet", weekly_flights: 11 }, { id: 91, origin_id: 15, destination_id: 27, carrier_id: 2, flight_no: "FL3214", block_minutes: "189", aircraft: "narrowbody", weekly_flights: 7 }, { id: 92, origin_id: 33, destination_id: 25, carrier_id: 6, flight_no: "FL7126", block_minutes: "203", aircraft: "turboprop", weekly_flights: 38 }, { id: 93, origin_id: 17, destination_id: 26, carrier_id: 1, flight_no: "FL2160", block_minutes: "208", aircraft: "turboprop", weekly_flights: 15 }, { id: 94, origin_id: 29, destination_id: 4, carrier_id: 6, flight_no: "FL7763", block_minutes: "246", aircraft: "narrowbody", weekly_flights: 10 }, { id: 95, origin_id: 35, destination_id: 5, carrier_id: 1, flight_no: "FL7686", block_minutes: "224", aircraft: "regional_jet", weekly_flights: 14 }, { id: 96, origin_id: 17, destination_id: 9, carrier_id: 2, flight_no: "FL7476", block_minutes: "167", aircraft: "regional_jet", weekly_flights: 8 }, { id: 97, origin_id: 19, destination_id: 44, carrier_id: 6, flight_no: "FL3918", block_minutes: "314", aircraft: "turboprop", weekly_flights: 11 }, { id: 98, origin_id: 35, destination_id: 26, carrier_id: 6, flight_no: "FL4765", block_minutes: "209", aircraft: "narrowbody", weekly_flights: 21 }, { id: 99, origin_id: 22, destination_id: 4, carrier_id: 1, flight_no: "FL1790", block_minutes: "234", aircraft: "narrowbody", weekly_flights: 11 }, { id: 100, origin_id: 45, destination_id: 39, carrier_id: 3, flight_no: "FL4515", block_minutes: "205", aircraft: "regional_jet", weekly_flights: 38 }, { id: 101, origin_id: 15, destination_id: 18, carrier_id: 3, flight_no: "FL2967", block_minutes: "159", aircraft: "turboprop", weekly_flights: 9 }, { id: 102, origin_id: 9, destination_id: 1, carrier_id: 6, flight_no: "FL3163", block_minutes: "208", aircraft: "regional_jet", weekly_flights: 8 }, { id: 103, origin_id: 12, destination_id: 11, carrier_id: 4, flight_no: "FL3807", block_minutes: "270", aircraft: "regional_jet", weekly_flights: 9 }, { id: 104, origin_id: 40, destination_id: 29, carrier_id: 1, flight_no: "FL7046", block_minutes: "226", aircraft: "regional_jet", weekly_flights: 33 }, ], }); } main() .then(() => prisma.$disconnect()) .catch(async error => { console.error(error); await prisma.$disconnect(); process.exit(1); });