[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_202":203,"_204":205},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_19":20,"_17":18,"_21":157,"_23":158,"_159":160,"_161":162,"_27":163,"_25":164,"_165":-5,"_166":-5,"_167":61,"_168":169,"_170":61},"routes/_app.x.$handle.$name.branch.$branch.version.$version.code.$",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":22,"_23":24,"_25":26,"_27":28,"_29":-5,"_30":-5,"_31":-5,"_32":-5,"_33":-5},"handle","jpchip","name","GlobalEntryAppointmentChecker","branchName","main","version",67,"path","locations.tsx","project",{"_34":103,"_13":14,"_46":104,"_105":-5,"_106":61,"_107":108,"_109":110,"_111":112,"_113":114,"_115":67,"_116":58,"_117":-5,"_118":119,"_120":121,"_122":123,"_124":-5,"_125":-5,"_126":-5,"_127":-5,"_128":129,"_130":129,"_131":132,"_133":132,"_134":132,"_135":129,"_136":129,"_137":138,"_139":140,"_141":142,"_143":61},"tree",[52,53,54,55,56],"file",{"_34":35,"_36":37,"_38":39,"_13":20,"_40":41,"_42":43,"_17":44,"_45":-5,"_46":47,"_48":49,"_50":-5,"_19":51},"contents",[],"upstream","pull","ahead","behind","envVars","id","d45da116-2874-11f0-bdaa-569c3dd06744","branchId","82216088-275a-11f0-bd43-569c3dd06744","fileId","822692ce-275a-11f0-bd43-569c3dd06744","content","import { sqlite } from \"https://esm.town/v/std/sqlite\";\n\nawait sqlite.execute(`create table if not exists locations(\n id integer primary key,\n name text\n)`);\n\nconst locations = [\n {\n \"id\": \"8040\",\n \"name\":\n \"Albuquerque Enrollment Center - Albuquerque International Sunport 2200 Sunport Blvd SE Albuquerque NM 87106\",\n },\n {\n \"id\": \"6580\",\n \"name\": \"American Express - New York - 0 UNAVAILABLE NEW YORK NY 99999 US\",\n },\n {\n \"id\": \"7540\",\n \"name\": \"Anchorage Enrollment Center - Ted Stevens International Airport 4600 Postmark Drive RM NA 207 Anchorage\",\n },\n {\n \"id\": \"5182\",\n \"name\":\n \"Atlanta International Global Entry EC - 2600 Maynard H. Jackson Jr. Int'l Terminal Maynard H. Jackson Jr. Blvd.\",\n },\n {\n \"id\": \"5200\",\n \"name\": \"Atlanta Port Office Global Entry Enrollment Center - 157 Tradeport Drive Suite C Atlanta GA 30354 US\",\n },\n {\n \"id\": \"7820\",\n \"name\": \"Austin-Bergstrom International Airport - 3600 Presidential Blvd. Austin-Bergstrom International Airport\",\n },\n {\n \"id\": \"7940\",\n \"name\":\n \"Baltimore Enrollment Center - Baltimore Washington Thurgood Marshall I Lower Level Door 18 Linthicum MD 21240\",\n },\n {\n \"id\": \"13321\",\n \"name\": \"Blaine Global Entry Enrollment Center - 8115 Birch Bay Square St. Suite 104 Blaine WA 98230 US\",\n },\n {\n \"id\": \"12161\",\n \"name\": \"Boise Enrollment Center - 4655 S Enterprise Street Boise ID 83705 US\",\n },\n {\n \"id\": \"14221\",\n \"name\": \"Boston- Tip O'Neill Federal Building - 10 Causeway Street Room 812 Boston MA 02222 US\",\n },\n {\n \"id\": \"5441\",\n \"name\": \"Boston-Logan Global Entry Enrollment Center - Logan International Airport Terminal E East Boston MA 02128\",\n },\n {\n \"id\": \"5003\",\n \"name\": \"Brownsville Enrollment Center - 3300 South Expressway 77 83 Veterans International Bridge - Los Tomates\",\n },\n {\n \"id\": \"5022\",\n \"name\": \"Buffalo-Ft. Erie Enrollment Center - 10 CENTRAL AVENUE FORT ERIE ON L2A1G6 CA\",\n },\n {\n \"id\": \"5500\",\n \"name\": \"Calais Enrollment Center - 3 Customs Street, Calais, MAINE 04619\",\n },\n {\n \"id\": \"5006\",\n \"name\": \"Calexico Enrollment Center - 1699 E. Carr Rd PO BOX 632 Calexico CA 92231 US\",\n },\n {\n \"id\": \"5030\",\n \"name\": \"Calgary Enrollment Center - 2000 Airport Rd N.E. Calgary AB T2E6W5 CA\",\n },\n {\n \"id\": \"13801\",\n \"name\": \"Champlain Global Entry Enrollment Center - 237 West Service Road Champlain NY 12919 US\",\n },\n {\n \"id\": \"14321\",\n \"name\":\n \"Charlotte-Douglas - DOWNSTAIRS LOCATION - 5501 Charlotte-Douglas International Airport Josh Birmingham Parkway\",\n },\n {\n \"id\": \"11981\",\n \"name\":\n \"Chicago Field Office Enrollment Center - 610 Closed until further notice Closed until futher notice Chicago\",\n },\n {\n \"id\": \"5183\",\n \"name\": \"Chicago O'Hare International Global Entry EC - 10000 Bessie Coleman Drive Terminal 5 Lower Level Chicago\",\n },\n {\n \"id\": \"7680\",\n \"name\": \"Cincinnati Enrollment Center - 4243 Olympic Blvd. Suite. 210 Erlanger KY 41018 US\",\n },\n {\n \"id\": \"9180\",\n \"name\":\n \"Cleveland U.S. Customs and Border Protection - Customs & Border Protection 6747 Engle Road Middleburg Heights\",\n },\n {\n \"id\": \"5300\",\n \"name\": \"Dallas-Fort Worth Intl Airport Global Entry - DFW International Airport - Terminal D DFW Airport TX 75261\",\n },\n {\n \"id\": \"14161\",\n \"name\": \"DBX-SF -\",\n },\n {\n \"id\": \"14021\",\n \"name\": \"DCL2017 - This is a private event.\",\n },\n {\n \"id\": \"6940\",\n \"name\": \"Denver International Airport - 8400 Denver International Airport Pena Boulevard Denver CO 80249 US\",\n },\n {\n \"id\": \"5223\",\n \"name\": \"Derby Line Enrollment Center - 84 Main Street Derby Line VT 08530 US\",\n },\n {\n \"id\": \"14421\",\n \"name\": \"DESIGNTRAVEL2017 -\",\n },\n {\n \"id\": \"5023\",\n \"name\": \"Detroit Enrollment Center - 2810 WEST FORT STREET BUILDING B DETROIT MI 48226 US\",\n },\n {\n \"id\": \"5320\",\n \"name\": \"Detroit Metro Airport Global Entry - 601 Detroit North Terminal Rogell Dr. Suite 1271 Detroit MI 48242\",\n },\n {\n \"id\": \"14281\",\n \"name\": \"DLGA GO EVENT -\",\n },\n {\n \"id\": \"6920\",\n \"name\": \"Doha International Airport - Hamad International Airport Doha QA\",\n },\n {\n \"id\": \"8100\",\n \"name\": \"Douglas Enrollment Center - 1012 G Avenue Suite 107 Douglas AZ 85607 US\",\n },\n {\n \"id\": \"5032\",\n \"name\": \"Edmonton Enrollment Center - 1000 Airport Road Edmonton International Airport Edmonton AB T9E0V3 CA\",\n },\n {\n \"id\": \"14361\",\n \"name\": \"EGESBOS2017 -\",\n },\n {\n \"id\": \"5005\",\n \"name\": \"El Paso Enrollment Center - 797 S. Zaragoza Rd. Bldg. A El Paso TX 79907 US\",\n },\n {\n \"id\": \"14301\",\n \"name\": \"EMRSN2017 -\",\n },\n {\n \"id\": \"14381\",\n \"name\": \"Fairbanks Enrollment Center - 6450 Airport Way - Suite 13 Room 1320A Fairbanks AK 99709 US\",\n },\n {\n \"id\": \"14441\",\n \"name\": \"FOLA 020817-ROS -\",\n },\n {\n \"id\": \"14541\",\n \"name\": \"FOLA 030117-ALT -\",\n },\n {\n \"id\": \"14461\",\n \"name\": \"FOLA 031517-PTE -\",\n },\n {\n \"id\": \"14581\",\n \"name\": \"FOLA 032117-PLTR -\",\n },\n {\n \"id\": \"14462\",\n \"name\": \"FOLA 051717-APPT -\",\n },\n {\n \"id\": \"5443\",\n \"name\": \"Fort Lauderdale Global Entry Enrollment Center - 1800 Eller Drive Suite 104 Ft Lauderdale FL 33316 US\",\n },\n {\n \"id\": \"14241\",\n \"name\": \"FTGBL2017 -\",\n },\n {\n \"id\": \"14081\",\n \"name\": \"GenElect2017 - This is a private event.\",\n },\n {\n \"id\": \"9101\",\n \"name\": \"Grand Portage - 9403 E Highway 61 Grand Portage MN 55605 US\",\n },\n {\n \"id\": \"9140\",\n \"name\": \"Guam International Airport - 355 Chalan PasaHeru Suite B 224-B Tamuning GU 96913 US\",\n },\n {\n \"id\": \"14501\",\n \"name\": \"GULFAERO -\",\n },\n {\n \"id\": \"14481\",\n \"name\": \"Gulfport-Biloxi Global Entry Enrollment Center - Gulfport-Biloxi International Airport 14035 Airport Road\",\n },\n {\n \"id\": \"5031\",\n \"name\":\n \"Halifax Enrollment Center - U.S. Customs and Border Protection 1 Bell Boulevard Comp 1666 Halifax Intl Airport\",\n },\n {\n \"id\": \"5001\",\n \"name\": \"Hidalgo Enrollment Center - 5911 SOUTH STEWART RD MISSION TX 78572 US\",\n },\n {\n \"id\": \"5340\",\n \"name\": \"Honolulu Enrollment Center - 300 Rodgers Blvd Honolulu HI 96819 US\",\n },\n {\n \"id\": \"5101\",\n \"name\": \"Houlton Enrollment Center - 1403 Route 95 Belleville NB E7M4Z9 CA\",\n },\n {\n \"id\": \"7620\",\n \"name\": \"Houston Central Library - 500 McKinney St. Houston TX 77002 US\",\n },\n {\n \"id\": \"5141\",\n \"name\": \"Houston Intercontinental Global Entry EC - 3870 North Terminal Road Terminal E Houston TX 77032 US\",\n },\n {\n \"id\": \"7480\",\n \"name\":\n \"Houston Term E - BOARDING PASS REQUIRED TO ENT - Sterile Corridor requires Boarding Pass IAH Terminal E\",\n },\n {\n \"id\": \"14242\",\n \"name\": \"HU-GSS1 -\",\n },\n {\n \"id\": \"14243\",\n \"name\": \"HU-GSS2 -\",\n },\n {\n \"id\": \"5160\",\n \"name\": \"International Falls Enrollment Center - 312 Highway 11 East International Falls MN 56649 US\",\n },\n {\n \"id\": \"14181\",\n \"name\": \"International Falls Global Entry Enrollment Center - 312 Highway 11 East International Falls MN 56649\",\n },\n {\n \"id\": \"5140\",\n \"name\": \"JFK International Global Entry EC - JFK International Airport Terminal 4 IAT Jamaica NY 11430 US\",\n },\n {\n \"id\": \"12781\",\n \"name\": \"Kansas City Enrollment Center - 90 Beirut Circle Terminal C Gate 90 Kansas City MO 64153 US\",\n },\n {\n \"id\": \"5520\",\n \"name\": \"Lansdowne ON - 664 Highway 137 Hill Island Lansdowne ON K0E1L0 CA\",\n },\n {\n \"id\": \"5004\",\n \"name\": \"Laredo Enrollment Center - 0 Lincoln Juarez Bridge Bldg.2 Laredo TX 780443130 US\",\n },\n {\n \"id\": \"5360\",\n \"name\": \"Las Vegas Enrollment Center - 5757 Wayne Newton Blvd Terminal 3 Las Vegas NV 89119 US\",\n },\n {\n \"id\": \"14561\",\n \"name\": \"LMT2017 -\",\n },\n {\n \"id\": \"13561\",\n \"name\": \"London - US Embassy - 24 Grosvenor Square US Embassy London W1A 2LQ GB\",\n },\n {\n \"id\": \"8920\",\n \"name\": \"Los Angeles -Long Beach Seaport - 301 E. Ocean Blvd Room 805 Long Beach CA 90802 US\",\n },\n {\n \"id\": \"5180\",\n \"name\": \"Los Angeles International Global Entry EC - 380 World Way Tom Bradley International Terminal Los Angeles\",\n },\n {\n \"id\": \"13621\",\n \"name\": \"Memphis International Airport Global Enrollment Ce - 2491 Winchester Suite 230 Memphis TN 38116 US\",\n },\n {\n \"id\": \"5181\",\n \"name\": \"Miami International Global Entry EC - 4200 NW 21st Street Miami International Airport Conc. \\\"J\\\" Miami\",\n },\n {\n \"id\": \"7740\",\n \"name\": \"Milwaukee Enrollment Center - 4915 S Howell Ave. 2nd floor Milwaukee WI 53207 US\",\n },\n {\n \"id\": \"6840\",\n \"name\": \"Minneapolis - St. Paul Global Entry EC - 4300 Glumack Drive St. Paul MN 55111 US\",\n },\n {\n \"id\": \"11000\",\n \"name\":\n \"Moline Quad Cities International Airport - 3300 69th Ave Quad Cities International Airport Moline IL 61265\",\n },\n {\n \"id\": \"5028\",\n \"name\": \"Montreal Enrollment Center - 1 Pierre E Trudeau International Airport 975 Blvd Romeo Vachon. Room T1476\",\n },\n {\n \"id\": \"10260\",\n \"name\": \"Nashville Enrollment Center - 612 Hangar Lane Suite 114 Nashville TN 37217 US\",\n },\n {\n \"id\": \"9740\",\n \"name\": \"New Orleans Enrollment Center - 900 Airline Drive Kenner LA 70062 US\",\n },\n {\n \"id\": \"5444\",\n \"name\":\n \"Newark Global Entry Enrollment Center - Newark Liberty International Airport Terminal B - International Arrivals Area\",\n },\n {\n \"id\": \"5161\",\n \"name\": \"Niagara Falls Enrollment Center - 2250 WHIRLPOOL ST. NIAGARA FALLS NY 14305 US\",\n },\n {\n \"id\": \"14401\",\n \"name\": \"NIKE2017 -\",\n },\n {\n \"id\": \"5007\",\n \"name\": \"Nogales Enrollment Center - 9 N. GRAND AVENUE NOGALES AZ 85621 US\",\n },\n {\n \"id\": \"5380\",\n \"name\": \"Orlando Global Entry Enrollment Center - 1 Orlando International Airport Airport Blvd Orlando FL 32827\",\n },\n {\n \"id\": \"5025\",\n \"name\": \"Ottawa Enrollment Center - 140 Thad Johnson Private Suite 102 Ottawa Cargo Services Ottawa ON K1V0R4\",\n },\n {\n \"id\": \"5100\",\n \"name\": \"Pembina Enrollment Center - 10980 Interstate 29 N Pembina ND 58271 US\",\n },\n {\n \"id\": \"11002\",\n \"name\": \"Peoria International Airport - 5701 W. Smithville Road Suite 700 Bartonville IL 61607 US\",\n },\n {\n \"id\": \"5445\",\n \"name\":\n \"Philadelphia Global Entry Enrollment Center - PHILADELPHIA INTL AIRPORT TERMINAL A WEST 3RD FLOOR PHILADELPHIA\",\n },\n {\n \"id\": \"7160\",\n \"name\": \"Phoenix Sky Harbor Global Entry Enrollment Center - CBP-Global Enrollment Center 3400 E. Sky Harbor Blvd\",\n },\n {\n \"id\": \"9200\",\n \"name\": \"Pittsburgh International Airport - 1000 Airport Boulevard Ticketing Level Pittsburgh PA 15231 US\",\n },\n {\n \"id\": \"11841\",\n \"name\": \"Port Clinton Ohio Enrollment Center - 709 S.E. Catawba Road Port Clinton OH 43452 US\",\n },\n {\n \"id\": \"5024\",\n \"name\": \"Port Huron Enrollment Center - 2321 NEXUS Enrollment Center Pine Grove Ave. Port Huron MI 48060 US\",\n },\n {\n \"id\": \"7960\",\n \"name\": \"Portland OR Enrollment Center - 7000 PDX AIRPORT Room T3352 Portland OR 97218 US\",\n },\n {\n \"id\": \"14261\",\n \"name\": \"RGBOS2017 -\",\n },\n {\n \"id\": \"11001\",\n \"name\": \"Rockford-Chicago International Airport - 50 Airport Drive Chicago Rockford International Airport Rockford\",\n },\n {\n \"id\": \"13981\",\n \"name\": \"RTAA Board -\",\n },\n {\n \"id\": \"7600\",\n \"name\":\n \"Salt Lake City International Airport - 3850 West Terminal Dr International Arrivals Terminal Salt Lake City\",\n },\n {\n \"id\": \"7520\",\n \"name\": \"San Antonio International Airport - 9800 Airport Boulevard Suite 1101 San Antonio TX 78216 US\",\n },\n {\n \"id\": \"5002\",\n \"name\": \"San Diego -Otay Mesa Enrollment Center - 2500 Paseo Internacional San Diego CA 92154 US\",\n },\n {\n \"id\": \"13541\",\n \"name\": \"San Diego International Airport - 3707 N Harbor Drive San Diego CA 92101 US\",\n },\n {\n \"id\": \"5446\",\n \"name\": \"San Francisco Global Entry Enrollment Center - San Francisco International Airport San Francisco CA 94128\",\n },\n {\n \"id\": \"5400\",\n \"name\": \"San Juan Global Entry Enrollment Center - Luis Munoz Marin Int'l Airport Carolina PR 00937 US\",\n },\n {\n \"id\": \"5460\",\n \"name\": \"San Luis Enrollment Center - 0 SLU II Global Enrollment Center 1375 South Avenue E San Luis AZ 85349\",\n },\n {\n \"id\": \"8060\",\n \"name\": \"San Ysidro Enrollment Center - 405 VIRGINIA AVE SAN YSIDRO CA 92173 US\",\n },\n {\n \"id\": \"5447\",\n \"name\": \"Sanford Global Entry Enrollment Center - 1100 Red Cleveland Blvd Sanford FL 32773 US\",\n },\n {\n \"id\": \"5080\",\n \"name\": \"Sault Ste Marie Enrollment Center - 900 International Bridge Plaza Sault Ste. Marie MI 49783 US\",\n },\n {\n \"id\": \"5420\",\n \"name\":\n \"SeaTac International Airport Global Entry EC - CBP Global Entry Office SeaTac International Airport Seattle\",\n },\n {\n \"id\": \"5040\",\n \"name\":\n \"Seattle Urban Enrollment Center - 7277 PERIMETER ROAD SOUTH RM 116 KING COUNTY INTERNATIONAL AIRPORT BOEING FIELD\",\n },\n {\n \"id\": \"9040\",\n \"name\": \"Singapore U.S. Embassy - U.S. Embassy 27 Napier Road Singapore SG\",\n },\n {\n \"id\": \"12021\",\n \"name\": \"St. Louis Enrollment Center - 10701 Lambert Intl Blvd Terminal 2 St. Louis MO 63145 US\",\n },\n {\n \"id\": \"5120\",\n \"name\": \"Sweetgrass Enrollment Center - 39825 FAST Enrollment Center 39825 Interstate 15 North Sweetgrass MT 59484\",\n },\n {\n \"id\": \"8020\",\n \"name\": \"Tampa Enrollment Center - Tampa International Airport 4100 George J Bean Outbound Pkwy Tampa FL 33607\",\n },\n {\n \"id\": \"5027\",\n \"name\": \"Toronto Enrollment Center - 6301 Silver Dart Drive Terminal One-Depatures Level Mississauga ON L5P1B2\",\n },\n {\n \"id\": \"12421\",\n \"name\":\n \"Toronto Enrollment Center AESC - 2935 Convair Drive Airport Emergency Support Centre Mississauga ON L5P1B2\",\n },\n {\n \"id\": \"14143\",\n \"name\": \"Travel AAA - 10220 Regency Circle Marriott Regency Hotel Omaha NE 68114 US\",\n },\n {\n \"id\": \"14142\",\n \"name\": \"Travel and Transport - 16950 Wright Plaza Suite 151 Travel Design Lounge by Travel and Transport\",\n },\n {\n \"id\": \"9240\",\n \"name\": \"Tucson Enrollment Center - 7150 S. Tucson Blvd Tucson AZ 85756 US\",\n },\n {\n \"id\": \"6480\",\n \"name\": \"U.S. Custom House - Bowling Green - 1 BOWLING GREEN NEW YORK NY 10004 US\",\n },\n {\n \"id\": \"5026\",\n \"name\":\n \"Vancouver Enrollment Center - 3211 Grant McConachie Way Vancouver International Airport Richmond BC V7B1Y9\",\n },\n {\n \"id\": \"5041\",\n \"name\": \"Vancouver Urban Enrollment Center - 1611 Main Street 4th Floor VANCOUVER BC V6A2W5 CA\",\n },\n {\n \"id\": \"5060\",\n \"name\": \"Warroad Enrollment Center - 41059 Warroad Enrollment Center State Hwy 313 N Warroad MN 56763 US\",\n },\n {\n \"id\": \"9300\",\n \"name\": \"Warwick RI Enrollment Center - Warwick RI Enrollment Center 300 Jefferson Boulevard Suite 106 Warwick\",\n },\n {\n \"id\": \"5142\",\n \"name\":\n \"Washington Dulles International Global Entry EC - 22685 International Arrivals- Main Terminal Washington Dulles International Airport\",\n },\n {\n \"id\": \"8120\",\n \"name\": \"Washington DC Enrollment Center - 1300 Pennsylvania Avenue NW Washington DC 20229 US\",\n },\n {\n \"id\": \"9260\",\n \"name\":\n \"West Palm Beach Enrollment Center - West Palm Beach Enrollment Center 1 East 11th Street Third Floor Riviera Beach\",\n },\n {\n \"id\": \"5029\",\n \"name\": \"Winnipeg Enrollment Center - 1970 Winnipeg NEXUS Office Wellington Room 1074 Winnipeg MB R3H0E3 CA\",\n },\n];\n\nfor (const location of locations) {\n await sqlite.execute({\n sql: `INSERT OR REPLACE into locations(id, name) values (:id, :name)`,\n args: { id: location.id, name: location.name },\n });\n}","fileType","script",4,"parentId","createdAt",["D",1746314269252],"branchVersion",32,"label",[20],{"_34":94,"_13":95,"_38":96,"_45":-5,"_36":37,"_48":97,"_57":61,"_46":98,"_17":99,"_42":25,"_40":100,"_60":61,"_50":-5,"_62":101,"_19":102},{"_34":85,"_13":86,"_38":87,"_45":-5,"_36":37,"_48":88,"_57":58,"_46":89,"_17":90,"_42":43,"_40":91,"_60":61,"_50":-5,"_62":92,"_19":93},{"_34":75,"_13":76,"_38":77,"_45":-5,"_36":37,"_48":78,"_57":61,"_46":79,"_17":80,"_42":81,"_40":82,"_60":61,"_50":-5,"_62":83,"_19":84},{"_34":65,"_13":66,"_38":67,"_45":-5,"_36":37,"_48":18,"_57":61,"_46":68,"_17":69,"_42":70,"_40":71,"_60":61,"_50":72,"_62":73,"_19":74},{"_34":35,"_13":20,"_38":39,"_45":-5,"_36":37,"_48":49,"_57":58,"_46":59,"_17":44,"_42":43,"_40":41,"_60":61,"_50":-5,"_62":63,"_19":64},"latest",true,["D",1746314269252],"deleted",false,"children",[],[20],"dd59caf8-2881-11f0-a7a9-569c3dd06744","http.tsx","8229c52a-275a-11f0-bd43-569c3dd06744",["D",1746319867794],27,"http","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport { renderToString } from \"npm:react-dom@18.2.0/server\";\n\nconst result = await sqlite.execute(`select id, name from locations ORDER BY name`);\n\nconst locations: { id: number; name: string }[] = result.rows.map(row =>\n Object.fromEntries(row.map((value, index) => [result.columns[index], value])) as any\n);\n\nexport default async function httpHandler(req: Request): Promise {\n if (req.method !== \"POST\") {\n // allow seeing what appts are set up for a user\n // eg. https://globalentryapptchecker.val.run/?email=username@example.com\n const appts = [];\n const searchParams = new URL(req.url).searchParams;\n const params = Object.fromEntries(searchParams.entries());\n if (params && params.email) {\n const result = await sqlite.execute({\n sql: `select location, start_date, end_date from appointments where email = :email`,\n args: { email: params.email },\n });\n const appts: { location: string; start_date: string; end_date: string }[] = result.rows.map(row =>\n Object.fromEntries(row.map((value, index) => [result.columns[index], value])) as any\n );\n return Response.json(appts);\n }\n\n return new Response(getFormHtml(), {\n headers: {\n \"Content-Type\": \"text/html\",\n },\n });\n } else {\n const data = await req.formData();\n const email = data.get(\"email\") as string;\n const startDate = data.get(\"startDate\") as string;\n const endDate = data.get(\"endDate\") as string;\n const location = data.get(\"location\") as string;\n console.log(email, startDate, endDate, location);\n\n if (email === \"\") {\n return new Response(getFormHtml([\"Email is required\"]), {\n headers: {\n \"Content-Type\": \"text/html\",\n },\n });\n }\n\n await sqlite.execute(`create table if not exists appointments (\n email text not null,\n start_date text,\n end_date text,\n location integer\n)`);\n\n await sqlite.execute({\n sql:\n `insert into appointments(email, start_date, end_date, location) values (:email, :startDate, :endDate, :location)`,\n args: { email: email, startDate: startDate, endDate: endDate, location: location },\n });\n return new Response(getSubmittedFormHtml(), {\n headers: {\n \"Content-Type\": \"text/html\",\n },\n });\n }\n}\n\nfunction getFormHtml(errors?: string[]): string {\n return renderToString(\n \n \n \n \n \n Global Entry Appointment Checker\n \n \n

