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