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;