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'))