"""empty message

Revision ID: de316f0831f9
Revises: 6<PASSWORD>1e462e9
Create Date: 2021-11-19 23:38:39.754126

"""
import sqlalchemy as sa
import sqlmodel
from alembic import op
from sqlalchemy.dialects import postgresql

# revision identifiers, used by Alembic.
revision = "de316f0831f9"
down_revision = "60f151e462e9"
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###

    sale_type = postgresql.ENUM(
        "SALE_IN_PIX",
        "SALE_IN_DEBT",
        "SALE_IN_CREDIT",
        "SALE_IN_MONEY",
        "SALE_IN_TRANSFER",
        "SALE_IN_BILLET",
        "SALE_OTHERS",
        name="saletype",
    )
    sale_type.create(op.get_bind())
    op.add_column(
        "orders",
        sa.Column(
            "sale_type",
            sa.Enum(
                "SALE_IN_PIX",
                "SALE_IN_DEBT",
                "SALE_IN_CREDIT",
                "SALE_IN_MONEY",
                "SALE_IN_TRANSFER",
                "SALE_IN_BILLET",
                "SALE_OTHERS",
                name="saletype",
            ),
            nullable=True,
        ),
    )

    op.drop_index("ix_balance_operation", table_name="balance")
    op.drop_index("ix_balance_type", table_name="balance")
    op.drop_column("balance", "type")
    op.alter_column("clients", "email", existing_type=sa.VARCHAR(), nullable=False)
    op.alter_column("clients", "phone", existing_type=sa.VARCHAR(), nullable=False)
    op.alter_column("clients", "owner_id", existing_type=postgresql.UUID(), nullable=False)

    op.alter_column("orders", "owner_id", existing_type=postgresql.UUID(), nullable=False)
    op.add_column("clients", sa.Column("zip_code", sqlmodel.sql.sqltypes.AutoString(), nullable=True))
    op.add_column("clients", sa.Column("address", sqlmodel.sql.sqltypes.AutoString(), nullable=True))
    op.add_column("order_details", sa.Column("value", sa.Float(), nullable=True))
    op.drop_column("order_details", "sell_value")
    op.drop_column("order_details", "cost")

    op.drop_index("ix_fiscal_note_items_fiscal_note_id", table_name="fiscal_note_items")
    op.drop_index("ix_fiscal_note_items_item_id", table_name="fiscal_note_items")
    op.drop_index("ix_fiscal_note_items_owner_id", table_name="fiscal_note_items")
    op.drop_index("ix_fiscal_note_items_sugested_sell_value", table_name="fiscal_note_items")
    op.drop_table("fiscal_note_items")
    op.drop_index("ix_fiscal_notes_owner_id", table_name="fiscal_notes")
    op.drop_index("ix_fiscal_notes_purchase_date", table_name="fiscal_notes")
    op.drop_table("fiscal_notes")
    op.drop_index("ix_users_email", table_name="users")
    op.create_index(op.f("ix_users_email"), "users", ["email"], unique=True)

    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.alter_column("orders", "owner_id", existing_type=postgresql.UUID(), nullable=True)
    op.drop_column("orders", "sale_type")
    op.alter_column("clients", "owner_id", existing_type=postgresql.UUID(), nullable=True)
    op.alter_column("clients", "phone", existing_type=sa.VARCHAR(), nullable=True)
    op.alter_column("clients", "email", existing_type=sa.VARCHAR(), nullable=True)
    op.add_column(
        "balance",
        sa.Column("type", postgresql.ENUM("DEBT", "CREDIT", name="balancetype"), autoincrement=False, nullable=True),
    )
    op.create_index("ix_balance_type", "balance", ["type"], unique=False)
    op.create_index("ix_balance_operation", "balance", ["operation"], unique=False)
    op.drop_column("clients", "address")
    op.drop_column("clients", "zip_code")
    op.add_column(
        "order_details",
        sa.Column("cost", postgresql.DOUBLE_PRECISION(precision=53), autoincrement=False, nullable=False),
    )
    op.add_column(
        "order_details",
        sa.Column("sell_value", postgresql.DOUBLE_PRECISION(precision=53), autoincrement=False, nullable=False),
    )
    op.drop_column("order_details", "value")

    op.drop_index(op.f("ix_users_email"), table_name="users")
    op.create_index("ix_users_email", "users", ["email"], unique=False)
    op.create_table(
        "fiscal_notes",
        sa.Column("id", postgresql.UUID(), autoincrement=False, nullable=False),
        sa.Column("description", sa.VARCHAR(), autoincrement=False, nullable=False),
        sa.Column("purchase_date", sa.DATE(), autoincrement=False, nullable=False),
        sa.Column("owner_id", postgresql.UUID(), autoincrement=False, nullable=True),
        sa.Column("file_id", sa.VARCHAR(), autoincrement=False, nullable=False),
        sa.ForeignKeyConstraint(["file_id"], ["files.bucket_key"], name="fiscal_notes_file_id_fkey"),
        sa.ForeignKeyConstraint(["owner_id"], ["users.id"], name="fiscal_notes_owner_id_fkey"),
        sa.PrimaryKeyConstraint("id", name="fiscal_notes_pkey"),
        postgresql_ignore_search_path=False,
    )
    op.create_index("ix_fiscal_notes_purchase_date", "fiscal_notes", ["purchase_date"], unique=False)
    op.create_index("ix_fiscal_notes_owner_id", "fiscal_notes", ["owner_id"], unique=False)
    op.create_table(
        "fiscal_note_items",
        sa.Column("id", postgresql.UUID(), autoincrement=False, nullable=False),
        sa.Column("buy_value", postgresql.DOUBLE_PRECISION(precision=53), autoincrement=False, nullable=False),
        sa.Column(
            "sugested_sell_value", postgresql.DOUBLE_PRECISION(precision=53), autoincrement=False, nullable=False
        ),
        sa.Column("owner_id", postgresql.UUID(), autoincrement=False, nullable=False),
        sa.Column("fiscal_note_id", postgresql.UUID(), autoincrement=False, nullable=False),
        sa.Column("item_id", postgresql.UUID(), autoincrement=False, nullable=False),
        sa.Column("file_id", sa.VARCHAR(), autoincrement=False, nullable=False),
        sa.ForeignKeyConstraint(["file_id"], ["files.bucket_key"], name="fiscal_note_items_file_id_fkey"),
        sa.ForeignKeyConstraint(["fiscal_note_id"], ["fiscal_notes.id"], name="fiscal_note_items_fiscal_note_id_fkey"),
        sa.ForeignKeyConstraint(["item_id"], ["items.id"], name="fiscal_note_items_item_id_fkey"),
        sa.ForeignKeyConstraint(["owner_id"], ["users.id"], name="fiscal_note_items_owner_id_fkey"),
        sa.PrimaryKeyConstraint("id", name="fiscal_note_items_pkey"),
    )
    op.create_index(
        "ix_fiscal_note_items_sugested_sell_value", "fiscal_note_items", ["sugested_sell_value"], unique=False
    )
    op.create_index("ix_fiscal_note_items_owner_id", "fiscal_note_items", ["owner_id"], unique=False)
    op.create_index("ix_fiscal_note_items_item_id", "fiscal_note_items", ["item_id"], unique=False)
    op.create_index("ix_fiscal_note_items_fiscal_note_id", "fiscal_note_items", ["fiscal_note_id"], unique=False)
    # ### end Alembic commands ###

