[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_642":643,"_644":645},"routes/_app.x.$handle.$name",{"_99":98,"_32":46,"_107":89,"_27":108,"_13":14,"_109":-5,"_11":110,"_111":112,"_113":114,"_115":116,"_117":118,"_20":-5,"_119":-5,"_120":-5,"_121":25,"_122":123,"_124":60,"_125":-5,"_126":-5,"_127":128},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_44":45,"_32":46,"_39":47,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":54,"_55":-5,"_18":56,"_57":58,"_59":60,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":-5,"_69":-5,"_70":-5,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":82,"_83":84,"_85":86,"_87":25},"version",126,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":35,"_36":38,"_39":40,"_41":14,"_42":43,"_24":25},"previous",{"_30":31,"_32":33,"_34":35,"_36":37},"deleted",false,"deletedHere","path","frontend/components/HomePage.tsx","latestPath","fileId","6732b59e-1d26-11f0-b330-569c3dd06744","name","HomePage.tsx","fileType","script","content","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\n\ninterface Item {\n id: number;\n name: string;\n price: number;\n description: string;\n image: string;\n buyUrl: string;\n}\n\nexport function HomePage() {\n const [item, setItem] = useState(null);\n const [loading, setLoading] = useState(true);\n\n useEffect(() => {\n async function fetchItem() {\n try {\n const response = await fetch('/api/items');\n if (response.ok) {\n const data = await response.json();\n setItem(data);\n }\n } catch (error) {\n console.error('Error fetching item:', error);\n } finally {\n setLoading(false);\n }\n }\n\n fetchItem();\n }, []);\n\n if (loading) {\n return

;\n }\n\n if (!item) {\n return

No items available

;\n }\n\n const InfoText = ({ text }: { text: string }) => (\n

{text}

\n );\n\n return (\n

\n \n

{item.name}

${(item.price / 100).toFixed(2)}

\n\n

\n \n \n \n \n \n \n

\n\n \n Reserve an iClicker today!\n \n

\n );\n}","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\n\ninterface Item {\n id: number;\n name: string;\n price: number;\n description: string;\n image: string;\n buyUrl: string;\n}\n\n// Default item to use if API fails\nconst DEFAULT_ITEM: Item = {\n id: 1,\n name: \"iClicker\",\n price: 4500, // $45.00\n description: \"iClicker for CWRU classes\",\n image: \"https://placehold.co/200x200?text=iClicker\",\n buyUrl: \"\"\n};\n\nexport function HomePage() {\n const [item, setItem] = useState(null);\n const [loading, setLoading] = useState(true);\n const [error, setError] = useState(\"\");\n\n useEffect(() => {\n async function fetchItem() {\n try {\n const response = await fetch('/api/items');\n if (response.ok) {\n const data = await response.json();\n setItem(data);\n } else {\n // If API fails, use default item\n console.warn(\"Using default item data because API returned an error\");\n setItem(DEFAULT_ITEM);\n \n // Get error message\n try {\n const errorData = await response.json();\n setError(errorData.error || \"Failed to load item data\");\n } catch {\n setError(\"Failed to load item data\");\n }\n }\n } catch (error) {\n console.error('Error fetching item:', error);\n setItem(DEFAULT_ITEM);\n setError(\"Failed to connect to the server. Using default item data.\");\n } finally {\n setLoading(false);\n }\n }\n\n fetchItem();\n }, []);\n\n if (loading) {\n return

