1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
|
import type { APIRoute } from 'astro';
export const prerender = false;
export const GET: APIRoute = async ({ locals }) => {
try {
const db = locals.runtime?.env?.DB;
if (!db) {
console.error('Database not available');
return new Response(JSON.stringify([]), {
status: 200,
headers: { 'Content-Type': 'application/json' }
});
}
const { results } = await db.prepare('SELECT * FROM tasks ORDER BY created_at DESC').all();
return new Response(JSON.stringify(results || []), {
status: 200,
headers: { 'Content-Type': 'application/json' }
});
} catch (error) {
console.error('Database error:', error);
return new Response(JSON.stringify([]), {
status: 200,
headers: { 'Content-Type': 'application/json' }
});
}
};
export const POST: APIRoute = async ({ request, locals }) => {
try {
const db = locals.runtime?.env?.DB;
if (!db) {
return new Response(JSON.stringify({ error: 'Database not available' }), {
status: 503,
headers: { 'Content-Type': 'application/json' }
});
}
const body = await request.json();
const { title, description } = body;
if (!title) {
return new Response(JSON.stringify({ error: 'Title is required' }), {
status: 400,
headers: { 'Content-Type': 'application/json' }
});
}
const { results } = await db.prepare(
'INSERT INTO tasks (title, description) VALUES (?, ?) RETURNING *'
).bind(title, description || '').all();
return new Response(JSON.stringify(results?.[0] || { id: Date.now(), title, description, completed: false }), {
status: 201,
headers: { 'Content-Type': 'application/json' }
});
} catch (error) {
console.error('Database error:', error);
return new Response(JSON.stringify({ error: 'Failed to create task' }), {
status: 500,
headers: { 'Content-Type': 'application/json' }
});
}
};
|
