blob: 925fa090a4b91c803bf99983965fd58ebc1000cf (
plain) (
blame)
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
|
import express from 'express';
import { Database } from "bun:sqlite";
import cors from 'cors';
const app = express();
const port = process.env.PORT || 3000;
const db = new Database("../database.sqlite", { readonly: true });
app.use(express.static('../public'))
app.use(cors());
app.get('/', (req, res) => {
const query = db.prepare(`SELECT * FROM announcements ORDER BY created_at DESC`);
const result = query.all();
res.send(result);
});
app.get('/attachments/:slug', (req, res) => {
if (req.params.slug) {
const query = db.prepare(`SELECT * FROM announcements_attachments WHERE msg_id = (?)`);
const result = query.all(req.params.slug);
res.send(result);
}
});
app.get('/reactions/:slug', (req, res) => {
if (req.params.slug) {
const query = db.prepare(`SELECT * FROM announcements_reactions WHERE msg_id = (?)`);
const result = query.all(req.params.slug);
res.send(result);
}
});
app.listen(port, () => {
console.log(`Server is running on port ${port}`);
});
|
