refactor(db): make the PullRequestState enum more logic
+ 21
- 2
new file
db/migrations/20220929231118_refactor_pull_request_state_enum_values/migration.sql
@@ -0,0 +1,19 @@
+/*
+  Warnings:
+
+  - The values [CLOSE_COMPLETE,CLOSE_DENY] on the enum `PullRequestState` will be removed. If these variants are still used in the database, this will fail.
+
+*/
+-- AlterEnum
+BEGIN;
+CREATE TYPE "PullRequestState_new" AS ENUM ('OPEN', 'CLOSE_MERGED', 'CLOSE_DENIED');
+ALTER TABLE "PullRequest" ALTER COLUMN "state" DROP DEFAULT;
+ALTER TABLE "PullRequest" ALTER COLUMN "state" TYPE "PullRequestState_new" USING ("state"::text::"PullRequestState_new");
+ALTER TYPE "PullRequestState" RENAME TO "PullRequestState_old";
+ALTER TYPE "PullRequestState_new" RENAME TO "PullRequestState";
+DROP TYPE "PullRequestState_old";
+ALTER TABLE "PullRequest" ALTER COLUMN "state" SET DEFAULT 'OPEN';
+COMMIT;
+
+-- DropIndex
+DROP INDEX "Repository_organizationId_slug_key";

@@ -166,8 +166,8 @@ enum OrganizationRole {
 
 enum PullRequestState {
   OPEN
-  CLOSE_COMPLETE
-  CLOSE_DENY
+  CLOSE_MERGED
+  CLOSE_DENIED
 }
 
 enum ResourceVisibility {