def upgrade_user_db():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'events', sa.Column('id', sa.String(length=100), nullable=False),
sa.Column('calendar_id', sa.String(length=150), nullable=True),
sa.Column('created_at', sa.TIMESTAMP(), nullable=True),
sa.Column('organizer_email', sa.String(length=200), nullable=True),
sa.Column('is_recurring', sa.BOOLEAN(), nullable=True),
sa.Column('title', sa.String(length=500), nullable=True),
sa.Column('location', sa.String(length=500), nullable=True),
sa.Column('start_time', sa.TIMESTAMP(), nullable=True),
sa.Column('end_time', sa.TIMESTAMP(), nullable=True),
sa.Column('description', sa.String(length=5000), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'event_attendees', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('event_id', sa.String(length=100), nullable=True),
sa.Column('email', sa.String(length=200), nullable=True),
sa.Column('working_hours_start_time', sa.TIME(), nullable=True),
sa.Column('working_hours_end_time', sa.TIME(), nullable=True),
sa.Column('display_name', sa.String(length=200), nullable=True),
sa.Column('response_status', sa.String(length=20), nullable=True),
sa.Column('is_organizer', sa.BOOLEAN(), nullable=True),
sa.Column('is_optional', sa.BOOLEAN(), nullable=True),
sa.ForeignKeyConstraint(
['event_id'],
['events.id'],
), sa.PrimaryKeyConstraint('id'))
def upgrade_user_db():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'calendar_event',
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('event_id', sa.String(length=500), nullable=False),
sa.Column('created_at', sa.TIMESTAMP(), nullable=True),
sa.Column('updated_at', sa.TIMESTAMP(), nullable=True),
sa.Column('organizer_email', sa.String(length=200), nullable=True),
sa.Column('creator_email', sa.String(length=200), nullable=True),
sa.Column('status', sa.String(length=200), nullable=True),
sa.Column('is_recurring', sa.BOOLEAN(), nullable=True),
sa.Column('recurrence_id', sa.String(length=200), nullable=True),
sa.Column('title', sa.String(length=500), nullable=True),
sa.Column('location', sa.String(length=500), nullable=True),
sa.Column('start_time', sa.TIMESTAMP(), nullable=True),
sa.Column('end_time', sa.TIMESTAMP(), nullable=True),
sa.Column('description', sa.String(length=5000), nullable=True),
sa.PrimaryKeyConstraint('event_id'))
op.create_table(
'calendar_event_attendee',
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('event_id', sa.String(length=500), nullable=False),
sa.Column('invited_email', sa.String(length=200), nullable=False),
sa.Column('timezone', sa.String(length=200), nullable=True),
sa.Column('calendar_user_id', sa.String(length=100), nullable=True),
sa.Column('working_hours_start_time', sa.TIME(), nullable=True),
sa.Column('working_hours_end_time', sa.TIME(), nullable=True),
sa.Column('timezone_organized', sa.String(length=200), nullable=True),
sa.Column('display_name', sa.String(length=200), nullable=True),
sa.Column('response_status', sa.String(length=20), nullable=True),
sa.Column('is_organizer', sa.BOOLEAN(), nullable=True),
sa.Column('is_optional', sa.BOOLEAN(), nullable=True),
sa.Column('comment', sa.Text(), nullable=True),
sa.ForeignKeyConstraint(
['calendar_user_id'],
['calendar_user.id'],
), sa.ForeignKeyConstraint(
['event_id'],
['calendar_event.event_id'],
), sa.PrimaryKeyConstraint('event_id', 'invited_email'))
op.drop_table('calendar_event_attendees')
op.drop_table('calendar_events')
def downgrade():
### commands auto generated by Alembic - please adjust! ###
with op.batch_alter_table('sessions', schema=None) as batch_op:
batch_op.add_column(sa.Column('date', sa.DATE(), nullable=True))
batch_op.drop_index(batch_op.f('ix_sessions_timestamp'))
batch_op.alter_column('start_time',
existing_type=sa.DateTime(),
type_=sa.TIME(),
existing_nullable=True)
batch_op.alter_column('end_time',
existing_type=sa.DateTime(),
type_=sa.TIME(),
existing_nullable=True)
batch_op.drop_column('timestamp')
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_table('association')
op.drop_table('association2')
op.add_column('events', sa.Column('date', sa.DATE(), nullable=True))
op.add_column('events', sa.Column('location', sa.Text(), nullable=True))
op.add_column('events', sa.Column('time', sa.TIME(), nullable=True))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'appointments', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('user_id', sa.Integer(), nullable=True),
sa.Column('source_language', sa.String(length=100), nullable=True),
sa.Column('target_languages', sa.Text(), nullable=False),
sa.Column('industry', sa.String(length=150), nullable=True),
sa.Column('date', sa.DATE(), nullable=True),
sa.Column('time', sa.TIME(), nullable=True),
sa.Column('duration', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['user_id'],
['users.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'interpreters', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('user_id', sa.Integer(), nullable=True),
sa.Column('headline', sa.String(length=150), nullable=True),
sa.Column('native_language', sa.String(length=150), nullable=True),
sa.Column('target_languages', sa.Text(), nullable=False),
sa.Column('years_of_experience', sa.Integer(), nullable=False),
sa.Column('education', sa.String(length=150), nullable=True),
sa.Column('field_of_expertise', sa.Text(), nullable=True),
sa.Column('certifications', sa.Text(), nullable=True),
sa.Column('interpreting_service', sa.Text(), nullable=True),
sa.ForeignKeyConstraint(
['user_id'],
['users.id'],
), sa.PrimaryKeyConstraint('id'))
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
with op.batch_alter_table('mycourse', schema=None) as batch_op:
batch_op.alter_column('time', existing_type=sa.TIME(), nullable=False)
batch_op.alter_column('cost',
existing_type=sa.VARCHAR(length=64),
nullable=False)
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column('appointments', sa.Column('date', sa.DATE(), nullable=True))
op.add_column('appointments', sa.Column('time', sa.TIME(), nullable=True))
op.create_index('ix_appointments_time',
'appointments', ['time'],
unique=False)
op.create_index('ix_appointments_date',
'appointments', ['date'],
unique=False)
def upgrade():
#convert time column to interval, so create native timedelta
op.alter_column('radio_program', 'duration',
existing_type=sa.TIME(),
type_=sa.types.Interval(),
nullable=False)
#cleanup misc
### commands auto generated by Alembic ###
op.drop_column(u'radio_location', u'modifieddate')
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('schedule',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('day', sa.Integer(), nullable=False),
sa.Column('exact', sa.BOOLEAN(), nullable=False),
sa.Column('time', sa.TIME(), nullable=False),
sa.Column('start', sa.Date(), nullable=False),
sa.Column('end', sa.Date(), nullable=False),
sa.PrimaryKeyConstraint('id')
)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('appointments',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('userId', sa.Integer(), nullable=True),
sa.Column('source_language', sa.String(length=100), nullable=True),
sa.Column('target_languages', sa.Text(), nullable=False),
sa.Column('industry', sa.String(length=150), nullable=True),
sa.Column('date', sa.DateTime(), nullable=True),
sa.Column('time', sa.TIME(), nullable=True),
sa.Column('duration', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['userId'], ['users.id'], ),
sa.PrimaryKeyConstraint('id')
)
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column('result', sa.Column('distance', sa.INTEGER(),
nullable=False))
op.add_column('result', sa.Column('time', sa.TIME(), nullable=False))
op.drop_column('conditioning', 'time')
op.drop_column('conditioning', 'distance')
op.create_table(
'userUsergroup', sa.Column('user_id', sa.INTEGER(), nullable=False),
sa.Column('usergroup_id', sa.INTEGER(), nullable=False),
sa.ForeignKeyConstraint(
['user_id'],
['account.id'],
), sa.ForeignKeyConstraint(
['usergroup_id'],
['usergroup.id'],
), sa.PrimaryKeyConstraint('user_id', 'usergroup_id'))
op.drop_table('UserUsergroup')
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('company',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=50), nullable=False),
sa.Column('code', sa.String(length=100), nullable=False),
sa.Column('phone', sa.String(length=20), nullable=True),
sa.Column('tax_number', sa.String(length=20), nullable=True),
sa.Column('email', sa.String(length=75), nullable=True),
sa.Column('industry', sa.String(length=25), nullable=False),
sa.Column('address_1', sa.String(length=100), nullable=True),
sa.Column('address_2', sa.String(length=100), nullable=True),
sa.Column('address_3', sa.String(length=100), nullable=True),
sa.Column('city', sa.String(length=25), nullable=True),
sa.Column('country', sa.String(length=25), nullable=True),
sa.Column('state', sa.String(length=25), nullable=True),
sa.Column('zipcode', sa.String(length=10), nullable=True),
sa.Column('is_active', sa.Boolean(), server_default='false', nullable=False),
sa.PrimaryKeyConstraint('id')
)
op.create_index(op.f('ix_company_email'), 'company', ['email'], unique=True)
op.create_index(op.f('ix_company_name'), 'company', ['name'], unique=True)
op.create_table('appointments',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('user_id', sa.Integer(), nullable=True),
sa.Column('source_language', sa.String(length=100), nullable=True),
sa.Column('target_languages', sa.Text(), nullable=False),
sa.Column('industry', sa.String(length=150), nullable=True),
sa.Column('date', sa.DATE(), nullable=True),
sa.Column('time', sa.TIME(), nullable=True),
sa.Column('duration', sa.Integer(), nullable=True),
sa.Column('meeting_type', sa.String(length=50), nullable=True),
sa.Column('category_type', sa.Text(), nullable=True),
sa.Column('order_id', sa.String(length=50), nullable=True),
sa.Column('status', sa.String(length=20), nullable=True),
sa.Column('join_url', sa.String(length=256), nullable=True),
sa.Column('start_url', sa.String(length=550), nullable=True),
sa.Column('meeting_id', sa.String(length=15), nullable=True),
sa.Column('meeting_password', sa.String(length=256), nullable=True),
sa.ForeignKeyConstraint(['user_id'], ['users.id'], ),
sa.PrimaryKeyConstraint('id')
)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'appointments', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('user_id', sa.Integer(), nullable=True),
sa.Column('source_language', sa.String(length=100), nullable=True),
sa.Column('target_languages', sa.Text(), nullable=False),
sa.Column('industry', sa.String(length=150), nullable=True),
sa.Column('date', sa.DATE(), nullable=True),
sa.Column('time', sa.TIME(), nullable=True),
sa.Column('duration', sa.Integer(), nullable=True),
sa.Column('url', sa.String(length=256), nullable=True),
sa.Column('meeting_id',
sa.Numeric(precision=20, scale=0),
nullable=True),
sa.Column('meeting_password', sa.String(length=256), nullable=True),
sa.ForeignKeyConstraint(
['user_id'],
['users.id'],
), sa.PrimaryKeyConstraint('id'))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('events',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.Text(), nullable=True),
sa.Column('date', sa.DATE(), nullable=True),
sa.Column('time', sa.TIME(), nullable=True),
sa.Column('location', sa.Text(), nullable=True),
sa.Column('type_of_event', sa.Text(), nullable=True),
sa.PrimaryKeyConstraint('id', name=op.f('pk_events')),
sa.UniqueConstraint('name', name=op.f('uq_events_name'))
)
op.create_index('event_index', 'events', ['id'], unique=True, mysql_length=255)
op.create_table('teams',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.Text(), nullable=True),
sa.PrimaryKeyConstraint('id', name=op.f('pk_teams')),
sa.UniqueConstraint('name', name=op.f('uq_teams_name'))
)
op.create_index('team_index', 'teams', ['id'], unique=True, mysql_length=255)
op.create_table('matches',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.Text(), nullable=True),
sa.Column('event_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['event_id'], ['events.id'], name=op.f('fk_matches_event_id_events')),
sa.PrimaryKeyConstraint('id', name=op.f('pk_matches')),
sa.UniqueConstraint('name', name=op.f('uq_matches_name'))
)
op.create_index('match_index', 'matches', ['id'], unique=True, mysql_length=255)
op.create_table('players',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('username', sa.Text(), nullable=False),
sa.Column('name', sa.Text(), nullable=True),
sa.Column('surname', sa.Text(), nullable=True),
sa.Column('email', sa.Text(), nullable=False),
sa.Column('imageurl', sa.Text(), nullable=True),
sa.Column('team_id', sa.Integer(), nullable=True),
sa.Column('age', sa.Integer(), nullable=True),
sa.Column('weight', sa.Integer(), nullable=True),
sa.Column('height', sa.Integer(), nullable=True),
sa.Column('location', sa.Text(), nullable=True),
sa.Column('telephone', sa.Text(), nullable=True),
sa.Column('ratings_by_own', sa.JSON(), nullable=True),
sa.Column('rating_evaluation', sa.FLOAT(), nullable=True),
sa.Column('credit', sa.FLOAT(), nullable=True),
sa.Column('role_preference', sa.Integer(), nullable=True),
sa.Column('password_hash', sa.Text(), nullable=True),
sa.ForeignKeyConstraint(['team_id'], ['teams.id'], name=op.f('fk_players_team_id_teams')),
sa.PrimaryKeyConstraint('id', name=op.f('pk_players')),
sa.UniqueConstraint('username', name=op.f('uq_players_username'))
)
op.create_index('player_index', 'players', ['id'], unique=True, mysql_length=255)
op.create_table('match_team',
sa.Column('match_id', sa.Integer(), nullable=True),
sa.Column('team_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['match_id'], ['matches.id'], name=op.f('fk_match_team_match_id_matches')),
sa.ForeignKeyConstraint(['team_id'], ['teams.id'], name=op.f('fk_match_team_team_id_teams'))
)
op.create_table('player_event',
sa.Column('player_id', sa.Integer(), nullable=True),
sa.Column('event_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['event_id'], ['events.id'], name=op.f('fk_player_event_event_id_events')),
sa.ForeignKeyConstraint(['player_id'], ['players.id'], name=op.f('fk_player_event_player_id_players'))
)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column('event', sa.Column('time', sa.TIME(), nullable=True))
op.add_column('event', sa.Column('weekday', sa.String(length=64), nullable=True))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'maintenance', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('provider_maintenance_id',
sa.String(length=128),
nullable=True), sa.Column('start', sa.TIME(), nullable=True),
sa.Column('end', sa.TIME(), nullable=True),
sa.Column('timezone', sa.String(length=128), nullable=True),
sa.Column('cancelled', sa.INTEGER(), nullable=True),
sa.Column('rescheduled', sa.INTEGER(), nullable=True),
sa.Column('rescheduled_id', sa.Integer(), nullable=True),
sa.Column('location', sa.String(length=2048), nullable=True),
sa.Column('reason', sa.TEXT(), nullable=True),
sa.Column('received_dt', sa.DateTime(), nullable=True),
sa.Column('started', sa.INTEGER(), nullable=True),
sa.Column('ended', sa.INTEGER(), nullable=True),
sa.ForeignKeyConstraint(
['rescheduled_id'],
['maintenance.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_maintenance_location'),
'maintenance', ['location'],
unique=False)
op.create_table(
'provider', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=128), nullable=True),
sa.Column('type',
sa.Enum('transit',
'backbone',
'transport',
'peering',
'facility',
'multi',
name='ProviderType'),
nullable=True),
sa.Column('email_esc', sa.VARCHAR(length=128), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_provider_name'),
'provider', ['name'],
unique=False)
op.create_table(
'circuit', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('provider_cid', sa.VARCHAR(length=128), nullable=True),
sa.Column('a_side', sa.VARCHAR(length=128), nullable=True),
sa.Column('z_side', sa.VARCHAR(length=128), nullable=True),
sa.Column('provider_id', sa.Integer(), nullable=True),
sa.Column('contract_filename', sa.String(length=256), nullable=True),
sa.ForeignKeyConstraint(
['provider_id'],
['provider.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_circuit_provider_cid'),
'circuit', ['provider_cid'],
unique=True)
op.create_table(
'maint_update', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('maintenance_id', sa.Integer(), nullable=True),
sa.Column('comment', sa.TEXT(), nullable=True),
sa.Column('updated', sa.DateTime(), nullable=True),
sa.ForeignKeyConstraint(
['maintenance_id'],
['maintenance.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'maint_circuit', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('maint_id', sa.Integer(), nullable=True),
sa.Column('circuit_id', sa.Integer(), nullable=True),
sa.Column('impact', sa.VARCHAR(length=128), nullable=True),
sa.Column('date', sa.DATE(), nullable=True),
sa.ForeignKeyConstraint(
['circuit_id'],
['circuit.id'],
), sa.ForeignKeyConstraint(
['maint_id'],
['maintenance.id'],
), sa.PrimaryKeyConstraint('id'))
op.drop_index('ix_apscheduler_jobs_next_run_time',
table_name='apscheduler_jobs')
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'category', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('category_media', sa.String(length=80), nullable=False),
sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('category_media'))
op.create_table(
'device', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('device_id', sa.Integer(), nullable=True),
sa.Column('versionName', sa.String(length=256), nullable=True),
sa.Column('applicationName', sa.String(length=256), nullable=True),
sa.Column('deviceName', sa.String(length=256), nullable=True),
sa.Column('systemName', sa.String(length=256), nullable=True),
sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('device_id'),
sa.UniqueConstraint('versionName'))
op.create_table(
'user', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('username', sa.String(length=80), nullable=False),
sa.Column('hashed_password', sa.String(length=512), nullable=False),
sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('hashed_password'),
sa.UniqueConstraint('username'))
op.create_table(
'version', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('minVersion', sa.String(length=80), nullable=True),
sa.Column('latest', sa.String(length=80), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'book', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('user_id', sa.Integer(), nullable=True),
sa.Column('title', sa.String(length=64), nullable=True),
sa.Column('author', sa.String(length=256), nullable=True),
sa.Column('page_number', sa.Integer(), nullable=True),
sa.Column('book_url', sa.String(length=256), nullable=False),
sa.Column('thumbnaiUrl', sa.String(length=256), nullable=True),
sa.ForeignKeyConstraint(
['user_id'],
['user.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'sound', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('user_id', sa.Integer(), nullable=True),
sa.Column('category_id', sa.Integer(), nullable=True),
sa.Column('time', sa.TIME(), nullable=True),
sa.Column('singer', sa.String(length=64), nullable=True),
sa.Column('sound_url', sa.String(length=256), nullable=False),
sa.Column('name', sa.String(length=128), nullable=True),
sa.ForeignKeyConstraint(
['category_id'],
['category.id'],
), sa.ForeignKeyConstraint(
['user_id'],
['user.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'video', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('user_id', sa.Integer(), nullable=True),
sa.Column('category_id', sa.Integer(), nullable=True),
sa.Column('title', sa.String(length=64), nullable=True),
sa.Column('text', sa.String(length=512), nullable=True),
sa.Column('video_url', sa.String(length=256), nullable=False),
sa.Column('thumbnaiUrl', sa.String(length=256), nullable=True),
sa.ForeignKeyConstraint(
['category_id'],
['category.id'],
), sa.ForeignKeyConstraint(
['user_id'],
['user.id'],
), sa.PrimaryKeyConstraint('id'))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('antropometrias',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('peso', sa.Float(), nullable=True),
sa.Column('braco', sa.Float(), nullable=True),
sa.Column('torax', sa.Float(), nullable=True),
sa.Column('cintura', sa.Float(), nullable=True),
sa.Column('abdomen', sa.Float(), nullable=True),
sa.Column('quadril', sa.Float(), nullable=True),
sa.Column('coxa', sa.Float(), nullable=True),
sa.Column('biceps', sa.Float(), nullable=True),
sa.Column('triceps', sa.Float(), nullable=True),
sa.Column('peito', sa.Float(), nullable=True),
sa.Column('subsCap', sa.Float(), nullable=True),
sa.Column('axilar', sa.Float(), nullable=True),
sa.Column('gorduraPerc', sa.Float(), nullable=True),
sa.Column('aguaPerc', sa.Float(), nullable=True),
sa.Column('pesoMagro', sa.Float(), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'horarios', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('data', sa.String(length=10), nullable=True),
sa.Column('horaInicio', sa.String(length=5), nullable=True),
sa.Column('horaFim', sa.String(length=5), nullable=True),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('data',
'horaInicio',
'horaFim',
name='periodo unico'))
op.create_table('tipoAtendimentos',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('nome', sa.String(length=300), nullable=True),
sa.Column('preco', sa.Float(), nullable=True),
sa.Column('qtdRetorno', sa.Integer(), nullable=True),
sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('nome'))
op.create_table('tipoEstados', sa.Column('id',
sa.Integer(),
nullable=False),
sa.Column('nome', sa.String(length=30), nullable=True),
sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('nome'))
op.create_table('tipoRefeicoes',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('nome', sa.String(length=30), nullable=False),
sa.PrimaryKeyConstraint('id'))
op.create_table('users', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('username', sa.String(), nullable=True),
sa.Column('password', sa.String(), nullable=True),
sa.Column('nome', sa.String(), nullable=True),
sa.Column('email', sa.String(), nullable=True),
sa.Column('celular', sa.String(length=11), nullable=True),
sa.Column('tipo', sa.String(length=1), nullable=True),
sa.Column('ativo', sa.Boolean(), nullable=True),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('email'),
sa.UniqueConstraint('username'))
op.create_table('ocupados', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('horario_id', sa.Integer(), nullable=False),
sa.Column('horaI', sa.String(length=5), nullable=False),
sa.Column('horaF', sa.String(length=5), nullable=False),
sa.ForeignKeyConstraint(
['horario_id'],
['horarios.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'pacientes', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('user_id', sa.Integer(), nullable=True),
sa.Column('dataNascimento', sa.DateTime(), nullable=True),
sa.Column('sexo', sa.String(length=1), nullable=True),
sa.Column('cidade', sa.String(length=50), nullable=True),
sa.Column('profissao', sa.String(length=50), nullable=True),
sa.Column('objetivo', sa.String(length=50), nullable=True),
sa.Column('altura', sa.Float(), nullable=False),
sa.ForeignKeyConstraint(
['user_id'],
['users.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'anamneses', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('paciente_id', sa.Integer(), nullable=True),
sa.Column('qtdAtividadeFisica', sa.Integer(), nullable=True),
sa.Column('tipoExercicio', sa.String(length=150), nullable=True),
sa.Column('horaAcorda', sa.TIME(), nullable=True),
sa.Column('padraoRefeicao', sa.String(length=150), nullable=True),
sa.Column('deficienciaAlimentacaoDiaria',
sa.String(length=250),
nullable=True),
sa.Column('necessitaSuplementoAlimentar',
sa.String(length=150),
nullable=True),
sa.Column('retencaoLiquido', sa.Boolean(), nullable=True),
sa.Column('alergiaRemedio', sa.String(length=150), nullable=True),
sa.Column('alergiaSuplemento', sa.String(length=150), nullable=True),
sa.Column('intoleranciaAlimentar',
sa.String(length=150),
nullable=True),
sa.Column('problemaSaude', sa.String(length=150), nullable=True),
sa.Column('problemaSaudeFamilia', sa.String(length=150),
nullable=True),
sa.Column('medicacao', sa.String(length=150), nullable=True),
sa.Column('suplementacao', sa.String(length=150), nullable=True),
sa.ForeignKeyConstraint(
['paciente_id'],
['pacientes.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'consultas', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('paciente_id', sa.Integer(), nullable=False),
sa.Column('tipoAtendimento_id', sa.Integer(), nullable=False),
sa.Column('horario_id', sa.Integer(), nullable=True),
sa.Column('tipoEstado_id', sa.Integer(), nullable=False),
sa.Column('antropometria_id', sa.Integer(), nullable=True),
sa.Column('dieta', sa.LargeBinary(), nullable=True),
sa.Column('pagamento', sa.Boolean(), nullable=True),
sa.ForeignKeyConstraint(
['antropometria_id'],
['antropometrias.id'],
), sa.ForeignKeyConstraint(
['horario_id'],
['ocupados.id'],
), sa.ForeignKeyConstraint(
['paciente_id'],
['pacientes.id'],
),
sa.ForeignKeyConstraint(
['tipoAtendimento_id'],
['tipoAtendimentos.id'],
), sa.ForeignKeyConstraint(
['tipoEstado_id'],
['tipoEstados.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'refeicoes', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('anamnese_id', sa.Integer(), nullable=False),
sa.Column('tipoRefeicao_id', sa.Integer(), nullable=False),
sa.Column('horario', sa.TIME(), nullable=False),
sa.Column('refeicao', sa.Text(), nullable=False),
sa.ForeignKeyConstraint(
['anamnese_id'],
['anamneses.id'],
), sa.ForeignKeyConstraint(
['tipoRefeicao_id'],
['tipoRefeicoes.id'],
), sa.PrimaryKeyConstraint('id'))
sa.Column('notifications', sa.Boolean(), nullable=False),
sa.Column('sms', sa.Boolean(), nullable=False),
sa.Column('pb', sa.Boolean(), nullable=False),
sa.Column('email', sa.Boolean(), nullable=False),
)
scheduled_jobs = sa.Table(
'scheduled_jobs',
metadata,
sa.Column('job_id', sa.Integer(), primary_key=True, nullable=False),
sa.Column('zone',
sa.VARCHAR(collation='utf8_unicode_ci', length=15),
nullable=False),
sa.Column('zone_job', sa.Integer(), nullable=False),
sa.Column('job_enabled', sa.Boolean(), nullable=False),
sa.Column('job_start_time', sa.TIME(), nullable=False),
sa.Column('job_stop_time', sa.TIME(), nullable=False),
sa.Column('job_duration', sa.Integer(), nullable=False),
sa.Column('job_running', sa.Boolean(), nullable=False),
sa.Column('monday', sa.Boolean(), nullable=False),
sa.Column('tuesday', sa.Boolean(), nullable=False),
sa.Column('wednesday', sa.Boolean(), nullable=False),
sa.Column('thursday', sa.Boolean(), nullable=False),
sa.Column('friday', sa.Boolean(), nullable=False),
sa.Column('saturday', sa.Boolean(), nullable=False),
sa.Column('sunday', sa.Boolean(), nullable=False),
sa.Column('forced_stop_manually', sa.Boolean(), nullable=False),
)
zones_currently_running = sa.Table(
'zones_currently_running', metadata,
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column('article', sa.Column('createTime', sa.TIME(),
nullable=False))
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.drop_column('member', 'lecture_num')
op.create_table(
'comment', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('content', sa.TEXT(), nullable=True),
sa.Column('voice_filename', sa.VARCHAR(length=128), nullable=True),
sa.Column('timestamp', sa.DATETIME(), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'faq', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('number', sa.INTEGER(), nullable=False),
sa.Column('title', sa.VARCHAR(length=256), nullable=False),
sa.Column('content_filename', sa.VARCHAR(length=64), nullable=False),
sa.Column('content_url', sa.VARCHAR(length=256), nullable=False),
sa.Column('register_timestamp', sa.DATETIME(), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'reservation', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('arrival_date', sa.DATE(), nullable=True),
sa.Column('departure_date', sa.DATE(), nullable=True),
sa.Column('guest_id', sa.INTEGER(), nullable=True),
sa.Column('room_number', sa.VARCHAR(length=64), nullable=True),
sa.Column('checkout_time', sa.TIME(), nullable=True),
sa.Column('checkin_time', sa.TIME(), nullable=True),
sa.Column('register_timestamp', sa.DATETIME(), nullable=True),
sa.ForeignKeyConstraint(
['guest_id'],
['guest.id'],
), sa.ForeignKeyConstraint(
['room_number'],
['room.number'],
), sa.PrimaryKeyConstraint('id'))
op.create_table('room',
sa.Column('number', sa.VARCHAR(length=64), nullable=False),
sa.Column('type', sa.VARCHAR(length=64), nullable=False),
sa.Column('tower', sa.VARCHAR(length=32), nullable=True),
sa.Column('floor', sa.VARCHAR(length=32), nullable=True),
sa.PrimaryKeyConstraint('number'))
op.create_table(
'signage_play_time', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('signage_group_id', sa.INTEGER(), nullable=False),
sa.Column('play_time', sa.INTEGER(), nullable=True),
sa.ForeignKeyConstraint(
['signage_group_id'],
['signage_group.id'],
), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('play_time'))
op.create_table(
'service_class', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('title', sa.VARCHAR(length=128), nullable=False),
sa.Column('subtitle', sa.VARCHAR(length=256), nullable=True),
sa.Column('image_filename', sa.VARCHAR(length=128), nullable=True),
sa.Column('image_url', sa.VARCHAR(length=128), nullable=True),
sa.Column('register_timestamp', sa.DATETIME(), nullable=True),
sa.Column('recent_update_timestamp', sa.DATETIME(), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'chat_message', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('sender_id', sa.INTEGER(), nullable=True),
sa.Column('channel_id', sa.INTEGER(), nullable=True),
sa.Column('timestamp', sa.DATETIME(), nullable=True),
sa.Column('voice_filename', sa.VARCHAR(length=128), nullable=True),
sa.Column('type', sa.VARCHAR(length=64), nullable=False),
sa.Column('content_english', sa.TEXT(), nullable=True),
sa.Column('content_arabic', sa.TEXT(), nullable=True),
sa.Column('content_spanish', sa.TEXT(), nullable=True),
sa.ForeignKeyConstraint(
['channel_id'],
['chat_channel.id'],
), sa.ForeignKeyConstraint(
['sender_id'],
['employee.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'chat_member', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('channel_id', sa.INTEGER(), nullable=True),
sa.Column('person_id', sa.INTEGER(), nullable=True),
sa.Column('type', sa.VARCHAR(length=64), nullable=True),
sa.ForeignKeyConstraint(
['channel_id'],
['chat_channel.id'],
), sa.ForeignKeyConstraint(
['person_id'],
['employee.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'requirement', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('content_english', sa.TEXT(), nullable=False),
sa.Column('content_spanish', sa.TEXT(), nullable=True),
sa.Column('content_arabic', sa.TEXT(), nullable=True),
sa.Column('room_number', sa.VARCHAR(length=64), nullable=True),
sa.Column('register_timestamp', sa.DATETIME(), nullable=True),
sa.Column('status', sa.INTEGER(), nullable=True),
sa.Column('priority', sa.INTEGER(), nullable=True),
sa.Column('wip_employee_id', sa.INTEGER(), nullable=True),
sa.Column('done_employee_id', sa.INTEGER(), nullable=True),
sa.Column('wip_timestamp', sa.DATETIME(), nullable=True),
sa.Column('done_timestamp', sa.DATETIME(), nullable=True),
sa.Column('sender_employee_id', sa.INTEGER(), nullable=True),
sa.ForeignKeyConstraint(
['done_employee_id'],
['employee.id'],
), sa.ForeignKeyConstraint(
['sender_employee_id'],
['employee.id'],
), sa.ForeignKeyConstraint(
['wip_employee_id'],
['employee.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'attraction_class', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('title', sa.VARCHAR(length=128), nullable=False),
sa.Column('subtitle', sa.VARCHAR(length=256), nullable=True),
sa.Column('image_filename', sa.VARCHAR(length=128), nullable=True),
sa.Column('register_timestamp', sa.DATETIME(), nullable=True),
sa.Column('recent_update_timestamp', sa.DATETIME(), nullable=True),
sa.Column('image_url', sa.VARCHAR(length=128), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'location_log', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('phone_id', sa.INTEGER(), nullable=False),
sa.Column('lat', sa.FLOAT(), nullable=True),
sa.Column('lng', sa.FLOAT(), nullable=True),
sa.Column('accuracy', sa.FLOAT(), nullable=True),
sa.Column('ap_name', sa.VARCHAR(length=128), nullable=True),
sa.Column('recent_ap_name', sa.VARCHAR(length=128), nullable=True),
sa.Column('register_timestamp', sa.DATETIME(), nullable=True),
sa.ForeignKeyConstraint(
['phone_id'],
['phone.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'clean', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('employee_id', sa.INTEGER(), nullable=False),
sa.Column('room_number', sa.VARCHAR(length=64), nullable=False),
sa.Column('register_timestamp', sa.DATETIME(), nullable=True),
sa.Column('assign_date', sa.DATE(), nullable=False),
sa.Column('status', sa.VARCHAR(length=64), nullable=True),
sa.ForeignKeyConstraint(
['employee_id'],
['employee.id'],
), sa.ForeignKeyConstraint(
['room_number'],
['room.number'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'phone', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('uuid', sa.VARCHAR(length=128), nullable=True),
sa.Column('gcm_register_id', sa.VARCHAR(length=256), nullable=True),
sa.Column('name', sa.VARCHAR(length=64), nullable=True),
sa.Column('room_number', sa.VARCHAR(length=64), nullable=True),
sa.Column('phone_model', sa.VARCHAR(length=64), nullable=True),
sa.Column('floor', sa.VARCHAR(length=32), nullable=True),
sa.Column('recent_notice_timestamp', sa.DATETIME(), nullable=True),
sa.Column('register_timestamp', sa.DATETIME(), nullable=True),
sa.Column('clean_date_time', sa.TIME(), nullable=True),
sa.Column('recent_heartbeat_timestamp', sa.DATETIME(), nullable=True),
sa.Column('recent_ap_name', sa.VARCHAR(length=64), nullable=True),
sa.Column('is_paired', sa.BOOLEAN(), nullable=True),
sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('name'),
sa.UniqueConstraint('room_number'))
op.create_table(
'attraction', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('attraction_class_id', sa.INTEGER(), nullable=False),
sa.Column('title', sa.VARCHAR(length=128), nullable=False),
sa.Column('subtitle', sa.VARCHAR(length=256), nullable=True),
sa.Column('image_filename', sa.VARCHAR(length=128), nullable=True),
sa.Column('image_url', sa.VARCHAR(length=128), nullable=True),
sa.Column('content', sa.TEXT(), nullable=True),
sa.Column('content_url', sa.VARCHAR(length=128), nullable=True),
sa.Column('phone_number', sa.VARCHAR(length=64), nullable=True),
sa.Column('website_url', sa.VARCHAR(length=128), nullable=True),
sa.Column('register_timestamp', sa.DATETIME(), nullable=True),
sa.Column('recent_update_timestamp', sa.DATETIME(), nullable=True),
sa.ForeignKeyConstraint(
['attraction_class_id'],
['attraction_class.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table('survey', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('title', sa.VARCHAR(length=256), nullable=True),
sa.Column('max_point', sa.FLOAT(), nullable=True),
sa.Column('type', sa.VARCHAR(length=64), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'push_notification', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('employee_id', sa.INTEGER(), nullable=True),
sa.Column('success', sa.BOOLEAN(), nullable=False),
sa.Column('msg', sa.TEXT(), nullable=False),
sa.ForeignKeyConstraint(
['employee_id'],
['employee.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'room_status', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('room_number', sa.VARCHAR(length=64), nullable=False),
sa.Column('fo_status', sa.VARCHAR(length=32), nullable=False),
sa.Column('employee_id', sa.INTEGER(), nullable=True),
sa.Column('timestamp', sa.DATETIME(), nullable=True),
sa.Column('register_timestamp', sa.DATETIME(), nullable=True),
sa.ForeignKeyConstraint(
['employee_id'],
['employee.id'],
), sa.ForeignKeyConstraint(
['room_number'],
['room.number'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'guest_requirement', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('content_english', sa.TEXT(), nullable=False),
sa.Column('content_spanish', sa.TEXT(), nullable=True),
sa.Column('content_arabic', sa.TEXT(), nullable=True),
sa.Column('room_number', sa.VARCHAR(length=64), nullable=True),
sa.Column('floor', sa.VARCHAR(length=64), nullable=True),
sa.Column('register_timestamp', sa.DATETIME(), nullable=True),
sa.Column('status', sa.INTEGER(), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_table('authority',
sa.Column('label', sa.VARCHAR(length=64), nullable=False),
sa.PrimaryKeyConstraint('label'))
op.create_table(
'inspection_result', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('point', sa.INTEGER(), nullable=True),
sa.Column('comment_id', sa.INTEGER(), nullable=True),
sa.Column('inspection_id', sa.INTEGER(), nullable=False),
sa.Column('inspection_form_id', sa.INTEGER(), nullable=True),
sa.Column('register_timestamp', sa.DATETIME(), nullable=True),
sa.ForeignKeyConstraint(
['comment_id'],
['comment.id'],
),
sa.ForeignKeyConstraint(
['inspection_form_id'],
['inspection_form.id'],
), sa.ForeignKeyConstraint(
['inspection_id'],
['inspection.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'positionAuthority',
sa.Column('position_label', sa.VARCHAR(length=64), nullable=False),
sa.Column('authority_label', sa.VARCHAR(length=64), nullable=False),
sa.ForeignKeyConstraint(
['authority_label'],
['authority.label'],
), sa.ForeignKeyConstraint(
['position_label'],
['position.label'],
), sa.PrimaryKeyConstraint('position_label', 'authority_label'))
op.create_table('guest', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('level', sa.VARCHAR(length=64), nullable=True),
sa.Column('state', sa.VARCHAR(length=64), nullable=True),
sa.ForeignKeyConstraint(
['id'],
['person.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'person', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('first_name', sa.VARCHAR(length=64), nullable=False),
sa.Column('middle_name', sa.VARCHAR(length=64), nullable=True),
sa.Column('last_name', sa.VARCHAR(length=64), nullable=False),
sa.Column('register_timestamp', sa.DATETIME(), nullable=True),
sa.Column('recent_login_timestamp', sa.DATETIME(), nullable=True),
sa.Column('type', sa.VARCHAR(length=64), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'hotel', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('image_filename', sa.VARCHAR(length=128), nullable=True),
sa.Column('image_url', sa.VARCHAR(length=128), nullable=True),
sa.Column('phone_number', sa.VARCHAR(length=64), nullable=True),
sa.Column('website_url', sa.VARCHAR(length=128), nullable=True),
sa.Column('facebook_url', sa.VARCHAR(length=128), nullable=True),
sa.Column('twitter_url', sa.VARCHAR(length=128), nullable=True),
sa.Column('tripadvisor_url', sa.VARCHAR(length=128), nullable=True),
sa.Column('yelp_url', sa.VARCHAR(length=128), nullable=True),
sa.Column('instagram_url', sa.VARCHAR(length=128), nullable=True),
sa.Column('pinterest_url', sa.VARCHAR(length=128), nullable=True),
sa.Column('content_filename', sa.VARCHAR(length=128), nullable=True),
sa.Column('content_url', sa.VARCHAR(length=128), nullable=True),
sa.Column('register_timestamp', sa.DATETIME(), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'push', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('person_id', sa.INTEGER(), nullable=False),
sa.Column('register_id', sa.VARCHAR(length=128), nullable=False),
sa.Column('device_type', sa.VARCHAR(length=64), nullable=True),
sa.Column('region_id', sa.VARCHAR(length=32), nullable=True),
sa.ForeignKeyConstraint(
['person_id'],
['person.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'inspection', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('employee_id', sa.INTEGER(), nullable=True),
sa.Column('clean_id', sa.INTEGER(), nullable=True),
sa.Column('room_number', sa.VARCHAR(length=64), nullable=False),
sa.Column('assign_date', sa.DATE(), nullable=False),
sa.Column('max_point', sa.INTEGER(), nullable=True),
sa.Column('received_point', sa.INTEGER(), nullable=True),
sa.Column('register_timestamp', sa.DATETIME(), nullable=True),
sa.Column('complete_timestamp', sa.DATETIME(), nullable=True),
sa.Column('inspection_type', sa.VARCHAR(length=32), nullable=True),
sa.Column('inspection_status', sa.VARCHAR(length=32), nullable=True),
sa.Column('comment_id', sa.INTEGER(), nullable=True),
sa.ForeignKeyConstraint(
['clean_id'],
['clean.id'],
), sa.ForeignKeyConstraint(
['comment_id'],
['comment.id'],
), sa.ForeignKeyConstraint(
['employee_id'],
['employee.id'],
), sa.ForeignKeyConstraint(
['room_number'],
['room.number'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'signage_group', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('name', sa.VARCHAR(length=256), nullable=True),
sa.Column('signage_number', sa.INTEGER(), nullable=True),
sa.Column('register_timestamp', sa.DATETIME(), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_table('inspection_form',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('type', sa.VARCHAR(length=64), nullable=False),
sa.Column('description', sa.TEXT(), nullable=False),
sa.Column('point', sa.INTEGER(), nullable=False),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'signage', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('signage_group_id', sa.INTEGER(), nullable=False),
sa.Column('name', sa.VARCHAR(length=256), nullable=True),
sa.Column('duration', sa.INTEGER(), nullable=True),
sa.Column('status', sa.VARCHAR(length=16), nullable=True),
sa.Column('title_content', sa.VARCHAR(length=256), nullable=True),
sa.Column('title_typeface', sa.VARCHAR(length=64), nullable=True),
sa.Column('title_weight', sa.VARCHAR(length=64), nullable=True),
sa.Column('title_color', sa.VARCHAR(length=64), nullable=True),
sa.Column('title_size', sa.VARCHAR(length=32), nullable=True),
sa.Column('title_alignment', sa.VARCHAR(length=64), nullable=True),
sa.Column('title_line_height', sa.VARCHAR(length=32), nullable=True),
sa.Column('title_box_width', sa.FLOAT(), nullable=True),
sa.Column('title_box_height', sa.FLOAT(), nullable=True),
sa.Column('title_box_left', sa.FLOAT(), nullable=True),
sa.Column('title_box_top', sa.FLOAT(), nullable=True),
sa.Column('text_content', sa.TEXT(), nullable=True),
sa.Column('text_typeface', sa.VARCHAR(length=64), nullable=True),
sa.Column('text_weight', sa.VARCHAR(length=64), nullable=True),
sa.Column('text_color', sa.VARCHAR(length=64), nullable=True),
sa.Column('text_size', sa.VARCHAR(length=32), nullable=True),
sa.Column('text_alignment', sa.VARCHAR(length=64), nullable=True),
sa.Column('text_line_height', sa.VARCHAR(length=32), nullable=True),
sa.Column('text_box_width', sa.FLOAT(), nullable=True),
sa.Column('text_box_height', sa.FLOAT(), nullable=True),
sa.Column('text_box_left', sa.FLOAT(), nullable=True),
sa.Column('text_box_top', sa.FLOAT(), nullable=True),
sa.Column('signage_filename', sa.VARCHAR(length=64), nullable=True),
sa.Column('signage_url', sa.VARCHAR(length=256), nullable=True),
sa.Column('image_filename', sa.VARCHAR(length=128), nullable=True),
sa.Column('image_url', sa.VARCHAR(length=256), nullable=True),
sa.Column('thumbnail_filename', sa.VARCHAR(length=128), nullable=True),
sa.Column('thumbnail_url', sa.VARCHAR(length=256), nullable=True),
sa.Column('link_url', sa.VARCHAR(length=256), nullable=True),
sa.Column('signage_number', sa.INTEGER(), nullable=True),
sa.Column('recent_update_timestamp', sa.DATETIME(), nullable=True),
sa.Column('register_timestamp', sa.DATETIME(), nullable=True),
sa.ForeignKeyConstraint(
['signage_group_id'],
['signage_group.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table('position',
sa.Column('label', sa.VARCHAR(length=64), nullable=False),
sa.PrimaryKeyConstraint('label'))
op.create_table(
'survey_answer', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('guest_requirement_id', sa.INTEGER(), nullable=False),
sa.Column('survey_id', sa.INTEGER(), nullable=False),
sa.Column('point', sa.FLOAT(), nullable=True),
sa.Column('comment', sa.TEXT(), nullable=True),
sa.ForeignKeyConstraint(
['guest_requirement_id'],
['guest_requirement.id'],
), sa.ForeignKeyConstraint(
['survey_id'],
['survey.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table('chat_channel',
sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('name', sa.VARCHAR(length=64), nullable=False),
sa.Column('timestamp', sa.DATETIME(), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'service', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('service_class_id', sa.INTEGER(), nullable=False),
sa.Column('title', sa.VARCHAR(length=128), nullable=False),
sa.Column('subtitle', sa.VARCHAR(length=256), nullable=True),
sa.Column('image_filename', sa.VARCHAR(length=128), nullable=True),
sa.Column('image_url', sa.VARCHAR(length=128), nullable=True),
sa.Column('content', sa.TEXT(), nullable=True),
sa.Column('content_url', sa.VARCHAR(length=128), nullable=True),
sa.Column('phone_number', sa.VARCHAR(length=64), nullable=True),
sa.Column('website_url', sa.VARCHAR(length=128), nullable=True),
sa.Column('register_timestamp', sa.DATETIME(), nullable=True),
sa.Column('recent_update_timestamp', sa.DATETIME(), nullable=True),
sa.ForeignKeyConstraint(
['service_class_id'],
['service_class.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'requirement_employee',
sa.Column('requirement_id', sa.INTEGER(), nullable=False),
sa.Column('employee_id', sa.INTEGER(), nullable=False),
sa.ForeignKeyConstraint(
['employee_id'],
['employee.id'],
), sa.ForeignKeyConstraint(
['requirement_id'],
['requirement.id'],
), sa.PrimaryKeyConstraint('requirement_id', 'employee_id'))
op.create_table(
'chat_read', sa.Column('message_id', sa.INTEGER(), nullable=False),
sa.Column('employee_id', sa.INTEGER(), nullable=False),
sa.Column('token', sa.VARCHAR(length=64), nullable=False),
sa.Column('is_read', sa.BOOLEAN(), nullable=True),
sa.ForeignKeyConstraint(
['employee_id'],
['employee.id'],
), sa.ForeignKeyConstraint(
['message_id'],
['chat_message.id'],
), sa.PrimaryKeyConstraint('message_id', 'employee_id'))
op.create_table(
'notice', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('register_timestamp', sa.DATETIME(), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'memo', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('room_number', sa.VARCHAR(length=64), nullable=True),
sa.Column('content_english', sa.TEXT(), nullable=True),
sa.Column('content_spanish', sa.TEXT(), nullable=True),
sa.Column('content_arabic', sa.TEXT(), nullable=True),
sa.Column('employee_id', sa.INTEGER(), nullable=True),
sa.Column('timestamp', sa.DATETIME(), nullable=True),
sa.ForeignKeyConstraint(
['employee_id'],
['employee.id'],
), sa.ForeignKeyConstraint(
['room_number'],
['room.number'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'employee', sa.Column('id', sa.INTEGER(), nullable=False),
sa.Column('userid', sa.VARCHAR(length=256), nullable=True),
sa.Column('password_hash', sa.VARCHAR(length=256), nullable=False),
sa.Column('position', sa.VARCHAR(length=64), nullable=False),
sa.Column('state', sa.VARCHAR(length=64), nullable=False),
sa.Column('department', sa.VARCHAR(length=64), nullable=True),
sa.ForeignKeyConstraint(
['id'],
['person.id'],
), sa.ForeignKeyConstraint(
['position'],
['position.label'],
), sa.PrimaryKeyConstraint('id'))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('perfil', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=250), nullable=False),
sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('id'))
op.create_table('speciality', sa.Column('id', sa.Integer(),
nullable=False),
sa.Column('name', sa.String(length=250), nullable=False),
sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('id'))
op.create_table(
'user', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('first_name', sa.String(length=250), nullable=True),
sa.Column('last_name', sa.String(length=250), nullable=True),
sa.Column('email', sa.String(length=250), nullable=False),
sa.Column('phone', sa.Integer(), nullable=True),
sa.Column('password', sa.String(length=255), nullable=True),
sa.Column('perfil_id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(
['perfil_id'],
['perfil.id'],
), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('email'))
op.create_table(
'specialist', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('speciality_id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=250), nullable=False),
sa.ForeignKeyConstraint(
['id'],
['user.id'],
), sa.ForeignKeyConstraint(
['speciality_id'],
['speciality.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'working_hours', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('speciality_id', sa.Integer(), nullable=False),
sa.Column('specialist_id', sa.Integer(), nullable=False),
sa.Column('time', sa.TIME(), nullable=False),
sa.ForeignKeyConstraint(
['specialist_id'],
['specialist.id'],
), sa.ForeignKeyConstraint(
['speciality_id'],
['speciality.id'],
), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('id'))
op.create_table(
'appointment', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('user_id', sa.Integer(), nullable=False),
sa.Column('speciality_id', sa.Integer(), nullable=False),
sa.Column('specialist_id', sa.Integer(), nullable=False),
sa.Column('working_hour_id', sa.Integer(), nullable=False),
sa.Column('pet_name', sa.String(length=250), nullable=False),
sa.Column('pet', sa.String(length=250), nullable=False),
sa.Column('date', sa.Date(), nullable=False),
sa.ForeignKeyConstraint(
['specialist_id'],
['specialist.id'],
), sa.ForeignKeyConstraint(
['speciality_id'],
['speciality.id'],
), sa.ForeignKeyConstraint(
['user_id'],
['user.id'],
), sa.ForeignKeyConstraint(
['working_hour_id'],
['working_hours.id'],
), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('id'))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'restaurant_chain', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('created_at', sa.DateTime(timezone=True), nullable=True),
sa.Column('updated_at', sa.DateTime(timezone=True), nullable=True),
sa.Column('restaurant_chain_name', sa.String(), nullable=True),
sa.Column('restaurant_chain_category', sa.Integer(), nullable=True),
sa.Column('restaurant_chain_desc', sa.Text(), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_restaurant_chain_id'),
'restaurant_chain', ['id'],
unique=False)
op.create_table(
'hotel_collection', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('created_at', sa.DateTime(timezone=True), nullable=True),
sa.Column('updated_at', sa.DateTime(timezone=True), nullable=True),
sa.Column('hotel_id', sa.Integer(), nullable=True),
sa.Column('collection_name', sa.String(), nullable=True),
sa.Column('featured', sa.Boolean(), nullable=True),
sa.Column('desc', sa.Text(), nullable=True),
sa.Column('image', sa.String(), nullable=True),
sa.ForeignKeyConstraint(
['hotel_id'],
['hotel.id'],
), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('hotel_id'))
op.create_index(op.f('ix_hotel_collection_id'),
'hotel_collection', ['id'],
unique=False)
op.create_table(
'collection_product', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('created_at', sa.DateTime(timezone=True), nullable=True),
sa.Column('updated_at', sa.DateTime(timezone=True), nullable=True),
sa.Column('hotel_collection_id', sa.Integer(), nullable=False),
sa.Column('product_url', sa.String(), nullable=True),
sa.Column('product_name', sa.String(), nullable=True),
sa.Column('featured_product', sa.Boolean(), nullable=True),
sa.Column('product_desc', sa.Text(), nullable=True),
sa.Column('product_image', sa.String(), nullable=True),
sa.ForeignKeyConstraint(
['hotel_collection_id'],
['hotel_collection.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_collection_product_id'),
'collection_product', ['id'],
unique=False)
op.add_column('restaurant',
sa.Column('break_interval', sa.Integer(), nullable=True))
op.add_column('restaurant',
sa.Column('break_time', sa.TIME(), nullable=True))
op.add_column('restaurant',
sa.Column('closing_time', sa.TIME(), nullable=True))
op.add_column('restaurant',
sa.Column('mode_of_payment', sa.Integer(), nullable=True))
op.add_column('restaurant',
sa.Column('off_day_in_week', sa.String(), nullable=True))
op.add_column('restaurant',
sa.Column('opening_time', sa.TIME(), nullable=True))
op.add_column(
'restaurant',
sa.Column('restaurant_chain_id', sa.Integer(), nullable=True))
op.add_column('restaurant', sa.Column('state', sa.String(), nullable=True))
op.create_foreign_key(None, 'restaurant', 'restaurant_chain',
['restaurant_chain_id'], ['id'])
def upgrade():
### commands auto generated by Alembic - please adjust! ###
op.create_table(
'xignite_security_bars',
sa.Column('symbol',
mysql.VARCHAR(charset='latin1',
collation='latin1_swedish_ci',
length=20),
nullable=False),
sa.Column('StartDate', sa.DATE(), nullable=False),
sa.Column('StartTime', sa.TIME(), nullable=False),
sa.Column('EndDate', sa.DATE(), nullable=False),
sa.Column('EndTime', sa.TIME(), nullable=False),
sa.Column('UTCOffset', sa.FLOAT(), nullable=False),
sa.Column('Open', sa.FLOAT(), nullable=False),
sa.Column('High', sa.FLOAT(), nullable=False),
sa.Column('Low', sa.FLOAT(), nullable=False),
sa.Column('Close', sa.FLOAT(), nullable=False),
sa.Column('Volume', sa.INTEGER(), nullable=False),
sa.Column('Trades', sa.INTEGER(), nullable=False),
sa.ForeignKeyConstraint(['symbol'], [u'xignite_securty.symbol'],
name='xignite_security_bars_to_security_fk',
onupdate='CASCADE',
ondelete='CASCADE'),
sa.PrimaryKeyConstraint('symbol', 'StartDate', 'StartTime', 'EndDate',
'EndTime', 'UTCOffset'))
op.create_table(
'emitted_stock_volume',
sa.Column('symbol',
mysql.VARCHAR(charset='latin1',
collation='latin1_swedish_ci',
length=20),
nullable=False),
sa.Column('StartDate', sa.DATE(), nullable=False),
sa.Column('StartTime', sa.TIME(), nullable=False),
sa.Column('EndDate', sa.DATE(), nullable=False),
sa.Column('EndTime', sa.TIME(), nullable=False),
sa.Column('UTCOffset', sa.FLOAT(), nullable=False),
sa.Column('sent', sa.DATETIME(), nullable=True),
sa.ForeignKeyConstraint([
'symbol', 'StartDate', 'StartTime', 'EndDate', 'EndTime',
'UTCOffset'
], [
'xignite_security_bars.symbol', 'xignite_security_bars.StartDate',
'xignite_security_bars.StartTime', 'xignite_security_bars.EndDate',
'xignite_security_bars.EndTime', 'xignite_security_bars.UTCOffset'
],
onupdate='CASCADE',
ondelete='CASCADE'),
sa.PrimaryKeyConstraint('symbol', 'StartDate', 'StartTime', 'EndDate',
'EndTime', 'UTCOffset'))
op.create_index('xignite_stock_volume_sent_idx',
'emitted_stock_volume', ['sent'],
unique=False)
op.create_table(
'emitted_stock_price',
sa.Column('symbol',
mysql.VARCHAR(charset='latin1',
collation='latin1_swedish_ci',
length=20),
nullable=False),
sa.Column('StartDate', sa.DATE(), nullable=False),
sa.Column('StartTime', sa.TIME(), nullable=False),
sa.Column('EndDate', sa.DATE(), nullable=False),
sa.Column('EndTime', sa.TIME(), nullable=False),
sa.Column('UTCOffset', sa.FLOAT(), nullable=False),
sa.Column('sent', sa.DATETIME(), nullable=True),
sa.ForeignKeyConstraint([
'symbol', 'StartDate', 'StartTime', 'EndDate', 'EndTime',
'UTCOffset'
], [
'xignite_security_bars.symbol', 'xignite_security_bars.StartDate',
'xignite_security_bars.StartTime', 'xignite_security_bars.EndDate',
'xignite_security_bars.EndTime', 'xignite_security_bars.UTCOffset'
],
onupdate='CASCADE',
ondelete='CASCADE'),
sa.PrimaryKeyConstraint('symbol', 'StartDate', 'StartTime', 'EndDate',
'EndTime', 'UTCOffset'))
op.create_index('xignite_stock_price_sent_idx',
'emitted_stock_price', ['sent'],
unique=False)
Stock = sa.Table(
'sma_fund_holding_stock',
metadata,
sa.Column('secucode_id', sa.String(12)),
sa.Column('stockcode', sa.String(12)),
sa.Column('date', sa.DATE())
)
Price = sa.Table(
'sma_stocks_realtime_price',
metadata,
sa.Column('secucode', sa.String(12)),
sa.Column('price', sa.DECIMAL(10, 2)),
sa.Column('prev_close', sa.DECIMAL(10, 2)),
sa.Column('date', sa.DATE()),
sa.Column('time', sa.TIME())
)
Observe = sa.Table(
'sma_observe_pool',
metadata,
sa.Column('secucode_id', sa.String(12))
)
async def etf_in_portfolio() -> list:
"""获取持仓中的etf"""
query = sa.select([Holding.c.secucode]).where(
Holding.columns.date == sa.select([sa.func.max(Holding.columns.date)]).scalar_subquery(),
Holding.c.trade_market.in_([1, 2])
)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column('appointments', sa.Column('time', sa.TIME(), nullable=True))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column('parties', sa.Column('date', sa.DATE(), nullable=True))
op.add_column('parties', sa.Column('time', sa.TIME(), nullable=True))
op.drop_column('parties', 'timestamp')
