#django

No, it should never change.

Hello

How are you?

I have a question

I need compare date in django

but i don't know how I can do it

I need filter object with a month difference of today

how I can do it?

oh! Thanksyou! urth

refu: are you using a git checkout of Django?

if not, change 'dev' in that URL to the version you'r using... e.g. 1.4

mmm I am using 1.4

because I am installed Archlinux as principal OS

this OS always have the last version of almost softs

funkybob: just the man i was looking for, you always seem to know what you're talking about, may i ask you a legacy db question?

refu: wow, you're using a distro provided package? brave

smill: you overestimate my skills :)

ask away

mmm, i dont know, I install django for aur xD

OK, thanks!

refu: learn to love virtualenv :) then always pip install

funkybob: ok well basically i have a legacy db that has an items and sections table, then a third table called Section_Items that just has the section id and item ids to link them together, because each item can be in multiple sections

funkybob: relevant paste here http://dpaste.com/899084/

smill: so, it's a Many-to-many "through" table?

funkybob: that was my general impression but i can't for the life of me figure out how to set it up! i have read about manytomany things but it seems to be adding functionality and i'd have to manually go through and redo the "links" between the tables

ahhh yes! I listen about virtualenv

if i execute Person.objects.get(id=1) 10 times in a function, does it hit the DB 10 times?

or are the latter 9 times pulled from a cache?

smill: create a model for Section_Items, and set it as the 'through on a ManyToMany field on one of the models

skandocious: I'd hope it would hit it 10 times

FunkyBob: thats what i figured

FunkyBob: i'm doing a CSV dump function that resolves FK's before dumping

FunkyBob: and its resolving the same keys over and over...

FunkyBob: takes FOREVER

skandocious: yeah, that's why we made cache dicts...

FunkyBob: ooo whats what?!

you use one of those

I'm familiar with defaultdicts

and build it so accessing a missing key will get the object from the DB, _and_ store it in itself

then you have a transparently caching dict of objects :)

FunkyBob: ah well i already did something like that

hang on

you MUST remember to have your __missing__ method store the value back into itself

FunkyBob: http://dpaste.org/3DWxS/

FunkyBob: memoize :)

that's another option, sure

FunkyBob: same idea, right?

but more flexible, yeah... memoize can take more arguments

FunkyBob: yeah

of course, you'll probably find select_related would save you all [most of] those hits anyway

FunkyBob: will it?

won't that resolve all the foreign keys in 1 swoop?

it'll do it as part of the initial query

i don't necessarily want to resolve all of them… that might be expensive…

then tell it which ones you do know you want to reolve

plus if 2 tuples point to the same FK, that FK will get resolved twice

resolve

yes, but it's still JUST ONE QUERY

tuple1.select_related() // resolves FK

funkybob: I tried this http://dpaste.com/899096/ note the contained_items in the Sections model. it doesn't work tho, I hate to ask you to spell this out for me but I have been screwing with it for a couple hours and I can't get it

tuple2.select_related() // resolves same FK again

skandocious: huh?

skandocious: do it as part of your QuerySet

I have no idea what tuple1 and tuple2 are supposed to be there

FunkyBob: ohhh the original objects.all() call

by tuple i mean row/model-object

FunkyBob: but yeah i get what you're saying now

MyModel.objects.select_related() ...

FunkyBob: gotcha

smill: I see the problem.. you haven't expressed the relations

funkybob: do I need to put in ForeignKey things?

fortunately, your schema follows django's field naming :)

also, no need to define an Integer primary key whose name is 'id'

though you may want to ensure it's using .... whatever implementation of PK sequence generation your DBMS uses

funkybob: ok, thanks, that makes sense. however i'm still getting the same error "'Sections" object has no attribute 'contained_items_set'"

that's because it doesn't

you called the m2m "contained_items"

the '_set' suffix is only used for _auto-generated_ reverse references

so, for your case, Items will have a sections_set property

I currently have a view which returns: return render_to_response('login.html',{'state':state, 'username':username}). I have created a csrf_token in this view and I need render_to_response to return this as well.. How do I change the return statement?

Amitash: firstly, you will finde life easier [especially hwne using csrf] to use render, not render_to_response

funkybob: I tried section.itemlist = Items.sections_set.all() and it says "'ManyRelatedObjectsDescriptor' object has no attribute 'all'" :(

Hi there, I'm using django boilerplate, in a medium sized project, its time to start tryals with DEBUG = False, but I'm getting a mysterious 500 error each time I set the flag to false

Amitash: the reason is render() will use a RequestContext

Amitash: [and there's less typing :)]

odarbelaeze: have you written a 404 template?

I there any way to figure out what is happening, the only thing I'm getting is "GET / HTTP/1.1" 500 27?

FunkyBob: I keep getting the csrf token error.. I am trying step 3, sub step 2 of the django docs: https://docs.djangoproject.com/en/dev/ref/contr...

Amitash: Are you using a git checkout of Django?

Amitash: I'm betting you're not...

FunkyBob: yep, or I'm too fool trying to set the flag to false with the development server?

FunkyBob: Nope

Amitash: then stop using the dev docs...

Amitash: change 'dev' in that url to '1.4'

odarbelaeze: no, you're not

FunkyBob: No difference in the docs :)

Amitash: no, but there could have been

FunkyBob: So should I use the HttpResponse instead of render_to_response?

Amitash: meanshilw... you need to pass the csrf token in the context so you can use it

Amitash: WTF? where did anyone suggest that?

render_to_resposne creates a HttpResponse For you

FunkyBob: Sorry.. I have only used Httpresponse before.. Am very new to django..

Amitash: and you've done the tutorial?

the 4-part one in the docs?

FunkyBob: I was following another book actually..

/////////////////////////////////////////////////////////////////////w 3

grrr

sorry