diff options
Diffstat (limited to 'internal/data/networks.sql.go')
| -rw-r--r-- | internal/data/networks.sql.go | 74 |
1 files changed, 74 insertions, 0 deletions
diff --git a/internal/data/networks.sql.go b/internal/data/networks.sql.go new file mode 100644 index 0000000..1333863 --- /dev/null +++ b/internal/data/networks.sql.go @@ -0,0 +1,74 @@ +// Code generated by sqlc. DO NOT EDIT. +// versions: +// sqlc v1.27.0 +// source: networks.sql + +package data + +import ( + "context" + + "github.com/kyren223/eko/pkg/snowflake" +) + +const createNetwork = `-- name: CreateNetwork :one +INSERT INTO networks ( + id, name, owner_id +) VALUES ( + ?, ?, ? +) +RETURNING id, name, owner_id +` + +type CreateNetworkParams struct { + ID snowflake.ID + Name string + OwnerID snowflake.ID +} + +func (q *Queries) CreateNetwork(ctx context.Context, arg CreateNetworkParams) (Network, error) { + row := q.db.QueryRowContext(ctx, createNetwork, arg.ID, arg.Name, arg.OwnerID) + var i Network + err := row.Scan(&i.ID, &i.Name, &i.OwnerID) + return i, err +} + +const getNetwork = `-- name: GetNetwork :one +SELECT id, name, owner_id FROM networks +WHERE id = ? +` + +func (q *Queries) GetNetwork(ctx context.Context, id snowflake.ID) (Network, error) { + row := q.db.QueryRowContext(ctx, getNetwork, id) + var i Network + err := row.Scan(&i.ID, &i.Name, &i.OwnerID) + return i, err +} + +const listNetworks = `-- name: ListNetworks :many +SELECT id, name, owner_id FROM networks +ORDER BY id +` + +func (q *Queries) ListNetworks(ctx context.Context) ([]Network, error) { + rows, err := q.db.QueryContext(ctx, listNetworks) + if err != nil { + return nil, err + } + defer rows.Close() + var items []Network + for rows.Next() { + var i Network + if err := rows.Scan(&i.ID, &i.Name, &i.OwnerID); err != nil { + return nil, err + } + items = append(items, i) + } + if err := rows.Close(); err != nil { + return nil, err + } + if err := rows.Err(); err != nil { + return nil, err + } + return items, nil +} |
