{ "info": { "author": "Lucas Weyne", "author_email": "weynelucas@gmail.com", "bugtrack_url": null, "classifiers": [ "Development Status :: 5 - Production/Stable", "Framework :: Django", "Intended Audience :: Developers", "License :: OSI Approved :: MIT License", "Programming Language :: Python :: 3", "Programming Language :: Python :: 3.3", "Programming Language :: Python :: 3.4", "Programming Language :: Python :: 3.5", "Programming Language :: Python :: 3.6", "Topic :: Internet :: WWW/HTTP" ], "description": "[![PyPi version](https://img.shields.io/pypi/v/django-db-adapter.svg)](https://pypi.python.org/pypi/django-db-adapter)\n\n# django-db-adapter\nA configurable database backend for Oracle\n\n## Requirements\ndjango-db-adapter was tested with the following requirements:\n\n- [Python](https://www.python.org/) (3+)\n- [Django](https://docs.djangoproject.com/) (1.11)\n- [cx_Oracle](http://cx-oracle.readthedocs.io/en/latest/) (5.2+)\n\nThe following packages are optional:\n- [progressbar2](https://pypi.python.org/pypi/progressbar2) (3.34.0+) - Used only to display progress during `sqlmigrateall` command\n\n## Installation\nInstall using pip, including any optional packages you want...\n\n```\npip install django-db-adapter\n```\n\n...or clone the project from github.\n\n```\ngit clone https://github.com/weynelucas/django-db-adapter.git\n```\n\nAdd `'db_adapter'` at the top of your `INSTALLED_APPS` setting.\n\n```python\nINSTALLED_APPS = (\n ...,\n 'db_adapter'\n)\n```\n\n## Quickstart\nAny global settings for a django-db-adapter are kept in a single configuration dictionary named `DB_ADAPTER`\n\n```python\nDB_ADAPTER = {\n 'SCHEMA': 'CONN_ORCL',\n 'ALLOWED_BACKENDS': ['oracle'],\n 'PREFIX': {\n 'TABLE': 'tb_',\n 'FOREIGN_KEY': 'ce_',\n 'INDEX': 'ix_',\n 'UNIQUE': 'ct_',\n 'TRIGGER': 'tg_',\n 'SEQUENCE': 'sq_'\n }\n}\n```\n\nYou must setting the connection parameter `ENGINE` from `DATABASES` with the custom oracle database backend to apply your `DB_ADAPTER` settings.\n\n```python\nDATABASES = {\n 'default': {\n 'ENGINE': 'db_adapter.db.backends.oracle',\n 'NAME': 'mydatabase',\n 'USER': 'mydatabaseuser',\n 'PASSWORD': 'mypassword',\n 'HOST': '127.0.0.1',\n 'PORT': '1521'\n }\n}\n```\n\n## Settings\nConfiguration for django-db-adapter is all namespaced inside a single Django setting, named `DB_ADAPTER`.\n\nIf you need to access the values of `db_adapter` settings in your project, you should use the `settings` object. For example.\n\n```python\nfrom db_adapter.config import settings\n\nprint(settings.SCHEMA)\nprint(settings.PREFIX['TABLE'])\n```\n\n### Global settings\n\n#### `SCHEMA`\n**Default:** `None`\n\nString with user schema name of you database connection. This value will be appended to all database queries.\n\n#### `ALLOWED_BACKENDS`\n**Default:** `[ '*' ]`\n\nList of database backends names allowed to perform non-oracle actions. Add table prefixes and the command `sqlmigrateall` are actions that not require a oracle backend. If a backend are not present on list, theese action will not be performed.\n\nOptions are: `'mysql'`, `'oracle'`, `'postgresql'`, `'postgresql_psycopg2'`, `'sqlite'` or `*` for allow all backends to perform non-oracle actions\n\n\n#### `PREFIX`\n**Default:**\n```python\n{\n 'TABLE': 'tb_',\n 'FOREIGN_KEY': 'fk_',\n 'INDEX': 'ix_',\n 'UNIQUE': 'uniq_',\n 'TRIGGER': 'tg_',\n 'SEQUENCE': 'sq_'\n}\n```\n\nDefault prefix mapping for all database objects. This configuration allow backend to create DDL commands applying theese prefixes for each database object. \n\n```sql\nCREATE TABLE \"TB_PERSON\" (\"ID\" NUMBER(11) NOT NULL PRIMARY KEY, \"NAME\" NVARCHAR2(255) NULL);\n\nDECLARE\n i INTEGER;\nBEGIN\n SELECT COUNT(1) INTO i FROM USER_SEQUENCES\n WHERE SEQUENCE_NAME = 'SQ_PERSON';\n IF i = 0 THEN\n EXECUTE IMMEDIATE 'CREATE SEQUENCE \"SQ_PERSON\"';\n END IF;\nEND;\n/;\n```\n\n## Release Notes\n\n- 1.0.0 - 16/04/2018 - First release\n- 1.0.1 - 16/04/2018 - Rename package and fix setup issues\n- 1.0.2 - 17/04/2018 - Fix documentation preview", "description_content_type": "text/markdown", "docs_url": null, "download_url": "https://github.com/weynelucas/django-db-adapter/archive/1.0.2.tar.gz", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/weynelucas/django-db-adapter/", "keywords": "django database schema editor oracle django-db-adapter", "license": "", "maintainer": "", "maintainer_email": "", "name": "django-db-adapter", "package_url": "https://pypi.org/project/django-db-adapter/", "platform": "", "project_url": "https://pypi.org/project/django-db-adapter/", "project_urls": { "Download": "https://github.com/weynelucas/django-db-adapter/archive/1.0.2.tar.gz", "Homepage": "https://github.com/weynelucas/django-db-adapter/" }, "release_url": "https://pypi.org/project/django-db-adapter/1.0.2/", "requires_dist": null, "requires_python": "", "summary": "A configurable database backend for Oracle", "version": "1.0.2" }, "last_serial": 3773835, "releases": { "1.0.1": [ { "comment_text": "", "digests": { "md5": "4d0b3e6b40e7ab0f69dd09b9120f4699", "sha256": "0e06c00df89f4dcba6af10fbcf4da41f695a268c0f1fa57fa5d8adc12313eec8" }, "downloads": -1, "filename": "django-db-adapter-1.0.1.tar.gz", "has_sig": false, "md5_digest": "4d0b3e6b40e7ab0f69dd09b9120f4699", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 6204, "upload_time": "2018-04-16T19:46:05", "url": "https://files.pythonhosted.org/packages/25/70/69b48ff5c8791425db9ec7ed89197f846f768e61da754a76e8805304ba53/django-db-adapter-1.0.1.tar.gz" } ], "1.0.2": [ { "comment_text": "", "digests": { "md5": "7dd45467bbeeb52d34f4431a22d095cd", "sha256": "16374daafb5ce4ee4b0180b8d38979bdd851000a524a7f2f971aa23dbd320967" }, "downloads": -1, "filename": "django-db-adapter-1.0.2.tar.gz", "has_sig": false, "md5_digest": "7dd45467bbeeb52d34f4431a22d095cd", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 6142, "upload_time": "2018-04-17T16:06:04", "url": "https://files.pythonhosted.org/packages/85/7c/38eb165184fc4324d548c3d48dfb159c4aef490ddbe213970fec6546887a/django-db-adapter-1.0.2.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "7dd45467bbeeb52d34f4431a22d095cd", "sha256": "16374daafb5ce4ee4b0180b8d38979bdd851000a524a7f2f971aa23dbd320967" }, "downloads": -1, "filename": "django-db-adapter-1.0.2.tar.gz", "has_sig": false, "md5_digest": "7dd45467bbeeb52d34f4431a22d095cd", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 6142, "upload_time": "2018-04-17T16:06:04", "url": "https://files.pythonhosted.org/packages/85/7c/38eb165184fc4324d548c3d48dfb159c4aef490ddbe213970fec6546887a/django-db-adapter-1.0.2.tar.gz" } ] }