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

-- name: GetShockBrandById :one
SELECT * FROM shock_brands WHERE id = $1 LIMIT 1;

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

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

-- name: DeleteShockBrand :one
DELETE FROM shock_brands WHERE id=$1 RETURNING id;