8957d4adbc77_rename_manager_group.downgrade() - Code Metrics - Inspection of "rename manager group" - tracim/tracim_v2 - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — develop ( 297c7c...ca43ab )

by Bastien

created 2018-09-20 10:43 UTC

8957d4adbc77_rename_manager_group.downgrade() A

↳ Parent: 8957d4adbc77_rename_manager_group

Complexity

Conditions

Size

Total Lines	9
Code Lines	9

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
eloc	9
dl	0
loc	9
rs	9.95
c	0
b	0
f	0
cc	1
nop	0

"""rename_manager_group

Revision ID: 8957d4adbc77
Revises: c223cce1a413
Create Date: 2018-09-20 10:56:29.173246

"""

# revision identifiers, used by Alembic.
from datetime import datetime

revision = '8957d4adbc77'
down_revision = 'c223cce1a413'

from alembic import op
import sqlalchemy as sa

group = sa.Table(
    'groups',
    sa.MetaData(),
    sa.Column('group_id', sa.Integer, sa.Sequence('seq__groups__group_id'),
              autoincrement=True, primary_key=True),
    sa.Column('group_name', sa.Unicode(16), unique=True, nullable=False),
    sa.Column('display_name', sa.Unicode(255)),
    sa.Column('created', sa.DateTime, default=datetime.utcnow),
)


def upgrade():
    connection = op.get_bind()
    connection.execute(
        group.update()
        .where(
            group.c.group_name == 'managers'
        ).values(
            group_name='trusted-users',
            display_name='Trusted Users',
        )
    )


def downgrade():
    connection = op.get_bind()
    connection.execute(
        group.update()
        .where(
            group.c.group_name == 'trusted-users'
        ).values(
            group_name='managers',
            display_name='Global Managers',
        )
    )
    # ### end Alembic commands ###


1			"""rename_manager_group
2
3			Revision ID: 8957d4adbc77
4			Revises: c223cce1a413
5			Create Date: 2018-09-20 10:56:29.173246
6
7			"""
8
9			# revision identifiers, used by Alembic.
10			from datetime import datetime
11
12			revision = '8957d4adbc77'
13			down_revision = 'c223cce1a413'
14
15			from alembic import op
16			import sqlalchemy as sa
17
18			group = sa.Table(
19			'groups',
20			sa.MetaData(),
21			sa.Column('group_id', sa.Integer, sa.Sequence('seq__groups__group_id'),
22			autoincrement=True, primary_key=True),
23			sa.Column('group_name', sa.Unicode(16), unique=True, nullable=False),
24			sa.Column('display_name', sa.Unicode(255)),
25			sa.Column('created', sa.DateTime, default=datetime.utcnow),
26			)
27
28
29			def upgrade():
30			connection = op.get_bind()
31			connection.execute(
32			group.update()
33			.where(
34			group.c.group_name == 'managers'
35			).values(
36			group_name='trusted-users',
37			display_name='Trusted Users',
38			)
39			)
40
41
42			def downgrade():
43			connection = op.get_bind()
44			connection.execute(
45			group.update()
46			.where(
47			group.c.group_name == 'trusted-users'
48			).values(
49			group_name='managers',
50			display_name='Global Managers',
51			)
52			)
53			# ### end Alembic commands ###
54

tracim / tracim_v2

Push — develop ( 297c7c...ca43ab )

8957d4adbc77_rename_manager_group.downgrade() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like