Metadata-Version: 2.1
Name: django-database-view
Version: 0.3.0
Summary: A simple Django app to handle database views.
Home-page: https://github.com/manuelnaranjo/django-database-view
Author: Manuel F. Naranjo
Author-email: naranjo.manuel@gmail.com
License: MIT
Platform: UNKNOWN
Classifier: Environment :: Web Environment
Classifier: Framework :: Django
Classifier: Intended Audience :: Developers
Classifier: License :: OSI Approved :: MIT License
Classifier: Operating System :: OS Independent
Classifier: Programming Language :: Python
Classifier: Programming Language :: Python :: 2
Classifier: Programming Language :: Python :: 2.7
Classifier: Programming Language :: Python :: 3
Classifier: Programming Language :: Python :: 3.2
Classifier: Programming Language :: Python :: 3.3
Classifier: Programming Language :: Python :: 3.4
Classifier: Programming Language :: Python :: 3.5
Classifier: Programming Language :: Python :: 3.6
Classifier: Programming Language :: Python :: 3.7
Classifier: Programming Language :: Python :: 3.8
Classifier: Topic :: Internet :: WWW/HTTP
Classifier: Topic :: Internet :: WWW/HTTP :: Dynamic Content

####################
django-database-view
####################

A simple pluggable application that allows to work with database views.

Quick start
===========

1. Install the package::

    pip install django-database-view

2. In your ``models.py`` create classes which extend ``dbview.models.DbView``
   like this:

   .. code-block:: python

      from django.db import models
      from dbview.models import DbView

      class ModelA(models.Model):
          fielda = models.CharField()
          fieldc = models.IntegerField()

      class MyView(DbView):
          fieldA = models.OneToOneField(ModelA, primary_key=True,
              db_column='fielda__id')
          fieldB = models.IntegerField(blank=True, null=True, db_column='fieldb')

          @classmethod
          def view(cls):
              """
              This method returns the SQL string that creates the view,
              in this example fieldB is the result of annotating another column
              """
              qs = modelA.objects.all(
              ).annotate(
                  fieldb=models.Sum('fieldc'),
              ).annotate(
                  fielda__id=models.F('pk'),
              ).order_by(
                  'fielda__id',
              ).values(
                  'fielda__id',
                  'fieldb',
              )
              return str(qs.query)

   Alternatively ``get_view_str`` method could be used to write a custom SQL:

   .. code-block:: python

       class MyView(DbView):
           # ...

           @classmethod
           def get_view_str(cls):
               return """
                   CREATE VIEW my_view AS (
                   SELECT ...
               )"""

3. Then create a migration point for your view generation, edit that
   migration and modify it, add:
   ``from dbview.helpers import CreateView`` and replace the line the
   call to ``migrations.CreateModel`` with ``CreateView``.

4. Migrate your database and start using your database views.


