Val Town Code SearchReturn to Val Town

3import { TABLE_NAME } from "./updateTable";
4
5export default async function(req: Request): Promise<Response> {
6  // First, get the row IDs of all rows that are older than 25 hours old
7  const res = await sqlite.execute(`

3import { TABLE_NAME } from "./updateTable";
4
5export default async function(req: Request): Promise<Response> {
6  const url = new URL(req.url);
7  const id = url.searchParams.get("id");

3import { TABLE_NAME } from "./updateTable";
4
5export default async function(req: Request): Promise<Response> {
6  const url = new URL(req.url);
7  const id = url.searchParams.get("id");

4import { TABLE_NAME } from "./updateTable";
5
6export default async function(req: Request): Promise<Response> {
7  // body contains:
8  // - id (number)

4import { TABLE_NAME } from "./updateTable";
5
6export default async function(req: Request): Promise<Response> {
7  // body contains:
8  // - title (string)

1export default async function (req: Request): Promise<Response> {
2  return Response.json({ ok: true })
3}

6// const 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}

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

1import { sendDailyBriefing } from "./sendDailyBrief.ts";
2
3export async function cronDailyBrief() {
4  try {
5    console.log("Sending scheduled daily briefing...");

4import { sendDailyBriefing } from "./sendDailyBrief.ts";
5
6export async function testDailyBrief() {
7  try {
8    // const testChatId = Deno.env.get("TEST_TELEGRAM_CHAT_ID");