[{"_1":2,"_173":-5,"_174":-5},"loaderData",{"_3":4,"_92":93},"root",{"_5":6,"_35":36,"_65":66},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":20,"_29":20,"_30":20,"_31":32,"_33":20,"_34":20},"auth",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20,"_21":22},"sessionClaims","sessionId","sessionStatus","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","isAuthenticated",false,"tokenType","session_token","user","preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","notificationCount",0,"flagDenols","isTeamOrgMember","ENV",{"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":50,"_51":52,"_53":54,"_55":56,"_57":58,"_59":60,"_61":62,"_63":64},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","48807a73dfb4c250ae0af97d07e94d04aadb2cac","RENDER_GIT_BRANCH","main","CLERK_PUBLISHABLE_KEY","pk_live_Y2xlcmsudmFsLnRvd24k","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","API_URL","https://api.val.town","clerkState",{"_67":68},"__internal_clerk_state",{"_69":70,"_71":46,"_72":73,"_74":73,"_75":20,"_76":73,"_77":73,"_78":73,"_79":73,"_80":81,"_90":20,"_91":20},"__clerk_ssr_state",{"_21":22,"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__clerk_debug",{"_82":20,"_19":20,"_83":73,"_84":85,"_86":73,"_87":46,"_88":20,"_89":73},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/embed.x.$handle.$name.$",{"_94":95,"_96":97,"_98":99,"_100":101,"_148":149,"_170":171,"_172":-5},"handle","ryi","name","extended-core","path","backend/db.ts","project",{"_102":103,"_96":97,"_104":105,"_106":-5,"_107":20,"_108":109,"_110":73,"_111":-5,"_12":112,"_113":-5,"_114":20,"_115":-5,"_116":-5,"_117":32,"_14":118,"_119":120,"_121":120,"_122":123,"_124":123,"_125":123,"_126":120,"_127":120,"_23":128,"_131":132,"_134":135,"_147":20},"id","d545face-e2c8-11f0-aa2e-42dde27851f2","createdAt",["D",1766801264791],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","f8b34481-b666-4e4c-b330-92f517c060c5","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","1fd640bc-f4e1-40ac-9627-06115c6756a0","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_94":95,"_129":130},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJWN01taHZBV3JpN1FyWUdabTlzQTM5YzBPcCJ9","org",{"_94":95,"_133":130,"_12":112},"avatar","branch",{"_136":137,"_96":44,"_102":138,"_139":103,"_140":-5,"_141":-5,"_142":-5,"_143":-5,"_144":-5,"_145":97,"_146":95},"version",13,"d5464e5c-e2c8-11f0-aa2e-42dde27851f2","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_102":150,"_96":151,"_152":153,"_154":155,"_156":138,"_157":158,"_159":160,"_104":161,"_136":32,"_162":163,"_164":165,"_166":20,"_167":-5,"_98":168},"d61190e4-e2c8-11f0-b10b-42dde27851f2","db.ts","fileId","d61191b6-e2c8-11f0-b10b-42dde27851f2","parentId","d5c306ae-e2c8-11f0-a958-42dde27851f2","branchId","branchVersion",7,"latest",true,["D",1766801266122],"fileType","script","content","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { ArcFileCache, Thread, Cycle, ArcIndex, SyncStatus } from \"../shared/types.ts\";\n\nconst ARCFILES_CACHE_TABLE = \"ryizome_ext_arcfiles_v1\";\nconst THREADS_TABLE = \"ryizome_ext_threads_v1\";\nconst CYCLES_TABLE = \"ryizome_ext_cycles_v1\";\nconst SYNC_META_TABLE = \"ryizome_ext_sync_meta_v1\";\n\nexport async function initDb() {\n // Cached arcfiles from stable core\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${ARCFILES_CACHE_TABLE} (\n arcindex TEXT PRIMARY KEY,\n name TEXT NOT NULL,\n origin TEXT NOT NULL,\n createdAt TEXT NOT NULL,\n lastSynced TEXT NOT NULL\n )\n `);\n\n // Discovered threads from Obsidian\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${THREADS_TABLE} (\n id TEXT PRIMARY KEY,\n arcfileId TEXT NOT NULL,\n goal TEXT NOT NULL,\n classification TEXT NOT NULL,\n filePath TEXT NOT NULL,\n createdAt TEXT NOT NULL,\n discoveredAt TEXT NOT NULL\n )\n `);\n\n // Discovered cycles from Obsidian\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${CYCLES_TABLE} (\n id TEXT PRIMARY KEY,\n threadId TEXT NOT NULL,\n notes TEXT NOT NULL,\n classification TEXT NOT NULL,\n filePath TEXT NOT NULL,\n createdAt TEXT NOT NULL,\n discoveredAt TEXT NOT NULL\n )\n `);\n\n // Sync metadata\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${SYNC_META_TABLE} (\n key TEXT PRIMARY KEY,\n value TEXT NOT NULL\n )\n `);\n}\n\n// Sync metadata\nexport async function getSyncMeta(key: string): Promise {\n const result = await sqlite.execute(\n `SELECT value FROM ${SYNC_META_TABLE} WHERE key = ?`,\n [key]\n );\n return result.rows.length > 0 ? result.rows[0].value as string : null;\n}\n\nexport async function setSyncMeta(key: string, value: string): Promise {\n await sqlite.execute(\n `INSERT OR REPLACE INTO ${SYNC_META_TABLE} (key, value) VALUES (?, ?)`,\n [key, value]\n );\n}\n\nexport async function getSyncStatus(): Promise {\n const [lastArcfileSync, lastObsidianSync] = await Promise.all([\n getSyncMeta('lastArcfileSync'),\n getSyncMeta('lastObsidianSync')\n ]);\n\n const [arcfileResult, threadResult, cycleResult] = await Promise.all([\n sqlite.execute(`SELECT COUNT(*) as count FROM ${ARCFILES_CACHE_TABLE}`),\n sqlite.execute(`SELECT COUNT(*) as count FROM ${THREADS_TABLE}`),\n sqlite.execute(`SELECT COUNT(*) as count FROM ${CYCLES_TABLE}`)\n ]);\n\n return {\n lastArcfileSync,\n lastObsidianSync,\n arcfileCount: arcfileResult.rows[0].count as number,\n threadCount: threadResult.rows[0].count as number,\n cycleCount: cycleResult.rows[0].count as number\n };\n}\n\n// Arcfiles cache\nexport async function upsertArcFileCache(file: ArcFileCache): Promise {\n await sqlite.execute(\n `INSERT OR REPLACE INTO ${ARCFILES_CACHE_TABLE}\n (arcindex, name, origin, createdAt, lastSynced) VALUES (?, ?, ?, ?, ?)`,\n [file.arcindex, file.name, file.origin, file.createdAt, file.lastSynced]\n );\n}\n\nexport async function listArcFilesCache(): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${ARCFILES_CACHE_TABLE} ORDER BY createdAt DESC`\n );\n return result.rows.map(row => ({\n arcindex: row.arcindex as string,\n name: row.name as string,\n origin: row.origin as string,\n createdAt: row.createdAt as string,\n lastSynced: row.lastSynced as string\n }));\n}\n\nexport async function getArcFileCache(arcindex: ArcIndex): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${ARCFILES_CACHE_TABLE} WHERE arcindex = ?`,\n [arcindex]\n );\n if (result.rows.length === 0) return null;\n const row = result.rows[0];\n return {\n arcindex: row.arcindex as string,\n name: row.name as string,\n origin: row.origin as string,\n createdAt: row.createdAt as string,\n lastSynced: row.lastSynced as string\n };\n}\n\n// Threads\nexport async function upsertThread(thread: Thread): Promise {\n await sqlite.execute(\n `INSERT OR REPLACE INTO ${THREADS_TABLE}\n (id, arcfileId, goal, classification, filePath, createdAt, discoveredAt)\n VALUES (?, ?, ?, ?, ?, ?, ?)`,\n [thread.id, thread.arcfileId, thread.goal, thread.classification,\n thread.filePath, thread.createdAt, thread.discoveredAt]\n );\n}\n\nexport async function listThreads(): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${THREADS_TABLE} ORDER BY createdAt DESC`\n );\n return result.rows.map(row => ({\n id: row.id as string,\n arcfileId: row.arcfileId as string,\n goal: row.goal as string,\n classification: row.classification as any,\n filePath: row.filePath as string,\n createdAt: row.createdAt as string,\n discoveredAt: row.discoveredAt as string\n }));\n}\n\nexport async function listThreadsByArcfile(arcfileId: ArcIndex): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${THREADS_TABLE} WHERE arcfileId = ? ORDER BY createdAt DESC`,\n [arcfileId]\n );\n return result.rows.map(row => ({\n id: row.id as string,\n arcfileId: row.arcfileId as string,\n goal: row.goal as string,\n classification: row.classification as any,\n filePath: row.filePath as string,\n createdAt: row.createdAt as string,\n discoveredAt: row.discoveredAt as string\n }));\n}\n\nexport async function getThread(id: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${THREADS_TABLE} WHERE id = ?`,\n [id]\n );\n if (result.rows.length === 0) return null;\n const row = result.rows[0];\n return {\n id: row.id as string,\n arcfileId: row.arcfileId as string,\n goal: row.goal as string,\n classification: row.classification as any,\n filePath: row.filePath as string,\n createdAt: row.createdAt as string,\n discoveredAt: row.discoveredAt as string\n };\n}\n\n// Cycles\nexport async function upsertCycle(cycle: Cycle): Promise {\n await sqlite.execute(\n `INSERT OR REPLACE INTO ${CYCLES_TABLE}\n (id, threadId, notes, classification, filePath, createdAt, discoveredAt)\n VALUES (?, ?, ?, ?, ?, ?, ?)`,\n [cycle.id, cycle.threadId, cycle.notes, cycle.classification,\n cycle.filePath, cycle.createdAt, cycle.discoveredAt]\n );\n}\n\nexport async function listCycles(): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${CYCLES_TABLE} ORDER BY createdAt DESC`\n );\n return result.rows.map(row => ({\n id: row.id as string,\n threadId: row.threadId as string,\n notes: row.notes as string,\n classification: row.classification as any,\n filePath: row.filePath as string,\n createdAt: row.createdAt as string,\n discoveredAt: row.discoveredAt as string\n }));\n}\n\nexport async function listCyclesByThread(threadId: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${CYCLES_TABLE} WHERE threadId = ? ORDER BY createdAt DESC`,\n [threadId]\n );\n return result.rows.map(row => ({\n id: row.id as string,\n threadId: row.threadId as string,\n notes: row.notes as string,\n classification: row.classification as any,\n filePath: row.filePath as string,\n createdAt: row.createdAt as string,\n discoveredAt: row.discoveredAt as string\n }));\n}\n\nexport async function getCycle(id: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${CYCLES_TABLE} WHERE id = ?`,\n [id]\n );\n if (result.rows.length === 0) return null;\n const row = result.rows[0];\n return {\n id: row.id as string,\n threadId: row.threadId as string,\n notes: row.notes as string,\n classification: row.classification as any,\n filePath: row.filePath as string,\n createdAt: row.createdAt as string,\n discoveredAt: row.discoveredAt as string\n };\n}\n","deleted","label",[169,151],"backend","permalink","https://www.val.town/x/ryi/extended-core/code/backend/db.ts","extension","actionData","errors"]