;\n }\n\n if (!item) {\n return (\n

Error Loading Product

{error || \"No items available\"}

Please try again later or contact support.

\n );\n }\n\n const InfoText = ({ text }: { text: string }) => (\n

{text}

\n );\n\n return (\n

\n {error && (\n

Note:

{error}

\n )}\n \n

\n \n

{item.name}

${(item.price / 100).toFixed(2)}

\n\n

\n \n \n \n \n \n \n

\n\n \n Reserve an iClicker today!\n \n

\n );\n}","createdAt",["D",1745071437596],"branchVersion","branchId","0a147088-1d25-11f0-9565-569c3dd06744","id","0a13eeec-1d25-11f0-9565-569c3dd06744","iClickWolf",["D",1745070536853],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Starter template with client-side React & Hono server","imageUrl","4555dd0e-707e-4444-acd3-049d206eb1db","pinnedFileId","0a4ebd1a-1d25-11f0-9565-569c3dd06744","pinPreview",true,"pinMigrated","screenshotVersion",165,"likeCount",0,"orgId","bced381e-9ab2-4b55-929d-e7c5064f7f38","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_99":98,"_106":102},"org",{"_99":98,"_100":-5,"_101":102,"_18":56,"_103":104,"_105":25},"branch",{"_13":88,"_32":89,"_44":43,"_90":45,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":46,"_97":98},"isOwned",177,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","wolf","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJvVXpPVUZRTjZGTGd2Q2t4c0RRdFpNZWJ5UCJ9","tier","pro","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_44":45,"_32":46,"_39":638,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":54,"_55":-5,"_18":56,"_57":58,"_59":60,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":-5,"_69":-5,"_70":-5,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":639,"_83":640,"_85":641,"_87":25},"tree",[188,198,207,241,242,243],"files",[188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243],"counts",{"_177":65,"_178":150,"_179":65,"_180":181,"_182":183},"contents",[129,130,131,132,133,134],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_44":172,"_32":173,"_30":174,"_138":-5,"_42":43,"_41":150,"_140":60,"_39":175,"_13":65,"_34":164,"_36":-5,"_24":25,"_143":-5,"_27":176},{"_44":166,"_32":167,"_30":168,"_138":-5,"_42":43,"_41":169,"_140":60,"_39":170,"_13":65,"_34":164,"_36":-5,"_24":25,"_143":-5,"_27":171},{"_44":159,"_32":160,"_30":161,"_138":-5,"_42":43,"_41":162,"_140":25,"_39":163,"_13":65,"_34":164,"_36":-5,"_24":25,"_143":-5,"_27":165},{"_44":153,"_32":154,"_30":155,"_138":-5,"_42":43,"_41":156,"_140":60,"_39":157,"_13":65,"_34":20,"_36":108,"_24":25,"_143":-5,"_27":158},{"_44":145,"_32":146,"_30":147,"_138":-5,"_42":43,"_41":148,"_140":25,"_39":149,"_13":150,"_34":20,"_36":151,"_24":25,"_143":-5,"_27":152},{"_44":135,"_32":136,"_30":137,"_138":-5,"_42":43,"_41":139,"_140":25,"_39":141,"_13":65,"_34":20,"_36":142,"_24":25,"_143":-5,"_27":144},"460279d2-1d25-11f0-8fe3-569c3dd06744","deno.json","46027a5e-1d25-11f0-8fe3-569c3dd06744","parentId",48,"latest",["D",1745070637386],"{\n \"$schema\": \"https://raw.githubusercontent.com/denoland/deno/348900b8b79f4a434cab4c74b3bc8d4d2fa8ee74/cli/schemas/config-file.v1.json\",\n \"lock\": false,\n \"compilerOptions\": {\n \"noImplicitAny\": false,\n \"strict\": false,\n \"types\": [\n \"https://www.val.town/types/valtown.d.ts\"\n ],\n \"lib\": [\n \"dom\",\n \"dom.iterable\",\n \"dom.asynciterable\",\n \"deno.ns\",\n \"deno.unstable\"\n ]\n },\n \"lint\": {\n \"files\": {\n \"include\": [\n \"deno:/https/esm.town/**/*\"\n ]\n },\n \"rules\": {\n \"exclude\": [\n \"no-explicit-any\"\n ]\n }\n },\n \"node_modules_dir\": false,\n \"experimental\": {\n \"unstable-node-globals\": true,\n \"unstable-temporal\": true,\n \"unstable-worker-options\": true,\n \"unstable-sloppy-imports\": true\n }\n}","label",[136],"d21e08b8-1d26-11f0-a00f-569c3dd06744","README.md","0a5d5960-1d25-11f0-b3df-569c3dd06744",122,["D",1745071301954],1,"# iClickWolf - Val Town Edition\n\nThis app is a port of the iClickWolf Next.js application to Val Town, using SQLite for database storage.\n\n## Project Structure\n\n- **Backend**: `/backend/index.ts` - The main HTTP server that serves the frontend and API endpoints\n - `/backend/database/` - Contains SQLite database setup and queries\n - `/backend/routes/` - API routes for checkout, webhook, and items\n\n- **Frontend**: `/frontend/index.html` - The main HTML entry point\n - `/frontend/index.tsx` - The React entry point\n - `/frontend/components/` - React components for the application\n\n## Features\n\n- iClicker preordering system\n- Stripe integration for payments\n- Email notifications for order confirmations\n- SQLite database for storing items and preorders\n\n## Environment Variables\n\nThe following environment variables are required:\n\n- `STRIPE_SECRET` - Stripe API secret key\n- `STRIPE_PUBLIC` - Stripe publishable key (for frontend)\n- `STRIPE_WEBHOOK_SECRET` - Secret for verifying Stripe webhook events\n- `VAL_EMAIL_KEY` - API key for the email sending service\n\n## Database\n\nThe application uses Val Town's SQLite database with the following tables:\n\n- `iclickwolf_items_v1` - Stores product information\n- `iclickwolf_preorders_v1` - Stores customer preorder information\n\n## API Endpoints\n\n- `POST /api/checkout` - Creates a Stripe checkout session and preorder\n- `POST /api/webhook` - Handles Stripe webhook events\n- `GET /api/items` - Returns the first item (iClicker)",[146],"808049a4-1d25-11f0-8967-569c3dd06744",".vtignore","80804a3a-1d25-11f0-8967-569c3dd06744",95,["D",1745070735006],[154],"44a65482-1d25-11f0-8f40-569c3dd06744","iclickwolf-old","44a6550e-1d25-11f0-8f40-569c3dd06744",10,["D",1745070635115],"directory",[160],"0a37adfa-1d25-11f0-99f3-569c3dd06744","frontend","0a37aeb8-1d25-11f0-99f3-569c3dd06744",2,["D",1745070537083],[167],"0a2db408-1d25-11f0-99f3-569c3dd06744","backend","0a2db49e-1d25-11f0-99f3-569c3dd06744",["D",1745070537017],[173],"pulls","branches","forks","envVars",{"_184":186,"_187":65},"connections",{"_184":65,"_185":65},"count","unfilledCount",3,"emptyCount",{"_44":172,"_32":173,"_30":174,"_138":-5,"_42":43,"_41":150,"_140":60,"_39":635,"_13":65,"_34":164,"_36":-5,"_24":25,"_143":-5,"_245":636,"_27":637},{"_44":630,"_32":614,"_30":608,"_138":174,"_42":43,"_41":631,"_140":60,"_39":632,"_13":65,"_34":164,"_36":-5,"_24":25,"_143":-5,"_245":633,"_27":634},{"_44":623,"_32":146,"_30":624,"_138":608,"_42":43,"_41":625,"_140":25,"_39":626,"_13":65,"_34":20,"_36":627,"_24":25,"_143":-5,"_245":628,"_27":629},{"_44":615,"_32":616,"_30":617,"_138":608,"_42":43,"_41":618,"_140":25,"_39":619,"_13":186,"_34":35,"_36":620,"_24":25,"_143":-5,"_245":621,"_27":622},{"_44":605,"_32":606,"_30":607,"_138":608,"_42":43,"_41":609,"_140":25,"_39":610,"_13":65,"_34":35,"_36":611,"_24":25,"_143":-5,"_245":612,"_27":613},{"_44":600,"_32":583,"_30":577,"_138":174,"_42":43,"_41":601,"_140":60,"_39":602,"_13":65,"_34":164,"_36":-5,"_24":25,"_143":-5,"_245":603,"_27":604},{"_44":592,"_32":593,"_30":594,"_138":577,"_42":43,"_41":595,"_140":25,"_39":596,"_13":150,"_34":35,"_36":597,"_24":25,"_143":-5,"_245":598,"_27":599},{"_44":584,"_32":585,"_30":586,"_138":577,"_42":43,"_41":587,"_140":25,"_39":588,"_13":65,"_34":35,"_36":589,"_24":25,"_143":-5,"_245":590,"_27":591},{"_44":574,"_32":575,"_30":576,"_138":577,"_42":43,"_41":578,"_140":25,"_39":579,"_13":150,"_34":35,"_36":580,"_24":25,"_143":-5,"_245":581,"_27":582},{"_44":565,"_32":566,"_30":58,"_138":174,"_42":43,"_41":567,"_140":25,"_39":568,"_13":186,"_34":569,"_36":570,"_24":25,"_143":571,"_245":572,"_27":573},{"_44":166,"_32":167,"_30":168,"_138":-5,"_42":43,"_41":169,"_140":60,"_39":562,"_13":65,"_34":164,"_36":-5,"_24":25,"_143":-5,"_245":563,"_27":564},{"_44":558,"_32":351,"_30":524,"_138":168,"_42":43,"_41":186,"_140":60,"_39":559,"_13":65,"_34":164,"_36":-5,"_24":25,"_143":-5,"_245":560,"_27":561},{"_44":550,"_32":551,"_30":552,"_138":524,"_42":43,"_41":553,"_140":25,"_39":554,"_13":150,"_34":35,"_36":555,"_24":25,"_143":-5,"_245":556,"_27":557},{"_44":542,"_32":543,"_30":544,"_138":524,"_42":43,"_41":545,"_140":25,"_39":546,"_13":65,"_34":35,"_36":547,"_24":25,"_143":-5,"_245":548,"_27":549},{"_44":538,"_32":33,"_30":31,"_138":524,"_42":43,"_41":14,"_140":25,"_39":539,"_13":150,"_34":35,"_36":38,"_24":25,"_143":-5,"_245":540,"_27":541},{"_44":530,"_32":531,"_30":532,"_138":524,"_42":43,"_41":533,"_140":25,"_39":534,"_13":150,"_34":35,"_36":535,"_24":25,"_143":-5,"_245":536,"_27":537},{"_44":521,"_32":522,"_30":523,"_138":524,"_42":43,"_41":525,"_140":25,"_39":526,"_13":65,"_34":35,"_36":527,"_24":25,"_143":-5,"_245":528,"_27":529},{"_44":513,"_32":514,"_30":515,"_138":168,"_42":43,"_41":516,"_140":25,"_39":517,"_13":150,"_34":20,"_36":518,"_24":25,"_143":-5,"_245":519,"_27":520},{"_44":505,"_32":506,"_30":507,"_138":168,"_42":43,"_41":508,"_140":25,"_39":509,"_13":65,"_34":35,"_36":510,"_24":25,"_143":-5,"_245":511,"_27":512},{"_44":159,"_32":160,"_30":161,"_138":-5,"_42":43,"_41":162,"_140":25,"_39":502,"_13":65,"_34":164,"_36":-5,"_24":25,"_143":-5,"_245":503,"_27":504},{"_44":497,"_32":318,"_30":312,"_138":161,"_42":43,"_41":498,"_140":25,"_39":499,"_13":65,"_34":164,"_36":-5,"_24":25,"_143":-5,"_245":500,"_27":501},{"_44":492,"_32":374,"_30":368,"_138":312,"_42":43,"_41":493,"_140":25,"_39":494,"_13":65,"_34":164,"_36":-5,"_24":25,"_143":-5,"_245":495,"_27":496},{"_44":487,"_32":465,"_30":482,"_138":368,"_42":43,"_41":488,"_140":25,"_39":489,"_13":65,"_34":164,"_36":-5,"_24":25,"_143":-5,"_245":490,"_27":491},{"_44":481,"_32":466,"_30":459,"_138":482,"_42":43,"_41":483,"_140":25,"_39":484,"_13":65,"_34":164,"_36":-5,"_24":25,"_143":-5,"_245":485,"_27":486},{"_44":476,"_32":475,"_30":469,"_138":459,"_42":43,"_41":477,"_140":25,"_39":478,"_13":65,"_34":164,"_36":-5,"_24":25,"_143":-5,"_245":479,"_27":480},{"_44":467,"_32":457,"_30":468,"_138":469,"_42":43,"_41":470,"_140":25,"_39":471,"_13":65,"_34":35,"_36":472,"_24":25,"_143":-5,"_245":473,"_27":474},{"_44":456,"_32":457,"_30":458,"_138":459,"_42":43,"_41":460,"_140":25,"_39":461,"_13":65,"_34":35,"_36":462,"_24":25,"_143":-5,"_245":463,"_27":464},{"_44":451,"_32":450,"_30":444,"_138":368,"_42":43,"_41":452,"_140":25,"_39":453,"_13":65,"_34":164,"_36":-5,"_24":25,"_143":-5,"_245":454,"_27":455},{"_44":442,"_32":366,"_30":443,"_138":444,"_42":43,"_41":445,"_140":25,"_39":446,"_13":65,"_34":35,"_36":447,"_24":25,"_143":-5,"_245":448,"_27":449},{"_44":437,"_32":413,"_30":432,"_138":368,"_42":43,"_41":438,"_140":25,"_39":439,"_13":65,"_34":164,"_36":-5,"_24":25,"_143":-5,"_245":440,"_27":441},{"_44":431,"_32":414,"_30":407,"_138":432,"_42":43,"_41":433,"_140":25,"_39":434,"_13":65,"_34":164,"_36":-5,"_24":25,"_143":-5,"_245":435,"_27":436},{"_44":423,"_32":424,"_30":425,"_138":407,"_42":43,"_41":426,"_140":25,"_39":427,"_13":65,"_34":35,"_36":428,"_24":25,"_143":-5,"_245":429,"_27":430},{"_44":415,"_32":416,"_30":417,"_138":407,"_42":43,"_41":418,"_140":25,"_39":419,"_13":65,"_34":35,"_36":420,"_24":25,"_143":-5,"_245":421,"_27":422},{"_44":405,"_32":366,"_30":406,"_138":407,"_42":43,"_41":408,"_140":25,"_39":409,"_13":65,"_34":35,"_36":410,"_24":25,"_143":-5,"_245":411,"_27":412},{"_44":400,"_32":399,"_30":393,"_138":368,"_42":43,"_41":401,"_140":25,"_39":402,"_13":65,"_34":164,"_36":-5,"_24":25,"_143":-5,"_245":403,"_27":404},{"_44":391,"_32":366,"_30":392,"_138":393,"_42":43,"_41":394,"_140":25,"_39":395,"_13":65,"_34":35,"_36":396,"_24":25,"_143":-5,"_245":397,"_27":398},{"_44":383,"_32":384,"_30":385,"_138":368,"_42":43,"_41":386,"_140":25,"_39":387,"_13":65,"_34":20,"_36":388,"_24":25,"_143":-5,"_245":389,"_27":390},{"_44":375,"_32":376,"_30":377,"_138":368,"_42":43,"_41":378,"_140":25,"_39":379,"_13":65,"_34":35,"_36":380,"_24":25,"_143":-5,"_245":381,"_27":382},{"_44":365,"_32":366,"_30":367,"_138":368,"_42":43,"_41":369,"_140":25,"_39":370,"_13":65,"_34":35,"_36":371,"_24":25,"_143":-5,"_245":372,"_27":373},{"_44":360,"_32":351,"_30":345,"_138":312,"_42":43,"_41":361,"_140":25,"_39":362,"_13":65,"_34":164,"_36":-5,"_24":25,"_143":-5,"_245":363,"_27":364},{"_44":352,"_32":353,"_30":354,"_138":345,"_42":43,"_41":355,"_140":25,"_39":356,"_13":65,"_34":35,"_36":357,"_24":25,"_143":-5,"_245":358,"_27":359},{"_44":342,"_32":343,"_30":344,"_138":345,"_42":43,"_41":346,"_140":25,"_39":347,"_13":65,"_34":35,"_36":348,"_24":25,"_143":-5,"_245":349,"_27":350},{"_44":337,"_32":328,"_30":322,"_138":312,"_42":43,"_41":338,"_140":25,"_39":339,"_13":65,"_34":164,"_36":-5,"_24":25,"_143":-5,"_245":340,"_27":341},{"_44":329,"_32":330,"_30":331,"_138":322,"_42":43,"_41":332,"_140":25,"_39":333,"_13":65,"_34":35,"_36":334,"_24":25,"_143":-5,"_245":335,"_27":336},{"_44":319,"_32":320,"_30":321,"_138":322,"_42":43,"_41":323,"_140":25,"_39":324,"_13":65,"_34":35,"_36":325,"_24":25,"_143":-5,"_245":326,"_27":327},{"_44":309,"_32":310,"_30":311,"_138":312,"_42":43,"_41":313,"_140":25,"_39":314,"_13":65,"_34":35,"_36":315,"_24":25,"_143":-5,"_245":316,"_27":317},{"_44":301,"_32":302,"_30":303,"_138":161,"_42":43,"_41":304,"_140":25,"_39":305,"_13":65,"_34":20,"_36":306,"_24":25,"_143":-5,"_245":307,"_27":308},{"_44":293,"_32":294,"_30":295,"_138":161,"_42":43,"_41":296,"_140":25,"_39":297,"_13":65,"_34":20,"_36":298,"_24":25,"_143":-5,"_245":299,"_27":300},{"_44":286,"_32":146,"_30":287,"_138":161,"_42":43,"_41":288,"_140":25,"_39":289,"_13":65,"_34":20,"_36":290,"_24":25,"_143":-5,"_245":291,"_27":292},{"_44":278,"_32":279,"_30":280,"_138":161,"_42":43,"_41":281,"_140":25,"_39":282,"_13":65,"_34":35,"_36":283,"_24":25,"_143":-5,"_245":284,"_27":285},{"_44":270,"_32":271,"_30":272,"_138":161,"_42":43,"_41":273,"_140":25,"_39":274,"_13":65,"_34":35,"_36":275,"_24":25,"_143":-5,"_245":276,"_27":277},{"_44":262,"_32":263,"_30":264,"_138":161,"_42":43,"_41":265,"_140":25,"_39":266,"_13":65,"_34":35,"_36":267,"_24":25,"_143":-5,"_245":268,"_27":269},{"_44":254,"_32":255,"_30":256,"_138":161,"_42":43,"_41":257,"_140":25,"_39":258,"_13":65,"_34":20,"_36":259,"_24":25,"_143":-5,"_245":260,"_27":261},{"_44":153,"_32":154,"_30":155,"_138":-5,"_42":43,"_41":156,"_140":60,"_39":251,"_13":65,"_34":20,"_36":108,"_24":25,"_143":-5,"_245":252,"_27":253},{"_44":145,"_32":146,"_30":147,"_138":-5,"_42":43,"_41":148,"_140":25,"_39":248,"_13":150,"_34":20,"_36":151,"_24":25,"_143":-5,"_245":249,"_27":250},{"_44":135,"_32":136,"_30":137,"_138":-5,"_42":43,"_41":139,"_140":25,"_39":244,"_13":65,"_34":20,"_36":142,"_24":25,"_143":-5,"_245":246,"_27":247},["D",1745070637386],"children",[],[136],["D",1745071301954],[],[146],["D",1745070735006],[],[154],"803f1222-1d25-11f0-a9d3-569c3dd06744","tsconfig.json","803f12b8-1d25-11f0-a9d3-569c3dd06744",82,["D",1745070734986],"{\n \"compilerOptions\": {\n \"lib\": [\n \"dom\",\n \"dom.iterable\",\n \"esnext\"\n ],\n \"allowJs\": true,\n \"skipLibCheck\": true,\n \"strict\": false,\n \"noEmit\": true,\n \"incremental\": true,\n \"esModuleInterop\": true,\n \"module\": \"esnext\",\n \"moduleResolution\": \"node\",\n \"resolveJsonModule\": true,\n \"isolatedModules\": true,\n \"jsx\": \"preserve\",\n \"plugins\": [\n {\n \"name\": \"next\"\n }\n ]\n },\n \"include\": [\n \"next-env.d.ts\",\n \".next/types/**/*.ts\",\n \"**/*.ts\",\n \"**/*.tsx\"\n ],\n \"exclude\": [\n \"node_modules\"\n ]\n}\n",[],[160,255],"7a0d4e0a-1d25-11f0-a079-569c3dd06744","postcss.config.js","7a0d4ea0-1d25-11f0-a079-569c3dd06744",76,["D",1745070704745],"module.exports = {\n plugins: {\n tailwindcss: {},\n autoprefixer: {},\n },\n}\n",[],[160,263],"61932eb2-1d25-11f0-b388-569c3dd06744","next.config.js","61932f66-1d25-11f0-b388-569c3dd06744",72,["D",1745070663517],"/** @type {import('next').NextConfig} */\nconst nextConfig = {\n experimental: {\n //esmExternals: \"loose\", // <-- add this\n //serverComponentsExternalPackages: [\"mongoose\"], // <-- and this\n },\n}\n\nmodule.exports = nextConfig;\n",[],[160,271],"5594f618-1d25-11f0-8d5c-569c3dd06744","database.js","5594f6d6-1d25-11f0-8d5c-569c3dd06744",68,["D",1745070663511],"import mongoose from 'mongoose'\n\nconst MONGODB_URI = process.env.MONGODB_URI\n\nif (!MONGODB_URI) {\n throw new Error(\n 'Please define the MONGODB_URI environment variable inside .env.local',\n )\n}\n\nlet cached = global.mongoose\n\nif (!cached) {\n cached = global.mongoose = { conn: null, promise: null }\n}\n\nexport default async function mongoConnect() {\n console.log(\"Connecting...\")\n if (cached.conn) {\n return cached.conn\n }\n if (!cached.promise) {\n const opts = {\n bufferCommands: true,\n useUnifiedTopology: true,\n dbName: 'shop',\n }\n cached.promise = await mongoose.connect(MONGODB_URI, opts).then(mongoose => {\n console.log('Db connected')\n return mongoose\n })\n }\n try {\n cached.conn = await cached.promise\n } catch (e) {\n cached.promise = null\n throw e\n }\n\n return cached.conn\n}\n\n",[],[160,279],"55929274-1d25-11f0-8001-569c3dd06744","55929350-1d25-11f0-8001-569c3dd06744",67,["D",1745070663510],"This is a [Next.js](https://nextjs.org/) project bootstrapped with [`create-next-app`](https://github.com/vercel/next.js/tree/canary/packages/create-next-app).\n\n## Getting Started\n\nFirst, run the development server:\n\n```bash\nnpm run dev\n# or\nyarn dev\n# or\npnpm dev\n# or\nbun dev\n```\n\nOpen [http://localhost:3000](http://localhost:3000) with your browser to see the result.\n\nYou can start editing the page by modifying `app/page.tsx`. The page auto-updates as you edit the file.\n\nThis project uses [`next/font`](https://nextjs.org/docs/basic-features/font-optimization) to automatically optimize and load Inter, a custom Google Font.\n\n## Learn More\n\nTo learn more about Next.js, take a look at the following resources:\n\n- [Next.js Documentation](https://nextjs.org/docs) - learn about Next.js features and API.\n- [Learn Next.js](https://nextjs.org/learn) - an interactive Next.js tutorial.\n\nYou can check out [the Next.js GitHub repository](https://github.com/vercel/next.js/) - your feedback and contributions are welcome!\n\n## Deploy on Vercel\n\nThe easiest way to deploy your Next.js app is to use the [Vercel Platform](https://vercel.com/new?utm_medium=default-template&filter=next.js&utm_source=create-next-app&utm_campaign=create-next-app-readme) from the creators of Next.js.\n\nCheck out our [Next.js deployment documentation](https://nextjs.org/docs/deployment) for more details.\n",[],[160,146],"4600347e-1d25-11f0-ab73-569c3dd06744",".gitignore","4600351e-1d25-11f0-ab73-569c3dd06744",47,["D",1745070637385],".direnv\n.env\n.env*\n.next\nnode_modules\ndump\nhome/wolf/.zsh\nhome/wolf/.zsh\nhome/wolf/.zsh\nbackup.json\n",[],[160,294],"460f847e-1d25-11f0-b932-569c3dd06744",".eslintrc.json","460f853c-1d25-11f0-b932-569c3dd06744",51,["D",1745070637388],"{\n \"extends\": \"next/core-web-vitals\",\n \"rules\": {\n \"react/no-unescaped-entities\": \"off\"\n }\n}\n",[],[160,302],"53486a34-1d25-11f0-8f40-569c3dd06744","theme.ts","53486af2-1d25-11f0-8f40-569c3dd06744","44d48974-1d25-11f0-8f91-569c3dd06744",58,["D",1745070657398],"\"use client\";\n\nimport { ThemeOptions, createTheme } from \"@mui/material/styles\";\n\nconst themeOptions: ThemeOptions = createTheme({\n palette: {\n mode: \"dark\",\n primary: {\n main: \"#0D47A1\",\n },\n secondary: {\n main: \"#B71C1C\",\n },\n background: {\n default: \"#1C1C1C\",\n paper: \"#2C2C2C\",\n },\n },\n typography: {\n fontFamily: \"Roboto, sans-serif\",\n h1: {\n fontSize: \"2.5rem\",\n fontWeight: 500,\n },\n h2: {\n fontSize: \"2rem\",\n fontWeight: 500,\n },\n body1: {\n fontSize: \"1rem\",\n fontWeight: 400,\n },\n },\n});\n\nexport default themeOptions;\n",[],[160,318,310],"src","53dc8a8e-1d25-11f0-9505-569c3dd06744","Preorder.ts","53dc8b60-1d25-11f0-9505-569c3dd06744","453ad904-1d25-11f0-9681-569c3dd06744",64,["D",1745070657654],"import mongoose from \"mongoose\";\n\nexport interface Preorder {\n customerName: string;\n email: string;\n productID: mongoose.Schema.Types.ObjectId;\n date: Date;\n status: \"pending\" | \"completed\" | \"canceled\";\n pickupLocation: \"Wade\" | \"Fribley\";\n amountPaid: number;\n agreedPrice: number;\n completedDate: Date;\n sessionID: string;\n}\n\nconst PreorderSchema = new mongoose.Schema({\n customerName: { type: String, required: true },\n email: { type: String, required: true },\n productID: {\n type: mongoose.Schema.Types.ObjectId,\n ref: \"Item\",\n required: true,\n },\n date: { type: Date, default: Date.now },\n status: {\n type: String,\n enum: [\"pending\", \"completed\", \"canceled\"],\n default: \"pending\",\n },\n amountPaid: { type: Number, required: false },\n agreedPrice: { type: Number, required: false },\n completedDate: { type: Date, required: false },\n pickupLocation: {\n type: String,\n enum: [\"Wade\", \"Fribley\"],\n required: true,\n },\n sessionID: { type: String, required: true },\n});\n\nexport default mongoose.models.Preorder ||\n mongoose.model(\"Preorder\", PreorderSchema);\n",[],[160,318,328,320],"models","807d706c-1d25-11f0-a36b-569c3dd06744","Item.ts","807d7134-1d25-11f0-a36b-569c3dd06744",94,["D",1745070734994],"import mongoose from 'mongoose';\n\nconst ItemSchema = new mongoose.Schema({\n name: String,\n price: Number,\n description: String,\n image: String,\n buyUrl: String\n}, { collection: 'items' },\n);\n\nexport default mongoose.models.Item || mongoose.model('Item', ItemSchema)\n",[],[160,318,328,330],"453ad846-1d25-11f0-9681-569c3dd06744",26,["D",1745070636089],[231,232],[160,318,328],"8037a5aa-1d25-11f0-a7ed-569c3dd06744","Item.tsx","8037a636-1d25-11f0-a7ed-569c3dd06744","4531ce54-1d25-11f0-ab73-569c3dd06744",80,["D",1745070735011],"import { Card } from \"@mui/material\";\nimport Typography from \"@mui/material/Typography\";\nimport CardHeader from \"@mui/material/CardHeader\";\nimport CardMedia from \"@mui/material/CardMedia\";\n\ninterface ItemProps {\n id: string;\n name: string;\n image: string;\n price: number;\n}\n\nconst Item = ({ id, name, image, price }: ItemProps) => {\n return (\n \n \n {name}\n \n\n \n \n );\n};\n\nexport default Item;\n",[],[160,318,351,343],"components","53d6a70e-1d25-11f0-adc8-569c3dd06744","EmailEntry.tsx","53d6a7fe-1d25-11f0-adc8-569c3dd06744",63,["D",1745070657453],"import TextField from \"@mui/material/TextField\";\nimport { useState } from \"react\";\n\ninterface EmailEntryProps {\n onChange: (value: string) => void\n label: string;\n placeholder: string;\n sx: any;\n name: string;\n required?: boolean;\n fullWidth?: boolean;\n}\n\nexport default function EmailEntry({ onChange, label, sx, name, required, placeholder, fullWidth }: EmailEntryProps) {\n const [error, setError] = useState(false);\n\n const handleChange = (event: React.ChangeEvent) => {\n const value = event.target.value;\n const emailRegex = /^[^\\s@]+@[^\\s@]+\\.[^\\s@]+$/;\n setError(!emailRegex.test(value));\n onChange(value);\n };\n\n return (\n )\n}\n",[],[160,318,351,353],"4531cd8c-1d25-11f0-ab73-569c3dd06744",25,["D",1745070636031],[228,229],[160,318,351],"8043e284-1d25-11f0-b41d-569c3dd06744","page.tsx","8043e342-1d25-11f0-b41d-569c3dd06744","4527628e-1d25-11f0-b3df-569c3dd06744",83,["D",1745070734988],"import Typography from \"@mui/material/Typography\";\nimport Grid from \"@mui/material/Grid\";\nimport MongoItem from \"../models/Item\";\nimport mongoConnect from \"../../database\"\nimport CardContent from \"@mui/material/CardContent\";\nimport Stack from \"@mui/material/Stack\";\nimport Button from \"@mui/material/Button\";\nimport Paper from \"@mui/material/Paper\";\nimport Box from \"@mui/material/Box\";\n\nexport default async function HomePage() {\n await mongoConnect()\n const iclicker = (await MongoItem\n .find({})\n .limit(1)\n .exec())[0];\n\n const makeInfoText = (text: string) => {\n return (\n \n {text}\n \n )\n }\n\n return (\n <>\n \n \n\n \n \n \n \n \n {iclicker.name}\n ${iclicker.price}\n \n \n \n \n\n \n \n\n \n {makeInfoText(`Preorders for SPRING 2025`)}\n {makeInfoText(`Case Western's CHEM 105 and CHEM 111 require and PHYS 121 highly encourages having a physical iClicker device.`)}\n {makeInfoText(`I order iClickers in bulk, and pass on much of the discount to you. iClickers at Case's book store cost $50! Here, you can buy iClickers for less than half the price!`)}\n {makeInfoText(`\n Pre-Order an iClicker from me for only $${iclicker.price}, and pick it up Tuesday evening at 9PM at Wade, or a bit later at Fribley! I offer cheap, tested, reliable, lightly used iClickers with AAA batteries included.\n `)}\n {makeInfoText(`After spring semester starts I'll only continue selling while supplies last.`)}\n {makeInfoText(`To order, just make a $5 deposit to hold your spot, and I'll shoot out an email to everyone a few days before school starts with pickup details.`)}\n \n\n \n\n \n \n \n \n \n );\n}\n",[],[160,318,374,366],"app","803b0e7a-1d25-11f0-9eeb-569c3dd06744","layout.tsx","803b0f10-1d25-11f0-9eeb-569c3dd06744",81,["D",1745070734985],"import { AppRouterCacheProvider } from \"@mui/material-nextjs/v14-appRouter\";\nimport { ThemeProvider } from \"@mui/material/styles\";\nimport AppBar from \"@mui/material/AppBar\";\nimport CssBaseline from \"@mui/material/CssBaseline\";\nimport Container from \"@mui/material/Container\";\nimport Toolbar from \"@mui/material/Toolbar\";\nimport Typography from \"@mui/material/Typography\";\nimport theme from \"../theme\";\nimport Box from \"@mui/material/Box\";\nimport Link from \"@mui/material/Link\";\nimport Paper from \"@mui/material/Paper\";\nimport Script from \"next/script\";\n\nexport const metadata = {\n title: \"Wolf's iClicker Shop\",\n description: \"Cheap Case Western iClicker Shop\",\n};\n\nexport default function RootLayout({\n children,\n}: {\n children: React.ReactNode;\n}) {\n return (\n \n \n\n\n \n \n \n \n\n \n \n \n \n Wolf's iClicker Shop\n \n \n \n\n \n {children}\n \n\n \n \n \n \n Wolf Mermelstein\n \n \n \n wsm32@case.edu\n \n \n \n 212-767-9653\n \n \n \n https://404wolf.com\n \n \n \n \n \n\n \n \n \n \n );\n}\n",[],[160,318,374,376],"532b40e4-1d25-11f0-a29a-569c3dd06744","globals.css","532b41c0-1d25-11f0-a29a-569c3dd06744",57,["D",1745070657398],"@tailwind base;\n@tailwind components;\n@tailwind utilities;\n\n:root {\n --foreground-rgb: 0, 0, 0;\n --background-start-rgb: 214, 219, 220;\n --background-end-rgb: 255, 255, 255;\n}\n\n@media (prefers-color-scheme: dark) {\n :root {\n --foreground-rgb: 255, 255, 255;\n --background-start-rgb: 0, 0, 0;\n --background-end-rgb: 0, 0, 0;\n }\n}\n\nbody {\n color: rgb(var(--foreground-rgb));\n background: linear-gradient(\n to bottom,\n transparent,\n rgb(var(--background-end-rgb))\n )\n rgb(var(--background-start-rgb));\n}\n",[],[160,318,374,384],"5260957e-1d25-11f0-ae97-569c3dd06744","5260965a-1d25-11f0-ae97-569c3dd06744","459fde9e-1d25-11f0-8f40-569c3dd06744",54,["D",1745070657394],"import React from 'react';\nimport { Container, Box, Paper, Typography } from '@mui/material';\n\nconst ThankYouPage = () => {\n return (\n \n \n \n \n Thank you for your preorder!\n \n \n Thank you for preordering an iClicker. I'll be sending out a mass email with more information on when I'll set them up for pickup. If you have any questions at all feel free to contact me at wsm32@case.edu.\n \n \n \n \n );\n};\n\nexport default ThankYouPage; \n",[],[160,318,374,399,366],"thankyou","459fddd6-1d25-11f0-8f40-569c3dd06744",37,["D",1745070636752],[223],[160,318,374,399],"53d04ae4-1d25-11f0-901f-569c3dd06744","53d04b8e-1d25-11f0-901f-569c3dd06744","45e04326-1d25-11f0-8f40-569c3dd06744",62,["D",1745070657447],"import mongooseConnect from \"../../../../database\"\nimport MongoItem from \"../../../models/Item\";\nimport Body from \"./Body\";\n\nexport default async function IClickPage() {\n await mongooseConnect()\n const iclickerItem: any = await MongoItem\n .find({ name: \"iClicker\" })\n .exec()\n .then((res) => res[0])\n\n return (\n <>\n \n \n )\n}\n",[],[160,318,374,413,414,366],"purchase","iclicker","5293a77a-1d25-11f0-b051-569c3dd06744","IClickerForm.tsx","5293a806-1d25-11f0-b051-569c3dd06744",55,["D",1745070657395],"\"use client\"\nimport Box from \"@mui/material/Box\";\nimport Button from \"@mui/material/Button\";\nimport FormControlLabel from \"@mui/material/FormControlLabel\";\nimport Radio from \"@mui/material/Radio\";\nimport RadioGroup from \"@mui/material/RadioGroup\";\nimport Stack from \"@mui/material/Stack\";\nimport TextField from \"@mui/material/TextField\";\nimport { loadStripe } from '@stripe/stripe-js';\nimport { useState } from \"react\";\nimport EmailEntry from \"../../../components/EmailEntry\";\n\nconst stripePromise = loadStripe(process.env.NEXT_PUBLIC_STRIPE_PUBLIC!);\n\n\nexport default function IClickerForm() {\n const [customerName, setCustomerName] = useState(\"\");\n const [email, setEmail] = useState(\"\");\n const [pickupLocation, setPickupLocation] = useState<\"Wade\" | \"Fribley\">(\"Wade\")\n\n const handleSubmit = async (event: any) => {\n event.preventDefault();\n const stripe = await stripePromise;\n const response = await fetch('/api/checkout', {\n method: 'POST',\n body: JSON.stringify({ customerName, email, pickupLocation, productID: \"65b137f8d45dddc0597df3d7\", }),\n });\n const responseData = await response.json();\n const { error } = await stripe.redirectToCheckout({ sessionId: responseData.id });\n if (error) console.error(\"Error redirecting to checkout\", error)\n };\n\n return (\n :not(style)': { m: 1 } }}>\n setCustomerName(event.target.value)}\n sx={{ pr: 2 }}\n />\n \n\n setPickupLocation(event.target.value as \"Wade\" | \"Fribley\")}\n >\n \n } label=\"Fribley pickup. Best for Sophomores & upperclassmen\" />\n } label=\"Wade pickup. Best for First Years\" />\n \n \n\n \n \n )\n}\n",[],[160,318,374,413,414,416],"52233ff8-1d25-11f0-aac2-569c3dd06744","Body.tsx","522340e8-1d25-11f0-aac2-569c3dd06744",53,["D",1745070637497],"\"use client\"\nimport Box from \"@mui/material/Box\";\nimport IClickerForm from \"./IClickerForm\";\nimport Stack from \"@mui/material/Stack\";\nimport Typography from \"@mui/material/Typography\";\nimport Card from \"@mui/material/Card\";\nimport useMediaQuery from \"@mui/material/useMediaQuery\";\nimport Paper from \"@mui/material/Paper\";\n\nexport default function Body({ imageURL }: { imageURL: string }) {\n const isNotMobile = useMediaQuery('(min-width:600px)');\n\n return (\n \n \n {isNotMobile &&\n }\n\n \n \n \n Pre order an iClicker! I will send an email a few days before school starts with more info about how to pick it up and pay. To pre order an iClicker, I'm requiring a $5 deposit ahead of time.\n \n \n If you have any issues or don't receive an email by January 9th, please email wsm32@case.edu.\n \n \n\n \n \n \n \n \n \n )\n}\n",[],[160,318,374,413,414,424],"45e04268-1d25-11f0-8f40-569c3dd06744","4597a094-1d25-11f0-b686-569c3dd06744",44,["D",1745070637173],[219,220,221],[160,318,374,413,414],"45979fea-1d25-11f0-b686-569c3dd06744",36,["D",1745070636699],[218],[160,318,374,413],"53a414ba-1d25-11f0-854f-569c3dd06744","53a41546-1d25-11f0-854f-569c3dd06744","458f0a6a-1d25-11f0-9137-569c3dd06744",59,["D",1745070657411],"import React from 'react';\nimport { Container, Box, Paper, Typography } from '@mui/material';\n\nconst ThankYouPage = () => {\n return (\n \n \n \n \n Whoops, something went wrong.\n \n \n For some reason I couldn't process your order. Please email me at wsm32@case.edu.\n \n \n \n \n );\n};\n\nexport default ThankYouPage; \n",[],[160,318,374,450,366],"canceled","458f0998-1d25-11f0-9137-569c3dd06744",35,["D",1745070636643],[216],[160,318,374,450],"53e020fe-1d25-11f0-b1b6-569c3dd06744","route.ts","53e021bc-1d25-11f0-b1b6-569c3dd06744","45d7bd96-1d25-11f0-b051-569c3dd06744",65,["D",1745070657658],"import Stripe from \"stripe\";\nimport Preorder from \"../../../models/Preorder\";\nimport { NextRequest, NextResponse } from \"next/server\";\nimport mongoose from \"mongoose\";\nimport mongoConnect from \"../../../../database\";\n\nconst stripe = new Stripe(process.env.STRIPE_SECRET!, {\n apiVersion: \"2024-06-20\",\n});\n\nexport async function POST(request: NextRequest) {\n mongoConnect();\n\n const { customerName, pickupLocation, email, productID } = await request\n .json();\n console.log(customerName, email, productID, pickupLocation);\n\n // Validate required fields\n if (!customerName || !email || !productID || !pickupLocation) {\n return NextResponse.json(\n { error: \"Missing required fields\" },\n { status: 400 },\n );\n }\n\n // Validate productID is a valid ObjectId\n if (!mongoose.Types.ObjectId.isValid(productID)) {\n return NextResponse.json({ error: \"Invalid productID\" }, { status: 400 });\n }\n\n const session = await stripe.checkout.sessions.create({\n payment_method_types: [\"card\"],\n line_items: [\n {\n price_data: {\n currency: \"usd\",\n product_data: {\n name: \"iClicker\",\n },\n unit_amount: 500,\n },\n quantity: 1,\n },\n ],\n mode: \"payment\",\n customer_email: email,\n success_url: \"https://iclickwolf.com/thankyou\",\n cancel_url: \"https://iclickwolf.com/canceled\",\n });\n\n // Create new preorder\n const newPreorder = new Preorder({\n customerName,\n email,\n productID,\n amountPaid: 0,\n agreedPrice: null,\n status: \"pending\",\n pickupLocation,\n sessionID: session.id,\n date: new Date(),\n });\n\n // Save preorder to database\n const savedPreorder = await newPreorder.save();\n\n return NextResponse.json({ id: session.id, preorder: savedPreorder });\n}\n",[],[160,318,374,465,466,457],"api","checkout","53c3e696-1d25-11f0-a4e8-569c3dd06744","53c3e772-1d25-11f0-a4e8-569c3dd06744","45f1a62a-1d25-11f0-b1b6-569c3dd06744",61,["D",1745070657441],"import { NextRequest, NextResponse } from \"next/server\";\nimport stripe, { Stripe } from \"stripe\";\nimport Preorder from \"../../../../models/Preorder\";\nimport mongoConnect from \"../../../../../database\";\nimport MongoItem from \"../../../../models/Item\";\n\ninterface EmailSendBody {\n name: string;\n email: string;\n subject: string;\n content?: string;\n html?: string;\n}\n\nconst emailSenderApiUrl = \"https://wolf-emailsender.web.val.run/\";\n\nconst sendEmail = async (body: EmailSendBody) => {\n const response = await fetch(emailSenderApiUrl, {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n \"Authorization\": `Bearer ${process.env.VAL_EMAIL_KEY}`,\n },\n body: JSON.stringify(body),\n });\n\n if (!response.ok) {\n console.log(await response.text());\n throw new Error(\"Failed to send email\");\n }\n\n return response.json();\n};\n\nexport async function POST(request: NextRequest) {\n await mongoConnect();\n const iclicker = (await MongoItem\n .find({})\n .limit(1)\n .exec())[0];\n\n const buf = await request.text();\n console.log(buf);\n const sig = request.headers.get(\"stripe-signature\");\n console.log(sig);\n\n let event: Stripe.Event;\n console.log(event);\n\n try {\n event = stripe.webhooks.constructEvent(\n buf.toString(),\n sig,\n process.env.STRIPE_WEBHOOK_SECRET!,\n );\n } catch (err) {\n console.log(`Error message: ${err?.message}`);\n return NextResponse.json({ error: err.message }, { status: 400 });\n }\n if (event.type === \"checkout.session.completed\") {\n const session = event.data.object as Stripe.Checkout.Session;\n console.log(session);\n await Preorder.updateOne(\n { sessionID: session.id },\n {\n $set: {\n status: \"completed\",\n agreedPrice: iclicker.price * 100,\n amountPaid: session.amount_total,\n completedDate: new Date(),\n },\n },\n );\n const preorder = await Preorder.findOne({ sessionID: session.id });\n\n // Send confirmation email\n await sendEmail({\n email: session.customer_email,\n name: session.customer_details.name,\n subject: \"iClicker Preorder Confirmation\",\n content:\n `Thank you for preordering an iClicker! This email is a confirmation that your $5 deposit has been received, and you can pay the remaining balance at the time you pick up your iClicker. I accept cash, all payment apps, or credit/debit cards (with a $3 processing fee). I'll be distributing iClickers Tuesday evening the day after break, January 14th, at 9PM at Wade (stay tuned for Fribley pickup info), and will email with an exact time soon. If you have any questions at all, please feel free to email me (or reply to this email) and I'll be happy to help.\n\nBest,\nWolf`,\n });\n console.log(\"Email sent to:\", session.customer_email);\n\n console.log(preorder);\n console.log(\"Session completed:\", session);\n }\n\n return NextResponse.json({ received: true });\n}\n",[],[160,318,374,465,466,475,457],"callback","45f1a562-1d25-11f0-b1b6-569c3dd06744",46,["D",1745070637288],[213],[160,318,374,465,466,475],"45d7bcd8-1d25-11f0-b051-569c3dd06744","45861ff4-1d25-11f0-9681-569c3dd06744",43,["D",1745070637117],[212,214],[160,318,374,465,466],"45861f2c-1d25-11f0-9681-569c3dd06744",34,["D",1745070636583],[211],[160,318,374,465],"452761bc-1d25-11f0-b3df-569c3dd06744",24,["D",1745070635962],[210,215,217,222,224,225,226],[160,318,374],"44d488b6-1d25-11f0-8f91-569c3dd06744",15,["D",1745070635419],[209,227,230,233],[160,318],["D",1745070635115],[208,234,235,236,237,238,239,240],[160],"0a59802e-1d25-11f0-a4c4-569c3dd06744","index.tsx","0a5980f6-1d25-11f0-a4c4-569c3dd06744",7,["D",1745070537237],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport { App } from \"./components/App.tsx\";\n\nconst root = document.getElementById(\"root\");\nif (!root) {\n throw new Error(\"No root element found\");\n}\n\ncreateRoot(root).render();",[],[167,506],"5745b014-1d26-11f0-9c28-569c3dd06744","index.html","0a52108c-1d25-11f0-a6aa-569c3dd06744",110,["D",1745071095852],"\n\n \n \n \n Wolf's iClicker Shop\n \n \n \n \n \n

