Express + PostgreSQL — mini API

import express from "express";
import { pool } from "./db";

const app = express();
app.use(express.json());

app.get("/api/products", async (_req, res) => {
  const result = await pool.query(
    "SELECT id, name, price, qty FROM products"
  );
  res.json({ products: result.rows });
});

app.post("/api/products", async (req, res) => {
  const { name, price, qty } = req.body;
  const result = await pool.query(
    "INSERT INTO products (name, price, qty) " +
    "VALUES ($1, $2, $3) RETURNING *",
    [name, price, qty]
  );
  res.status(201).json(result.rows[0]);
});

app.listen(4000);