[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_179":180,"_181":182},"routes/_app.x.$handle.$name",{"_16":17,"_20":21,"_81":64,"_82":83,"_62":-7,"_84":-5,"_13":85,"_86":87,"_11":88,"_89":90,"_91":92,"_93":-5,"_94":-5,"_95":-5,"_96":26,"_97":98,"_99":26,"_100":-5,"_101":-5,"_102":103},"routes/_app.x.$handle.$name.search.$(branch)",{"_11":12,"_13":14,"_15":-5,"_16":17},"files",[],"project",{"_18":19,"_20":21,"_22":23,"_24":-5,"_25":26,"_27":28,"_29":28,"_30":-5,"_31":-5,"_32":33,"_34":-5,"_35":26,"_36":-5,"_37":-5,"_38":39,"_40":41,"_42":-5,"_43":-5,"_44":-5,"_45":-5,"_46":47,"_48":47,"_49":50,"_51":50,"_52":50,"_53":47,"_54":47,"_55":56,"_57":58,"_59":60,"_61":26},"query","handle","Shmully","id","5e64a4a6-32c3-11f0-bd44-569c3dd06744","name","Mullbot","createdAt",["D",1747447513212],"deletedAt","legacyEnvVars",false,"privacy","public","httpPrivacy","description","imageUrl","userId","e036ffc0-26f1-11f0-a049-f3a9b7a94124","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","d03bf8cd-f815-4c06-aa3c-6ba76ff72b74","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_16":17,"_80":76},"org",{"_16":17,"_74":-5,"_75":76,"_32":33,"_77":78,"_79":26},"branch",{"_62":63,"_20":64,"_18":65,"_66":19,"_67":-5,"_68":-5,"_69":-5,"_70":-5,"_71":-5,"_72":21,"_73":17},"isOwned","version",12,"main","5e64f438-32c3-11f0-bd44-569c3dd06744","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yd1dDZkVOdUdyaXpzek42bjJyRm5vR2xuZlAifQ","tier","free","canRestrictVals","profileImageUrl","branchName","path","","adoptOrgId",{"_18":19,"_20":21,"_22":175,"_24":-5,"_25":26,"_27":28,"_29":28,"_30":-5,"_31":-5,"_32":33,"_34":-5,"_35":26,"_36":-5,"_37":-5,"_38":39,"_40":41,"_42":-5,"_43":-5,"_44":-5,"_45":-5,"_46":47,"_48":47,"_49":50,"_51":50,"_52":50,"_53":47,"_54":47,"_55":176,"_57":177,"_59":178,"_61":26},"tree",[158,159,160,161],[158,159,160,161],"counts",{"_147":39,"_148":149,"_150":39,"_151":152,"_153":154},"contents",[104,105,106,107],"file","upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_18":140,"_20":141,"_110":142,"_112":-5,"_113":65,"_114":143,"_115":116,"_22":144,"_62":118,"_119":120,"_121":145,"_123":26,"_124":-5,"_82":146},{"_18":133,"_20":134,"_110":135,"_112":-5,"_113":65,"_114":136,"_115":116,"_22":137,"_62":118,"_119":120,"_121":138,"_123":26,"_124":-5,"_82":139},{"_18":126,"_20":127,"_110":128,"_112":-5,"_113":65,"_114":129,"_115":116,"_22":130,"_62":118,"_119":120,"_121":131,"_123":26,"_124":-5,"_82":132},{"_18":108,"_20":109,"_110":111,"_112":-5,"_113":65,"_114":63,"_115":116,"_22":117,"_62":118,"_119":120,"_121":122,"_123":26,"_124":-5,"_82":125},"0d644dec-3456-11f0-8a4f-9e149126039e","viewMemories.tsx","fileId","eb887356-3455-11f0-a604-9e149126039e","parentId","branchId","branchVersion","latest",true,["D",1747620464494],2,"fileType","script","content","/**\n * View the contents of the memories table\n * @returns {Promise} Table contents\n */\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nexport async function viewMemoriesTable() {\n try {\n // Query all data from the memories table\n const result = await sqlite.execute(\n `SELECT * FROM memories ORDER BY date DESC LIMIT 100`,\n );\n\n return {\n success: true,\n count: result.rows?.length || 0,\n data: result.rows || [],\n };\n } catch (error) {\n console.error(\"Error viewing memories table:\", error);\n return {\n success: false,\n error: error.message,\n };\n }\n}\n\n// Call the function when the Val is run directly\nexport default async function() {\n return await viewMemoriesTable();\n}","deleted","label",[109],"476e19a2-3454-11f0-bd3c-9e149126039e","migrateMemoriesDB.tsx","1d4f5c44-3454-11f0-b8fc-9e149126039e",3,["D",1747619702872],"// Script to migrate the memories table in SQLite\n// Run this script manually to add new columns to the memories table\n\nexport default async function migrateMemoriesDb() {\n try {\n // Import SQLite module\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n\n // First, backup the current table contents\n const backup = await sqlite.execute(`SELECT * FROM memories`);\n console.log(\"Backup of memories table (JSON format):\");\n console.log(JSON.stringify(backup.rows, null, 2));\n\n // Create a new table with the updated schema\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS memories_new (\n id TEXT,\n date TEXT,\n text TEXT,\n createdBy TEXT,\n createdDate INTEGER,\n tags TEXT\n )\n `);\n\n // Copy data from old table to new table\n await sqlite.execute(`\n INSERT INTO memories_new (date, text)\n SELECT date, text FROM memories\n `);\n\n // Drop the old table\n await sqlite.execute(`DROP TABLE memories`);\n\n // Rename the new table to the original name\n await sqlite.execute(`ALTER TABLE memories_new RENAME TO memories`);\n\n // Create an index on id for faster lookups\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_memories_id ON memories(id)\n `);\n\n return \"Memories table migrated successfully with new columns.\";\n } catch (error) {\n console.error(\"Error migrating memories table:\", error);\n throw error;\n }\n}\n\nmigrateMemoriesDb();",[127],"b5408cc6-3454-11f0-9c6f-9e149126039e","initializeMemoriesDB.tsx","58931304-3454-11f0-b8fc-9e149126039e",6,["D",1747619887122],"/**\n * Creates a SQLite database table called 'memories' with specified columns\n * @returns {Promise} A success message\n */\nexport async function memoryTableCreator() {\n // Import the better-sqlite3 library\n // This is available in Val Town's environment\n const Database = require(\"better-sqlite3\");\n\n // Create in-memory database for testing\n // For persistence, you'd use a file path instead\n const db = new Database(\":memory:\");\n\n try {\n // Create the memories table with the specified columns\n db.exec(`\n CREATE TABLE IF NOT EXISTS memories (\n id TEXT PRIMARY KEY,\n date TEXT,\n text TEXT,\n createdBy TEXT,\n createdDate INTEGER,\n tags TEXT\n );\n `);\n\n // Optional: Insert a test record to verify functionality\n const stmt = db.prepare(`\n INSERT INTO memories (id, date, text, createdBy, createdDate, tags)\n VALUES (?, ?, ?, ?, ?, ?)\n `);\n\n const testId = \"mem_\" + Date.now().toString();\n stmt.run(\n testId,\n new Date().toISOString().split(\"T\")[0], // Current date in YYYY-MM-DD format\n \"This is a test memory\",\n \"system\",\n Date.now(),\n \"test,setup\",\n );\n\n // Verify the record was inserted\n const row = db.prepare(\"SELECT * FROM memories WHERE id = ?\").get(testId);\n\n return {\n success: true,\n message: \"Memories table created successfully!\",\n testRecord: row,\n };\n } catch (error) {\n return {\n success: false,\n message: `Error creating memories table: ${error.message}`,\n };\n } finally {\n // Close the database connection\n db.close();\n }\n}\n\n// For persistent storage in Val Town, you might want to use:\n// - val.storage to store the database file path\n// - val.storage.put/get to save/load data if SQLite isn't preferred",[134],"e503735a-3455-11f0-922e-9e149126039e","generateFunFacts.tsx","cdeaf8b0-3454-11f0-87c2-9e149126039e",9,["D",1747620396750],"import { DateTime } from \"https://esm.sh/luxon@3.4.4\";\nimport { nanoid } from \"https://esm.sh/nanoid@5.0.5\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport OpenAI from \"npm:openai@4.26.0\";\n\nconst TABLE_NAME = `memories`;\nconst TAG_NAME = \"fun_fact\";\n\n/**\n * Retrieves previously generated fun facts from the memories database\n * @returns Array of previous fun facts\n */\nasync function getPreviousFunFacts() {\n try {\n const result = await sqlite.execute(\n `SELECT date(date) as date, text FROM ${TABLE_NAME}\n WHERE tags = ?\n ORDER BY date DESC\n LIMIT 50`,\n [TAG_NAME],\n );\n\n return result.rows || [];\n } catch (error) {\n console.error(\"Error retrieving previous fun facts:\", error);\n return [];\n }\n}\n\n/**\n * Deletes existing fun facts for the specified dates\n * @param dates Array of date strings in ISO format\n */\nasync function deleteExistingFunFacts(dates) {\n try {\n for (const date of dates) {\n await sqlite.execute(\n `DELETE FROM ${TABLE_NAME}\n WHERE date = ? AND tags = ?`,\n [date, TAG_NAME],\n );\n }\n } catch (error) {\n console.error(\"Error deleting existing fun facts:\", error);\n }\n}\n\n/**\n * Inserts a fun fact into the memories database\n * @param date Date for the fun fact in ISO format\n * @param factText The fun fact text\n */\nasync function insertFunFact(date, factText) {\n try {\n await sqlite.execute(\n `INSERT INTO ${TABLE_NAME} (id, date, text, createdBy, createdDate, tags)\n VALUES (?, ?, ?, ?, ?, ?)`,\n [\n nanoid(10),\n date,\n `fun fact: ${factText}`,\n \"fun_fact_generator\",\n Date.now(),\n TAG_NAME,\n ],\n );\n } catch (error) {\n console.error(`Error inserting fun fact for ${date}:`, error);\n }\n}\n\n/**\n * Generates fun facts for the next 7 days using OpenAI API\n * @param previousFacts Previous fun facts to avoid duplication\n * @returns Array of generated fun facts\n */\nasync function generateFunFacts(previousFacts) {\n try {\n // Get API key from environment\n const apiKey = Deno.env.get(\"OPENAI_API_KEY\");\n if (!apiKey) {\n console.error(\"OpenAI API key is not configured.\");\n return null;\n }\n\n // Initialize OpenAI client\n const openai = new OpenAI({ apiKey });\n\n // Format previous facts for the prompt\n const previousFactsText = previousFacts\n .map((fact) => `- ${fact.date}: ${fact.text}`)\n .join(\"\\n\");\n\n // Get today's date in US Eastern Time\n const today = DateTime.now().setZone(\"America/New_York\").startOf(\"day\");\n\n // Hana's birthday - adjust as needed\n const hanaBirthday = \"2025-03-26\";\n const currentDate = today.toFormat(\"yyyy-MM-dd\");\n\n // Format dates for the next 7 days\n const nextSevenDays = Array.from({ length: 7 }, (_, i) => {\n const date = today.plus({ days: i });\n return date.toFormat(\"yyyy-MM-dd\");\n });\n\n const message =\n `Generate 7 unique fun facts, one for each of the next 7 days. Each fact should be brief (1-2 sentences) and relate to one of these categories:\n\n1. Infant development appropriate for Miss Hana, who was born on ${hanaBirthday} (today is ${currentDate})\n2. Cute animals: capybaras, border collies, elephants, or penguins\n3. Plants: monsteras, orchids, ficus, or other common houseplants\n\nRequirements:\n- Each fact must be interesting, educational, and appropriate for formal communication\n- Keep each fact to 1-2 sentences maximum\n- Use different categories across the 7 days for variety\n- Ensure facts are scientifically accurate\n- Make infant development facts age-appropriate for Miss Hana based on her birthdate\n- Do not repeat any previous facts from this list:\n\n${previousFactsText}\n\nFORMAT YOUR RESPONSE AS STRUCTURED JSON INSIDE XML TAGS:\n\n[\n {\n \"date\": \"YYYY-MM-DD\",\n \"text\": \"The fun fact text here\",\n \"category\": \"infant\" | \"animal\" | \"plant\"\n },\n ... (repeat for all 7 days)\n]\n\n\nUse these dates for the 7 facts:\n${nextSevenDays.join(\"\\n\")}`;\n\n console.log({ message });\n\n // Call OpenAI API\n const response = await openai.chat.completions.create({\n model: \"gpt-4-turbo-preview\", // You can adjust the model as needed\n messages: [\n {\n role: \"system\",\n content: \"You are a helpful assistant that generates educational fun facts.\",\n },\n {\n role: \"user\",\n content: message,\n },\n ],\n max_tokens: 1000,\n });\n\n // Extract the response text\n const responseText = response.choices[0].message.content.trim();\n\n // Extract JSON between tags\n const factsMatch = responseText.match(/([\\s\\S]*?)<\\/facts>/);\n\n if (!factsMatch || factsMatch.length < 2) {\n console.error(\"Failed to parse facts from response:\", responseText);\n return [];\n }\n\n try {\n // Parse the JSON from the extracted content\n const factData = JSON.parse(factsMatch[1]);\n\n // Validate and format facts\n const facts = factData.map((fact) => ({\n date: fact.date,\n text: fact.text,\n category: fact.category,\n }));\n\n return facts;\n } catch (parseError) {\n console.error(\"Failed to parse facts JSON:\", parseError);\n console.log(\"Raw response:\", responseText);\n\n // Fallback to regex parsing if JSON parsing fails\n return parseFallbackFacts(responseText, nextSevenDays);\n }\n } catch (error) {\n console.error(\"Error generating fun facts:\", error);\n return [];\n }\n}\n\n/**\n * Fallback parser for when JSON parsing fails\n * @param responseText The raw response text from OpenAI\n * @param expectedDates Array of expected dates for facts\n * @returns Array of parsed facts\n */\nfunction parseFallbackFacts(responseText, expectedDates) {\n // Try to extract facts using regex\n const factPattern = /(\\d{4}-\\d{2}-\\d{2})[\"']?[,:]?\\s*[\"']?(.*?)[\"']?[,}]/gs;\n const facts = [];\n let match;\n\n while ((match = factPattern.exec(responseText)) !== null) {\n if (match.length >= 3) {\n facts.push({\n date: match[1],\n text: match[2].trim(),\n });\n }\n }\n\n // If we couldn't extract any facts, try another approach\n if (facts.length === 0) {\n // Look for quoted text that might be facts\n const lines = responseText.split(\"\\n\");\n let currentDate = null;\n\n for (let i = 0; i < lines.length; i++) {\n const line = lines[i].trim();\n\n // Check if this line contains a date\n const dateMatch = line.match(/(\\d{4}-\\d{2}-\\d{2})/);\n if (dateMatch) {\n currentDate = dateMatch[1];\n } else if (currentDate && line.length > 10) {\n // If we have a date and this is a non-empty line, treat it as a fact\n facts.push({\n date: currentDate,\n text: line.replace(/[\"']/g, \"\").trim(),\n });\n currentDate = null;\n }\n }\n }\n\n // As a last resort, assign facts to dates in order\n if (facts.length === 0 && expectedDates.length > 0) {\n // Extract any sentences that look like facts\n const sentences = responseText.match(/[^.!?]+[.!?]+/g) || [];\n\n for (let i = 0; i < Math.min(sentences.length, expectedDates.length); i++) {\n let factText = sentences[i].trim();\n\n // Clean up the fact text\n factText = factText.replace(/[\"']/g, \"\").trim();\n\n if (factText.length > 10) {\n facts.push({\n date: expectedDates[i],\n text: factText,\n });\n }\n }\n }\n\n return facts;\n}\n\n/**\n * Main function to generate and store fun facts for the next 7 days\n */\nexport async function generateAndStoreFunFacts() {\n try {\n // Get previous fun facts\n const previousFacts = await getPreviousFunFacts();\n\n // Generate new fun facts\n const newFacts = await generateFunFacts(previousFacts);\n\n if (!newFacts || newFacts.length === 0) {\n console.error(\"Failed to generate fun facts\");\n return \"Failed to generate fun facts\";\n }\n\n // Get dates for the next 7 days\n const today = DateTime.now().setZone(\"America/New_York\").startOf(\"day\");\n const nextSevenDays = Array.from({ length: 7 }, (_, i) => {\n return today.plus({ days: i }).toFormat(\"yyyy-MM-dd\");\n });\n\n // Delete existing fun facts for these dates\n await deleteExistingFunFacts(nextSevenDays);\n\n // Insert new fun facts\n for (const fact of newFacts) {\n await insertFunFact(fact.date, fact.text);\n }\n\n console.log(`Generated and stored ${newFacts.length} fun facts`);\n return `Generated and stored ${newFacts.length} fun facts`;\n } catch (error) {\n console.error(\"Error in generateAndStoreFunFacts:\", error);\n return \"Error generating fun facts\";\n }\n}\n\n/**\n * Cron job entry point - runs weekly to generate fun facts for the next 7 days\n * Intended to be used as a Val Town cron job\n */\nexport default async function() {\n console.log(\"Running fun facts generation cron job...\");\n return await generateAndStoreFunFacts();\n}\n\n// For testing with Deno directly\nif (import.meta.main) {\n await generateAndStoreFunFacts();\n}",[141],"pulls","branches",1,"forks","envVars",{"_155":39,"_157":39},"connections",{"_155":39,"_156":39},"count","unfilledCount","emptyCount",{"_18":140,"_20":141,"_110":142,"_112":-5,"_113":65,"_114":143,"_115":116,"_22":172,"_62":118,"_119":120,"_121":145,"_123":26,"_124":-5,"_163":173,"_82":174},{"_18":133,"_20":134,"_110":135,"_112":-5,"_113":65,"_114":136,"_115":116,"_22":169,"_62":118,"_119":120,"_121":138,"_123":26,"_124":-5,"_163":170,"_82":171},{"_18":126,"_20":127,"_110":128,"_112":-5,"_113":65,"_114":129,"_115":116,"_22":166,"_62":118,"_119":120,"_121":131,"_123":26,"_124":-5,"_163":167,"_82":168},{"_18":108,"_20":109,"_110":111,"_112":-5,"_113":65,"_114":63,"_115":116,"_22":162,"_62":118,"_119":120,"_121":122,"_123":26,"_124":-5,"_163":164,"_82":165},["D",1747620464494],"children",[],[109],["D",1747619702872],[],[127],["D",1747619887122],[],[134],["D",1747620396750],[],[141],["D",1747447513212],{"_16":17,"_80":76},{"_16":17,"_74":-5,"_75":76,"_32":33,"_77":78,"_79":26},{"_62":63,"_20":64,"_18":65,"_66":19,"_67":-5,"_68":-5,"_69":-5,"_70":-5,"_71":-5,"_72":21,"_73":17},"ctx",{"_55":-5,"_101":212,"_213":214,"_215":216,"_217":26,"_218":26,"_219":26,"_220":116,"_221":-5,"_222":-7,"_223":-7,"_224":39,"_225":26,"_226":26,"_227":-5,"_228":26,"_229":26,"_230":26,"_231":-5},"ENV",{"_183":184,"_185":186,"_187":64,"_188":189,"_190":191,"_192":193,"_194":195,"_196":197,"_198":199,"_200":201,"_202":203,"_204":205,"_206":207,"_208":209,"_210":211},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","71c1b20804b3232a7e513be260cfffc1932a9e97","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",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Search