def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'user',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('public_id', sa.String(), nullable=True),
sa.Column('username', sa.String(length=100), nullable=True),
sa.Column('password', sa.String(length=100), nullable=False),
sa.Column('email', sa.String(length=120), nullable=False),
sa.Column('photo', sa.String(), nullable=True),
sa.Column('admin', sa.Boolean(), nullable=True),
sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('email'),
sa.UniqueConstraint('username'))
op.create_table(
'vault',
sa.Column('vault_id', sa.Integer(), autoincrement=True,
nullable=False),
sa.Column('owner_id', sa.Integer(), nullable=True),
sa.Column('title', sa.String(length=100), nullable=True),
sa.Column('description', sa.String(), nullable=True),
sa.ForeignKeyConstraint(
['owner_id'],
['user.id'],
), sa.PrimaryKeyConstraint('vault_id'), sa.UniqueConstraint('title'))
op.create_table(
'file',
sa.Column('file_id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('vault_id', sa.Integer(), nullable=True),
sa.Column('owner_id', sa.Integer(), nullable=True),
sa.Column('name', sa.String(length=100), nullable=True),
sa.Column('description', sa.String(), nullable=True),
sa.Column('data', sa.LargeBinary(), nullable=True),
sa.ForeignKeyConstraint(
['owner_id'],
['user.id'],
), sa.ForeignKeyConstraint(
['vault_id'],
['vault.vault_id'],
), sa.PrimaryKeyConstraint('file_id'))
def _cast(t, expr):
arg, typ = expr.op().args
sa_arg = t.translate(arg)
sa_type = t.get_sqla_type(typ)
if isinstance(arg, ir.CategoryValue) and typ == dt.int32:
return sa_arg
# specialize going from an integer type to a timestamp
if isinstance(arg.type(), dt.Integer) and isinstance(sa_type, sa.DateTime):
return t.integer_to_timestamp(sa_arg)
if arg.type().equals(dt.binary) and typ.equals(dt.string):
return sa.func.encode(sa_arg, 'escape')
if typ.equals(dt.binary):
# decode yields a column of memoryview which is annoying to deal with
# in pandas. CAST(expr AS BYTEA) is correct and returns byte strings.
return sa.cast(sa_arg, sa.LargeBinary())
return sa.cast(sa_arg, sa_type)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('empleado',
sa.Column('dni', sa.Integer(), nullable=False),
sa.Column('legajo', sa.Integer(), nullable=False),
sa.Column('telefono', sa.Integer(), nullable=True),
sa.Column('nombre', sa.String(length=250), nullable=True),
sa.Column('apellido', sa.String(
length=250), nullable=True),
sa.Column('domicilio', sa.String(
length=250), nullable=True),
sa.Column('fecha_ingreso', sa.DateTime(), nullable=True),
sa.Column('fecha_salida', sa.DateTime(), nullable=True),
sa.Column('fecha_nacimiento',
sa.DateTime(), nullable=True),
sa.Column('fecha_cese', sa.DateTime(), nullable=True),
sa.Column('estado_general', sa.String(
length=250), nullable=True),
sa.Column('sexo', sa.String(length=250), nullable=True),
sa.Column('foto', sa.LargeBinary(), nullable=True),
sa.PrimaryKeyConstraint('legajo')
)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('sessions',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('session_id', sa.String(length=255), nullable=True),
sa.Column('data', sa.LargeBinary(), nullable=True),
sa.Column('expiry', sa.DateTime(), nullable=True),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('session_id')
)
op.create_table('users',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('username', sa.String(length=80), nullable=True),
sa.Column('email', sa.String(length=120), nullable=True),
sa.Column('pw_hash', sa.String(length=256), nullable=True),
sa.Column('rand_number', sa.Integer(), nullable=True),
sa.Column('language', sa.String(length=80), nullable=True),
sa.PrimaryKeyConstraint('id')
)
op.create_index(op.f('ix_users_email'), 'users', ['email'], unique=True)
op.create_index(op.f('ix_users_pw_hash'), 'users', ['pw_hash'], unique=True)
op.create_index(op.f('ix_users_username'), 'users', ['username'], unique=True)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'uploaded_file', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('filename', sa.String(length=64), nullable=True),
sa.Column('data', sa.LargeBinary(), nullable=True),
sa.Column('uploaded_timestamp', sa.TIMESTAMP(), nullable=True),
sa.Column('file_last_modified_dt', sa.TIMESTAMP(), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_uploaded_file_uploaded_timestamp'),
'uploaded_file', ['uploaded_timestamp'],
unique=False)
op.create_table(
'user', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('username', sa.String(length=64), nullable=True),
sa.Column('email', sa.String(length=120), nullable=True),
sa.Column('password_hash', sa.String(length=128), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_user_email'), 'user', ['email'], unique=True)
op.create_index(op.f('ix_user_username'),
'user', ['username'],
unique=True)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'users', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('username', sa.String(length=80), nullable=False),
sa.Column('email', sa.String(length=80), nullable=False),
sa.Column('password', sa.LargeBinary(length=128), nullable=True),
sa.Column('created_at', sa.DateTime(), nullable=False),
sa.Column('first_name', sa.String(length=30), nullable=True),
sa.Column('last_name', sa.String(length=30), nullable=True),
sa.Column('active', sa.Boolean(), nullable=True),
sa.Column('is_admin', sa.Boolean(), nullable=True),
sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('email'),
sa.UniqueConstraint('username'))
op.create_table('roles', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=80), nullable=False),
sa.Column('user_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['user_id'],
['users.id'],
), sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('name'))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('categories',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=30), nullable=False),
sa.Column('slug', sa.String(length=35), nullable=False),
sa.PrimaryKeyConstraint('id')
)
op.create_index(op.f('ix_categories_slug'), 'categories', ['slug'], unique=True)
op.create_table('products',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=120), nullable=False),
sa.Column('slug', sa.String(length=130), nullable=False),
sa.Column('price', sa.Float(), nullable=False),
sa.Column('image', sa.LargeBinary(), nullable=False),
sa.Column('quantity', sa.Integer(), nullable=False),
sa.Column('description', sa.Text(), nullable=False),
sa.Column('category_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['category_id'], ['categories.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_index(op.f('ix_products_slug'), 'products', ['slug'], unique=True)
def upgrade():
"""Setup database to initial cookiecutter-flask model."""
op.create_table(
'users', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('username', sa.String(length=80), nullable=False),
sa.Column('email', sa.String(length=80), nullable=False),
sa.Column('password', sa.LargeBinary(), nullable=True),
sa.Column('created_at', sa.DateTime(), nullable=False),
sa.Column('first_name', sa.String(length=30), nullable=True),
sa.Column('last_name', sa.String(length=30), nullable=True),
sa.Column('active', sa.Boolean(), nullable=True),
sa.Column('is_admin', sa.Boolean(), nullable=True),
sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('email'),
sa.UniqueConstraint('username'))
op.create_table('roles', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=80), nullable=False),
sa.Column('user_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['user_id'],
['users.id'],
), sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('name'))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('producer',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(), nullable=False),
sa.Column('sex', sa.String(), nullable=False),
sa.Column('dob', sa.DateTime(), nullable=False),
sa.Column('bio', sa.String(), nullable=False),
sa.PrimaryKeyConstraint('id')
)
op.create_index(op.f('ix_producer_bio'), 'producer', ['bio'], unique=False)
op.create_index(op.f('ix_producer_dob'), 'producer', ['dob'], unique=False)
op.create_index(op.f('ix_producer_id'), 'producer', ['id'], unique=False)
op.create_index(op.f('ix_producer_name'), 'producer', ['name'], unique=False)
op.create_index(op.f('ix_producer_sex'), 'producer', ['sex'], unique=False)
op.create_table('movie',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(), nullable=False),
sa.Column('year_of_release', sa.String(), nullable=False),
sa.Column('plot', sa.String(), nullable=False),
sa.Column('poster', sa.LargeBinary(), nullable=False),
sa.Column('producer_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['producer_id'], ['producer.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_index(op.f('ix_movie_id'), 'movie', ['id'], unique=False)
op.create_index(op.f('ix_movie_name'), 'movie', ['name'], unique=False)
op.create_index(op.f('ix_movie_plot'), 'movie', ['plot'], unique=False)
op.create_index(op.f('ix_movie_poster'), 'movie', ['poster'], unique=False)
op.create_index(op.f('ix_movie_year_of_release'), 'movie', ['year_of_release'], unique=False)
op.create_table('cast',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('movie_id', sa.Integer(), nullable=True),
sa.Column('actor_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['actor_id'], ['actor.id'], ),
sa.ForeignKeyConstraint(['movie_id'], ['movie.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_index(op.f('ix_cast_id'), 'cast', ['id'], unique=False)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('user',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('name', sa.String(length=100), nullable=False),
sa.Column('username', sa.String(length=15), nullable=False),
sa.Column('password', sa.String(length=150), nullable=False),
sa.Column('email', sa.String(length=100), nullable=False),
sa.Column('gender', sqlalchemy_utils.types.choice.ChoiceType(user.User.genders), nullable=True),
sa.Column('born_on', sa.Date(), nullable=True),
sa.Column('created_at', sa.DateTime(), nullable=True),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('email'),
sa.UniqueConstraint('username')
)
op.create_table('user_img',
sa.Column('user_id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=100), nullable=True),
sa.Column('data', sa.LargeBinary(), nullable=True),
sa.ForeignKeyConstraint(['user_id'], ['user.id'], ),
sa.PrimaryKeyConstraint('user_id')
)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'gender', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('genderTypes', sa.String(length=80), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'user_profile', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('firstname', sa.String(length=80), nullable=True),
sa.Column('lastname', sa.String(length=80), nullable=True),
sa.Column('location', sa.String(length=255), nullable=True),
sa.Column('photo', sa.String(length=255), nullable=True),
sa.Column('email', sa.String(length=255), nullable=True),
sa.Column('bio', sa.String(length=255), nullable=True),
sa.Column('photo_data', sa.LargeBinary(), nullable=True),
sa.Column('username', sa.String(length=255), nullable=True),
sa.Column('gender', sa.String(length=255), nullable=True),
sa.Column('created_on',
sa.DateTime(),
server_default=sa.text('now()'),
nullable=True), sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('email'))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
"users",
sa.Column("id", sa.Integer(), nullable=False),
sa.Column("username", sa.String(length=80), nullable=False),
sa.Column("email", sa.String(length=80), nullable=False),
sa.Column("password", sa.LargeBinary(length=128), nullable=True),
sa.Column("created_at", sa.DateTime(), nullable=False),
sa.Column("first_name", sa.String(length=30), nullable=True),
sa.Column("last_name", sa.String(length=30), nullable=True),
sa.Column("active", sa.Boolean(), nullable=True),
sa.Column("type", sa.String(length=20), nullable=True),
sa.Column("stripe_id", sa.String(), nullable=True),
sa.Column("is_admin", sa.Boolean(), nullable=True),
sa.Column("amount_paid", sa.Numeric(), nullable=True),
sa.Column("verified", sa.Boolean(), nullable=True),
sa.Column("amount_earned", sa.Numeric(), nullable=True),
sa.PrimaryKeyConstraint("id"),
sa.UniqueConstraint("email"),
sa.UniqueConstraint("username"),
)
op.create_table(
"payments",
sa.Column("id", sa.Integer(), nullable=False),
sa.Column("customer_id", sa.Integer(), nullable=True),
sa.Column("merchant_id", sa.Integer(), nullable=True),
sa.Column("amount", sa.Numeric(), nullable=True),
sa.ForeignKeyConstraint(
["customer_id"],
["users.id"],
),
sa.ForeignKeyConstraint(
["merchant_id"],
["users.id"],
),
sa.PrimaryKeyConstraint("id"),
)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('imgs',
sa.Column('id', mysql.INTEGER(display_width=11), autoincrement=True, nullable=False),
sa.Column('img_1', mysql.MEDIUMBLOB(), nullable=False),
sa.Column('img_2', mysql.MEDIUMBLOB(), nullable=True),
sa.Column('img_3', mysql.MEDIUMBLOB(), nullable=True),
sa.Column('img_4', mysql.MEDIUMBLOB(), nullable=True),
sa.Column('filetypes_id', sa.Integer(), nullable=False),
sa.PrimaryKeyConstraint('id'),
mysql_default_charset='utf8mb4',
mysql_engine='InnoDB'
)
op.create_table('filetypes',
sa.Column('id', mysql.INTEGER(display_width=11), autoincrement=True, nullable=False),
sa.Column('ft_1', sa.String(length=5), nullable=False),
sa.Column('ft_2', sa.String(length=5), nullable=True),
sa.Column('ft_3', sa.String(length=5), nullable=True),
sa.Column('ft_4', sa.String(length=5), nullable=True),
sa.PrimaryKeyConstraint('id')
)
op.add_column('entries', sa.Column('description', sa.LargeBinary(length=4294967295), nullable=True))
op.add_column('entries', sa.Column('imgs_id', sa.Integer(), nullable=False))
op.create_foreign_key(
'fk_imgs_id',
'entries', 'imgs',
['imgs_id'], ['id'],
)
op.create_foreign_key(
'fk_filetypes_id',
'imgs', 'filetypes',
['filetypes_id'], ['id'],
)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('cache',
sa.Column('key', sa.String(length=100), nullable=False),
sa.Column('value', sa.PickleType(), nullable=True),
sa.Column('last_updated', sa.DateTime(), nullable=True),
sa.PrimaryKeyConstraint('key')
)
op.create_table('site_configuration',
sa.Column('key', sa.String(length=100), nullable=False),
sa.Column('value', sa.PickleType(), nullable=True),
sa.PrimaryKeyConstraint('key')
)
op.create_table('user',
sa.Column('id', sa.Integer(), autoincrement=False, nullable=False),
sa.Column('name', sa.String(length=500), nullable=True),
sa.Column('avatar_url', sa.String(length=500), nullable=True),
sa.Column('faculty', sa.Boolean(), nullable=True),
sa.Column('anonymous_by_default', sa.Boolean(), nullable=True),
sa.Column('autosave_timeout', sa.Integer(), nullable=True),
sa.Column('autosave_enabled', sa.Boolean(), nullable=True),
sa.Column('random_seed', sa.LargeBinary(length=32), nullable=True),
sa.PrimaryKeyConstraint('id')
)
op.create_table('nicety',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('end_date', sa.Date(), nullable=True),
sa.Column('author_id', sa.Integer(), nullable=True),
sa.Column('target_id', sa.Integer(), nullable=True),
sa.Column('anonymous', sa.Boolean(), nullable=True),
sa.Column('faculty_reviewed', sa.Boolean(), nullable=True),
sa.Column('starred', sa.Boolean(), nullable=True),
sa.Column('text', sa.Text(), nullable=True),
sa.Column('no_read', sa.Boolean(), nullable=True),
sa.Column('date_updated', sa.Text(), nullable=True),
sa.ForeignKeyConstraint(['author_id'], ['user.id'], ),
sa.PrimaryKeyConstraint('id')
)
def upgrade():
# Appears there is an alembic issue with autogenerating enums:
# https://github.com/sqlalchemy/alembic/issues/278
compression_enum = postgresql.ENUM("none",
"gzip",
"bzip2",
"lzma",
name="compressionenum")
compression_enum.create(op.get_bind())
# ### commands auto generated by Alembic - please adjust! ###
op.add_column("kv_store",
sa.Column("compression", compression_enum, nullable=True))
op.add_column("kv_store",
sa.Column("compression_level", sa.Integer(), nullable=True))
op.add_column("kv_store", sa.Column("data",
sa.LargeBinary(),
nullable=True))
op.alter_column("kv_store",
"value",
existing_type=postgresql.JSON(astext_type=sa.Text()),
nullable=True)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'files', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('description', sa.String(length=140), nullable=False),
sa.Column('file', sa.LargeBinary(), nullable=True),
sa.Column('timestamp', sa.DateTime(), nullable=False),
sa.Column('author', sa.Integer(), nullable=True),
sa.Column('ticket_id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(
['ticket_id'],
['tickets.id'],
), sa.PrimaryKeyConstraint('id'))
op.alter_column('comment',
'ticket_id',
existing_type=sa.INTEGER(),
nullable=False)
op.alter_column('comment',
'timestamp',
existing_type=sa.DATETIME(),
nullable=False)
op.drop_column('comment', 'parent_id')
op.drop_column('comment', 'path')
def upgrade():
### commands auto generated by Alembic - please adjust! ###
op.create_table(
'skills', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=250), nullable=False),
sa.Column('description', sa.String(length=255), nullable=False),
sa.Column('image', sa.LargeBinary(), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'skills_levels', sa.Column('project_id', sa.Integer(), nullable=False),
sa.Column('user_id', sa.Integer(), nullable=False),
sa.Column('skill_id', sa.Integer(), nullable=False),
sa.Column('level', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(
['project_id'],
['projects.id'],
), sa.ForeignKeyConstraint(
['skill_id'],
['skills.id'],
), sa.ForeignKeyConstraint(
['user_id'],
['users.id'],
), sa.PrimaryKeyConstraint('project_id', 'user_id', 'skill_id'))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column(
'pages',
sa.Column('content_compressed', sa.LargeBinary(), nullable=True))
# ### end Alembic commands ###
# Manually run the commit.
conn = op.get_bind()
conn.execute("COMMIT")
# Actually do the migration.
db = sm()
done = 0
print("Starting compression conversion process.")
for page in db.query(Page):
if done % 10 == 0:
print(f"Compressed {done} pages.")
db.commit()
if page.content:
page.set_content(page.content)
done += 1
db.commit()
def upgrade():
op.create_table('imagedata', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('image', sa.Integer(), nullable=False),
sa.Column('fits_header', sa.String(), nullable=True),
sa.Column('fits_data', sa.LargeBinary(), nullable=True),
sa.ForeignKeyConstraint(
['image'],
['image.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_imagedata_image'),
'imagedata', ['image'],
unique=False)
op.add_column(u'frequencyband',
sa.Column('dataset', sa.Integer(), nullable=False))
op.create_index(op.f('ix_frequencyband_dataset'),
'frequencyband', ['dataset'],
unique=False)
op.create_foreign_key(None, 'frequencyband', 'dataset', ['dataset'],
['id'])
op.drop_index('ix_varmetric_runcat', table_name='varmetric')
op.create_index(op.f('ix_varmetric_runcat'),
'varmetric', ['runcat'],
unique=True)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'users', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('first_name', sa.VARCHAR(length=20), nullable=False),
sa.Column('last_name', sa.VARCHAR(length=20), nullable=False),
sa.Column('email', sa.VARCHAR(length=60), nullable=False),
sa.Column('username', sa.VARCHAR(length=20), nullable=False),
sa.Column('password', sa.LargeBinary(), nullable=False),
sa.Column('phone', sa.VARCHAR(length=50), nullable=True),
sa.Column('job', sa.VARCHAR(length=50), nullable=True),
sa.Column('profile', sa.String(), nullable=False),
sa.Column('created_at', sa.DateTime(), nullable=False),
sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('email'),
sa.UniqueConstraint('phone'), sa.UniqueConstraint('username'))
op.execute(
'ALTER TABLE answers ALTER COLUMN user_id TYPE INTEGER USING user_id::integer'
)
op.execute(
'ALTER TABLE questions ALTER COLUMN user_id TYPE INTEGER USING user_id::integer'
)
op.create_foreign_key(None, 'answers', 'users', ['user_id'], ['id'])
op.create_foreign_key(None, 'questions', 'users', ['user_id'], ['id'])
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.alter_column('roles',
'default',
existing_type=sa.Boolean(),
type_=mysql.TINYINT(display_width=1),
existing_nullable=True)
op.alter_column('posts',
'hide',
existing_type=sa.Boolean(),
type_=mysql.TINYINT(display_width=1),
existing_nullable=True)
op.alter_column('post_type',
'default',
existing_type=sa.Boolean(),
type_=mysql.TINYINT(display_width=1),
existing_nullable=True)
op.alter_column('messages',
'hide',
existing_type=sa.Boolean(),
type_=mysql.TINYINT(display_width=1),
existing_nullable=True)
op.alter_column('friend_link',
'logo',
existing_type=sa.LargeBinary(length=65535),
type_=mysql.VARCHAR(length=64),
existing_nullable=True)
op.alter_column('friend_link',
'hide',
existing_type=sa.Boolean(),
type_=mysql.TINYINT(display_width=1),
existing_nullable=True)
op.alter_column('comments',
'hide',
existing_type=sa.Boolean(),
type_=mysql.TINYINT(display_width=1),
existing_nullable=True)
def setup_thd(conn):
metadata = sa.MetaData()
metadata.bind = conn
builds = sautils.Table(
'builds',
metadata,
sa.Column('id', sa.Integer, primary_key=True),
# ...
)
builds.create()
build_data = sautils.Table(
'build_data',
metadata,
sa.Column('id', sa.Integer, primary_key=True),
sa.Column('buildid',
sa.Integer,
sa.ForeignKey('builds.id', ondelete='CASCADE'),
nullable=False),
sa.Column('name', sa.String(256), nullable=False),
sa.Column('value',
sa.LargeBinary().with_variant(
sa.dialects.mysql.LONGBLOB, "mysql"),
nullable=False),
sa.Column('source', sa.String(256), nullable=False),
)
build_data.create()
conn.execute(builds.insert(), [{'id': 3}])
conn.execute(build_data.insert(), [{
'id': 15,
'buildid': 3,
'name': 'name1',
'value': b'value1',
'source': 'source1'
}])
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('res_docclasses',
sa.Column('docclass_id', sa.Integer(), nullable=False),
sa.Column('docclass_pid', sa.Integer(), nullable=True),
sa.Column('docclass_name', sa.String(length=128), nullable=True),
sa.Column('docclass_createtime', sa.DateTime(), nullable=True),
sa.ForeignKeyConstraint(['docclass_pid'], ['res_docclasses.docclass_id'], ),
sa.PrimaryKeyConstraint('docclass_id')
)
op.create_table('res_docs',
sa.Column('doc_id', sa.Integer(), nullable=False),
sa.Column('class_id', sa.Integer(), nullable=True),
sa.Column('author_id', sa.Integer(), nullable=True),
sa.Column('doc_title', sa.String(length=64), nullable=True),
sa.Column('doc_summary', sa.String(length=512), nullable=True),
sa.Column('doc_content_html', sa.Text(), nullable=True),
sa.Column('doc_sort', sa.Integer(), nullable=True),
sa.Column('doc_isshow', sa.Boolean(), nullable=True),
sa.Column('doc_updatetime', sa.DateTime(), nullable=True),
sa.Column('doc_createtime', sa.DateTime(), nullable=True),
sa.ForeignKeyConstraint(['author_id'], ['ua_users.ua_user_id'], ),
sa.ForeignKeyConstraint(['class_id'], ['res_docclasses.docclass_id'], ),
sa.PrimaryKeyConstraint('doc_id')
)
op.create_table('res_files',
sa.Column('file_id', sa.Integer(), nullable=False),
sa.Column('author_id', sa.Integer(), nullable=True),
sa.Column('file_name', sa.String(length=128), nullable=True),
sa.Column('file_type', sa.String(length=64), nullable=True),
sa.Column('file_data', sa.LargeBinary(), nullable=True),
sa.Column('file_uri', sa.String(length=512), nullable=True),
sa.Column('file_isextern', sa.Boolean(), nullable=True),
sa.Column('file_createtime', sa.DateTime(), nullable=True),
sa.ForeignKeyConstraint(['author_id'], ['ua_users.ua_user_id'], ),
sa.PrimaryKeyConstraint('file_id')
)
class PyScriptsScript(Base, PyScriptsBase):
"""A PyScripts entry.
"""
__tablename__ = 'pyscripts_scripts'
id = sqlalchemy.Column(sqlalchemy.Integer, primary_key=True)
script_id = sqlalchemy.Column(sqlalchemy.String(36),
nullable=False,
unique=True)
name = sqlalchemy.Column(sqlalchemy.String(255),
nullable=False,
unique=True)
_data = sqlalchemy.Column('data', sqlalchemy.LargeBinary(), nullable=False)
_checksum = sqlalchemy.Column('checksum',
sqlalchemy.String(40),
nullable=False)
@hybrid.hybrid_property
def data(self):
udata = zlib.decompress(self._data)
return udata
@data.setter
def data(self, value):
sha_check = hashlib.sha1()
sha_check.update(value)
self._checksum = sha_check.hexdigest()
self._data = zlib.compress(value)
@hybrid.hybrid_property
def checksum(self):
return self._checksum
def __repr__(self):
return ('<PyScripts Script[{uuid}]: '
'name={name}>').format(uuid=self.script_id, name=self.name)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.alter_column('workflow_v2',
'config',
existing_type=sa.LargeBinary(),
type_=sa.LargeBinary(16777215),
comment='config')
op.alter_column('template_v2',
'config',
existing_type=sa.LargeBinary(),
type_=sa.LargeBinary(16777215),
comment='config',
nullable=False)
op.alter_column('workflow_v2',
'fork_proposal_config',
existing_type=sa.LargeBinary(),
type_=sa.LargeBinary(16777215),
comment='fork_proposal_config')
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('CURRENCY',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=32), nullable=False),
sa.Column('country', sa.String(length=32), nullable=False),
sa.Column('code', sa.String(length=10), nullable=False),
sa.Column('number', sa.Integer(), nullable=False),
sa.PrimaryKeyConstraint('id')
)
op.create_table('EMERGENCY_CONTACT',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('user_id', postgresql.UUID(as_uuid=True), nullable=False),
sa.Column('firstname', sa.String(length=32), nullable=True),
sa.Column('lastname', sa.String(length=32), nullable=True),
sa.Column('homephone', sa.String(length=32), nullable=True),
sa.Column('mobilephone', sa.String(length=32), nullable=True),
sa.Column('workphone', sa.String(length=32), nullable=True),
sa.ForeignKeyConstraint(['user_id'], ['USER.uuid'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_table('TOUR_LOCATION',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('tour_id', postgresql.UUID(as_uuid=True), nullable=False),
sa.Column('name', sa.String(length=60), nullable=True),
sa.Column('address', sa.String(length=60), nullable=True),
sa.Column('lat', sa.Float(), nullable=False),
sa.Column('lng', sa.Float(), nullable=False),
sa.ForeignKeyConstraint(['tour_id'], ['TOUR.uuid'], ),
sa.PrimaryKeyConstraint('id')
)
op.drop_table('LOCATION')
op.add_column('USER', sa.Column('dob', sa.Date(), nullable=False))
op.add_column('USER', sa.Column('photo', sa.LargeBinary(), nullable=True))
op.add_column('USER', sa.Column('url', sa.String(length=60), nullable=True))
op.drop_constraint('USER_uuid_key', 'USER', type_='unique')
op.create_unique_constraint(None, 'USER', ['email'])
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
"background_jobs",
sa.Column("id", sa.BigInteger(), nullable=False),
sa.Column(
"job_type",
sa.Enum("send_email",
"purge_login_tokens",
"purge_signup_tokens",
name="backgroundjobtype"),
nullable=False,
),
sa.Column(
"state",
sa.Enum("pending",
"reserved",
"completed",
"error",
"failed",
name="backgroundjobstate"),
nullable=False,
),
sa.Column("queued",
sa.DateTime(timezone=True),
server_default=sa.text("now()"),
nullable=False),
sa.Column("next_attempt_after",
sa.DateTime(timezone=True),
server_default=sa.text("now()"),
nullable=False),
sa.Column("try_count", sa.Integer(), nullable=False),
sa.Column("max_tries", sa.Integer(), nullable=False),
sa.Column("payload", sa.LargeBinary(), nullable=False),
sa.Column("failure_info", sa.String(), nullable=True),
sa.PrimaryKeyConstraint("id", name=op.f("pk_background_jobs")),
)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'messages',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('created_at', sa.TIMESTAMP(), nullable=False),
sa.Column('updated_at', sa.TIMESTAMP(), nullable=False),
sa.Column('message', sa.VARCHAR(length=255), nullable=True),
sa.Column('recipient_id', sa.Integer(), nullable=True),
sa.Column('sender_id', sa.Integer(), nullable=True),
sa.Column('is_delete', sa.BOOLEAN(), nullable=True),
sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('id'))
op.create_table(
'users',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('created_at', sa.TIMESTAMP(), nullable=False),
sa.Column('updated_at', sa.TIMESTAMP(), nullable=False),
sa.Column('login', sa.VARCHAR(length=50), nullable=False),
sa.Column('password', sa.LargeBinary(), nullable=False),
sa.Column('first_name', sa.VARCHAR(length=50), nullable=True),
sa.Column('last_name', sa.VARCHAR(length=50), nullable=True),
sa.Column('is_delete', sa.BOOLEAN(), nullable=False),
sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('id'),
sa.UniqueConstraint('login'))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('users',
sa.Column('id', postgresql.UUID(), server_default=sa.text('uuid_generate_v4()'), nullable=False, comment='ID пользователя'),
sa.Column('login', sa.String(), nullable=False, comment='Логин пользователя'),
sa.Column('password', sa.LargeBinary(), nullable=False, comment='Пароль пользователя'),
sa.PrimaryKeyConstraint('id')
)
op.alter_column('assessments', 'id',
existing_type=postgresql.UUID(),
comment='ID оценки',
existing_server_default=sa.text('uuid_generate_v4()'))
op.alter_column('assessments', 'photo_id',
existing_type=postgresql.UUID(),
comment='ID фотографии.',
existing_nullable=True)
op.alter_column('assessments', 'rating',
existing_type=postgresql.DOUBLE_PRECISION(precision=53),
comment='Рейтинг фотографии.',
existing_nullable=True)
op.alter_column('photos', 'id',
existing_type=postgresql.UUID(),
comment='Id photo.',
existing_server_default=sa.text('uuid_generate_v4()'))
def upgrade(migrate_engine):
metadata = sa.MetaData()
metadata.bind = migrate_engine
sautils.Table(
'builds',
metadata,
sa.Column('id', sa.Integer, primary_key=True),
# ...
)
build_data = sautils.Table(
'build_data',
metadata,
sa.Column('id', sa.Integer, primary_key=True),
sa.Column('buildid',
sa.Integer,
sa.ForeignKey('builds.id', ondelete='CASCADE'),
nullable=False),
sa.Column('name', sa.String(256), nullable=False),
sa.Column('value',
sa.LargeBinary().with_variant(sa.dialects.mysql.LONGBLOB,
"mysql"),
nullable=False),
sa.Column('source', sa.String(256), nullable=False),
)
# create the tables
build_data.create()
# create indexes
idx = sa.Index('build_data_buildid_name',
build_data.c.buildid,
build_data.c.name,
unique=True)
idx.create()
