listTodos.ts12 lines · main

1	import { query, type Ctx } from '@briven/cli/server';
2
3	interface Args {
4	filter?: 'open' | 'done' | 'all';
5	}
6
7	export default query(async (ctx: Ctx, args: Args = {}) => {
8	let q = ctx.db('todos').select(['id', 'body', 'done', 'createdAt', 'completedAt']);
9	if (args.filter === 'open') q = q.where({ done: false });
10	if (args.filter === 'done') q = q.where({ done: true });
11	return q.orderBy('createdAt', 'desc').limit(200);
12	});