3 Revision ID: c141a63b2487
5 Create Date: 2020-07-09 00:05:39.845465
9 import sqlalchemy as sa
10 from sqlalchemy import orm, func
11 from app.models import Package, PackageRelease
14 # revision identifiers, used by Alembic.
15 revision = 'c141a63b2487'
16 down_revision = 'cb6ab141c522'
22 op.add_column('package', sa.Column('downloads', sa.Integer(), nullable=False, server_default="0"))
25 session = orm.Session(bind=bind)
27 for package in session.query(Package).all():
28 downloads_result = session.query(func.sum(PackageRelease.downloads)).filter_by(package_id=package.id).one_or_none()
29 downloads = 0 if not downloads_result or not downloads_result[0] else downloads_result[0]
30 package.downloads = downloads
36 # ### commands auto generated by Alembic - please adjust! ###
37 op.drop_column('package', 'downloads')
38 # ### end Alembic commands ###