"""reindex gin

Revision ID: b2c884664119
Revises: c7d4ba6e8971
Create Date: 2024-03-15 15:50:35.843237

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = 'b2c884664119'
down_revision = 'c7d4ba6e8971'
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    # fix db corrupted data on gin indexes
    conn = op.get_bind()
    # %% - escaping
    # for row in conn.execute(
    #         """select indexname from pg_indexes where indexdef like '%% gin %%' and indexname like 'ix_%%'"""
    # ):
    #     print('reindex', row[0])
    #     conn.execute(f'REINDEX INDEX "{row[0]}"')
    #     conn.execute("commit")
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    pass
    # ### end Alembic commands ###