diff options
| author | Jan Tuomi <jans.tuomi@gmail.com> | 2022-02-07 14:40:02 +0200 |
|---|---|---|
| committer | Jan Tuomi <jans.tuomi@gmail.com> | 2022-02-07 14:40:02 +0200 |
| commit | 6831948476003527e5ac7eec0f1efa279bac2ac3 (patch) | |
| tree | a79887dbbab88b5f74f95a854880faf13b1f6c76 | |
| parent | 7a0f65385189cc6e888027d5f286794e07a6fe2a (diff) | |
Add db conn
| -rw-r--r-- | docker-compose.yml | 2 | ||||
| -rw-r--r-- | migrations/down/001-initial.sql | 1 | ||||
| -rw-r--r-- | migrations/up/001-initial.sql | 5 | ||||
| -rw-r--r-- | src/index.ts | 3 |
4 files changed, 10 insertions, 1 deletions
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) }) |