On Jan 30, 1:33 pm, Thomas Guettler <[EMAIL PROTECTED]> wrote:
> > def markable(checkins, project_category):
> > projects = project_category.projects.all()
> > res = []
> > for day in checkins.group_dates():
> > for ci in day: # for every checkin that day
> > if ci.project in projects: # <-- HERE
> > res.append(day.date)
> > break
> > return res
>
> Just a guess. Try this:
> projects = list(project_category.projects.all())
>
> or this:
> projects = project_category.projects.all()[:]
>
> Please report if this fetches all at once.
It does, but it is the other side of the test that is problematic:
for ci in day:
if ci.project in projects:
calls the database to fetch each ci.project no matter how I get the
Checkin (ci) from the database...
> Thomas Güttler
I've worked around the problem by dropping to sql
select year(start_work), month(start_work),
dayofmonth(start_work), count(*)
from tt_checkin
where who_id = %d and project_id in (%s)
group by year(start_work), month(start_work),
dayofmonth(start_work)
but it would still be nice to know what I did wrong...
-- bjorn
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-users@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---
