On Sat, 2009-08-08 at 07:26 -0700, Lokesh wrote:
> Hi,
>
> Need help in generating the sql query i.e generated by django at
> runtime from ORM
>
> from django.contrib.auth.models import User
> class UserBasicDetails(models.Model):
> user_id = models.OneToOneField(User, primary_key=True,
> to_field='username')
> name = models.CharField(null=False, blank=False, max_length=30)
>
> qs = UserBasicDetails.objects.get
> (user_id__email__exact='exam...@djano.com')
>
>
> I got the below search result qs.query.as_sql()
> but, this will generate sql for only for result sets (filter) and not
> for a single record/value (get) (UserBasicDetails.objects.filter
> (user_id__email__exact='exam...@djano.com'))
A get() call is a filter() call with only the first element extracted
(if more than one element is returned, it's an error). So just look at
the SQL for the equivalent filter() call.
Regards,
Malcolm
--~--~-~--~~~---~--~~
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
django-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en
-~--~~~~--~~--~--~---