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

-- name: GetDiskBrandById :one
SELECT * FROM disk_brands WHERE id = $1 LIMIT 1;

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

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

-- name: DeleteDiskBrand :one
DELETE FROM disk_brands WHERE id=$1 RETURNING id;