{ "info": { "author": "Manuel F. Naranjo", "author_email": "naranjo.manuel@gmail.com", "bugtrack_url": null, "classifiers": [ "Environment :: Web Environment", "Framework :: Django", "Intended Audience :: Developers", "License :: OSI Approved :: MIT License", "Operating System :: OS Independent", "Programming Language :: Python", "Programming Language :: Python :: 2", "Programming Language :: Python :: 2.7", "Programming Language :: Python :: 3", "Programming Language :: Python :: 3.2", "Programming Language :: Python :: 3.3", "Programming Language :: Python :: 3.4", "Topic :: Internet :: WWW/HTTP", "Topic :: Internet :: WWW/HTTP :: Dynamic Content" ], "description": "django-database-view\n====================\n\nA simple pluggable application that allows to work with database views.\n\nSo far only MySQL is supported as backend, but more could be added if\nnecessary.\n\nQuick start\n-----------\n\n1. Add \"dbview\" to your INSTALLED\\_APPS settings like this:\n\n .. code:: python\n\n INSTALLED_APPS = (\n ...\n 'dbview',\n )\n\n2. In your models.py create classes which extend dbview.DbView like\n this:\n\n .. code:: python\n\n\n from django.db import models\n from dbview import DbView\n\n class ModelA(models.Model):\n fielda = models.CharField()\n fieldc = models.IntegerField()\n\n class MyView(DbView):\n fieldA = models.OneToOneField(ModelA, primary_key=True,\n db_column='fielda__id')\n fieldB = models.IntegerField(blank=True, null=True, db_column='fieldb')\n\n @classmethod\n def view(klass):\n '''\n This method returns the SQL string that creates the view, in this\n example fieldB is the result of annotating another column\n '''\n qs = modelA.objects.all().\\\n annotate(fieldb=models.Sum('fieldc')) .\\\n annotate(fielda__id=models.F('pk')) .\\\n order_by('fielda__id') .\\\n values('fielda__id', 'fieldb')\n return str(qs.query)\n\n3. Then create a migration point for your view generation, edit that\n migration and modify it, add: ``from dbview import CreateView`` and\n replace the line the call to ``migrations.CreateModel`` with\n ``CreateView``.\n\n4. Migrate your database and start using your database views.", "description_content_type": null, "docs_url": null, "download_url": "UNKNOWN", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/manuelnaranjo/django-database-view", "keywords": null, "license": "MIT", "maintainer": null, "maintainer_email": null, "name": "django-database-view", "package_url": "https://pypi.org/project/django-database-view/", "platform": "UNKNOWN", "project_url": "https://pypi.org/project/django-database-view/", "project_urls": { "Download": "UNKNOWN", "Homepage": "https://github.com/manuelnaranjo/django-database-view" }, "release_url": "https://pypi.org/project/django-database-view/0.1.3/", "requires_dist": null, "requires_python": null, "summary": "A simple Django app to handle database views.", "version": "0.1.3" }, "last_serial": 1814827, "releases": { "0.1": [ { "comment_text": "", "digests": { "md5": "7a1929ab3f4131ab86602bf782c477f1", "sha256": "b2d17a76f15692d680b2a5293dee76799d674b77758afff60ae6a7c75340b8b9" }, "downloads": -1, "filename": "django_database_view-0.1-py2-none-any.whl", "has_sig": false, "md5_digest": "7a1929ab3f4131ab86602bf782c477f1", "packagetype": "bdist_wheel", "python_version": "2.7", "requires_python": null, "size": 4854, "upload_time": "2015-07-27T19:44:43", "url": "https://files.pythonhosted.org/packages/09/f5/44b209299a14664db0e5b421a2a35eda08ed68cfe14aa2d4e4b1bb3e73b0/django_database_view-0.1-py2-none-any.whl" }, { "comment_text": "", "digests": { "md5": "b622483e977b83c833557b31096a8e2d", "sha256": "e33ce31f03569c69662f2af0ef629669a33eed7182a12d1f9f4433bf5b88ef1c" }, "downloads": -1, "filename": "django-database-view-0.1.tar.gz", "has_sig": false, "md5_digest": "b622483e977b83c833557b31096a8e2d", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3934, "upload_time": "2015-07-27T19:44:39", "url": "https://files.pythonhosted.org/packages/93/9a/42505be8e30c371efd4542ba9047335dcbe888ec13e1733c8810cd7dd880/django-database-view-0.1.tar.gz" } ], "0.1.1": [ { "comment_text": "", "digests": { "md5": "730469e7bb921a93f11d4acf3d0c9e17", "sha256": "058d1852d99e8a7bb67ca77cefefeaa5069d474fb8c314daec60eea7cc01fafb" }, "downloads": -1, "filename": "django_database_view-0.1.1-py2-none-any.whl", "has_sig": false, "md5_digest": "730469e7bb921a93f11d4acf3d0c9e17", "packagetype": "bdist_wheel", "python_version": "2.7", "requires_python": null, "size": 4914, "upload_time": "2015-07-28T11:36:04", "url": "https://files.pythonhosted.org/packages/fa/8c/76788f673e759ec4b01c1049244c27fee6b9d81257a782b0560d8f5c5b5a/django_database_view-0.1.1-py2-none-any.whl" }, { "comment_text": "", "digests": { "md5": "44ad57ab3d6672b40b654c1ebf3e669f", "sha256": "81a0269a5cd0a61dd05c071cdaaee7dba9dce3672510631b2034c69a8a95bcf2" }, "downloads": -1, "filename": "django-database-view-0.1.1.tar.gz", "has_sig": false, "md5_digest": "44ad57ab3d6672b40b654c1ebf3e669f", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3959, "upload_time": "2015-07-28T11:36:00", "url": "https://files.pythonhosted.org/packages/e2/a0/628d8973faf1de2d7131346b7b6c84ea55131ae1112b6e094e315901118f/django-database-view-0.1.1.tar.gz" } ], "0.1.2": [ { "comment_text": "", "digests": { "md5": "9de7cb1500097ad285de7173107ddc0b", "sha256": "39279bc0a448b585ef776a7e9e24f7f24c9ff4f4b30a3badc189125637cd634c" }, "downloads": -1, "filename": "django_database_view-0.1.2-py2-none-any.whl", "has_sig": false, "md5_digest": "9de7cb1500097ad285de7173107ddc0b", "packagetype": "bdist_wheel", "python_version": "2.7", "requires_python": null, "size": 4927, "upload_time": "2015-07-28T16:51:33", "url": "https://files.pythonhosted.org/packages/9a/f0/c09d36ced8a689b3cb39c0c41c137d75e294c43eee078d9d5520a6574495/django_database_view-0.1.2-py2-none-any.whl" }, { "comment_text": "", "digests": { "md5": "479db27058cc6457e3df56b10369ad6a", "sha256": "9d424831f0a26bd9bc2c5a1e5159f4233b9bab6c3d05837c53ffc9f10f0b6021" }, "downloads": -1, "filename": "django-database-view-0.1.2.tar.gz", "has_sig": false, "md5_digest": "479db27058cc6457e3df56b10369ad6a", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3974, "upload_time": "2015-07-28T16:51:29", "url": "https://files.pythonhosted.org/packages/57/61/9682577fd96e9c96ef996167ca0d0163aa3c082724cd523724a5c011679d/django-database-view-0.1.2.tar.gz" } ], "0.1.3": [ { "comment_text": "", "digests": { "md5": "f39e90be9c5ecdb626dae853aebefea9", "sha256": "1c289accf23a9a2d3f0fa83d69d3c140595badc1c7a86d651be2031434c47ada" }, "downloads": -1, "filename": "django_database_view-0.1.3-py2-none-any.whl", "has_sig": false, "md5_digest": "f39e90be9c5ecdb626dae853aebefea9", "packagetype": "bdist_wheel", "python_version": "2.7", "requires_python": null, "size": 10641, "upload_time": "2015-11-13T13:27:52", "url": "https://files.pythonhosted.org/packages/76/0f/7161f9615129e95999ed0a5479caabab155323769e9147122d90eeabc254/django_database_view-0.1.3-py2-none-any.whl" }, { "comment_text": "", "digests": { "md5": "9049d2504c5976460c933c4b56b3f2d1", "sha256": "49abcda91ce025dd01df73bcd98768cb865f9c18f70b15431d10be9c74c232a8" }, "downloads": -1, "filename": "django-database-view-0.1.3.tar.gz", "has_sig": false, "md5_digest": "9049d2504c5976460c933c4b56b3f2d1", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3977, "upload_time": "2015-11-13T13:27:47", "url": "https://files.pythonhosted.org/packages/bb/d3/066637d0b02a9c25c14e0c251bfc5b21ae919a37042580d62a642459a966/django-database-view-0.1.3.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "f39e90be9c5ecdb626dae853aebefea9", "sha256": "1c289accf23a9a2d3f0fa83d69d3c140595badc1c7a86d651be2031434c47ada" }, "downloads": -1, "filename": "django_database_view-0.1.3-py2-none-any.whl", "has_sig": false, "md5_digest": "f39e90be9c5ecdb626dae853aebefea9", "packagetype": "bdist_wheel", "python_version": "2.7", "requires_python": null, "size": 10641, "upload_time": "2015-11-13T13:27:52", "url": "https://files.pythonhosted.org/packages/76/0f/7161f9615129e95999ed0a5479caabab155323769e9147122d90eeabc254/django_database_view-0.1.3-py2-none-any.whl" }, { "comment_text": "", "digests": { "md5": "9049d2504c5976460c933c4b56b3f2d1", "sha256": "49abcda91ce025dd01df73bcd98768cb865f9c18f70b15431d10be9c74c232a8" }, "downloads": -1, "filename": "django-database-view-0.1.3.tar.gz", "has_sig": false, "md5_digest": "9049d2504c5976460c933c4b56b3f2d1", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3977, "upload_time": "2015-11-13T13:27:47", "url": "https://files.pythonhosted.org/packages/bb/d3/066637d0b02a9c25c14e0c251bfc5b21ae919a37042580d62a642459a966/django-database-view-0.1.3.tar.gz" } ] }