[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_231":232,"_233":234},"routes/_app.x.$handle.$name",{"_95":94,"_32":44,"_103":85,"_27":104,"_13":14,"_105":-5,"_11":106,"_107":108,"_109":110,"_111":112,"_113":114,"_20":-5,"_115":-5,"_116":-5,"_117":25,"_118":119,"_120":121,"_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",{"_42":43,"_32":44,"_37":45,"_46":-5,"_47":25,"_48":49,"_50":49,"_51":-5,"_52":-5,"_18":53,"_54":55,"_56":25,"_57":-5,"_58":59,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":78,"_79":80,"_81":82,"_83":25},"version",169,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","deleteCreation","latestPath","fileId","c25c65d6-2993-11f0-92a8-569c3dd06744","name","fileType","script","content","import { blob } from \"https://esm.town/v/std/blob\";\n\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { TABLE_NAME } from \"./updateTable\";\n\nexport default async function(req: Request): Promise {\n // body contains:\n // - id (number)\n // - password (string), to be checked against PONDIVERSE_STORE_ADMIN_PASSWORD env variable\n\n let body;\n try {\n body = await req.json();\n } catch (e) {\n return Response.json({ ok: false, error: \"Invalid JSON\" });\n }\n\n const id = body.id;\n const password = body.password;\n\n if (!password) {\n return Response.json({ ok: false, error: \"No password provided\" });\n }\n\n if (isNaN(id)) {\n return Response.json({ ok: false, error: \"Invalid ID\" });\n }\n\n // Now it's time to check the password\n\n if (password !== Deno.env.get(\"PONDIVERSE_STORE_ADMIN_PASSWORD\")) {\n return Response.json({ ok: false, error: \"Invalid password\" });\n }\n\n // Now it's time to delete the creation\n await sqlite.execute(\n `DELETE FROM ${TABLE_NAME} WHERE id = ?;`,\n [id],\n );\n\n // Also delete the blob!\n blob.delete(\"pondiverse_image\" + id);\n\n // await blob.set(\"pondiverse_image\" + id.lastInsertRowid, image);\n return Response.json({ ok: true });\n}","createdAt",["D",1746437952827],"branchVersion","branchId","6c09648a-00c7-11f0-973c-569c3dd06744","id","6c0914a8-00c7-11f0-973c-569c3dd06744","pondiverse",["D",1741951695949],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","e3d47057-1e07-44ef-bc45-882ea85d881f","pinnedFileId","33148208-2459-11f0-bc54-569c3dd06744","pinPreview","pinMigrated","screenshotVersion",157,"likeCount",4,"orgId","cfe0c703-f763-4d56-b1c2-c1dbd5a52bee","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_95":94,"_102":98},"org",{"_95":94,"_96":-5,"_97":98,"_18":53,"_99":100,"_101":25},"branch",{"_13":84,"_32":85,"_42":41,"_86":43,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":44,"_93":94},"isOwned",194,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","todepond","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJab0hiUXRpdGZBSzFmWm1UWTdaRjZYV251cSJ9","tier","pro","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_42":43,"_32":44,"_37":227,"_46":-5,"_47":25,"_48":49,"_50":49,"_51":-5,"_52":-5,"_18":53,"_54":55,"_56":25,"_57":-5,"_58":59,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":228,"_79":229,"_81":230,"_83":25},"tree",[198,199,200,201,202,203,204],"files",[198,199,200,201,202,203,204],"counts",{"_186":187,"_188":189,"_190":61,"_191":192,"_193":194},"contents",[126,127,128,129,130,131,132],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_42":178,"_32":179,"_30":180,"_136":-5,"_40":41,"_39":181,"_138":121,"_37":182,"_13":183,"_33":34,"_35":184,"_24":25,"_142":-5,"_27":185},{"_42":174,"_32":28,"_30":31,"_136":-5,"_40":41,"_39":14,"_138":25,"_37":175,"_13":176,"_33":34,"_35":36,"_24":25,"_142":-5,"_27":177},{"_42":166,"_32":167,"_30":168,"_136":-5,"_40":41,"_39":169,"_138":121,"_37":170,"_13":171,"_33":34,"_35":172,"_24":25,"_142":-5,"_27":173},{"_42":158,"_32":159,"_30":160,"_136":-5,"_40":41,"_39":161,"_138":121,"_37":162,"_13":163,"_33":34,"_35":164,"_24":25,"_142":-5,"_27":165},{"_42":150,"_32":151,"_30":152,"_136":-5,"_40":41,"_39":153,"_138":25,"_37":154,"_13":155,"_33":34,"_35":156,"_24":25,"_142":-5,"_27":157},{"_42":144,"_32":85,"_30":55,"_136":-5,"_40":41,"_39":59,"_138":121,"_37":145,"_13":146,"_33":147,"_35":148,"_24":25,"_142":44,"_27":149},{"_42":133,"_32":134,"_30":135,"_136":-5,"_40":41,"_39":137,"_138":121,"_37":139,"_13":140,"_33":34,"_35":141,"_24":25,"_142":-5,"_27":143},"d374d93c-2459-11f0-8890-569c3dd06744","updateTable","d60ba2a4-21b9-11f0-9a39-569c3dd06744","parentId",116,"latest",["D",1745862866674],17,"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nexport const TABLE_NAME = \"pondiverse_creations_v4\";\nexport default async function(req: Request): Promise {\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT,\n data TEXT,\n type TEXT,\n image TEXT,\n time DATETIME NOT NULL\n )`,\n );\n\n return Response.json({ ok: true });\n}","label",[134],"bdb091ce-2993-11f0-9dc9-569c3dd06744",["D",1746437496776],16,"http","import addCreation from \"./addCreation\";\nimport deleteCreation from \"./deleteCreation\";\nimport getCreation from \"./getCreation\";\nimport getCreationImage from \"./getCreationImage\";\nimport getCreations from \"./getCreations\";\nimport updateTable from \"./updateTable\";\n\nexport default async function(req: Request): Promise {\n let url = new URL(req.url);\n const path = url.pathname.toLowerCase();\n switch (path) {\n case \"/add-creation\":\n return addCreation(req);\n case \"/get-creation\":\n return getCreation(req);\n case \"/get-creation-image\":\n return getCreationImage(req);\n case \"/get-creations\":\n return getCreations(req);\n case \"/update-table\":\n return updateTable(req);\n case \"/delete-creation\":\n return deleteCreation(req);\n }\n\n return Response.json({}, { status: 404 });\n}",[85],"511d97f6-276c-11f0-8b87-569c3dd06744","getCreations","8d306728-21b8-11f0-b0cd-569c3dd06744",155,["D",1746200661921],30,"import { blob } from \"https://esm.town/v/std/blob\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { TABLE_NAME } from \"./updateTable\";\n\nexport default async function(req: Request): Promise {\n // First, get the row IDs of all rows that are older than 25 hours old\n const res = await sqlite.execute(`\n SELECT id FROM ${TABLE_NAME}\n WHERE time < DATETIME('now', '-25 hours')\n `);\n\n // Iterate through each one and delete it's blob\n for (const row of res.rows) {\n console.log(\"delete\", row.id);\n blob.delete(\"pondiverse_image\" + row.id);\n }\n\n // Then, delete all rows that are older than 25 hours old\n await sqlite.execute(`\n DELETE FROM ${TABLE_NAME}\n WHERE time < DATETIME('now', '-25 hours')\n `);\n\n // Get page number query (5 results per page)\n const url = new URL(req.url);\n // const page = +(url.searchParams.get(\"page\") ?? 0);\n\n // Get all rows\n // const rowsPerPage = 5;\n // const offset = (page - 1) * rowsPerPage;\n\n // fuck pages who needs em anyway\n // if it gets slow just wait 25 hours lol\n const response = await sqlite.execute(`\n SELECT * FROM ${TABLE_NAME}\n ORDER BY time DESC\n `);\n\n // const response = await sqlite.execute(`\n // SELECT * FROM ${TABLE_NAME}\n // ORDER BY time DESC\n // LIMIT ${rowsPerPage}\n // OFFSET ${offset}\n // `);\n\n if (response.rows.length === 0) {\n return Response.json({\n ok: true,\n items: [],\n });\n }\n\n // This makes forking harder sorry\n // for (let creation of response.rows) {\n // creation.url = `https://pondiverse.val.run/get-creation?id=${creation.id}`;\n // creation.image = `https://pondiverse.val.run/get-creation-image?id=${creation.id}`;\n // }\n\n return Response.json({\n ok: true,\n rows: response.rows,\n // This makes forking harder sorry\n // next: `https://pondiverse.val.run/get-creations?page=${page + 1}`,\n });\n}",[151],"08f74c84-275c-11f0-8cc2-569c3dd06744","getCreationImage","aa6bc020-2466-11f0-823a-569c3dd06744",142,["D",1746193668929],5,"import { blob } from \"https://esm.town/v/std/blob\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { TABLE_NAME } from \"./updateTable\";\n\nexport default async function(req: Request): Promise {\n const url = new URL(req.url);\n const id = url.searchParams.get(\"id\");\n\n let response;\n try {\n response = await blob.get(\"pondiverse_image\" + id);\n } catch (e) {\n return new Response(null, { status: 404 });\n }\n if (!response.ok) {\n return new Response(response.body, { status: 404 });\n }\n\n const dataUrlBase64 = await response.text();\n const [head, tail] = dataUrlBase64.split(\",\");\n const decoded = atob(tail);\n\n const buffer = new Uint8Array(decoded.length);\n for (let i = 0; i < decoded.length; i++) {\n buffer[i] = decoded.charCodeAt(i);\n }\n\n const type = head.split(\";\")[0].split(\":\")[1];\n\n return new Response(buffer, {\n status: 200,\n headers: {\n \"Content-Type\": type,\n // Allow any origin\n \"Access-Control-Allow-Origin\": \"*\",\n },\n });\n}",[159],"e5842a28-276b-11f0-9958-569c3dd06744","getCreation","efc86a68-275b-11f0-ae87-569c3dd06744",152,["D",1746200481399],3,"import { blob } from \"https://esm.town/v/std/blob\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { TABLE_NAME } from \"./updateTable\";\n\nexport default async function(req: Request): Promise {\n const url = new URL(req.url);\n const id = url.searchParams.get(\"id\");\n\n let result = await sqlite.execute(`SELECT * FROM ${TABLE_NAME} WHERE id = ?`, [id]);\n\n let creation = result.rows[0];\n if (!creation) return Response.json(null, { status: 404 });\n\n // This makes forking harder sorry\n // creation.uri = `https://pondiverse.val.run/get-creation?id=${creation.id}`;\n // creation.image = `https://pondiverse.val.run/get-creation-image?id=${creation.id}`;\n return Response.json(creation);\n}",[167],"cd83db64-2994-11f0-a0b7-569c3dd06744",["D",1746437952827],11,[28],"321d2d98-2777-11f0-b74a-569c3dd06744","addCreation","e03ca2bc-21bb-11f0-94e3-569c3dd06744",156,["D",1746205334376],19,"import { blob } from \"https://esm.town/v/std/blob\";\n\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { TABLE_NAME } from \"./updateTable\";\n\nexport default async function(req: Request): Promise {\n // body contains:\n // - title (string)\n // - data (string)\n // - type (string)\n // - image (data url string)\n\n // sanity checks:\n // - title, not toooo long\n // - data, hmm this needs to be long i guess.. maybe some crazy upper limit sanity check though\n // - type, not too long\n // - image, not toooo large a file size\n let body;\n try {\n body = await req.json();\n } catch (e) {\n return Response.json({ ok: false, error: \"Invalid JSON\" });\n }\n\n const title = body.title;\n const data = body.data;\n const type = body.type;\n const image = body.image;\n\n // Sanity checks\n\n if (title.length > 100) {\n return Response.json({ ok: false, error: \"Title too long\" });\n }\n\n if (type.length > 100) {\n return Response.json({ ok: false, error: \"Type too long\" });\n }\n\n if (image.length > 20 * 1024 * 1024) {\n return Response.json({ ok: false, error: \"Thumbnail too large\" });\n }\n\n if (data.length > 20 * 1024 * 1024) {\n return Response.json({ ok: false, error: \"Data too large\" });\n }\n\n // Now it's time to upload things to database and blob storage\n // First, add to database, and get the ID\n const id = await sqlite.execute(\n `INSERT INTO ${TABLE_NAME} (title, data, type, time) VALUES ($title, $data, $type, $time)`,\n {\n $title: title,\n $data: data,\n $type: type,\n $time: (new Date()).toISOString(),\n },\n );\n\n await blob.set(\"pondiverse_image\" + id.lastInsertRowid, image);\n return Response.json({ ok: true });\n}",[179],"pulls",0,"branches",1,"forks","envVars",{"_195":189,"_197":187},"connections",{"_195":187,"_196":187},"count","unfilledCount","emptyCount",{"_42":178,"_32":179,"_30":180,"_136":-5,"_40":41,"_39":181,"_138":121,"_37":224,"_13":183,"_33":34,"_35":184,"_24":25,"_142":-5,"_206":225,"_27":226},{"_42":174,"_32":28,"_30":31,"_136":-5,"_40":41,"_39":14,"_138":25,"_37":221,"_13":176,"_33":34,"_35":36,"_24":25,"_142":-5,"_206":222,"_27":223},{"_42":166,"_32":167,"_30":168,"_136":-5,"_40":41,"_39":169,"_138":121,"_37":218,"_13":171,"_33":34,"_35":172,"_24":25,"_142":-5,"_206":219,"_27":220},{"_42":158,"_32":159,"_30":160,"_136":-5,"_40":41,"_39":161,"_138":121,"_37":215,"_13":163,"_33":34,"_35":164,"_24":25,"_142":-5,"_206":216,"_27":217},{"_42":150,"_32":151,"_30":152,"_136":-5,"_40":41,"_39":153,"_138":25,"_37":212,"_13":155,"_33":34,"_35":156,"_24":25,"_142":-5,"_206":213,"_27":214},{"_42":144,"_32":85,"_30":55,"_136":-5,"_40":41,"_39":59,"_138":121,"_37":209,"_13":146,"_33":147,"_35":148,"_24":25,"_142":44,"_206":210,"_27":211},{"_42":133,"_32":134,"_30":135,"_136":-5,"_40":41,"_39":137,"_138":121,"_37":205,"_13":140,"_33":34,"_35":141,"_24":25,"_142":-5,"_206":207,"_27":208},["D",1745862866674],"children",[],[134],["D",1746437496776],[],[85],["D",1746200661921],[],[151],["D",1746193668929],[],[159],["D",1746200481399],[],[167],["D",1746437952827],[],[28],["D",1746205334376],[],[179],["D",1741951695949],{"_95":94,"_102":98},{"_95":94,"_96":-5,"_97":98,"_18":53,"_99":100,"_101":25},{"_13":84,"_32":85,"_42":41,"_86":43,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":44,"_93":94},"ctx",{"_77":-5,"_123":264,"_265":266,"_267":268,"_269":25,"_270":25,"_271":25,"_272":121,"_273":-5,"_274":-7,"_275":-7,"_276":187,"_277":25,"_278":25,"_279":-5,"_280":25,"_281":25,"_282":25,"_283":-5},"ENV",{"_235":236,"_237":238,"_239":85,"_240":241,"_242":243,"_244":245,"_246":247,"_248":249,"_250":251,"_252":253,"_254":255,"_256":257,"_258":259,"_260":261,"_262":263},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","71c1b20804b3232a7e513be260cfffc1932a9e97","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 · v169