Skip to content
Snippets Groups Projects

remove duplicate staff entries from qa_staff

Merged Charlotte Hausman requested to merge remove_duplicate_staff into main
1 unresolved thread

Merge request reports

Loading
Loading

Activity

Filter activity
  • Approvals
  • Assignees & reviewers
  • Comments (from bots)
  • Comments (from users)
  • Commits & branches
  • Edits
  • Labels
  • Lock status
  • Mentions
  • Merge request status
  • Tracking
41 41 WHERE "group" = 'DA';
42 42 """
43 43 )
44
45 # Remove duplicate entries
46 op.execute(
47 """
48 CREATE TABLE qa_staff_tmp (LIKE qa_staff);
49 """
50 )
51 op.execute(
52 """
53 INSERT INTO qa_staff_tmp(user_name, "group", available, email)
54 SELECT
55 DISTINCT ON (user_name, "group") user_name, "group", available, email
  • Daniel Lyons approved this merge request

    approved this merge request

  • Brittany Faciane approved this merge request

    approved this merge request

  • Daniel Nemergut approved this merge request

    approved this merge request

  • Charlotte Hausman enabled an automatic merge when the pipeline for 3a04f4e9 succeeds

    enabled an automatic merge when the pipeline for 3a04f4e9 succeeds

  • Nathan Bockisch approved this merge request

    approved this merge request

  • Please register or sign in to reply
    Loading