[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_188":189,"_190":191},"routes/_app.x.$handle.$name",{"_105":104,"_38":51,"_113":95,"_33":107,"_13":14,"_114":-5,"_11":115,"_116":117,"_118":119,"_120":121,"_122":123,"_26":-5,"_124":-5,"_125":-5,"_126":31,"_127":128,"_129":64,"_130":-5,"_131":-5,"_132":133},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_49":50,"_38":51,"_44":52,"_53":-5,"_54":31,"_55":56,"_57":56,"_58":59,"_60":-5,"_19":61,"_62":37,"_63":64,"_65":-5,"_66":-5,"_67":68,"_69":70,"_71":72,"_73":74,"_75":76,"_77":-5,"_78":79,"_80":79,"_81":82,"_83":82,"_84":82,"_85":79,"_86":79,"_87":88,"_89":90,"_91":92,"_93":31},"version",7,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","3d1d823c-6eca-47b3-b998-ca0e93315c42","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":29,"_30":31,"_32":31,"_33":34,"_35":34},"file",{"_36":37,"_38":34,"_39":40,"_41":43,"_44":45,"_46":14,"_47":48,"_30":31},"previous",{"_36":37,"_38":34,"_39":40,"_41":42},"deleted",false,"deletedHere","path","main.ts","latestPath","fileId","f559200c-8534-11f1-88fb-1607ee4eb77e","name","fileType","http","content","import { readFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { blob } from \"https://esm.town/v/std/blob/main.ts\";\nimport { all, run } from \"./db.ts\";\n\nconst FIELDS: Record = {\n products: [\"title\", \"description\", \"price\", \"seller_name\", \"contact\", \"location\"],\n vlogs: [\"title\", \"video_url\", \"author\", \"description\"],\n gossip: [\"title\", \"content\", \"author\"],\n src: [\"title\", \"content\", \"member_name\", \"role\"],\n courses: [\"course_code\", \"course_name\", \"type\", \"content\", \"link\", \"uploaded_by\"],\n};\n\nexport default async function(req: Request): Promise {\n const url = new URL(req.url);\n const path = url.pathname.replace(/\\/$/, \"\");\n\n if (path === \"\" || path === \"/\") {\n const html = await readFile(\"app.html\");\n return new Response(html, {\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n });\n }\n\n // Serve Univen logo (fetched from univen.ac.za, cached in blob storage)\n if (path === \"/logo\") {\n try {\n const cached = await blob.get(\"univen-logo\");\n const buf = await cached.arrayBuffer();\n return new Response(buf, {\n headers: { \"Content-Type\": \"image/png\", \"Cache-Control\": \"max-age=86400\" },\n });\n } catch {\n // Not cached yet — fetch from Univen website\n try {\n const pageRes = await fetch(\"https://www.univen.ac.za\");\n const html = await pageRes.text();\n\n // Try to find logo image URL in the HTML\n let logoUrl =\n html.match(/]*src=\"(https?:\\/\\/[^\"]*(?:logo|UNIVEN|univen)[^\"]*)\"/i)?.[1] ||\n html.match(/]*class=\"[^\"]*logo[^\"]*\"[^>]*src=\"([^\"]*)\"/i)?.[1] ||\n html.match(/]*src=\"([^\"]*)\"[^>]*class=\"[^\"]*logo[^\"]*\"/i)?.[1] ||\n html.match(/]*rel=\"icon\"[^>]*href=\"([^\"]*)\"/i)?.[1] ||\n html.match(/]*rel=\"shortcut icon\"[^>]*href=\"([^\"]*)\"/i)?.[1];\n\n if (logoUrl) {\n if (logoUrl.startsWith(\"/\")) {\n logoUrl = \"https://www.univen.ac.za\" + logoUrl;\n }\n const imgRes = await fetch(logoUrl);\n const imgBuf = await imgRes.arrayBuffer();\n const ct = imgRes.headers.get(\"Content-Type\") || \"image/png\";\n await blob.set(\"univen-logo\", imgBuf);\n return new Response(imgBuf, {\n headers: { \"Content-Type\": ct, \"Cache-Control\": \"max-age=86400\" },\n });\n }\n } catch {\n // Fall through to SVG fallback\n }\n // SVG fallback logo\n const svg = ``;\n return new Response(svg, {\n headers: { \"Content-Type\": \"image/svg+xml\", \"Cache-Control\": \"max-age=3600\" },\n });\n }\n }\n\n // Serve uploaded product photos from blob storage\n const photoMatch = path.match(/^\\/api\\/photo\\/(.+)$/);\n if (photoMatch) {\n try {\n const res = await blob.get(photoMatch[1]);\n const buf = await res.arrayBuffer();\n return new Response(buf, {\n headers: { \"Content-Type\": \"image/jpeg\", \"Cache-Control\": \"max-age=86400\" },\n });\n } catch {\n return new Response(\"Photo not found\", { status: 404 });\n }\n }\n\n const match = path.match(/^\\/api\\/(\\w+)$/);\n if (!match) {\n return new Response(\"Not found\", { status: 404 });\n }\n\n const resource = match[1];\n const fields = FIELDS[resource];\n\n if (!fields) {\n return new Response(JSON.stringify({ error: \"Unknown resource\" }), {\n status: 404,\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n if (req.method === \"GET\") {\n const result = all(`SELECT * FROM ${resource} ORDER BY id DESC`);\n return new Response(JSON.stringify({ rows: result.rows || [] }), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n if (req.method === \"POST\") {\n let body: Record;\n try {\n body = await req.json();\n } catch {\n return new Response(JSON.stringify({ error: \"Invalid JSON\" }), {\n status: 400,\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n const values = fields.map((f) => body[f] ?? \"\");\n const placeholders = fields.map(() => \"?\").join(\", \");\n const cols = fields.join(\", \");\n\n run(`INSERT INTO ${resource} (${cols}) VALUES (${placeholders})`, values);\n\n return new Response(JSON.stringify({ success: true }), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n return new Response(JSON.stringify({ error: \"Method not allowed\" }), {\n status: 405,\n headers: { \"Content-Type\": \"application/json\" },\n });\n}\n","import { readFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { blob } from \"https://esm.town/v/std/blob/main.ts\";\nimport { all, run } from \"./db.ts\";\n\nconst FIELDS: Record = {\n products: [\"title\", \"description\", \"price\", \"seller_name\", \"contact\", \"location\"],\n vlogs: [\"title\", \"video_url\", \"author\", \"description\"],\n gossip: [\"title\", \"content\", \"author\"],\n src: [\"title\", \"content\", \"member_name\", \"role\"],\n courses: [\"course_code\", \"course_name\", \"type\", \"content\", \"link\", \"uploaded_by\"],\n};\n\nexport default async function(req: Request): Promise {\n const url = new URL(req.url);\n const path = url.pathname.replace(/\\/$/, \"\");\n\n if (path === \"\" || path === \"/\") {\n const html = await readFile(\"app.html\");\n return new Response(html, {\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n });\n }\n\n // Serve Univen logo (fetched from univen.ac.za, cached in blob storage)\n if (path === \"/logo\") {\n try {\n const cached = await blob.get(\"univen-logo\");\n const buf = await cached.arrayBuffer();\n return new Response(buf, {\n headers: { \"Content-Type\": \"image/png\", \"Cache-Control\": \"max-age=86400\" },\n });\n } catch {\n // Not cached yet — fetch from Univen website\n try {\n const pageRes = await fetch(\"https://www.univen.ac.za\");\n const html = await pageRes.text();\n\n // Try to find logo image URL in the HTML\n let logoUrl =\n html.match(/]*src=\"(https?:\\/\\/[^\"]*(?:logo|UNIVEN|univen)[^\"]*)\"/i)?.[1] ||\n html.match(/]*class=\"[^\"]*logo[^\"]*\"[^>]*src=\"([^\"]*)\"/i)?.[1] ||\n html.match(/]*src=\"([^\"]*)\"[^>]*class=\"[^\"]*logo[^\"]*\"/i)?.[1] ||\n html.match(/]*rel=\"icon\"[^>]*href=\"([^\"]*)\"/i)?.[1] ||\n html.match(/]*rel=\"shortcut icon\"[^>]*href=\"([^\"]*)\"/i)?.[1];\n\n if (logoUrl) {\n if (logoUrl.startsWith(\"/\")) {\n logoUrl = \"https://www.univen.ac.za\" + logoUrl;\n }\n const imgRes = await fetch(logoUrl);\n const imgBuf = await imgRes.arrayBuffer();\n const ct = imgRes.headers.get(\"Content-Type\") || \"image/png\";\n await blob.set(\"univen-logo\", imgBuf);\n return new Response(imgBuf, {\n headers: { \"Content-Type\": ct, \"Cache-Control\": \"max-age=86400\" },\n });\n }\n } catch {\n // Fall through to SVG fallback\n }\n // SVG fallback logo\n const svg = ``;\n return new Response(svg, {\n headers: { \"Content-Type\": \"image/svg+xml\", \"Cache-Control\": \"max-age=3600\" },\n });\n }\n }\n\n // Serve uploaded product photos from blob storage\n const photoMatch = path.match(/^\\/api\\/photo\\/(.+)$/);\n if (photoMatch) {\n try {\n const res = await blob.get(photoMatch[1]);\n const buf = await res.arrayBuffer();\n return new Response(buf, {\n headers: { \"Content-Type\": \"image/jpeg\", \"Cache-Control\": \"max-age=86400\" },\n });\n } catch {\n return new Response(\"Photo not found\", { status: 404 });\n }\n }\n\n const match = path.match(/^\\/api\\/(\\w+)$/);\n if (!match) {\n return new Response(\"Not found\", { status: 404 });\n }\n\n const resource = match[1];\n const fields = FIELDS[resource];\n\n if (!fields) {\n return new Response(JSON.stringify({ error: \"Unknown resource\" }), {\n status: 404,\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n if (req.method === \"GET\") {\n const result = all(`SELECT * FROM ${resource} ORDER BY id DESC`);\n return new Response(JSON.stringify({ rows: result.rows || [] }), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n if (req.method === \"POST\") {\n const contentType = req.headers.get(\"Content-Type\") || \"\";\n\n // Products with photo upload (multipart form data)\n if (resource === \"products\" && contentType.includes(\"multipart/form-data\")) {\n const formData = await req.formData();\n const photoFile = formData.get(\"photo\") as File | null;\n let photoKey = \"\";\n\n if (photoFile && photoFile.size > 0) {\n photoKey = `product-photo-${Date.now()}-${Math.random().toString(36).slice(2)}`;\n await blob.set(photoKey, await photoFile.arrayBuffer());\n }\n\n const values = fields.map((f) => formData.get(f) ?? \"\");\n const allCols = [...fields, \"photo\"];\n const allValues = [...values, photoKey];\n const placeholders = allCols.map(() => \"?\").join(\", \");\n const cols = allCols.join(\", \");\n\n run(`INSERT INTO products (${cols}) VALUES (${placeholders})`, allValues);\n\n return new Response(JSON.stringify({ success: true }), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n // JSON body for all other resources\n let body: Record;\n try {\n body = await req.json();\n } catch {\n return new Response(JSON.stringify({ error: \"Invalid JSON\" }), {\n status: 400,\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n const values = fields.map((f) => body[f] ?? \"\");\n const placeholders = fields.map(() => \"?\").join(\", \");\n const cols = fields.join(\", \");\n\n // Include empty photo for products via JSON\n if (resource === \"products\") {\n run(`INSERT INTO products (${cols}, photo) VALUES (${placeholders}, ?)`, [...values, \"\"]);\n } else {\n run(`INSERT INTO ${resource} (${cols}) VALUES (${placeholders})`, values);\n }\n\n return new Response(JSON.stringify({ success: true }), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n return new Response(JSON.stringify({ error: \"Method not allowed\" }), {\n status: 405,\n headers: { \"Content-Type\": \"application/json\" },\n });\n}\n","createdAt",["D",1784660166492],"branchVersion","branchId","de406310-6ef9-445a-9d95-0ab7a13b20ea","id","9814e6bc-d899-45ef-97ee-28c7338f8a40","univen-student-hub",["D",1784659659428],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Univen student hub: marketplace, vlogs, gossip, SRC & courses","imageUrl","e4c4caa6-441d-4ad1-94be-8595c8de6dc9","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019f85fa-ef66-71be-9e9d-f5bc0c489178","tursoName","9814e6bcd89945ef97ee28c7338f8a40","tursoHostname","9814e6bcd89945ef97ee28c7338f8a40-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789473046147],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_105":104,"_112":107},"org",{"_105":104,"_106":107,"_108":107,"_19":61,"_109":110,"_111":31},"branch",{"_13":94,"_38":95,"_49":48,"_96":50,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":-5,"_102":51,"_103":104},"isOwned",16,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","Tsirexx96","handle","displayName","","avatar","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_49":50,"_38":51,"_44":183,"_53":-5,"_54":31,"_55":56,"_57":56,"_58":59,"_60":-5,"_19":61,"_62":37,"_63":64,"_65":-5,"_66":-5,"_67":68,"_69":70,"_71":72,"_73":74,"_75":184,"_77":-5,"_78":79,"_80":79,"_81":82,"_83":82,"_84":82,"_85":79,"_86":79,"_87":185,"_89":186,"_91":187,"_93":31},"tree",[170,171,172],"files",[170,171,172],"counts",{"_160":68,"_161":149,"_162":68,"_163":164,"_165":166},"contents",[134,135,136],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_49":153,"_38":154,"_36":155,"_138":-5,"_47":48,"_46":156,"_139":31,"_44":157,"_13":68,"_39":26,"_41":158,"_30":31,"_142":-5,"_33":159},{"_49":144,"_38":145,"_36":146,"_138":-5,"_47":48,"_46":147,"_139":31,"_44":148,"_13":149,"_39":150,"_41":151,"_30":31,"_142":-5,"_33":152},{"_49":137,"_38":34,"_36":37,"_138":-5,"_47":48,"_46":14,"_139":31,"_44":140,"_13":141,"_39":40,"_41":43,"_30":31,"_142":-5,"_33":143},"53d76965-e9ec-4081-8e24-22a42ffd166e","parentId","latest",["D",1784660166492],3,"label",[34],"d7e52eb0-7174-499b-be2a-4df0417c46c8","db.ts","b5e4df38-8534-11f1-90ae-1607ee4eb77e",4,["D",1784660149421],1,"script","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n// Initialize all tables\nsqlite.execute(`\n CREATE TABLE IF NOT EXISTS products (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL,\n description TEXT,\n price TEXT NOT NULL,\n seller_name TEXT NOT NULL,\n contact TEXT NOT NULL,\n location TEXT,\n created_at TEXT DEFAULT (datetime('now'))\n );\n`);\n\n// Migration: add photo column to products\ntry {\n sqlite.execute(`ALTER TABLE products ADD COLUMN photo TEXT DEFAULT ''`);\n} catch {\n // Column already exists\n}\n\nsqlite.execute(`\n CREATE TABLE IF NOT EXISTS vlogs (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL,\n video_url TEXT NOT NULL,\n author TEXT NOT NULL,\n description TEXT,\n created_at TEXT DEFAULT (datetime('now'))\n );\n`);\n\nsqlite.execute(`\n CREATE TABLE IF NOT EXISTS gossip (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL,\n content TEXT NOT NULL,\n author TEXT NOT NULL,\n created_at TEXT DEFAULT (datetime('now'))\n );\n`);\n\nsqlite.execute(`\n CREATE TABLE IF NOT EXISTS src_posts (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL,\n content TEXT NOT NULL,\n member_name TEXT NOT NULL,\n role TEXT,\n created_at TEXT DEFAULT (datetime('now'))\n );\n`);\n\nsqlite.execute(`\n CREATE TABLE IF NOT EXISTS courses (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n course_code TEXT NOT NULL,\n course_name TEXT NOT NULL,\n type TEXT NOT NULL,\n content TEXT NOT NULL,\n link TEXT,\n uploaded_by TEXT NOT NULL,\n created_at TEXT DEFAULT (datetime('now'))\n );\n`);\n\n// Query helpers\nexport function all(query: string, params: unknown[] = []) {\n return sqlite.execute({ sql: query, args: params });\n}\n\nexport function run(query: string, params: unknown[] = []) {\n return sqlite.execute({ sql: query, args: params });\n}\n",[145],"231729f8-74cb-4791-8f6b-bc9c411e8a52","app.html","f54b1610-8534-11f1-8d27-1607ee4eb77e",2,["D",1784659792521],"\n\n\n \n \n Univen Student Hub\n \n\n\n

