#django

but shouldnt I do a sync all then fake migrate?

no

oh ...

you should do a "syncdb --migrate"

however, doesn't eplain the missing table... UNLESS

did you switch to a custom user model part-way through the project?

no

so an existing project put on a new server you dont do python manage.py syncdb?

sure you do... to create all the tables not managed by South

yep, thats where it’s failing

“FunkyBob: it’s a new server, pulled code from git, version 1.6.5” ….. im setting up a new server with exisitng project. and running syncb I’m getting the error I originally pasted

and when you tried "manage.py syncdb --migrate" ?

any ideas why this is giving me a syntax error

(python not django)

player_id = request.user.player.id if player_id is None

FunkyBob: Create the database tables for all apps in INSTALLED_APPS whose tables haven't already been created.

limbera: no else clause?

limbera: this isn't Perl, you know :)

ahh can you not use that shorthand for plain if

has to be else if

:P i actually learned perl as my 2nd programming language

old habits die hard

"foo = a if b else c" is valid

I do agree it's a convenient syntax...

so i just have an aempty else clause

limbera: just do it as two lines... "if player_id is None: player_id = request.user.player_id"

yeah

that's what i had and i tried to refactor it to be more pyhtonic :P

all the code examples i see online of django love the old one-liner

nah

clearer is better

the one-liner is ok if you have an else clause

cool cool

could anyone "code review" this snippet, more for style and what not

FunkyBob: any other thoughts?

getting the django way slowly i hope! initially i ahd like 6 dictionaries in their to achieve the same thing :P

nownot: did you try what I suggested?

limbera: that's quite a few queries for one value

isn't it 2 queries?

ping Player and ping Performance table?

why 2 when you can do 1?

i seee! thank you

sorry about that, my computer likes to disconnect from the router from time to time

ahh actually

i think i remember trying that, and it cant roder by date

scratch that, it worked thanks again!

FunkyBob: alright boss, any other thoughts? i have no clue what to look for, I’ve never had syncdb fail on a fresh server

nownot: am still waiting to hear if you tried anything I suggested

FunkyBob i remember a while back when you were talking about your django restful package that you said "i should probably imelement CBVs in there"

nownot: did you try "manage.py syncdb --migrate" ?

does that mean you don't use the CBVs yourself?

limbera: not anything based on the CBV that ship with Django, no

yes, and I posted the response. Create the database tables for all apps in INSTALLED_APPS whose tables haven't already been created.

so... it should be good to go, then?

no, if I try syncb I get error tables dont exist, which is what syncb is supposed to do

nownot: What is the error you see?

hello all, i have a question. Lets imagine i want to build a view of my store products based on ListView. I want to make the urls as pretty as possible so i want a few query get parameters to appear as part of the url path. There are a few combinations of them. category, category/page, category/sortmethod/order/page, category/subcategory, category/subcategory/page/, category/subcategory/sort_method/order/page. anyone thinks of a way i can do it in a

clean way in urls.py?

django_lover: firstly, stop writing such long lines in IRC...

FunkyBob: https://gist.github.com/anonymous/70c59b45b0226...

django_lover: move page and sort to querystrings

nownot: That's because you are doing a for user in User.objects.all() in your models.py

nownot: Don't have code like that at the module level.

django_lover: so it's /category/subcategory/?page=N&order=M

holy shitballs …

FunkyBob: thanks

nownot: dpaste your api/models.py

i focused on the last line, and didnt see that

I know where the error is

thanks

schinckel: oh, sure, it's easy when they do the right thing and paste the traceback! :P

Yep.

FunkyBob: if you want to help me a bit more, https://gist.github.com/anonymous/f7cc00aa7d4ef..., how would I put that in a if table && users exist

FunkyBob, I guess a so long message looks like spam. Didn't notice :).

django_lover: more that it looks like "wall of text"... and is harder to read

also, a lot of irc clients will jsut truncate long lines

FunkyBob, I guess I need to learn a bit more about IRC usage

morning, elbaschid

rough weekend?

morning FunkyBob

haha, no not a rough weekend

just distracted by work for the first half of the day

poor excuse for neglecting your friends :P

FunkyBob: absolutely true

I should stop doing that

FunkyBob, I thought i could look for the sort/order template context variables and call the correct url tag from a custom template tag. do you think it is possible and how good is this design?

django_lover: huh?

why are you putting that work in the template? why not in the view?

another question of style

i have quite a few (about 20-30) aggregate functions defined in my model

i have a page that makes use of all 20 of these values

in my view i currently have a function that is called those model functions and storing each of the values in context {} and sending that to the template

would it be better to have the model create a single summary value that does all the ahrd work, and then the view just calls "get_summary()" or something like that

probably... can those aggregate functions be called in the same query?

here is a subset of them

i don't understand what that means FunkyBob

so "yes"

also, stop using tabs in your source

ok!

ahhhh thank you!

i'll group them now into smaller groups

maybe 5 or so aggregates in a dictionary

It may be best just to do all the aggregates in the one query: I think postgres is pretty good about only iterating over rows once. You would want to check that though.

If it's only 10% worse to do all 20 aggregates in one query than just 5, it's still a win whenever you need to do aggregates from multiple groups.

ah yep makes sense, thanks schnikel