On 4/16/14 11:51 PM, Shoaib Ijaz wrote:
I don't want use SQL query in django
OK. You *could* have class B inherit from class A:
class B(A):
link = models.IntegerField(blank=True, null=True)
and then do your query on A:
ulist = A.objects.all()
hth
- Tom
On Thursday, 17 April 2014 04:39:09 UTC+5, Russell Keith-Magee wrote:
On Wed, Apr 16, 2014 at 9:30 PM, Shoaib Ijaz <[email protected]
<javascript:>> wrote:
> Sorry for duplicate post How to create Union
>
> I am using Django REST Framework in project and I want to create
union two
> different Models.
>
> My Models
>
> class A(models.Model):
> name = models.CharField(max_length=240, blank=True)
> geometry = models.GeometryField(blank=True, null=True)
> abwrapper= models.ForeignKey(ABWrapper)
>
> class Meta:
> db_table = 'tbl_a'
>
> class B(models.Model):
> name = models.CharField(max_length=240, blank=True)
> link = models.IntegerField(blank=True, null=True)
> geometry = models.GeometryField(blank=True, null=True)
> abwrapper= models.ForeignKey(ABWrapper)
>
> class Meta:
> db_table = 'tbl_b'
>
> I am trying to create this query
>
> SELECT id,name FROM tbl_a UNION (SELECT b.id
<http://b.id>,b.name <http://b.name> From tbl_b b)
>
> My attempt for union
>
> a = A.objects.values_list('id')
> b = B.objects.values_list('id')
> queryset = a | b
--
You received this message because you are subscribed to the Google Groups "Django
users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/534FE2D0.1080508%40gmail.com.
For more options, visit https://groups.google.com/d/optout.
