Django project design question

Question

Hi, I have just started to work on a django project( and learn django at the same time) and I came across some design questions that I can't really answer with my limited knowledge so I decided to ask it here. anyway Here is the questions: 1) where would you put raw queries. is it ok to put row queries in view.py files? My personal opinion is to put them only in models.py files. 2) where can you query db? can you call query methods in models.py, views.py, templates? I think they should be in models.py or views.py but not in templates. specifically calls like "MyModel__attribute_set__all" should not be used in templates.

Since I am new in django (and python) I am not really sure if I have the right idea about this. I appreciate for any feedback.

Answer 1

Sounds like you're on a good path already.

I try to:

• Keep my views slim, in terms of code, and my models fat
• keep my templates even slimmer and free of database lookups; if I have to do something that hits the DB that for some reason isn't viable to do in the view, I do it via a templatetag or filter so that it can improved and/or cached, and is also easy to find, and is as DRY as a can be
• define and execute any raw SQL in the models that use it

Answer 2

where would you put raw queries. is it ok to put row queries in view.py files?

Queries are most commonly seen in the view.py; yes it's ok there.

My personal opinion is to put them only in models.py files.

If you're using the same query a lot then create a "manager" for the model. You'll put the very commonly used querys there. "Only" in there would be making life hard for yourself.

where can you query db?

Usually in views.py; not uncommonly in models.py.

can you call query methods in ... templates?

Technically it is possible but, logically, very strongly discouraged.

I think they should be in models.py or views.py but not in templates

I agree.