Legacy Database "%" escaping not documented
|Reported by:||Greg||Owned by:||nobody|
|Component:||Core (Management commands)||Version:||1.0|
|Severity:||Normal||Keywords:||legacy, models.py inspectdb|
|Has patch:||no||Needs documentation:||no|
|Needs tests:||no||Patch needs improvement:||no|
While creating a model for a legacy database using inspectdb, I was not able to retrieve data from a column where db_column referenced a field with a % i.e. Discount%. Eventually, through the help here http://groups.google.com/group/django-users/browse_thread/thread/162a4e857d15248c I learned that it is necessary to escape the % with a %%, which makes sense overall, but was not obvious in the context of the model design.
The need to escape the % with %% is not documented as far as I can tell and should either be automatic with inspectdb or included in the Integrating Django with a legacy database documentation (I leaning towards the latter). Other such non-obvious (at least for relatively new python and django users) aspects of dealing with a legacy database should also be documented more clearly, perhaps in a Things To Look Out For section for example.