DT
Drizzle Team•11mo ago
x03

Need help with a migration

This was my old enum: 
export const securityEnum = pgEnum("security", ["none", "minimal", "regular", "advanced"])
export const securityEnum = pgEnum("security", ["none", "minimal", "regular", "advanced"])
And this is my new one: 
export const securityEnum = pgEnum("security", ["none", "hwid", "hwid_ip"])
export const securityEnum = pgEnum("security", ["none", "hwid", "hwid_ip"])
I ran generate --custom to make a blank migration file, and wrote this custom script: 
ALTER TYPE "security" ADD VALUE 'hwid';

--> statement-breakpoint
ALTER TYPE "security" ADD VALUE 'hwid_ip';

--> statement-breakpoint
COMMIT;

--> statement-breakpoint
UPDATE apps
SET
  security = 'hwid'
WHERE
  security = 'minimal';

--> statement-breakpoint
UPDATE apps
SET
  security = 'hwid_ip'
WHERE
  security IN ('regular', 'advanced');

--> statement-breakpoint
ALTER TYPE "security"
DROP VALUE 'minimal';

--> statement-breakpoint
ALTER TYPE "security"
DROP VALUE 'regular';

--> statement-breakpoint
ALTER TYPE "security"
DROP VALUE 'advanced';

--> statement-breakpoint
ALTER TABLE "apps"
ALTER COLUMN "security"
SET DEFAULT 'hwid_ip';
ALTER TYPE "security" ADD VALUE 'hwid';

--> statement-breakpoint
ALTER TYPE "security" ADD VALUE 'hwid_ip';

--> statement-breakpoint
COMMIT;

--> statement-breakpoint
UPDATE apps
SET
  security = 'hwid'
WHERE
  security = 'minimal';

--> statement-breakpoint
UPDATE apps
SET
  security = 'hwid_ip'
WHERE
  security IN ('regular', 'advanced');

--> statement-breakpoint
ALTER TYPE "security"
DROP VALUE 'minimal';

--> statement-breakpoint
ALTER TYPE "security"
DROP VALUE 'regular';

--> statement-breakpoint
ALTER TYPE "security"
DROP VALUE 'advanced';

--> statement-breakpoint
ALTER TABLE "apps"
ALTER COLUMN "security"
SET DEFAULT 'hwid_ip';
Sadly, this did not work and I get this output in my terminal:
No description
1 Reply
x03
x03OP•11mo ago
The first two objects output by the terminal always get printed when I run my server because I run my migration script on server startup. I'm not sure what they mean but I always assumed it just meant that a migration already exists, therefore it will not migrate again.

Did you find this page helpful?