PR#903: Adding on delete cascade for table build - copr/copr

Silvie Chlupova • 5 years ago

a2aa488

Silvie Chlupova • 5 years ago

51c5d9e

file added

+24

		`@@ -0,0 +1,24 @@`
		`+ """`
		`+ on delete cascade for table build`
		`+`
		`+ Revision ID: 3cba3ffe2836`
		`+ Revises: 55a07cb7bd68`
		`+ Create Date: 2019-08-05 10:36:41.354582`
		`+ """`
		`+`
		`+ import sqlalchemy as sa`
		`+ from alembic import op`
		`+`
		`+`
		`+ revision = '3cba3ffe2836'`
		`+ down_revision = '55a07cb7bd68'`
		`+`
		`+`
		`+ def upgrade():`
		`+ op.drop_constraint('build_chroot_build_id_fkey', 'build_chroot', type_='foreignkey')`
		`+ op.create_foreign_key('build_chroot_build_id_fkey', 'build_chroot', 'build', ['build_id'], ['id'], ondelete='CASCADE')`
		`+`
		`+`
		`+ def downgrade():`
		`+ op.drop_constraint('build_chroot_build_id_fkey', 'build_chroot', type_='foreignkey')`
		`+ op.create_foreign_key('build_chroot_build_id_fkey', 'build_chroot', 'build', ['build_id'], ['id'])`

file modified

-3

		`@@ -1055,9 +1055,6 @@`
		`if send_delete_action:`
		`ActionsLogic.send_delete_build(build)`

		`- for build_chroot in build.build_chroots:`
		`- db.session.delete(build_chroot)`
		`-`
		`db.session.delete(build)`

		`@classmethod`

frontend/coprs_frontend/coprs/models.py

file modified

+3 -2

		`@@ -1302,9 +1302,10 @@`
		`mock_chroot_id = db.Column(db.Integer, db.ForeignKey("mock_chroot.id"),`
		`primary_key=True)`
		`mock_chroot = db.relationship("MockChroot", backref=db.backref("builds"))`
		`- build_id = db.Column(db.Integer, db.ForeignKey("build.id"),`
		`+ build_id = db.Column(db.Integer, db.ForeignKey("build.id", ondelete="CASCADE"),`
		`primary_key=True)`
		`- build = db.relationship("Build", backref=db.backref("build_chroots"))`
		`+ build = db.relationship("Build", backref=db.backref("build_chroots", cascade="all, delete-orphan",`
		`+ passive_deletes=True))`
		`git_hash = db.Column(db.String(40))`
		`status = db.Column(db.Integer, default=StatusEnum("waiting"))`