blob: 65452f3f6fe97effafe0d481be43417c9c81e39d (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
|
import { App } from "@tinyhttp/app"
import { logger } from "@tinyhttp/logger"
import { cors } from "@tinyhttp/cors"
import pg from "pg"
import { ExampleApi } from "slam-types"
const client = new pg.Client({
user: process.env.PGUSER ?? "postgres",
host: process.env.PGHOST ?? "localhost",
database: process.env.PGDATABASE ?? "postgres",
password: process.env.PGPASSWORD ?? "postgres",
port: process.env.PGPORT ? Number(process.env.PGPORT) : 5432,
})
client.connect()
.then(() => {
console.log("DB connection succeeded")
})
.catch((err) => {
console.error("DB connection failed", err)
})
const app = new App()
const PORT = Number(process.env.PORT) || 3000
console.log(`Serving API on port ${PORT}`)
app
.use(logger({
timestamp: { format: "YYYY-MM-DDTHH:mm:ssZ" },
}))
.use(cors())
.get(ExampleApi.ListRequest.path, async (_req, res) => {
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)
}
})
.listen(PORT)
|
