def upgrade(): op.execute(CreateSequence(Sequence('object_id_seq'))) op.execute(CreateSequence(Sequence('blockchain_index_seq'))) op.create_table( 'blockchain', Column('id', Integer(), Sequence('object_id_seq'), primary_key=True), Column('object_id', String(), nullable=False), Column('creation_timestamp', Integer(), nullable=False), Column('data', LargeBinary(), nullable=False), Column('blockchain_index', Integer(), Sequence('blockchain_index_seq'), nullable=False, unique=True), Index('idx_blockchain', 'id', 'object_id', 'blockchain_index', 'creation_timestamp', unique=True))
def upgrade(): op.execute(sa.text("create extension if not exists \"uuid-ossp\";")) op.create_table( "devices", sa.Column("id", UUID(), nullable=False, server_default=sa.func.uuid_generate_v4()), sa.Column("user_id", sa.BIGINT(), nullable=False), sa.Column("name", sa.TEXT(), nullable=False), sa.Column("pkey", sa.TEXT(), nullable=False), sa.Column("cert_req", sa.TEXT(), nullable=False), sa.Column("cert", sa.TEXT(), nullable=False), sa.Column("cert_sn", sa.BIGINT(), nullable=False), sa.Column("created_at", sa.TIMESTAMP(timezone=True), nullable=False, server_default=sa.text("current_timestamp")), sa.Column("removed", sa.BOOLEAN(), nullable=False, server_default=sa.literal(False)), sa.PrimaryKeyConstraint("id"), sa.UniqueConstraint("cert_sn")) op.create_index("uniq_devices_user_id_name", "devices", ("user_id", "name"), unique=True, postgresql_where=sa.text("not removed")) op.execute( CreateSequence( sa.Sequence("certs_sn", start=2971215073, increment=233, minvalue=1, cycle=True)))
async def visit_sequence(self, sequence, create_ok=False): if not create_ok and not await self._can_create_sequence(sequence): return await self.connection.status(CreateSequence(sequence))
def create_seq(seq): if dialect_supports_sequences(): op.execute(CreateSequence(seq))
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### log.debug('Creating tables ...') op.execute(CreateSequence(Sequence('grid_seq'))) person_group = op.create_table( 'person_group', sa.Column('grid', sa.BigInteger(), sa.Sequence('grid_seq'), nullable=False), sa.Column('code', sa.Integer(), sa.Sequence('person_group_code_seq'), nullable=True), sa.Column('name', sa.String(length=250), nullable=False), sa.Column('flag', sa.CHAR(length=1), nullable=False, default='A'), sa.PrimaryKeyConstraint('grid')) op.execute(CreateSequence(Sequence('person_group_code_seq'))) person = op.create_table( 'person', sa.Column('grid', sa.BigInteger(), sa.Sequence('grid_seq'), nullable=False), sa.Column( 'code', sa.Integer(), sa.Sequence('person_code_seq'), nullable=True, ), sa.Column('doc', sa.String(length=20), nullable=False), sa.Column('name', sa.String(length=250), nullable=False), sa.Column('email', sa.String(length=200), nullable=False), sa.Column('flag', sa.CHAR(length=1), nullable=False, default='A'), sa.Column('city_code', sa.String(length=10), nullable=False), sa.Column('city_name', sa.String(length=100), nullable=False), sa.Column('state', sa.String(length=50), nullable=False), sa.Column('zipcode', sa.String(length=10), nullable=True), sa.Column('district', sa.String(length=50), nullable=True), sa.Column('country', sa.String(length=50), nullable=True), sa.Column('address', sa.Unicode(length=50), nullable=True), sa.Column('address_nr', sa.String(length=50), nullable=False), sa.Column('group_grid', sa.Integer(), nullable=True), sa.ForeignKeyConstraint( ['group_grid'], ['person_group.grid'], ), sa.PrimaryKeyConstraint('grid')) op.execute(CreateSequence(Sequence('person_code_seq'))) product = op.create_table( 'product', sa.Column('grid', sa.BigInteger(), sa.Sequence('grid_seq'), nullable=False), sa.Column('code', sa.Integer(), sa.Sequence('product_code_seq'), nullable=True), sa.Column('barcode', sa.String(length=50), nullable=False), sa.Column('name', sa.String(length=250), nullable=False), sa.Column('price', sa.Float(), nullable=False), sa.Column('person_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint( ['person_id'], ['person.grid'], ), sa.PrimaryKeyConstraint('grid'), sa.UniqueConstraint('code')) op.execute(CreateSequence(Sequence('product_code_seq'))) # ### end Alembic commands ### bind = op.get_bind() session = sa.orm.Session(bind=bind) person_group_data = list() person_group_data.append({'name': 'EMPRESA'}) person_group_data.append({'name': 'CLIENTES'}) person_group_data.append({'name': 'FORNECEDORES'}) person_group_data.append({'name': 'FUNCIONARIOS'}) log.debug('Populate person_group table') for pg in person_group_data: session.execute(sa.insert(person_group).values(pg)) log.debug('Populate person table') person_data = { 'name': 'EMPRESA REGISTRADA', 'email': '*****@*****.**', 'doc': '00.000.000/0000-00', 'city_code': '4202404', 'city_name': 'Blumenau', 'state': 'SC', 'zipcode': '89010-000', 'district': "Centro", 'country': 'Brasil', 'address': 'Rua XV de Novembro', 'address_nr': '45', 'group_grid': 1 } session.execute(sa.insert(person).values(person_data))
def upgrade(): op.execute(CreateSequence(Sequence('exec_type_id_seq'))) op.execute(CreateSequence(Sequence('item_id_seq'))) op.create_table('exec_type', sa.Column( 'id', sa.BigInteger(), server_default=sa.text("nextval('exec_type_id_seq')"), nullable=False, comment='Уникальный идентификатор запускаемого типа'), sa.Column('name', sa.Text(), nullable=False, comment='Наименование запускаемого типа'), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('name'), schema='public', comment='Запускаемые типы') op.create_table( 'root', sa.Column( 'item_id', sa.BigInteger(), nullable=False, comment='Идентификатор корневой пункта для построения дерева'), sa.PrimaryKeyConstraint('item_id'), schema='public', comment='Корень либо маркер для построения дерева меню') op.create_table('item', sa.Column('id', sa.BigInteger(), server_default=sa.text("nextval('item_id_seq')"), nullable=False, comment='Уникальный идентификатор пункта'), sa.Column('parent_id', sa.BigInteger(), nullable=True, comment='Идентификатор родительского пункта'), sa.Column('sorted_id', sa.BigInteger(), nullable=False, comment='Порядок сортировки на одном уровне'), sa.Column('name', sa.Text(), nullable=False, comment='Наименование пункта'), sa.Column('full_name', sa.Text(), nullable=False, comment='Полное наименование пункта'), sa.Column('key', sa.Text(), nullable=True, comment='Ключ запускаемого типа'), sa.Column('exec_type_id', sa.BigInteger(), nullable=True, comment='Идентификатор запускаемого типа'), sa.Column('visible', sa.Boolean(), server_default=sa.text('false'), nullable=False, comment='Видимость пункта в меню'), sa.ForeignKeyConstraint(['exec_type_id'], ['public.exec_type.id'], onupdate='CASCADE'), sa.ForeignKeyConstraint(['parent_id'], ['public.item.id'], onupdate='CASCADE', ondelete='CASCADE'), sa.PrimaryKeyConstraint('id'), schema='public', comment='Пункты меню')