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='Пункты меню')