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}`);
});