Val Town Code SearchReturn to Val Town

8}
9
10export default function TaskForm({ onTasksSubmitted, userEmail }: TaskFormProps) {
11  const [formData, setFormData] = useState<TaskFormData>({
12    name: '',

5import type { DashboardData } from "../../shared/types.ts";
6
7export default function App() {
8  const [currentView, setCurrentView] = useState<'form' | 'dashboard'>('form');
9  const [userEmail, setUserEmail] = useState<string>('');

3import type { ChatMessage, CreateChatMessageRequest, ApiResponse } from "../../shared/types.ts";
4
5export default function ChatRoom() {
6  const [messages, setMessages] = useState<ChatMessage[]>([]);
7  const [loading, setLoading] = useState(true);

2import type { User, DailyTasks, TaskCompletion, TaskFormData, DashboardData } from "../../shared/types.ts";
3
4export async function createOrUpdateUser(data: TaskFormData): Promise<User> {
5  // Try to find existing user by email
6  const existingUser = await sqlite.execute(
28}
29
30export async function saveDailyTasks(userId: number, tasks: TaskFormData): Promise<DailyTasks> {
31  const today = new Date().toISOString().split('T')[0];
32  
41}
42
43export async function getUserByEmail(email: string): Promise<User | null> {
44  const result = await sqlite.execute(
45    "SELECT * FROM users WHERE email = ?",
49}
50
51export async function getUserById(userId: number): Promise<User | null> {
52  const result = await sqlite.execute(
53    "SELECT * FROM users WHERE id = ?",
57}
58
59export async function getTodaysTasks(userId: number): Promise<DailyTasks | null> {
60  const today = new Date().toISOString().split('T')[0];
61  const result = await sqlite.execute(
66}
67
68export async function getTasksForDate(userId: number, date: string): Promise<DailyTasks | null> {
69  const result = await sqlite.execute(
70    "SELECT * FROM daily_tasks WHERE user_id = ? AND date = ?",
74}
75
76export async function recordTaskCompletion(userId: number, completed: boolean, date?: string): Promise<TaskCompletion> {
77  const targetDate = date || new Date().toISOString().split('T')[0];
78  
86}
87
88export async function markReminderSent(userId: number, date: string): Promise<void> {
89  await sqlite.execute(
90    "UPDATE task_completions SET reminder_sent = TRUE WHERE user_id = ? AND date = ?",
93}
94
95export async function getUsersNeedingEveningReminder(): Promise<User[]> {
96  const today = new Date().toISOString().split('T')[0];
97  
108}
109
110export async function getUsersNeedingMorningReminder(): Promise<User[]> {
111  const yesterday = new Date();
112  yesterday.setDate(yesterday.getDate() - 1);
124}
125
126export async function getDashboardData(userId: number): Promise<DashboardData> {
127  const user = await getUserById(userId);
128  if (!user) throw new Error("User not found");

7}
8
9export default function JobForm({ onJobPosted }: JobFormProps) {
10  const [formData, setFormData] = useState<CreateJobRequest>({
11    title: '',

3import type { Job, ApiResponse } from "../../shared/types.ts";
4
5export default function JobBoard() {
6  const [jobs, setJobs] = useState<Job[]>([]);
7  const [loading, setLoading] = useState(true);

7type Tab = 'jobs' | 'post-job' | 'chat';
8
9export default function App() {
10  const [activeTab, setActiveTab] = useState<Tab>('jobs');
11

4
5// Job queries
6export async function getAllJobs(): Promise<Job[]> {
7  const result = await sqlite.execute(`
8    SELECT * FROM ${JOBS_TABLE} 
12}
13
14export async function getJobById(id: number): Promise<Job | null> {
15  const result = await sqlite.execute(`
16    SELECT * FROM ${JOBS_TABLE} 
21}
22
23export async function createJob(jobData: CreateJobRequest): Promise<Job> {
24  const result = await sqlite.execute(`
25    INSERT INTO ${JOBS_TABLE} (
46
47// Chat queries
48export async function getChatMessages(limit: number = 50): Promise<ChatMessage[]> {
49  const result = await sqlite.execute(`
50    SELECT * FROM ${CHAT_MESSAGES_TABLE} 
57}
58
59export async function createChatMessage(messageData: CreateChatMessageRequest): Promise<ChatMessage> {
60  const result = await sqlite.execute(`
61    INSERT INTO ${CHAT_MESSAGES_TABLE} (username, message) 

5export const CHAT_MESSAGES_TABLE = 'chat_messages_v1';
6
7export async function runMigrations() {
8  // Create jobs table
9  await sqlite.execute(`

16│   ├── database/
17│   │   ├── migrations.ts    # Database schema setup
18│   │   └── queries.ts       # Database query functions
19│   ├── routes/
20│   │   ├── jobs.ts         # Job posting API routes