#django

but it doesn't seem to be working

being nothing, I hope?

critias: Also Python (speclially 3), django and mysql doesn't always getalong.

jtiai: oh really?

after mysql, do i have a long learning curve?

critias: not ime

I'll look into it. thnx

hmmm, accessing model data passed to my template seems to hit the DB again?

is that normal?

critias: (particularly not from a Django perspective; I've had Django projects using MySQL that I never realised were)

d1rkp1tt: yes

d1rkp1tt: are you trying to optimise for number of db accesses, and if so why?

doismellburning, Confused by this, as I already query in my view.

d1rkp1tt: I doubt you do; I suspect you just build up a queryset, and querysets are lazy

doismellburning, What started me down this path was that I was doing a for loop through records and hitting the db again with the django-voting app results... so I thought... I already have that data... why hit it again

THEN

d1rkp1tt: code please

view, or template

d1rkp1tt: shrug

so queryset is not run in the template

d1rkp1tt: "I was doing a for loop through records and hitting the db again with the django-voting app results" - wherever you were doing that

view side I mean

d1rkp1tt: querysets are lazy

so they are run when the template is crafted?

I use a RAW query though!

d1rkp1tt: querysets are lazy; queries will run when they are evaluated (i.e. "when needed", to an approximation)

and a "RAQ query" is?

*W

and I thought that I mapped results to my model from a RAW query using 'AS' to define the correct fieldname

oh, you just mean using `raw`?

yeah

ooooh, I think its probably being clever

which returns a queryset

I dont pull back a few fields

and for the third and final time: querysets are lazy

it must go and get the ones I am not pulling back

I dont know what lazy is

will read up

(actually, I don't know that about RQS, but since you're experiencing that behaviour, I see no reason to assume otherwise yet)

d1rkp1tt: https://en.wikipedia.org/wiki/Lazy_loading

Thanks

seems like I should try and optimize the hits

d1rkp1tt: why?

small VPS

...

d1rkp1tt: noting that premature optimisation is approximately a terrible idea

d1rkp1tt: have you measured? is this your bottleneck? (I suspect the answer to the first is no)

Theres different degrees of pre optimisation

hey guys. What is the best practice of serving static assets when I have multiple django servers behind a load balancer?

sometimes doing zero is madness

(if it is, and the second is "yes", I'm slightly surprised)

pxu: approximately it's irrelevant, the thing to do is "use something else"

pxu: i.e. Django should not be serving your static assets, $somethingelse should be, which will depend on your setup

pxu: (I use S3 a lot, and also nginx)

currently the load balancer (nginx) is serving the static assets

pxu: sounds sensible

so I managed to cut out about 30 queries per page request...

For each record in my list, it was re-querying for fields that werent accounted for in my query

I can't find this in documentation, how do I print the current VALUE of a form field ? I'm getting "CharField instance at blahblahblah"

This is for debug purposes. A form is failing validation because of a hidden field.

I have moved my django project from mac to windows, Now i get 'Not a Directory error at / ' here is my settings.py. https://gist.github.com/anonymous/0b6fb8425cd22.... How can i solve it. ? also, trying to 'collectstatic' path is c:/static instead of c:/proman(project_name)/static ...

I tried getting it from cleaned_data, but there's a KeyError.

rabbi1: at a guess you moved the virtualenv too?

rabbi1: and/or you hardcoded some paths in settings

STATIC_ROOT = '/static/'

form['fieldname'] will get you the boundfield

that is so very wrong, rabbi1

hardcoded the paths

no, storing static at /

rabbi1: also what FunkyBob said

this is my path for static /project_name/static/css ...

rabbi1: then it sounds like you want `os.path.join(BASE_DIR, '..', 'static')`

rabbi1: er, possibly without the ..; ymmv

yeap, BASE_DIR is set and also os.path.join

the whole concept of moving _to_ windows is scary, imho

line 112

FunkyBob: well indeed

rabbi1: I think you misunderstand me; I was talking about the value of `STATIC_ROOT` (though now I reread what you've said, I think you're confusing STATIC_ROOT with STATICFILES_DIRS)

i tried to set path here like STATIC_PATH = os.path.join(BASE_DIR, 'proman/static')

but din't work

kezabelle: Thank you.

rabbi1: multiple things not to do there

rabbi1: os.path.join takes arbitraryish numbers of arguments; don't `proman/static`, those are two arguments; doing it like that defeats much of the point

rabbi1: don't hardcode your project name in the path like that

STATIC_URL = '/static/'

STATIC_ROOT = '/'

STATIC_PATH = os.path.join(BASE_DIR, 'static')

STATICFILES_DIRS = ( STATIC_PATH, )

rabbi1: don't paste code into here

this is what i got now ^^

rabbi1: don't have / as STATIC_ROOT

In that case why BASE_DIR = os.path.dirname(os.path.dirname(__file__)) is directing to right project path ?

BASE_DIR should be atleast c:/project_name/

os.path is ok, but .dirname is what it is missing to get

rabbi1: I'm afraid I don't understand your question

doismellburning: to start: moving project from mac to windows i get 'Not a Directory error at / ' this error

rabbi1: yes, this is probably to do with your multiple hardcoded directory separators

rabbi1: as above, stop doing that, use os.path.join more

doismellburning: I think that forward slash is guaranteed to work across platforms in paths...

doismellburning: that case, i have to make change only at one place STATIC_URL = 'os.path' and change STATIC_ROOT = ''