github.com/nais/knorten@v0.0.0-20240104110906-55926958e361/pkg/database/queries/teams.sql (about)

     1  -- name: TeamCreate :exec
     2  INSERT INTO teams ("id", "users", "slug", "enable_allowlist")
     3  VALUES (@id, @users, @slug, @enable_allowlist);
     4  
     5  -- name: TeamUpdate :exec
     6  UPDATE teams
     7  SET users = @users, enable_allowlist = @enable_allowlist
     8  WHERE id = @id;
     9  
    10  -- name: TeamsForUserGet :many
    11  SELECT id, slug
    12  FROM teams
    13  WHERE @email::TEXT = ANY ("users");
    14  
    15  -- name: TeamGet :one
    16  SELECT id, users, slug, enable_allowlist
    17  FROM teams
    18  WHERE id = @id;
    19  
    20  -- name: TeamBySlugGet :one
    21  SELECT id, users, slug, enable_allowlist
    22  FROM teams
    23  WHERE slug = @slug;
    24  
    25  -- name: TeamDelete :exec
    26  DELETE
    27  FROM teams
    28  WHERE id = @id;
    29  
    30  -- name: TeamsGet :many
    31  select *
    32  from teams
    33  ORDER BY slug;