Val Town Code SearchReturn to Val Town

9}
10
11export default function AchievementsScreen({ user, onNavigate, onLogout }: AchievementsScreenProps) {
12  const [achievements, setAchievements] = useState<Achievement[]>([]);
13  const [loading, setLoading] = useState(true);

9}
10
11export default function TaskScreen({ user, onNavigate, onLogout }: TaskScreenProps) {
12  const [tasks, setTasks] = useState<Task[]>([]);
13  const [newTaskTitle, setNewTaskTitle] = useState("");

7}
8
9export default function LoginScreen({ onLogin }: LoginScreenProps) {
10  const [name, setName] = useState("");
11  const [username, setUsername] = useState("");

8type Screen = "login" | "tasks" | "achievements";
9
10export default function App() {
11  const [currentScreen, setCurrentScreen] = useState<Screen>("login");
12  const [user, setUser] = useState<User | null>(null);

3
4// User operations
5export async function createUser(name: string, username: string): Promise<User> {
6  const result = await sqlite.execute(
7    "INSERT INTO users (name, username) VALUES (?, ?) RETURNING *",
11}
12
13export async function getUserByUsername(username: string): Promise<User | null> {
14  const result = await sqlite.execute(
15    "SELECT * FROM users WHERE username = ?",
19}
20
21export async function getUserById(id: number): Promise<User | null> {
22  const result = await sqlite.execute(
23    "SELECT * FROM users WHERE id = ?",
28
29// Task operations
30export async function createTask(userId: number, title: string, description?: string): Promise<Task> {
31  const result = await sqlite.execute(
32    "INSERT INTO tasks (user_id, title, description) VALUES (?, ?, ?) RETURNING *",
36}
37
38export async function getUserTasks(userId: number): Promise<Task[]> {
39  const result = await sqlite.execute(
40    "SELECT * FROM tasks WHERE user_id = ? ORDER BY created_at DESC",
44}
45
46export async function updateTaskCompletion(taskId: number, completed: boolean): Promise<Task> {
47  const completedAt = completed ? new Date().toISOString() : null;
48  const result = await sqlite.execute(
53}
54
55export async function deleteTask(taskId: number, userId: number): Promise<boolean> {
56  const result = await sqlite.execute(
57    "DELETE FROM tasks WHERE id = ? AND user_id = ?",
62
63// Achievement operations
64export async function getUserAchievements(userId: number): Promise<Achievement[]> {
65  const result = await sqlite.execute(`
66    SELECT 

1import { sqlite } from "https://esm.town/v/stevekrouse/sqlite";
2
3export async function runMigrations() {
4  // Users table
5  await sqlite.execute(`

2import { renderToString } from "npm:react-dom/server";
3
4export default async function(req: Request) {
5  return new Response(
6    renderToString(

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

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

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