Hallo - i'm kind of newbie in django, but actually like it very much.
I need to make a search panel in web site where users could search
worker by name, city etc, and by working time and day. I would like to
make this panel using django db-api, not raw sql.
Here are two models.
--------------------------------------------------------------------------------------------------
class worker(models.Model):
name = models.CharField(max_length=100,blank=True)
city = models.CharField(max_length=100,blank=True)
address = models.CharField(max_length=100,blank=True)
notes = models.TextField(blank=True)
class WorkingDay(models.Model):
day = models.ForeignKey(Notary)
worker = models.ForeignKey(Notary)
wrk_from = models.TimeField(blank=True,null=True)
wrk_to = models.TimeField(blank=True,null=True)
--------------------------------------------------------------------------------------------------
I made search function, and while I tried to search by the field of
first model it worked quite well. Now I'm stock with the search by
workingdays.
--------------------------------------------------------------------------------------------------
worker_list = worker.objects.filter(**notary).extra(
select = {
'found_wrk_days': 'SELECT COUNT(*) FROM worker_WorkingDay
WHERE worker_WorkingDay.worker_id = worker_worker.id etc blabla ... ',
},
where=['found_wrk_days > %s'],
params=[0,]
)
--------------------------------------------------------------------------------------------------
Any help (or just link to rtfm subject :) will be appreciated. Thanx
in advance.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