Wolf's iClicker Shop

\n \n \n \n",[],[167,514],"7b01ebda-1d26-11f0-a002-569c3dd06744","ThankYouPage.tsx","7b01ec7a-1d26-11f0-a002-569c3dd06744","0a419d38-1d25-11f0-9acd-569c3dd06744",115,["D",1745071155811],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\n\nexport function ThankYouPage() {\n return (\n

Thank You for Your Order!

\n \n

\n Your iClicker preorder has been confirmed! A $5 deposit has been received.\n

\n \n

\n You'll receive a confirmation email shortly with all the details about your order.\n

\n \n

\n I'll be distributing iClickers Tuesday evening the day after break, January 14th, at 9PM at Wade \n (stay tuned for Fribley pickup info), and will email with an exact time soon.\n

\n \n

\n If you have any questions, please contact me at wsm32@case.edu\n

\n \n \n Return to Home\n \n

\n );\n}",[],[167,351,522],"0e736e84-1d27-11f0-8a83-569c3dd06744","PurchasePage.tsx","74660504-1d26-11f0-94ab-569c3dd06744",125,["D",1745071403174],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState } from \"https://esm.sh/react@18.2.0\";\n\nexport function PurchasePage() {\n const [customerName, setCustomerName] = useState(\"\");\n const [email, setEmail] = useState(\"\");\n const [pickupLocation, setPickupLocation] = useState<\"Wade\" | \"Fribley\">(\"Wade\");\n const [isSubmitting, setIsSubmitting] = useState(false);\n const [error, setError] = useState(\"\");\n\n const validateEmail = (email: string): boolean => {\n const re = /^[^\\s@]+@[^\\s@]+\\.[^\\s@]+$/;\n return re.test(email);\n };\n\n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n \n // Validate form\n if (!customerName.trim()) {\n setError(\"Please enter your name\");\n return;\n }\n \n if (!validateEmail(email)) {\n setError(\"Please enter a valid email address\");\n return;\n }\n \n setError(\"\");\n setIsSubmitting(true);\n \n try {\n const response = await fetch('/api/checkout', {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/json',\n },\n body: JSON.stringify({ \n customerName, \n email, \n pickupLocation, \n productID: 1 // We'll get the actual ID from the database on the server\n }),\n });\n \n const data = await response.json();\n \n if (!response.ok) {\n throw new Error(data.error || \"Failed to create checkout session\");\n }\n \n // Check if we have a session ID\n if (!data.id) {\n throw new Error(\"No checkout session ID returned from server\");\n }\n \n // Redirect to Stripe checkout\n try {\n const stripe = await loadStripe();\n if (!stripe) {\n throw new Error(\"Stripe is not configured properly\");\n }\n \n const { error } = await stripe.redirectToCheckout({ sessionId: data.id });\n if (error) {\n throw error;\n }\n } catch (stripeError) {\n console.error(\"Stripe error:\", stripeError);\n throw new Error(\"Failed to redirect to payment page: \" + stripeError.message);\n }\n } catch (err) {\n console.error(\"Checkout error:\", err);\n setError(err.message || \"An error occurred during checkout\");\n } finally {\n setIsSubmitting(false);\n }\n };\n\n return (\n

