CODEWITHSUNDEEP
pythonsqlalchemymigration
Eric Baldwin
Eric Baldwin

Reputation: 3501

Drop and read index using SQLAlchemy

I want to do a bulk insertion in SQL alchemy and would prefer to remove an index prior to making the insertion, reading it when the insertion is complete.

I see adding and removing indexes is supported by Alembic for migrations, but is this possible with SQLAlchemy? If so, how?

Upvotes: 3

Views: 2919

Answers (2)

Ben
Ben

Reputation: 5228

So, I've been struggling with this. It seems that SQLAlchemy (v1.4 with the v2.0 compatibility routines running) drops the physical index but, at least in my case, doesn't update its metadata to reflect that. The following code seems to get over that issue...

ndx_to_drop.drop()
# SQLAlchemy drops the index but doesn't update our index metadata, requiring the following
loc_indexes = tbl.indexes.copy()
loc_indexes = {loc_ndx for loc_ndx in loc_indexes if loc_ndx.name !=ndx_to_drop.name}
tbl.indexes = loc_indexes

Upvotes: 0

Eric Baldwin
Eric Baldwin

Reputation: 3501

The best method is to just execute sql. In this casesession.execute("DROP INDEX ...")

Upvotes: 2

Related Questions