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