-- name: GetDiskStocksByDiskSpec :many
SELECT
  *
FROM
  disk_stocks
WHERE
  "fk_idDiskk" = $1;

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

-- name: CreateDiskStock :one
INSERT INTO disk_stocks (quantity, "fk_idDiskk")
VALUES ($1, $2)
RETURNING *;
-- name: GetDiskStockById :one
SELECT * FROM disk_stocks WHERE id=$1 LIMIT 1;

-- name: UpdateDiskStock :one
UPDATE disk_stocks SET quantity=$2, "fk_idDiskk"=$3 WHERE id=$1 RETURNING *;

-- name: DeleteDiskStock :one
DELETE FROM disk_stocks WHERE id=$1 RETURNING id;