Created
July 1, 2023 23:18
-
-
Save christopherbauer/d1159499cf6029baa25ee70ec9914469 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import express, { Request } from "express"; | |
| import * as db from "zapatos/db"; | |
| import type * as s from "zapatos/schema"; | |
| import pool from "../pool"; | |
| const productRouter = express.Router(); | |
| productRouter | |
| .route("/") | |
| .get(async (req, res) => { | |
| const products = await db.select("Product", {}).run(pool); | |
| res.status(200).send(products); | |
| }) | |
| .put( | |
| async ( | |
| req: Request< | |
| {}, | |
| {}, | |
| { | |
| id?: number; | |
| name: string; | |
| price: number; | |
| description: string; | |
| }[], | |
| {} | |
| >, | |
| res | |
| ) => { | |
| const { body } = req; | |
| let products: s.Product.JSONSelectable[] = []; | |
| for (let i = 0; i < body.length; i++) { | |
| const product = body[i]; | |
| const { id, name, price, description } = product; | |
| if (id) { | |
| products.push( | |
| ...(await db | |
| .update( | |
| "Product", | |
| { | |
| name, | |
| price, | |
| description, | |
| updated_at: new Date(), | |
| }, | |
| { | |
| product_id: Number(id), | |
| } | |
| ) | |
| .run(pool)) | |
| ); | |
| } else { | |
| products.push( | |
| await db | |
| .insert("Product", { | |
| name, | |
| price, | |
| description, | |
| created_at: new Date(), | |
| updated_at: new Date(), | |
| }) | |
| .run(pool) | |
| ); | |
| } | |
| } | |
| res.status(200).send(products); | |
| } | |
| ); | |
| export default productRouter; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment