diff options
| author | rubenwardy <rw@rubenwardy.com> | 2020-09-01 14:57:03 +0100 |
|---|---|---|
| committer | rubenwardy <rw@rubenwardy.com> | 2020-09-01 14:57:03 +0100 |
| commit | 5b086bb55901ccaed26ce44f90037d5903e515c1 (patch) | |
| tree | 8febfb280d9b7ee1adaff551980433aa0cc426e5 /migrations | |
| parent | 934d5817376a072cf97e69d4dfa925cdbd466464 (diff) | |
| download | cheatdb-5b086bb55901ccaed26ce44f90037d5903e515c1.tar.xz | |
Fix migration error when migrating from scratch
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() |