{ "info": { "author": "Bart\u0142omiej Nowak and Mariusz Okulanis", "author_email": "n.bartek3762@gmail.com", "bugtrack_url": null, "classifiers": [ "License :: OSI Approved :: MIT License", "Programming Language :: Python :: 3", "Programming Language :: Python :: 3.7" ], "description": "# django-db-views\n\n### How to install?\n - `pip install django-db-views`\n\n### How to use?\n - add `django_db_views` to `INSTALLED_APPS`\n - use `makeviewmigrations` command to create migrations for view models\n\n\n### How to create view in your database?\n\n from django_db_views.db_view import DBView\n\n class Balance(DBView):\n\n virtual_card = models.ForeignKey(\n VirtualCard, on_delete=models.DO_NOTHING, related_name='virtual_cards'\n )\n total_discount = models.DecimalField(max_digits=12, decimal_places=2)\n total_returns = models.DecimalField(max_digits=12, decimal_places=2)\n balance = models.DecimalField(max_digits=12, decimal_places=2)\n\n view_definition = \"\"\"\n SELECT\n row_number() over () as id, # Django requires column called id\n virtual_card.id as virtual_card_id,\n sum(...) as total_discount,\n ...\n \"\"\"\n\n class Meta:\n managed = False\n db_table = 'virtual_card_balance'\n\n### How view migrations work?\n - It's using Django code, view-migrations looks like regular migrations. \n - It relies on `db_table` names. \n - `makeviewmigrations` command finds previous migration for view.\n - if there is no such migration then script create a new migration\n - if previous migration exists but no change in `view_definition` is detected nothing is done\n - if previous migration exists, then script will use previous `view_definition` for backward operation, and creates new migration.\n\nTested with live project based on Django 1.11.5\n\n\n", "description_content_type": "text/markdown", "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/BezBartek/django-db-views", "keywords": "", "license": "MIT", "maintainer": "", "maintainer_email": "", "name": "django-db-views", "package_url": "https://pypi.org/project/django-db-views/", "platform": "", "project_url": "https://pypi.org/project/django-db-views/", "project_urls": { "Homepage": "https://github.com/BezBartek/django-db-views" }, "release_url": "https://pypi.org/project/django-db-views/0.0.5/", "requires_dist": [ "Django", "six" ], "requires_python": "", "summary": "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", "version": "0.0.5" }, "last_serial": 5683893, "releases": { "0.0.1": [ { "comment_text": "", "digests": { "md5": "35124512573462563c2830b5d1227a78", "sha256": "7ab54525350f969fcee241b89c8e5c97fc6a47d022f81356e1c8dc446d21d600" }, "downloads": -1, "filename": "django_db_views-0.0.1-py3-none-any.whl", "has_sig": false, "md5_digest": "35124512573462563c2830b5d1227a78", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 6834, "upload_time": "2019-08-11T14:14:22", "url": "https://files.pythonhosted.org/packages/d5/35/243cad8a0d885cabbf733e515946e78f9ed796b9a6d97609d42dd834fab3/django_db_views-0.0.1-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "049b8d727744492247c36898e0175527", "sha256": "6db2596e76ff0993a7807a41809429c39a082c8e2f3041b37daf6e01edb78e04" }, "downloads": -1, "filename": "django-db-views-0.0.1.tar.gz", "has_sig": false, "md5_digest": "049b8d727744492247c36898e0175527", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5236, "upload_time": "2019-08-11T14:14:24", "url": "https://files.pythonhosted.org/packages/1c/b9/bcb8f6b12060cc2f165624b428f0ea4d585b5f3261bc3d0eac051e6f5c33/django-db-views-0.0.1.tar.gz" } ], "0.0.2": [ { "comment_text": "", "digests": { "md5": "9252682333c370810d5045364b242c8c", "sha256": "4e4521aecc9e9ae761feb76406b346c39cc0afc5fd80285e70aa014f38793d8e" }, "downloads": -1, "filename": "django_db_views-0.0.2-py3-none-any.whl", "has_sig": false, "md5_digest": "9252682333c370810d5045364b242c8c", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 7087, "upload_time": "2019-08-11T20:16:29", "url": "https://files.pythonhosted.org/packages/9b/b1/8e20c6da5e15ba50ffbe34eac778c3fb82f097e58a6a0e68a51b5d45372b/django_db_views-0.0.2-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "d6d512e815e269049d80866b942c7a56", "sha256": "53c8e225ea7b1fa53c71876c30914170614ede391a1b5ddd9ceafc9f7fe979e1" }, "downloads": -1, "filename": "django-db-views-0.0.2.tar.gz", "has_sig": false, "md5_digest": "d6d512e815e269049d80866b942c7a56", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5461, "upload_time": "2019-08-11T20:16:31", "url": "https://files.pythonhosted.org/packages/4c/45/344009f4bf8ad4c57943a5323319ca8f0b39dad50a94994eba14459ff9db/django-db-views-0.0.2.tar.gz" } ], "0.0.3": [ { "comment_text": "", "digests": { "md5": "714437676cce7a868c47c538a1baaf03", "sha256": "05b49ccf139127f4e9d7443b14c33bffd5dfdcc1b1ad564d09c6c9d4df506b63" }, "downloads": -1, "filename": "django_db_views-0.0.3-py3-none-any.whl", "has_sig": false, "md5_digest": "714437676cce7a868c47c538a1baaf03", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 7061, "upload_time": "2019-08-11T20:28:21", "url": "https://files.pythonhosted.org/packages/74/a6/410d4b924adbca4c0856ef6340decd666e417a9ab14f1d4f009f3502143c/django_db_views-0.0.3-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "e2f9c5fbaa8b5141bb814d8fd10946ce", "sha256": "379e9815efa0c1cbdf201e391104580756d782ba3df2df1788ddb7f823d19586" }, "downloads": -1, "filename": "django-db-views-0.0.3.tar.gz", "has_sig": false, "md5_digest": "e2f9c5fbaa8b5141bb814d8fd10946ce", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5441, "upload_time": "2019-08-11T20:28:24", "url": "https://files.pythonhosted.org/packages/5f/c2/29defbc2c40004fb4ace1718cde61779580deb485fc6fd8da80b39244b2a/django-db-views-0.0.3.tar.gz" } ], "0.0.4": [ { "comment_text": "", "digests": { "md5": "7e37931c88ad83bbf22dab1d1a6f70ac", "sha256": "38bd3363d28131c5ae094a9ea56fe6c14566e8e6fb55bd9130c4fbe260080dd7" }, "downloads": -1, "filename": "django_db_views-0.0.4-py3-none-any.whl", "has_sig": false, "md5_digest": "7e37931c88ad83bbf22dab1d1a6f70ac", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 7606, "upload_time": "2019-08-13T13:10:12", "url": "https://files.pythonhosted.org/packages/7e/e2/973e68ed44c87e43443b6c45cc0b6ab4efa6bbd32c9947a97e392fa6016d/django_db_views-0.0.4-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "d4524e229f3608753db9930b1fa5b175", "sha256": "2482c27ae7253f78a5617506070da35d03abc8ae50cf90bcbfce82811fc3d9ec" }, "downloads": -1, "filename": "django-db-views-0.0.4.tar.gz", "has_sig": false, "md5_digest": "d4524e229f3608753db9930b1fa5b175", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5391, "upload_time": "2019-08-13T13:10:14", "url": "https://files.pythonhosted.org/packages/63/77/0f5c8a7ef793faa756de63911636b5334a010dd3be6cf544762370ae4545/django-db-views-0.0.4.tar.gz" } ], "0.0.5": [ { "comment_text": "", "digests": { "md5": "9a9bc7fef08e5e0b21ee9378ac13e4c0", "sha256": "653ff42ff16db8e26b10ff732dc5d2a4e8dbe734126bb6aac9ca1ee5ff9a435d" }, "downloads": -1, "filename": "django_db_views-0.0.5-py3-none-any.whl", "has_sig": false, "md5_digest": "9a9bc7fef08e5e0b21ee9378ac13e4c0", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 7067, "upload_time": "2019-08-15T19:42:11", "url": "https://files.pythonhosted.org/packages/0f/12/7fa7d18292ce962e0f1c0b0b6cd11f318dea3c66c475a36f12b47067aaa8/django_db_views-0.0.5-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "da6d4baef1db822fd5b3e9b5c3e377d9", "sha256": "a284fea430251718912d3772e2753bf8ef6ceb8c197bf68ba5f9efb3b8b0ab4f" }, "downloads": -1, "filename": "django-db-views-0.0.5.tar.gz", "has_sig": false, "md5_digest": "da6d4baef1db822fd5b3e9b5c3e377d9", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5457, "upload_time": "2019-08-15T19:42:15", "url": "https://files.pythonhosted.org/packages/4b/df/4647aad3527f1ab0d57bcc995f92b5c6f957a0af0e3f239685a95752b45a/django-db-views-0.0.5.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "9a9bc7fef08e5e0b21ee9378ac13e4c0", "sha256": "653ff42ff16db8e26b10ff732dc5d2a4e8dbe734126bb6aac9ca1ee5ff9a435d" }, "downloads": -1, "filename": "django_db_views-0.0.5-py3-none-any.whl", "has_sig": false, "md5_digest": "9a9bc7fef08e5e0b21ee9378ac13e4c0", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 7067, "upload_time": "2019-08-15T19:42:11", "url": "https://files.pythonhosted.org/packages/0f/12/7fa7d18292ce962e0f1c0b0b6cd11f318dea3c66c475a36f12b47067aaa8/django_db_views-0.0.5-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "da6d4baef1db822fd5b3e9b5c3e377d9", "sha256": "a284fea430251718912d3772e2753bf8ef6ceb8c197bf68ba5f9efb3b8b0ab4f" }, "downloads": -1, "filename": "django-db-views-0.0.5.tar.gz", "has_sig": false, "md5_digest": "da6d4baef1db822fd5b3e9b5c3e377d9", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5457, "upload_time": "2019-08-15T19:42:15", "url": "https://files.pythonhosted.org/packages/4b/df/4647aad3527f1ab0d57bcc995f92b5c6f957a0af0e3f239685a95752b45a/django-db-views-0.0.5.tar.gz" } ] }