[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_195":196,"_197":198},"routes/_app.x.$handle.$name",{"_100":99,"_37":50,"_108":90,"_32":102,"_13":14,"_109":-5,"_11":110,"_111":112,"_113":114,"_115":116,"_117":118,"_26":-5,"_119":-5,"_120":-5,"_121":30,"_122":123,"_124":125,"_126":-5,"_127":-5,"_128":129},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_48":49,"_37":50,"_43":51,"_52":-5,"_53":30,"_54":55,"_56":55,"_57":58,"_59":-5,"_19":60,"_61":-5,"_62":30,"_63":-5,"_64":-5,"_65":66,"_67":68,"_69":-5,"_70":-5,"_71":-5,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":30},"version",4,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","c63393e8-58bc-456b-b5ac-a414579a6e40","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":-7,"_29":30,"_31":30,"_32":33,"_34":33},"file",{"_35":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":14,"_46":47,"_29":30},"previous","deleted",false,"deletedHere","path","backend/auth.ts","latestPath","fileId","c01e7b00-64a8-11f1-9f73-1607ee4eb77e","name","auth.ts","fileType","script","content","import { query, queryOne, run } from \"./db.ts\";\n\nconst SESSION_COOKIE = \"devtrack_session\";\nconst SESSION_DAYS = 30;\n\nfunction randomToken(): string {\n return crypto.randomUUID() + crypto.randomUUID().replace(/-/g, \"\");\n}\n\nexport function parseCookies(header: string | null): Record {\n if (!header) return {};\n return Object.fromEntries(\n header.split(\";\").map((c) => {\n const [k, ...v] = c.trim().split(\"=\");\n return [k, decodeURIComponent(v.join(\"=\"))];\n }),\n );\n}\n\nexport async function createSession(userId: number): Promise {\n const token = randomToken();\n const expires = new Date(Date.now() + SESSION_DAYS * 86400_000).toISOString();\n await run(\"INSERT INTO sessions (token, user_id, expires_at) VALUES (?, ?, ?)\", [\n token,\n userId,\n expires,\n ]);\n return token;\n}\n\nexport function sessionCookieHeader(token: string): string {\n const maxAge = SESSION_DAYS * 86400;\n return `${SESSION_COOKIE}=${token}; Path=/; HttpOnly; Secure; SameSite=Lax; Max-Age=${maxAge}`;\n}\n\nexport function clearCookieHeader(): string {\n return `${SESSION_COOKIE}=; Path=/; HttpOnly; Secure; SameSite=Lax; Max-Age=0`;\n}\n\n/** Resolve the current user id from the request cookie, or null. */\nexport async function currentUserId(req: Request): Promise {\n const cookies = parseCookies(req.headers.get(\"Cookie\"));\n const token = cookies[SESSION_COOKIE];\n if (!token) return null;\n const row = await queryOne(\n \"SELECT user_id, expires_at FROM sessions WHERE token = ?\",\n [token],\n );\n if (!row) return null;\n if (new Date(row.expires_at as string) < new Date()) {\n await run(\"DELETE FROM sessions WHERE token = ?\", [token]);\n return null;\n }\n return row.user_id as number;\n}\n\nexport async function logout(req: Request): Promise {\n const cookies = parseCookies(req.headers.get(\"Cookie\"));\n const token = cookies[SESSION_COOKIE];\n if (token) await run(\"DELETE FROM sessions WHERE token = ?\", [token]);\n}\n\n/** Upsert a user from GitHub identity; returns user id. */\nexport async function upsertGithubUser(\n githubId: number,\n login: string,\n email: string | null,\n): Promise {\n const existing = await queryOne(\"SELECT id FROM users WHERE github_id = ?\", [githubId]);\n if (existing) {\n await run(\n \"UPDATE users SET github_login = ?, email = COALESCE(?, email), last_login_at = datetime('now') WHERE id = ?\",\n [login, email, existing.id],\n );\n return existing.id as number;\n }\n const res = await run(\n \"INSERT INTO users (github_id, github_login, email, last_login_at) VALUES (?, ?, ?, datetime('now'))\",\n [githubId, login, email],\n );\n const id = Number(res.lastInsertRowid);\n // Seed default profile + preferences rows.\n await run(\"INSERT OR IGNORE INTO profiles (user_id) VALUES (?)\", [id]);\n await run(\"INSERT OR IGNORE INTO preferences (user_id) VALUES (?)\", [id]);\n return id;\n}\n","createdAt",["D",1781081136564],"branchVersion","branchId","1ae76238-c0b6-4b0a-895f-0fdb02849212","id","ecee92e2-8c00-467b-ac1d-a97525cc499c","devtrack-ai",["D",1781081075707],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","AI-powered developer growth dashboard with real GitHub OAuth","imageUrl","65801581-7a39-4c73-a2b2-f89ec2035c42","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019eb09f-1c5f-722e-a681-4a9d06ccc52b","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_100":99,"_107":102},"org",{"_100":99,"_101":102,"_103":102,"_19":60,"_104":105,"_106":30},"branch",{"_13":89,"_37":90,"_48":47,"_91":49,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":50,"_98":99},"isOwned",24,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","chikatiyugalasri","handle","displayName","","avatar","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_48":49,"_37":50,"_43":191,"_52":-5,"_53":30,"_54":55,"_56":55,"_57":58,"_59":-5,"_19":60,"_61":-5,"_62":30,"_63":-5,"_64":-5,"_65":66,"_67":68,"_69":-5,"_70":-5,"_71":-5,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":192,"_84":193,"_86":194,"_88":30},"tree",[160,164],"files",[160,161,162,163,164],"counts",{"_150":66,"_151":136,"_152":66,"_153":154,"_155":156},"contents",[130,131],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_48":143,"_37":144,"_35":145,"_135":-5,"_46":47,"_45":146,"_137":125,"_43":147,"_13":66,"_39":148,"_41":-5,"_29":30,"_141":-5,"_32":149},{"_48":132,"_37":133,"_35":134,"_135":-5,"_46":47,"_45":136,"_137":30,"_43":138,"_13":66,"_39":139,"_41":140,"_29":30,"_141":-5,"_32":142},"a6bd7d87-dc1b-4de5-b34a-6351818a1ef7","index.ts","9bda6376-64a8-11f1-b9ff-1607ee4eb77e","parentId",1,"latest",["D",1781081075719],"http","import { Hono } from \"npm:hono\";\nconst app = new Hono();\napp.get(\"/\", (c) => c.text(\"DevTrack AI booting...\"));\napp.onError((err) => Promise.reject(err));\nexport default app.fetch;\n","label",[133],"78232b56-f798-4b97-b35f-b7c6434091a1","backend","648bd389-27ec-428e-99d5-1799d453eea8",2,["D",1781081097986],"directory",[144],"pulls","branches","forks","envVars",{"_157":66,"_159":66},"connections",{"_157":66,"_158":66},"count","unfilledCount","emptyCount",{"_48":143,"_37":144,"_35":145,"_135":-5,"_46":47,"_45":146,"_137":125,"_43":188,"_13":66,"_39":148,"_41":-5,"_29":30,"_141":-5,"_166":189,"_32":190},{"_48":184,"_37":38,"_35":36,"_135":145,"_46":47,"_45":14,"_137":125,"_43":185,"_13":66,"_39":40,"_41":42,"_29":30,"_141":-5,"_166":186,"_32":187},{"_48":177,"_37":178,"_35":179,"_135":145,"_46":47,"_45":146,"_137":125,"_43":180,"_13":66,"_39":40,"_41":181,"_29":30,"_141":-5,"_166":182,"_32":183},{"_48":169,"_37":170,"_35":171,"_135":145,"_46":47,"_45":172,"_137":125,"_43":173,"_13":66,"_39":40,"_41":174,"_29":30,"_141":-5,"_166":175,"_32":176},{"_48":132,"_37":133,"_35":134,"_135":-5,"_46":47,"_45":136,"_137":30,"_43":165,"_13":66,"_39":139,"_41":140,"_29":30,"_141":-5,"_166":167,"_32":168},["D",1781081075719],"children",[],[133],"7449789d-3ac9-4f89-9d85-0a8fe726525b","github.ts","b787c79e-64a8-11f1-93c5-1607ee4eb77e",3,["D",1781081122153],"/**\n * GitHub OAuth + REST/GraphQL API client.\n *\n * Requires two env vars (a GitHub OAuth App):\n * GITHUB_CLIENT_ID\n * GITHUB_CLIENT_SECRET\n */\n\nconst CLIENT_ID = () => Deno.env.get(\"GITHUB_CLIENT_ID\") ?? \"\";\nconst CLIENT_SECRET = () => Deno.env.get(\"GITHUB_CLIENT_SECRET\") ?? \"\";\n\nexport function isConfigured(): boolean {\n return !!CLIENT_ID() && !!CLIENT_SECRET();\n}\n\nexport function authorizeUrl(redirectUri: string, state: string): string {\n const params = new URLSearchParams({\n client_id: CLIENT_ID(),\n redirect_uri: redirectUri,\n scope: \"read:user user:email public_repo\",\n state,\n allow_signup: \"true\",\n });\n return `https://github.com/login/oauth/authorize?${params}`;\n}\n\nexport async function exchangeCode(code: string, redirectUri: string): Promise {\n const res = await fetch(\"https://github.com/login/oauth/access_token\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\", Accept: \"application/json\" },\n body: JSON.stringify({\n client_id: CLIENT_ID(),\n client_secret: CLIENT_SECRET(),\n code,\n redirect_uri: redirectUri,\n }),\n });\n const data = await res.json();\n if (data.error || !data.access_token) {\n throw new Error(data.error_description || \"Failed to exchange GitHub code\");\n }\n return data.access_token as string;\n}\n\nasync function gh(token: string, path: string) {\n const res = await fetch(`https://api.github.com${path}`, {\n headers: {\n Authorization: `Bearer ${token}`,\n Accept: \"application/vnd.github+json\",\n \"User-Agent\": \"DevTrack-AI\",\n },\n });\n if (!res.ok) {\n throw new Error(`GitHub API ${path} failed: ${res.status}`);\n }\n return res.json();\n}\n\nexport interface GitHubUser {\n id: number;\n login: string;\n name: string | null;\n avatar_url: string;\n bio: string | null;\n company: string | null;\n location: string | null;\n blog: string | null;\n email: string | null;\n followers: number;\n following: number;\n public_repos: number;\n}\n\nexport function getUser(token: string): Promise {\n return gh(token, \"/user\") as Promise;\n}\n\nexport async function getEmail(token: string): Promise {\n try {\n const emails = await gh(token, \"/user/emails\");\n const primary = (emails as any[]).find((e) => e.primary) ?? (emails as any[])[0];\n return primary?.email ?? null;\n } catch {\n return null;\n }\n}\n\nexport interface GitHubRepo {\n id: number;\n name: string;\n full_name: string;\n description: string | null;\n html_url: string;\n language: string | null;\n stargazers_count: number;\n forks_count: number;\n open_issues_count: number;\n fork: boolean;\n pushed_at: string;\n created_at: string;\n languages_url: string;\n}\n\n/** All repos for the authenticated user (paginated). */\nexport async function getRepos(token: string): Promise {\n const all: GitHubRepo[] = [];\n for (let page = 1; page <= 5; page++) {\n const repos = (await gh(\n token,\n `/user/repos?per_page=100&page=${page}&sort=pushed&affiliation=owner`,\n )) as GitHubRepo[];\n all.push(...repos);\n if (repos.length < 100) break;\n }\n return all;\n}\n\n/** Aggregate language byte counts across the user's (non-fork) repos. */\nexport async function getLanguageBreakdown(\n token: string,\n repos: GitHubRepo[],\n): Promise> {\n const totals: Record = {};\n const top = repos.filter((r) => !r.fork).slice(0, 30); // cap API calls\n await Promise.all(\n top.map(async (r) => {\n try {\n const langs = (await gh(token, `/repos/${r.full_name}/languages`)) as Record;\n for (const [lang, bytes] of Object.entries(langs)) {\n totals[lang] = (totals[lang] ?? 0) + bytes;\n }\n } catch {\n if (r.language) totals[r.language] = (totals[r.language] ?? 0) + 1;\n }\n }),\n );\n return totals;\n}\n\n/**\n * Contribution calendar via the GraphQL API (the public contributions graph).\n * Returns { total, weeks: [{ date, count }...] } flattened to days.\n */\nexport async function getContributions(token: string, login: string) {\n const queryStr = `query($login:String!){\n user(login:$login){\n contributionsCollection{\n contributionCalendar{\n totalContributions\n weeks{ contributionDays{ date contributionCount } }\n }\n }\n }\n }`;\n const res = await fetch(\"https://api.github.com/graphql\", {\n method: \"POST\",\n headers: {\n Authorization: `Bearer ${token}`,\n \"User-Agent\": \"DevTrack-AI\",\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({ query: queryStr, variables: { login } }),\n });\n const json = await res.json();\n const cal = json?.data?.user?.contributionsCollection?.contributionCalendar;\n if (!cal) return { total: 0, days: [] as { date: string; count: number }[] };\n const days: { date: string; count: number }[] = [];\n for (const w of cal.weeks) {\n for (const d of w.contributionDays) {\n days.push({ date: d.date, count: d.contributionCount });\n }\n }\n return { total: cal.totalContributions as number, days };\n}\n\n/** Fetch the README (decoded) for AI review, or null if none. */\nexport async function getReadme(token: string, fullName: string): Promise {\n try {\n const res = await fetch(`https://api.github.com/repos/${fullName}/readme`, {\n headers: {\n Authorization: `Bearer ${token}`,\n Accept: \"application/vnd.github.raw+json\",\n \"User-Agent\": \"DevTrack-AI\",\n },\n });\n if (!res.ok) return null;\n return await res.text();\n } catch {\n return null;\n }\n}\n",[],[144,170],"1d55acad-d77a-4d83-a160-12f5d56362e8","db.ts","a922c870-64a8-11f1-9252-1607ee4eb77e",["D",1781081097986],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n/**\n * DevTrack AI — Production database schema (Val Town SQLite).\n *\n * This is the real, production datastore. The same logical schema is mirrored\n * in /supabase/schema.sql for users who prefer to deploy against Supabase/Postgres.\n *\n * Tables: users, profiles, github_accounts, repositories, goals, reports,\n * notifications, preferences, resume_analysis, interview_sessions, sessions.\n */\n\nlet initialized = false;\n\nexport async function initDb() {\n if (initialized) return;\n\n await sqlite.batch([\n `CREATE TABLE IF NOT EXISTS users (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n email TEXT,\n github_id INTEGER UNIQUE,\n github_login TEXT,\n created_at TEXT NOT NULL DEFAULT (datetime('now')),\n last_login_at TEXT\n )`,\n\n `CREATE TABLE IF NOT EXISTS profiles (\n user_id INTEGER PRIMARY KEY REFERENCES users(id),\n display_name TEXT,\n headline TEXT,\n bio TEXT,\n location TEXT,\n website TEXT,\n avatar_url TEXT,\n theme TEXT NOT NULL DEFAULT 'dark',\n updated_at TEXT NOT NULL DEFAULT (datetime('now'))\n )`,\n\n `CREATE TABLE IF NOT EXISTS github_accounts (\n user_id INTEGER PRIMARY KEY REFERENCES users(id),\n github_id INTEGER,\n login TEXT,\n name TEXT,\n avatar_url TEXT,\n bio TEXT,\n company TEXT,\n location TEXT,\n blog TEXT,\n followers INTEGER DEFAULT 0,\n following INTEGER DEFAULT 0,\n public_repos INTEGER DEFAULT 0,\n total_stars INTEGER DEFAULT 0,\n languages TEXT,\n contributions TEXT,\n access_token TEXT,\n synced_at TEXT\n )`,\n\n `CREATE TABLE IF NOT EXISTS repositories (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n user_id INTEGER NOT NULL REFERENCES users(id),\n repo_id INTEGER,\n name TEXT,\n full_name TEXT,\n description TEXT,\n html_url TEXT,\n language TEXT,\n stars INTEGER DEFAULT 0,\n forks INTEGER DEFAULT 0,\n open_issues INTEGER DEFAULT 0,\n is_fork INTEGER DEFAULT 0,\n pushed_at TEXT,\n created_at TEXT,\n ai_score INTEGER,\n ai_review TEXT,\n synced_at TEXT,\n UNIQUE(user_id, repo_id)\n )`,\n\n `CREATE TABLE IF NOT EXISTS goals (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n user_id INTEGER NOT NULL REFERENCES users(id),\n title TEXT NOT NULL,\n category TEXT,\n target INTEGER,\n progress INTEGER DEFAULT 0,\n status TEXT NOT NULL DEFAULT 'active',\n due_date TEXT,\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n )`,\n\n `CREATE TABLE IF NOT EXISTS reports (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n user_id INTEGER NOT NULL REFERENCES users(id),\n kind TEXT NOT NULL,\n data TEXT NOT NULL,\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n )`,\n\n `CREATE TABLE IF NOT EXISTS notifications (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n user_id INTEGER NOT NULL REFERENCES users(id),\n type TEXT NOT NULL,\n title TEXT NOT NULL,\n body TEXT,\n read INTEGER NOT NULL DEFAULT 0,\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n )`,\n\n `CREATE TABLE IF NOT EXISTS preferences (\n user_id INTEGER PRIMARY KEY REFERENCES users(id),\n email_weekly INTEGER NOT NULL DEFAULT 1,\n email_goal_reminders INTEGER NOT NULL DEFAULT 1,\n email_product INTEGER NOT NULL DEFAULT 0,\n push_enabled INTEGER NOT NULL DEFAULT 1,\n updated_at TEXT NOT NULL DEFAULT (datetime('now'))\n )`,\n\n `CREATE TABLE IF NOT EXISTS resume_analysis (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n user_id INTEGER NOT NULL REFERENCES users(id),\n filename TEXT,\n ats_score INTEGER,\n result TEXT NOT NULL,\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n )`,\n\n `CREATE TABLE IF NOT EXISTS interview_sessions (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n user_id INTEGER NOT NULL REFERENCES users(id),\n role TEXT,\n kind TEXT,\n questions TEXT NOT NULL,\n score INTEGER,\n status TEXT NOT NULL DEFAULT 'in_progress',\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n )`,\n\n `CREATE TABLE IF NOT EXISTS sessions (\n token TEXT PRIMARY KEY,\n user_id INTEGER NOT NULL REFERENCES users(id),\n created_at TEXT NOT NULL DEFAULT (datetime('now')),\n expires_at TEXT NOT NULL\n )`,\n ]);\n\n initialized = true;\n}\n\nexport type Row = Record;\n\nexport async function query(sql: string, args: unknown[] = []): Promise {\n await initDb();\n const res = await sqlite.execute({ sql, args });\n return res.rows as unknown as Row[];\n}\n\nexport async function queryOne(sql: string, args: unknown[] = []): Promise {\n const rows = await query(sql, args);\n return rows[0] ?? null;\n}\n\nexport async function run(sql: string, args: unknown[] = []) {\n await initDb();\n return sqlite.execute({ sql, args });\n}\n",[],[144,178],"443f2120-3338-484d-b720-6dac003e583b",["D",1781081136564],[],[144,38],["D",1781081097986],[161,162,163],[144],["D",1781081075707],{"_100":99,"_107":102},{"_100":99,"_101":102,"_103":102,"_19":60,"_104":105,"_106":30},{"_13":89,"_37":90,"_48":47,"_91":49,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":50,"_98":99},"ctx",{"_82":-5,"_127":228,"_229":230,"_231":232,"_233":30,"_234":30,"_235":30,"_236":125,"_237":-5,"_238":-7,"_239":-7,"_240":66,"_241":30,"_242":30,"_243":-5,"_244":30,"_245":30,"_246":30,"_247":-5},"ENV",{"_199":200,"_201":202,"_203":90,"_204":205,"_206":207,"_208":209,"_210":211,"_212":213,"_214":215,"_216":217,"_218":219,"_220":221,"_222":223,"_224":225,"_226":227},"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 · v4