{
    "info": {
        "author": "William Galleti",
        "author_email": "william.galleti@gmail.com",
        "bugtrack_url": null,
        "classifiers": [
            "Development Status :: 4 - Beta",
            "Environment :: Console",
            "Framework :: Pytest",
            "Intended Audience :: Developers",
            "License :: OSI Approved :: BSD License",
            "Operating System :: OS Independent",
            "Programming Language :: Python :: 3.6"
        ],
        "description": "# pyDbOracle\n\nEst\u00e1 lib foi desenvolvida para facilitar o dia a dia de quem precisa martelar comandos a moda antiga (SELECT, UPDATE, INSERT) em bancos oracle.\n\n## Instala\u00e7\u00e3o\n\n```\npip install pyDbOracle\n```\n\n## Utiliza\u00e7\u00e3o\n\nAlguns exemplos de uso.\n\n### Conex\u00e3o b\u00e1sica\n\n```Python\nfrom pyDbOracle.database import Database\nstr_conn = 'oracle://<USER>:<PASS>@<HOST>:<PORT>/<INSTANCE>'\ndb = Database(str_conn)\ndb.info()\n```\n\n\n### Conex\u00e3o em banco com RAC\n\n```Python\nfrom pyDbOracle.database import Database\nstr_conn = 'oracle://<USER>:<PASS>@<HOST>:<PORT>/<INSTANCE>?threaded=True'\ndb = Database(str_conn)\ndb.info()\n```\n\n\n### Conex\u00e3o definindo charset\n\n```Python\nfrom pyDbOracle.database import Database\nstr_conn = 'oracle://<USER>:<PASS>@<HOST>:<PORT>/<INSTANCE>?encoding=utf-8'\ndb = Database(str_conn)\ndb.info()\n```\n\n### Executando queries\n\n```Python\nfrom pyDbOracle.database import Database\nstr_conn = 'oracle://<USER>:<PASS>@<HOST>:<PORT>/<INSTANCE>'\ndb = Database(str_conn)\ncommand = 'SELECT INSTANCE_NAME FROM V$INSTANCE'\ndata = db.get(command=command)\nprint(data)\n# {'instance_name': 'PROD'}\n```\n\n### Executando queries com filtros\n\n```Python\nfrom pyDbOracle.database import Database\nstr_conn = 'oracle://<USER>:<PASS>@<HOST>:<PORT>/<INSTANCE>'\ndb = Database(str_conn)\ncommand = 'SELECT INSTANCE_NAME FROM V$INSTANCE WHERE HOST = :host'\nparams = dict(host='MEUHOST')\ndata = db.get(command=command, params=params)\nprint(data)\n# {'instance_name': 'PROD'}\n```\n\n### Executandos Inserts, Updates ou Deletes\n\nQuando precisar executar um comando do tipo insert, update ou delete, rodar o metodo `run` \n\n```Python\nfrom pyDbOracle.database import Database\nstr_conn = 'oracle://<USER>:<PASS>@<HOST>:<PORT>/<INSTANCE>'\ndb = Database(str_conn)\ncommand = 'INSERT INTO TABELA (COLUNA1, COLUNA2) VALUES (:valor1, :valor2)'\nparams = dict(valor1='ABC', valor2=123)\ndata = db.run(command=command, params=params)\nprint(data)\n# 1\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/wgalleti/pyDbOracle",
        "keywords": "",
        "license": "BSD",
        "maintainer": "",
        "maintainer_email": "",
        "name": "pyDbOracle",
        "package_url": "https://pypi.org/project/pyDbOracle/",
        "platform": "",
        "project_url": "https://pypi.org/project/pyDbOracle/",
        "project_urls": {
            "Homepage": "https://github.com/wgalleti/pyDbOracle"
        },
        "release_url": "https://pypi.org/project/pyDbOracle/0.4.2/",
        "requires_dist": null,
        "requires_python": "",
        "summary": "Standard Oracle Using (queries, updates, inserts)",
        "version": "0.4.2"
    },
    "last_serial": 5415588,
    "releases": {
        "0.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "e02a6cf063fa17c9fbf93d6b708bff3b",
                    "sha256": "5fae68a71d37aefa40e3e6cb82323cee23d0bae860ee3222752b9fc118b4bdbe"
                },
                "downloads": -1,
                "filename": "pyDbOracle-0.1.tar.gz",
                "has_sig": false,
                "md5_digest": "e02a6cf063fa17c9fbf93d6b708bff3b",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 4635,
                "upload_time": "2019-02-04T19:00:40",
                "url": "https://files.pythonhosted.org/packages/2f/c0/68d56145d1e710a905bf8435a10a3d0838dc54247937fd55d7ac1281eb95/pyDbOracle-0.1.tar.gz"
            }
        ],
        "0.2": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "1dd2b6a3633fc0e4301e22a5fb70166d",
                    "sha256": "5c07b505b85c2164be9fb8dff576eadc589bd5199c216e5b597cdae910cfac69"
                },
                "downloads": -1,
                "filename": "pyDbOracle-0.2.tar.gz",
                "has_sig": false,
                "md5_digest": "1dd2b6a3633fc0e4301e22a5fb70166d",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 4695,
                "upload_time": "2019-02-04T19:15:11",
                "url": "https://files.pythonhosted.org/packages/15/0b/e887388590a8239d4ad1bd276f02d69bb6c3ad6903cfaa1cce0858cd1fd2/pyDbOracle-0.2.tar.gz"
            }
        ],
        "0.3": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "725005117f56b886f4f509308afc52bc",
                    "sha256": "47f7e89bacecb370038efbfcaa33574e50d3bb1ddcfcc98c878cac7505d04ba7"
                },
                "downloads": -1,
                "filename": "pyDbOracle-0.3.tar.gz",
                "has_sig": false,
                "md5_digest": "725005117f56b886f4f509308afc52bc",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 4690,
                "upload_time": "2019-06-03T19:49:24",
                "url": "https://files.pythonhosted.org/packages/6e/9d/2dffed32f4e1219162321797aa4303714aa57359fafbc379d0cc76f7da26/pyDbOracle-0.3.tar.gz"
            }
        ],
        "0.4": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "ac009797308729d97151260db53ad47c",
                    "sha256": "979726b3a12639be860fbe705c901202e0026aa6235c73317c7e63f7e61b54d7"
                },
                "downloads": -1,
                "filename": "pyDbOracle-0.4.tar.gz",
                "has_sig": false,
                "md5_digest": "ac009797308729d97151260db53ad47c",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 4700,
                "upload_time": "2019-06-03T20:42:10",
                "url": "https://files.pythonhosted.org/packages/e8/c4/c8285fb52cf55da06df0a2548c03f6f9e51c6d3a54f13660b446639e3edb/pyDbOracle-0.4.tar.gz"
            }
        ],
        "0.4.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "8cc1ef75a5e8438a49e494a1cb8fd9d9",
                    "sha256": "e533213f68227f42d65aaeea4b38f2fe114dc8aefca23a33233ad20fa9cf7320"
                },
                "downloads": -1,
                "filename": "pyDbOracle-0.4.1.tar.gz",
                "has_sig": false,
                "md5_digest": "8cc1ef75a5e8438a49e494a1cb8fd9d9",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 4636,
                "upload_time": "2019-06-05T18:54:30",
                "url": "https://files.pythonhosted.org/packages/02/10/3b67105b4396b7ea0c3f5e2035ab1a24a02a02deec2cf345665393881d59/pyDbOracle-0.4.1.tar.gz"
            }
        ],
        "0.4.2": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "e88edcb54ae3129ddd7b0f020c79a535",
                    "sha256": "58a67798293fdcf42a4ccd5be39c30b8692891e08c85d3e2f14aeee03aecb5f4"
                },
                "downloads": -1,
                "filename": "pyDbOracle-0.4.2.tar.gz",
                "has_sig": false,
                "md5_digest": "e88edcb54ae3129ddd7b0f020c79a535",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 4695,
                "upload_time": "2019-06-18T14:16:36",
                "url": "https://files.pythonhosted.org/packages/df/bb/e8da93d30dca1003c6786bd68dd522f6d15734654f2a7c251d20571facd1/pyDbOracle-0.4.2.tar.gz"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "e88edcb54ae3129ddd7b0f020c79a535",
                "sha256": "58a67798293fdcf42a4ccd5be39c30b8692891e08c85d3e2f14aeee03aecb5f4"
            },
            "downloads": -1,
            "filename": "pyDbOracle-0.4.2.tar.gz",
            "has_sig": false,
            "md5_digest": "e88edcb54ae3129ddd7b0f020c79a535",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 4695,
            "upload_time": "2019-06-18T14:16:36",
            "url": "https://files.pythonhosted.org/packages/df/bb/e8da93d30dca1003c6786bd68dd522f6d15734654f2a7c251d20571facd1/pyDbOracle-0.4.2.tar.gz"
        }
    ]
}