[{"_1":2,"_189":-5,"_190":-5},"loaderData",{"_3":4,"_93":94},"root",{"_5":6,"_36":37,"_66":67},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":20,"_29":20,"_30":20,"_31":-5,"_32":33,"_34":20,"_35":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","preferencesChatPanelState","notificationCount",0,"flagDenols","isTeamOrgMember","ENV",{"_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":65},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","649658ad08db36d20c9686b1f9c11e229c7276ed","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",{"_68":69},"__internal_clerk_state",{"_70":71,"_72":47,"_73":74,"_75":74,"_76":20,"_77":74,"_78":74,"_79":74,"_80":74,"_81":82,"_91":20,"_92":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",{"_83":20,"_19":20,"_84":74,"_85":86,"_87":74,"_88":47,"_89":20,"_90":74},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/embed.x.$handle.$name.$",{"_95":96,"_97":98,"_99":100,"_101":102,"_162":163,"_186":187,"_188":-5},"handle","ozanatgreenpt","name","thirdTimer","path","src/backend/database/queries.ts","project",{"_103":104,"_97":98,"_105":106,"_107":-5,"_108":20,"_109":110,"_111":112,"_113":-5,"_12":114,"_115":116,"_117":118,"_119":-5,"_120":-5,"_121":33,"_14":122,"_123":124,"_125":126,"_127":128,"_129":128,"_130":131,"_132":131,"_133":131,"_134":128,"_135":128,"_23":136,"_139":140,"_144":145,"_161":20},"id","2564eb70-1099-11f1-8a6a-42dde27851f2","createdAt",["D",1771838536808],"deletedAt","legacyEnvVars","privacy","public","description","This version stores some data, so you can restart the app!","imageUrl","019bfe98-75fd-713b-83d5-edcffcda6af5","pinnedFileId","019c89ce-7cc0-75ad-bf76-e12eeaf4e6b3","pinPreview",true,"pinMigrated","screenshotVersion","likeCount","019bfe98-75fd-713b-83d5-f27288110d30","tursoName","2564eb70109911f18a6a42dde27851f2","tursoHostname","2564eb70109911f18a6a42dde27851f2-val-town.aws-us-east-2.turso.io","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_95":96,"_137":138},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzM4cGlWZXRaZkpPd3gzTU9Qb1ZJY3V6a2tVZyJ9","org",{"_95":96,"_141":138,"_12":114,"_142":143},"avatar","tier","free","branch",{"_146":147,"_97":45,"_103":148,"_149":104,"_150":151,"_152":153,"_154":110,"_155":156,"_157":158,"_159":98,"_160":96},"version",120,"2568f8fa-1099-11f1-8a6a-42dde27851f2","projectId","forkedBranchId","d5703b74-7fe8-11f0-a138-0224a6c84d84","forkedBranchVersion",13,"forkedProjectPrivacy","forkedProjectId","d56cf5fe-7fe8-11f0-a138-0224a6c84d84","forkedProjectOrgId","7018ec7d-7a8e-4e8f-93d1-ab6a7334ca50","projectName","userHandle","isOwned","file",{"_103":164,"_97":165,"_166":167,"_168":169,"_170":148,"_171":172,"_173":118,"_105":174,"_146":175,"_176":177,"_178":179,"_180":20,"_181":-5,"_99":182},"eb3b81cc-10be-11f1-b6f0-42dde27851f2","queries.ts","fileId","b376bd66-109a-11f1-8e90-42dde27851f2","parentId","aa5128d4-109a-11f1-929b-42dde27851f2","branchId","branchVersion",95,"latest",["D",1771854760139],14,"fileType","script","content","import { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport type { GroupMemberState, TimerState } from \"../../shared/types.ts\";\n\nconst ADJECTIVES = [\n \"bold\", \"calm\", \"cool\", \"eager\", \"fair\", \"fond\", \"glad\", \"keen\",\n \"kind\", \"mild\", \"neat\", \"safe\", \"warm\", \"wise\", \"able\", \"brave\",\n \"busy\", \"cozy\", \"deft\", \"fast\", \"firm\", \"free\", \"good\", \"happy\",\n];\nconst NOUNS = [\n \"kare\", \"curie\", \"darwin\", \"euler\", \"fermi\", \"gauss\", \"hopper\",\n \"knuth\", \"lamar\", \"morse\", \"nobel\", \"planck\", \"turing\", \"yonath\",\n \"agnesi\", \"bohr\", \"dirac\", \"faraday\", \"hertz\", \"kepler\", \"lovelace\",\n \"mendel\", \"noether\", \"pascal\",\n];\n\nfunction generatePseudonym(userId: string): string {\n let hash = 0;\n for (let i = 0; i < userId.length; i++) {\n hash = ((hash << 5) - hash + userId.charCodeAt(i)) | 0;\n }\n const h = Math.abs(hash);\n return `${ADJECTIVES[h % ADJECTIVES.length]}-${NOUNS[(h >>> 8) % NOUNS.length]}`;\n}\n\nexport async function getState(userId: string): Promise {\n const result = await sqlite.execute({\n sql: \"SELECT * FROM timer_states WHERE user_id = ?\",\n args: [userId],\n });\n\n if (result.rows.length === 0) return null;\n\n const row = result.rows[0];\n const cols = result.columns;\n const col = (name: string) => row[cols.indexOf(name)];\n\n return {\n mode: col(\"mode\") as TimerState[\"mode\"],\n workStartTime: col(\"work_start_time\") as number | null,\n breakStartTime: col(\"break_start_time\") as number | null,\n savedBreakMinutes: col(\"saved_break_minutes\") as number,\n breakFraction: col(\"break_fraction\") as number,\n totalWorkTime: col(\"total_work_time\") as number,\n totalBreakTime: col(\"total_break_time\") as number,\n sessionStartedAt: col(\"session_started_at\") as number | null,\n };\n}\n\nexport async function saveState(userId: string, state: TimerState, passphrase: string | null = null, displayName: string | null = null, sessionIntent: string | null = null): Promise {\n await sqlite.execute({\n sql: `INSERT OR REPLACE INTO timer_states\n (user_id, mode, work_start_time, break_start_time, saved_break_minutes, break_fraction, total_work_time, total_break_time, passphrase, display_name, session_intent, session_started_at)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [\n userId,\n state.mode,\n state.workStartTime,\n state.breakStartTime,\n state.savedBreakMinutes,\n state.breakFraction,\n state.totalWorkTime,\n state.totalBreakTime,\n passphrase,\n displayName,\n sessionIntent,\n state.sessionStartedAt,\n ],\n });\n}\n\nexport async function getGroupStates(passphrase: string, excludeUserId: string): Promise {\n const result = await sqlite.execute({\n sql: `SELECT user_id, mode, work_start_time, break_start_time, display_name, session_intent FROM timer_states WHERE passphrase = ? AND user_id != ?`,\n args: [passphrase, excludeUserId],\n });\n\n const cols = result.columns;\n return result.rows.map((row) => {\n const col = (name: string) => row[cols.indexOf(name)];\n const displayName = col(\"display_name\") as string | null;\n return {\n mode: col(\"mode\") as GroupMemberState[\"mode\"],\n workStartTime: col(\"work_start_time\") as number | null,\n breakStartTime: col(\"break_start_time\") as number | null,\n displayName: displayName || generatePseudonym(col(\"user_id\") as string),\n sessionIntent: col(\"session_intent\") as string | null,\n };\n });\n}\n\nexport async function getActiveTimerCount(): Promise {\n const oneDayAgo = Date.now() - 24 * 60 * 60 * 1000;\n const result = await sqlite.execute({\n sql: \"SELECT COUNT(*) as count FROM timer_states WHERE work_start_time IS NOT NULL AND work_start_time > ?\",\n args: [oneDayAgo],\n });\n return result.rows[0][0] as number;\n}\n\nexport async function saveSessionHistory(record: {\n ownerToken: string;\n intent: string | null;\n workTime: number;\n breakTime: number;\n startedAt: string;\n endedAt: string;\n breakFraction: number;\n}): Promise {\n await sqlite.execute({\n sql: `INSERT INTO session_history (owner_token, intent, work_time, break_time, started_at, ended_at, break_fraction)\n VALUES (?, ?, ?, ?, ?, ?, ?)`,\n args: [\n record.ownerToken,\n record.intent,\n record.workTime,\n record.breakTime,\n record.startedAt,\n record.endedAt,\n record.breakFraction,\n ],\n });\n}\n\nexport async function getDistinctIntents(ownerToken: string): Promise {\n const result = await sqlite.execute({\n sql: `SELECT intent FROM session_history WHERE owner_token = ? AND intent IS NOT NULL AND intent != '' GROUP BY intent ORDER BY MAX(ended_at) DESC`,\n args: [ownerToken],\n });\n return result.rows.map((row) => row[0] as string);\n}\n\nexport async function getHistoryByIntent(ownerToken: string): Promise> {\n const result = await sqlite.execute({\n sql: `SELECT\n COALESCE(intent, '(no intent)') as intent,\n COUNT(*) as session_count,\n SUM(work_time) as total_work_time,\n AVG(work_time) as avg_session_length,\n COUNT(DISTINCT DATE(ended_at)) as days_worked,\n MAX(ended_at) as last_worked\n FROM session_history\n WHERE owner_token = ?\n GROUP BY COALESCE(intent, '(no intent)')\n ORDER BY MAX(ended_at) DESC`,\n args: [ownerToken],\n });\n\n const cols = result.columns;\n return result.rows.map((row) => {\n const col = (name: string) => row[cols.indexOf(name)];\n return {\n intent: col(\"intent\") as string,\n sessionCount: col(\"session_count\") as number,\n totalWorkTime: col(\"total_work_time\") as number,\n avgSessionLength: col(\"avg_session_length\") as number,\n daysWorked: col(\"days_worked\") as number,\n lastWorked: col(\"last_worked\") as string,\n };\n });\n}\n\nexport async function getHistorySummary(ownerToken: string, period: \"daily\" | \"weekly\"): Promise> {\n const groupExpr = period === \"daily\"\n ? \"DATE(ended_at)\"\n : \"strftime('%Y-W%W', ended_at)\";\n\n const result = await sqlite.execute({\n sql: `SELECT\n ${groupExpr} as period,\n SUM(work_time) as total_work_time,\n SUM(break_time) as total_break_time,\n COUNT(*) as session_count\n FROM session_history\n WHERE owner_token = ?\n GROUP BY ${groupExpr}\n ORDER BY period DESC\n LIMIT 30`,\n args: [ownerToken],\n });\n\n const cols = result.columns;\n return result.rows.map((row) => {\n const col = (name: string) => row[cols.indexOf(name)];\n return {\n period: col(\"period\") as string,\n totalWorkTime: col(\"total_work_time\") as number,\n totalBreakTime: col(\"total_break_time\") as number,\n sessionCount: col(\"session_count\") as number,\n };\n });\n}\n","deleted","label",[183,184,185,165],"src","backend","database","permalink","https://www.val.town/x/ozanatgreenpt/thirdTimer/code/src/backend/database/queries.ts","extension","actionData","errors"]