Skip to content
This repository has been archived by the owner on Jan 4, 2023. It is now read-only.

Handle case sensitivity of table and column names #670

Open
simonvadee opened this issue Oct 12, 2021 · 0 comments
Open

Handle case sensitivity of table and column names #670

simonvadee opened this issue Oct 12, 2021 · 0 comments

Comments

@simonvadee
Copy link
Contributor

Description

We have an issue when introspecting the schema using sqlAlchemy (reflection sometimes uses case sensitive or insensitive). Until now we chose to handle everything as lowercase but this makes the code ugly (see database_explorer.py for instance)

See this discussion: https://arkhn.slack.com/archives/G01B1NZC7JQ/p1634036258002900

Additional context

related doc:

https://docs.sqlalchemy.org/en/14/dialects/oracle.html#identifier-casing
https://docs.sqlalchemy.org/en/14/core/metadata.html?highlight=table%20name#sqlalchemy.schema.Table

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant