sqlalchemy / sqlalchemy/alembic
Support sorting and expression index reflection on oracle
Open
Nobody has claimed this yet.
autogenerate - detection
index expressions
oracle
use case
- Dominant language
- Python
- Stars
- 4.4k
- Forks
- 375
- PR merge metrics
- No merged PRs in 30d
Description
Since https://github.com/sqlalchemy/sqlalchemy/issues/9597 added support for oracle reflection of function indexes and sorting, it would make sense so support them also in alembic.
The functionality should be the same as what was implemented for postgresql
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by reading SQLAlchemy issue 9597 and comparing the existing PostgreSQL implementation in Alembic. Add equivalent Oracle support for sorting and expression index reflection, then verify that Oracle behavior matches the PostgreSQL functionality described in the issue.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- python, sql, sqlalchemy
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100