Reserve your iClicker

\n \n {error && (\n

\n {error}\n

\n )}\n \n

\n \n Name\n \n setCustomerName(e.target.value)}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md shadow-sm focus:outline-none focus:ring-blue-500 focus:border-blue-500\"\n required\n />\n

\n \n

\n \n Email\n \n setEmail(e.target.value)}\n placeholder=\"example32@case.edu\"\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md shadow-sm focus:outline-none focus:ring-blue-500 focus:border-blue-500\"\n required\n />\n

\n \n

Pickup Location

\n \n setPickupLocation(\"Fribley\")}\n className=\"h-4 w-4 text-blue-600 focus:ring-blue-500\"\n />\n Fribley pickup. Best for Sophomores & upperclassmen\n \n \n setPickupLocation(\"Wade\")}\n className=\"h-4 w-4 text-blue-600 focus:ring-blue-500\"\n />\n Wade pickup. Best for First Years\n \n

\n \n \n {isSubmitting ? \"Processing...\" : \"Preorder iClicker!\"}\n \n \n

\n );\n}\n\n// Helper function to load Stripe\nasync function loadStripe() {\n try {\n const stripeKey = Deno.env.get(\"STRIPE_PUBLIC\");\n if (!stripeKey) {\n console.error(\"Stripe public key not configured\");\n return null;\n }\n \n const { loadStripe: loadStripeJs } = await import(\"https://esm.sh/@stripe/stripe-js@2.4.0\");\n return await loadStripeJs(stripeKey);\n } catch (error) {\n console.error(\"Failed to load Stripe:\", error);\n return null;\n }\n}",[],[167,351,531],"22f7b1ee-1d27-11f0-978d-569c3dd06744",["D",1745071437596],[],[167,351,33],"7f0eada8-1d26-11f0-9e69-569c3dd06744","CanceledPage.tsx","7f0eae70-1d26-11f0-9e69-569c3dd06744",116,["D",1745071162604],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\n\nexport function CanceledPage() {\n return (\n

