Val Town Code SearchReturn to Val Town

5
6// Create the memories_demo table
7async function createMemoriesDemoTable() {
8  try {
9    await sqlite.execute(`
25
26// Create a fake memory with proper ID and timestamps
27function createMemory(date, text, createdBy, tags, createdDateOffset = 0) {
28  const id = nanoid(10);
29  // Base date is April 5, 2025
375
376// Insert memories into the database
377async function insertDemoMemories() {
378  try {
379    // Clear existing data if any
406}
407
408// Main function to populate demo data
409export default async function populateDemo() {
410  try {
411    // Create the table

4import { DateTime } from "https://esm.sh/luxon@3.4.4";
5
6export async function testDailyBrief() {
7  try {
8    const testChatId = Deno.env.get("TEST_TELEGRAM_CHAT_ID");

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

13} from "../memoryUtils.ts";
14
15async function generateBriefingContent(anthropic, memories, today, isSunday) {
16  try {
17    const weekdaysHelp = generateWeekDays(today);
96}
97
98export async function sendDailyBriefing(chatId?: string, today?: DateTime) {
99  // Get API keys from environment
100  const apiKey = Deno.env.get("ANTHROPIC_API_KEY");
135  const lastSunday = today.startOf("week").minus({ days: 1 });
136
137  // Fetch relevant memories using the utility function
138  const memories = await getRelevantMemories();
139
216}
217
218function generateWeekDays(today) {
219  let output = [];
220
239// console.log(weekDays);
240
241// Export a function that calls sendDailyBriefing with no parameters
242// This maintains backward compatibility with existing cron jobs
243export default async function (overrideToday?: DateTime) {
244  return await sendDailyBriefing(undefined, overrideToday);
245}

2// Run this script manually to set createdBy based on memory content
3
4export default async function populateCreatedBy() {
5  try {
6    // Import SQLite module

2// Run this script manually to create the database table
3
4export default async function setupTelegramChatDb() {
5  try {
6    // Import SQLite module

2// Run this script manually to add new columns to the memories table
3
4export default async function migrateMemoriesDb() {
5  try {
6    // Import SQLite module

4import { nanoid } from "https://esm.sh/nanoid@5.0.5";
5
6export default async function populateMemoryIds() {
7  try {
8    // Import SQLite module

16In a normal server environment, you would likely use a middleware [like this one](https://hono.dev/docs/getting-started/nodejs#serve-static-files) to serve static files. Some frameworks or deployment platforms automatically make any content inside a `public/` folder public. 
17
18However in Val Town you need to handle this yourself, and it can be suprisingly difficult to read and serve files in a Val Town Project. This template uses helper functions from [stevekrouse/utils/serve-public](https://www.val.town/x/stevekrouse/utils/branch/main/code/serve-public/README.md), which handle reading project files in a way that will work across branches and forks, automatically transpiles typescript to javascript, and assigns content-types based on the file's extension.
19
20### `index.html`
26## CRUD API Routes
27
28This app has two CRUD API routes: for reading and inserting into the messages table. They both speak JSON, which is standard. They import their functions from `/backend/database/queries.ts`. These routes are called from the React app to refresh and update data.
29
30## Errors

6const tableName = "memories_demo";
7
8export async function getAllMemories(): Promise<Memory[]> {
9  const result = await sqlite.execute(
10    `SELECT id, date, text, createdBy, createdDate, tags FROM ${tableName}
23}
24
25export async function createMemory(
26  memory: Omit<Memory, "id">
27): Promise<Memory> {
51}
52
53export async function updateMemory(
54  id: string,
55  memory: Partial<Omit<Memory, "id">>
70}
71
72export async function deleteMemory(id: string): Promise<void> {
73  await sqlite.execute(`DELETE FROM ${tableName} WHERE id = ?`, [id]);
74}