github.com/nais/knorten@v0.0.0-20240104110906-55926958e361/pkg/database/gensql/compute.sql.go (about) 1 // Code generated by sqlc. DO NOT EDIT. 2 // versions: 3 // sqlc v1.23.0 4 // source: compute.sql 5 6 package gensql 7 8 import ( 9 "context" 10 ) 11 12 const computeInstanceCreate = `-- name: ComputeInstanceCreate :exec 13 INSERT INTO compute_instances ("owner", "name", "disk_size") 14 VALUES ($1, $2, $3) 15 ` 16 17 type ComputeInstanceCreateParams struct { 18 Owner string 19 Name string 20 DiskSize int32 21 } 22 23 func (q *Queries) ComputeInstanceCreate(ctx context.Context, arg ComputeInstanceCreateParams) error { 24 _, err := q.db.ExecContext(ctx, computeInstanceCreate, arg.Owner, arg.Name, arg.DiskSize) 25 return err 26 } 27 28 const computeInstanceDelete = `-- name: ComputeInstanceDelete :exec 29 DELETE 30 FROM compute_instances 31 WHERE owner = $1 32 ` 33 34 func (q *Queries) ComputeInstanceDelete(ctx context.Context, owner string) error { 35 _, err := q.db.ExecContext(ctx, computeInstanceDelete, owner) 36 return err 37 } 38 39 const computeInstanceGet = `-- name: ComputeInstanceGet :one 40 SELECT owner, name, disk_size 41 FROM compute_instances 42 WHERE owner = $1 43 ` 44 45 func (q *Queries) ComputeInstanceGet(ctx context.Context, owner string) (ComputeInstance, error) { 46 row := q.db.QueryRowContext(ctx, computeInstanceGet, owner) 47 var i ComputeInstance 48 err := row.Scan(&i.Owner, &i.Name, &i.DiskSize) 49 return i, err 50 } 51 52 const computeInstanceUpdate = `-- name: ComputeInstanceUpdate :exec 53 UPDATE compute_instances 54 SET disk_size = $1 55 WHERE "owner" = $2 56 ` 57 58 type ComputeInstanceUpdateParams struct { 59 DiskSize int32 60 Owner string 61 } 62 63 func (q *Queries) ComputeInstanceUpdate(ctx context.Context, arg ComputeInstanceUpdateParams) error { 64 _, err := q.db.ExecContext(ctx, computeInstanceUpdate, arg.DiskSize, arg.Owner) 65 return err 66 } 67 68 const computeInstancesGet = `-- name: ComputeInstancesGet :many 69 SELECT owner, name, disk_size 70 FROM compute_instances 71 ` 72 73 func (q *Queries) ComputeInstancesGet(ctx context.Context) ([]ComputeInstance, error) { 74 rows, err := q.db.QueryContext(ctx, computeInstancesGet) 75 if err != nil { 76 return nil, err 77 } 78 defer rows.Close() 79 items := []ComputeInstance{} 80 for rows.Next() { 81 var i ComputeInstance 82 if err := rows.Scan(&i.Owner, &i.Name, &i.DiskSize); err != nil { 83 return nil, err 84 } 85 items = append(items, i) 86 } 87 if err := rows.Close(); err != nil { 88 return nil, err 89 } 90 if err := rows.Err(); err != nil { 91 return nil, err 92 } 93 return items, nil 94 }