def upgrade():
if context.is_offline_mode():
raise Exception('This upgrade is only possible in online mode')
json_to_acl(acl_settings)
def upgrade():
if context.is_offline_mode():
raise Exception('This upgrade is only possible in online mode')
op.create_table(
'settings_principals',
sa.Column('type', PyIntEnum(PrincipalType), nullable=True),
sa.Column('mp_group_provider', sa.String(), nullable=True),
sa.Column('mp_group_name', sa.String(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('module', sa.String(), nullable=False),
sa.Column('name', sa.String(), nullable=False),
sa.Column('event_id', sa.String(), nullable=False),
sa.Column('user_id', sa.Integer(), nullable=True),
sa.Column('local_group_id', sa.Integer(), nullable=True),
sa.CheckConstraint('module = lower(module)', name='lowercase_module'),
sa.CheckConstraint('name = lower(name)', name='lowercase_name'),
sa.CheckConstraint(
'type != 1 OR (mp_group_provider IS NULL AND local_group_id IS NULL '
'AND mp_group_name IS NULL AND user_id IS NOT NULL)',
name='valid_user'),
sa.CheckConstraint(
'type != 2 OR (mp_group_provider IS NULL AND mp_group_name IS NULL '
'AND user_id IS NULL AND local_group_id IS NOT NULL)',
name='valid_local_group'),
sa.CheckConstraint(
'type != 3 OR (local_group_id IS NULL AND user_id IS NULL AND mp_group_provider IS NOT NULL AND '
'mp_group_name IS NOT NULL)',
name='valid_mp_group'),
sa.ForeignKeyConstraint(['local_group_id'], ['users.groups.id']),
sa.ForeignKeyConstraint(['user_id'], ['users.users.id']),
sa.PrimaryKeyConstraint('id'),
schema='events')
op.create_index(None, 'settings_principals', ['event_id'], schema='events')
op.create_index(None,
'settings_principals', ['event_id', 'module'],
schema='events')
op.create_index(None,
'settings_principals', ['event_id', 'module', 'name'],
schema='events')
op.create_index(None,
'settings_principals', ['local_group_id'],
schema='events')
op.create_index(None, 'settings_principals', ['module'], schema='events')
op.create_index(None,
'settings_principals',
['mp_group_provider', 'mp_group_name'],
schema='events')
op.create_index(None, 'settings_principals', ['name'], schema='events')
op.create_index(None, 'settings_principals', ['user_id'], schema='events')
op.create_table(
'settings_principals',
sa.Column('type', PyIntEnum(PrincipalType), nullable=True),
sa.Column('mp_group_provider', sa.String(), nullable=True),
sa.Column('mp_group_name', sa.String(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('module', sa.String(), nullable=False),
sa.Column('name', sa.String(), nullable=False),
sa.Column('user_id', sa.Integer(), nullable=True),
sa.Column('local_group_id', sa.Integer(), nullable=True),
sa.CheckConstraint('module = lower(module)', name='lowercase_module'),
sa.CheckConstraint('name = lower(name)', name='lowercase_name'),
sa.CheckConstraint(
'type != 1 OR (mp_group_provider IS NULL AND local_group_id IS NULL AND '
'mp_group_name IS NULL AND user_id IS NOT NULL)',
name='valid_user'),
sa.CheckConstraint(
'type != 2 OR (mp_group_provider IS NULL AND mp_group_name IS NULL AND '
'user_id IS NULL AND local_group_id IS NOT NULL)',
name='valid_local_group'),
sa.CheckConstraint(
'type != 3 OR (local_group_id IS NULL AND user_id IS NULL AND mp_group_provider IS NOT NULL AND '
'mp_group_name IS NOT NULL)',
name='valid_mp_group'),
sa.ForeignKeyConstraint(['local_group_id'], ['users.groups.id']),
sa.ForeignKeyConstraint(['user_id'], ['users.users.id']),
sa.PrimaryKeyConstraint('id'),
schema='indico')
op.create_index(None, 'settings_principals', ['module'], schema='indico')
op.create_index(None, 'settings_principals', ['name'], schema='indico')
op.create_index(None,
'settings_principals', ['module', 'name'],
schema='indico')
op.create_index(None, 'settings_principals', ['user_id'], schema='indico')
op.create_index(None,
'settings_principals', ['local_group_id'],
schema='indico')
op.create_index(None,
'settings_principals',
['mp_group_provider', 'mp_group_name'],
schema='indico')
json_to_acl(acl_settings)
def upgrade():
if context.is_offline_mode():
raise Exception('This upgrade is only possible in online mode')
op.create_table(
'settings_principals',
sa.Column('type', PyIntEnum(PrincipalType), nullable=True),
sa.Column('mp_group_provider', sa.String(), nullable=True),
sa.Column('mp_group_name', sa.String(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('module', sa.String(), nullable=False),
sa.Column('name', sa.String(), nullable=False),
sa.Column('event_id', sa.String(), nullable=False),
sa.Column('user_id', sa.Integer(), nullable=True),
sa.Column('local_group_id', sa.Integer(), nullable=True),
sa.CheckConstraint('module = lower(module)', name='lowercase_module'),
sa.CheckConstraint('name = lower(name)', name='lowercase_name'),
sa.CheckConstraint(
'type != 1 OR (mp_group_provider IS NULL AND local_group_id IS NULL '
'AND mp_group_name IS NULL AND user_id IS NOT NULL)',
name='valid_user'),
sa.CheckConstraint(
'type != 2 OR (mp_group_provider IS NULL AND mp_group_name IS NULL '
'AND user_id IS NULL AND local_group_id IS NOT NULL)',
name='valid_local_group'),
sa.CheckConstraint(
'type != 3 OR (local_group_id IS NULL AND user_id IS NULL AND mp_group_provider IS NOT NULL AND '
'mp_group_name IS NOT NULL)',
name='valid_mp_group'),
sa.ForeignKeyConstraint(['local_group_id'], ['users.groups.id']),
sa.ForeignKeyConstraint(['user_id'], ['users.users.id']),
sa.PrimaryKeyConstraint('id'),
schema='events'
)
op.create_index(None, 'settings_principals', ['event_id'], schema='events')
op.create_index(None, 'settings_principals', ['event_id', 'module'], schema='events')
op.create_index(None, 'settings_principals', ['event_id', 'module', 'name'], schema='events')
op.create_index(None, 'settings_principals', ['local_group_id'], schema='events')
op.create_index(None, 'settings_principals', ['module'], schema='events')
op.create_index(None, 'settings_principals', ['mp_group_provider', 'mp_group_name'], schema='events')
op.create_index(None, 'settings_principals', ['name'], schema='events')
op.create_index(None, 'settings_principals', ['user_id'], schema='events')
op.create_table(
'settings_principals',
sa.Column('type', PyIntEnum(PrincipalType), nullable=True),
sa.Column('mp_group_provider', sa.String(), nullable=True),
sa.Column('mp_group_name', sa.String(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('module', sa.String(), nullable=False),
sa.Column('name', sa.String(), nullable=False),
sa.Column('user_id', sa.Integer(), nullable=True),
sa.Column('local_group_id', sa.Integer(), nullable=True),
sa.CheckConstraint('module = lower(module)', name='lowercase_module'),
sa.CheckConstraint('name = lower(name)', name='lowercase_name'),
sa.CheckConstraint(
'type != 1 OR (mp_group_provider IS NULL AND local_group_id IS NULL AND '
'mp_group_name IS NULL AND user_id IS NOT NULL)',
name='valid_user'
),
sa.CheckConstraint(
'type != 2 OR (mp_group_provider IS NULL AND mp_group_name IS NULL AND '
'user_id IS NULL AND local_group_id IS NOT NULL)',
name='valid_local_group'
),
sa.CheckConstraint(
'type != 3 OR (local_group_id IS NULL AND user_id IS NULL AND mp_group_provider IS NOT NULL AND '
'mp_group_name IS NOT NULL)',
name='valid_mp_group'
),
sa.ForeignKeyConstraint(['local_group_id'], ['users.groups.id']),
sa.ForeignKeyConstraint(['user_id'], ['users.users.id']),
sa.PrimaryKeyConstraint('id'),
schema='indico'
)
op.create_index(None, 'settings_principals', ['module'], schema='indico')
op.create_index(None, 'settings_principals', ['name'], schema='indico')
op.create_index(None, 'settings_principals', ['module', 'name'], schema='indico')
op.create_index(None, 'settings_principals', ['user_id'], schema='indico')
op.create_index(None, 'settings_principals', ['local_group_id'], schema='indico')
op.create_index(None, 'settings_principals', ['mp_group_provider', 'mp_group_name'], schema='indico')
json_to_acl(acl_settings)