Global Entry Appointment Checker

\n Sorry, this only works on the Val Town Pro plan. As is, it will only email the user who owns the val.\n \n Fork this Val\n {\" \"}\n to use it.\n

\n Enter an email address, pick your location(s), and select a date range. Every 20 minutes we will check for\n available appts and send you an email if any are available.\n

\n\n {errors?.map((error) =>

{error}

)}\n \n \n ,\n );\n}\n\nfunction getSubmittedFormHtml(): string {\n return renderToString(\n \n \n \n \n \n Global Entry Appointment Checker\n \n \n

Global Entry Appointment Checker

\n Your request was submitted. Unfortunately, because I'm not on the Val Town Pro plan, all emails are sent to\n me.\n

\n Back\n

\n \n ,\n );\n}","globalentryapptchecker",[],[66],"4048b0a4-287b-11f0-9147-569c3dd06744","cron.tsx","822cd9ea-275a-11f0-bd43-569c3dd06744",51,["D",1746317027277],20,"interval","import { email } from \"https://esm.town/v/std/email?v=13\";\nimport { fetch } from \"https://esm.town/v/std/fetch\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\n\nexport async function scheduledHandler() {\n // first clean up any old appointments\n await sqlite.execute(`delete from appointments where end_date < date() OR location is null`);\n\n // then check for new appointments\n const result = await sqlite.execute(\n `select email, location, start_date, end_date from appointments where end_date > date() and location is not null`,\n );\n const rows: { email: string; location: number; start_date: string; end_date: string }[] = result.rows.map(row =>\n Object.fromEntries(row.map((value, index) => [result.columns[index], value])) as any\n );\n\n const locationsResult = await sqlite.execute(`select id, name from locations ORDER BY name`);\n\n const locations: { id: number; name: string }[] = locationsResult.rows.map(row =>\n Object.fromEntries(row.map((value, index) => [locationsResult.columns[index], value])) as any\n );\n\n const formatter = new Intl.DateTimeFormat(\"en-US\", {\n dateStyle: \"full\",\n timeStyle: \"short\",\n });\n\n // console.log(rows);\n for (const row of rows) {\n // if start date is before today, use today as start date\n if (new Date(row.start_date) < new Date()) {\n row.start_date = new Date().toISOString().split(\"T\")[0];\n }\n // console.log(\"checking for appointments in \" + row.location + \" between \" + row.start_date + \" and \" + row.end_date);\n\n let result = await fetch(\n `https://ttp.cbp.dhs.gov/schedulerapi/locations/${row.location}/slots?startTimestamp=${row.start_date}T00:00:00&endTimestamp=${row.end_date}T00:00:00`,\n );\n let json = await result.json();\n const activeSlots = json.filter((slot: any) => slot.active === 1);\n\n const locationName = locations.find(location => location.id === row.location)?.name ?? \"unknown\";\n\n // console.log(json);\n if (activeSlots.length > 0) {\n console.log(\"sending email to \" + row.email);\n const body = `Global Entry Appointments Available at ${locationName} at the following times:\\n ${\n activeSlots.map((slot: any) => formatter.format(new Date(slot.timestamp))).join(\",\\n \")\n }`;\n\n await email({\n // to: row.email,\n subject: `Global Entry Appointments available at ${locationName}`,\n text: body,\n });\n } else {\n console.log(`no appointments available for ${locationName} during ${row.start_date} to ${row.end_date}`);\n }\n }\n console.log(\"done\");\n}",[],[76],"7a30f8b2-287b-11f0-a766-569c3dd06744","cleanup.tsx","4a18880c-287b-11f0-a180-569c3dd06744",55,["D",1746317124451],3,"import { sqlite } from \"https://esm.town/v/std/sqlite\";\n\n// delete all appointments\nawait sqlite.execute(`delete from appointments`);",[],[86],"1aefe5ec-2881-11f0-a374-569c3dd06744","README.md","8222e19c-275a-11f0-bd43-569c3dd06744",65,["D",1746319541620],6,"# Global Entry Appointment Checker\n\nGlobal Entry doesn't have many appointments available these days, and it's a pain to check constantly to see if any have opened up. \n\nThis script lets you sign up to receive an email if any slots open up at locations you are interested. It will check the location you pick every twenty seconds.\n\nInspired by https://github.com/TobiKr/GlobalEntryAppointmentChecker\n\n## Usage\n\n~~Visit https://globalentryapptchecker.val.run/ and fill in the details. You can sign up multiple times.~~\n\nUntil I pony up for Val Town Pro, this can only send emails to me. So to use, fork this project and run webpage in your own fork.\n\n## Development\n\n`http` contains the logic for the website. `cron` contains the job that sends the emails. `locations` generates the locations table data. Use `cleanup` to erase all submitted appointments.\n\nTo see all the appts for a certain email address, go to:\n\nhttps://globalentryapptchecker.val.run/?email=username@example.com",[],[95],"82211e7a-275a-11f0-bd43-569c3dd06744",["D",1746193013221],"deletedAt","legacyEnvVars","privacy","public","description","Emails you when global entry appointments are available","imageUrl","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/4a63de04-28fb-4622-0bde-4e35c5069d00/square512","userId","7cda5a30-275a-11f0-a049-f3a9b7a94124","pinnedFileId","pinPreview","pinMigrated","screenshotVersion",82,"likeCount",0,"orgId","c37a85fe-8e69-4626-880f-8320700f0b43","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_156":153},"org",{"_11":12,"_152":153,"_113":114,"_154":155},"branch",{"_17":119,"_13":16,"_34":37,"_144":103,"_145":-5,"_146":-5,"_147":-5,"_148":-5,"_149":-5,"_150":14,"_151":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yd1hma3ZiSng2WWxGZm43QW1GSGFWQW5DNVEifQ","tier","free","profileImageUrl",{"_34":103,"_13":14,"_46":198,"_105":-5,"_106":61,"_107":108,"_109":110,"_111":112,"_113":114,"_115":67,"_116":58,"_117":-5,"_118":119,"_120":121,"_122":123,"_124":-5,"_125":-5,"_126":-5,"_127":-5,"_128":129,"_130":129,"_131":132,"_133":132,"_134":132,"_135":129,"_136":129,"_137":199,"_139":200,"_141":201,"_143":61},[183,184,185,186,187],"files",[183,184,185,186,187],"counts",{"_173":121,"_174":175,"_176":121,"_33":177,"_178":179},[],{"_34":35,"_13":20,"_38":39,"_45":-5,"_36":37,"_48":49,"_57":58,"_46":171,"_17":44,"_42":43,"_40":41,"_60":61,"_50":-5,"_19":172},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"navCollapsed",["D",1746314269252],[20],"pulls","branches",1,"forks",{"_180":121,"_182":121},"connections",{"_180":121,"_181":121},"count","unfilledCount","emptyCount",{"_34":94,"_13":95,"_38":96,"_45":-5,"_36":37,"_48":97,"_57":61,"_46":98,"_17":99,"_42":25,"_40":100,"_60":61,"_50":-5,"_62":196,"_19":197},{"_34":85,"_13":86,"_38":87,"_45":-5,"_36":37,"_48":88,"_57":58,"_46":89,"_17":90,"_42":43,"_40":91,"_60":61,"_50":-5,"_62":194,"_19":195},{"_34":75,"_13":76,"_38":77,"_45":-5,"_36":37,"_48":78,"_57":61,"_46":79,"_17":80,"_42":81,"_40":82,"_60":61,"_50":-5,"_62":192,"_19":193},{"_34":65,"_13":66,"_38":67,"_45":-5,"_36":37,"_48":18,"_57":61,"_46":68,"_17":69,"_42":70,"_40":71,"_60":61,"_50":72,"_62":190,"_19":191},{"_34":35,"_13":20,"_38":39,"_45":-5,"_36":37,"_48":49,"_57":58,"_46":59,"_17":44,"_42":43,"_40":41,"_60":61,"_50":-5,"_62":188,"_19":189},[],[20],[],[66],[],[76],[],[86],[],[95],["D",1746193013221],{"_11":12,"_156":153},{"_11":12,"_152":153,"_113":114,"_154":155},{"_17":119,"_13":16,"_34":37,"_144":103,"_145":-5,"_146":-5,"_147":-5,"_148":-5,"_149":-5,"_150":14,"_151":12},"ctx",{"_137":-5,"_235":236,"_237":238,"_239":61,"_240":61,"_241":61,"_242":-5,"_243":-7,"_244":-7,"_245":121,"_246":61,"_247":61,"_248":-5,"_249":61,"_250":61},"ENV",{"_206":207,"_208":209,"_210":211,"_212":16,"_213":214,"_215":216,"_217":218,"_219":220,"_221":222,"_223":224,"_225":226,"_227":228,"_229":230,"_231":232,"_233":234},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","f1316bb1ce3ad41ce227a17bcad7725ad044419f","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","API_URL","https://api.val.town","preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier"]