#django

though, should be easy to do this w/o all this extra stuff and figure it out

aye

hello to all

how can i detect empty queryset before add aggregate function to this queryset ?

unless it's the none() queryset, you won't know it's empty without executing it

FunkyBob, i execute it and got a error: ProgrammingError at /task/hours/

syntax error at or near ")"

LINE 1: SELECT SUM("subquery"."hours_spent") FROM () subquery

i try to add aggregate function to queryset like this

queryset.aggregate(hours_spent_total=Sum('hours_spent'))

and because after execute query set this queryset is null, aggragate functon can't execute

how about you dpaste the code + traceback?

FunkyBob, http://dpaste.com/3J31R4A

and the code?

FunkyBob, http://dpaste.com/147RTMF

code fail when execute block self.request.GET['look'] == 'today':

and this self.hours_spent_total_all = queryset.aggregate(

hours_spent_total=Sum('hours_spent'))['hours_spent_total']

hi

i got a question: is it possible to set a field as multi-values, each value comes from foreign key to another table?

FunkyBob: sorry I see you answered my question a while back and it's not exactly what I'm looking for. let me explain my problem and maybe you can better help me

I have a form that allows the user to add their rental history. I want them to be able to add as many previous rentals as they like. To do this, I want to create a template that I can render on the page every time the user clicks "add rental"...

nozavroni: sounds like you want a formset

yes

thats exactly what I want

but I'm having trouble executing it

I want it to show only one form but have a button they can click to add additional forms as they need them

but in order to do this, I either have to pull the form into the page via ajax, or render additional forms and just hide them until the user clicks the button

but neither is proving to be particularly easy

because once the user clicks "submit", if there is an error, I have to have code to show the additional forms on subsequent renderings

and no matter what I've tried the code just gets too ugly and complex for such a simple problem

yelloo

dodo

nozavroni: you don't need ajax to pull the blank form... just look at how admin does it

but you will need JS

the formset provides you an empty form instance to use as a template

the formset has rendered three empty forms on the page

so tell it not to

tell it you only want one

I have.

but then how do I get additional ones?

after the page is already rendered?

this is where my previous question came from

as I said, look at how Admin does it

your previous question didn't appear to have _anything_ to do with forms or formsets

lol I realize that I'm doing a poor job of asking my questions

and you have been very helpful

Anyone feel like helping me understand why sdist won't build a package that includes a template folder? Feel I've tried all the 'include_package_data=True' type permatations and manifest options but to no avail..

aiui Admin renderes a hidden blank form to use as a template for adding new forms to the set on the fly

to look at how admin does it, do I just look in django.contrib.admin?

nozavroni: well, you'd have to look at admin's JS

ok I'll try that. thanks a bunch

bee_keeper: this is how I did it - https://github.com/funkybob/formulation/blob/ma...

FunkyBob: I suppose that's one slightly different permatation i could try. I'll give it a go

permutation

FunkyBob: I suspected that was the case..

hrm.. does somebody have an opinion on swampdragon? just looking through the docs, and it looks interesting

FunkyBob: are you referring to the popups in the admin?

in the admin, if I want to add a related model, there's a little plus sign that pops up a window to add that model

but I would prefer not to use popups

I'm having a hard time figuring out where to look in the admin

no,I'm referring to inlines in admin

don't they show them in the tutorial any more?

FunkyBob: sdist still not including templates..the repo is here - https://github.com/bee-keeper/django-invitations - would you mind taking a look if you get chance please? I'm out of ideas..

hmm maybe ill look

but as for that empty_form thing, it doesn't really provide much information about it. just that one paragraph. I can't figure out how to use it

ugh im lost

when I call empty_form() I get "'property' object is not callable"

oh nevermind I got it to work... I think I can figure this out now

am I just supposed to replace __prefix__ with a number via javascript?

as I said.. look at what admin's JS does for inlines

or wait until nlh logs on

is it possible to define a fallback language other than the default language? I have a site with a large german codebase and 100% EN translations. I'd like to fallback to EN if no translations are available for e.g. ES and not to DE.

I've been poking around in the admin without much luck but ill keep trying