Order Canceled

\n \n

\n Your iClicker preorder has been canceled.\n

\n \n

\n No charges have been made to your account. If you'd like to try again or have any questions,\n please feel free to return to the home page or contact me directly.\n

\n \n

\n If you have any questions, please contact me at wsm32@case.edu\n

\n \n \n Return to Home\n \n

\n );\n}",[],[167,351,543],"5c069e06-1d26-11f0-b167-569c3dd06744","App.tsx","0a559a36-1d25-11f0-99f3-569c3dd06744",111,["D",1745071103819],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport { BrowserRouter, Routes, Route } from \"https://esm.sh/react-router-dom@6.22.3?deps=react@18.2.0\";\nimport { HomePage } from \"./HomePage.tsx\";\nimport { PurchasePage } from \"./PurchasePage.tsx\";\nimport { ThankYouPage } from \"./ThankYouPage.tsx\";\nimport { CanceledPage } from \"./CanceledPage.tsx\";\n\nexport function App() {\n return (\n \n \n } />\n } />\n } />\n } />\n \n \n );\n}",[],[167,351,551],"0a419c84-1d25-11f0-9acd-569c3dd06744",["D",1745070537150],[200,201,202,203,204],[167,351],["D",1745070537083],[199,205,206],[167],"c69c58d2-1d26-11f0-af43-569c3dd06744","index.ts",121,["D",1745071282645],"http","import { serveFile, readFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { Hono } from \"npm:hono\";\nimport { cors } from \"npm:hono/cors\";\nimport checkoutRoutes from \"./routes/checkout.ts\";\nimport webhookRoutes from \"./routes/webhook.ts\";\nimport itemsRoutes from \"./routes/items.ts\";\nimport { runMigrations } from \"./database/migrations.ts\";\n\n// Initialize the app\nconst app = new Hono();\n\n// Enable CORS\napp.use(\"*\", cors());\n\n// Run migrations on startup\ntry {\n await runMigrations();\n console.log(\"Database migrations completed successfully\");\n} catch (error) {\n console.error(\"Database migration error:\", error);\n}\n\n// API routes\napp.route(\"/api/checkout\", checkoutRoutes);\napp.route(\"/api/webhook\", webhookRoutes);\napp.route(\"/api/items\", itemsRoutes);\n\n// Serve frontend files\napp.get(\"/frontend/*\", c => serveFile(c.req.path, import.meta.url));\n\n// Handle SPA routes - serve index.html for all non-API, non-asset routes\nconst serveIndex = async (c: any) => {\n try {\n const html = await readFile(\"/frontend/index.html\", import.meta.url);\n return c.html(html);\n } catch (error) {\n console.error(\"Error serving index.html:\", error);\n return c.text(\"Error loading application\", 500);\n }\n};\n\napp.get(\"/\", serveIndex);\napp.get(\"/purchase/*\", serveIndex);\napp.get(\"/thankyou\", serveIndex);\napp.get(\"/canceled\", serveIndex);\n\n// Unwrap and rethrow Hono errors as the original error\napp.onError((err, c) => {\n console.error(\"Application error:\", err);\n throw err;\n});\n\n// HTTP vals expect an exported \"fetch handler\"\nexport default app.fetch;","iclickwolf",[],[173,566],"f6542ff0-1d26-11f0-9de6-569c3dd06744","webhook.ts","1683027a-1d26-11f0-ac38-569c3dd06744","79db37e8-bed0-4668-8c45-6228973a80d6",124,["D",1745071362703],"import { Hono } from \"npm:hono\";\nimport { getFirstItem, getPreorderBySessionId, updatePreorderStatus } from \"../database/queries.ts\";\n\nconst app = new Hono();\n\n// Initialize Stripe only if the API key is available\nlet stripe: any = null;\nconst stripeKey = Deno.env.get(\"STRIPE_SECRET\");\n\nif (stripeKey) {\n try {\n const { Stripe } = await import(\"npm:stripe\");\n stripe = new Stripe(stripeKey, {\n apiVersion: \"2024-06-20\",\n });\n } catch (error) {\n console.error(\"Failed to initialize Stripe:\", error);\n }\n}\n\n// Helper function to send email\nasync function sendEmail(body: {\n name: string;\n email: string;\n subject: string;\n content?: string;\n html?: string;\n}) {\n const emailSenderApiUrl = \"https://wolf-emailsender.web.val.run/\";\n const emailKey = Deno.env.get(\"VAL_EMAIL_KEY\");\n \n if (!emailKey) {\n console.error(\"Email API key not configured\");\n throw new Error(\"Email service is not configured\");\n }\n \n const response = await fetch(emailSenderApiUrl, {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n \"Authorization\": `Bearer ${emailKey}`,\n },\n body: JSON.stringify(body),\n });\n\n if (!response.ok) {\n console.error(\"Email sending failed:\", await response.text());\n throw new Error(\"Failed to send email\");\n }\n\n return response.json();\n}\n\n// Webhook endpoint for Stripe events\napp.post(\"/\", async (c) => {\n try {\n // Check if Stripe is initialized\n if (!stripe) {\n return c.json({ \n error: \"Stripe is not configured. Please set the STRIPE_SECRET environment variable.\" \n }, 500);\n }\n\n const payload = await c.req.text();\n const signature = c.req.header(\"stripe-signature\") || \"\";\n const webhookSecret = Deno.env.get(\"STRIPE_WEBHOOK_SECRET\");\n \n if (!webhookSecret) {\n return c.json({ \n error: \"Webhook secret is not configured. Please set the STRIPE_WEBHOOK_SECRET environment variable.\" \n }, 500);\n }\n \n // Verify the webhook signature\n let event;\n try {\n event = stripe.webhooks.constructEvent(\n payload,\n signature,\n webhookSecret\n );\n } catch (err) {\n console.error(`Webhook signature verification failed: ${err.message}`);\n return c.json({ error: err.message }, 400);\n }\n \n // Handle the checkout.session.completed event\n if (event.type === \"checkout.session.completed\") {\n const session = event.data.object;\n \n // Get the item price\n const item = await getFirstItem();\n if (!item) {\n throw new Error(\"Product not found\");\n }\n \n // Update the preorder status\n await updatePreorderStatus(\n session.id,\n \"completed\",\n session.amount_total,\n item.price\n );\n \n // Get the updated preorder\n const preorder = await getPreorderBySessionId(session.id);\n if (!preorder) {\n throw new Error(\"Preorder not found\");\n }\n \n // Send confirmation email\n if (session.customer_email && session.customer_details?.name) {\n try {\n await sendEmail({\n email: session.customer_email,\n name: session.customer_details.name,\n subject: \"iClicker Preorder Confirmation\",\n content: `Thank you for preordering an iClicker! This email is a confirmation that your $5 deposit has been received, and you can pay the remaining balance at the time you pick up your iClicker. I accept cash, all payment apps, or credit/debit cards (with a $3 processing fee). I'll be distributing iClickers Tuesday evening the day after break, January 14th, at 9PM at Wade (stay tuned for Fribley pickup info), and will email with an exact time soon. If you have any questions at all, please feel free to email me (or reply to this email) and I'll be happy to help.\n\nBest,\nWolf`,\n });\n console.log(\"Email sent to:\", session.customer_email);\n } catch (emailError) {\n console.error(\"Failed to send confirmation email:\", emailError);\n }\n }\n \n console.log(\"Preorder completed:\", preorder);\n }\n \n return c.json({ received: true });\n } catch (error) {\n console.error(\"Webhook error:\", error);\n return c.json({ error: error.message }, 500);\n }\n});\n\nexport default app;",[],[173,583,575],"routes","81ef41ea-1d26-11f0-b224-569c3dd06744","items.ts","81ef42d0-1d26-11f0-b224-569c3dd06744",118,["D",1745071167431],"import { Hono } from \"npm:hono\";\nimport { getFirstItem } from \"../database/queries.ts\";\n\nconst app = new Hono();\n\n// Get the first item (iClicker)\napp.get(\"/\", async (c) => {\n try {\n const item = await getFirstItem();\n if (!item) {\n return c.json({ error: \"No items found\" }, 404);\n }\n return c.json(item);\n } catch (error) {\n console.error(\"Error fetching item:\", error);\n return c.json({ error: error.message }, 500);\n }\n});\n\nexport default app;",[],[173,583,585],"e4d0b87a-1d26-11f0-a3ba-569c3dd06744","checkout.ts","0c6f8952-1d26-11f0-9dbf-569c3dd06744",123,["D",1745071333324],"import { Hono } from \"npm:hono\";\nimport { createPreorder, getFirstItem } from \"../database/queries.ts\";\n\nconst app = new Hono();\n\n// Initialize Stripe only if the API key is available\nlet stripe: any = null;\nconst stripeKey = Deno.env.get(\"STRIPE_SECRET\");\n\nif (stripeKey) {\n try {\n const { Stripe } = await import(\"npm:stripe\");\n stripe = new Stripe(stripeKey, {\n apiVersion: \"2024-06-20\",\n });\n } catch (error) {\n console.error(\"Failed to initialize Stripe:\", error);\n }\n}\n\n// Checkout endpoint\napp.post(\"/\", async (c) => {\n try {\n // Check if Stripe is initialized\n if (!stripe) {\n return c.json({ \n error: \"Stripe is not configured. Please set the STRIPE_SECRET environment variable.\" \n }, 500);\n }\n\n const { customerName, pickupLocation, email, productID } = await c.req.json();\n \n // Validate required fields\n if (!customerName || !email || !productID || !pickupLocation) {\n return c.json({ error: \"Missing required fields\" }, 400);\n }\n \n // Get the product from the database\n const item = await getFirstItem();\n if (!item) {\n return c.json({ error: \"Product not found\" }, 404);\n }\n \n // Create a Stripe checkout session\n const session = await stripe.checkout.sessions.create({\n payment_method_types: [\"card\"],\n line_items: [\n {\n price_data: {\n currency: \"usd\",\n product_data: {\n name: item.name,\n },\n unit_amount: 500, // $5 deposit\n },\n quantity: 1,\n },\n ],\n mode: \"payment\",\n customer_email: email,\n success_url: `${c.req.url.origin}/thankyou`,\n cancel_url: `${c.req.url.origin}/canceled`,\n });\n \n // Create a new preorder in the database\n const preorderId = await createPreorder({\n customerName,\n email,\n productID: item.id,\n date: new Date().toISOString(),\n status: \"pending\",\n pickupLocation,\n amountPaid: 0,\n agreedPrice: null,\n completedDate: null,\n sessionID: session.id,\n });\n \n return c.json({ id: session.id, preorderId });\n } catch (error) {\n console.error(\"Checkout error:\", error);\n return c.json({ error: error.message }, 500);\n }\n});\n\nexport default app;",[],[173,583,593],"0c6f9564-1d26-11f0-9dbf-569c3dd06744",108,["D",1745070970300],[194,195,196],[173,583],"022287c4-1d26-11f0-b265-569c3dd06744","queries.ts","02228896-1d26-11f0-b265-569c3dd06744","97362530-90c1-4a48-8e69-ff02e398614b",106,["D",1745070953020],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { ITEMS_TABLE, PREORDERS_TABLE } from \"./migrations.ts\";\n\n// Types matching our database schema\nexport interface Item {\n id: number;\n name: string;\n price: number;\n description: string;\n image: string;\n buyUrl: string;\n}\n\nexport interface Preorder {\n id: number;\n customerName: string;\n email: string;\n productID: number;\n date: string;\n status: \"pending\" | \"completed\" | \"canceled\";\n pickupLocation: \"Wade\" | \"Fribley\";\n amountPaid: number;\n agreedPrice: number | null;\n completedDate: string | null;\n sessionID: string;\n}\n\n// Item queries\nexport async function getItems(): Promise {\n return await sqlite.execute(`SELECT * FROM ${ITEMS_TABLE}`);\n}\n\nexport async function getItem(id: number): Promise {\n const items = await sqlite.execute(`SELECT * FROM ${ITEMS_TABLE} WHERE id = ?`, [id]);\n return items.length > 0 ? items[0] : null;\n}\n\nexport async function getFirstItem(): Promise {\n const items = await sqlite.execute(`SELECT * FROM ${ITEMS_TABLE} LIMIT 1`);\n return items.length > 0 ? items[0] : null;\n}\n\n// Preorder queries\nexport async function createPreorder(preorder: Omit): Promise {\n const result = await sqlite.execute(\n `INSERT INTO ${PREORDERS_TABLE} \n (customerName, email, productID, date, status, pickupLocation, amountPaid, agreedPrice, completedDate, sessionID)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n RETURNING id`,\n [\n preorder.customerName,\n preorder.email,\n preorder.productID,\n preorder.date,\n preorder.status,\n preorder.pickupLocation,\n preorder.amountPaid,\n preorder.agreedPrice,\n preorder.completedDate,\n preorder.sessionID,\n ]\n );\n \n return result[0].id;\n}\n\nexport async function getPreorderBySessionId(sessionId: string): Promise {\n const preorders = await sqlite.execute(\n `SELECT * FROM ${PREORDERS_TABLE} WHERE sessionID = ?`,\n [sessionId]\n );\n \n return preorders.length > 0 ? preorders[0] : null;\n}\n\nexport async function updatePreorderStatus(\n sessionId: string, \n status: \"pending\" | \"completed\" | \"canceled\",\n amountPaid?: number,\n agreedPrice?: number\n): Promise {\n const updateFields = [\"status = ?\"];\n const params: any[] = [status];\n \n if (amountPaid !== undefined) {\n updateFields.push(\"amountPaid = ?\");\n params.push(amountPaid);\n }\n \n if (agreedPrice !== undefined) {\n updateFields.push(\"agreedPrice = ?\");\n params.push(agreedPrice);\n }\n \n if (status === \"completed\") {\n updateFields.push(\"completedDate = ?\");\n params.push(new Date().toISOString());\n }\n \n params.push(sessionId);\n \n const result = await sqlite.execute(\n `UPDATE ${PREORDERS_TABLE} SET ${updateFields.join(\", \")} WHERE sessionID = ?`,\n params\n );\n \n return result.changes > 0;\n}",[],[173,614,606],"database","bb64b694-1d26-11f0-a80c-569c3dd06744","migrations.ts","fa78ba02-1d25-11f0-9575-569c3dd06744",120,["D",1745071263829],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// Table names - use versioning to handle schema changes\nexport const TABLES_PREFIX = \"iclickwolf_\";\nexport const ITEMS_TABLE = TABLES_PREFIX + \"items_v1\";\nexport const PREORDERS_TABLE = TABLES_PREFIX + \"preorders_v1\";\n\n// Create tables if they don't exist\nexport async function runMigrations() {\n // Create items table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${ITEMS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n price INTEGER NOT NULL,\n description TEXT,\n image TEXT,\n buyUrl TEXT\n )\n `);\n\n // Create preorders table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${PREORDERS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n customerName TEXT NOT NULL,\n email TEXT NOT NULL,\n productID INTEGER NOT NULL,\n date TEXT NOT NULL,\n status TEXT NOT NULL CHECK(status IN ('pending', 'completed', 'canceled')),\n pickupLocation TEXT NOT NULL CHECK(pickupLocation IN ('Wade', 'Fribley')),\n amountPaid INTEGER,\n agreedPrice INTEGER,\n completedDate TEXT,\n sessionID TEXT NOT NULL,\n FOREIGN KEY (productID) REFERENCES ${ITEMS_TABLE}(id)\n )\n `);\n\n try {\n // Check if we need to seed the items table\n const itemsResult = await sqlite.execute(`SELECT COUNT(*) as count FROM ${ITEMS_TABLE}`);\n \n // Access the count safely\n const count = itemsResult[0] ? Number(itemsResult[0].count) : 0;\n \n if (count === 0) {\n // Seed with default iClicker item\n await sqlite.execute(\n `\n INSERT INTO ${ITEMS_TABLE} (name, price, description, image, buyUrl)\n VALUES (?, ?, ?, ?, ?)\n `,\n [\n \"iClicker\",\n 4500, // $45.00 in cents\n \"iClicker for CWRU classes\",\n \"https://placehold.co/200x200?text=iClicker\",\n \"\",\n ],\n );\n console.log(\"Seeded items table with default iClicker\");\n }\n } catch (error) {\n console.error(\"Error checking or seeding items table:\", error);\n }\n}",[],[173,614,616],"05896fd6-1d26-11f0-88a1-569c3dd06744","058970b2-1d26-11f0-88a1-569c3dd06744",107,["D",1745070958727],"# Database\n\nThis directory contains the SQLite database setup for the iClickWolf application.\n\n## Files\n\n- `migrations.ts` - Contains the database schema and table creation logic\n- `queries.ts` - Contains typed functions for interacting with the database\n\n## Tables\n\n### Items (items_v1)\nStores product information for iClickers.\n\n### Preorders (preorders_v1)\nStores customer preorder information including payment status.\n\n## Schema Versioning\n\nWhen changing the schema, create a new table with an incremented version number (e.g., `items_v2`) rather than altering existing tables. This is a best practice for SQLite in Val Town.",[],[173,614,146],"fa78d7e4-1d25-11f0-9575-569c3dd06744",105,["D",1745070940161],[190,191,192],[173,614],["D",1745070537017],[189,193,197],[173],["D",1745070536853],{"_99":98,"_106":102},{"_99":98,"_100":-5,"_101":102,"_18":56,"_103":104,"_105":25},{"_13":88,"_32":89,"_44":43,"_90":45,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":46,"_97":98},"ctx",{"_81":-5,"_126":675,"_676":677,"_678":679,"_680":25,"_681":25,"_682":25,"_683":60,"_684":-5,"_685":-7,"_686":-7,"_687":65,"_688":25,"_689":25,"_690":-5,"_691":25,"_692":25,"_693":25,"_694":-5},"ENV",{"_646":647,"_648":649,"_650":89,"_651":652,"_653":654,"_655":656,"_657":658,"_659":660,"_661":662,"_663":664,"_665":666,"_667":668,"_669":670,"_671":672,"_673":674},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","5015b8df46402d8bba4f485ecc37aec202b0e06b","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","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v126