Scratch space for learning atproto app development
1import express from "express";
2import type { AppContext } from "#/config";
3
4export const createRouter = (ctx: AppContext) => {
5 const router = express.Router();
6
7 router.get("/", async (req, res) => {
8 const posts = await ctx.db
9 .selectFrom("post")
10 .selectAll()
11 .orderBy("indexedAt", "desc")
12 .limit(10)
13 .execute();
14 const postTexts = posts.map((row) => row.text);
15 res.json(postTexts);
16 });
17
18 return router;
19};