def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column(
'menu',
sa.Column('class_id', sa.BIGINT(), autoincrement=False, nullable=True))
op.drop_constraint(None, 'menu', type_='foreignkey')
op.create_foreign_key('menu_class_id_fkey', 'menu', 'class', ['class_id'],
['class_id'])
op.alter_column('menu',
'name',
existing_type=sa.VARCHAR(length=128),
nullable=True)
op.drop_column('menu', 'category_id')
op.create_table(
'class',
sa.Column('class_id', sa.BIGINT(), autoincrement=True, nullable=False),
sa.Column('name',
sa.VARCHAR(length=64),
autoincrement=False,
nullable=True),
sa.Column('order', sa.INTEGER(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('class_id', name='class_pkey'))
op.drop_table('category')
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.add_column(
'elbs',
sa.Column('account_id',
sa.BIGINT(),
autoincrement=False,
nullable=True))
op.create_foreign_key(u'elbs_account_id_fkey', 'elbs', 'accounts',
['account_id'], ['id'])
op.create_index('ix_elbs_account_id', 'elbs', ['account_id'], unique=False)
op.drop_column('destinations', 'plugin_name')
op.create_table(
'accounts',
sa.Column(
'id',
sa.INTEGER(),
server_default=sa.text(u"nextval('accounts_id_seq'::regclass)"),
nullable=False),
sa.Column('account_number',
sa.VARCHAR(length=32),
autoincrement=False,
nullable=True),
sa.Column('label',
sa.VARCHAR(length=32),
autoincrement=False,
nullable=True),
sa.Column('notes', sa.TEXT(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id', name=u'accounts_pkey'),
sa.UniqueConstraint('account_number',
name=u'accounts_account_number_key'),
postgresql_ignore_search_path=False)
op.create_table(
'certificate_account_associations',
sa.Column('account_id',
sa.INTEGER(),
autoincrement=False,
nullable=True),
sa.Column('certificate_id',
sa.INTEGER(),
autoincrement=False,
nullable=True),
sa.ForeignKeyConstraint(
['account_id'], [u'accounts.id'],
name=u'certificate_account_associations_account_id_fkey',
ondelete=u'CASCADE'),
sa.ForeignKeyConstraint(
['certificate_id'], [u'certificates.id'],
name=u'certificate_account_associations_certificate_id_fkey',
ondelete=u'CASCADE'))
class GcloudRouterQos(model_base.BASEV2, models_v2.HasId, models_v2.HasUserId,
models_v2.HasCreateTime, models_v2.HasTenant):
"""Represents a Router Qos .
This class is desgin for tengzheng project at 2016.3.2.
"""
__tablename__ = 'gcloud_router_qoss'
name = sa.Column(sa.String(length=36),
server_default=sa.text(u"''"),
nullable=True)
type = sa.Column(sa.String(length=36), nullable=True)
max_rate = sa.Column(sa.BIGINT(), autoincrement=False, nullable=False)
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_constraint('user_category_uc', 'user_category', type_='unique')
op.drop_constraint('game_guesses', 'guess', type_='unique')
op.drop_constraint('game_participants_id', 'game_participants', type_='unique')
op.create_table('tweeter_user',
sa.Column('id', sa.BIGINT(), autoincrement=True, nullable=False),
sa.Column('username', sa.VARCHAR(length=140), autoincrement=False, nullable=True),
sa.Column('name', sa.VARCHAR(length=240), autoincrement=False, nullable=True),
sa.Column('profile_image_url', sa.TEXT(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id', name='tweeter_user_pkey'),
sa.UniqueConstraint('name', name='tweeter_user_name_key'),
sa.UniqueConstraint('username', name='tweeter_user_username_key')
)
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'user', sa.Column('id',
sa.BIGINT(),
autoincrement=True,
nullable=False),
sa.Column('display_name',
sa.VARCHAR(length=32),
autoincrement=False,
nullable=True),
sa.PrimaryKeyConstraint('id', name='user_pkey'))
op.drop_table('greetings')
op.drop_table('users')
def upgrade():
op.create_table('timezone',
sa.Column('id', sa.BIGINT(), nullable=False),
sa.Column('name', sa.TEXT(), nullable=False),
sa.PrimaryKeyConstraint('id'),
schema='navitia')
op.create_table('tz_dst',
sa.Column('id', sa.BIGINT(), nullable=False),
sa.Column('tz_id', sa.BIGINT(), nullable=False),
sa.Column('beginning_date', sa.DATE(), nullable=False),
sa.Column('end_date', sa.DATE(), nullable=False),
sa.Column('utc_offset', sa.INTEGER(), nullable=False),
sa.ForeignKeyConstraint(['tz_id'],
[u'navitia.timezone.id'],
name=u'associated_tz_dst_fkey'),
sa.PrimaryKeyConstraint('id'),
schema='navitia')
op.add_column(u'meta_vj',
sa.Column('timezone', sa.BIGINT(), nullable=True),
schema=u'navitia')
op.drop_column(u'vehicle_journey',
'utc_to_local_offset',
schema=u'navitia')
def downgrade():
op.create_table(
"complaints",
sa.Column("id", sa.BIGINT(), autoincrement=True, nullable=False),
sa.Column(
"time",
postgresql.TIMESTAMP(timezone=True),
server_default=sa.text("now()"),
autoincrement=False,
nullable=False,
),
sa.Column("author_user_id",
sa.BIGINT(),
autoincrement=False,
nullable=False),
sa.Column("reported_user_id",
sa.BIGINT(),
autoincrement=False,
nullable=False),
sa.Column("reason", sa.VARCHAR(), autoincrement=False, nullable=False),
sa.Column("description",
sa.VARCHAR(),
autoincrement=False,
nullable=False),
sa.ForeignKeyConstraint(["author_user_id"], ["users.id"],
name="fk_complaints_author_user_id_users"),
sa.ForeignKeyConstraint(["reported_user_id"], ["users.id"],
name="fk_complaints_reported_user_id_users"),
sa.PrimaryKeyConstraint("id", name="pk_complaints"),
)
op.create_index("ix_complaints_reported_user_id",
"complaints", ["reported_user_id"],
unique=False)
op.create_index("ix_complaints_author_user_id",
"complaints", ["author_user_id"],
unique=False)
op.drop_table("content_reports")
def upgrade():
### commands auto generated by Alembic - please adjust! ###
op.create_table('gcloud_router_qoss',
sa.Column('id', sa.String(length=36), server_default=sa.text(u"''"), nullable=False),
sa.Column('name', sa.String(length=36), server_default=sa.text(u"''"), nullable=True),
sa.Column('type', sa.String(length=36), nullable=True),
sa.Column('max_rate', sa.BIGINT(), autoincrement=False, nullable=False),
sa.PrimaryKeyConstraint('id'),
sa.Column('create_time', sa.String(length=26), nullable=False),
sa.Column('user_id', sa.String(length=64), nullable=False),
sa.Column('tenant_id', sa.String(length=255), nullable=False)
)
op.create_table('gcloud_router_qosrules',
sa.Column('id', sa.String(length=36), nullable=False),
sa.Column('qos_id', sa.String(length=36), nullable=False),
sa.Column('max_rate', sa.BIGINT(), autoincrement=False, nullable=False),
sa.Column('name', sa.String(length=36), nullable=True),
sa.Column('create_time', sa.String(length=26), nullable=False),
sa.ForeignKeyConstraint(['qos_id'], [u'gcloud_router_qoss.id'], name=u'gcloud_route_qosrules_ibfk_1', ondelete=u'CASCADE'),
sa.PrimaryKeyConstraint('id')
)
op.create_table('gcloud_router_qosrule_binds',
sa.Column('id', sa.String(length=36), nullable=False),
sa.Column('qos_id', sa.String(length=36), nullable=False),
sa.Column('rule_id', sa.String(length=36), nullable=False),
sa.Column('src_ip', sa.String(length=32), nullable=False),
sa.Column('port_id', sa.String(length=36), nullable=False),
sa.Column('user_id', sa.String(length=64), nullable=False),
sa.Column('create_time', sa.String(length=26), nullable=False),
sa.Column('ip_type', sa.String(length=26), nullable=False),
sa.ForeignKeyConstraint(['port_id'], [u'ports.id'], name=u'gcloud_router_qosrule_binds_ibfk_3', ondelete=u'CASCADE'),
sa.ForeignKeyConstraint(['qos_id'], [u'gcloud_router_qoss.id'], name=u'gcloud_router_qosrule_binds_ibfk_1', ondelete=u'CASCADE'),
sa.ForeignKeyConstraint(['rule_id'], [u'gcloud_router_qosrules.id'], name=u'gcloud_router_qosrule_binds_ibfk_2', ondelete=u'CASCADE'),
sa.PrimaryKeyConstraint('id')
)
def upgrade():
op.drop_constraint('journey_pattern_route_id_fkey',
'journey_pattern',
schema='navitia')
op.drop_constraint('journey_pattern_physical_mode_id_fkey',
'journey_pattern',
schema='navitia')
op.drop_constraint('vehicle_journey_journey_pattern_id_fkey',
'vehicle_journey',
schema='navitia')
op.drop_constraint('stop_time_journey_pattern_point_id_fkey',
'stop_time',
schema='navitia')
op.drop_table('journey_pattern_point', schema='navitia')
op.drop_table('journey_pattern', schema='navitia')
op.add_column('stop_time',
sa.Column('order', sa.INTEGER(), nullable=True),
schema='navitia')
op.add_column('stop_time',
sa.Column('shape_from_prev',
ga.Geography(geometry_type='LINESTRING',
srid=4326,
spatial_index=False),
nullable=True),
schema='navitia')
op.add_column('stop_time',
sa.Column('stop_point_id', sa.BIGINT(), nullable=True),
schema='navitia')
op.drop_column('stop_time', 'journey_pattern_point_id', schema='navitia')
op.add_column('vehicle_journey',
sa.Column('physical_mode_id', sa.BIGINT(), nullable=True),
schema='navitia')
op.add_column('vehicle_journey',
sa.Column('route_id', sa.BIGINT(), nullable=True),
schema='navitia')
op.drop_column('vehicle_journey', 'journey_pattern_id', schema='navitia')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_constraint("ck_pages_main_page_owned_by_cluster")
op.drop_index("ix_pages_owner_cluster_id_type", table_name="pages")
op.add_column(
"pages",
sa.Column("main_page_for_cluster_id",
sa.BIGINT(),
autoincrement=False,
nullable=True))
op.create_foreign_key("fk_pages_main_page_for_cluster_id_clusters",
"pages", "clusters", ["main_page_for_cluster_id"],
["id"])
op.create_index("ix_pages_main_page_for_cluster_id",
"pages", ["main_page_for_cluster_id"],
unique=True)
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.alter_column('users',
'password',
existing_type=sa.String(length=255),
type_=sa.VARCHAR(),
existing_nullable=False)
op.alter_column('users',
'email',
existing_type=sa.String(length=255),
type_=sa.VARCHAR(),
existing_nullable=False)
op.alter_column('articles',
'id',
existing_type=sa.BIGINT(),
type_=sa.INTEGER())
class UsageRecord(Base):
__tablename__ = "usage_record"
__table_args__ = (
SA.Index("create_date_index", 'create_date'),
)
id = SA.Column(SA.BIGINT(), primary_key=True, autoincrement=True)
cpu_usage = SA.Column(SA.FLOAT)
server_load = SA.Column(SA.FLOAT)
memory_usage = SA.Column(SA.FLOAT)
disk_usage = SA.Column(SA.FLOAT)
mysql_cpu = SA.Column(SA.FLOAT)
mongo_cpu = SA.Column(SA.FLOAT)
other_service_status = SA.Column(SA.String(512))
robot_id = SA.Column(SA.INTEGER, nullable=False)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'admin', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('email', sa.String(length=120), nullable=False),
sa.Column('password_hash', sa.String(length=128), nullable=True),
sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('email'))
op.create_table(
'employee', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=120), nullable=False),
sa.Column('email', sa.String(length=120), nullable=False),
sa.Column('phone', sa.String(length=120), nullable=False),
sa.Column('location', sa.String(length=120), nullable=False),
sa.Column('salary', sa.BIGINT(), nullable=False),
sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('email'),
sa.UniqueConstraint('phone'))
