blob: 2fb7a0821922fec8903f3f2810aa096e6fe3755a (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
import express from 'express';
import { Database } from "bun:sqlite";
const app = express();
const port = process.env.PORT || 3000;
const db = new Database("../database.sqlite", { readonly: true });
app.get('/', (req, res) => {
const query = db.prepare(`SELECT * FROM announcements ORDER BY created_at DESC`);
const result = query.all();
res.send(result);
});
app.listen(port, () => {
console.log(`Server is running on port ${port}`);
});
|
