[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_594":595,"_596":597},"routes/_app.x.$handle.$name",{"_98":97,"_32":49,"_106":88,"_27":107,"_13":14,"_108":-5,"_11":109,"_110":111,"_112":113,"_114":115,"_116":117,"_21":-5,"_118":-5,"_119":-5,"_120":25,"_121":122,"_123":25,"_124":-5,"_125":-5,"_126":127},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_47":48,"_32":49,"_36":50,"_51":-5,"_52":25,"_53":54,"_55":54,"_56":-5,"_57":-5,"_18":58,"_59":-5,"_60":25,"_61":-5,"_62":-5,"_63":64,"_65":66,"_67":-5,"_68":-5,"_69":-5,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":81,"_82":83,"_84":85,"_86":25},"version",35,"changes",[19,20],"aiChatInfo","userId",{"_21":41,"_23":-7,"_24":25,"_26":25,"_27":42,"_29":42},{"_21":22,"_23":-7,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":-5,"_36":37,"_38":14,"_39":40,"_24":25},"previous","deleted",false,"deletedHere","path","menu","latestPath","fileId","af1f6066-00dc-45e2-ae17-f30b9fe07a1f","name","fileType","directory","content","createdAt",["D",1779200527795],"branchVersion","branchId","0a0b415c-538e-11f1-869b-ee650bb23af1",{"_30":43,"_32":44,"_33":21,"_35":45,"_36":46,"_38":14,"_39":40,"_24":25},"menu/get.ts","1df1e89c-538e-11f1-b9b6-ee650bb23af1","get.ts","import { db, eq } from '../db.ts';\nimport { categories } from '../categories/categories.table.ts';\nimport { items } from '../items/items.table.ts';\nimport { toppings } from '../toppings/toppings.table.ts';\nimport { itemToppings } from '../item_toppings/item_toppings.table.ts';\n\nexport default async function handler() {\n // Fetch all categories sorted by sortable categories\n const cats = await db\n .select()\n .from(categories)\n .orderBy(categories.sort_order);\n\n // Fetch only active items\n const activeItems = await db\n .select()\n .from(items)\n .where(eq(items.status, 'active'));\n\n // Fetch all item-topping relations with topping details\n const toppingRows = await db\n .select({\n itemId: itemToppings.item_id,\n topping: {\n id: toppings.id,\n name: toppings.name,\n price: toppings.price,\n },\n })\n .from(itemToppings)\n .innerJoin(toppings, eq(itemToppings.topping_id, toppings.id));\n\n // Group toppings by item id\n const toppingByItem = new Map();\n for (const row of toppingRows) {\n const list = toppingByItem.get(row.itemId);\n if (list) {\n list.push(row.topping);\n } elserow.topping);\n toppingByItem.set(row.itemId, [row.topping]);\n }\n }\n\n // Build category → items structure\n const categoryMap = new Map;\n }>;\n }>();\n\n for (const cat of cats) {\n categoryMap.set(cat.id, { ...cat, items: [] });\n }\n\n for (const item of activeItems) {\n const parent = categoryMap.get(item.category_id);\n if (!parent) continue;\n\n parent.items.push({\n id: item.id,\n name: item.name,\n price: item.price,\n description: item.description,\n image: item.image,\n status: item.status,\n toppings: toppingByItem.get(item.id) || [],\n });\n }\n\n return Array.from(categoryMap.values());\n}",["D",1779200527795],"id","0a0a74ac-538e-11f1-869b-ee650bb23af1","flowtest-72m0b34v",["D",1779200494411],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","3fa51a00-4088-11f0-bfbe-7da0210b7c9d","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","1debf5ae-5acf-4d9b-bb1c-6834e6cfc9b9","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_98":97,"_105":101},"org",{"_98":97,"_99":-5,"_100":101,"_18":58,"_102":103,"_104":25},"branch",{"_13":87,"_32":88,"_47":40,"_89":48,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":49,"_96":97},"isOwned",56,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","ictuer","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yeTBCNXpSZ2xvMENDdWhEM2ZzbmhKQndVenUifQ","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_47":48,"_32":49,"_36":590,"_51":-5,"_52":25,"_53":54,"_55":54,"_56":-5,"_57":-5,"_18":58,"_59":-5,"_60":25,"_61":-5,"_62":-5,"_63":64,"_65":66,"_67":-5,"_68":-5,"_69":-5,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":591,"_82":592,"_84":593,"_86":25},"tree",[225,232,240,250,258,266,268,270,272,274,276,277],"files",[225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277],"counts",{"_215":64,"_216":206,"_217":64,"_218":219,"_220":221},"contents",[128,129,130,131,132,133,134,135,136,137,138,139],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_47":209,"_32":210,"_30":211,"_143":-5,"_39":40,"_38":212,"_145":146,"_36":213,"_13":64,"_33":34,"_35":-5,"_24":25,"_149":-5,"_27":214},{"_47":203,"_32":204,"_30":205,"_143":-5,"_39":40,"_38":206,"_145":146,"_36":207,"_13":64,"_33":34,"_35":-5,"_24":25,"_149":-5,"_27":208},{"_47":197,"_32":198,"_30":199,"_143":-5,"_39":40,"_38":200,"_145":146,"_36":201,"_13":64,"_33":34,"_35":-5,"_24":25,"_149":-5,"_27":202},{"_47":191,"_32":192,"_30":193,"_143":-5,"_39":40,"_38":194,"_145":146,"_36":195,"_13":64,"_33":34,"_35":-5,"_24":25,"_149":-5,"_27":196},{"_47":185,"_32":186,"_30":187,"_143":-5,"_39":40,"_38":188,"_145":146,"_36":189,"_13":64,"_33":34,"_35":-5,"_24":25,"_149":-5,"_27":190},{"_47":182,"_32":28,"_30":31,"_143":-5,"_39":40,"_38":14,"_145":146,"_36":183,"_13":64,"_33":34,"_35":-5,"_24":25,"_149":-5,"_27":184},{"_47":176,"_32":177,"_30":178,"_143":-5,"_39":40,"_38":179,"_145":146,"_36":180,"_13":64,"_33":34,"_35":-5,"_24":25,"_149":-5,"_27":181},{"_47":170,"_32":171,"_30":172,"_143":-5,"_39":40,"_38":173,"_145":146,"_36":174,"_13":64,"_33":34,"_35":-5,"_24":25,"_149":-5,"_27":175},{"_47":164,"_32":165,"_30":166,"_143":-5,"_39":40,"_38":167,"_145":146,"_36":168,"_13":64,"_33":34,"_35":-5,"_24":25,"_149":-5,"_27":169},{"_47":158,"_32":159,"_30":160,"_143":-5,"_39":40,"_38":161,"_145":146,"_36":162,"_13":64,"_33":34,"_35":-5,"_24":25,"_149":-5,"_27":163},{"_47":151,"_32":152,"_30":153,"_143":-5,"_39":40,"_38":154,"_145":146,"_36":155,"_13":64,"_33":21,"_35":156,"_24":25,"_149":-5,"_27":157},{"_47":140,"_32":141,"_30":142,"_143":-5,"_39":40,"_38":144,"_145":146,"_36":147,"_13":64,"_33":21,"_35":148,"_24":25,"_149":-5,"_27":150},"111d4260-538e-11f1-b04e-ee650bb23af1","middleware-rbac.ts","111d4328-538e-11f1-b04e-ee650bb23af1","parentId",6,"latest",true,["D",1779200506262],"import { db, eq } from \"./db.ts\";\nimport { users } from \"./users/users.table.ts\";\n\nconst RULES: Array<{ re: RegExp; roles: Set }> = [\n \n { re: new RegExp(\"^/categories(/|$)\"), roles: new Set([\"manager\",]) },\n \n { re: new RegExp(\"^/items(/|$)\"), roles: new Set([\"manager\",]) },\n \n { re: new RegExp(\"^/toppings(/|$)\"), roles: new Set([\"manager\",]) },\n \n { re: new RegExp(\"^/item_toppings(/|$)\"), roles: new Set([\"manager\",]) },\n \n { re: new RegExp(\"^/customers(/|$)\"), roles: new Set([\"manager\",]) },\n \n];\n\nconst userCache = new Map();\nconst CACHE_MS = 30_000;\n\n/**\n * RBAC middleware. Must mount AFTER auth middleware (which sets c.get(\"userId\")).\n * For each rule whose regex matches the URL path, the user.role must be in roles.\n * If multiple rules match, all must allow.\n */\nexport default async function rbac(c: any, next: any) {\n const path = new URL(c.req.url).pathname;\n const matched = RULES.filter((r) => r.re.test(path));\n if (matched.length === 0) return next();\n\n const userId = Number(c.get?.(\"userId\") ?? c.get?.(\"user\")?.id ?? 0);\n if (!Number.isFinite(userId) || userId <= 0) {\n c.status(401);\n return c.json({ error: \"unauthorized\" });\n }\n\n let cached = userCache.get(userId);\n if (!cached || Date.now() - cached.at > CACHE_MS) {\n const [u] = await db.select().from(users).where(eq((users as any).id, userId));\n cached = { role: (u as any)?.role ?? null, at: Date.now() };\n userCache.set(userId, cached);\n }\n\n const role = cached.role ?? \"\";\n for (const r of matched) {\n if (!r.roles.has(role)) {\n c.status(403);\n return c.json({ error: \"forbidden\", role, required: [...r.roles] });\n }\n }\n return next();\n}\n","label",[141],"0fd11062-538e-11f1-9e88-ee650bb23af1","db.ts","0fd1112a-538e-11f1-9e88-ee650bb23af1",3,["D",1779200504083],"// AUTO-GENERATED by Manh. Do not edit.\n//\n// Drizzle helpers barrel. Per-entity tables are NOT re-exported from here —\n// each lives at `app//.table.ts` and handlers import\n// directly from the relative path, e.g.\n// import { db, eq } from \"app/db\";\n// import { products } from \"./products.table\";\n// This makes table provenance grep-able and removes a magic barrel.\nimport { createClient } from \"npm:@libsql/client@0.14.0\";\nimport { drizzle } from \"npm:drizzle-orm@0.44.2/libsql/web\";\nexport { sqliteTable, integer, text, real, blob } from \"npm:drizzle-orm@0.44.2/sqlite-core\";\nexport { eq, ne, lt, lte, gt, gte, like, ilike, and, or, not, isNull, isNotNull, inArray, notInArray, between, asc, desc, sql, count, sum, avg, min, max } from \"npm:drizzle-orm@0.44.2\";\nexport { alias } from \"npm:drizzle-orm@0.44.2/sqlite-core\";\n\nconst client = createClient({\n url: \"libsql://ft-c87529eef42b643608e635f93-ictuer.turso.io\",\n authToken: \"eyJhbGciOiJFZERTQSIsInR5cCI6IkpXVCJ9.eyJpYXQiOjE3NzkyMDA0OTYsImlkIjoiMDE5ZTQwOWQtMGQwMS03MDQwLWFiMDctZmQwODhhMWI2OTczIiwicmlkIjoiYTA4NTRkNmQtNWU4Ny00MjAwLTkzYjItZjc1ZDEwYWEzNTQ1In0.ZaELDfkr6rvAPL0IYJwwU7oUUVLC7Nk2vFssD7BqmrsDY0XnG0NM_4AqzP1woA6EMHi-TX-3D24PtgMxz9F2Dg\",\n});\nexport const db = drizzle(client);\n",[152],"12938118-538e-11f1-961c-ee650bb23af1","users","63ba00c1-b0bd-4da6-8a19-f24b493ed350",10,["D",1779200508719],[159],"1238fae0-538e-11f1-961c-ee650bb23af1","toppings","f0390e62-9bf0-4d55-a0aa-d2f06ebb1f60",9,["D",1779200508127],[165],"11dea2fc-538e-11f1-a631-ee650bb23af1","orders","e0014934-2105-4b85-8ae1-08943dd7eeac",8,["D",1779200507533],[171],"117bc1c8-538e-11f1-961c-ee650bb23af1","order_items","fb7f3804-3a85-477d-9b4c-1781458cffb1",7,["D",1779200506879],[177],"1df1fd1e-538e-11f1-b9b6-ee650bb23af1",["D",1779200527795],[28],"10938296-538e-11f1-9e88-ee650bb23af1","items","1bb073c9-c1d6-4b02-a95d-9625e8dd06ad",5,["D",1779200505362],[186],"103b6e4e-538e-11f1-ae69-ee650bb23af1","item_toppings","c37d6086-e8db-4152-a564-d5729ab5da3e",4,["D",1779200504788],[192],"0f6fb128-538e-11f1-8d89-ee650bb23af1","customers","f47ebe5e-c25f-4902-891b-dd6ffcd0e6e5",2,["D",1779200503414],[198],"0ec43b2c-538e-11f1-ae69-ee650bb23af1","categories","06e0bf5b-302d-4dbd-9e7c-29de34f276e2",1,["D",1779200502324],[204],"12ea5d26-538e-11f1-9240-ee650bb23af1","auth","78641fc9-2541-4b88-b8f0-012b1a61d4f7",11,["D",1779200509288],[210],"pulls","branches","forks","envVars",{"_222":64,"_224":64},"connections",{"_222":64,"_223":64},"count","unfilledCount","emptyCount",{"_47":209,"_32":210,"_30":211,"_143":-5,"_39":40,"_38":212,"_145":146,"_36":587,"_13":64,"_33":34,"_35":-5,"_24":25,"_149":-5,"_279":588,"_27":589},{"_47":583,"_32":582,"_30":577,"_143":211,"_39":40,"_38":212,"_145":146,"_36":584,"_13":64,"_33":34,"_35":-5,"_24":25,"_149":-5,"_279":585,"_27":586},{"_47":575,"_32":333,"_30":576,"_143":577,"_39":40,"_38":212,"_145":146,"_36":578,"_13":64,"_33":21,"_35":579,"_24":25,"_149":-5,"_279":580,"_27":581},{"_47":571,"_32":570,"_30":564,"_143":211,"_39":40,"_38":565,"_145":146,"_36":572,"_13":64,"_33":34,"_35":-5,"_24":25,"_149":-5,"_279":573,"_27":574},{"_47":562,"_32":44,"_30":563,"_143":564,"_39":40,"_38":565,"_145":146,"_36":566,"_13":64,"_33":21,"_35":567,"_24":25,"_149":-5,"_279":568,"_27":569},{"_47":558,"_32":557,"_30":551,"_143":211,"_39":40,"_38":552,"_145":146,"_36":559,"_13":64,"_33":34,"_35":-5,"_24":25,"_149":-5,"_279":560,"_27":561},{"_47":549,"_32":333,"_30":550,"_143":551,"_39":40,"_38":552,"_145":146,"_36":553,"_13":64,"_33":21,"_35":554,"_24":25,"_149":-5,"_279":555,"_27":556},{"_47":203,"_32":204,"_30":205,"_143":-5,"_39":40,"_38":206,"_145":146,"_36":546,"_13":64,"_33":34,"_35":-5,"_24":25,"_149":-5,"_279":547,"_27":548},{"_47":542,"_32":363,"_30":522,"_143":205,"_39":40,"_38":537,"_145":146,"_36":543,"_13":64,"_33":34,"_35":-5,"_24":25,"_149":-5,"_279":544,"_27":545},{"_47":535,"_32":372,"_30":536,"_143":522,"_39":40,"_38":537,"_145":146,"_36":538,"_13":64,"_33":21,"_35":539,"_24":25,"_149":-5,"_279":540,"_27":541},{"_47":528,"_32":44,"_30":529,"_143":522,"_39":40,"_38":530,"_145":146,"_36":531,"_13":64,"_33":21,"_35":532,"_24":25,"_149":-5,"_279":533,"_27":534},{"_47":520,"_32":355,"_30":521,"_143":522,"_39":40,"_38":523,"_145":146,"_36":524,"_13":64,"_33":21,"_35":525,"_24":25,"_149":-5,"_279":526,"_27":527},{"_47":513,"_32":514,"_30":515,"_143":205,"_39":40,"_38":206,"_145":146,"_36":516,"_13":64,"_33":21,"_35":517,"_24":25,"_149":-5,"_279":518,"_27":519},{"_47":506,"_32":44,"_30":507,"_143":205,"_39":40,"_38":508,"_145":146,"_36":509,"_13":64,"_33":21,"_35":510,"_24":25,"_149":-5,"_279":511,"_27":512},{"_47":499,"_32":333,"_30":500,"_143":205,"_39":40,"_38":501,"_145":146,"_36":502,"_13":64,"_33":21,"_35":503,"_24":25,"_149":-5,"_279":504,"_27":505},{"_47":197,"_32":198,"_30":199,"_143":-5,"_39":40,"_38":200,"_145":146,"_36":496,"_13":64,"_33":34,"_35":-5,"_24":25,"_149":-5,"_279":497,"_27":498},{"_47":492,"_32":363,"_30":472,"_143":199,"_39":40,"_38":487,"_145":146,"_36":493,"_13":64,"_33":34,"_35":-5,"_24":25,"_149":-5,"_279":494,"_27":495},{"_47":485,"_32":372,"_30":486,"_143":472,"_39":40,"_38":487,"_145":146,"_36":488,"_13":64,"_33":21,"_35":489,"_24":25,"_149":-5,"_279":490,"_27":491},{"_47":478,"_32":44,"_30":479,"_143":472,"_39":40,"_38":480,"_145":146,"_36":481,"_13":64,"_33":21,"_35":482,"_24":25,"_149":-5,"_279":483,"_27":484},{"_47":470,"_32":355,"_30":471,"_143":472,"_39":40,"_38":473,"_145":146,"_36":474,"_13":64,"_33":21,"_35":475,"_24":25,"_149":-5,"_279":476,"_27":477},{"_47":466,"_32":465,"_30":459,"_143":199,"_39":40,"_38":460,"_145":146,"_36":467,"_13":64,"_33":34,"_35":-5,"_24":25,"_149":-5,"_279":468,"_27":469},{"_47":457,"_32":44,"_30":458,"_143":459,"_39":40,"_38":460,"_145":146,"_36":461,"_13":64,"_33":21,"_35":462,"_24":25,"_149":-5,"_279":463,"_27":464},{"_47":450,"_32":451,"_30":452,"_143":199,"_39":40,"_38":200,"_145":146,"_36":453,"_13":64,"_33":21,"_35":454,"_24":25,"_149":-5,"_279":455,"_27":456},{"_47":443,"_32":44,"_30":444,"_143":199,"_39":40,"_38":445,"_145":146,"_36":446,"_13":64,"_33":21,"_35":447,"_24":25,"_149":-5,"_279":448,"_27":449},{"_47":436,"_32":333,"_30":437,"_143":199,"_39":40,"_38":438,"_145":146,"_36":439,"_13":64,"_33":21,"_35":440,"_24":25,"_149":-5,"_279":441,"_27":442},{"_47":191,"_32":192,"_30":193,"_143":-5,"_39":40,"_38":194,"_145":146,"_36":433,"_13":64,"_33":34,"_35":-5,"_24":25,"_149":-5,"_279":434,"_27":435},{"_47":429,"_32":363,"_30":409,"_143":193,"_39":40,"_38":424,"_145":146,"_36":430,"_13":64,"_33":34,"_35":-5,"_24":25,"_149":-5,"_279":431,"_27":432},{"_47":422,"_32":372,"_30":423,"_143":409,"_39":40,"_38":424,"_145":146,"_36":425,"_13":64,"_33":21,"_35":426,"_24":25,"_149":-5,"_279":427,"_27":428},{"_47":415,"_32":44,"_30":416,"_143":409,"_39":40,"_38":417,"_145":146,"_36":418,"_13":64,"_33":21,"_35":419,"_24":25,"_149":-5,"_279":420,"_27":421},{"_47":407,"_32":355,"_30":408,"_143":409,"_39":40,"_38":410,"_145":146,"_36":411,"_13":64,"_33":21,"_35":412,"_24":25,"_149":-5,"_279":413,"_27":414},{"_47":400,"_32":44,"_30":401,"_143":193,"_39":40,"_38":402,"_145":146,"_36":403,"_13":64,"_33":21,"_35":404,"_24":25,"_149":-5,"_279":405,"_27":406},{"_47":393,"_32":394,"_30":395,"_143":193,"_39":40,"_38":194,"_145":146,"_36":396,"_13":64,"_33":21,"_35":397,"_24":25,"_149":-5,"_279":398,"_27":399},{"_47":386,"_32":333,"_30":387,"_143":193,"_39":40,"_38":388,"_145":146,"_36":389,"_13":64,"_33":21,"_35":390,"_24":25,"_149":-5,"_279":391,"_27":392},{"_47":185,"_32":186,"_30":187,"_143":-5,"_39":40,"_38":188,"_145":146,"_36":383,"_13":64,"_33":34,"_35":-5,"_24":25,"_149":-5,"_279":384,"_27":385},{"_47":379,"_32":363,"_30":357,"_143":187,"_39":40,"_38":374,"_145":146,"_36":380,"_13":64,"_33":34,"_35":-5,"_24":25,"_149":-5,"_279":381,"_27":382},{"_47":371,"_32":372,"_30":373,"_143":357,"_39":40,"_38":374,"_145":146,"_36":375,"_13":64,"_33":21,"_35":376,"_24":25,"_149":-5,"_279":377,"_27":378},{"_47":364,"_32":44,"_30":365,"_143":357,"_39":40,"_38":366,"_145":146,"_36":367,"_13":64,"_33":21,"_35":368,"_24":25,"_149":-5,"_279":369,"_27":370},{"_47":354,"_32":355,"_30":356,"_143":357,"_39":40,"_38":358,"_145":146,"_36":359,"_13":64,"_33":21,"_35":360,"_24":25,"_149":-5,"_279":361,"_27":362},{"_47":347,"_32":44,"_30":348,"_143":187,"_39":40,"_38":349,"_145":146,"_36":350,"_13":64,"_33":21,"_35":351,"_24":25,"_149":-5,"_279":352,"_27":353},{"_47":340,"_32":341,"_30":342,"_143":187,"_39":40,"_38":188,"_145":146,"_36":343,"_13":64,"_33":21,"_35":344,"_24":25,"_149":-5,"_279":345,"_27":346},{"_47":332,"_32":333,"_30":334,"_143":187,"_39":40,"_38":335,"_145":146,"_36":336,"_13":64,"_33":21,"_35":337,"_24":25,"_149":-5,"_279":338,"_27":339},{"_47":182,"_32":28,"_30":31,"_143":-5,"_39":40,"_38":14,"_145":146,"_36":329,"_13":64,"_33":34,"_35":-5,"_24":25,"_149":-5,"_279":330,"_27":331},{"_47":325,"_32":44,"_30":43,"_143":31,"_39":40,"_38":14,"_145":146,"_36":326,"_13":64,"_33":21,"_35":45,"_24":25,"_149":-5,"_279":327,"_27":328},{"_47":176,"_32":177,"_30":178,"_143":-5,"_39":40,"_38":179,"_145":146,"_36":322,"_13":64,"_33":34,"_35":-5,"_24":25,"_149":-5,"_279":323,"_27":324},{"_47":315,"_32":316,"_30":317,"_143":178,"_39":40,"_38":179,"_145":146,"_36":318,"_13":64,"_33":21,"_35":319,"_24":25,"_149":-5,"_279":320,"_27":321},{"_47":170,"_32":171,"_30":172,"_143":-5,"_39":40,"_38":173,"_145":146,"_36":312,"_13":64,"_33":34,"_35":-5,"_24":25,"_149":-5,"_279":313,"_27":314},{"_47":305,"_32":306,"_30":307,"_143":172,"_39":40,"_38":173,"_145":146,"_36":308,"_13":64,"_33":21,"_35":309,"_24":25,"_149":-5,"_279":310,"_27":311},{"_47":164,"_32":165,"_30":166,"_143":-5,"_39":40,"_38":167,"_145":146,"_36":302,"_13":64,"_33":34,"_35":-5,"_24":25,"_149":-5,"_279":303,"_27":304},{"_47":295,"_32":296,"_30":297,"_143":166,"_39":40,"_38":167,"_145":146,"_36":298,"_13":64,"_33":21,"_35":299,"_24":25,"_149":-5,"_279":300,"_27":301},{"_47":158,"_32":159,"_30":160,"_143":-5,"_39":40,"_38":161,"_145":146,"_36":292,"_13":64,"_33":34,"_35":-5,"_24":25,"_149":-5,"_279":293,"_27":294},{"_47":285,"_32":286,"_30":287,"_143":160,"_39":40,"_38":161,"_145":146,"_36":288,"_13":64,"_33":21,"_35":289,"_24":25,"_149":-5,"_279":290,"_27":291},{"_47":151,"_32":152,"_30":153,"_143":-5,"_39":40,"_38":154,"_145":146,"_36":282,"_13":64,"_33":21,"_35":156,"_24":25,"_149":-5,"_279":283,"_27":284},{"_47":140,"_32":141,"_30":142,"_143":-5,"_39":40,"_38":144,"_145":146,"_36":278,"_13":64,"_33":21,"_35":148,"_24":25,"_149":-5,"_279":280,"_27":281},["D",1779200506262],"children",[],[141],["D",1779200504083],[],[152],"1293748e-538e-11f1-961c-ee650bb23af1","users.table.ts","1293756a-538e-11f1-961c-ee650bb23af1",["D",1779200508719],"import { sqliteTable, integer, text } from \"../db.ts\";\n\nexport const users = sqliteTable(\"users\", {\n id: integer(\"id\").primaryKey({ autoIncrement: true }),\n \n email: text(\"email\").notNull(),\n \n password_hash: text(\"password_hash\").notNull(),\n \n name: text(\"name\"),\n \n role: text(\"role\").notNull(),\n \n created_at: text(\"created_at\"),\n updated_at: text(\"updated_at\"),\n \n});\n",[],[159,286],["D",1779200508719],[275],[159],"1238ed70-538e-11f1-961c-ee650bb23af1","toppings.table.ts","1238ee4c-538e-11f1-961c-ee650bb23af1",["D",1779200508127],"import { sqliteTable, integer, text } from \"../db.ts\";\n\nexport const toppings = sqliteTable(\"toppings\", {\n id: integer(\"id\").primaryKey({ autoIncrement: true }),\n \n name: text(\"name\").notNull(),\n \n price: integer(\"price\"),\n \n created_at: text(\"created_at\"),\n updated_at: text(\"updated_at\"),\n \n});\n",[],[165,296],["D",1779200508127],[273],[165],"11de7f66-538e-11f1-a631-ee650bb23af1","orders.table.ts","11de8006-538e-11f1-a631-ee650bb23af1",["D",1779200507533],"import { sqliteTable, integer, text } from \"../db.ts\";\n\nexport const orders = sqliteTable(\"orders\", {\n id: integer(\"id\").primaryKey({ autoIncrement: true }),\n \n customer_name: text(\"customer_name\"),\n \n table_type: text(\"table_type\").notNull(),\n \n status: text(\"status\").notNull(),\n \n payment_method: text(\"payment_method\"),\n \n total: integer(\"total\"),\n \n created_at: text(\"created_at\"),\n updated_at: text(\"updated_at\"),\n \n deleted_at: text(\"deleted_at\"),\n \n});\n",[],[171,306],["D",1779200507533],[271],[171],"117b92ca-538e-11f1-961c-ee650bb23af1","order_items.table.ts","117b9374-538e-11f1-961c-ee650bb23af1",["D",1779200506879],"import { sqliteTable, integer, text } from \"../db.ts\";\n\nexport const orderItems = sqliteTable(\"order_items\", {\n id: integer(\"id\").primaryKey({ autoIncrement: true }),\n \n order_id: integer(\"order_id\").notNull(),\n \n item_id: integer(\"item_id\").notNull(),\n \n quantity: integer(\"quantity\").notNull(),\n \n unit_price: integer(\"unit_price\"),\n \n subtotal: integer(\"subtotal\"),\n \n selected_toppings: text(\"selected_toppings\"),\n \n created_at: text(\"created_at\"),\n updated_at: text(\"updated_at\"),\n \n});\n",[],[177,316],["D",1779200506879],[269],[177],"1df1e7e8-538e-11f1-b9b6-ee650bb23af1",["D",1779200527795],[],[28,44],["D",1779200527795],[267],[28],"1d971a98-538e-11f1-8553-ee650bb23af1","post.ts","1d971b38-538e-11f1-8553-ee650bb23af1",34,["D",1779200527199],"import { db } from \"../db.ts\";\nimport { items } from \"./items.table.ts\";\n\n// body: any\n// returns: { id: number; success: true }\nexport default async function handler(c: any) {\n const body = await c.req.json();\n const now = new Date().toISOString();\n const inserted = await db.insert(items).values({ ...body, created_at: now, updated_at: now } as any).returning();\n return { id: (inserted[0] as any).id, success: true };\n}\n",[],[186,333],"10937102-538e-11f1-9e88-ee650bb23af1","items.table.ts","109371ca-538e-11f1-9e88-ee650bb23af1",["D",1779200505362],"import { sqliteTable, integer, text } from \"../db.ts\";\n\nexport const items = sqliteTable(\"items\", {\n id: integer(\"id\").primaryKey({ autoIncrement: true }),\n \n name: text(\"name\").notNull(),\n \n category_id: integer(\"category_id\").notNull(),\n \n price: integer(\"price\").notNull(),\n \n description: text(\"description\"),\n \n image: text(\"image\"),\n \n status: text(\"status\").notNull(),\n \n created_at: text(\"created_at\"),\n updated_at: text(\"updated_at\"),\n \n});\n",[],[186,341],"1d2adef0-538e-11f1-9b3d-ee650bb23af1","1d2adfae-538e-11f1-9b3d-ee650bb23af1",33,["D",1779200526484],"import { db, desc, asc, like, and, count, isNull } from \"../db.ts\";\nimport { items } from \"./items.table.ts\";\n\n// query: { current?: number; pageSize?: number; sort?: string; order?: \"ascend\"|\"descend\"; q?: string }\n// returns: { data: any[]; total: number; success: true }\nexport default async function handler(c: any) {\n const q = c.req.query();\n const page = Math.max(1, Number(q.current ?? q.page ?? 1));\n const pageSize = Math.min(100, Math.max(1, Number(q.pageSize ?? 20)));\n const offset = (page - 1) * pageSize;\n\n const filters: any[] = [];\n \n \n if (q.q) filters.push(like((items as any).name, `%${q.q}%`));\n \n\n const where = filters.length ? and(...filters) : undefined;\n\n const sortKey = (q.sort ?? \"id\") as string;\n const dir = q.order === \"ascend\" ? asc : desc;\n const sortCol = (items as any)[sortKey] ?? (items as any).id;\n\n const rows = await db.select().from(items).where(where).orderBy(dir(sortCol)).limit(pageSize).offset(offset);\n const [{ value: total }] = await db.select({ value: count() }).from(items).where(where);\n\n return { data: rows, total, success: true };\n}\n",[],[186,44],"1c9c3bb4-538e-11f1-bd07-ee650bb23af1","patch.ts","1c9c3c5e-538e-11f1-bd07-ee650bb23af1","07e348b5-f31a-42f7-95da-07706a805518",32,["D",1779200525555],"import { db, eq } from \"../../db.ts\";\nimport { items } from \"../items.table.ts\";\n\n// params: { id: number }\n// body: Partial\n// returns: { success: true }\nexport default async function handler(c: any) {\n const id = Number(c.req.param(\"id__int\") ?? c.req.param(\"id\"));\n const body = await c.req.json();\n const now = new Date().toISOString();\n await db.update(items).set({ ...body, updated_at: now } as any).where(eq((items as any).id, id));\n return { success: true };\n}\n",[],[186,363,355],"[id__int]","1bef5d68-538e-11f1-8b8d-ee650bb23af1","1bef5e1c-538e-11f1-8b8d-ee650bb23af1",31,["D",1779200524426],"import { db, eq } from \"../../db.ts\";\nimport { items } from \"../items.table.ts\";\n\n// params: { id: number }\n// returns: any\nexport default async function handler(c: any) {\n const id = Number(c.req.param(\"id__int\") ?? c.req.param(\"id\"));\n const [row] = await db.select().from(items).where(eq((items as any).id, id));\n if (!row) {\n c.status(404);\n return { error: \"not found\" };\n }\n return row;\n}\n",[],[186,363,44],"1b8171f4-538e-11f1-94d4-ee650bb23af1","delete.ts","1b8172bc-538e-11f1-94d4-ee650bb23af1",30,["D",1779200523703],"import { db, eq } from \"../../db.ts\";\nimport { items } from \"../items.table.ts\";\n\n// params: { id: number }\n// returns: { success: true }\nexport default async function handler(c: any) {\n const id = Number(c.req.param(\"id__int\") ?? c.req.param(\"id\"));\n const now = new Date().toISOString();\n await db.update(items).set({ deleted_at: now } as any).where(eq((items as any).id, id));\n return { success: true };\n}\n",[],[186,363,372],"1b817cc6-538e-11f1-94d4-ee650bb23af1",["D",1779200523703],[260,261,262],[186,363],["D",1779200505362],[259,263,264,265],[186],"1b14edc2-538e-11f1-ae22-ee650bb23af1","1b14ee80-538e-11f1-ae22-ee650bb23af1",29,["D",1779200522993],"import { db } from \"../db.ts\";\nimport { itemToppings } from \"./item_toppings.table.ts\";\n\n// body: any\n// returns: { id: number; success: true }\nexport default async function handler(c: any) {\n const body = await c.req.json();\n const now = new Date().toISOString();\n const inserted = await db.insert(itemToppings).values({ ...body, created_at: now, updated_at: now } as any).returning();\n return { id: (inserted[0] as any).id, success: true };\n}\n",[],[192,333],"103b6430-538e-11f1-ae69-ee650bb23af1","item_toppings.table.ts","103b6502-538e-11f1-ae69-ee650bb23af1",["D",1779200504788],"import { sqliteTable, integer, text } from \"../db.ts\";\n\nexport const itemToppings = sqliteTable(\"item_toppings\", {\n id: integer(\"id\").primaryKey({ autoIncrement: true }),\n \n item_id: integer(\"item_id\").notNull(),\n \n topping_id: integer(\"topping_id\").notNull(),\n \n created_at: text(\"created_at\"),\n updated_at: text(\"updated_at\"),\n \n});\n",[],[192,394],"1ab223ae-538e-11f1-a5f7-ee650bb23af1","1ab22462-538e-11f1-a5f7-ee650bb23af1",28,["D",1779200522343],"import { db, desc, asc, like, and, count, isNull } from \"../db.ts\";\nimport { itemToppings } from \"./item_toppings.table.ts\";\n\n// query: { current?: number; pageSize?: number; sort?: string; order?: \"ascend\"|\"descend\"; q?: string }\n// returns: { data: any[]; total: number; success: true }\nexport default async function handler(c: any) {\n const q = c.req.query();\n const page = Math.max(1, Number(q.current ?? q.page ?? 1));\n const pageSize = Math.min(100, Math.max(1, Number(q.pageSize ?? 20)));\n const offset = (page - 1) * pageSize;\n\n const filters: any[] = [];\n \n \n\n const where = filters.length ? and(...filters) : undefined;\n\n const sortKey = (q.sort ?? \"id\") as string;\n const dir = q.order === \"ascend\" ? asc : desc;\n const sortCol = (itemToppings as any)[sortKey] ?? (itemToppings as any).id;\n\n const rows = await db.select().from(itemToppings).where(where).orderBy(dir(sortCol)).limit(pageSize).offset(offset);\n const [{ value: total }] = await db.select({ value: count() }).from(itemToppings).where(where);\n\n return { data: rows, total, success: true };\n}\n",[],[192,44],"1a4c6a28-538e-11f1-8615-ee650bb23af1","1a4c6af0-538e-11f1-8615-ee650bb23af1","58b5504c-70cd-4ff7-9a24-4a9c58a42805",27,["D",1779200521675],"import { db, eq } from \"../../db.ts\";\nimport { itemToppings } from \"../item_toppings.table.ts\";\n\n// params: { id: number }\n// body: Partial\n// returns: { success: true }\nexport default async function handler(c: any) {\n const id = Number(c.req.param(\"id__int\") ?? c.req.param(\"id\"));\n const body = await c.req.json();\n const now = new Date().toISOString();\n await db.update(itemToppings).set({ ...body, updated_at: now } as any).where(eq((itemToppings as any).id, id));\n return { success: true };\n}\n",[],[192,363,355],"19dd9756-538e-11f1-94d4-ee650bb23af1","19dd980a-538e-11f1-94d4-ee650bb23af1",26,["D",1779200520954],"import { db, eq } from \"../../db.ts\";\nimport { itemToppings } from \"../item_toppings.table.ts\";\n\n// params: { id: number }\n// returns: any\nexport default async function handler(c: any) {\n const id = Number(c.req.param(\"id__int\") ?? c.req.param(\"id\"));\n const [row] = await db.select().from(itemToppings).where(eq((itemToppings as any).id, id));\n if (!row) {\n c.status(404);\n return { error: \"not found\" };\n }\n return row;\n}\n",[],[192,363,44],"195b2f00-538e-11f1-bec8-ee650bb23af1","195b2ff0-538e-11f1-bec8-ee650bb23af1",25,["D",1779200520094],"import { db, eq } from \"../../db.ts\";\nimport { itemToppings } from \"../item_toppings.table.ts\";\n\n// params: { id: number }\n// returns: { success: true }\nexport default async function handler(c: any) {\n const id = Number(c.req.param(\"id__int\") ?? c.req.param(\"id\"));\n const now = new Date().toISOString();\n await db.update(itemToppings).set({ deleted_at: now } as any).where(eq((itemToppings as any).id, id));\n return { success: true };\n}\n",[],[192,363,372],"195b393c-538e-11f1-bec8-ee650bb23af1",["D",1779200520094],[252,253,254],[192,363],["D",1779200504788],[251,255,256,257],[192],"189cdc62-538e-11f1-bec8-ee650bb23af1","189cdd48-538e-11f1-bec8-ee650bb23af1",23,["D",1779200518842],"import { db } from \"../db.ts\";\nimport { customers } from \"./customers.table.ts\";\n\n// body: any\n// returns: { id: number; success: true }\nexport default async function handler(c: any) {\n const body = await c.req.json();\n const now = new Date().toISOString();\n const inserted = await db.insert(customers).values({ ...body, created_at: now, updated_at: now } as any).returning();\n return { id: (inserted[0] as any).id, success: true };\n}\n",[],[198,333],"181ab0f2-538e-11f1-9713-ee650bb23af1","181ab1ba-538e-11f1-9713-ee650bb23af1",22,["D",1779200517999],"import { db, desc, asc, like, and, count, isNull } from \"../db.ts\";\nimport { customers } from \"./customers.table.ts\";\n\n// query: { current?: number; pageSize?: number; sort?: string; order?: \"ascend\"|\"descend\"; q?: string }\n// returns: { data: any[]; total: number; success: true }\nexport default async function handler(c: any) {\n const q = c.req.query();\n const page = Math.max(1, Number(q.current ?? q.page ?? 1));\n const pageSize = Math.min(100, Math.max(1, Number(q.pageSize ?? 20)));\n const offset = (page - 1) * pageSize;\n\n const filters: any[] = [];\n \n \n if (q.q) filters.push(like((customers as any).name, `%${q.q}%`));\n \n\n const where = filters.length ? and(...filters) : undefined;\n\n const sortKey = (q.sort ?? \"id\") as string;\n const dir = q.order === \"ascend\" ? asc : desc;\n const sortCol = (customers as any)[sortKey] ?? (customers as any).id;\n\n const rows = await db.select().from(customers).where(where).orderBy(dir(sortCol)).limit(pageSize).offset(offset);\n const [{ value: total }] = await db.select({ value: count() }).from(customers).where(where);\n\n return { data: rows, total, success: true };\n}\n",[],[198,44],"0f6f901c-538e-11f1-8d89-ee650bb23af1","customers.table.ts","0f6f90e4-538e-11f1-8d89-ee650bb23af1",["D",1779200503414],"import { sqliteTable, integer, text } from \"../db.ts\";\n\nexport const customers = sqliteTable(\"customers\", {\n id: integer(\"id\").primaryKey({ autoIncrement: true }),\n \n name: text(\"name\").notNull(),\n \n phone: text(\"phone\"),\n \n notes: text(\"notes\"),\n \n created_at: text(\"created_at\"),\n updated_at: text(\"updated_at\"),\n \n});\n",[],[198,451],"18fe4ae2-538e-11f1-bc1e-ee650bb23af1","18fe4c18-538e-11f1-bc1e-ee650bb23af1","91417747-a2fa-4e72-85f2-32398d913d8b",24,["D",1779200519482],"import { Context } from \"npm:hono@3\";\nimport { db, ilike, or } from \"../../db.ts\";\nimport { customers } from \"../customers.table.ts\";\nimport { ilike, and, or, db } from \"../../db.ts\";\n\nexport default async function handler(c: Context) {\n const q = c.req.query(\"q\")?.trim();\n const name = c.req.query(\"name\")?.trim();\n const phone = c.req.query(\"phone\")?.trim();\n\n let conditions;\n\n if (q) {\n conditions = or(\n ilike(customers.name, `%${q}%`),\n ilike(customers.phone ? ilike(customers.phone, `%${q}%`) : undefined\n );\n } else if (name && phone) {\n conditions = and(\n ilike(customers.name, `%${name}%`),\n ilike(customers.phone, `%${phone}%`)\n );\n } else if (name) {\n conditions = ilike(customers.name, `%${name}%`);\n } else if (phone) {\n conditions = ilike(customers.phone, `%${phone}%`);\n } else {\n return { data: [] };\n }\n\n const rows = await db\n .select({\n id: customers.id,\n name:customers.name,\n phone: customers.phone,\n notes: customers.notes,\n created_at: customers.created_at,\n })\n .from(customers)\n .where(conditions)\n .limit(10);\n\n return { data: rows };\n}",[],[198,465,44],"search","18fe95d8-538e-11f1-bc1e-ee650bb23af1",["D",1779200519482],[246],[198,465],"179c584c-538e-11f1-b9b6-ee650bb23af1","179c58f6-538e-11f1-b9b6-ee650bb23af1","85f9738d-c34f-45ea-8aaf-5636fadc4131",21,["D",1779200517171],"import { db, eq } from \"../../db.ts\";\nimport { customers } from \"../customers.table.ts\";\n\n// params: { id: number }\n// body: Partial\n// returns: { success: true }\nexport default async function handler(c: any) {\n const id = Number(c.req.param(\"id__int\") ?? c.req.param(\"id\"));\n const body = await c.req.json();\n const now = new Date().toISOString();\n await db.update(customers).set({ ...body, updated_at: now } as any).where(eq((customers as any).id, id));\n return { success: true };\n}\n",[],[198,363,355],"172f7632-538e-11f1-9713-ee650bb23af1","172f76d2-538e-11f1-9713-ee650bb23af1",20,["D",1779200516456],"import { db, eq } from \"../../db.ts\";\nimport { customers } from \"../customers.table.ts\";\n\n// params: { id: number }\n// returns: any\nexport default async function handler(c: any) {\n const id = Number(c.req.param(\"id__int\") ?? c.req.param(\"id\"));\n const [row] = await db.select().from(customers).where(eq((customers as any).id, id));\n if (!row) {\n c.status(404);\n return { error: \"not found\" };\n }\n return row;\n}\n",[],[198,363,44],"16c2a30e-538e-11f1-925e-ee650bb23af1","16c2a3ea-538e-11f1-925e-ee650bb23af1",19,["D",1779200515720],"import { db, eq } from \"../../db.ts\";\nimport { customers } from \"../customers.table.ts\";\n\n// params: { id: number }\n// returns: { success: true }\nexport default async function handler(c: any) {\n const id = Number(c.req.param(\"id__int\") ?? c.req.param(\"id\"));\n const now = new Date().toISOString();\n await db.update(customers).set({ deleted_at: now } as any).where(eq((customers as any).id, id));\n return { success: true };\n}\n",[],[198,363,372],"16c2cbea-538e-11f1-925e-ee650bb23af1",["D",1779200515720],[242,243,244],[198,363],["D",1779200503414],[241,245,247,248,249],[198],"164a5d90-538e-11f1-8d7c-ee650bb23af1","164a5e30-538e-11f1-8d7c-ee650bb23af1",18,["D",1779200514954],"import { db } from \"../db.ts\";\nimport { categories } from \"./categories.table.ts\";\n\n// body: any\n// returns: { id: number; success: true }\nexport default async function handler(c: any) {\n const body = await c.req.json();\n const now = new Date().toISOString();\n const inserted = await db.insert(categories).values({ ...body, created_at: now, updated_at: now } as any).returning();\n return { id: (inserted[0] as any).id, success: true };\n}\n",[],[204,333],"15d4ada2-538e-11f1-ae5b-ee650bb23af1","15d4ae60-538e-11f1-ae5b-ee650bb23af1",17,["D",1779200514184],"import { db, desc, asc, like, and, count, isNull } from \"../db.ts\";\nimport { categories } from \"./categories.table.ts\";\n\n// query: { current?: number; pageSize?: number; sort?: string; order?: \"ascend\"|\"descend\"; q?: string }\n// returns: { data: any[]; total: number; success: true }\nexport default async function handler(c: any) {\n const q = c.req.query();\n const page = Math.max(1, Number(q.current ?? q.page ?? 1));\n const pageSize = Math.min(100, Math.max(1, Number(q.pageSize ?? 20)));\n const offset = (page - 1) * pageSize;\n\n const filters: any[] = [];\n \n \n if (q.q) filters.push(like((categories as any).name, `%${q.q}%`));\n \n\n const where = filters.length ? and(...filters) : undefined;\n\n const sortKey = (q.sort ?? \"id\") as string;\n const dir = q.order === \"ascend\" ? asc : desc;\n const sortCol = (categories as any)[sortKey] ?? (categories as any).id;\n\n const rows = await db.select().from(categories).where(where).orderBy(dir(sortCol)).limit(pageSize).offset(offset);\n const [{ value: total }] = await db.select({ value: count() }).from(categories).where(where);\n\n return { data: rows, total, success: true };\n}\n",[],[204,44],"0ec40d64-538e-11f1-ae69-ee650bb23af1","categories.table.ts","0ec40e68-538e-11f1-ae69-ee650bb23af1",["D",1779200502324],"import { sqliteTable, integer, text } from \"../db.ts\";\n\nexport const categories = sqliteTable(\"categories\", {\n id: integer(\"id\").primaryKey({ autoIncrement: true }),\n \n name: text(\"name\").notNull(),\n \n sort_order: integer(\"sort_order\"),\n \n created_at: text(\"created_at\"),\n updated_at: text(\"updated_at\"),\n \n});\n",[],[204,514],"1576de7a-538e-11f1-b9b6-ee650bb23af1","1576df60-538e-11f1-b9b6-ee650bb23af1","9c313511-1b61-4ab7-85f6-e8c93e657c16",16,["D",1779200513569],"import { db, eq } from \"../../db.ts\";\nimport { categories } from \"../categories.table.ts\";\n\n// params: { id: number }\n// body: Partial\n// returns: { success: true }\nexport default async function handler(c: any) {\n const id = Number(c.req.param(\"id__int\") ?? c.req.param(\"id\"));\n const body = await c.req.json();\n const now = new Date().toISOString();\n await db.update(categories).set({ ...body, updated_at: now } as any).where(eq((categories as any).id, id));\n return { success: true };\n}\n",[],[204,363,355],"14eb6f52-538e-11f1-9b3d-ee650bb23af1","14eb7006-538e-11f1-9b3d-ee650bb23af1",15,["D",1779200512654],"import { db, eq } from \"../../db.ts\";\nimport { categories } from \"../categories.table.ts\";\n\n// params: { id: number }\n// returns: any\nexport default async function handler(c: any) {\n const id = Number(c.req.param(\"id__int\") ?? c.req.param(\"id\"));\n const [row] = await db.select().from(categories).where(eq((categories as any).id, id));\n if (!row) {\n c.status(404);\n return { error: \"not found\" };\n }\n return row;\n}\n",[],[204,363,44],"148f4a88-538e-11f1-9270-ee650bb23af1","148f4b5a-538e-11f1-9270-ee650bb23af1",14,["D",1779200512045],"import { db, eq } from \"../../db.ts\";\nimport { categories } from \"../categories.table.ts\";\n\n// params: { id: number }\n// returns: { success: true }\nexport default async function handler(c: any) {\n const id = Number(c.req.param(\"id__int\") ?? c.req.param(\"id\"));\n const now = new Date().toISOString();\n await db.update(categories).set({ deleted_at: now } as any).where(eq((categories as any).id, id));\n return { success: true };\n}\n",[],[204,363,372],"148f77e2-538e-11f1-9270-ee650bb23af1",["D",1779200512045],[234,235,236],[204,363],["D",1779200502324],[233,237,238,239],[204],"13b24156-538e-11f1-94d4-ee650bb23af1","13b2421e-538e-11f1-94d4-ee650bb23af1","10b06273-fc42-4a1d-8c0f-e1bde1640832",13,["D",1779200510600],"import { db, eq } from \"../../db.ts\";\nimport { users } from \"../../users/users.table.ts\";\nimport bcryptDefault from \"npm:bcryptjs@2.4.3\";\nconst bcrypt: { hash: (s: string, n: number) => Promise; compare: (s: string, h: string) => Promise } = (bcryptDefault as any).default ?? bcryptDefault;\nimport { sign } from \"npm:hono@3/jwt\";\n\nconst JWT_SECRET = (globalThis as any).Deno?.env?.get?.(\"JWT_SECRET\") ?? \"dev-secret-change-me\";\n\n// body: { email: string; password: string; name?: string }\n// returns: { token: string; user: { id: number; email: string } }\nexport default async function handler(c: any) {\n const body = await c.req.json() as { email: string; password: string; name?: string };\n if (!body.email || !body.password || body.password.length < 6) {\n c.status(400);\n return { error: \"invalid input\" };\n }\n const [exists] = await db.select().from(users).where(eq((users as any).email, body.email));\n if (exists) {\n c.status(409);\n return { error: \"email taken\" };\n }\n\n const hash = await bcrypt.hash(body.password, 10);\n const now = new Date().toISOString();\n const inserted = await db.insert(users).values({\n email: body.email,\n password_hash: hash,\n name: body.name ?? body.email.split(\"@\")[0],\n created_at: now,\n updated_at: now,\n } as any).returning();\n const user = inserted[0] as any;\n\n const token = await sign(\n { sub: user.id, email: user.email, exp: Math.floor(Date.now() / 1000) + 60 * 60 * 24 * 7 },\n JWT_SECRET,\n );\n\n return { token, user: { id: user.id, email: user.email } };\n}\n",[],[210,557,333],"register","13b254ac-538e-11f1-94d4-ee650bb23af1",["D",1779200510600],[231],[210,557],"1346cbec-538e-11f1-94d4-ee650bb23af1","1346ccaa-538e-11f1-94d4-ee650bb23af1","bb54daca-bb9c-476d-804a-d5e4712f5e50",12,["D",1779200509889],"import { db, eq } from \"../../db.ts\";\nimport { users } from \"../../users/users.table.ts\";\nimport { verify } from \"npm:hono@3/jwt\";\n\nconst JWT_SECRET = (globalThis as any).Deno?.env?.get?.(\"JWT_SECRET\") ?? \"dev-secret-change-me\";\n\n// header: Authorization: Bearer \n// returns: { id: number; email: string }\nexport default async function handler(c: any) {\n const auth = c.req.header(\"authorization\") ?? \"\";\n const token = auth.replace(/^Bearer\\s+/i, \"\");\n if (!token) { c.status(401); return { error: \"missing token\" }; }\n\n try {\n const payload = await verify(token, JWT_SECRET) as { sub: number };\n const [user] = await db.select().from(users).where(eq((users as any).id, payload.sub));\n if (!user) { c.status(404); return { error: \"user not found\" }; }\n return { id: (user as any).id, email: (user as any).email };\n } catch {\n c.status(401);\n return { error: \"invalid token\" };\n }\n}\n",[],[210,570,44],"me","1346effa-538e-11f1-94d4-ee650bb23af1",["D",1779200509889],[229],[210,570],"12ea3684-538e-11f1-9240-ee650bb23af1","12ea376a-538e-11f1-9240-ee650bb23af1","beb37a34-1d9c-47f0-9142-2ae30d742d75",["D",1779200509288],"import { db, eq } from \"../../db.ts\";\nimport { users } from \"../../users/users.table.ts\";\nimport bcryptDefault from \"npm:bcryptjs@2.4.3\";\nconst bcrypt: { hash: (s: string, n: number) => Promise; compare: (s: string, h: string) => Promise } = (bcryptDefault as any).default ?? bcryptDefault;\nimport { sign } from \"npm:hono@3/jwt\";\n\nconst JWT_SECRET = (globalThis as any).Deno?.env?.get?.(\"JWT_SECRET\") ?? \"dev-secret-change-me\";\n\n// body: { email: string; password: string }\n// returns: { token: string; user: { id: number; email: string } }\nexport default async function handler(c: any) {\n const body = await c.req.json() as { email: string; password: string };\n const [user] = await db.select().from(users).where(eq((users as any).email, body.email));\n if (!user) {\n c.status(401);\n return { error: \"invalid credentials\" };\n }\n const ok = await bcrypt.compare(body.password, (user as any).password_hash);\n if (!ok) {\n c.status(401);\n return { error: \"invalid credentials\" };\n }\n\n const token = await sign(\n { sub: (user as any).id, email: (user as any).email, exp: Math.floor(Date.now() / 1000) + 60 * 60 * 24 * 7 },\n JWT_SECRET,\n );\n\n return { token, user: { id: (user as any).id, email: (user as any).email } };\n}\n",[],[210,582,333],"login","12ea6c6c-538e-11f1-9240-ee650bb23af1",["D",1779200509288],[227],[210,582],["D",1779200509288],[226,228,230],[210],["D",1779200494411],{"_98":97,"_105":101},{"_98":97,"_99":-5,"_100":101,"_18":58,"_102":103,"_104":25},{"_13":87,"_32":88,"_47":40,"_89":48,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":49,"_96":97},"ctx",{"_80":-5,"_125":627,"_628":629,"_630":631,"_632":25,"_633":25,"_634":25,"_635":146,"_636":-5,"_637":-7,"_638":-7,"_639":64,"_640":25,"_641":25,"_642":-5,"_643":25,"_644":25,"_645":25,"_646":-5},"ENV",{"_598":599,"_600":601,"_602":88,"_603":604,"_605":606,"_607":608,"_609":610,"_611":612,"_613":614,"_615":616,"_617":618,"_619":620,"_621":622,"_623":624,"_625":626},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","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 · v35