Function decreaseItemQuantityDb

server/db/cart.db.js:73–84

({ cart_id, product_id })

// decrement item quantity by 1
const decreaseItemQuantityDb = async ({ cart_id, product_id }) => {
  await pool.query(
    "update cart_item set quantity = quantity - 1 where cart_item.cart_id = $1 AND cart_item.product_id = $2 returning *",
    [cart_id, product_id]
  );

  const results = await pool.query(
    "Select products.*, cart_item.quantity, round((products.price * cart_item.quantity)::numeric, 2) as subtotal from cart_item join products on cart_item.product_id = products.product_id where cart_item.cart_id = $1",
    [cart_id]
  );
  return results.rows;
};

const emptyCartDb = async (cartId) => {
  return await pool.query("delete from cart_item where cart_id = $1", [cartId]);