github.com/navikt/knorten@v0.0.0-20240419132333-1333f46ed8b6/pkg/database/gensql/teams.sql.go (about)

     1  // Code generated by sqlc. DO NOT EDIT.
     2  // source: teams.sql
     3  
     4  package gensql
     5  
     6  import (
     7  	"context"
     8  
     9  	"github.com/lib/pq"
    10  )
    11  
    12  const teamBySlugGet = `-- name: TeamBySlugGet :one
    13  SELECT id, users, slug
    14  FROM teams
    15  WHERE slug = $1
    16  `
    17  
    18  type TeamBySlugGetRow struct {
    19  	ID    string
    20  	Users []string
    21  	Slug  string
    22  }
    23  
    24  func (q *Queries) TeamBySlugGet(ctx context.Context, slug string) (TeamBySlugGetRow, error) {
    25  	row := q.db.QueryRowContext(ctx, teamBySlugGet, slug)
    26  	var i TeamBySlugGetRow
    27  	err := row.Scan(&i.ID, pq.Array(&i.Users), &i.Slug)
    28  	return i, err
    29  }
    30  
    31  const teamCreate = `-- name: TeamCreate :exec
    32  INSERT INTO teams ("id", "users", "slug")
    33  VALUES ($1, $2, $3)
    34  `
    35  
    36  type TeamCreateParams struct {
    37  	ID    string
    38  	Users []string
    39  	Slug  string
    40  }
    41  
    42  func (q *Queries) TeamCreate(ctx context.Context, arg TeamCreateParams) error {
    43  	_, err := q.db.ExecContext(ctx, teamCreate, arg.ID, pq.Array(arg.Users), arg.Slug)
    44  	return err
    45  }
    46  
    47  const teamDelete = `-- name: TeamDelete :exec
    48  DELETE
    49  FROM teams
    50  WHERE id = $1
    51  `
    52  
    53  func (q *Queries) TeamDelete(ctx context.Context, id string) error {
    54  	_, err := q.db.ExecContext(ctx, teamDelete, id)
    55  	return err
    56  }
    57  
    58  const teamGet = `-- name: TeamGet :one
    59  SELECT id, users, slug
    60  FROM teams
    61  WHERE id = $1
    62  `
    63  
    64  type TeamGetRow struct {
    65  	ID    string
    66  	Users []string
    67  	Slug  string
    68  }
    69  
    70  func (q *Queries) TeamGet(ctx context.Context, id string) (TeamGetRow, error) {
    71  	row := q.db.QueryRowContext(ctx, teamGet, id)
    72  	var i TeamGetRow
    73  	err := row.Scan(&i.ID, pq.Array(&i.Users), &i.Slug)
    74  	return i, err
    75  }
    76  
    77  const teamUpdate = `-- name: TeamUpdate :exec
    78  UPDATE teams
    79  SET users = $1
    80  WHERE id = $2
    81  `
    82  
    83  type TeamUpdateParams struct {
    84  	Users []string
    85  	ID    string
    86  }
    87  
    88  func (q *Queries) TeamUpdate(ctx context.Context, arg TeamUpdateParams) error {
    89  	_, err := q.db.ExecContext(ctx, teamUpdate, pq.Array(arg.Users), arg.ID)
    90  	return err
    91  }
    92  
    93  const teamsForUserGet = `-- name: TeamsForUserGet :many
    94  SELECT id, slug
    95  FROM teams
    96  WHERE $1::TEXT = ANY ("users")
    97  `
    98  
    99  type TeamsForUserGetRow struct {
   100  	ID   string
   101  	Slug string
   102  }
   103  
   104  func (q *Queries) TeamsForUserGet(ctx context.Context, email string) ([]TeamsForUserGetRow, error) {
   105  	rows, err := q.db.QueryContext(ctx, teamsForUserGet, email)
   106  	if err != nil {
   107  		return nil, err
   108  	}
   109  	defer rows.Close()
   110  	items := []TeamsForUserGetRow{}
   111  	for rows.Next() {
   112  		var i TeamsForUserGetRow
   113  		if err := rows.Scan(&i.ID, &i.Slug); err != nil {
   114  			return nil, err
   115  		}
   116  		items = append(items, i)
   117  	}
   118  	if err := rows.Close(); err != nil {
   119  		return nil, err
   120  	}
   121  	if err := rows.Err(); err != nil {
   122  		return nil, err
   123  	}
   124  	return items, nil
   125  }
   126  
   127  const teamsGet = `-- name: TeamsGet :many
   128  select id, slug, users, created
   129  from teams
   130  ORDER BY slug
   131  `
   132  
   133  func (q *Queries) TeamsGet(ctx context.Context) ([]Team, error) {
   134  	rows, err := q.db.QueryContext(ctx, teamsGet)
   135  	if err != nil {
   136  		return nil, err
   137  	}
   138  	defer rows.Close()
   139  	items := []Team{}
   140  	for rows.Next() {
   141  		var i Team
   142  		if err := rows.Scan(
   143  			&i.ID,
   144  			&i.Slug,
   145  			pq.Array(&i.Users),
   146  			&i.Created,
   147  		); err != nil {
   148  			return nil, err
   149  		}
   150  		items = append(items, i)
   151  	}
   152  	if err := rows.Close(); err != nil {
   153  		return nil, err
   154  	}
   155  	if err := rows.Err(); err != nil {
   156  		return nil, err
   157  	}
   158  	return items, nil
   159  }