-- name: GetBrakekStocksByBrakeSpec :many
SELECT
  *
FROM
  brake_stocks
WHERE
  "fk_idBrake" = $1;

-- name: GetBrakeStocks :one
SELECT
  *
FROM
  brake_stocks
WHERE
  id = $1
LIMIT 1;

-- name: CreateBrakeStock :one
INSERT INTO brake_stocks (quantity, "fk_idBrake")
VALUES ($1, $2)
RETURNING *;




-- name: ListBrakeStocks :many
SELECT * FROM brake_stocks
WHERE (
sqlc.arg('search')::text = '' OR
  "id"::text ILIKE '%' || sqlc.arg('search')::text || '%' OR
  "quantity"::text ILIKE '%' || sqlc.arg('search')::text || '%' OR
  "fk_idBrake"::text ILIKE '%' || sqlc.arg('search')::text || '%'
)
ORDER BY id LIMIT sqlc.arg('limit') OFFSET sqlc.arg('offset');

-- name: UpdateBrakeStock :one
UPDATE brake_stocks SET quantity=$2, "fk_idBrake"=$3 WHERE id=$1 RETURNING *;

-- name: DeleteBrakeStock :one
DELETE FROM brake_stocks WHERE id=$1 RETURNING id;