-- name: GetBrakekBrands :many
SELECT * FROM brake_brands ORDER BY id LIMIT $1 OFFSET $2;

-- name: GetBreakBrandById :one
SELECT * FROM brake_brands WHERE id = $1 LIMIT 1;

-- name: CreateBrakeBrand :one
INSERT INTO brake_brands (name, brand, img_logo)
VALUES ($1, $2, $3)
RETURNING *;

-- name: UpdateBrakeBrand :one
UPDATE brake_brands SET name=$2, brand=$3, img_logo=$4 WHERE id=$1 RETURNING *;

-- name: DeleteBrakeBrand :one
DELETE FROM brake_brands WHERE id=$1 RETURNING id;