[{"_1":2,"_179":-5,"_180":-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","59ec1ef0e18859058993800a2105674ef41eefe7","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,"_159":160,"_176":177,"_178":-5},"handle","wizos","name","cache","path","main.tsx","project",{"_103":104,"_97":98,"_105":106,"_107":-5,"_108":109,"_110":111,"_112":-5,"_113":-5,"_12":114,"_115":-5,"_116":109,"_117":-5,"_118":-5,"_119":33,"_14":120,"_121":-5,"_122":-5,"_123":-5,"_124":125,"_126":125,"_127":128,"_129":128,"_130":128,"_131":125,"_132":125,"_23":133,"_136":137,"_141":142,"_158":20},"id","3e242b60-26cc-11f0-9439-569c3dd06744","createdAt",["D",1746131910620],"deletedAt","legacyEnvVars",true,"privacy","unlisted","description","imageUrl","0fd49fcc-8056-4698-ad92-c31c10361eba","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","2bbd561c-2791-41e8-bb0e-39228de08122","tursoName","tursoHostname","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_95":96,"_134":135},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJpZFZsMUpZZFBSUUNNcHNKQzRBbFpjVk94VSJ9","org",{"_95":96,"_138":135,"_12":114,"_139":140},"avatar","tier","free","branch",{"_143":144,"_97":45,"_103":145,"_146":104,"_147":148,"_149":33,"_150":151,"_152":153,"_154":155,"_156":98,"_157":96},"version",1,"3e249866-26cc-11f0-9439-569c3dd06744","projectId","forkedBranchId","50b74476-279c-11f0-9d52-569c3dd06744","forkedBranchVersion","forkedProjectPrivacy","public","forkedProjectId","50b6a57a-279c-11f0-9d52-569c3dd06744","forkedProjectOrgId","5e5de42a-e7ad-44f1-bdfc-fb2991b3e132","projectName","userHandle","isOwned","file",{"_103":161,"_97":100,"_162":163,"_164":-5,"_165":145,"_166":144,"_167":109,"_105":168,"_143":33,"_169":170,"_171":172,"_173":20,"_174":-5,"_99":175},"3e289420-26cc-11f0-9439-569c3dd06744","fileId","3e2895ec-26cc-11f0-9439-569c3dd06744","parentId","branchId","branchVersion","latest",["D",1731572189632],"fileType","script","content","import { sqlite } from \"https://esm.town/v/std/sqlite\";\n\n// Retrieve the table name from the environment variable\n// Fail if it's not present.\nconst tableName = Deno.env.get(\"CACHE_TABLE_NAME\");\nif (tableName === undefined) {\n console.error(\n \"Env variable 'CACHE_TABLE_NAME' is not configured. Stopping execution.\",\n );\n throw new Error(\"Env variable 'CACHE_TABLE_NAME' is not configured\");\n}\n\n/**\n * Defualt TTL (time to live) - this describes how long a default cache entry\n * is guaranteed to persist. The default value is 24 hours, can be changed by\n * setting the `CACHE_DEFAULT_TTL` environment variable with a new default value\n * in seconds.\n */\nconst defaultTTL = parseInt(\n Deno.env.get(\"CACHE_DEFAULT_TTL\") || `${24 * 60 * 60}`,\n);\n\n/**\n * Setup the cache table if it does not exist.\n * Make sure to set the `CACHE_TABLE_NAME` environment variable first.\n */\nexport async function setup() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${tableName} (\n key TEXT PRIMARY KEY,\n content TEXT NOT NULL,\n expires_at DATETIME\n )\n `);\n console.log(\"Cache setup complete.\");\n}\n\n/**\n * Check if the provided key exists (has value) in the cache.\n * If the key is expired, it's considered non-existent.\n * @param key The key to check if exists\n * @returns The value indicating whether the key is present in cache.\n */\nexport async function exists(key): Promise {\n const result = await sqlite.execute({\n sql: `SELECT 1 FROM ${tableName} WHERE key = :key AND (expires_at IS NULL OR expires_at > datetime('now'))`,\n args: { key },\n });\n return result.rows.length > 0;\n}\n\n/**\n * Get a value from the cache by key. You can provide a type of the return value or it will default to `unknown`.\n * @param key The key to get the value for\n * @returns The value for the key, or `null` if the key does not exist or has expired\n */\nexport async function get(key): Promise {\n const result = await sqlite.execute({\n sql: `SELECT content FROM ${tableName} WHERE key = :key AND (expires_at IS NULL OR expires_at > datetime('now'))`,\n args: { key },\n });\n return result.rows.length > 0\n ? JSON.parse(result.rows[0][0] as string) as T\n : null;\n}\n\n/**\n * Set a value in the cache\n * @param key The key to set the value for\n * @param value The value to set\n * @param ttl The time to live in seconds. If not set, the default TTL is used.\n * @returns The number of keys set (1 if the key was inserted/updated, 0 if the ttl was 0)\n */\nexport async function set(key, value, ttl: number = defaultTTL): Promise {\n if (ttl <= 0) return 0;\n const expires_at = ttl ? `datetime('now', '+${ttl} seconds')` : null;\n const result = await sqlite.execute({\n sql:\n `INSERT INTO ${tableName} (key, content, expires_at) VALUES (:key, :content, ${expires_at}) ON CONFLICT(key) DO UPDATE SET content = :content, expires_at = ${expires_at}`,\n args: { key, content: JSON.stringify(value) },\n });\n return result.rowsAffected;\n}\n\n/**\n * Set a value in the cache\n * @param key The key to set the value for\n * @param value The value to set\n * @param expiresAt The expiration time as a UTC date string. If not set, the default expiration is used.\n * @returns The number of keys set (1 if the key was inserted/updated, 0 if the expiresAt was in the past)\n */\nexport async function setUntil(key: string, value: unknown, expiresAt: string): Promise {\n const currentDateTime = new Date().toISOString();\n if (expiresAt <= currentDateTime) return 0;\n\n const result = await sqlite.execute({\n sql:\n `INSERT INTO ${tableName} (key, content, expires_at) VALUES (:key, :content, :expiresAt) ON CONFLICT(key) DO UPDATE SET content = :content, expires_at = :expiresAt`,\n args: { key, content: JSON.stringify(value), expiresAt },\n });\n return result.rowsAffected;\n}\n\n/**\n * Update the expiration date of a cache entry based on TTL.\n * @param key The key of the cache entry to update.\n * @param ttl The time to live in seconds from now.\n * @returns The number of keys updated (1 if updated, 0 if not found or ttl was 0).\n */\nexport async function setExpiration(key: string, ttl: number = defaultTTL): Promise {\n if (ttl <= 0) return 0;\n const expires_at = `datetime('now', '+${ttl} seconds')`;\n\n const result = await sqlite.execute({\n sql:\n `UPDATE ${tableName} SET expires_at = ${expires_at} WHERE key = :key AND (expires_at IS NULL OR expires_at > datetime('now'))`,\n args: { key },\n });\n\n return result.rowsAffected;\n}\n\n/**\n * Update the expiration date of a cache entry to a specific UTC date and time.\n * @param key The key of the cache entry to update.\n * @param expiresAt The expiration time as a UTC date string.\n * @returns The number of keys updated (1 if updated, 0 if not found or expiresAt was in the past).\n */\nexport async function setExpirationUntil(key: string, expiresAt: string): Promise {\n const currentDateTime = new Date().toISOString();\n if (expiresAt <= currentDateTime) return 0;\n\n const result = await sqlite.execute({\n sql:\n `UPDATE ${tableName} SET expires_at = :expiresAt WHERE key = :key AND (expires_at IS NULL OR expires_at > datetime('now'))`,\n args: { key, expiresAt },\n });\n\n return result.rowsAffected;\n}\n\n/**\n * Gets a list of all non-expired keys in the cache that match the prefix.\n * If no prefix is provided, all keys are returned.\n * @param prefix The optional prefix to match keys against\n * @returns A list of keys. Can be an empty list (array) if no keys match.\n */\nexport async function listKeys(\n prefix: string | undefined = undefined,\n): Promise {\n const result = await sqlite.execute({\n sql: prefix == null || prefix === \"\"\n ? `SELECT key FROM ${tableName} WHERE (expires_at IS NULL OR expires_at > datetime('now'))`\n : `SELECT key FROM ${tableName} WHERE key LIKE :prefix || '%' AND (expires_at IS NULL OR expires_at > datetime('now'))`,\n args: { prefix },\n });\n return result.rows.map((row) => row[0] as string);\n}\n\n/**\n * Get many key-value pairs from the cache that match the given prefix.\n * @param prefix The prefix to match keys against. If not provided, all keys are considered.\n * @param limit The maximum number of key-value pairs to return. If 0, no limit is applied.\n * @returns An array of key-value pairs. Each pair is an object with 'key' and 'value' properties.\n */\nexport async function getMany(\n prefix: string | undefined = undefined,\n limit: number = 0,\n): Promise> {\n // Construct the base SQL query\n let sql = `SELECT key, content FROM ${tableName} WHERE (expires_at IS NULL OR expires_at > datetime('now'))`;\n let args: any = {};\n\n // Add the prefix condition if a prefix is provided\n if (prefix != null && prefix !== \"\") {\n sql += ` AND key LIKE :prefix || '%'`;\n args.prefix = prefix;\n }\n\n // Add the limit condition if a limit is specified\n if (limit > 0) {\n sql += ` LIMIT :limit`;\n args.limit = limit;\n }\n\n const result = await sqlite.execute({\n sql,\n args,\n });\n\n // Map the results to an array of key-value objects\n return result.rows.map((row) => ({\n key: row[0] as string,\n value: JSON.parse(row[1] as string) as T,\n }));\n}\n\n/**\n * Delete a key from the cache\n * @param key The key to delete\n * @returns The number of keys deleted (1 if the key was deleted, 0 if the key did not exist)\n */\nexport async function deleteKey(key): Promise {\n const result = await sqlite.execute({\n sql: `DELETE FROM ${tableName} WHERE key = :key`,\n args: { key },\n });\n return result.rowsAffected;\n}\n\n/**\n * Delete all keys from the cache that match the prefix.\n * If no prefix is provided, all keys in the cache are deleted.\n * @param prefix The optional prefix to match keys against\n * @returns The number of keys deleted\n */\nexport async function deleteKeys(\n prefix: string | undefined = undefined,\n): Promise {\n const result = await sqlite.execute({\n sql: prefix == null || prefix === \"\"\n ? `DELETE FROM ${tableName}`\n : `DELETE FROM ${tableName} WHERE key LIKE :prefix || '%'`,\n args: { prefix },\n });\n return result.rowsAffected;\n}\n\n/**\n * Delete all expired keys from the cache.\n * Perfect for running on a schedule to keep the cache small and fast.\n */\nexport async function deleteExpired(): Promise {\n const result = await sqlite.execute({\n sql: `DELETE FROM ${tableName} WHERE expires_at IS NOT NULL AND expires_at <= datetime('now')`,\n args: {},\n });\n return result.rowsAffected;\n}\n\n// Export all functions as a single object to allow for easy importing\nexport const cache = {\n setup,\n get,\n set,\n setUntil,\n setExpiration,\n setExpirationUntil,\n listKeys,\n getMany,\n deleteKey,\n deleteKeys,\n deleteExpired,\n};","deleted","label",[100],"permalink","https://www.val.town/x/wizos/cache/code/main.tsx","extension","actionData","errors"]