[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_568":569,"_570":571},"routes/_app.x.$handle.$name",{"_96":95,"_31":43,"_104":86,"_26":105,"_13":14,"_106":-5,"_11":107,"_108":109,"_110":111,"_112":113,"_114":115,"_20":-5,"_116":-5,"_117":-5,"_118":24,"_119":120,"_121":57,"_122":-5,"_123":-5,"_124":125},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_41":42,"_31":43,"_36":44,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":51,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":-5,"_59":60,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":79,"_80":81,"_82":83,"_84":24},"version",107,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":32,"_33":20,"_34":35,"_36":37,"_38":14,"_39":40,"_23":24},"previous","deleted",false,"deletedHere","path","backend/database/README.md","latestPath","fileId","058970b2-1d26-11f0-88a1-569c3dd06744","name","README.md","fileType","content","# 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.","createdAt",["D",1745070958727],"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",{"_96":95,"_103":99},"org",{"_96":95,"_97":-5,"_98":99,"_18":53,"_100":101,"_102":24},"branch",{"_13":85,"_31":86,"_41":40,"_87":42,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":43,"_94":95},"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",{"_41":42,"_31":43,"_36":564,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":51,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":-5,"_59":60,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":565,"_80":566,"_82":567,"_84":24},"tree",[184,190,195,229,230,231],"files",[184,185,186,187,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],"counts",{"_173":62,"_174":170,"_175":62,"_176":177,"_178":179},"contents",[126,127,128,129,130,131],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_41":167,"_31":168,"_29":169,"_135":-5,"_39":40,"_38":170,"_137":57,"_36":171,"_13":62,"_33":159,"_34":-5,"_23":24,"_140":-5,"_26":172},{"_41":161,"_31":162,"_29":163,"_135":-5,"_39":40,"_38":164,"_137":57,"_36":165,"_13":62,"_33":159,"_34":-5,"_23":24,"_140":-5,"_26":166},{"_41":154,"_31":155,"_29":156,"_135":-5,"_39":40,"_38":157,"_137":24,"_36":158,"_13":62,"_33":159,"_34":-5,"_23":24,"_140":-5,"_26":160},{"_41":148,"_31":149,"_29":150,"_135":-5,"_39":40,"_38":151,"_137":57,"_36":152,"_13":62,"_33":20,"_34":105,"_23":24,"_140":-5,"_26":153},{"_41":142,"_31":32,"_29":143,"_135":-5,"_39":40,"_38":144,"_137":24,"_36":145,"_13":62,"_33":20,"_34":146,"_23":24,"_140":-5,"_26":147},{"_41":132,"_31":133,"_29":134,"_135":-5,"_39":40,"_38":136,"_137":24,"_36":138,"_13":62,"_33":20,"_34":139,"_23":24,"_140":-5,"_26":141},"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",[133],"0a5d58b6-1d25-11f0-b3df-569c3dd06744","0a5d5960-1d25-11f0-b3df-569c3dd06744",8,["D",1745070537237],"# React Hono Starter\n\nThis app is a starter template for client-side React and server-side Hono.\n\n- **Remix** this starter template on the top right to get started.\n\n- The **entrypoint** is `/backend/index.ts`. That's the backend HTTP server, which also serves the all the frontend assets.\n\n- The **client-side entrypoint** is `/frontend/index.html`, which in turn imports `/frontend/index.tsx`, which in turn imports the React app from `/frontend/components/App.tsx`.\n\n[React Hono Example](https://www.val.town/x/stevekrouse/reactHonoExample) is a fuller featured example project, with a SQLite database table, queries, client-side CSS and a favicon, and some shared code that runs on both client and server.",[32],"808049a4-1d25-11f0-8967-569c3dd06744",".vtignore","80804a3a-1d25-11f0-8967-569c3dd06744",95,["D",1745070735006],[149],"44a65482-1d25-11f0-8f40-569c3dd06744","iclickwolf-old","44a6550e-1d25-11f0-8f40-569c3dd06744",10,["D",1745070635115],"directory",[155],"0a37adfa-1d25-11f0-99f3-569c3dd06744","frontend","0a37aeb8-1d25-11f0-99f3-569c3dd06744",2,["D",1745070537083],[162],"0a2db408-1d25-11f0-99f3-569c3dd06744","backend","0a2db49e-1d25-11f0-99f3-569c3dd06744",1,["D",1745070537017],[168],"pulls","branches","forks","envVars",{"_180":182,"_183":62},"connections",{"_180":62,"_181":62},"count","unfilledCount",3,"emptyCount",{"_41":167,"_31":168,"_29":169,"_135":-5,"_39":40,"_38":170,"_137":57,"_36":561,"_13":62,"_33":159,"_34":-5,"_23":24,"_140":-5,"_233":562,"_26":563},{"_41":557,"_31":544,"_29":538,"_135":169,"_39":40,"_38":548,"_137":57,"_36":558,"_13":62,"_33":159,"_34":-5,"_23":24,"_140":-5,"_233":559,"_26":560},{"_41":553,"_31":32,"_29":30,"_135":538,"_39":40,"_38":14,"_137":24,"_36":554,"_13":62,"_33":20,"_34":35,"_23":24,"_140":-5,"_233":555,"_26":556},{"_41":545,"_31":546,"_29":547,"_135":538,"_39":40,"_38":548,"_137":24,"_36":549,"_13":62,"_33":255,"_34":550,"_23":24,"_140":-5,"_233":551,"_26":552},{"_41":535,"_31":536,"_29":537,"_135":538,"_39":40,"_38":539,"_137":24,"_36":540,"_13":62,"_33":255,"_34":541,"_23":24,"_140":-5,"_233":542,"_26":543},{"_41":526,"_31":527,"_29":55,"_135":169,"_39":40,"_38":528,"_137":24,"_36":529,"_13":170,"_33":530,"_34":531,"_23":24,"_140":532,"_233":533,"_26":534},{"_41":161,"_31":162,"_29":163,"_135":-5,"_39":40,"_38":164,"_137":57,"_36":523,"_13":62,"_33":159,"_34":-5,"_23":24,"_140":-5,"_233":524,"_26":525},{"_41":519,"_31":340,"_29":513,"_135":163,"_39":40,"_38":182,"_137":57,"_36":520,"_13":62,"_33":159,"_34":-5,"_23":24,"_140":-5,"_233":521,"_26":522},{"_41":510,"_31":511,"_29":512,"_135":513,"_39":40,"_38":514,"_137":24,"_36":515,"_13":62,"_33":255,"_34":516,"_23":24,"_140":-5,"_233":517,"_26":518},{"_41":502,"_31":503,"_29":504,"_135":163,"_39":40,"_38":505,"_137":24,"_36":506,"_13":62,"_33":20,"_34":507,"_23":24,"_140":-5,"_233":508,"_26":509},{"_41":494,"_31":495,"_29":496,"_135":163,"_39":40,"_38":497,"_137":24,"_36":498,"_13":62,"_33":255,"_34":499,"_23":24,"_140":-5,"_233":500,"_26":501},{"_41":154,"_31":155,"_29":156,"_135":-5,"_39":40,"_38":157,"_137":24,"_36":491,"_13":62,"_33":159,"_34":-5,"_23":24,"_140":-5,"_233":492,"_26":493},{"_41":486,"_31":307,"_29":301,"_135":156,"_39":40,"_38":487,"_137":24,"_36":488,"_13":62,"_33":159,"_34":-5,"_23":24,"_140":-5,"_233":489,"_26":490},{"_41":481,"_31":363,"_29":357,"_135":301,"_39":40,"_38":482,"_137":24,"_36":483,"_13":62,"_33":159,"_34":-5,"_23":24,"_140":-5,"_233":484,"_26":485},{"_41":476,"_31":454,"_29":471,"_135":357,"_39":40,"_38":477,"_137":24,"_36":478,"_13":62,"_33":159,"_34":-5,"_23":24,"_140":-5,"_233":479,"_26":480},{"_41":470,"_31":455,"_29":448,"_135":471,"_39":40,"_38":472,"_137":24,"_36":473,"_13":62,"_33":159,"_34":-5,"_23":24,"_140":-5,"_233":474,"_26":475},{"_41":465,"_31":464,"_29":458,"_135":448,"_39":40,"_38":466,"_137":24,"_36":467,"_13":62,"_33":159,"_34":-5,"_23":24,"_140":-5,"_233":468,"_26":469},{"_41":456,"_31":446,"_29":457,"_135":458,"_39":40,"_38":459,"_137":24,"_36":460,"_13":62,"_33":255,"_34":461,"_23":24,"_140":-5,"_233":462,"_26":463},{"_41":445,"_31":446,"_29":447,"_135":448,"_39":40,"_38":449,"_137":24,"_36":450,"_13":62,"_33":255,"_34":451,"_23":24,"_140":-5,"_233":452,"_26":453},{"_41":440,"_31":439,"_29":433,"_135":357,"_39":40,"_38":441,"_137":24,"_36":442,"_13":62,"_33":159,"_34":-5,"_23":24,"_140":-5,"_233":443,"_26":444},{"_41":431,"_31":355,"_29":432,"_135":433,"_39":40,"_38":434,"_137":24,"_36":435,"_13":62,"_33":255,"_34":436,"_23":24,"_140":-5,"_233":437,"_26":438},{"_41":426,"_31":402,"_29":421,"_135":357,"_39":40,"_38":427,"_137":24,"_36":428,"_13":62,"_33":159,"_34":-5,"_23":24,"_140":-5,"_233":429,"_26":430},{"_41":420,"_31":403,"_29":396,"_135":421,"_39":40,"_38":422,"_137":24,"_36":423,"_13":62,"_33":159,"_34":-5,"_23":24,"_140":-5,"_233":424,"_26":425},{"_41":412,"_31":413,"_29":414,"_135":396,"_39":40,"_38":415,"_137":24,"_36":416,"_13":62,"_33":255,"_34":417,"_23":24,"_140":-5,"_233":418,"_26":419},{"_41":404,"_31":405,"_29":406,"_135":396,"_39":40,"_38":407,"_137":24,"_36":408,"_13":62,"_33":255,"_34":409,"_23":24,"_140":-5,"_233":410,"_26":411},{"_41":394,"_31":355,"_29":395,"_135":396,"_39":40,"_38":397,"_137":24,"_36":398,"_13":62,"_33":255,"_34":399,"_23":24,"_140":-5,"_233":400,"_26":401},{"_41":389,"_31":388,"_29":382,"_135":357,"_39":40,"_38":390,"_137":24,"_36":391,"_13":62,"_33":159,"_34":-5,"_23":24,"_140":-5,"_233":392,"_26":393},{"_41":380,"_31":355,"_29":381,"_135":382,"_39":40,"_38":383,"_137":24,"_36":384,"_13":62,"_33":255,"_34":385,"_23":24,"_140":-5,"_233":386,"_26":387},{"_41":372,"_31":373,"_29":374,"_135":357,"_39":40,"_38":375,"_137":24,"_36":376,"_13":62,"_33":20,"_34":377,"_23":24,"_140":-5,"_233":378,"_26":379},{"_41":364,"_31":365,"_29":366,"_135":357,"_39":40,"_38":367,"_137":24,"_36":368,"_13":62,"_33":255,"_34":369,"_23":24,"_140":-5,"_233":370,"_26":371},{"_41":354,"_31":355,"_29":356,"_135":357,"_39":40,"_38":358,"_137":24,"_36":359,"_13":62,"_33":255,"_34":360,"_23":24,"_140":-5,"_233":361,"_26":362},{"_41":349,"_31":340,"_29":334,"_135":301,"_39":40,"_38":350,"_137":24,"_36":351,"_13":62,"_33":159,"_34":-5,"_23":24,"_140":-5,"_233":352,"_26":353},{"_41":341,"_31":342,"_29":343,"_135":334,"_39":40,"_38":344,"_137":24,"_36":345,"_13":62,"_33":255,"_34":346,"_23":24,"_140":-5,"_233":347,"_26":348},{"_41":331,"_31":332,"_29":333,"_135":334,"_39":40,"_38":335,"_137":24,"_36":336,"_13":62,"_33":255,"_34":337,"_23":24,"_140":-5,"_233":338,"_26":339},{"_41":326,"_31":317,"_29":311,"_135":301,"_39":40,"_38":327,"_137":24,"_36":328,"_13":62,"_33":159,"_34":-5,"_23":24,"_140":-5,"_233":329,"_26":330},{"_41":318,"_31":319,"_29":320,"_135":311,"_39":40,"_38":321,"_137":24,"_36":322,"_13":62,"_33":255,"_34":323,"_23":24,"_140":-5,"_233":324,"_26":325},{"_41":308,"_31":309,"_29":310,"_135":311,"_39":40,"_38":312,"_137":24,"_36":313,"_13":62,"_33":255,"_34":314,"_23":24,"_140":-5,"_233":315,"_26":316},{"_41":298,"_31":299,"_29":300,"_135":301,"_39":40,"_38":302,"_137":24,"_36":303,"_13":62,"_33":255,"_34":304,"_23":24,"_140":-5,"_233":305,"_26":306},{"_41":290,"_31":291,"_29":292,"_135":156,"_39":40,"_38":293,"_137":24,"_36":294,"_13":62,"_33":20,"_34":295,"_23":24,"_140":-5,"_233":296,"_26":297},{"_41":282,"_31":283,"_29":284,"_135":156,"_39":40,"_38":285,"_137":24,"_36":286,"_13":62,"_33":20,"_34":287,"_23":24,"_140":-5,"_233":288,"_26":289},{"_41":275,"_31":32,"_29":276,"_135":156,"_39":40,"_38":277,"_137":24,"_36":278,"_13":62,"_33":20,"_34":279,"_23":24,"_140":-5,"_233":280,"_26":281},{"_41":267,"_31":268,"_29":269,"_135":156,"_39":40,"_38":270,"_137":24,"_36":271,"_13":62,"_33":255,"_34":272,"_23":24,"_140":-5,"_233":273,"_26":274},{"_41":259,"_31":260,"_29":261,"_135":156,"_39":40,"_38":262,"_137":24,"_36":263,"_13":62,"_33":255,"_34":264,"_23":24,"_140":-5,"_233":265,"_26":266},{"_41":250,"_31":251,"_29":252,"_135":156,"_39":40,"_38":253,"_137":24,"_36":254,"_13":62,"_33":255,"_34":256,"_23":24,"_140":-5,"_233":257,"_26":258},{"_41":242,"_31":243,"_29":244,"_135":156,"_39":40,"_38":245,"_137":24,"_36":246,"_13":62,"_33":20,"_34":247,"_23":24,"_140":-5,"_233":248,"_26":249},{"_41":148,"_31":149,"_29":150,"_135":-5,"_39":40,"_38":151,"_137":57,"_36":239,"_13":62,"_33":20,"_34":105,"_23":24,"_140":-5,"_233":240,"_26":241},{"_41":142,"_31":32,"_29":143,"_135":-5,"_39":40,"_38":144,"_137":24,"_36":236,"_13":62,"_33":20,"_34":146,"_23":24,"_140":-5,"_233":237,"_26":238},{"_41":132,"_31":133,"_29":134,"_135":-5,"_39":40,"_38":136,"_137":24,"_36":232,"_13":62,"_33":20,"_34":139,"_23":24,"_140":-5,"_233":234,"_26":235},["D",1745070637386],"children",[],[133],["D",1745070537237],[],[32],["D",1745070735006],[],[149],"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",[],[155,243],"7a0d4e0a-1d25-11f0-a079-569c3dd06744","postcss.config.js","7a0d4ea0-1d25-11f0-a079-569c3dd06744",76,["D",1745070704745],"script","module.exports = {\n plugins: {\n tailwindcss: {},\n autoprefixer: {},\n },\n}\n",[],[155,251],"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",[],[155,260],"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",[],[155,268],"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",[],[155,32],"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",[],[155,283],"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",[],[155,291],"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",[],[155,307,299],"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",[],[155,307,317,309],"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",[],[155,307,317,319],"453ad846-1d25-11f0-9681-569c3dd06744",26,["D",1745070636089],[219,220],[155,307,317],"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",[],[155,307,340,332],"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",[],[155,307,340,342],"4531cd8c-1d25-11f0-ab73-569c3dd06744",25,["D",1745070636031],[216,217],[155,307,340],"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",[],[155,307,363,355],"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",[],[155,307,363,365],"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",[],[155,307,363,373],"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",[],[155,307,363,388,355],"thankyou","459fddd6-1d25-11f0-8f40-569c3dd06744",37,["D",1745070636752],[211],[155,307,363,388],"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",[],[155,307,363,402,403,355],"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",[],[155,307,363,402,403,405],"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",[],[155,307,363,402,403,413],"45e04268-1d25-11f0-8f40-569c3dd06744","4597a094-1d25-11f0-b686-569c3dd06744",44,["D",1745070637173],[207,208,209],[155,307,363,402,403],"45979fea-1d25-11f0-b686-569c3dd06744",36,["D",1745070636699],[206],[155,307,363,402],"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",[],[155,307,363,439,355],"canceled","458f0998-1d25-11f0-9137-569c3dd06744",35,["D",1745070636643],[204],[155,307,363,439],"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",[],[155,307,363,454,455,446],"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",[],[155,307,363,454,455,464,446],"callback","45f1a562-1d25-11f0-b1b6-569c3dd06744",46,["D",1745070637288],[201],[155,307,363,454,455,464],"45d7bcd8-1d25-11f0-b051-569c3dd06744","45861ff4-1d25-11f0-9681-569c3dd06744",43,["D",1745070637117],[200,202],[155,307,363,454,455],"45861f2c-1d25-11f0-9681-569c3dd06744",34,["D",1745070636583],[199],[155,307,363,454],"452761bc-1d25-11f0-b3df-569c3dd06744",24,["D",1745070635962],[198,203,205,210,212,213,214],[155,307,363],"44d488b6-1d25-11f0-8f91-569c3dd06744",15,["D",1745070635419],[197,215,218,221],[155,307],["D",1745070635115],[196,222,223,224,225,226,227,228],[155],"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();",[],[162,495],"0a520fce-1d25-11f0-a6aa-569c3dd06744","index.html","0a52108c-1d25-11f0-a6aa-569c3dd06744",5,["D",1745070537236],"\n\n \n \n \n React Hono Val Town Starter\n \n \n \n \n

