🗓️ Smart Schedule Assistant

\n \n View Source\n \n \n );\n}\n\nfunction client() {\n createRoot(document.getElementById(\"root\")).render();\n}\nif (typeof document !== \"undefined\") { client(); }\n\nexport default async function server(request: Request): Promise {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n const { OpenAI } = await import(\"https://esm.town/v/std/openai\");\n const openai = new OpenAI();\n\n const KEY = \"My_Scheduler\";\n const SCHEMA_VERSION = 1;\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_tasks_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n task TEXT NOT NULL,\n duration INTEGER NOT NULL,\n priority TEXT NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n if (request.method === \"POST\" && new URL(request.url).pathname === \"/addTask\") {\n const { task, duration, priority } = await request.json();\n await sqlite.execute(\n `INSERT INTO ${KEY}_tasks_${SCHEMA_VERSION} (task, duration, priority) VALUES (?, ?, ?)`,\n [task, duration, priority],\n );\n\n const tasks = await sqlite.execute(\n `SELECT * FROM ${KEY}_tasks_${SCHEMA_VERSION} ORDER BY created_at DESC LIMIT 10`,\n );\n\n return new Response(JSON.stringify({ tasks: tasks.rows }), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n if (request.method === \"GET\" && new URL(request.url).pathname === \"/aiSchedule\") {\n const tasks = await sqlite.execute(\n `SELECT * FROM ${KEY}_tasks_${SCHEMA_VERSION} ORDER BY created_at DESC LIMIT 10`,\n );\n\n const taskList = tasks.rows.map(t => `${t.task} (${t.duration} mins, ${t.priority} priority)`).join(\", \");\n\n const suggestion = await openai.chat.completions.create({\n messages: [\n {\n role: \"system\",\n content:\n \"You are a helpful scheduling assistant. Provide concise, practical advice for organizing tasks efficiently.\",\n },\n {\n role: \"user\",\n content:\n `I have these tasks to schedule: ${taskList}. Help me prioritize and find the best time slots considering task duration and priority.`,\n },\n ],\n model: \"gpt-4o-mini\",\n max_tokens: 150,\n });\n\n return new Response(\n JSON.stringify({\n suggestion: suggestion.choices[0].message.content,\n }),\n {\n headers: { \"Content-Type\": \"application/json\" },\n },\n );\n }\n\n return new Response(\n `\n \n \n Smart Schedule Assistant\n \n \n \n \n

\n \n \n \n `,\n {\n headers: { \"Content-Type\": \"text/html\" },\n },\n );\n}","deleted","label",[98],"permalink","https://www.val.town/x/shirahh/My_Scheduler/code/main.tsx","extension","actionData","errors"]

🗓️ Smart Schedule Assistant

AI Suggestion

Upcoming Tasks