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

-- name: GetStrutBrandById :one
SELECT * FROM strut_brands WHERE id = $1 LIMIT 1;

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

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

-- name: DeleteStrutBrand :one
DELETE FROM strut_brands WHERE id=$1 RETURNING id;