1a4d62b02630_199_sources.downgrade() - Code Metrics - OnroerendErfgoed/atramhasis - Measure and Improve Code Quality continuously with Scrutinizer

1a4d62b02630_199_sources.downgrade() A
last analyzed 2025-11-27 15:12 UTC

↳ Parent: 1a4d62b02630_199_sources

Complexity

Conditions

Size

Total Lines	5
Code Lines	4

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
eloc	4
dl	0
loc	5
rs	10
c	0
b	0
f	0
cc	1
nop	0

"""199 Sources.

Revision ID: 1a4d62b02630
Revises: 2a38d364113b
Create Date: 2015-12-08 12:06:20.303601

"""
import sqlalchemy as sa
from alembic import op

# revision identifiers, used by Alembic.
revision = "1a4d62b02630"
down_revision = "2a38d364113b"


def upgrade():

    op.create_table(
        "source",
        sa.Column("id", sa.Integer(), nullable=False),
        sa.Column("citation", sa.Text(), nullable=False),
        sa.PrimaryKeyConstraint("id"),
    )

    op.create_table(
        "conceptscheme_source",
        sa.Column("conceptscheme_id", sa.Integer(), nullable=False),
        sa.Column("source_id", sa.Integer(), nullable=False),
        sa.ForeignKeyConstraint(
            ["conceptscheme_id"],
            ["conceptscheme.id"],
        ),
        sa.ForeignKeyConstraint(
            ["source_id"],
            ["source.id"],
        ),
        sa.PrimaryKeyConstraint("conceptscheme_id", "source_id"),
    )

    op.create_table(
        "concept_source",
        sa.Column("concept_id", sa.Integer(), nullable=False),
        sa.Column("source_id", sa.Integer(), nullable=False),
        sa.ForeignKeyConstraint(
            ["concept_id"],
            ["concept.id"],
        ),
        sa.ForeignKeyConstraint(
            ["source_id"],
            ["source.id"],
        ),
        sa.PrimaryKeyConstraint("concept_id", "source_id"),
    )


def downgrade():

    op.drop_table("conceptscheme_source")
    op.drop_table("concept_source")
    op.drop_table("source")


1			"""199 Sources.
2
3			Revision ID: 1a4d62b02630
4			Revises: 2a38d364113b
5			Create Date: 2015-12-08 12:06:20.303601
6
7			"""
8			import sqlalchemy as sa
9			from alembic import op
10
11			# revision identifiers, used by Alembic.
12			revision = "1a4d62b02630"
13			down_revision = "2a38d364113b"
14
15
16			def upgrade():
17
18			op.create_table(
19			"source",
20			sa.Column("id", sa.Integer(), nullable=False),
21			sa.Column("citation", sa.Text(), nullable=False),
22			sa.PrimaryKeyConstraint("id"),
23			)
24
25			op.create_table(
26			"conceptscheme_source",
27			sa.Column("conceptscheme_id", sa.Integer(), nullable=False),
28			sa.Column("source_id", sa.Integer(), nullable=False),
29			sa.ForeignKeyConstraint(
30			["conceptscheme_id"],
31			["conceptscheme.id"],
32			),
33			sa.ForeignKeyConstraint(
34			["source_id"],
35			["source.id"],
36			),
37			sa.PrimaryKeyConstraint("conceptscheme_id", "source_id"),
38			)
39
40			op.create_table(
41			"concept_source",
42			sa.Column("concept_id", sa.Integer(), nullable=False),
43			sa.Column("source_id", sa.Integer(), nullable=False),
44			sa.ForeignKeyConstraint(
45			["concept_id"],
46			["concept.id"],
47			),
48			sa.ForeignKeyConstraint(
49			["source_id"],
50			["source.id"],
51			),
52			sa.PrimaryKeyConstraint("concept_id", "source_id"),
53			)
54
55
56			def downgrade():
57
58			op.drop_table("conceptscheme_source")
59			op.drop_table("concept_source")
60			op.drop_table("source")
61

OnroerendErfgoed / atramhasis

1a4d62b02630_199_sources.downgrade() A last analyzed 2025-11-27 15:12 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

1a4d62b02630_199_sources.downgrade() A
last analyzed 2025-11-27 15:12 UTC