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