Val Town Code SearchReturn to Val Town

36 * Store a chat message in the database
37 */
38export async function storeChatMessage(
39  chatId,
40  senderId,
69 * Retrieve chat history for a specific chat
70 */
71export async function getChatHistory(chatId, limit = 50) {
72  try {
73    const { sqlite } = await import("https://esm.town/v/stevekrouse/sqlite");
94 * Format chat history for Anthropic API
95 */
96function formatChatHistoryForAI(history) {
97  const messages = [];
98
118 * Analyze a Telegram message and extract memories from it
119 */
120async function analyzeMessageContent(
121  anthropic,
122  username,
499
500// Handle webhook requests
501export default async function (req: Request): Promise<Response> {
502  // Set webhook if it is not set yet
503  if (!isEndpointSet) {

8const TABLE_NAME = `memories`;
9
10function summarizeWeather(weather: WeatherResponse) {
11  const summarizeDay = (day: WeatherResponse["weather"][number]) => ({
12    date: day.date,
25}
26
27async function generateConciseWeatherSummary(weatherDay) {
28  try {
29    // Get API key from environment
83}
84
85async function deleteExistingForecast(date: string) {
86  await sqlite.execute(
87    `
93}
94
95async function insertForecast(date: string, forecast: string) {
96  const { nanoid } = await import("https://esm.sh/nanoid@5.0.5");
97
112}
113
114export default async function getWeatherForecast(interval: number) {
115  const weather = await getWeather("Washington, DC");
116  console.log({ weather });

6const LOCAL_TIMEZONE = "America/New_York";
7
8async function deleteExistingCalendarEvents() {
9  await sqlite.execute(
10    `
15}
16
17// Helper function to extract time from ISO string without timezone conversion
18function extractTimeFromISO(isoString) {
19  // Match the time portion of the ISO string
20  const timeMatch = isoString.match(/T(\d{2}):(\d{2}):/);
31}
32
33function formatEventToNaturalLanguage(event) {
34  const summary = event.summary || "Untitled event";
35
83}
84
85async function insertCalendarEvent(date, eventText) {
86  const { nanoid } = await import("https://esm.sh/nanoid@5.0.5");
87
97}
98
99export default async function getCalendarEvents() {
100  try {
101    const events = await getEvents(

11 * @returns Array of previous fun facts
12 */
13async function getPreviousFunFacts() {
14  try {
15    const result = await sqlite.execute(
32 * @param dates Array of date strings in ISO format
33 */
34async function deleteExistingFunFacts(dates) {
35  try {
36    for (const date of dates) {
51 * @param factText The fun fact text
52 */
53async function insertFunFact(date, factText) {
54  try {
55    await sqlite.execute(
75 * @returns Array of generated fun facts
76 */
77async function generateFunFacts(previousFacts) {
78  try {
79    // Get API key from environment
197 * @returns Array of parsed facts
198 */
199function parseFallbackFacts(responseText, expectedDates) {
200  // Try to extract facts using regex
201  const factPattern = /(\d{4}-\d{2}-\d{2})["']?[,:]?\s*["']?(.*?)["']?[,}]/gs;
260
261/**
262 * Main function to generate and store fun facts for the next 7 days
263 */
264export async function generateAndStoreFunFacts() {
265  try {
266    // Get previous fun facts
301 * Intended to be used as a Val Town cron job
302 */
303export default async function() {
304  console.log("Running fun facts generation cron job...");
305  return await generateAndStoreFunFacts();

8### 1. Script Vals
9
10- Basic JavaScript/TypeScript functions
11- Can be imported by other vals
12- Example structure:
13
14```typescript
15export function myFunction() {
16  // Your code here
17}
25
26```typescript
27export default async function (req: Request) {
28  return new Response("Hello World");
29}
37
38```typescript
39export default async function () {
40  // Scheduled task code
41}
49
50```typescript
51export default async function (email: Email) {
52  // Process email
53}
57
58- Ask clarifying questions when requirements are ambiguous
59- Provide complete, functional solutions rather than skeleton implementations
60- Test your logic against edge cases before presenting the final solution
61- Ensure all code follows Val Town's specific platform requirements
70- **Never bake in secrets into the code** - always use environment variables
71- Include comments explaining complex logic (avoid commenting obvious operations)
72- Follow modern ES6+ conventions and functional programming practices if possible
73
74## Val Town Standard Libraries
75
76Val Town provides several hosted services and utility functions.
77
78### Blob Storage
124```
125
126## Val Town Utility Functions
127
128Val Town provides several utility functions to help with common project tasks.
129
130### Importing Utilities
176      {
177        name: "should add numbers correctly",
178        function: () => {
179          expect(1 + 1).toBe(2);
180        },
210│   ├── database/
211│   │   ├── migrations.ts    # Schema definitions
212│   │   ├── queries.ts       # DB query functions
213│   │   └── README.md
214│   ├── index.ts             # Main entry point
226└── shared/
227    ├── README.md
228    └── utils.ts             # Shared types and functions
229```
230
232- Hono is the recommended API framework (similar to Express, Flask, or Sinatra)
233- Main entry point should be `backend/index.ts`
234- **Static asset serving:** Use the utility functions to read and serve project files:
235  ```ts
236  // Use the serveFile utility to handle content types automatically
273- Run migrations on startup or comment out for performance
274- Change table names when modifying schemas rather than altering
275- Export clear query functions with proper TypeScript typing
276- Follow the queries and migrations pattern from the example
277

1import { sendDailyBriefing } from "./sendDailyBrief.ts";
2
3export async function cronDailyBrief() {
4  try {
5    const chatId = Deno.env.get("TELEGRAM_CHAT_ID");

62};
63
64export function App() {
65  const [memories, setMemories] = useState<Memory[]>([]);
66  const [loading, setLoading] = useState(true);
139      const data = await response.json();
140
141      // Change the sorting function to show memories in chronological order
142      const sortedMemories = [...data].sort((a, b) => {
143        const dateA = a.createdDate || 0;

31
32// ------------
33// Functions
34// ------------
35
36async function execute(statement: InStatement, args?: InArgs): Promise<ResultSet> {
37  const res = await fetch(`${API_URL}/v1/sqlite/execute`, {
38    method: "POST",
49}
50
51async function batch(statements: InStatement[], mode?: TransactionMode): Promise<ResultSet[]> {
52  if (mode && !["write", "read", "deferred"].includes(mode)) {
53    throw new Error("Invalid transaction mode provided to sqlite.batch. Must be 'write', 'read', or 'deferred.");
67}
68
69function createResError(body: string) {
70  try {
71    const e = zLibsqlError.parse(JSON.parse(body));
88}
89
90function normalizeStatement(statement: InStatement, args?: InArgs) {
91  if (Array.isArray(statement)) {
92    // for the case of an array of arrays
110}
111
112function upgradeResultSet(results: ImpoverishedResultSet): ResultSet {
113  return {
114    ...results,
119// adapted from
120// https://github.com/tursodatabase/libsql-client-ts/blob/17dd996b840c950dd22b871adfe4ba0eb4a5ead3/packages/libsql-client/src/sqlite3.ts#L314C1-L337C2
121function rowFromSql(
122  sqlRow: Array<unknown>,
123  columns: Array<string>,

1import { google } from "npm:googleapis@118";
2
3export default async function() {
4  const clientId = Deno.env.get("GOOGLE_CLIENT_ID")!;
5  const clientSecret = Deno.env.get("GOOGLE_CLIENT_SECRET")!;

1export function handler(request: Request) {
2  return Response.json({ ok: true });
3}