django-admin model validation mistake

[Nick Meharry]

In one of my models I have a field that would be logically be called class, but because it is a reserved word, I renamed the field to class_ (notice the trailing underscore). I also set the db_column kwarg to class. I then run ./manage.py sql tracker, and get this error:

    Error: One or more models did not validate:
    tracker.assignment: "class_": Field names cannot end with underscores, because this would lead to ambiguous queryset filters.

However, when I set the model name to klass, the output shows it recognizes the db_column setting. It seems that the validator should check for that setting before emitting an error. Is there a work around I should use for now? I'd rather not spell "class" with a "k".

System Info:

• Ubuntu 9.04
• Django 1.0.2

-- Nick

[James Bennett]

Field names ending with underscores are invalid regardless of db_column, because the Python-level query API separates field names/joins/lookup types with underscores; as the error message tells you, ending a field name in an underscore would lead to ambiguity in parsing the Python-level field lookups.

[Nick Meharry]

I feel like an idiot now for not realizing that. I suppose that's what I get for filing a bug report late at night.