Handle database views. Allow to create migrations for database views. View migrations using django code. They can be reversed. Changes in model view definition are detected automatically. Support almost all options as regular makemigrations command
How to install?
pip install django-db-views
How to use?
makeviewmigrationscommand to create migrations for view models
How to create view in your database?
from django_db_views.db_view import DBView class Balance(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'
How view migrations work?
- It's using Django code, view-migrations looks like regular migrations.
- It relies on
makeviewmigrationscommand finds previous migration for view.
- if there is no such migration then script create a new migration
- if previous migration exists but no change in
view_definitionis detected nothing is done
- if previous migration exists, then script will use previous
view_definitionfor backward operation, and creates new migration.
Tested with live project based on Django 1.11.5
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
|Filename, size||File type||Python version||Upload date||Hashes|
|Filename, size django_db_views-0.0.6-py3-none-any.whl (7.1 kB)||File type Wheel||Python version py3||Upload date||Hashes View hashes|
|Filename, size django-db-views-0.0.6.tar.gz (5.5 kB)||File type Source||Python version None||Upload date||Hashes View hashes|
Hashes for django_db_views-0.0.6-py3-none-any.whl