[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_109":110,"_111":112},"routes/embed.x.$handle.$name.$",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":-5},"handle","manas","name","togethr-beta-relay","path","db.ts","project",{"_22":45,"_11":12,"_33":46,"_47":-5,"_48":42,"_49":50,"_51":50,"_52":53,"_54":-5,"_55":56,"_57":58,"_59":32,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":42},"file",{"_22":23,"_11":14,"_24":25,"_26":-5,"_27":28,"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":-5,"_13":44},"permalink","https://www.val.town/x/manas/togethr-beta-relay/code/db.ts","extension","id","53254fea-c879-4c8d-8f86-ed19b333a67f","fileId","01a0157c-7a0e-76a8-9d6f-cd5a6bfb415a","parentId","branchId","095fa0fe-5a43-4bf0-9222-aaa30fc6f0b0","branchVersion",2,"latest",true,"createdAt",["D",1787067080726],"version",1,"fileType","script","content","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport type RelationType = \"Partner\" | \"Gym buddy\";\nexport type DeviceRow = { id: string; token_hash: string; display_name: string; created_at: string };\nexport type ConnectionView = { id: string; relationType: RelationType; peer: { id: string; displayName: string }; createdAt: string };\n\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS devices (\n id TEXT PRIMARY KEY,\n token_hash TEXT NOT NULL,\n display_name TEXT NOT NULL,\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n)`);\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS invites (\n code TEXT PRIMARY KEY,\n creator_device_id TEXT NOT NULL REFERENCES devices(id) ON DELETE CASCADE,\n accepted_device_id TEXT REFERENCES devices(id) ON DELETE SET NULL,\n connection_id TEXT,\n relation_type TEXT NOT NULL CHECK (relation_type IN ('Partner', 'Gym buddy')),\n status TEXT NOT NULL DEFAULT 'pending' CHECK (status IN ('pending', 'accepted', 'revoked')),\n expires_at TEXT NOT NULL,\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n)`);\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS connections (\n id TEXT PRIMARY KEY,\n device_a_id TEXT NOT NULL REFERENCES devices(id) ON DELETE CASCADE,\n device_b_id TEXT NOT NULL REFERENCES devices(id) ON DELETE CASCADE,\n relation_type TEXT NOT NULL CHECK (relation_type IN ('Partner', 'Gym buddy')),\n created_at TEXT NOT NULL DEFAULT (datetime('now')),\n UNIQUE(device_a_id, device_b_id)\n)`);\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS sessions (\n id TEXT PRIMARY KEY,\n connection_id TEXT NOT NULL REFERENCES connections(id) ON DELETE CASCADE,\n created_by_device_id TEXT NOT NULL REFERENCES devices(id) ON DELETE CASCADE,\n title TEXT NOT NULL,\n status TEXT NOT NULL DEFAULT 'live' CHECK (status IN ('live', 'completed')),\n created_at TEXT NOT NULL DEFAULT (datetime('now')),\n completed_at TEXT\n)`);\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS session_events (\n seq INTEGER PRIMARY KEY AUTOINCREMENT,\n event_id TEXT NOT NULL UNIQUE,\n session_id TEXT NOT NULL REFERENCES sessions(id) ON DELETE CASCADE,\n device_id TEXT NOT NULL REFERENCES devices(id) ON DELETE CASCADE,\n event_type TEXT NOT NULL,\n payload_json TEXT NOT NULL,\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n)`);\n\nexport async function insertDevice(id: string, tokenHash: string, displayName: string) {\n await sqlite.execute({ sql: \"INSERT INTO devices (id, token_hash, display_name) VALUES (?, ?, ?)\", args: [id, tokenHash, displayName] });\n}\nexport async function getDevice(id: string): Promise {\n const result = await sqlite.execute({ sql: \"SELECT * FROM devices WHERE id = ? LIMIT 1\", args: [id] });\n return (result.rows[0] as unknown as DeviceRow | undefined) ?? null;\n}\nexport async function updateDeviceName(id: string, displayName: string) {\n await sqlite.execute({ sql: \"UPDATE devices SET display_name = ? WHERE id = ?\", args: [displayName, id] });\n}\nexport async function createInvite(code: string, creatorDeviceId: string, relationType: RelationType) {\n const expiresAt = new Date(Date.now() + 24 * 60 * 60 * 1000).toISOString();\n await sqlite.execute({ sql: \"INSERT INTO invites (code, creator_device_id, relation_type, expires_at) VALUES (?, ?, ?, ?)\", args: [code, creatorDeviceId, relationType, expiresAt] });\n return expiresAt;\n}\nexport async function getInvite(code: string) {\n const result = await sqlite.execute({\n sql: `SELECT i.code, i.creator_device_id, i.relation_type, i.status, i.expires_at, d.display_name AS creator_name\n FROM invites i JOIN devices d ON d.id = i.creator_device_id WHERE i.code = ? LIMIT 1`,\n args: [code],\n });\n return (result.rows[0] as Record | undefined) ?? null;\n}\nexport async function acceptInvite(code: string, acceptedDeviceId: string, connectionId: string) {\n const invite = await getInvite(code);\n if (!invite) throw new Error(\"INVITE_NOT_FOUND\");\n if (invite.status !== \"pending\") throw new Error(\"INVITE_NOT_PENDING\");\n if (String(invite.expires_at) <= new Date().toISOString()) throw new Error(\"INVITE_EXPIRED\");\n if (invite.creator_device_id === acceptedDeviceId) throw new Error(\"INVITE_SELF\");\n await sqlite.execute({ sql: \"INSERT INTO connections (id, device_a_id, device_b_id, relation_type) VALUES (?, ?, ?, ?)\", args: [connectionId, String(invite.creator_device_id), acceptedDeviceId, String(invite.relation_type)] });\n await sqlite.execute({ sql: \"UPDATE invites SET accepted_device_id = ?, connection_id = ?, status = 'accepted' WHERE code = ?\", args: [acceptedDeviceId, connectionId, code] });\n return connectionId;\n}\nexport async function listConnections(deviceId: string): Promise {\n const result = await sqlite.execute({\n sql: `SELECT c.id, c.relation_type, c.created_at,\n CASE WHEN c.device_a_id = ? THEN b.id ELSE a.id END AS peer_id,\n CASE WHEN c.device_a_id = ? THEN b.display_name ELSE a.display_name END AS peer_name\n FROM connections c JOIN devices a ON a.id = c.device_a_id JOIN devices b ON b.id = c.device_b_id\n WHERE c.device_a_id = ? OR c.device_b_id = ? ORDER BY c.created_at DESC`,\n args: [deviceId, deviceId, deviceId, deviceId],\n });\n return (result.rows as unknown as Array>).map((row) => ({\n id: String(row.id), relationType: String(row.relation_type) as RelationType,\n peer: { id: String(row.peer_id), displayName: String(row.peer_name) }, createdAt: String(row.created_at),\n }));\n}\nexport async function deviceInConnection(connectionId: string, deviceId: string) {\n const result = await sqlite.execute({ sql: \"SELECT 1 AS ok FROM connections WHERE id = ? AND (device_a_id = ? OR device_b_id = ?) LIMIT 1\", args: [connectionId, deviceId, deviceId] });\n return result.rows.length > 0;\n}\nexport async function createSession(id: string, connectionId: string, deviceId: string, title: string) {\n await sqlite.execute({ sql: \"UPDATE sessions SET status = 'completed', completed_at = datetime('now') WHERE connection_id = ? AND status = 'live'\", args: [connectionId] });\n await sqlite.execute({ sql: \"INSERT INTO sessions (id, connection_id, created_by_device_id, title) VALUES (?, ?, ?, ?)\", args: [id, connectionId, deviceId, title] });\n}\nexport async function getActiveSession(connectionId: string) {\n const result = await sqlite.execute({ sql: \"SELECT * FROM sessions WHERE connection_id = ? AND status = 'live' ORDER BY created_at DESC LIMIT 1\", args: [connectionId] });\n return (result.rows[0] as Record | undefined) ?? null;\n}\nexport async function getSession(sessionId: string) {\n const result = await sqlite.execute({ sql: \"SELECT * FROM sessions WHERE id = ? LIMIT 1\", args: [sessionId] });\n return (result.rows[0] as Record | undefined) ?? null;\n}\nexport async function addSessionEvent(eventId: string, sessionId: string, deviceId: string, eventType: string, payload: unknown) {\n await sqlite.execute({ sql: \"INSERT OR IGNORE INTO session_events (event_id, session_id, device_id, event_type, payload_json) VALUES (?, ?, ?, ?, ?)\", args: [eventId, sessionId, deviceId, eventType, JSON.stringify(payload)] });\n const result = await sqlite.execute({ sql: \"SELECT seq FROM session_events WHERE event_id = ? LIMIT 1\", args: [eventId] });\n return Number((result.rows[0] as Record | undefined)?.seq ?? 0);\n}\nexport async function listSessionEvents(sessionId: string, afterSeq: number) {\n const result = await sqlite.execute({ sql: \"SELECT seq, event_id, device_id, event_type, payload_json, created_at FROM session_events WHERE session_id = ? AND seq > ? ORDER BY seq ASC LIMIT 100\", args: [sessionId, afterSeq] });\n return (result.rows as unknown as Array>).map((row) => ({ seq: Number(row.seq), eventId: String(row.event_id), deviceId: String(row.device_id), type: String(row.event_type), payload: JSON.parse(String(row.payload_json)), createdAt: String(row.created_at) }));\n}\nexport async function finishSession(sessionId: string) {\n await sqlite.execute({ sql: \"UPDATE sessions SET status = 'completed', completed_at = datetime('now') WHERE id = ?\", args: [sessionId] });\n}\n","deleted",false,"label",[14],"f81ec633-62da-4fa6-8a9b-5ee623c88180",["D",1787066874304],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Togethr beta invite and session relay","imageUrl","userId","bdda9a4c-13e6-4481-b3c2-7ac3d6eab867","pinnedFileId","01a0157c-7a0e-76a8-9d6f-d340704549ae","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019fcccd-fd9a-74cd-9f90-ade6d5af4f67","tursoName","f81ec63362da4fa68a9b5ee623c88180","tursoHostname","f81ec63362da4fa68a9b5ee623c88180-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789499469860],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_9":10,"_108":104},"org",{"_9":10,"_102":10,"_103":104,"_55":56,"_105":106,"_107":42},"branch",{"_35":89,"_11":90,"_22":28,"_91":45,"_92":93,"_94":36,"_95":50,"_96":97,"_98":99,"_100":12,"_101":10},"isOwned",6,"main","projectId","forkedBranchId","fb141f8d-047d-43b3-b09c-7fd59d8ddcfe","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","a35fc79f-ccd4-4375-94dc-260d312636c6","forkedProjectOrgId","019aa807-52c2-709c-928b-2029bae9a558","projectName","userHandle","displayName","avatar","https://lh3.googleusercontent.com/a/ACg8ocIDM6L3j1I5a-9KRxESWnU76mLAa66fJBhefbGOknwGZXzF-g=s96-c","tier","free","canRestrictVals","profileImageUrl","ctx",{"_82":-5,"_142":143,"_144":145,"_146":147,"_148":42,"_149":42,"_150":42,"_151":32,"_152":-5,"_153":-7,"_154":-7,"_155":63,"_156":42,"_157":42,"_158":-5,"_159":42,"_160":42,"_161":42,"_162":-5},"ENV",{"_113":114,"_115":116,"_117":90,"_118":119,"_120":121,"_122":123,"_124":125,"_126":127,"_128":129,"_130":131,"_132":133,"_134":135,"_136":137,"_138":139,"_140":141},"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","orgs",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]