tortoise / aerich

A database migrations tool for TortoiseORM, ready to production.
https://github.com/tortoise/aerich
Apache License 2.0
823 stars 93 forks source link

Duplicated lines #143

Open Olegt0rr opened 3 years ago

Olegt0rr commented 3 years ago

Sometimes on migration aerich generates some lines for one action

My latest example:

-- upgrade --
ALTER TABLE "settings" ALTER COLUMN "description" TYPE TEXT USING "description"::TEXT;
ALTER TABLE "settings" ALTER COLUMN "description" TYPE TEXT USING "description"::TEXT;
ALTER TABLE "settings" ALTER COLUMN "description" TYPE TEXT USING "description"::TEXT;
ALTER TABLE "settings" ALTER COLUMN "str_value" SET DEFAULT '';
DROP INDEX "idx_settings_str_val_c015bf";
ALTER TABLE "settings" ALTER COLUMN "str_value" TYPE VARCHAR(255) USING "str_value"::VARCHAR(255);
ALTER TABLE "settings" ALTER COLUMN "str_value" TYPE VARCHAR(255) USING "str_value"::VARCHAR(255);
ALTER TABLE "settings" ALTER COLUMN "name" TYPE VARCHAR(64) USING "name"::VARCHAR(64);
-- downgrade --
ALTER TABLE "settings" ALTER COLUMN "description" TYPE VARCHAR(2000) USING "description"::VARCHAR(2000);
ALTER TABLE "settings" ALTER COLUMN "description" TYPE VARCHAR(2000) USING "description"::VARCHAR(2000);
ALTER TABLE "settings" ALTER COLUMN "description" TYPE VARCHAR(2000) USING "description"::VARCHAR(2000);
ALTER TABLE "settings" ALTER COLUMN "str_value" TYPE VARCHAR(4026) USING "str_value"::VARCHAR(4026);
CREATE INDEX "idx_settings_str_val_c015bf" ON "settings" ("str_value");
ALTER TABLE "settings" ALTER COLUMN "str_value" DROP DEFAULT;
ALTER TABLE "settings" ALTER COLUMN "str_value" TYPE VARCHAR(4026) USING "str_value"::VARCHAR(4026);
ALTER TABLE "settings" ALTER COLUMN "name" TYPE VARCHAR(255) USING "name"::VARCHAR(255);
long2ice commented 3 years ago

What's the detail?

FIRDOUS-BHAT commented 3 years ago

@long2ice I've opened the same kind of issue https://github.com/tortoise/aerich/issues/169#issue-920402848

long2ice commented 3 years ago

Fixed

FIRDOUS-BHAT commented 3 years ago

Is there a update of aerich?