Я хочу сравнить две таблицы Column (Table1 - Balance_sheet, Table2- Account_list) (Column-split,column-account) и получить похожие данные в django

class Balance_Sheet(models.Model): #имя таблицы

# date = models.DateField() # Name of the column
# transaction_type = models.CharField(max_length=100,blank=False)
# num = models.IntegerField()
name = models.CharField(max_length=100,blank=True)
# description = models.CharField(max_length=100,blank=True)
split = models.CharField(max_length=100,blank=False)


# class Meta:
#     abstract : True

class Account_List(models.Model):
account = models.CharField(max_length=100,blank=True,null=True)
type = models.CharField(max_length=100,blank=True, null=True)
split =models.ForeignKey(Balance_Sheet,null=False, default=True,on_delete=models.CASCADE)

def str(self): return 'Account : {0} Type : {1} '.format(self.account,self.type)

def DisplayUVL(request):

# Excel page changes
Ven_list = Balance_Sheet.objects.filter(account_list__isnull=True).values_list('split', flat=True)
print("SQL Query:",Ven_list.query)
context = {
    'items': Ven_list
    # 'header': 'Vendor List'
   
}
return render(request, 'services2.html', context)

Вернуться на верх