Guest User

Untitled

a guest
May 14th, 2018
121
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.86 KB | None | 0 0
  1. class Userinfo(models.Model):
  2.  
  3. useruid = models.BigAutoField(db_column='UserUID', primary_key=True)
  4.  
  5. useremail = models.CharField(
  6. db_column='UserEmail', unique=True, max_length=100)
  7. userpassword = models.CharField(db_column='UserPassword', max_length=128)
  8.  
  9. passwordsalt = models.CharField(db_column='PasswordSalt', max_length=128)
  10. userstatus = models.IntegerField(db_column='UserStatus', default=0)
  11. username = models.CharField(
  12. db_column='UserName', max_length=100, default=0)
  13. class Meta:
  14. managed = False
  15. db_table = 'userinfo'
  16.  
  17. class Postinfo(models.model):
  18. postuid = models.BigAutoField(db_column='PostUID', primary_key=True)
  19. content = content = models.TextField(db_column='Content')
  20. useruid = models.ForeignKey(
  21. Userinfo, db_column='UserUID', on_delete=models.CASCADE)
  22.  
  23. class Meta:
  24. managed = False
  25. db_table = 'postinfo'
  26.  
  27. postquery = models.Postinfo.objects.all().select_related("useruid").order_by(
  28. '-postuid')
  29.  
  30. <QuerySet [{'content': 'test','postuid': 1, 'useruid_id': 1},OtherPosts...>
  31.  
  32. userinfoquery = postquery.values("useruid_id__username","useruid_id__userstatus","useruid_id")
  33.  
  34. <QuerySet [{'useruid_id__username': 'firstuser','useruid_id__userstatus': 0, 'useruid_id': 1},OtherUsers...>
  35.  
  36. userinfoquery = postquery.values(
  37. useruid="useruid_id", username="useruid_id__username", userstatus="useruid_id__userstatus")
  38.  
  39. QuerySet.annotate() received non-expression(s): useruid_id, useruid_id__uesrname, useruid_id__userstatus.
  40.  
  41. from django.db.models import F
  42. userinfoquery = postquery.values(
  43. useruid=f("useruid_id"), username=F("useruid_id__username"), userstatus=F("useruid_id__userstatus"))
  44.  
  45. from django.db.models import F
  46.  
  47. Postinfo.objects.annotate(renamed_value=F('useruid_id__username')).values('renamed_value')
Add Comment
Please, Sign In to add comment