From 6831948476003527e5ac7eec0f1efa279bac2ac3 Mon Sep 17 00:00:00 2001 From: Jan Tuomi Date: Mon, 7 Feb 2022 14:40:02 +0200 Subject: Add db conn --- docker-compose.yml | 2 ++ migrations/down/001-initial.sql | 1 + migrations/up/001-initial.sql | 5 +++++ src/index.ts | 3 ++- 4 files changed, 10 insertions(+), 1 deletion(-) create mode 100644 migrations/down/001-initial.sql create mode 100644 migrations/up/001-initial.sql diff --git a/docker-compose.yml b/docker-compose.yml index 047c9d3..2d69c45 100644 --- a/docker-compose.yml +++ b/docker-compose.yml @@ -17,6 +17,8 @@ services: PGHOST: db ports: - 3000:3000 + volumes: + - ./src:/app/src volumes: dbdata: diff --git a/migrations/down/001-initial.sql b/migrations/down/001-initial.sql new file mode 100644 index 0000000..4d53211 --- /dev/null +++ b/migrations/down/001-initial.sql @@ -0,0 +1 @@ +DROP TABLE examples; diff --git a/migrations/up/001-initial.sql b/migrations/up/001-initial.sql new file mode 100644 index 0000000..1a05754 --- /dev/null +++ b/migrations/up/001-initial.sql @@ -0,0 +1,5 @@ +CREATE TABLE examples ( + id uuid PRIMARY KEY DEFAULT gen_random_uuid(), + title VARCHAR(40), + content TEXT +); diff --git a/src/index.ts b/src/index.ts index dac8807..c5cf39a 100644 --- a/src/index.ts +++ b/src/index.ts @@ -23,8 +23,9 @@ app timestamp: { format: "YYYY-MM-DDTHH:mm:ssZ" }, })) .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: [{ id: "123", title: "foobar", content: "10 20 + ." }], + examples, } res.send(response) }) -- cgit v1.3