PR#496: various fixes for releases - mostly add two indexes for performance - copr/copr

Miroslav Suchý • 5 years ago

e378d75

Miroslav Suchý • 5 years ago

b89fe2c

Miroslav Suchý • 5 years ago

6504e7f

file added

+25

		`@@ -0,0 +1,25 @@`
		`+ """add indexes`
		`+`
		`+ Revision ID: deaddeadc0de_add_indexes.py`
		`+ Revises: 10029c92dd0d`
		`+ Create Date: 2018-06-27 14:43:00.000000`
		`+`
		`+ """`
		`+`
		`+ # revision identifiers, used by Alembic.`
		`+ revision = 'deaddeadc0de'`
		`+ down_revision = '8bf844cc7135'`
		`+`
		`+ from alembic import op`
		`+ import sqlalchemy as sa`
		`+`
		`+`
		`+ def upgrade():`
		`+ op.create_index('build_copr_id', 'build', ['copr_id'], unique=False)`
		`+ op.create_index('build_chroot_status_started_on_idx', 'build_chroot', ['status', 'started_on'], unique=False)`
		`+ ### end Alembic commands ###`
		`+`
		`+`
		`+ def downgrade():`
		`+ op.drop_index('build_status_started_on_idx', table_name='build')`
		`+ op.drop_index('build_copr_id', table_name='build')`

frontend/coprs_frontend/coprs/models.py

file modified

+3 -1

		`@@ -701,7 +701,7 @@`
		`# relations`
		`user_id = db.Column(db.Integer, db.ForeignKey("user.id"))`
		`user = db.relationship("User", backref=db.backref("builds"))`
		`- copr_id = db.Column(db.Integer, db.ForeignKey("copr.id"))`
		`+ copr_id = db.Column(db.Integer, db.ForeignKey("copr.id"), index=True)`
		`copr = db.relationship("Copr", backref=db.backref("builds"))`
		`package_id = db.Column(db.Integer, db.ForeignKey("package.id"))`
		`package = db.relationship("Package")`
		`@@ -1128,6 +1128,8 @@`
		`Representation of Build<->MockChroot relation`
		`"""`

		`+ __table_args__ = (db.Index('build_chroot_status_started_on_idx', "status", "started_on"),)`
		`+`
		`mock_chroot_id = db.Column(db.Integer, db.ForeignKey("mock_chroot.id"),`
		`primary_key=True)`
		`mock_chroot = db.relationship("MockChroot", backref=db.backref("builds"))`

file modified

file modified

+1 -1

		`@@ -1,4 +1,4 @@`
		`- #! /bin/sh -x`
		`+ #!/usr/bin/bash -x`

		`opt_static_files=coprs_frontend/coprs/static`
		`opt_base_color='#214d8b'`

file modified

+1 -1

		`@@ -1,4 +1,4 @@`
		`- #!/bin/bash`
		`+ #!/usr/bin/bash`
		`# Purpose of this script is to be remotely executed from batcave01`
		`# to collect user SAR data`
		`# Read more: http://fedora-infra-docs.readthedocs.io/en/latest/sysadmin-guide/sops/gdpr_sar.html`