Thanks Malcom, very enlightening.
I would be very interested in learning how/where to go about
reconstructing the queryset.
Tom
Here is the relevant section of my model:
########################################################
class TaskManager(models.Manager):
def get_query_set(self):
cursor = connection.cursor()
cursor.execute("SELECT * FROM projects_task WHERE done=0 GROUP
BY project_id;")
idents = [item[0] for item in cursor.fetchall()]
cursor.close()
connection.close()
return super(NextActionsManager,
self).get_query_set().filter(id__in = idents)
class Task(models.Model):
project = models.ForeignKey(Project, edit_inline=models.TABULAR,
num_in_admin=5)
task = models.CharField(maxlength=100, core=True)
action_order = models.IntegerField(core=True)
done = models.BooleanField('done', core=True)
time_modified = models.DateTimeField(auto_now=True)
objects = models.Manager()
tasks = TaskManager()
def __str__(self):
return self.action
########################################################
and the urls.py
list_dict = {
'queryset': Task.tasks.all(),
'template_name': "projects/task_list.html",
}
edit_dict = {
'model': Task,
'post_save_redirect': "/gtd/tasks/",
}
urlpatterns = patterns('',
(r'^$', 'django.views.generic.list_detail.object_list',
list_dict),
(r'^edit/(?P<object_id>\d+)/$',
'django.views.generic.create_update.update_object', edit_dict),
(r'^add/$', 'django.views.generic.create_update.create_object',
edit_dict),
)
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/django-users
-~----------~----~----~----~------~----~------~--~---