🎓 Univen Student Hub

University of Venda — Buy, sell, connect & stay updated

\n\n \n\n

\n\n \n

Post a Product for Sale

\n \n

\n\n \n

Share a Vlog

\n \n

\n\n \n

Share the Latest Tea

\n \n

\n\n \n

SRC Announcements and Updates

\n \n

\n\n \n

Upload Timetable or Assignment

\n \n

\n\n \n\n\n",[154],"pulls","branches","forks","envVars",{"_167":68,"_169":68},"connections",{"_167":68,"_168":68},"count","unfilledCount","emptyCount",{"_49":153,"_38":154,"_36":155,"_138":-5,"_47":48,"_46":156,"_139":31,"_44":180,"_13":68,"_39":26,"_41":158,"_30":31,"_142":-5,"_174":181,"_33":182},{"_49":144,"_38":145,"_36":146,"_138":-5,"_47":48,"_46":147,"_139":31,"_44":177,"_13":149,"_39":150,"_41":151,"_30":31,"_142":-5,"_174":178,"_33":179},{"_49":137,"_38":34,"_36":37,"_138":-5,"_47":48,"_46":14,"_139":31,"_44":173,"_13":141,"_39":40,"_41":43,"_30":31,"_142":-5,"_174":175,"_33":176},["D",1784660166492],"children",[],[34],["D",1784660149421],[],[145],["D",1784659792521],[],[154],["D",1784659659428],["D",1789473046147],{"_105":104,"_112":107},{"_105":104,"_106":107,"_108":107,"_19":61,"_109":110,"_111":31},{"_13":94,"_38":95,"_49":48,"_96":50,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":-5,"_102":51,"_103":104},"ctx",{"_87":-5,"_131":221,"_222":223,"_224":225,"_226":31,"_227":31,"_228":31,"_229":64,"_230":-5,"_231":-7,"_232":-7,"_233":68,"_234":31,"_235":31,"_236":-5,"_237":31,"_238":31,"_239":31,"_240":-5},"ENV",{"_192":193,"_194":195,"_196":95,"_197":198,"_199":200,"_201":202,"_203":204,"_205":206,"_207":208,"_209":210,"_211":212,"_213":214,"_215":216,"_217":218,"_219":220},"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 · v7