Django에서 view table 사용하기

django module django-db-views

pip install django-db-views 을 통해 모듈을 설치 뒤
models.py에 table을 선언할 때처럼 class를 만들어 준다.

class Test(DBView):  
  virtual_card = models.ForeignKey(  
      VirtualCard, on_delete=models.DO_NOTHING, related_name='virtual_cards'  
  )  
  total_discount = models.DecimalField(max_digits=12, decimal_places=2)  
  total_returns = models.DecimalField(max_digits=12, decimal_places=2)  
  balance = models.DecimalField(max_digits=12, decimal_places=2)  
  view_definition = """  
      SELECT  
          row_number() over () as id,  # Django requires column called id  
          virtual_card.id as virtual_card_id,  
          sum(...) as total_discount,  
      ...  
  """  
  class Meta:  
      managed = False  
      db_table = 'virtual_card_balance'  

참고 URL : https://pypi.org/project/django-db-views/