[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_190":191,"_192":193},"routes/_app.x.$handle.$name",{"_106":105,"_38":51,"_114":96,"_33":108,"_13":14,"_115":-5,"_11":116,"_117":118,"_119":120,"_121":122,"_123":124,"_26":-5,"_125":-5,"_126":-5,"_127":31,"_128":129,"_130":65,"_131":-5,"_132":-5,"_133":134},"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":63,"_64":65,"_66":-5,"_67":-5,"_68":69,"_70":71,"_72":73,"_74":75,"_76":77,"_78":-5,"_79":80,"_81":80,"_82":83,"_84":83,"_85":83,"_86":80,"_87":80,"_88":89,"_90":91,"_92":93,"_94":31},"version",13,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","e0e929e3-fce5-4f97-b2a1-6c87807240c0","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","db.ts","latestPath","fileId","b5e4df38-8534-11f1-90ae-1607ee4eb77e","name","fileType","script","content","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","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 await 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","createdAt",["D",1784660502996],"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","f559200c-8534-11f1-88fb-1607ee4eb77e","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",{"_106":105,"_113":108},"org",{"_106":105,"_107":108,"_109":108,"_19":61,"_110":111,"_112":31},"branch",{"_13":95,"_38":96,"_49":48,"_97":50,"_98":-5,"_99":-5,"_100":-5,"_101":-5,"_102":-5,"_103":51,"_104":105},"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":185,"_53":-5,"_54":31,"_55":56,"_57":56,"_58":59,"_60":-5,"_19":61,"_62":63,"_64":65,"_66":-5,"_67":-5,"_68":69,"_70":71,"_72":73,"_74":75,"_76":186,"_78":-5,"_79":80,"_81":80,"_82":83,"_84":83,"_85":83,"_86":80,"_87":80,"_88":187,"_90":188,"_92":189,"_94":31},"tree",[172,173,174],"files",[172,173,174],"counts",{"_161":69,"_162":163,"_164":69,"_165":166,"_167":168},"contents",[135,136,137],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_49":153,"_38":154,"_36":155,"_140":-5,"_47":48,"_46":156,"_142":31,"_44":157,"_13":158,"_39":26,"_41":159,"_30":31,"_147":-5,"_33":160},{"_49":149,"_38":34,"_36":37,"_140":-5,"_47":48,"_46":14,"_142":31,"_44":150,"_13":151,"_39":40,"_41":43,"_30":31,"_147":-5,"_33":152},{"_49":138,"_38":139,"_36":63,"_140":-5,"_47":48,"_46":141,"_142":31,"_44":143,"_13":144,"_39":145,"_41":146,"_30":31,"_147":-5,"_33":148},"53d76965-e9ec-4081-8e24-22a42ffd166e","main.ts","parentId",7,"latest",["D",1784660166492],3,"http","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","label",[139],"61410512-e2e8-4a72-a662-026e2b02c8bb",["D",1784660502996],2,[34],"5952bce3-893c-4d7f-921b-7246eec95ae9","app.html","f54b1610-8534-11f1-8d27-1607ee4eb77e",12,["D",1784660187699],5,"\n\n\n \n \n Univen Student Hub\n \n\n\n

\n $\"Univen$ \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",1,"forks","envVars",{"_169":69,"_171":69},"connections",{"_169":69,"_170":69},"count","unfilledCount","emptyCount",{"_49":153,"_38":154,"_36":155,"_140":-5,"_47":48,"_46":156,"_142":31,"_44":182,"_13":158,"_39":26,"_41":159,"_30":31,"_147":-5,"_176":183,"_33":184},{"_49":149,"_38":34,"_36":37,"_140":-5,"_47":48,"_46":14,"_142":31,"_44":179,"_13":151,"_39":40,"_41":43,"_30":31,"_147":-5,"_176":180,"_33":181},{"_49":138,"_38":139,"_36":63,"_140":-5,"_47":48,"_46":141,"_142":31,"_44":175,"_13":144,"_39":145,"_41":146,"_30":31,"_147":-5,"_176":177,"_33":178},["D",1784660166492],"children",[],[139],["D",1784660502996],[],[34],["D",1784660187699],[],[154],["D",1784659659428],["D",1789473046147],{"_106":105,"_113":108},{"_106":105,"_107":108,"_109":108,"_19":61,"_110":111,"_112":31},{"_13":95,"_38":96,"_49":48,"_97":50,"_98":-5,"_99":-5,"_100":-5,"_101":-5,"_102":-5,"_103":51,"_104":105},"ctx",{"_88":-5,"_132":223,"_224":225,"_226":227,"_228":31,"_229":31,"_230":31,"_231":65,"_232":-5,"_233":-7,"_234":-7,"_235":69,"_236":31,"_237":31,"_238":-5,"_239":31,"_240":31,"_241":31,"_242":-5},"ENV",{"_194":195,"_196":197,"_198":96,"_199":200,"_201":202,"_203":204,"_205":206,"_207":208,"_209":210,"_211":212,"_213":214,"_215":216,"_217":218,"_219":220,"_221":222},"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 · v13