Opened 8 years ago

Closed 8 years ago

Last modified 6 years ago

#27098 closed Cleanup/optimization (fixed)

Deprecate DatabaseIntrospection.get_indexes

Reported by: Claude Paroz Owned by: nobody
Component: Database layer (models, ORM) Version: dev
Severity: Normal Keywords: introspection db-indexes
Cc: Triage Stage: Ready for checkin
Has patch: yes Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no

Description

DatabaseIntrospection.get_indexes outputs a subset of DatabaseIntrospection.get_constraints, however only for single-column indexes. The use case was mainly for inspectdb primary key and unique detections, and for some tests. Now that multicolumn indexes is in sight, that API is less appealing and appears unnecessary (see also ticket:16220#comment:19).

Change History (10)

comment:1 by Claude Paroz, 8 years ago

Has patch: set
Patch needs improvement: set

​WIP PR

comment:2 by Akshesh Doshi, 8 years ago

Keywords: introspection db-indexes added
Triage Stage: Unreviewed → Accepted

comment:3 by Tim Graham <timograham@…>, 8 years ago

In 4c7bf83c:

Refs #27097, #27098 -- Moved PostgreSQL index type introspection to get_constraints().

comment:4 by Claude Paroz, 8 years ago

Patch needs improvement: unset

comment:5 by Tim Graham, 8 years ago

Triage Stage: Accepted → Ready for checkin

comment:6 by Claude Paroz <claude@…>, 8 years ago

Resolution: → fixed
Status: new → closed

In d3891256:

Fixed #27098 -- Deprecated DatabaseIntrospection.get_indexes

Thanks Akshesh <aksheshdoshi@…> for help with the PostgreSQL query.
Thanks Tim Graham for the review.

comment:7 by Claude Paroz <claude@…>, 8 years ago

In a1ad896:

Refs #27098 -- Added introspection for expression-based index on PostgreSQL

Also test it on PostGIS raster fields.

comment:8 by Tim Graham <timograham@…>, 7 years ago

In 578711c3:

Refs #27098 -- Removed DatabaseIntrospection.get_indexes() per deprecation timeline.

comment:9 by Mariusz Felisiak <felisiak.mariusz@…>, 6 years ago

In e01fa015:

Refs #27098 -- Removed unused introspection queries.

Unused since 578711c31052625cc87319cf1c46662c14d75ce9.

Thanks Ian Foote for finding this.

comment:10 by Mariusz Felisiak <felisiak.mariusz@…>, 6 years ago

In 40d87681:

[2.1.x] Refs #27098 -- Removed unused introspection queries.

Unused since 578711c31052625cc87319cf1c46662c14d75ce9.

Thanks Ian Foote for finding this.
Backport of e01fa015c0fca32bb740b575c8fbfd388d8f4957 from master

Note: See TracTickets for help on using tickets.
Back to Top