[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_458":459,"_460":461},"routes/_app.x.$handle.$name",{"_92":91,"_31":43,"_100":82,"_26":101,"_13":14,"_102":-5,"_11":103,"_104":105,"_106":107,"_108":109,"_110":111,"_20":-5,"_112":-5,"_113":-5,"_114":24,"_115":116,"_117":24,"_118":-5,"_119":-5,"_120":121},"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":-5,"_51":-5,"_18":52,"_53":-5,"_54":24,"_55":-5,"_56":-5,"_57":58,"_59":60,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":66,"_67":66,"_68":69,"_70":69,"_71":69,"_72":66,"_73":66,"_74":75,"_76":77,"_78":79,"_80":24},"version",22,"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","customers/get.ts","latestPath","fileId","181ab1ba-538e-11f1-9713-ee650bb23af1","name","get.ts","fileType","content","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","createdAt",["D",1779200517999],"branchVersion","branchId","0a0b415c-538e-11f1-869b-ee650bb23af1","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",{"_92":91,"_99":95},"org",{"_92":91,"_93":-5,"_94":95,"_18":52,"_96":97,"_98":24},"branch",{"_13":81,"_31":82,"_41":40,"_83":42,"_84":-5,"_85":-5,"_86":-5,"_87":-5,"_88":-5,"_89":43,"_90":91},"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",{"_41":42,"_31":43,"_36":454,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":-5,"_51":-5,"_18":52,"_53":-5,"_54":24,"_55":-5,"_56":-5,"_57":58,"_59":60,"_61":-5,"_62":-5,"_63":-5,"_64":-5,"_65":66,"_67":66,"_68":69,"_70":69,"_71":69,"_72":66,"_73":66,"_74":455,"_76":456,"_78":457,"_80":24},"tree",[216,223,231,238,240,242,244,246,248,250,251],"files",[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,244,245,246,247,248,249,250,251],"counts",{"_206":58,"_207":197,"_208":58,"_209":210,"_211":212},"contents",[122,123,124,125,126,127,128,129,130,131,132],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_41":200,"_31":201,"_29":202,"_136":-5,"_39":40,"_38":203,"_138":139,"_36":204,"_13":58,"_33":156,"_34":-5,"_23":24,"_142":-5,"_26":205},{"_41":194,"_31":195,"_29":196,"_136":-5,"_39":40,"_38":197,"_138":139,"_36":198,"_13":58,"_33":156,"_34":-5,"_23":24,"_142":-5,"_26":199},{"_41":188,"_31":189,"_29":190,"_136":-5,"_39":40,"_38":191,"_138":139,"_36":192,"_13":58,"_33":156,"_34":-5,"_23":24,"_142":-5,"_26":193},{"_41":182,"_31":183,"_29":184,"_136":-5,"_39":40,"_38":185,"_138":139,"_36":186,"_13":58,"_33":156,"_34":-5,"_23":24,"_142":-5,"_26":187},{"_41":176,"_31":177,"_29":178,"_136":-5,"_39":40,"_38":179,"_138":139,"_36":180,"_13":58,"_33":156,"_34":-5,"_23":24,"_142":-5,"_26":181},{"_41":170,"_31":171,"_29":172,"_136":-5,"_39":40,"_38":173,"_138":139,"_36":174,"_13":58,"_33":156,"_34":-5,"_23":24,"_142":-5,"_26":175},{"_41":164,"_31":165,"_29":166,"_136":-5,"_39":40,"_38":167,"_138":139,"_36":168,"_13":58,"_33":156,"_34":-5,"_23":24,"_142":-5,"_26":169},{"_41":158,"_31":159,"_29":160,"_136":-5,"_39":40,"_38":161,"_138":139,"_36":162,"_13":58,"_33":156,"_34":-5,"_23":24,"_142":-5,"_26":163},{"_41":151,"_31":152,"_29":153,"_136":-5,"_39":40,"_38":154,"_138":139,"_36":155,"_13":58,"_33":156,"_34":-5,"_23":24,"_142":-5,"_26":157},{"_41":144,"_31":145,"_29":146,"_136":-5,"_39":40,"_38":147,"_138":139,"_36":148,"_13":58,"_33":20,"_34":149,"_23":24,"_142":-5,"_26":150},{"_41":133,"_31":134,"_29":135,"_136":-5,"_39":40,"_38":137,"_138":139,"_36":140,"_13":58,"_33":20,"_34":141,"_23":24,"_142":-5,"_26":143},"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",[134],"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",[145],"12938118-538e-11f1-961c-ee650bb23af1","users","63ba00c1-b0bd-4da6-8a19-f24b493ed350",10,["D",1779200508719],"directory",[152],"1238fae0-538e-11f1-961c-ee650bb23af1","toppings","f0390e62-9bf0-4d55-a0aa-d2f06ebb1f60",9,["D",1779200508127],[159],"11dea2fc-538e-11f1-a631-ee650bb23af1","orders","e0014934-2105-4b85-8ae1-08943dd7eeac",8,["D",1779200507533],[165],"117bc1c8-538e-11f1-961c-ee650bb23af1","order_items","fb7f3804-3a85-477d-9b4c-1781458cffb1",7,["D",1779200506879],[171],"10938296-538e-11f1-9e88-ee650bb23af1","items","1bb073c9-c1d6-4b02-a95d-9625e8dd06ad",5,["D",1779200505362],[177],"103b6e4e-538e-11f1-ae69-ee650bb23af1","item_toppings","c37d6086-e8db-4152-a564-d5729ab5da3e",4,["D",1779200504788],[183],"0f6fb128-538e-11f1-8d89-ee650bb23af1","customers","f47ebe5e-c25f-4902-891b-dd6ffcd0e6e5",2,["D",1779200503414],[189],"0ec43b2c-538e-11f1-ae69-ee650bb23af1","categories","06e0bf5b-302d-4dbd-9e7c-29de34f276e2",1,["D",1779200502324],[195],"12ea5d26-538e-11f1-9240-ee650bb23af1","auth","78641fc9-2541-4b88-b8f0-012b1a61d4f7",11,["D",1779200509288],[201],"pulls","branches","forks","envVars",{"_213":58,"_215":58},"connections",{"_213":58,"_214":58},"count","unfilledCount","emptyCount",{"_41":200,"_31":201,"_29":202,"_136":-5,"_39":40,"_38":203,"_138":139,"_36":451,"_13":58,"_33":156,"_34":-5,"_23":24,"_142":-5,"_253":452,"_26":453},{"_41":447,"_31":446,"_29":441,"_136":202,"_39":40,"_38":203,"_138":139,"_36":448,"_13":58,"_33":156,"_34":-5,"_23":24,"_142":-5,"_253":449,"_26":450},{"_41":439,"_31":363,"_29":440,"_136":441,"_39":40,"_38":203,"_138":139,"_36":442,"_13":58,"_33":20,"_34":443,"_23":24,"_142":-5,"_253":444,"_26":445},{"_41":435,"_31":434,"_29":428,"_136":202,"_39":40,"_38":429,"_138":139,"_36":436,"_13":58,"_33":156,"_34":-5,"_23":24,"_142":-5,"_253":437,"_26":438},{"_41":426,"_31":32,"_29":427,"_136":428,"_39":40,"_38":429,"_138":139,"_36":430,"_13":58,"_33":20,"_34":431,"_23":24,"_142":-5,"_253":432,"_26":433},{"_41":422,"_31":421,"_29":415,"_136":202,"_39":40,"_38":416,"_138":139,"_36":423,"_13":58,"_33":156,"_34":-5,"_23":24,"_142":-5,"_253":424,"_26":425},{"_41":413,"_31":363,"_29":414,"_136":415,"_39":40,"_38":416,"_138":139,"_36":417,"_13":58,"_33":20,"_34":418,"_23":24,"_142":-5,"_253":419,"_26":420},{"_41":194,"_31":195,"_29":196,"_136":-5,"_39":40,"_38":197,"_138":139,"_36":410,"_13":58,"_33":156,"_34":-5,"_23":24,"_142":-5,"_253":411,"_26":412},{"_41":406,"_31":339,"_29":386,"_136":196,"_39":40,"_38":401,"_138":139,"_36":407,"_13":58,"_33":156,"_34":-5,"_23":24,"_142":-5,"_253":408,"_26":409},{"_41":399,"_31":348,"_29":400,"_136":386,"_39":40,"_38":401,"_138":139,"_36":402,"_13":58,"_33":20,"_34":403,"_23":24,"_142":-5,"_253":404,"_26":405},{"_41":392,"_31":32,"_29":393,"_136":386,"_39":40,"_38":394,"_138":139,"_36":395,"_13":58,"_33":20,"_34":396,"_23":24,"_142":-5,"_253":397,"_26":398},{"_41":384,"_31":331,"_29":385,"_136":386,"_39":40,"_38":387,"_138":139,"_36":388,"_13":58,"_33":20,"_34":389,"_23":24,"_142":-5,"_253":390,"_26":391},{"_41":377,"_31":378,"_29":379,"_136":196,"_39":40,"_38":197,"_138":139,"_36":380,"_13":58,"_33":20,"_34":381,"_23":24,"_142":-5,"_253":382,"_26":383},{"_41":370,"_31":32,"_29":371,"_136":196,"_39":40,"_38":372,"_138":139,"_36":373,"_13":58,"_33":20,"_34":374,"_23":24,"_142":-5,"_253":375,"_26":376},{"_41":362,"_31":363,"_29":364,"_136":196,"_39":40,"_38":365,"_138":139,"_36":366,"_13":58,"_33":20,"_34":367,"_23":24,"_142":-5,"_253":368,"_26":369},{"_41":188,"_31":189,"_29":190,"_136":-5,"_39":40,"_38":191,"_138":139,"_36":359,"_13":58,"_33":156,"_34":-5,"_23":24,"_142":-5,"_253":360,"_26":361},{"_41":355,"_31":339,"_29":333,"_136":190,"_39":40,"_38":350,"_138":139,"_36":356,"_13":58,"_33":156,"_34":-5,"_23":24,"_142":-5,"_253":357,"_26":358},{"_41":347,"_31":348,"_29":349,"_136":333,"_39":40,"_38":350,"_138":139,"_36":351,"_13":58,"_33":20,"_34":352,"_23":24,"_142":-5,"_253":353,"_26":354},{"_41":340,"_31":32,"_29":341,"_136":333,"_39":40,"_38":342,"_138":139,"_36":343,"_13":58,"_33":20,"_34":344,"_23":24,"_142":-5,"_253":345,"_26":346},{"_41":330,"_31":331,"_29":332,"_136":333,"_39":40,"_38":334,"_138":139,"_36":335,"_13":58,"_33":20,"_34":336,"_23":24,"_142":-5,"_253":337,"_26":338},{"_41":323,"_31":324,"_29":325,"_136":190,"_39":40,"_38":191,"_138":139,"_36":326,"_13":58,"_33":20,"_34":327,"_23":24,"_142":-5,"_253":328,"_26":329},{"_41":319,"_31":32,"_29":30,"_136":190,"_39":40,"_38":14,"_138":139,"_36":320,"_13":58,"_33":20,"_34":35,"_23":24,"_142":-5,"_253":321,"_26":322},{"_41":182,"_31":183,"_29":184,"_136":-5,"_39":40,"_38":185,"_138":139,"_36":316,"_13":58,"_33":156,"_34":-5,"_23":24,"_142":-5,"_253":317,"_26":318},{"_41":309,"_31":310,"_29":311,"_136":184,"_39":40,"_38":185,"_138":139,"_36":312,"_13":58,"_33":20,"_34":313,"_23":24,"_142":-5,"_253":314,"_26":315},{"_41":176,"_31":177,"_29":178,"_136":-5,"_39":40,"_38":179,"_138":139,"_36":306,"_13":58,"_33":156,"_34":-5,"_23":24,"_142":-5,"_253":307,"_26":308},{"_41":299,"_31":300,"_29":301,"_136":178,"_39":40,"_38":179,"_138":139,"_36":302,"_13":58,"_33":20,"_34":303,"_23":24,"_142":-5,"_253":304,"_26":305},{"_41":170,"_31":171,"_29":172,"_136":-5,"_39":40,"_38":173,"_138":139,"_36":296,"_13":58,"_33":156,"_34":-5,"_23":24,"_142":-5,"_253":297,"_26":298},{"_41":289,"_31":290,"_29":291,"_136":172,"_39":40,"_38":173,"_138":139,"_36":292,"_13":58,"_33":20,"_34":293,"_23":24,"_142":-5,"_253":294,"_26":295},{"_41":164,"_31":165,"_29":166,"_136":-5,"_39":40,"_38":167,"_138":139,"_36":286,"_13":58,"_33":156,"_34":-5,"_23":24,"_142":-5,"_253":287,"_26":288},{"_41":279,"_31":280,"_29":281,"_136":166,"_39":40,"_38":167,"_138":139,"_36":282,"_13":58,"_33":20,"_34":283,"_23":24,"_142":-5,"_253":284,"_26":285},{"_41":158,"_31":159,"_29":160,"_136":-5,"_39":40,"_38":161,"_138":139,"_36":276,"_13":58,"_33":156,"_34":-5,"_23":24,"_142":-5,"_253":277,"_26":278},{"_41":269,"_31":270,"_29":271,"_136":160,"_39":40,"_38":161,"_138":139,"_36":272,"_13":58,"_33":20,"_34":273,"_23":24,"_142":-5,"_253":274,"_26":275},{"_41":151,"_31":152,"_29":153,"_136":-5,"_39":40,"_38":154,"_138":139,"_36":266,"_13":58,"_33":156,"_34":-5,"_23":24,"_142":-5,"_253":267,"_26":268},{"_41":259,"_31":260,"_29":261,"_136":153,"_39":40,"_38":154,"_138":139,"_36":262,"_13":58,"_33":20,"_34":263,"_23":24,"_142":-5,"_253":264,"_26":265},{"_41":144,"_31":145,"_29":146,"_136":-5,"_39":40,"_38":147,"_138":139,"_36":256,"_13":58,"_33":20,"_34":149,"_23":24,"_142":-5,"_253":257,"_26":258},{"_41":133,"_31":134,"_29":135,"_136":-5,"_39":40,"_38":137,"_138":139,"_36":252,"_13":58,"_33":20,"_34":141,"_23":24,"_142":-5,"_253":254,"_26":255},["D",1779200506262],"children",[],[134],["D",1779200504083],[],[145],"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",[],[152,260],["D",1779200508719],[249],[152],"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",[],[159,270],["D",1779200508127],[247],[159],"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",[],[165,280],["D",1779200507533],[245],[165],"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",[],[171,290],["D",1779200506879],[243],[171],"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",[],[177,300],["D",1779200505362],[241],[177],"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",[],[183,310],["D",1779200504788],[239],[183],"181ab0f2-538e-11f1-9713-ee650bb23af1",["D",1779200517999],[],[189,32],"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",[],[189,324],"179c584c-538e-11f1-b9b6-ee650bb23af1","patch.ts","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",[],[189,339,331],"[id__int]","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",[],[189,339,32],"16c2a30e-538e-11f1-925e-ee650bb23af1","delete.ts","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",[],[189,339,348],"16c2cbea-538e-11f1-925e-ee650bb23af1",["D",1779200515720],[233,234,235],[189,339],["D",1779200503414],[232,236,237],[189],"164a5d90-538e-11f1-8d7c-ee650bb23af1","post.ts","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",[],[195,363],"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",[],[195,32],"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",[],[195,378],"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",[],[195,339,331],"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",[],[195,339,32],"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",[],[195,339,348],"148f77e2-538e-11f1-9270-ee650bb23af1",["D",1779200512045],[225,226,227],[195,339],["D",1779200502324],[224,228,229,230],[195],"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",[],[201,421,363],"register","13b254ac-538e-11f1-94d4-ee650bb23af1",["D",1779200510600],[222],[201,421],"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",[],[201,434,32],"me","1346effa-538e-11f1-94d4-ee650bb23af1",["D",1779200509889],[220],[201,434],"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",[],[201,446,363],"login","12ea6c6c-538e-11f1-9240-ee650bb23af1",["D",1779200509288],[218],[201,446],["D",1779200509288],[217,219,221],[201],["D",1779200494411],{"_92":91,"_99":95},{"_92":91,"_93":-5,"_94":95,"_18":52,"_96":97,"_98":24},{"_13":81,"_31":82,"_41":40,"_83":42,"_84":-5,"_85":-5,"_86":-5,"_87":-5,"_88":-5,"_89":43,"_90":91},"ctx",{"_74":-5,"_119":491,"_492":493,"_494":495,"_496":24,"_497":24,"_498":24,"_499":139,"_500":-5,"_501":-7,"_502":-7,"_503":58,"_504":24,"_505":24,"_506":-5,"_507":24,"_508":24,"_509":24,"_510":-5},"ENV",{"_462":463,"_464":465,"_466":82,"_467":468,"_469":470,"_471":472,"_473":474,"_475":476,"_477":478,"_479":480,"_481":482,"_483":484,"_485":486,"_487":488,"_489":490},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","fdb67791413f4386b4dbf18f354029a617f6160f","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 · v22