Val Town Code SearchReturn to Val Town

42  const handleLogin = async (username, password) => {
43    try {
44      const response = await fetch("/login", {
45        method: "POST",
46        headers: { "Content-Type": "application/json" },
377    }
378
379    if (path === "/fetch-news" && method === "GET") {
380      const newsArticles = await sqlite.execute(`SELECT * FROM ${KEY}_news_articles ORDER BY created_at DESC`);
381      return new Response(JSON.stringify({ articles: newsArticles.rows }), {
384    }
385
386    if (path === "/fetch-media" && method === "GET") {
387      const mediaEntries = await sqlite.execute(`SELECT * FROM ${KEY}_media_monitoring ORDER BY created_at DESC`);
388      return new Response(JSON.stringify({ entries: mediaEntries.rows }), {
476
477        if (result.rowsAffected > 0) {
478          // Fetch the updated article to return it to the client
479          const updatedArticle = await sqlite.execute(`SELECT * FROM ${KEY}_news_articles WHERE id = ?`, [id]);
480
487            // This case should ideally not happen if rowsAffected > 0, but good for robustness
488            return new Response(
489              JSON.stringify({ success: false, message: "Article updated but could not be refetched" }),
490              {
491                status: 500, // Internal Server Error
538
539        if (result.rowsAffected > 0) {
540          // Fetch the updated entry to return it
541          const updatedEntry = await sqlite.execute(`SELECT * FROM ${KEY}_media_monitoring WHERE id = ?`, [id]);
542          return new Response(JSON.stringify({ success: true, entry: updatedEntry.rows[0] }), {
573        const sevenDaysAgoISO = sevenDaysAgo.toISOString(); // e.g., "2023-10-27T10:00:00.000Z"
574
575        // Fetch news article counts per author in the last 7 days
576        const newsCountsResult = await sqlite.execute(
577          `
584        );
585
586        // Fetch media monitoring counts per author in the last 7 days
587        const mediaCountsResult = await sqlite.execute(
588          `

135  const lastSunday = today.startOf("week").minus({ days: 1 });
136
137  // Fetch relevant memories using the utility function
138  const memories = await getRelevantMemories();
139