\n \n \n \n",[],[162,503],"0a559982-1d25-11f0-99f3-569c3dd06744","App.tsx","0a559a36-1d25-11f0-99f3-569c3dd06744","0a419d38-1d25-11f0-9acd-569c3dd06744",6,["D",1745070537236],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState } from \"https://esm.sh/react@18.2.0\";\n\nexport function App() {\n const [clicked, setClicked] = useState(0);\n return (\n

Val Town React + Hono Starter

\n I've been clicked times\n

\n );\n}",[],[162,340,511],"0a419c84-1d25-11f0-9acd-569c3dd06744",["D",1745070537150],[192],[162,340],["D",1745070537083],[191,193,194],[162],"0a6c3afc-1d25-11f0-9565-569c3dd06744","index.ts",9,["D",1745070537421],"http","import { serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { Hono } from \"npm:hono\";\n\nconst app = new Hono();\n\n// Serve index.html at the root /\napp.get(\"/\", async c => {\n return serveFile(\"/frontend/index.html\", import.meta.url);\n});\n\n// Serve all /frontend files\napp.get(\"/frontend/**/*\", c => serveFile(c.req.path, import.meta.url));\n\n// Add your API routes here\n// app.get(\"/api/data\", c => c.json({ hello: \"world\" }));\n\n// Unwrap and rethrow Hono errors as the original error\n// If you delete this, all errors will be \"Internal Server Error\"\napp.onError((err, c) => {\n throw err;\n});\n\n// HTTP vals expect an exported \"fetch handler\"\n// This is how you \"run the server\" in Val Town with Hono\nexport default app.fetch;","iclickwolf",[],[168,527],"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}",[],[168,544,536],"database","fa78b912-1d25-11f0-9575-569c3dd06744","migrations.ts","fa78ba02-1d25-11f0-9575-569c3dd06744",105,["D",1745070940161],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// Table names - use versioning to handle schema changes\nexport const ITEMS_TABLE = \"items_v1\";\nexport const PREORDERS_TABLE = \"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 // Check if we need to seed the items table\n const items = await sqlite.execute(`SELECT COUNT(*) as count FROM ${ITEMS_TABLE}`);\n if (items[0].count === 0) {\n // Seed with default iClicker item\n await sqlite.execute(`\n INSERT INTO ${ITEMS_TABLE} (name, price, description, image, buyUrl)\n VALUES (?, ?, ?, ?, ?)\n `, [\n \"iClicker\",\n 4500, // $45.00 in cents\n \"iClicker for CWRU classes\",\n \"/frontend/assets/iclicker.jpg\",\n \"\"\n ]);\n }\n}",[],[168,544,546],"05896fd6-1d26-11f0-88a1-569c3dd06744",["D",1745070958727],[],[168,544,32],"fa78d7e4-1d25-11f0-9575-569c3dd06744",["D",1745070940161],[186,187,188],[168,544],["D",1745070537017],[185,189],[168],["D",1745070536853],{"_96":95,"_103":99},{"_96":95,"_97":-5,"_98":99,"_18":53,"_100":101,"_102":24},{"_13":85,"_31":86,"_41":40,"_87":42,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":43,"_94":95},"ctx",{"_78":-5,"_123":601,"_602":603,"_604":605,"_606":24,"_607":24,"_608":24,"_609":57,"_610":-5,"_611":-7,"_612":-7,"_613":62,"_614":24,"_615":24,"_616":-5,"_617":24,"_618":24,"_619":24,"_620":-5},"ENV",{"_572":573,"_574":575,"_576":86,"_577":578,"_579":580,"_581":582,"_583":584,"_585":586,"_587":588,"_589":590,"_591":592,"_593":594,"_595":596,"_597":598,"_599":600},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","811aa22498c9b0b5a47e8d778de579cdb990f332","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 · v107