remove duplicate staff entries from qa_staff

shared/workspaces/alembic/versions/68a8ad53ad74_change_qa_terminology.py

@@ -41,6 +41,33 @@ def upgrade():
         WHERE "group" = 'DA';
         """
     )
+
+    # Remove duplicate entries
+    op.execute(
+        """
+        CREATE TABLE qa_staff_tmp (LIKE qa_staff);
+        """
+    )
+    op.execute(
+        """
+        INSERT INTO qa_staff_tmp(user_name, "group", available, email)
+        SELECT
+            DISTINCT ON (user_name, "group") user_name, "group", available, email
+        FROM qa_staff;
+        """
+    )
+    op.execute(
+        """
+        DROP TABLE qa_staff;
+        """
+    )
+    op.execute(
+        """
+        ALTER TABLE qa_staff_tmp
+        RENAME TO qa_staff;
+        """
+    )
+    # Put back unique constraint
     op.execute(
         """
         ALTER TABLE qa_staff

[Daniel Lyons]

I haven't seen DISTINCT ON before, that's cool!

[Charlotte Hausman]

I hadn't before either, very useful that