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

     1  -- name: TeamValueInsert :exec
     2  INSERT INTO chart_team_values ("key",
     3                                 "value",
     4                                 "team_id",
     5                                 "chart_type")
     6  VALUES (@key,
     7          @value,
     8          @team_id,
     9          @chart_type);
    10  
    11  -- name: TeamValuesGet :many
    12  SELECT DISTINCT ON ("key") *
    13  FROM chart_team_values
    14  WHERE chart_type = @chart_type
    15    AND team_id = @team_id
    16  ORDER BY "key", "created" DESC;
    17  
    18  -- name: TeamValueGet :one
    19  SELECT DISTINCT ON ("key") *
    20  FROM chart_team_values
    21  WHERE key = @key
    22    AND team_id = @team_id
    23  ORDER BY "key", "created" DESC;
    24  
    25  -- name: TeamValueDelete :exec
    26  DELETE FROM chart_team_values
    27  WHERE key = @key AND team_id = @team_id;
    28  
    29  -- name: ChartsForTeamGet :many
    30  SELECT DISTINCT ON (chart_type) chart_type
    31  FROM chart_team_values
    32  WHERE team_id = @team_id;
    33  
    34  -- name: TeamsForChartGet :many
    35  SELECT DISTINCT ON (team_id) team_id
    36  FROM chart_team_values
    37  WHERE chart_type = @chart_type;
    38  
    39  -- name: ChartDelete :exec
    40  DELETE FROM chart_team_values
    41  WHERE team_id = @team_id AND chart_type = @chart_type;