From d7d21da01517a9b589091108745e4f73c29878d2 Mon Sep 17 00:00:00 2001
From: Jan Tuomi <jans.tuomi@gmail.com>
Date: Mon, 7 Feb 2022 16:01:21 +0200
Subject: Improve error handling

---
 src/index.ts | 19 +++++++++++++++----
 1 file changed, 15 insertions(+), 4 deletions(-)

(limited to 'src')

diff --git a/src/index.ts b/src/index.ts
index 392827e..65452f3 100644
--- a/src/index.ts
+++ b/src/index.ts
@@ -13,6 +13,12 @@ const client = new pg.Client({
 })
 
 client.connect()
+  .then(() => {
+    console.log("DB connection succeeded")
+  })
+  .catch((err) => {
+    console.error("DB connection failed", err)
+  })
 
 const app = new App()
 
@@ -25,10 +31,15 @@ app
   }))
   .use(cors())
   .get(ExampleApi.ListRequest.path, async (_req, res) => {
-    const examples: ExampleApi.Example[] = await client.query("SELECT * FROM examples").then(r => r.rows)
-    const response: ExampleApi.ListResponse.Body = {
-      examples,
+    try {
+      const examples: ExampleApi.Example[] = await client.query("SELECT * FROM examples").then(r => r.rows)
+      const response: ExampleApi.ListResponse.Body = {
+        examples,
+      }
+      res.send(response)
+    } catch (err) {
+      console.error(err)
+      res.sendStatus(500)
     }
-    res.send(response)
   })
   .listen(PORT)
-- 
cgit v1.3