diff options
Diffstat (limited to 'migrations')
| -rw-r--r-- | migrations/versions/c141a63b2487_.py | 10 | ||||
| -rw-r--r-- | migrations/versions/cb6ab141c522_.py | 3 |
2 files changed, 1 insertions, 12 deletions
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() |