def upgrade():
op.add_column(
"asset",
sa.Column(
"event_resolution",
sa.Interval(),
nullable=False,
server_default=str(timedelta(minutes=0)),
),
)
op.add_column(
"market",
sa.Column(
"event_resolution",
sa.Interval(),
nullable=False,
server_default=str(timedelta(minutes=0)),
),
)
op.add_column(
"weather_sensor",
sa.Column(
"event_resolution",
sa.Interval(),
nullable=False,
server_default=str(timedelta(minutes=0)),
),
)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('sports',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('label', sa.String(length=50), nullable=False),
sa.Column('img', sa.String(length=255), nullable=True),
sa.Column('is_default', sa.Boolean(), default=False, nullable=False),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('label')
)
op.create_table('activities',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('user_id', sa.Integer(), nullable=False),
sa.Column('sport_id', sa.Integer(), nullable=False),
sa.Column('title', sa.String(length=255), nullable=True),
sa.Column('gpx', sa.String(length=255), nullable=True),
sa.Column('creation_date', sa.DateTime(), nullable=True),
sa.Column('modification_date', sa.DateTime(), nullable=True),
sa.Column('activity_date', sa.DateTime(), nullable=False),
sa.Column('duration', sa.Interval(), nullable=False),
sa.Column('pauses', sa.Interval(), nullable=True),
sa.Column('moving', sa.Interval(), nullable=True),
sa.Column('distance', sa.Numeric(precision=6, scale=3), nullable=True),
sa.Column('min_alt', sa.Numeric(precision=6, scale=2), nullable=True),
sa.Column('max_alt', sa.Numeric(precision=6, scale=2), nullable=True),
sa.Column('descent', sa.Numeric(precision=7, scale=2), nullable=True),
sa.Column('ascent', sa.Numeric(precision=7, scale=2), nullable=True),
sa.Column('max_speed', sa.Numeric(precision=6, scale=2), nullable=True),
sa.Column('ave_speed', sa.Numeric(precision=6, scale=2), nullable=True),
sa.ForeignKeyConstraint(['sport_id'], ['sports.id'], ),
sa.ForeignKeyConstraint(['user_id'], ['users.id'], ),
sa.PrimaryKeyConstraint('id')
)
def upgrade():
op.create_table(
"contest_legs",
sa.Column("id", sa.Integer(), nullable=False),
sa.Column("flight_id", sa.Integer(), nullable=False),
sa.Column("contest_type", sa.String(), nullable=False),
sa.Column("trace_type", sa.String(), nullable=False),
sa.Column("distance", sa.Integer(), nullable=True),
sa.Column("cruise_height", sa.Integer(), nullable=True),
sa.Column("cruise_distance", sa.Integer(), nullable=True),
sa.Column("cruise_duration", sa.Interval(), nullable=True),
sa.Column("climb_height", sa.Integer(), nullable=True),
sa.Column("climb_duration", sa.Interval(), nullable=True),
sa.Column("start_height", sa.Integer(), nullable=True),
sa.Column("end_height", sa.Integer(), nullable=True),
sa.Column("start_time", sa.DateTime(), nullable=False),
sa.Column("end_time", sa.DateTime(), nullable=False),
sa.Column("start_location",
Geometry(geometry_type="POINT", srid=4326),
nullable=True),
sa.Column("end_location",
Geometry(geometry_type="POINT", srid=4326),
nullable=True),
sa.ForeignKeyConstraint(["flight_id"], ["flights.id"],
ondelete="CASCADE"),
sa.PrimaryKeyConstraint("id"),
)
op.create_index("ix_contest_legs_flight_id",
"contest_legs", ["flight_id"],
unique=False)
def upgrade():
op.create_table(
'contest_legs', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('flight_id', sa.Integer(), nullable=False),
sa.Column('contest_type', sa.String(), nullable=False),
sa.Column('trace_type', sa.String(), nullable=False),
sa.Column('distance', sa.Integer(), nullable=True),
sa.Column('cruise_height', sa.Integer(), nullable=True),
sa.Column('cruise_distance', sa.Integer(), nullable=True),
sa.Column('cruise_duration', sa.Interval(), nullable=True),
sa.Column('climb_height', sa.Integer(), nullable=True),
sa.Column('climb_duration', sa.Interval(), nullable=True),
sa.Column('start_height', sa.Integer(), nullable=True),
sa.Column('end_height', sa.Integer(), nullable=True),
sa.Column('start_time', sa.DateTime(), nullable=False),
sa.Column('end_time', sa.DateTime(), nullable=False),
sa.Column('start_location',
Geometry(geometry_type='POINT', srid=4326),
nullable=True),
sa.Column('end_location',
Geometry(geometry_type='POINT', srid=4326),
nullable=True),
sa.ForeignKeyConstraint(['flight_id'], ['flights.id'],
ondelete='CASCADE'),
sa.PrimaryKeyConstraint('id'))
op.create_index('ix_contest_legs_flight_id',
'contest_legs', ['flight_id'],
unique=False)
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
with op.batch_alter_table('price', schema=None) as batch_op:
batch_op.drop_column('modified_date')
batch_op.drop_column('created_date')
with op.batch_alter_table('platform', schema=None) as batch_op:
batch_op.drop_column('modified_date')
batch_op.drop_column('created_date')
with op.batch_alter_table('event_template', schema=None) as batch_op:
batch_op.alter_column('duration',
existing_type=sa.Interval(),
type_=sa.DATETIME(),
existing_nullable=False)
with op.batch_alter_table('event', schema=None) as batch_op:
batch_op.alter_column('duration',
existing_type=sa.Interval(),
type_=sa.DATETIME(),
existing_nullable=False)
with op.batch_alter_table('authorization', schema=None) as batch_op:
batch_op.drop_column('modified_date')
batch_op.drop_column('created_date')
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('tag',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('created_date', sa.DateTime(), nullable=True),
sa.Column('modified_date', sa.DateTime(), nullable=True),
sa.Column('name', sa.String(length=40), nullable=False),
sa.Column('parent_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['parent_id'], ['tag.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_table('event_tags',
sa.Column('tag_id', sa.Integer(), nullable=True),
sa.Column('event_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['event_id'], ['event.id'], ),
sa.ForeignKeyConstraint(['tag_id'], ['tag.id'], )
)
op.create_table('event_template_tags',
sa.Column('tag_id', sa.Integer(), nullable=True),
sa.Column('event_template_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['event_template_id'], ['event_template.id'], ),
sa.ForeignKeyConstraint(['tag_id'], ['tag.id'], )
)
with op.batch_alter_table('event', schema=None) as batch_op:
batch_op.alter_column('duration',
existing_type=sa.DATETIME(),
type_=sa.Interval(),
existing_nullable=False)
with op.batch_alter_table('event_template', schema=None) as batch_op:
batch_op.alter_column('duration',
existing_type=sa.DATETIME(),
type_=sa.Interval(),
existing_nullable=False)
class RecurringCard(Base):
__tablename__ = 'recurring_card'
id = sa.Column(sa.Integer(), primary_key=True)
title = sa.Column(sa.String(255))
description = sa.Column(sa.Text())
labels = sa.Column(sa.String(255))
board = sa.Column(sa.String(255))
list = sa.Column(sa.String(255))
start = sa.Column(UTCDateTime())
last_run = sa.Column(UTCDateTime())
frequency = sa.Column(sa.Interval())
frequency_kind = sa.Column(sa.Integer())
frequency_val = sa.Column(sa.Integer())
due_date_int = sa.Column(sa.Interval())
next_run = column_property(last_run + frequency)
user_id = sa.Column(sa.Integer(),
sa.ForeignKey('user.id', ondelete='CASCADE'),
nullable=False)
user = sa.orm.relationship('User')
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('project', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=40), nullable=False),
sa.Column('symbol', sa.String(length=3), nullable=True),
sa.Column('desc', sa.Text(), nullable=True),
sa.Column('category', sa.String(length=20), nullable=True),
sa.Column('color', sa.String(length=7), nullable=True),
sa.Column('order', sa.Integer(), nullable=True),
sa.Column('time_creation', sa.DateTime(), nullable=True),
sa.Column('time_completion', sa.DateTime(), nullable=True),
sa.Column('time_due', sa.DateTime(), nullable=True),
sa.Column('duration_plan', sa.Interval(), nullable=False),
sa.Column('show_timeline', sa.Boolean(), nullable=False),
sa.PrimaryKeyConstraint('id'))
op.create_table('strategy', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=40), nullable=False),
sa.Column('symbol', sa.String(length=3), nullable=True),
sa.Column('desc', sa.Text(), nullable=True),
sa.Column('color', sa.String(length=7), nullable=True),
sa.Column('order', sa.Integer(), nullable=True),
sa.Column('time_creation', sa.DateTime(), nullable=True),
sa.Column('time_completion', sa.DateTime(), nullable=True),
sa.Column('show_timeline', sa.Boolean(), nullable=False),
sa.Column('category', sa.String(length=20), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'task',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('name', sa.String(length=140), nullable=False),
sa.Column('desc', sa.Text(), nullable=True),
sa.Column('category', sa.String(length=20), nullable=True),
sa.Column('frequency', sa.String(length=10), nullable=True),
sa.Column('frequency_days', sa.Integer(), nullable=True),
sa.Column('time_creation', sa.DateTime(), nullable=True),
sa.Column('time_completion', sa.DateTime(), nullable=True),
sa.Column('time_due', sa.DateTime(), nullable=True),
sa.Column('time_line', sa.String(length=20), nullable=True),
sa.Column('duration_plan', sa.Interval(), nullable=False),
sa.Column('duration_real', sa.Interval(), nullable=False),
sa.Column('timer_start', sa.DateTime(), nullable=True),
sa.Column('order', sa.Integer(), nullable=True),
sa.Column('show_menu', sa.Boolean(), nullable=False),
sa.Column('id_strategy', sa.Integer(), nullable=False),
sa.Column('id_project', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['id_project'],
['project.id'],
), sa.ForeignKeyConstraint(
['id_strategy'],
['strategy.id'],
), sa.PrimaryKeyConstraint('id'))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
with op.batch_alter_table('event', schema=None) as batch_op:
batch_op.alter_column('duration',
existing_type=sa.DATETIME(),
type_=sa.Interval(),
existing_nullable=False)
with op.batch_alter_table('event_template', schema=None) as batch_op:
batch_op.alter_column('duration',
existing_type=sa.DATETIME(),
type_=sa.Interval(),
existing_nullable=False)
def upgrade():
op.add_column('membership_fee', sa.Column('booking_begin', sa.Interval(), nullable=True))
op.add_column('membership_fee', sa.Column('booking_end', sa.Interval(), nullable=True))
op.drop_column('membership_fee', 'grace_period')
membership_fee = sa.table('membership_fee',
sa.Column('booking_begin', sa.Interval(), nullable=False),
sa.Column('booking_end', sa.Interval(), nullable=False))
op.execute(membership_fee.update()
.values({'booking_begin': timedelta(days=2),
'booking_end': timedelta(days=14)}))
op.alter_column('membership_fee', sa.Column('booking_begin',nullable=False))
op.alter_column('membership_fee', sa.Column('booking_end', nullable=False))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column('tickets', sa.Column('andamento',
sa.Boolean(),
nullable=True))
op.add_column('tickets',
sa.Column('intervalo', sa.Interval(), nullable=True))
def upgrade():
op.create_table('job',
sa.Column('id', postgresql.UUID(), nullable=False),
sa.Column('command', sa.Text(), nullable=False),
sa.Column('options', postgresql.JSON(), nullable=True),
sa.Column('rlimits', postgresql.JSON(), nullable=True),
sa.Column('cwd', sa.Text(), nullable=False),
sa.Column('environment', postgresql.JSON(), nullable=True),
sa.Column('umask', sa.Integer(), nullable=True),
sa.Column('created_at', sa.DateTime(timezone=True), nullable=False),
sa.Column('lsf_job_id', sa.Integer(), nullable=True),
sa.Column('poll_after', sa.DateTime(), nullable=True),
sa.Column('polling_interval', sa.Interval(), nullable=False),
sa.Column('user', sa.Text(), nullable=False),
sa.Column('webhooks', postgresql.JSON(), nullable=False),
sa.PrimaryKeyConstraint('id', name=op.f('pk_job'))
)
op.create_index(op.f('ix_job_lsf_job_id'), 'job', ['lsf_job_id'], unique=False)
op.create_index(op.f('ix_job_poll_after'), 'job', ['poll_after'], unique=False)
op.create_index(op.f('ix_job_user'), 'job', ['user'], unique=False)
op.create_table('job_status_history',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('job_id', postgresql.UUID(), nullable=False),
sa.Column('timestamp', sa.DateTime(timezone=True), nullable=False),
sa.Column('status', sa.Text(), nullable=False),
sa.Column('lsf_primary_status', sa.Text(), nullable=True),
sa.Column('lsf_status_set', postgresql.JSON(), nullable=True),
sa.Column('message', sa.Text(), nullable=True),
sa.ForeignKeyConstraint(['job_id'], [u'job.id'], name=op.f('fk_job_status_history_job_id_job')),
sa.PrimaryKeyConstraint('id', name=op.f('pk_job_status_history'))
)
op.create_index(op.f('ix_job_status_history_lsf_primary_status'), 'job_status_history', ['lsf_primary_status'], unique=False)
op.create_index(op.f('ix_job_status_history_status'), 'job_status_history', ['status'], unique=False)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'card', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('badge_type', sa.String(length=64), nullable=True),
sa.Column('user_id', sa.Integer(), nullable=True),
sa.Column('serial_number', sa.String(length=14), nullable=True),
sa.Column('creation_date', sa.Interval(), nullable=True),
sa.Column('valid_from', sa.Interval(), nullable=True),
sa.Column('valid_until', sa.Interval(), nullable=True),
sa.Column('revoked', sa.Boolean(), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_card_serial_number'),
'card', ['serial_number'],
unique=False)
op.create_index(op.f('ix_card_user_id'), 'card', ['user_id'], unique=False)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('posiciones', sa.Column('id', sa.Integer(),
nullable=False),
sa.Column('name', sa.String(length=80), nullable=False),
sa.Column('time', sa.Interval(), nullable=False),
sa.PrimaryKeyConstraint('id'))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'individual_importances',
sa.Column('model_id', sa.Integer(), nullable=False),
sa.Column('entity_id', sa.BigInteger(), nullable=False),
sa.Column('as_of_date', sa.DateTime(), nullable=False),
sa.Column('feature', sa.String(), nullable=False),
sa.Column('method', sa.String(), nullable=False),
sa.Column('importance_score', sa.Text(), nullable=True),
sa.ForeignKeyConstraint(['model_id'], ['results.models.model_id'], ),
sa.PrimaryKeyConstraint(
'model_id',
'entity_id',
'as_of_date',
'feature',
'method',
),
schema='results'
)
op.create_table(
'list_predictions',
sa.Column('model_id', sa.Integer(), nullable=False),
sa.Column('entity_id', sa.BigInteger(), nullable=False),
sa.Column('as_of_date', sa.DateTime(), nullable=False),
sa.Column('score', sa.Numeric(), nullable=True),
sa.Column('rank_abs', sa.Integer(), nullable=True),
sa.Column('rank_pct', sa.Float(), nullable=True),
sa.Column('matrix_uuid', sa.Text(), nullable=True),
sa.Column('test_label_window', sa.Interval(), nullable=True),
sa.ForeignKeyConstraint(['model_id'], ['results.models.model_id'], ),
sa.PrimaryKeyConstraint('model_id', 'entity_id', 'as_of_date'),
schema='results'
)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'tasks', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('time_created',
sa.DateTime(timezone=True),
server_default=sa.text('now()'),
nullable=True),
sa.Column('time_updated', sa.DateTime(timezone=True), nullable=True),
sa.Column('owner_id', sa.Integer(), nullable=False),
sa.Column('community_id', sa.Integer(), nullable=False),
sa.Column('km_interval', sa.Integer(), nullable=True),
sa.Column('km_interval_start',
sa.DECIMAL(precision=10, scale=1),
nullable=True),
sa.Column('time_interval', sa.Interval(), nullable=True),
sa.Column('time_interval_start',
sa.DateTime(timezone=True),
nullable=True),
sa.Column('name', sa.String(length=120), nullable=True),
sa.Column('description', sa.String(length=120), nullable=True),
sa.ForeignKeyConstraint(
['community_id'],
['communities.id'],
), sa.ForeignKeyConstraint(
['owner_id'],
['users.id'],
), sa.PrimaryKeyConstraint('id'))
def upgrade():
op.create_table(
"timed_belief",
sa.Column("event_start",
sa.DateTime(timezone=True),
nullable=False,
index=True),
sa.Column("belief_horizon", sa.Interval(), nullable=False),
sa.Column("cumulative_probability",
sa.Float(),
nullable=False,
default=0.5),
sa.Column("event_value", sa.Float(), nullable=False),
sa.Column("sensor_id", sa.Integer(), nullable=False, index=True),
sa.Column("source_id", sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(
["sensor_id"],
["sensor.id"],
name=op.f("timed_belief_sensor_id_sensor_fkey"),
ondelete="CASCADE",
),
sa.ForeignKeyConstraint(
["source_id"],
["data_source.id"],
name=op.f("timed_belief_source_id_source_fkey"),
ondelete="CASCADE",
),
sa.PrimaryKeyConstraint(
"event_start",
"belief_horizon",
"cumulative_probability",
"sensor_id",
name=op.f("timed_belief_pkey"),
),
)
def upgrade():
### commands auto generated by Alembic - please adjust! ###
op.create_table('user',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=255), nullable=True),
sa.Column('email', sa.String(length=255), nullable=True),
sa.Column('trello_id', sa.String(length=255), nullable=True),
sa.Column('trello_token', sa.String(length=255), nullable=True),
sa.Column('trello_token_exp', sqlalchemy_utcdatetime.UTCDateTime(), nullable=True),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('trello_id')
)
op.create_table('recurring_card',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('title', sa.String(length=255), nullable=True),
sa.Column('description', sa.Text(), nullable=True),
sa.Column('labels', sa.String(length=255), nullable=True),
sa.Column('board', sa.String(length=255), nullable=True),
sa.Column('column', sa.String(length=255), nullable=True),
sa.Column('start', sqlalchemy_utcdatetime.UTCDateTime(), nullable=True),
sa.Column('last_run', sqlalchemy_utcdatetime.UTCDateTime(), nullable=True),
sa.Column('frequency', sa.Interval(), nullable=True),
sa.Column('due_date_minutes', sa.BigInteger(), nullable=True),
sa.Column('user_id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(['user_id'], ['user.id'], ondelete='CASCADE'),
sa.PrimaryKeyConstraint('id')
)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'assignment_peer_feedback_settings',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('created_at', sa.TIMESTAMP(timezone=True), nullable=False),
sa.Column('updated_at', sa.TIMESTAMP(timezone=True), nullable=False),
sa.Column('amount', sa.Integer(), nullable=False),
sa.Column('time', sa.Interval(), nullable=True),
sa.Column('assignment_id', sa.Integer(), nullable=False),
sa.PrimaryKeyConstraint('id'),
sa.ForeignKeyConstraint(['assignment_id'], ['Assignment.id'],
ondelete='CASCADE'),
sa.CheckConstraint(
'amount > 0', name='peer_feedback_amount_at_least_one'
),
)
op.create_table(
'assignment_peer_feedback_connection',
sa.Column('created_at', sa.TIMESTAMP(timezone=True), nullable=False),
sa.Column('updated_at', sa.TIMESTAMP(timezone=True), nullable=False),
sa.Column('peer_feedback_settings_id', sa.Integer(), nullable=False),
sa.Column('user_id', sa.Integer(), nullable=False),
sa.Column('peer_user_id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(['peer_feedback_settings_id'],
['assignment_peer_feedback_settings.id'],
ondelete='CASCADE'),
sa.ForeignKeyConstraint(['peer_user_id'], ['User.id'],
ondelete='CASCADE'),
sa.ForeignKeyConstraint(['user_id'], ['User.id'], ondelete='CASCADE'),
sa.PrimaryKeyConstraint(
'peer_feedback_settings_id', 'user_id', 'peer_user_id'
),
)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column('Assignment',
sa.Column('cool_off_period', sa.Interval(), nullable=True))
op.add_column(
'Assignment',
sa.Column('max_amount_of_submissions', sa.Integer(), nullable=True))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_index('name', table_name='cases')
op.add_column('inventory',
sa.Column('expiration', sa.DateTime(), nullable=True))
op.add_column('items',
sa.Column('expiration_period', sa.Interval(), nullable=True))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'transaction', sa.Column('transaction_id',
sa.Integer(),
nullable=False),
sa.Column('user_id', sa.Integer(), nullable=True),
sa.Column('account_from_id', sa.Integer(), nullable=True),
sa.Column('account_to_id', sa.Integer(), nullable=True),
sa.Column('transaction_name', sa.String(length=40)),
sa.Column('amount', sa.Numeric(scale=2), nullable=True),
sa.Column('timestamp', sa.DateTime(), nullable=True),
sa.Column('recurring', sa.Boolean(), nullable=True),
sa.Column('recurring_delay', sa.Interval(), nullable=True),
sa.Column('note', sa.String(length=120), nullable=True),
sa.Column('delete_allowed', sa.Boolean(), nullable=True),
sa.ForeignKeyConstraint(
['account_from_id'], ['account.account_id'],
name=op.f('fk_transaction_account_from_id_account')),
sa.ForeignKeyConstraint(
['account_to_id'], ['account.account_id'],
name=op.f('fk_transaction_account_to_id_account')),
sa.ForeignKeyConstraint(['user_id'], ['user.user_id'],
name=op.f('fk_transaction_user_id_user')),
sa.PrimaryKeyConstraint('transaction_id', name=op.f('pk_transaction')))
def upgrade():
op.create_table('reminders',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('event_id', sa.Integer(), nullable=False),
sa.Column('creator_id',
sa.Integer(),
nullable=False,
index=True),
sa.Column('created_dt', UTCDateTime, nullable=False),
sa.Column('scheduled_dt', UTCDateTime, nullable=False),
sa.Column('is_sent', sa.Boolean(), nullable=False),
sa.Column('event_start_delta',
sa.Interval(),
nullable=True),
sa.Column('recipients',
postgresql.ARRAY(sa.String()),
nullable=False),
sa.Column('send_to_participants',
sa.Boolean(),
nullable=False),
sa.Column('include_summary', sa.Boolean(), nullable=False),
sa.Column('reply_to_address', sa.String(), nullable=False),
sa.Column('message', sa.String(), nullable=False),
sa.ForeignKeyConstraint(['creator_id'],
['users.users.id']),
sa.PrimaryKeyConstraint('id'),
schema='events')
op.create_index(None,
'reminders', ['scheduled_dt'],
schema='events',
postgresql_where=sa.text('not is_sent'))
def upgrade():
# Live action
op.drop_table('live', schema=f'{get_inv()}')
op.create_table(
'live',
sa.Column('id', postgresql.UUID(as_uuid=True), nullable=False),
sa.Column('serial_number',
sa.Unicode(),
nullable=True,
comment='The serial number of the Hard Disk in lower case.'),
sa.Column('usage_time_hdd', sa.Interval(), nullable=True),
sa.Column('snapshot_uuid',
postgresql.UUID(as_uuid=True),
nullable=False),
sa.Column('software_version',
teal.db.StrictVersionType(length=32),
nullable=False),
sa.Column('licence_version',
teal.db.StrictVersionType(length=32),
nullable=False),
sa.Column('software',
sa.Enum('Workbench',
'WorkbenchAndroid',
'AndroidApp',
'Web',
'DesktopApp',
'WorkbenchDesktop',
name='snapshotsoftware'),
nullable=False),
sa.ForeignKeyConstraint(
['id'],
[f'{get_inv()}.action.id'],
),
sa.PrimaryKeyConstraint('id'),
schema=f'{get_inv()}')
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
"individual_importances",
sa.Column("model_id", sa.Integer(), nullable=False),
sa.Column("entity_id", sa.BigInteger(), nullable=False),
sa.Column("as_of_date", sa.DateTime(), nullable=False),
sa.Column("feature", sa.String(), nullable=False),
sa.Column("method", sa.String(), nullable=False),
sa.Column("importance_score", sa.Text(), nullable=True),
sa.ForeignKeyConstraint(["model_id"], ["results.models.model_id"]),
sa.PrimaryKeyConstraint(
"model_id", "entity_id", "as_of_date", "feature", "method"
),
schema="results",
)
op.create_table(
"list_predictions",
sa.Column("model_id", sa.Integer(), nullable=False),
sa.Column("entity_id", sa.BigInteger(), nullable=False),
sa.Column("as_of_date", sa.DateTime(), nullable=False),
sa.Column("score", sa.Numeric(), nullable=True),
sa.Column("rank_abs", sa.Integer(), nullable=True),
sa.Column("rank_pct", sa.Float(), nullable=True),
sa.Column("matrix_uuid", sa.Text(), nullable=True),
sa.Column("test_label_window", sa.Interval(), nullable=True),
sa.ForeignKeyConstraint(["model_id"], ["results.models.model_id"]),
sa.PrimaryKeyConstraint("model_id", "entity_id", "as_of_date"),
schema="results",
)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column('Diary', sa.Column('end', sa.DateTime(), nullable=True))
op.add_column('Diary', sa.Column('sleep_time',
sa.Interval(),
nullable=True))
op.add_column('Diary', sa.Column('start', sa.DateTime(), nullable=True))
def upgrade():
### commands auto generated by Alembic - please adjust! ###
op.add_column('time_entries',
sa.Column('duration', sa.Interval(), nullable=True))
op.alter_column('time_entries',
'amount',
existing_type=sa.NUMERIC(precision=4, scale=2),
nullable=True)
def upgrade():
# Break
op.create_table(
'breaks',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('title', sa.String(), nullable=False),
sa.Column('description', sa.Text(), nullable=False),
sa.Column('duration', sa.Interval(), nullable=False),
sa.Column('text_color', sa.String(), nullable=False),
sa.Column('background_color', sa.String(), nullable=False),
sa.Column('room_name', sa.String(), nullable=False),
sa.Column('inherit_location', sa.Boolean(), nullable=False),
sa.Column('address', sa.Text(), nullable=False),
sa.Column('venue_id', sa.Integer(), nullable=True, index=True),
sa.Column('venue_name', sa.String(), nullable=False),
sa.Column('room_id', sa.Integer(), nullable=True, index=True),
sa.CheckConstraint("(room_id IS NULL) OR (venue_name = '' AND room_name = '')",
name='no_custom_location_if_room'),
sa.CheckConstraint("(venue_id IS NULL) OR (venue_name = '')", name='no_venue_name_if_venue_id'),
sa.CheckConstraint("(room_id IS NULL) OR (venue_id IS NOT NULL)", name='venue_id_if_room_id'),
sa.CheckConstraint("NOT inherit_location OR (venue_id IS NULL AND room_id IS NULL AND venue_name = '' AND "
"room_name = '' AND address = '')", name='inherited_location'),
sa.CheckConstraint("(text_color = '') = (background_color = '')", name='both_or_no_colors'),
sa.CheckConstraint("text_color != '' AND background_color != ''", name='colors_not_empty'),
sa.ForeignKeyConstraint(['room_id'], ['roombooking.rooms.id']),
sa.ForeignKeyConstraint(['venue_id'], ['roombooking.locations.id']),
sa.ForeignKeyConstraint(['venue_id', 'room_id'], ['roombooking.rooms.location_id', 'roombooking.rooms.id']),
sa.PrimaryKeyConstraint('id'),
schema='events'
)
# TimetableEntry
op.create_table(
'timetable_entries',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('event_id', sa.Integer(), nullable=False, index=True),
sa.Column('parent_id', sa.Integer(), nullable=True, index=True),
sa.Column('session_block_id', sa.Integer(), nullable=True, index=True, unique=True),
sa.Column('contribution_id', sa.Integer(), nullable=True, index=True, unique=True),
sa.Column('break_id', sa.Integer(), nullable=True, index=True, unique=True),
sa.Column('type', PyIntEnum(TimetableEntryType), nullable=False),
sa.Column('start_dt', UTCDateTime, nullable=False),
sa.Index('ix_timetable_entries_start_dt_desc', sa.text('start_dt DESC')),
sa.CheckConstraint('type != 1 OR parent_id IS NULL', name='valid_parent'),
sa.CheckConstraint('type != 1 OR (contribution_id IS NULL AND break_id IS NULL AND '
'session_block_id IS NOT NULL)', name='valid_session_block'),
sa.CheckConstraint('type != 2 OR (session_block_id IS NULL AND break_id IS NULL AND '
'contribution_id IS NOT NULL)', name='valid_contribution'),
sa.CheckConstraint('type != 3 OR (contribution_id IS NULL AND session_block_id IS NULL AND '
'break_id IS NOT NULL)', name='valid_break'),
sa.ForeignKeyConstraint(['break_id'], ['events.breaks.id']),
sa.ForeignKeyConstraint(['contribution_id'], ['events.contributions.id']),
sa.ForeignKeyConstraint(['event_id'], ['events.events.id']),
sa.ForeignKeyConstraint(['parent_id'], ['events.timetable_entries.id']),
sa.ForeignKeyConstraint(['session_block_id'], ['events.session_blocks.id']),
sa.PrimaryKeyConstraint('id'),
schema='events'
)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'users', sa.Column('created_on', sa.DateTime(), nullable=True),
sa.Column('updated_on', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('email', sa.String(length=255), nullable=True),
sa.Column('full_name', sa.String(length=255), nullable=True),
sa.Column('hashed_password', sa.String(length=255), nullable=True),
sa.Column('is_superuser', sa.Boolean(), nullable=True),
sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('email'))
op.create_table(
'meetings', sa.Column('created_on', sa.DateTime(), nullable=True),
sa.Column('updated_on', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('meeting_name', sa.String(length=255), nullable=False),
sa.Column('description', sa.String(length=255), nullable=True),
sa.Column('set_duration', sa.Interval(), nullable=True),
sa.Column('final_duration', sa.Interval(), nullable=True),
sa.Column('set_start_time', sa.Time(), nullable=True),
sa.Column('set_end_time', sa.Time(), nullable=True),
sa.Column('final_start_time', sa.Time(), nullable=True),
sa.Column('final_end_time', sa.Time(), nullable=True),
sa.Column('completed', sa.Boolean(), nullable=True),
sa.Column('user_id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(
['user_id'],
['users.id'],
), sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('user_id', 'meeting_name'))
op.create_table(
'agendas', sa.Column('created_on', sa.DateTime(), nullable=True),
sa.Column('updated_on', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('agenda_name', sa.String(length=255), nullable=False),
sa.Column('set_duration', sa.Interval(), nullable=False),
sa.Column('final_duration', sa.Interval(), nullable=True),
sa.Column('completed', sa.Boolean(), nullable=True),
sa.Column('meeting_id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(
['meeting_id'],
['meetings.id'],
), sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('meeting_id', 'agenda_name'))
op.drop_table('user')
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'videos', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('title', sa.String(length=40), nullable=False),
sa.Column('owner_id', sa.String(length=5), nullable=False),
sa.Column('date_created', postgresql.TIMESTAMP(), nullable=True),
sa.Column('len', sa.Interval(), nullable=True),
sa.PrimaryKeyConstraint('id'))
