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;