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

-- name: CreateVehicleBrand :one
INSERT INTO vehicle_brands (brand)
VALUES ($1)
RETURNING *;

-- name: GetVehicleBrandById :one
SELECT * FROM vehicle_brands WHERE id=$1 LIMIT 1;

-- name: UpdateVehicleBrand :one
UPDATE vehicle_brands SET brand=$2 WHERE id=$1 RETURNING *;

-- name: DeleteVehicleBrand :one
DELETE FROM vehicle_brands WHERE id=$1 RETURNING id;