github.com/nais/knorten@v0.0.0-20240104110906-55926958e361/pkg/database/queries/compute.sql (about) 1 -- name: ComputeInstanceCreate :exec 2 INSERT INTO compute_instances ("owner", "name", "disk_size") 3 VALUES (@owner, @name, @disk_size); 4 5 -- name: ComputeInstanceUpdate :exec 6 UPDATE compute_instances 7 SET disk_size = @disk_size 8 WHERE "owner" = @owner; 9 10 -- name: ComputeInstancesGet :many 11 SELECT * 12 FROM compute_instances; 13 14 -- name: ComputeInstanceGet :one 15 SELECT * 16 FROM compute_instances 17 WHERE owner = @owner; 18 19 -- name: ComputeInstanceDelete :exec 20 DELETE 21 FROM compute_instances 22 WHERE owner = @owner;