def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('cart',
sa.Column('cid', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('cnumber', sa.Integer(), nullable=True),
sa.Column('cprice', mysql.DOUBLE(asdecimal=True), nullable=True),
sa.Column('pid', sa.Integer(), nullable=True),
sa.Column('uid', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['pid'], ['product.pid'], ),
sa.ForeignKeyConstraint(['uid'], ['user.uid'], ),
sa.PrimaryKeyConstraint('cid')
)
op.create_index(op.f('ix_cart_cid'), 'cart', ['cid'], unique=False)
op.create_table('detailed_order',
sa.Column('detailedoid', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('number', sa.Integer(), nullable=True),
sa.Column('dprice', mysql.DOUBLE(asdecimal=True), nullable=True),
sa.Column('status', sa.String(length=50), nullable=True),
sa.Column('orderid', sa.Integer(), nullable=True),
sa.Column('pid', sa.Integer(), nullable=True),
sa.Column('oid', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['oid'], ['official_user.oid'], ),
sa.ForeignKeyConstraint(['orderid'], ['order.orderid'], ),
sa.ForeignKeyConstraint(['pid'], ['product.pid'], ),
sa.PrimaryKeyConstraint('detailedoid')
)
op.create_index(op.f('ix_detailed_order_detailedoid'), 'detailed_order', ['detailedoid'], unique=False)
class User(BASE):
__tablename__ = "users_main"
id = Column("ID", mysql.INTEGER(10, unsigned=True), primary_key=True)
username = Column('Username', mysql.VARCHAR(20))
email = Column('Email', mysql.VARCHAR(255))
pass_hash = Column('PassHash', mysql.VARCHAR(60))
secret = Column('Secret', mysql.VARCHAR(32))
irc_key = Column('IRCKey', mysql.CHAR(32))
last_login = Column('LastLogin', mysql.DATETIME)
last_access = Column('LastAccess', mysql.DATETIME)
ip = Column('IP', mysql.VARCHAR(15))
class_id = Column('Class', mysql.TINYINT(2))
uploaded = Column('Uploaded', mysql.BIGINT(20, unsigned=True))
downloaded = Column('Downloaded', mysql.BIGINT(20, unsigned=True))
title = Column('Title', mysql.TEXT)
enabled = Column('Enabled', mysql.ENUM('0', '1', '2'))
paranoia = Column('Paranoia', mysql.TEXT)
visible = Column('Visible', mysql.ENUM('1', '0'))
invites = Column('Invites', mysql.INTEGER(10, unsigned=True))
permission_id = Column('PermissionID', mysql.INTEGER(10, unsigned=True),
ForeignKey('permissions.ID'))
custom_permissions = Column('CustomPermissions', mysql.TEXT)
can_leech = Column('can_leech', mysql.TINYINT(4))
torrent_pass = Column('torrent_pass', mysql.CHAR(32))
required_ratio = Column('RequiredRatio', mysql.DOUBLE(10, 8))
required_ratio_work = Column('RequiredRatioWork', mysql.DOUBLE(10, 8))
ipcc = Column('ipcc', mysql.VARCHAR(2))
fl_tokens = Column('FLTokens', mysql.INTEGER(10))
permission_class = relationship("Permissions")
info = relationship("UsersInfo")
def get_paranoia(self):
return dict_to_list(unserialize(bytes(str(self.paranoia), 'utf-8')))
def upgrade():
### commands auto generated by Alembic - please adjust! ###
op.alter_column('core_sensor',
'last_value',
existing_type=mysql.VARCHAR(length=32),
type_=sa.Unicode(length=255),
existing_nullable=True)
op.alter_column('core_sensor',
'value_max',
existing_type=mysql.DOUBLE(asdecimal=True),
type_=sa.Float(precision=53),
existing_nullable=True)
op.alter_column('core_sensor',
'value_min',
existing_type=mysql.DOUBLE(asdecimal=True),
type_=sa.Float(precision=53),
existing_nullable=True)
op.alter_column('core_sensor_history',
'original_value_num',
existing_type=mysql.DOUBLE(asdecimal=True),
type_=sa.Float(precision=53),
existing_nullable=True)
op.alter_column('core_sensor_history',
'value_num',
existing_type=mysql.DOUBLE(asdecimal=True),
type_=sa.Float(precision=53),
existing_nullable=True)
op.alter_column('core_sensor_history',
'value_str',
existing_type=mysql.VARCHAR(length=32),
type_=sa.Unicode(length=255),
existing_nullable=False)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'order',
sa.Column('orderid', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('oprice', mysql.DOUBLE(asdecimal=True), nullable=True),
sa.Column('odate', sa.DateTime(), nullable=True),
sa.Column('address', sa.String(length=500), nullable=True),
sa.Column('status', sa.String(length=50), nullable=True),
sa.Column('uid', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['uid'],
['user.uid'],
), sa.PrimaryKeyConstraint('orderid'))
op.create_index(op.f('ix_order_orderid'),
'order', ['orderid'],
unique=False)
op.create_table(
'product',
sa.Column('pid', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('pname', sa.String(length=500), nullable=True),
sa.Column('pprice', mysql.DOUBLE(asdecimal=True), nullable=True),
sa.Column('pdate', sa.DateTime(), nullable=True),
sa.Column('remain', sa.Integer(), nullable=True),
sa.Column('description', sa.String(length=500), nullable=True),
sa.Column('oid', sa.Integer(), nullable=True),
sa.Column('typeid', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['oid'],
['official_user.oid'],
), sa.ForeignKeyConstraint(
['typeid'],
['type.typeid'],
), sa.PrimaryKeyConstraint('pid'), sa.UniqueConstraint('pname'))
op.create_index(op.f('ix_product_pid'), 'product', ['pid'], unique=False)
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column(
'collection',
sa.Column('longitude_f', mysql.DOUBLE(asdecimal=True), nullable=True))
op.add_column(
'collection',
sa.Column('latitude_f', mysql.DOUBLE(asdecimal=True), nullable=True))
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.add_column('invtypes', sa.Column('portionSize', mysql.INTEGER(display_width=11), autoincrement=False, nullable=True))
op.add_column('invtypes', sa.Column('basePrice', mysql.DECIMAL(precision=19, scale=4), nullable=True))
op.add_column('invtypes', sa.Column('mass', mysql.DOUBLE(asdecimal=True), nullable=True))
op.add_column('invtypes', sa.Column('soundID', mysql.BIGINT(display_width=20), autoincrement=False, nullable=True))
op.add_column('invtypes', sa.Column('volume', mysql.DOUBLE(asdecimal=True), nullable=True))
op.add_column('invtypes', sa.Column('published', mysql.TINYINT(display_width=4), autoincrement=False, nullable=True))
op.add_column('invtypes', sa.Column('iconID', mysql.BIGINT(display_width=20), autoincrement=False, nullable=True))
op.add_column('invtypes', sa.Column('raceID', mysql.SMALLINT(display_width=6), autoincrement=False, nullable=True))
op.add_column('invtypes', sa.Column('capacity', mysql.DOUBLE(asdecimal=True), nullable=True))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'operations', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('currency', sa.String(length=3), nullable=False),
sa.Column('amount',
mysql.DOUBLE(precision=15, scale=8, asdecimal=True),
nullable=False),
sa.Column('price',
mysql.DOUBLE(precision=15, scale=8, asdecimal=True),
nullable=True),
sa.Column('final_amount',
mysql.DOUBLE(precision=15, scale=8, asdecimal=True),
nullable=True),
sa.Column('requested_time', sa.DateTime(), nullable=False),
sa.PrimaryKeyConstraint('id'))
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('apscheduler_jobs',
sa.Column('id', mysql.VARCHAR(length=191), nullable=False),
sa.Column('next_run_time',
mysql.DOUBLE(asdecimal=True),
nullable=True),
sa.Column('job_state', sa.BLOB(), nullable=False),
sa.PrimaryKeyConstraint('id'),
mysql_collate='utf8mb4_0900_ai_ci',
mysql_default_charset='utf8mb4',
mysql_engine='InnoDB')
op.create_index('ix_apscheduler_jobs_next_run_time',
'apscheduler_jobs', ['next_run_time'],
unique=False)
op.create_table('sessions',
sa.Column('id',
mysql.INTEGER(),
autoincrement=True,
nullable=False),
sa.Column('session_id',
mysql.VARCHAR(length=255),
nullable=True),
sa.Column('data', sa.BLOB(), nullable=True),
sa.Column('expiry', mysql.DATETIME(), nullable=True),
sa.PrimaryKeyConstraint('id'),
mysql_collate='utf8mb4_0900_ai_ci',
mysql_default_charset='utf8mb4',
mysql_engine='InnoDB')
op.create_index('session_id', 'sessions', ['session_id'], unique=True)
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('menu_item',
sa.Column('menu_item_number',
mysql.INTEGER(display_width=10),
autoincrement=False,
nullable=False),
sa.Column('item_name',
mysql.VARCHAR(collation='utf8mb4_unicode_ci',
length=128),
nullable=False),
sa.Column('price',
mysql.DOUBLE(precision=3,
scale=2,
asdecimal=True),
nullable=False),
sa.Column('drinkstatus',
mysql.TINYINT(display_width=1),
autoincrement=False,
nullable=True),
sa.Column('drink_type',
mysql.VARCHAR(collation='utf8mb4_unicode_ci',
length=255),
nullable=True),
sa.Column('drink_description',
mysql.VARCHAR(collation='utf8mb4_unicode_ci',
length=255),
nullable=True),
sa.PrimaryKeyConstraint('menu_item_number'),
mysql_collate='utf8mb4_unicode_ci',
mysql_default_charset='utf8mb4',
mysql_engine='InnoDB')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.alter_column('order_item', 'employee_id',
existing_type=mysql.INTEGER(display_width=10),
nullable=True)
op.alter_column('order_item', 'add_on_number',
existing_type=mysql.INTEGER(display_width=10),
nullable=True)
op.add_column('drink_order', sa.Column('add_on_number', mysql.INTEGER(display_width=10), autoincrement=False, nullable=True))
op.add_column('drink_order', sa.Column('menu_item_number', mysql.INTEGER(display_width=10), autoincrement=False, nullable=False))
op.add_column('drink_order', sa.Column('total_price', mysql.DOUBLE(precision=4, scale=2, asdecimal=True), nullable=True))
op.add_column('drink_order', sa.Column('employee_id', mysql.INTEGER(display_width=10), autoincrement=False, nullable=True))
op.create_foreign_key('drink_order_ibfk_4', 'drink_order', 'add_on_item', ['add_on_number'], ['add_on_number'])
op.create_foreign_key('drink_order_ibfk_1', 'drink_order', 'menu_item', ['menu_item_number'], ['menu_item_number'])
op.create_foreign_key('drink_order_ibfk_3', 'drink_order', 'employee', ['employee_id'], ['employee_id'])
op.alter_column('drink_order', 'order_date',
existing_type=mysql.DATETIME(),
nullable=False)
op.create_table('customer',
sa.Column('email', mysql.VARCHAR(collation='utf8mb4_unicode_ci', length=64), nullable=False),
sa.Column('customer_name', mysql.VARCHAR(collation='utf8mb4_unicode_ci', length=255), nullable=False),
sa.Column('phone', mysql.VARCHAR(collation='utf8mb4_unicode_ci', length=255), nullable=True),
sa.Column('address', mysql.VARCHAR(collation='utf8mb4_unicode_ci', length=255), nullable=True),
sa.PrimaryKeyConstraint('email'),
mysql_collate='utf8mb4_unicode_ci',
mysql_default_charset='utf8mb4',
mysql_engine='InnoDB'
)
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('user',
sa.Column('id',
mysql.INTEGER(display_width=11),
autoincrement=True,
nullable=False),
sa.Column('username',
mysql.VARCHAR(length=80),
nullable=True),
sa.Column('email',
mysql.VARCHAR(length=120),
nullable=True),
sa.PrimaryKeyConstraint('id'),
mysql_default_charset='latin1',
mysql_engine='InnoDB')
op.create_table('location',
sa.Column('pri_id',
mysql.INTEGER(display_width=11),
autoincrement=True,
nullable=False),
sa.Column('id',
mysql.INTEGER(display_width=11),
autoincrement=False,
nullable=True),
sa.Column('description',
mysql.VARCHAR(length=80),
nullable=True),
sa.Column('data_time', mysql.DATETIME(), nullable=True),
sa.Column('longtitude',
mysql.DOUBLE(precision=9,
scale=7,
asdecimal=True),
nullable=True),
sa.Column('latitude',
mysql.DOUBLE(precision=9,
scale=7,
asdecimal=True),
nullable=True),
sa.Column('elevation',
mysql.INTEGER(display_width=11),
autoincrement=False,
nullable=True),
sa.PrimaryKeyConstraint('pri_id'),
mysql_default_charset='latin1',
mysql_engine='InnoDB')
op.drop_table('assetlocation')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_column('users', 'is_student')
op.drop_column('users', 'is_staff')
op.alter_column('settings',
'notification_period',
existing_type=mysql.DOUBLE(asdecimal=True),
nullable=True)
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.alter_column('add_on_item',
'price',
existing_type=mysql.DOUBLE(precision=3,
scale=2,
asdecimal=True),
nullable=False)
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('delivery_order',
sa.Column('id', mysql.BIGINT(display_width=20), autoincrement=True, nullable=False),
sa.Column('user_id', mysql.VARCHAR(length=255), nullable=False),
sa.Column('order_id', mysql.VARCHAR(length=255), nullable=False),
sa.Column('pickup_address', mysql.VARCHAR(length=255), nullable=False),
sa.Column('pickup_contact', mysql.VARCHAR(length=255), nullable=False),
sa.Column('pickup_contact_number', mysql.VARCHAR(length=255), nullable=False),
sa.Column('dropoff_address', mysql.VARCHAR(length=255), nullable=False),
sa.Column('dropoff_contact', mysql.VARCHAR(length=255), nullable=False),
sa.Column('dropoff_contact_number', mysql.VARCHAR(length=255), nullable=False),
sa.Column('item_value_cost', mysql.BIGINT(display_width=20), autoincrement=False, nullable=False),
sa.Column('notes', mysql.TEXT(), nullable=False),
sa.Column('delivery_fee', mysql.DOUBLE(asdecimal=True), nullable=False),
sa.Column('invoice_id', mysql.VARCHAR(length=255), nullable=False),
sa.Column('mpesa_payment_id', mysql.VARCHAR(length=255), nullable=True),
sa.Column('date_created', mysql.BIGINT(display_width=20), autoincrement=False, nullable=False),
sa.Column('order_status', mysql.VARCHAR(length=255), server_default=sa.text("'New'"), nullable=True),
sa.Column('rider_id', mysql.VARCHAR(length=255), nullable=True),
sa.Column('rider_pickup_date', mysql.BIGINT(display_width=20), autoincrement=False, nullable=True),
sa.Column('rider_delivery_date', mysql.BIGINT(display_width=20), autoincrement=False, nullable=True),
sa.Column('rider_notes', mysql.TEXT(), nullable=True),
sa.Column('user_feedback', mysql.TEXT(), nullable=True),
sa.PrimaryKeyConstraint('id'),
mysql_default_charset='utf8',
mysql_engine='InnoDB'
)
op.create_table('user',
sa.Column('id', mysql.BIGINT(display_width=20), autoincrement=True, nullable=False),
sa.Column('user_id', mysql.VARCHAR(length=255), nullable=False),
sa.Column('firstname', mysql.VARCHAR(length=255), nullable=False),
sa.Column('lastname', mysql.VARCHAR(length=255), nullable=False),
sa.Column('email', mysql.VARCHAR(length=255), nullable=False),
sa.Column('phone_number', mysql.VARCHAR(length=255), nullable=False),
sa.Column('push_notificaiton_id', mysql.TEXT(), nullable=True),
sa.Column('date_created', mysql.VARCHAR(length=255), nullable=False),
sa.Column('phone_number_verified', mysql.INTEGER(display_width=11), server_default=sa.text('0'), autoincrement=False, nullable=False),
sa.PrimaryKeyConstraint('id'),
mysql_default_charset='utf8',
mysql_engine='InnoDB'
)
op.create_table('login',
sa.Column('id', mysql.BIGINT(display_width=20), autoincrement=True, nullable=False),
sa.Column('user_id', mysql.VARCHAR(length=255), nullable=False),
sa.Column('email_address', mysql.VARCHAR(length=255), nullable=False),
sa.Column('password', mysql.VARCHAR(length=255), nullable=False),
sa.Column('role', mysql.INTEGER(display_width=11), autoincrement=False, nullable=False),
sa.Column('status', mysql.INTEGER(display_width=11), autoincrement=False, nullable=False),
sa.Column('date_created', mysql.BIGINT(display_width=20), autoincrement=False, nullable=False),
sa.Column('last_login', mysql.BIGINT(display_width=20), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id'),
mysql_default_charset='utf8',
mysql_engine='InnoDB'
)
op.drop_table('users')
op.drop_table('blacklist_tokens')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.alter_column('games',
'duration',
existing_type=mysql.DOUBLE(asdecimal=True),
nullable=False)
op.drop_constraint(None, 'game_balances', type_='foreignkey')
op.drop_column('game_balances', 'dividend_id')
op.drop_table('dividends')
class Notification(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(128), index=True)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'))
timestamp = db.Column(mysql.DOUBLE(), index=True, default=time)
payload_json = db.Column(db.Text)
def get_data(self):
return json.loads(str(self.payload_json))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.alter_column('settings',
'notification_period',
existing_type=mysql.DOUBLE(asdecimal=True),
nullable=False)
op.add_column('users', sa.Column('is_staff', sa.Boolean(), nullable=True))
op.add_column('users', sa.Column('is_student', sa.Boolean(),
nullable=True))
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('gaodemapscene_test',
sa.Column('id', mysql.CHAR(length=20), nullable=False),
sa.Column('province', mysql.CHAR(length=50),
nullable=True),
sa.Column('city', mysql.CHAR(length=50), nullable=True),
sa.Column('name', mysql.CHAR(length=50), nullable=True),
sa.Column('city_adcode',
mysql.CHAR(length=20),
nullable=False),
sa.Column('district', mysql.CHAR(length=50),
nullable=True),
sa.Column('address', mysql.CHAR(length=100),
nullable=True),
sa.Column('longtitude',
mysql.DOUBLE(asdecimal=True),
nullable=True),
sa.Column('lat',
mysql.DOUBLE(asdecimal=True),
nullable=True),
sa.Column('type', mysql.CHAR(length=100), nullable=True),
sa.Column('typecode', mysql.CHAR(length=20),
nullable=True),
sa.Column('classify',
mysql.CHAR(length=100),
nullable=True),
sa.Column('area',
mysql.DOUBLE(asdecimal=True),
nullable=True),
sa.Column('shape', mysql.TEXT(), nullable=True),
sa.Column('wgs_long',
mysql.DOUBLE(asdecimal=True),
nullable=True),
sa.Column('wgs_lat',
mysql.DOUBLE(asdecimal=True),
nullable=True),
sa.Column('wgs_shape', mysql.TEXT(), nullable=True),
sa.PrimaryKeyConstraint('id', 'city_adcode'),
mysql_default_charset='utf8',
mysql_engine='InnoDB')
op.drop_table('database')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('apscheduler_jobs',
sa.Column('id', mysql.VARCHAR(length=191), nullable=False),
sa.Column('next_run_time', mysql.DOUBLE(asdecimal=True), nullable=True),
sa.Column('job_state', sa.BLOB(), nullable=False),
sa.PrimaryKeyConstraint('id'),
mysql_default_charset='utf8mb4',
mysql_engine='InnoDB'
)
op.create_index('ix_apscheduler_jobs_next_run_time', 'apscheduler_jobs', ['next_run_time'], unique=False)
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('image_meta',
sa.Column('id',
mysql.INTEGER(display_width=11),
autoincrement=True,
nullable=False),
sa.Column('path',
mysql.VARCHAR(length=1024),
nullable=False),
sa.Column('format',
mysql.VARCHAR(length=20),
nullable=True),
sa.Column('size',
mysql.INTEGER(display_width=11),
autoincrement=False,
nullable=True),
sa.Column('width',
mysql.INTEGER(display_width=11),
autoincrement=False,
nullable=True),
sa.Column('height',
mysql.INTEGER(display_width=11),
autoincrement=False,
nullable=True),
sa.Column('channel',
mysql.INTEGER(display_width=11),
autoincrement=False,
nullable=True),
sa.PrimaryKeyConstraint('id'),
mysql_collate=u'utf8mb4_0900_ai_ci',
mysql_default_charset=u'utf8mb4',
mysql_engine=u'InnoDB')
op.create_table('test_table_1',
sa.Column('id',
mysql.INTEGER(display_width=11),
autoincrement=True,
nullable=False),
sa.Column('name',
mysql.VARCHAR(length=256),
nullable=False),
sa.Column('count',
mysql.INTEGER(display_width=11),
autoincrement=False,
nullable=True),
sa.Column('score',
mysql.DOUBLE(asdecimal=True),
nullable=True),
sa.PrimaryKeyConstraint('id'),
mysql_collate=u'utf8mb4_0900_ai_ci',
mysql_default_charset=u'utf8mb4',
mysql_engine=u'InnoDB')
op.drop_table('ImageMeta')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.alter_column('room_message',
'modified_date',
existing_type=sa.DateTime(timezone=True),
type_=mysql.DOUBLE(asdecimal=True),
existing_nullable=True)
op.alter_column('room_message',
'created_date',
existing_type=sa.DateTime(timezone=True),
type_=mysql.DOUBLE(asdecimal=True),
existing_nullable=True)
op.alter_column('personal_message',
'modified_date',
existing_type=sa.DateTime(timezone=True),
type_=mysql.DOUBLE(asdecimal=True),
existing_nullable=True)
op.alter_column('personal_message',
'created_date',
existing_type=sa.DateTime(timezone=True),
type_=mysql.DOUBLE(asdecimal=True),
existing_nullable=True)
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('gps_ic_merge_bas_ic',
sa.Column('CARDID', mysql.TEXT(), nullable=True),
sa.Column('CARDTYPE_NAME', mysql.TEXT(), nullable=True),
sa.Column('TXNDATE', mysql.DATETIME(), nullable=True),
sa.Column('TXNAMT', mysql.DOUBLE(asdecimal=True), nullable=True),
sa.Column('BUSID', mysql.BIGINT(display_width=20), autoincrement=False, nullable=True),
sa.Column('bus_id', mysql.BIGINT(display_width=20), autoincrement=False, nullable=True),
sa.Column('line_id', mysql.TEXT(), nullable=True),
sa.Column('seconds', mysql.BIGINT(display_width=20), autoincrement=False, nullable=True),
sa.Column('second_diff', mysql.DOUBLE(asdecimal=True), nullable=True),
sa.Column('IS_STATION', mysql.DOUBLE(asdecimal=True), nullable=True),
sa.Column('STATION_NAME', mysql.TEXT(), nullable=True),
sa.Column('banci_csig', mysql.INTEGER(display_width=11), autoincrement=False, nullable=True),
mysql_default_charset='utf8',
mysql_engine='InnoDB'
)
op.create_table('station_roadlu',
sa.Column('FID', mysql.VARCHAR(length=255), nullable=True),
sa.Column('linename', mysql.VARCHAR(length=255), nullable=True),
sa.Column('sxxid', mysql.VARCHAR(length=255), nullable=True),
sa.Column('stopid', mysql.VARCHAR(length=255), nullable=True),
sa.Column('stopname', mysql.VARCHAR(length=255), nullable=True),
sa.Column('lng', mysql.VARCHAR(length=255), nullable=True),
sa.Column('lat', mysql.VARCHAR(length=255), nullable=True),
sa.Column('FID_', mysql.VARCHAR(length=255), nullable=True),
sa.Column('RoadName', mysql.VARCHAR(length=255), nullable=True),
sa.Column('GHDLDJ', mysql.VARCHAR(length=255), nullable=True),
sa.Column('GH_width', mysql.VARCHAR(length=255), nullable=True),
sa.Column('XZ_width', mysql.VARCHAR(length=255), nullable=True),
sa.Column('JDCDS', mysql.VARCHAR(length=255), nullable=True),
sa.Column('Finished', mysql.VARCHAR(length=255), nullable=True),
sa.Column('Shape_Leng', mysql.VARCHAR(length=255), nullable=True),
mysql_default_charset='gbk',
mysql_engine='InnoDB',
mysql_row_format='COMPACT'
)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('dividends', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('symbol', sa.Text(), nullable=True),
sa.Column('company', sa.Text(), nullable=True),
sa.Column('amount', sa.Float(precision=32), nullable=True),
sa.Column('exec_date', sa.Integer(), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.add_column('game_balances',
sa.Column('dividend_id', sa.Integer(), nullable=True))
op.create_foreign_key(None, 'game_balances', 'dividends', ['dividend_id'],
['id'])
op.alter_column('games',
'duration',
existing_type=mysql.DOUBLE(asdecimal=True),
nullable=True)
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.alter_column('dmp_chart', 'chart_name',
existing_type=mysql.VARCHAR(length=64),
comment='图标名称',
existing_comment='图表名称',
existing_nullable=False)
op.drop_column('dmp_chart', 'charts_position')
op.create_table('apscheduler_jobs',
sa.Column('id', mysql.VARCHAR(length=191), nullable=False),
sa.Column('next_run_time', mysql.DOUBLE(asdecimal=True), nullable=True),
sa.Column('job_state', sa.BLOB(), nullable=False),
sa.PrimaryKeyConstraint('id'),
mysql_default_charset='utf8mb4',
mysql_engine='InnoDB'
)
op.create_index('ix_apscheduler_jobs_next_run_time', 'apscheduler_jobs', ['next_run_time'], unique=False)
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.alter_column('dmp_chart',
'update_unit',
existing_type=mysql.INTEGER(display_width=11),
nullable=False,
existing_comment='时间间隔单位，0小时，1日，3周')
op.alter_column('dmp_chart',
'update_interval',
existing_type=mysql.INTEGER(display_width=11),
nullable=False,
existing_comment='时间间隔时间')
op.alter_column('dmp_chart',
'query_string',
existing_type=mysql.TEXT(),
nullable=False,
existing_comment='查询语句')
op.alter_column('dmp_chart',
'params',
existing_type=mysql.TEXT(),
nullable=False,
existing_comment='图表参数')
op.alter_column('dmp_chart',
'dmp_data_table_id',
existing_type=mysql.INTEGER(display_width=11),
nullable=False,
existing_comment='数据表ID')
op.alter_column('dmp_chart',
'chart_data',
existing_type=mysql.TEXT(),
nullable=False,
existing_comment='数据')
op.create_table('apscheduler_jobs',
sa.Column('id', mysql.VARCHAR(length=191), nullable=False),
sa.Column('next_run_time',
mysql.DOUBLE(asdecimal=True),
nullable=True),
sa.Column('job_state', sa.BLOB(), nullable=False),
sa.PrimaryKeyConstraint('id'),
mysql_default_charset='utf8mb4',
mysql_engine='InnoDB')
op.create_index('ix_apscheduler_jobs_next_run_time',
'apscheduler_jobs', ['next_run_time'],
unique=False)
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.alter_column('dmp_data_service',
'source_dmp_data_table_id',
existing_type=mysql.INTEGER(display_width=11),
nullable=False,
existing_comment='数据表ID')
op.drop_column('dmp_chart', 'update_task_id')
op.create_table('apscheduler_jobs',
sa.Column('id', mysql.VARCHAR(length=191), nullable=False),
sa.Column('next_run_time',
mysql.DOUBLE(asdecimal=True),
nullable=True),
sa.Column('job_state', sa.BLOB(), nullable=False),
sa.PrimaryKeyConstraint('id'),
mysql_default_charset='utf8mb4',
mysql_engine='InnoDB')
op.create_index('ix_apscheduler_jobs_next_run_time',
'apscheduler_jobs', ['next_run_time'],
unique=False)
def downgrade():
op.add_column(
'etablissements_backoffice',
sa.Column('semester-1', mysql.DOUBLE(asdecimal=True), nullable=True))
op.add_column(
'etablissements_backoffice',
sa.Column('semester-2', mysql.DOUBLE(asdecimal=True), nullable=True))
op.add_column(
'etablissements_backoffice',
sa.Column('semester-3', mysql.DOUBLE(asdecimal=True), nullable=True))
op.add_column(
'etablissements_backoffice',
sa.Column('semester-4', mysql.DOUBLE(asdecimal=True), nullable=True))
op.add_column(
'etablissements_backoffice',
sa.Column('semester-5', mysql.DOUBLE(asdecimal=True), nullable=True))
op.add_column(
'etablissements_backoffice',
sa.Column('semester-6', mysql.DOUBLE(asdecimal=True), nullable=True))
op.add_column(
'etablissements_backoffice',
sa.Column('semester-7', mysql.DOUBLE(asdecimal=True), nullable=True))
op.drop_column('etablissements_backoffice', 'dpae-period-7')
op.drop_column('etablissements_backoffice', 'dpae-period-6')
op.drop_column('etablissements_backoffice', 'dpae-period-5')
op.drop_column('etablissements_backoffice', 'dpae-period-4')
op.drop_column('etablissements_backoffice', 'dpae-period-3')
op.drop_column('etablissements_backoffice', 'dpae-period-2')
op.drop_column('etablissements_backoffice', 'dpae-period-1')
op.drop_column('etablissements_backoffice', 'score_alternance')
op.drop_column('etablissements_backoffice', 'score_alternance_regr')
op.drop_column('etablissements_backoffice', 'alt-period-7')
op.drop_column('etablissements_backoffice', 'alt-period-6')
op.drop_column('etablissements_backoffice', 'alt-period-5')
op.drop_column('etablissements_backoffice', 'alt-period-4')
op.drop_column('etablissements_backoffice', 'alt-period-3')
op.drop_column('etablissements_backoffice', 'alt-period-2')
op.drop_column('etablissements_backoffice', 'alt-period-1')
ALL_TABLES = [
TABLE_STATES,
TABLE_EVENTS,
TABLE_RECORDER_RUNS,
TABLE_SCHEMA_CHANGES,
TABLE_STATISTICS,
TABLE_STATISTICS_META,
TABLE_STATISTICS_RUNS,
TABLE_STATISTICS_SHORT_TERM,
]
DATETIME_TYPE = DateTime(timezone=True).with_variant(
mysql.DATETIME(timezone=True, fsp=6), "mysql")
DOUBLE_TYPE = (Float().with_variant(
mysql.DOUBLE(asdecimal=False),
"mysql").with_variant(oracle.DOUBLE_PRECISION(),
"oracle").with_variant(postgresql.DOUBLE_PRECISION(),
"postgresql"))
class Events(Base): # type: ignore
"""Event history data."""
__table_args__ = (
# Used for fetching events at a specific time
# see logbook
Index("ix_events_event_type_time_fired", "event_type", "time_fired"),
{
"mysql_default_charset": "utf8mb4",
"mysql_collate": "utf8mb4_unicode_ci"
TABLE_STATES,
TABLE_EVENTS,
TABLE_RECORDER_RUNS,
TABLE_SCHEMA_CHANGES,
TABLE_STATISTICS,
TABLE_STATISTICS_META,
TABLE_STATISTICS_RUNS,
TABLE_STATISTICS_SHORT_TERM,
]
DATETIME_TYPE = DateTime(timezone=True).with_variant(
mysql.DATETIME(timezone=True, fsp=6), "mysql"
)
DOUBLE_TYPE = (
Float()
.with_variant(mysql.DOUBLE(asdecimal=False), "mysql")
.with_variant(oracle.DOUBLE_PRECISION(), "oracle")
.with_variant(postgresql.DOUBLE_PRECISION(), "postgresql")
)
class Events(Base): # type: ignore
"""Event history data."""
__table_args__ = (
# Used for fetching events at a specific time
# see logbook
Index("ix_events_event_type_time_fired", "event_type", "time_fired"),
{"mysql_default_charset": "utf8mb4", "mysql_collate": "utf8mb4_unicode_ci"},
)
__tablename__ = TABLE_EVENTS
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.drop_table('user')
op.drop_table('rel_user')
op.drop_table('rel_user_text')
op.drop_table('rel_user_multi')
### end Alembic commands ###
### commands auto generated by Alembic - please adjust! ###
op.create_table('rel_user_multi',
sa.Column('rum_id', mysql.INTEGER(display_width=10, unsigned=True), nullable=False),
sa.Column('user_id', mysql.INTEGER(display_width=10, unsigned=True), autoincrement=False, nullable=True),
sa.Column('rel_lookup', mysql.VARCHAR(length=255), nullable=True),
sa.Column('attribute', mysql.VARCHAR(length=255), nullable=True),
sa.Column('create_transaction_id', mysql.INTEGER(display_width=10, unsigned=True), autoincrement=False, nullable=True),
sa.Column('create_time', mysql.TIMESTAMP(), server_default=sa.text(u'CURRENT_TIMESTAMP'), nullable=False),
sa.PrimaryKeyConstraint('rum_id'),
mysql_default_charset=u'utf8',
mysql_engine=u'InnoDB'
)
op.create_table('rel_user_text',
sa.Column('rut_id', mysql.INTEGER(display_width=11), nullable=False),
sa.Column('user_id', mysql.INTEGER(display_width=11), autoincrement=False, nullable=True),
sa.Column('rel_lookup', mysql.VARCHAR(length=255), nullable=True),
sa.Column('attribute', mysql.TEXT(), nullable=True),
sa.Column('create_transaction_id', mysql.INTEGER(display_width=11), autoincrement=False, nullable=True),
sa.Column('create_time', mysql.TIMESTAMP(), server_default=sa.text(u'CURRENT_TIMESTAMP'), nullable=False),
sa.PrimaryKeyConstraint('rut_id'),
mysql_default_charset=u'utf8',
mysql_engine=u'InnoDB'
)
op.create_table('rel_user',
sa.Column('user_id', mysql.INTEGER(display_width=10, unsigned=True), server_default=sa.text(u"'0'"), autoincrement=False, nullable=False),
sa.Column('rel_lookup', mysql.VARCHAR(length=128), server_default=sa.text(u"''"), nullable=False),
sa.Column('attribute', mysql.VARCHAR(length=255), nullable=True),
sa.Column('create_transaction_id', mysql.INTEGER(display_width=10, unsigned=True), autoincrement=False, nullable=True),
sa.Column('create_time', mysql.TIMESTAMP(), server_default=sa.text(u'CURRENT_TIMESTAMP'), nullable=False),
sa.PrimaryKeyConstraint('user_id', 'rel_lookup'),
mysql_default_charset=u'utf8',
mysql_engine=u'InnoDB'
)
op.create_table('user',
sa.Column('user_id', mysql.INTEGER(display_width=10, unsigned=True), nullable=False),
sa.Column('username', mysql.VARCHAR(length=128), nullable=True),
sa.Column('email_address', mysql.VARCHAR(length=255), nullable=True),
sa.Column('display_name', mysql.VARCHAR(length=50), nullable=True),
sa.Column('signup_date', sa.DATE(), nullable=True),
sa.Column('enroll_status', mysql.VARCHAR(length=50), server_default=sa.text(u"'PreValid'"), nullable=False),
sa.Column('enroll_complete', mysql.TINYINT(display_width=1), server_default=sa.text(u"'0'"), autoincrement=False, nullable=True),
sa.Column('tier', mysql.VARCHAR(length=50), server_default=sa.text(u"'Carbon'"), nullable=False),
sa.Column('last_interaction_dttm', mysql.TIMESTAMP(), nullable=True),
sa.Column('group_id', mysql.INTEGER(display_width=10, unsigned=True), autoincrement=False, nullable=True),
sa.Column('current_ohm_service_id', mysql.INTEGER(display_width=10, unsigned=True), autoincrement=False, nullable=True),
sa.Column('point_balance', mysql.DOUBLE(asdecimal=True), server_default=sa.text(u"'0'"), nullable=False),
sa.Column('credit_balance', mysql.DOUBLE(asdecimal=True), server_default=sa.text(u"'0'"), nullable=False),
sa.Column('donated_points', mysql.DOUBLE(asdecimal=True), server_default=sa.text(u"'0'"), nullable=False),
sa.Column('lifetime_points', mysql.DOUBLE(asdecimal=True), server_default=sa.text(u"'0'"), nullable=False),
sa.Column('create_transaction_id', mysql.INTEGER(display_width=10, unsigned=True), autoincrement=False, nullable=True),
sa.Column('create_time', mysql.TIMESTAMP(), server_default=sa.text(u'CURRENT_TIMESTAMP'), nullable=True),
sa.PrimaryKeyConstraint('user_id'),
mysql_default_charset=u'utf8',
mysql_engine=u'InnoDB'
)
