#148 db: add index on package(webhook_rebuild, source_type) and copr(copr_webhook_secret)
Merged 6 years ago by clime. Opened 6 years ago by msuchy.
copr/ msuchy/copr addindex  into  master

@@ -0,0 +1,23 @@ 

+ """add web_hook,source_type index

+ 

+ Revision ID: fdec9947f8a1

+ Revises: 669ba46bf357

+ Create Date: 2017-10-11 13:45:59.512011

+ 

+ """

+ 

+ # revision identifiers, used by Alembic.

+ revision = 'fdec9947f8a1'

+ down_revision = '669ba46bf357'

+ 

+ from alembic import op

+ import sqlalchemy as sa

+ 

+ 

+ def upgrade():

+     op.create_index('package_webhook_sourcetype', 'package', ['webhook_rebuild', 'source_type'])

+     op.create_index('copr_webhook_secret', 'copr', ['webhook_secret'])

+ 

+ def downgrade():

+     op.drop_index('package_webhook_sourcetype')

+     op.drop_index('copr_webhook_secret')

@@ -183,6 +183,10 @@ 

      Represents a single copr (private repo with builds, mock chroots, etc.).

      """

  

+     __table_args__ = (

+         db.Index('copr_webhook_secret', 'webhook_secret'),

+     )

+ 

      id = db.Column(db.Integer, primary_key=True)

      # name of the copr, no fancy chars (checked by forms)

      name = db.Column(db.String(100), nullable=False)
@@ -406,6 +410,7 @@ 

      """

      __table_args__ = (

          db.UniqueConstraint('copr_id', 'name', name='packages_copr_pkgname'),

+         db.Index('package_webhook_sourcetype', 'webhook_rebuild', 'source_type'),

      )

  

      id = db.Column(db.Integer, primary_key=True)