From 5b086bb55901ccaed26ce44f90037d5903e515c1 Mon Sep 17 00:00:00 2001 From: rubenwardy Date: Tue, 1 Sep 2020 14:57:03 +0100 Subject: Fix migration error when migrating from scratch --- migrations/versions/c141a63b2487_.py | 10 ---------- migrations/versions/cb6ab141c522_.py | 3 +-- 2 files changed, 1 insertion(+), 12 deletions(-) (limited to 'migrations') diff --git a/migrations/versions/c141a63b2487_.py b/migrations/versions/c141a63b2487_.py index 571eef6..a5d7297 100644 --- a/migrations/versions/c141a63b2487_.py +++ b/migrations/versions/c141a63b2487_.py @@ -21,16 +21,6 @@ depends_on = None def upgrade(): op.add_column('package', sa.Column('downloads', sa.Integer(), nullable=False, server_default="0")) - bind = op.get_bind() - session = orm.Session(bind=bind) - - for package in session.query(Package).all(): - downloads_result = session.query(func.sum(PackageRelease.downloads)).filter_by(package_id=package.id).one_or_none() - downloads = 0 if not downloads_result or not downloads_result[0] else downloads_result[0] - package.downloads = downloads - - session.commit() - def downgrade(): # ### commands auto generated by Alembic - please adjust! ### diff --git a/migrations/versions/cb6ab141c522_.py b/migrations/versions/cb6ab141c522_.py index 33da88b..be0378b 100644 --- a/migrations/versions/cb6ab141c522_.py +++ b/migrations/versions/cb6ab141c522_.py @@ -31,8 +31,7 @@ def upgrade(): bind = op.get_bind() session = orm.Session(bind=bind) - for package in session.query(Package).all(): - package.maintainers.append(package.author) + op.execute('INSERT INTO maintainers (package_id, user_id) SELECT id, author_id FROM package;') session.commit() -- cgit v1.2.3