Initial commit

1 files changed, 17 insertions, 0 deletions

diff --git a/api/index.ts b/api/index.ts
new file mode 100644
index 0000000..2fb7a08
--- /dev/null
+++ b/api/index.ts
@@ -0,0 +1,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}`);
+});