[{"_1":2,"_255":-5,"_256":-5},"loaderData",{"_3":4,"_92":93,"_183":184,"_254":-5},"root",{"_5":6,"_33":34,"_59":60,"_90":91},"ctx",{"_7":8,"_18":19,"_20":-5,"_21":22,"_23":24,"_25":26,"_27":26,"_28":26,"_29":30,"_31":32},"auth",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5},"sessionClaims","sessionId","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","environmentVariableKeys",[],"user","preferences_keybindings","default","preferences_theme","light","preferences_fixers",false,"preferences_copilot","preferences_selection_ai","preferences_model","claude-3-5-haiku-20241022","notification_count",0,"ENV",{"_35":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":50,"_51":52,"_53":54,"_55":56,"_57":58},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","2a24f0e9a29edb6ad45b57955e0c4d44af901bda","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","API_URL","https://api.val.town","WORKER_FINGERPRINT","c7de7de11d2fa3884730f0fa9fd384f8","clerkState",{"_61":62},"__internal_clerk_state",{"_63":64,"_65":44,"_66":67,"_68":67,"_69":26,"_70":67,"_71":67,"_72":67,"_73":67,"_74":67,"_75":67,"_76":67,"_77":67,"_78":79,"_88":26,"_89":26},"__clerk_ssr_state",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__signInForceRedirectUrl","__signUpForceRedirectUrl","__signInFallbackRedirectUrl","__signUpFallbackRedirectUrl","__clerk_debug",{"_80":26,"_81":67,"_82":83,"_84":67,"_85":44,"_86":26,"_87":67},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","remixVersion",2,"routes/_app.v.$handle.$name",{"_94":95,"_96":97,"_95":98,"_178":-5,"_179":-5,"_180":181,"_131":132,"_158":159,"_101":102,"_99":100,"_119":-7,"_51":52,"_182":26},"type","val","author","28170570-fe79-11ef-b764-53a9d87883d1",{"_99":100,"_96":97,"_101":102,"_103":-5,"_104":-5,"_105":106,"_107":108,"_109":110,"_111":112,"_113":26,"_114":112,"_115":116,"_117":118,"_119":120,"_121":26,"_122":123,"_124":32,"_125":32,"_126":123,"_127":32,"_128":32,"_129":-5,"_20":130,"_135":136,"_110":142,"_156":157,"_158":159,"_160":161},"name","twitterAlert","valNameId","3ecb31ec-fe7e-11ef-bc6c-569c3dd06744","parentFolderId","isOwned","privacy","public","readme","# Twitter/𝕏 Keyword Alerts [TEMPLATE]\n\nGet custom notifications when you, your company, or anything you care about is mentioned on Twitter/X, even if they don't tag you directly.\n\nThis template will help you:\n1. Search for specific mentions on Twitter/X using customizable keywords.\n2. Deliver notifications wherever you'd like (email, Discord, Slack, Telegram, etc).\n\n## Example\nThis val tracks mentions of \"Val Town\" and related terms, excluding noise like retweets and irrelevant accounts. Notifications are sent to a Discord webhook but can be easily reconfigured for other platforms.\n

\nTo see exactly how we use this template at Val Town: https://www.val.town/v/stevekrouse/twitterAlert\n\n## Set Up\n\n### 1. Fork this Val\nTo use this template, fork this val on the top right corner of this page.\n![Screenshot 2025-01-10 at 1.22.10 PM.png](https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/c4ae349d-7e28-4378-8646-21c8958e1f00/public)\n\n### 2. View Source Code\nThe `CODE` box shows you the the full source code of this val, you may need to scroll down to see it.\n![image.png](https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/6a4dabb4-3b27-4cea-fce3-95a1a1c3cd00/public)\n\n### 3. Customize Query\nDefine what you want to search for by modifying `query`:\n\n```ts\nconst query = \"\\\"val.town\\\" OR \\\"val.run\\\" OR \\\"val town\\\" -_ValTown_ -is:retweet -from:valenzuelacity -from:val__run\";\n```\n\nRefer to [Twitter's search operators](https://socialdata.gitbook.io/docs/twitter-tweets/retrieve-search-results-by-keyword#endpoint-parameters) to fine-tune your query.\n\n### 4. Test API call\nSet `isProd = false` in the code if you are testing, to ensure there are enough tweets to display.
\nToggle it back to `true` when you're ready to run this cron job in production and actuall send notifications.\n\n### 5. Choose Notification Method\n\nThis template uses a Discord webhook for notifications, but \nyou can update this to your preferred platform by replacing the `discordWebhook` call \nwith a call to [Slack](https://docs.val.town/integrations/slack/send-messages-to-slack/), [`@std/email`](https://docs.val.town/std/email/), etc.\n\n**Create a Discord webhook following [this guide](https://support.discord.com/hc/en-us/articles/228383668-Intro-to-Webhooks).**\n\nSave your Discord Webhook URL in your [Val Town environment variables](https://www.val.town/settings/environment-variables):\n- Key: `mentionsDiscord`\n- Value: Your Discord webhook URL.\nNotifications will be sent using this function:\n\n```ts\nawait discordWebhook({\n url: Deno.env.get(\"mentionsDiscord\"),\n content,\n});\n```\n\n\n#### 🎉 Congrats! You now have a val running that ensures you never miss another Twitter/X mention. 🎉\n\n\n### NOTE: Usage Limits\nThis val uses the SocialData API for Twitter data:\n\n- **Proxies via Val Town's [SocialDataProxy](https://www.val.town/v/stevekrouse/socialDataProxy)**: Limited to 10 cents per day for [**Val Town Pro users**](https://www.val.town/pricing). This API is *only* for Pro users.\n- **Need more calls?** Sign up for your own [SocialData API token](https://socialdata.tools) and configure the [`socialDataSearch`](https://www.val.town/v/stevekrouse/socialDataSearch) function.","valType","interval","currentVersion","a98a0940-fe7e-11ef-9de5-569c3dd06744","legacyPrivate","id","code","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\n\nfunction App() {\n const [balance, setBalance] = useState(0);\n const [clickCount, setClickCount] = useState(0);\n\n useEffect(() => {\n // Fetch initial balance when component loads\n fetch('/balance')\n .then(response => response.json())\n .then(data => setBalance(data.balance));\n }, []);\n\n const handleClick = async () => {\n try {\n const response = await fetch('/earn', { method: 'POST' });\n const data = await response.json();\n setBalance(data.balance);\n setClickCount(prev => prev + 1);\n } catch (error) {\n console.error('Error earning money:', error);\n }\n };\n\n return (\n

💰 Money Clicker Game 💰

Current Balance: ${balance.toFixed(2)}

Clicks: {clickCount}

\n \n

\n\n

📱 Download the App

\n \n 🍎 iOS App Store\n \n \n 🤖 Google Play\n \n

\n\n

\n \n View Source\n \n

\n );\n}\n\nfunction client() {\n createRoot(document.getElementById(\"root\")).render();\n}\nif (typeof document !== \"undefined\") { client(); }\n\nexport default async function server(request: Request): Promise {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n const KEY = new URL(import.meta.url).pathname.split(\"/\").at(-1);\n const SCHEMA_VERSION = 1;\n\n // Create table for tracking user earnings\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_earnings_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n total_balance REAL DEFAULT 0,\n total_clicks INTEGER DEFAULT 0\n )\n `);\n\n // Ensure at least one row exists\n await sqlite.execute(`\n INSERT OR IGNORE INTO ${KEY}_earnings_${SCHEMA_VERSION} (total_balance, total_clicks) \n VALUES (0, 0)\n `);\n\n // Handle different routes\n if (request.method === 'GET' && new URL(request.url).pathname === '/balance') {\n const result = await sqlite.execute(`\n SELECT total_balance FROM ${KEY}_earnings_${SCHEMA_VERSION} LIMIT 1\n `);\n return new Response(JSON.stringify({ \n balance: result.rows[0].total_balance \n }), { \n headers: { 'Content-Type': 'application/json' } \n });\n }\n\n if (request.method === 'POST' && new URL(request.url).pathname === '/earn') {\n // Simulate earning money with some randomness\n const earnAmount = Math.random() * 0.50; // Earn between $0 and $0.50 per click\n\n await sqlite.execute(`\n UPDATE ${KEY}_earnings_${SCHEMA_VERSION} \n SET total_balance = total_balance + ?, \n total_clicks = total_clicks + 1\n `, [earnAmount]);\n\n const result = await sqlite.execute(`\n SELECT total_balance FROM ${KEY}_earnings_${SCHEMA_VERSION} LIMIT 1\n `);\n\n return new Response(JSON.stringify({ \n balance: result.rows[0].total_balance,\n earned: earnAmount \n }), { \n headers: { 'Content-Type': 'application/json' } \n });\n }\n\n // Render the main page\n return new Response(`\n \n \n Money Clicker Game\n \n \n \n

\n \n \n \n \n `, {\n headers: { 'Content-Type': 'text/html' }\n });\n}","createdAt",["D",1741700543534],"version",4,"currentUserHasLiked","likeCount",1,"forkCount","referenceCount","dependencyCount","commentCount","prCount","mergedPr",{"_131":132,"_133":134},"handle","Akash11","profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ1QWo3Y2k0R1dtZnVZa3ZnYVZ6YWdrRkFwayJ9","forkedVal",{"_114":137,"_131":138,"_99":139,"_119":140,"_141":-5},"0f6b3876-d295-11ef-b222-e6cdfca9ef9f","valdottown","templateTwitterAlert",11,"prDisabledHint",{"_96":97,"_143":38,"_101":102,"_144":-5,"_145":146,"_147":148,"_149":150,"_151":152,"_153":154,"_94":149,"_155":67},"runtime","clearedAt","nextRunAt",["D",1741808524461],"unit","minute","delay",1200000,"registeredAt",["D",1741700364545],"lastRunAt",["D",1741807324461],"cron","slug","Akash11/twitterAlert","description","Twitter/𝕏 Keyword Alerts [TEMPLATE] Get custom notifications when you, your company, or anything you care about is mentioned on Twitter/X, even if they don't tag you directly. This template will help you: Search for specific mentions on Twitter/X using customizable keywords. Deliver notifications wherever you'd like (email, Discord, Slack, Telegram, etc). Example This val tracks mentions of \"Val Town\" and related terms, excluding noise like retweets and irrelevant accounts. Notifications are sent to a Discord webhook but can be easily reconfigured for other platforms.\n \nTo see exactly how we use this template at Val Town: https://www.val.town/v/stevekrouse/twitterAlert Set Up 1. Fork this Val To use this template, fork this val on the top right corner of this page.\n 2. View Source Code The CODE box shows you the the full source code of this val, you may need to scroll down to see it. \n 3. Customize Query Define what you want to search for by modifying query : const query = \"\\\"val.town\\\" OR \\\"val.run\\\" OR \\\"val town\\\" -_ValTown_ -is:retweet -from:valenzuelacity -from:val__run\"; Refer to Twitter's search operators to fine-tune your query. 4. Test API call Set isProd = false in the code if you are testing, to ensure there are enough tweets to display. \nToggle it back to true when you're ready to run this cron job in production and actuall send notifications. 5. Choose Notification Method This template uses a Discord webhook for notifications, but\nyou can update this to your preferred platform by replacing the discordWebhook call\nwith a call to Slack , @std/email , etc. Create a Discord webhook following this guide . Save your Discord Webhook URL in your Val Town environment variables : Key: mentionsDiscord Value: Your Discord webhook URL.\nNotifications will be sent using this function: await discordWebhook({\n url: Deno.env.get(\"mentionsDiscord\"),\n content,\n}); 🎉 Congrats! You now have a val running that ensures you never miss another Twitter/X mention. 🎉 NOTE: Usage Limits This val uses the SocialData API for Twitter data: Proxies via Val Town's SocialDataProxy : Limited to 10 cents per day for Val Town Pro users . This API is only for Pro users. Need more calls? Sign up for your own SocialData API token and configure the socialDataSearch function.","versions",[162,165,169,172,175],{"_119":120,"_163":-5,"_117":164,"_114":112},"prId",["D",1741700543534],{"_119":166,"_163":-5,"_117":167,"_114":168},3,["D",1741700520861],"9c0602d8-fe7e-11ef-a3ad-569c3dd06744",{"_119":91,"_163":-5,"_117":170,"_114":171},["D",1741700502719],"91375e88-fe7e-11ef-9de5-569c3dd06744",{"_119":123,"_163":-5,"_117":173,"_114":174},["D",1741700436931],"6a011336-fe7e-11ef-809f-569c3dd06744",{"_119":32,"_163":-5,"_117":176,"_114":177},["D",1741700364453],"3ecf061e-fe7e-11ef-bc6c-569c3dd06744","recentThread","breadcrumbs","comments",[],"isOwner","routes/_app.v.$handle.$name.dependencies",{"_185":186,"_250":123,"_251":157,"_252":32,"_95":253},"dependenciesList",[187],{"_101":188,"_189":190},"08f95904-3584-11ef-8995-0e10024e3b32","initialData",{"_99":191,"_96":192,"_101":188,"_103":193,"_104":-5,"_105":106,"_107":194,"_109":195,"_111":196,"_113":26,"_114":196,"_115":197,"_117":198,"_119":199,"_121":26,"_122":140,"_125":200,"_126":123,"_127":123,"_124":201,"_128":32,"_129":-5,"_20":202,"_135":205,"_110":-7,"_158":209,"_210":-5,"_156":211,"_160":212},"sqlite","a0bf3b31-15a5-4d5c-880e-4b1e22c9bc18","76a8911e-393e-11ef-8e71-de64eea55b61","# LLM-Safe Fork of @std/sqlite\n\nWe found that LLMs have trouble with the inputs and outputs of our @std/sqlite method.\n\n1. It expects the input to be `(sql: string, args: any[])` but it's `{ sql: string, args: any[] }`\n2. It expects the output to be objects, but they are arrays\n\nInstead of struggling to teach it, we built this val to be a wrapper around @std/sqlite that adheres to what the LLMs expect. \n\nThis val is also backwards-compatible with @std/sqlite, so we're considering merging it in.","script","5631f2d0-dcb9-11ef-80ec-e6cdfca9ef9f","import { API_URL } from \"https://esm.town/v/std/API_URL\";\nimport { LibsqlError, type ResultSet, type Row, type TransactionMode } from \"npm:@libsql/client\";\nimport { z } from \"npm:zod\";\n\n/**\n * Every Val Town account comes with its own private\n * [SQLite database](https://www.sqlite.org/) that\n * is accessible from any of your vals.\n * ([Docs ↗](https://docs.val.town/std/sqlite))\n */\nexport const sqlite = {\n /**\n * Executes a SQLite statement.\n *\n * @param {InStatement} statement - The SQLite statement to execute.\n * @example String query:\n * `sqlite.execute(\"SELECT 1;\")`\n * @example Query with arguments:\n * `sqlite.execute({sql: \"SELECT * from books WHERE year > ?;\", args: [2020]})`\n */\n execute,\n\n /**\n * Executes a batch of SQLite statements.\n *\n * @param {InStatement[]} statements - An array of SQLite statements to execute.\n * @param {TransactionMode} [mode] - The transaction mode for the batch execution.\n */\n batch,\n};\n\n// ------------\n// Functions\n// ------------\n\nasync function execute(statement: InStatement, args?: InArgs): Promise {\n const res = await fetch(`${API_URL}/v1/sqlite/execute`, {\n method: \"POST\",\n headers: {\n Authorization: `Bearer ${Deno.env.get(\"valtown\")}`,\n },\n body: JSON.stringify({ statement: normalizeStatement(statement, args) }),\n });\n if (!res.ok) {\n throw createResError(await res.text());\n }\n const resultSet = await res.json();\n return upgradeResultSet(resultSet);\n}\n\nasync function batch(statements: InStatement[], mode?: TransactionMode): Promise {\n if (mode && ![\"write\", \"read\", \"deferred\"].includes(mode)) {\n throw new Error(\"Invalid transaction mode provided to sqlite.batch. Must be 'write', 'read', or 'deferred.\");\n }\n const res = await fetch(`${API_URL}/v1/sqlite/batch`, {\n method: \"POST\",\n headers: {\n Authorization: `Bearer ${Deno.env.get(\"valtown\")}`,\n },\n body: JSON.stringify({ statements: statements.map(s => normalizeStatement(s)), mode }),\n });\n if (!res.ok) {\n throw createResError(await res.text());\n }\n const resultSets = await res.json();\n return resultSets.map(upgradeResultSet);\n}\n\nfunction createResError(body: string) {\n try {\n const e = zLibsqlError.parse(JSON.parse(body));\n // e.message already contains the code, and LibsqlError adds the\n // code to the beginning, so we remove it here\n const msg = e.message.replace(e.code, \"\").replace(/^:\\s+/, \"\");\n return new LibsqlError(msg, e.code, e.rawCode);\n } catch (_) {\n // Failed to parse libsql error\n }\n return new Error(body);\n}\n\n/* Val Town's Turso Proxy returns rows as an array of values\n * Yet the LibSQL API has a Row type which behave as an array or object,\n * ie you can access it via numerical index or string\n */\ninterface ImpoverishedResultSet extends ResultSet {\n rows: any[];\n}\n\nfunction normalizeStatement(statement: InStatement, args?: InArgs) {\n if (Array.isArray(statement)) {\n // for the case of an array of arrays\n return normalizeStatement(statement[0], statement[1]);\n }\n if (typeof statement === \"string\") {\n if (args) {\n return { sql: statement, args };\n } else return statement;\n }\n else if (typeof statement === \"object\") {\n if (statement.args) {\n return statement;\n }\n if (args) {\n return { sql: statement.sql, args };\n }\n return statement.sql;\n }\n else throw new Error(\"Error normalizing sql input\");\n}\n\nfunction upgradeResultSet(results: ImpoverishedResultSet): ResultSet {\n return {\n ...results,\n rows: results.rows.map(row => rowFromSql(row, results.columns)),\n };\n}\n\n// adapted from\n// https://github.com/tursodatabase/libsql-client-ts/blob/17dd996b840c950dd22b871adfe4ba0eb4a5ead3/packages/libsql-client/src/sqlite3.ts#L314C1-L337C2\nfunction rowFromSql(\n sqlRow: Array,\n columns: Array,\n): Row {\n const row = {};\n // make sure that the \"length\" property is not enumerable\n Object.defineProperty(row, \"length\", { value: sqlRow.length });\n for (let i = 0; i < sqlRow.length; ++i) {\n const value = sqlRow[i];\n Object.defineProperty(row, i, { value });\n\n const column = columns[i];\n if (!Object.hasOwn(row, column)) {\n Object.defineProperty(row, column, {\n value,\n enumerable: true,\n configurable: true,\n writable: true,\n });\n }\n }\n return row as Row;\n}\n\n// ------------\n// Helpers\n// ------------\n\nconst zLibsqlError = z.object({\n message: z.string(),\n code: z.string(),\n rawCode: z.number().optional(),\n});\n\n// We patch these types to only support JSON values\nexport type InValue = null | string | number | boolean;\nexport type InArgs = Array | Record;\nexport type InStatement = {\n /**\n * The SQL statement to execute.\n */\n sql: string;\n\n /**\n * The arguments to bind to the SQL statement.\n */\n args: InArgs;\n} | string;",["D",1737987404484],13,16191,21,{"_131":203,"_133":204},"stevekrouse","https://images.clerk.dev/uploaded/img_2PqHa2Gsy93xQrjh2w78Xu0cChW.jpeg",{"_114":206,"_131":207,"_99":191,"_119":208,"_141":-5},"56c849ee-f1f8-11ee-9b87-cab58f78796a","std",6,"LLM-Safe Fork of @std/sqlite We found that LLMs have trouble with the inputs and outputs of our @std/sqlite method. It expects the input to be (sql: string, args: any[]) but it's { sql: string, args: any[] } It expects the output to be objects, but they are arrays Instead of struggling to teach it, we built this val to be a wrapper around @std/sqlite that adheres to what the LLMs expect. This val is also backwards-compatible with @std/sqlite, so we're considering merging it in.","latestEvaluation","stevekrouse/sqlite",[213,217,221,224,228,232,236,240,243,247],{"_117":214,"_119":199,"_215":216},["D",1737987404484],"n","1",{"_117":218,"_119":219,"_215":220},["D",1724087412304],12,"2",{"_117":222,"_119":140,"_215":223},["D",1724087404512],"3",{"_117":225,"_119":226,"_215":227},["D",1723494410142],10,"4",{"_117":229,"_119":230,"_215":231},["D",1723494389876],9,"5",{"_117":233,"_119":234,"_215":235},["D",1723494345363],8,"6",{"_117":237,"_119":238,"_215":239},["D",1723494323065],7,"7",{"_117":241,"_119":208,"_215":242},["D",1719604370206],"8",{"_117":244,"_119":245,"_215":246},["D",1719604260994],5,"9",{"_117":248,"_119":120,"_215":249},["D",1719604144103],"10","dependenciesCount","valname","page",{"_114":112,"_99":100,"_131":132,"_11":97,"_119":120,"_101":102,"_115":116,"_105":106,"_113":26,"_156":157},"routes/_app","actionData","errors"]