sqlalchemy.dialects.postgresql.ENUM sqlmodel.sql.sqltypes.AutoString alembic.op.drop_index sqlalchemy.DATE sqlalchemy.VARCHAR alembic.op.drop_table sqlalchemy.Float sqlalchemy.dialects.postgresql.DOUBLE_PRECISION alembic.op.get_bind sqlalchemy.PrimaryKeyConstraint alembic.op.create_index alembic.op.f sqlalchemy.Enum sqlalchemy.dialects.postgresql.UUID sqlalchemy.ForeignKeyConstraint alembic.op.drop_column
[((461, 620), 'sqlalchemy.dialects.postgresql.ENUM', 'postgresql.ENUM', (['"""SALE_IN_PIX"""', '"""SALE_IN_DEBT"""', '"""SALE_IN_CREDIT"""', '"""SALE_IN_MONEY"""', '"""SALE_IN_TRANSFER"""', '"""SALE_IN_BILLET"""', '"""SALE_OTHERS"""'], {'name': '"""saletype"""'}), "('SALE_IN_PIX', 'SALE_IN_DEBT', 'SALE_IN_CREDIT',\n    'SALE_IN_MONEY', 'SALE_IN_TRANSFER', 'SALE_IN_BILLET', 'SALE_OTHERS',\n    name='saletype')\n", (476, 620), False, 'from sqlalchemy.dialects import postgresql\n'), ((1150, 1209), 'alembic.op.drop_index', 'op.drop_index', (['"""ix_balance_operation"""'], {'table_name': '"""balance"""'}), "('ix_balance_operation', table_name='balance')\n", (1163, 1209), False, 'from alembic import op\n'), ((1214, 1268), 'alembic.op.drop_index', 'op.drop_index', (['"""ix_balance_type"""'], {'table_name': '"""balance"""'}), "('ix_balance_type', table_name='balance')\n", (1227, 1268), False, 'from alembic import op\n'), ((1273, 1306), 'alembic.op.drop_column', 'op.drop_column', (['"""balance"""', '"""type"""'], {}), "('balance', 'type')\n", (1287, 1306), False, 'from alembic import op\n'), ((1950, 1995), 'alembic.op.drop_column', 'op.drop_column', (['"""order_details"""', '"""sell_value"""'], {}), "('order_details', 'sell_value')\n", (1964, 1995), False, 'from alembic import op\n'), ((2000, 2039), 'alembic.op.drop_column', 'op.drop_column', (['"""order_details"""', '"""cost"""'], {}), "('order_details', 'cost')\n", (2014, 2039), False, 'from alembic import op\n'), ((2045, 2134), 'alembic.op.drop_index', 'op.drop_index', (['"""ix_fiscal_note_items_fiscal_note_id"""'], {'table_name': '"""fiscal_note_items"""'}), "('ix_fiscal_note_items_fiscal_note_id', table_name=\n    'fiscal_note_items')\n", (2058, 2134), False, 'from alembic import op\n'), ((2134, 2211), 'alembic.op.drop_index', 'op.drop_index', (['"""ix_fiscal_note_items_item_id"""'], {'table_name': '"""fiscal_note_items"""'}), "('ix_fiscal_note_items_item_id', table_name='fiscal_note_items')\n", (2147, 2211), False, 'from alembic import op\n'), ((2216, 2294), 'alembic.op.drop_index', 'op.drop_index', (['"""ix_fiscal_note_items_owner_id"""'], {'table_name': '"""fiscal_note_items"""'}), "('ix_fiscal_note_items_owner_id', table_name='fiscal_note_items')\n", (2229, 2294), False, 'from alembic import op\n'), ((2299, 2393), 'alembic.op.drop_index', 'op.drop_index', (['"""ix_fiscal_note_items_sugested_sell_value"""'], {'table_name': '"""fiscal_note_items"""'}), "('ix_fiscal_note_items_sugested_sell_value', table_name=\n    'fiscal_note_items')\n", (2312, 2393), False, 'from alembic import op\n'), ((2393, 2427), 'alembic.op.drop_table', 'op.drop_table', (['"""fiscal_note_items"""'], {}), "('fiscal_note_items')\n", (2406, 2427), False, 'from alembic import op\n'), ((2432, 2500), 'alembic.op.drop_index', 'op.drop_index', (['"""ix_fiscal_notes_owner_id"""'], {'table_name': '"""fiscal_notes"""'}), "('ix_fiscal_notes_owner_id', table_name='fiscal_notes')\n", (2445, 2500), False, 'from alembic import op\n'), ((2505, 2578), 'alembic.op.drop_index', 'op.drop_index', (['"""ix_fiscal_notes_purchase_date"""'], {'table_name': '"""fiscal_notes"""'}), "('ix_fiscal_notes_purchase_date', table_name='fiscal_notes')\n", (2518, 2578), False, 'from alembic import op\n'), ((2583, 2612), 'alembic.op.drop_table', 'op.drop_table', (['"""fiscal_notes"""'], {}), "('fiscal_notes')\n", (2596, 2612), False, 'from alembic import op\n'), ((2617, 2668), 'alembic.op.drop_index', 'op.drop_index', (['"""ix_users_email"""'], {'table_name': '"""users"""'}), "('ix_users_email', table_name='users')\n", (2630, 2668), False, 'from alembic import op\n'), ((2961, 2998), 'alembic.op.drop_column', 'op.drop_column', (['"""orders"""', '"""sale_type"""'], {}), "('orders', 'sale_type')\n", (2975, 2998), False, 'from alembic import op\n'), ((3422, 3491), 'alembic.op.create_index', 'op.create_index', (['"""ix_balance_type"""', '"""balance"""', "['type']"], {'unique': '(False)'}), "('ix_balance_type', 'balance', ['type'], unique=False)\n", (3437, 3491), False, 'from alembic import op\n'), ((3496, 3575), 'alembic.op.create_index', 'op.create_index', (['"""ix_balance_operation"""', '"""balance"""', "['operation']"], {'unique': '(False)'}), "('ix_balance_operation', 'balance', ['operation'], unique=False)\n", (3511, 3575), False, 'from alembic import op\n'), ((3580, 3616), 'alembic.op.drop_column', 'op.drop_column', (['"""clients"""', '"""address"""'], {}), "('clients', 'address')\n", (3594, 3616), False, 'from alembic import op\n'), ((3621, 3658), 'alembic.op.drop_column', 'op.drop_column', (['"""clients"""', '"""zip_code"""'], {}), "('clients', 'zip_code')\n", (3635, 3658), False, 'from alembic import op\n'), ((3983, 4023), 'alembic.op.drop_column', 'op.drop_column', (['"""order_details"""', '"""value"""'], {}), "('order_details', 'value')\n", (3997, 4023), False, 'from alembic import op\n'), ((4091, 4158), 'alembic.op.create_index', 'op.create_index', (['"""ix_users_email"""', '"""users"""', "['email']"], {'unique': '(False)'}), "('ix_users_email', 'users', ['email'], unique=False)\n", (4106, 4158), False, 'from alembic import op\n'), ((4939, 5041), 'alembic.op.create_index', 'op.create_index', (['"""ix_fiscal_notes_purchase_date"""', '"""fiscal_notes"""', "['purchase_date']"], {'unique': '(False)'}), "('ix_fiscal_notes_purchase_date', 'fiscal_notes', [\n    'purchase_date'], unique=False)\n", (4954, 5041), False, 'from alembic import op\n'), ((5041, 5132), 'alembic.op.create_index', 'op.create_index', (['"""ix_fiscal_notes_owner_id"""', '"""fiscal_notes"""', "['owner_id']"], {'unique': '(False)'}), "('ix_fiscal_notes_owner_id', 'fiscal_notes', ['owner_id'],\n    unique=False)\n", (5056, 5132), False, 'from alembic import op\n'), ((6370, 6493), 'alembic.op.create_index', 'op.create_index', (['"""ix_fiscal_note_items_sugested_sell_value"""', '"""fiscal_note_items"""', "['sugested_sell_value']"], {'unique': '(False)'}), "('ix_fiscal_note_items_sugested_sell_value',\n    'fiscal_note_items', ['sugested_sell_value'], unique=False)\n", (6385, 6493), False, 'from alembic import op\n'), ((6508, 6610), 'alembic.op.create_index', 'op.create_index', (['"""ix_fiscal_note_items_owner_id"""', '"""fiscal_note_items"""', "['owner_id']"], {'unique': '(False)'}), "('ix_fiscal_note_items_owner_id', 'fiscal_note_items', [\n    'owner_id'], unique=False)\n", (6523, 6610), False, 'from alembic import op\n'), ((6610, 6710), 'alembic.op.create_index', 'op.create_index', (['"""ix_fiscal_note_items_item_id"""', '"""fiscal_note_items"""', "['item_id']"], {'unique': '(False)'}), "('ix_fiscal_note_items_item_id', 'fiscal_note_items', [\n    'item_id'], unique=False)\n", (6625, 6710), False, 'from alembic import op\n'), ((6710, 6823), 'alembic.op.create_index', 'op.create_index', (['"""ix_fiscal_note_items_fiscal_note_id"""', '"""fiscal_note_items"""', "['fiscal_note_id']"], {'unique': '(False)'}), "('ix_fiscal_note_items_fiscal_note_id', 'fiscal_note_items',\n    ['fiscal_note_id'], unique=False)\n", (6725, 6823), False, 'from alembic import op\n'), ((705, 718), 'alembic.op.get_bind', 'op.get_bind', ([], {}), '()\n', (716, 718), False, 'from alembic import op\n'), ((2689, 2711), 'alembic.op.f', 'op.f', (['"""ix_users_email"""'], {}), "('ix_users_email')\n", (2693, 2711), False, 'from alembic import op\n'), ((4043, 4065), 'alembic.op.f', 'op.f', (['"""ix_users_email"""'], {}), "('ix_users_email')\n", (4047, 4065), False, 'from alembic import op\n'), ((4629, 4726), 'sqlalchemy.ForeignKeyConstraint', 'sa.ForeignKeyConstraint', (["['file_id']", "['files.bucket_key']"], {'name': '"""fiscal_notes_file_id_fkey"""'}), "(['file_id'], ['files.bucket_key'], name=\n    'fiscal_notes_file_id_fkey')\n", (4652, 4726), True, 'import sqlalchemy as sa\n'), ((4731, 4822), 'sqlalchemy.ForeignKeyConstraint', 'sa.ForeignKeyConstraint', (["['owner_id']", "['users.id']"], {'name': '"""fiscal_notes_owner_id_fkey"""'}), "(['owner_id'], ['users.id'], name=\n    'fiscal_notes_owner_id_fkey')\n", (4754, 4822), True, 'import sqlalchemy as sa\n'), ((4827, 4882), 'sqlalchemy.PrimaryKeyConstraint', 'sa.PrimaryKeyConstraint', (['"""id"""'], {'name': '"""fiscal_notes_pkey"""'}), "('id', name='fiscal_notes_pkey')\n", (4850, 4882), True, 'import sqlalchemy as sa\n'), ((5871, 5973), 'sqlalchemy.ForeignKeyConstraint', 'sa.ForeignKeyConstraint', (["['file_id']", "['files.bucket_key']"], {'name': '"""fiscal_note_items_file_id_fkey"""'}), "(['file_id'], ['files.bucket_key'], name=\n    'fiscal_note_items_file_id_fkey')\n", (5894, 5973), True, 'import sqlalchemy as sa\n'), ((5978, 6093), 'sqlalchemy.ForeignKeyConstraint', 'sa.ForeignKeyConstraint', (["['fiscal_note_id']", "['fiscal_notes.id']"], {'name': '"""fiscal_note_items_fiscal_note_id_fkey"""'}), "(['fiscal_note_id'], ['fiscal_notes.id'], name=\n    'fiscal_note_items_fiscal_note_id_fkey')\n", (6001, 6093), True, 'import sqlalchemy as sa\n'), ((6098, 6192), 'sqlalchemy.ForeignKeyConstraint', 'sa.ForeignKeyConstraint', (["['item_id']", "['items.id']"], {'name': '"""fiscal_note_items_item_id_fkey"""'}), "(['item_id'], ['items.id'], name=\n    'fiscal_note_items_item_id_fkey')\n", (6121, 6192), True, 'import sqlalchemy as sa\n'), ((6197, 6293), 'sqlalchemy.ForeignKeyConstraint', 'sa.ForeignKeyConstraint', (["['owner_id']", "['users.id']"], {'name': '"""fiscal_note_items_owner_id_fkey"""'}), "(['owner_id'], ['users.id'], name=\n    'fiscal_note_items_owner_id_fkey')\n", (6220, 6293), True, 'import sqlalchemy as sa\n'), ((6298, 6358), 'sqlalchemy.PrimaryKeyConstraint', 'sa.PrimaryKeyConstraint', (['"""id"""'], {'name': '"""fiscal_note_items_pkey"""'}), "('id', name='fiscal_note_items_pkey')\n", (6321, 6358), True, 'import sqlalchemy as sa\n'), ((813, 960), 'sqlalchemy.Enum', 'sa.Enum', (['"""SALE_IN_PIX"""', '"""SALE_IN_DEBT"""', '"""SALE_IN_CREDIT"""', '"""SALE_IN_MONEY"""', '"""SALE_IN_TRANSFER"""', '"""SALE_IN_BILLET"""', '"""SALE_OTHERS"""'], {'name': '"""saletype"""'}), "('SALE_IN_PIX', 'SALE_IN_DEBT', 'SALE_IN_CREDIT', 'SALE_IN_MONEY',\n    'SALE_IN_TRANSFER', 'SALE_IN_BILLET', 'SALE_OTHERS', name='saletype')\n", (820, 960), True, 'import sqlalchemy as sa\n'), ((1361, 1373), 'sqlalchemy.VARCHAR', 'sa.VARCHAR', ([], {}), '()\n', (1371, 1373), True, 'import sqlalchemy as sa\n'), ((1445, 1457), 'sqlalchemy.VARCHAR', 'sa.VARCHAR', ([], {}), '()\n', (1455, 1457), True, 'import sqlalchemy as sa\n'), ((1532, 1549), 'sqlalchemy.dialects.postgresql.UUID', 'postgresql.UUID', ([], {}), '()\n', (1547, 1549), False, 'from sqlalchemy.dialects import postgresql\n'), ((1624, 1641), 'sqlalchemy.dialects.postgresql.UUID', 'postgresql.UUID', ([], {}), '()\n', (1639, 1641), False, 'from sqlalchemy.dialects import postgresql\n'), ((1710, 1744), 'sqlmodel.sql.sqltypes.AutoString', 'sqlmodel.sql.sqltypes.AutoString', ([], {}), '()\n', (1742, 1744), False, 'import sqlmodel\n'), ((1812, 1846), 'sqlmodel.sql.sqltypes.AutoString', 'sqlmodel.sql.sqltypes.AutoString', ([], {}), '()\n', (1844, 1846), False, 'import sqlmodel\n'), ((1918, 1928), 'sqlalchemy.Float', 'sa.Float', ([], {}), '()\n', (1926, 1928), True, 'import sqlalchemy as sa\n'), ((2923, 2940), 'sqlalchemy.dialects.postgresql.UUID', 'postgresql.UUID', ([], {}), '()\n', (2938, 2940), False, 'from sqlalchemy.dialects import postgresql\n'), ((3056, 3073), 'sqlalchemy.dialects.postgresql.UUID', 'postgresql.UUID', ([], {}), '()\n', (3071, 3073), False, 'from sqlalchemy.dialects import postgresql\n'), ((3144, 3156), 'sqlalchemy.VARCHAR', 'sa.VARCHAR', ([], {}), '()\n', (3154, 3156), True, 'import sqlalchemy as sa\n'), ((3227, 3239), 'sqlalchemy.VARCHAR', 'sa.VARCHAR', ([], {}), '()\n', (3237, 3239), True, 'import sqlalchemy as sa\n'), ((3320, 3373), 'sqlalchemy.dialects.postgresql.ENUM', 'postgresql.ENUM', (['"""DEBT"""', '"""CREDIT"""'], {'name': '"""balancetype"""'}), "('DEBT', 'CREDIT', name='balancetype')\n", (3335, 3373), False, 'from sqlalchemy.dialects import postgresql\n'), ((3729, 3770), 'sqlalchemy.dialects.postgresql.DOUBLE_PRECISION', 'postgresql.DOUBLE_PRECISION', ([], {'precision': '(53)'}), '(precision=53)\n', (3756, 3770), False, 'from sqlalchemy.dialects import postgresql\n'), ((3892, 3933), 'sqlalchemy.dialects.postgresql.DOUBLE_PRECISION', 'postgresql.DOUBLE_PRECISION', ([], {'precision': '(53)'}), '(precision=53)\n', (3919, 3933), False, 'from sqlalchemy.dialects import postgresql\n'), ((4228, 4245), 'sqlalchemy.dialects.postgresql.UUID', 'postgresql.UUID', ([], {}), '()\n', (4243, 4245), False, 'from sqlalchemy.dialects import postgresql\n'), ((4318, 4330), 'sqlalchemy.VARCHAR', 'sa.VARCHAR', ([], {}), '()\n', (4328, 4330), True, 'import sqlalchemy as sa\n'), ((4405, 4414), 'sqlalchemy.DATE', 'sa.DATE', ([], {}), '()\n', (4412, 4414), True, 'import sqlalchemy as sa\n'), ((4484, 4501), 'sqlalchemy.dialects.postgresql.UUID', 'postgresql.UUID', ([], {}), '()\n', (4499, 4501), False, 'from sqlalchemy.dialects import postgresql\n'), ((4569, 4581), 'sqlalchemy.VARCHAR', 'sa.VARCHAR', ([], {}), '()\n', (4579, 4581), True, 'import sqlalchemy as sa\n'), ((5203, 5220), 'sqlalchemy.dialects.postgresql.UUID', 'postgresql.UUID', ([], {}), '()\n', (5218, 5220), False, 'from sqlalchemy.dialects import postgresql\n'), ((5291, 5332), 'sqlalchemy.dialects.postgresql.DOUBLE_PRECISION', 'postgresql.DOUBLE_PRECISION', ([], {'precision': '(53)'}), '(precision=53)\n', (5318, 5332), False, 'from sqlalchemy.dialects import postgresql\n'), ((5426, 5467), 'sqlalchemy.dialects.postgresql.DOUBLE_PRECISION', 'postgresql.DOUBLE_PRECISION', ([], {'precision': '(53)'}), '(precision=53)\n', (5453, 5467), False, 'from sqlalchemy.dialects import postgresql\n'), ((5546, 5563), 'sqlalchemy.dialects.postgresql.UUID', 'postgresql.UUID', ([], {}), '()\n', (5561, 5563), False, 'from sqlalchemy.dialects import postgresql\n'), ((5639, 5656), 'sqlalchemy.dialects.postgresql.UUID', 'postgresql.UUID', ([], {}), '()\n', (5654, 5656), False, 'from sqlalchemy.dialects import postgresql\n'), ((5725, 5742), 'sqlalchemy.dialects.postgresql.UUID', 'postgresql.UUID', ([], {}), '()\n', (5740, 5742), False, 'from sqlalchemy.dialects import postgresql\n'), ((5811, 5823), 'sqlalchemy.VARCHAR', 'sa.VARCHAR', ([], {}), '()\n', (5821, 5823), True, 'import sqlalchemy as sa\n')]