manage.py: Don't format column names and aliases that are also SQL keywords

open-contracting / notebooks-ocds

A collection of notebooks for analysing OCDS data stored in Kingfisher.

BSD 3-Clause "New" or "Revised" License

3 stars 3 forks source link

manage.py: Don't format column names and aliases that are also SQL keywords #27

Closed duncandewhurst closed 1 year ago

duncandewhurst commented 3 years ago

For example:

'extension' in https://colab.research.google.com/github/open-contracting/kingfisher_notebook_components/blob/main/check_scope.ipynb#scrollTo=qFbWPY5Eq7fv&line=8&uniqifier=1
'language' in https://kingfisher-summarize.readthedocs.io/en/latest/database.html#release-summary

We can use this issue to collect any other examples and then update the commands in manage.py to use the --placeholder command-line option to keep them untouched.

jpmckinney commented 1 year ago

Easier to just not use SQL keywords, which I've done (ocds_extension, contract_implementation).