{
    "info": {
        "author": "Dauren Sdykov",
        "author_email": "",
        "bugtrack_url": null,
        "classifiers": [],
        "description": "oradump\n=========\n\nOraDump is a simple class for extracting data from Oracle database. It works over the native Oracle client,\nso you'll have the fastest and convenient way to get your data dumped.\n\n### Requirements\n- Since it works directly with native Oracle client, you need to have installed 12.2c(or higher) version of it on your computer.\n- Path to BIN directory of Oracle client have to be in PATH variable.\n- Set ENV variable `NLS_LANG` to encoding which used on your Oracle server. Like `AMERICAN_AMERICA.AL32UTF8`\n- Installed Python 3.6 or higher.\n\n\n### Installation\n    pip install oradump \n\n\n### Usage\n\nBefore utilize OraDump you need to prepare SQL-statement that will be used for retrieving data. \nFor values that will be changing you set placeholders like that `{start_date}`. So you'll have SQL script, but like as a template.\n\nExample:\n\n```sql\nselect\n     field_1,\n     id,\n     first_name,\n     last_name,\n     birth_day,\n     ....\n     field_N ,\n from scheme.employees\n where birth_day = to_date('{date}', 'dd.mm.yyyy')\n```\n\n\n`from oradump import OraDump` \n\nBy now, you can get data only in csv format. So to achieve this, you need to call `dump` or `dump_gziped`(if want get it compressed) functions.\n\n`dump` example:\n\n    rows_cnt = OraDump.dump(conn_str, template, csv, params)\n\n- conn_str - connection string that you specify when you connect to Oracle instance by native client(sqlplus). \nLike `user/password@(DESCRIPTION = (ADDRESS_LIST =  (ADDRESS = (PROTOCOL=TCP)(HOST=XXX.XXX.XXX.XXX)(PORT=1521)))(CONNECT_DATA = (SERVICE_NAME=SID.alias)))`\n\n- template - SQL template described above\n- csv - path to target csv file\n- params - parameters passing into SQL template and substituting into according placeholders.\n\n`dump_gziped` example:\n\n    rows_cnt = OraDump.dump_gziped(conn_str, template, gzip, params, del_orig=False)\n- gzip - path to target gziped csv file\n- del_orig - whether if you want to delete csv file that OraDump gets before compressing.\n\npurposes of rest of parameters are the same as in `dump`\n\nIf all went successful number of retrieved rows is returned. \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/elessarelfstone/oradump",
        "keywords": "",
        "license": "",
        "maintainer": "",
        "maintainer_email": "",
        "name": "oradump",
        "package_url": "https://pypi.org/project/oradump/",
        "platform": "",
        "project_url": "https://pypi.org/project/oradump/",
        "project_urls": {
            "Homepage": "https://github.com/elessarelfstone/oradump"
        },
        "release_url": "https://pypi.org/project/oradump/1.0.7/",
        "requires_dist": null,
        "requires_python": "",
        "summary": "Just a package for simple extracting data from Oracle database",
        "version": "1.0.7"
    },
    "last_serial": 4983095,
    "releases": {
        "1.0.4": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "fb1fe8fa6227d564b21a6d8db46c9dc3",
                    "sha256": "fed554f3131f0b4305a715aa3a72bf785d0c50afb6063ef39807a3e1afa8e377"
                },
                "downloads": -1,
                "filename": "oradump-1.0.4-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "fb1fe8fa6227d564b21a6d8db46c9dc3",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 4036,
                "upload_time": "2019-03-25T13:32:59",
                "url": "https://files.pythonhosted.org/packages/61/ae/9dd67695058af93cf2bc3058f418eafbc5f3432bfd4a2323651b3f5672ce/oradump-1.0.4-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "8d3c5e377db510fc39402bb9ca2ddc9b",
                    "sha256": "56fbf7aad0552e493f3bf33ed47d6262774145df23b5f01579674bc4d393428e"
                },
                "downloads": -1,
                "filename": "oradump-1.0.4.tar.gz",
                "has_sig": false,
                "md5_digest": "8d3c5e377db510fc39402bb9ca2ddc9b",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 3811,
                "upload_time": "2019-03-25T13:33:00",
                "url": "https://files.pythonhosted.org/packages/17/7f/f2043f4715428d7265e96436b4b4ab1f7f8b7f799be91aba6b8c430047f5/oradump-1.0.4.tar.gz"
            }
        ],
        "1.0.5": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "d81328d865994aeddf51c3361c4d0e56",
                    "sha256": "eee96dcd15a64113d1ff9b7be5b80732bb07015a4fca936141ee2c718e41c078"
                },
                "downloads": -1,
                "filename": "oradump-1.0.5-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "d81328d865994aeddf51c3361c4d0e56",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 4035,
                "upload_time": "2019-03-25T13:40:28",
                "url": "https://files.pythonhosted.org/packages/84/64/406d7dd4e76a85595979f2c1b72436a09cf8e47ec875826d6ed7d957875e/oradump-1.0.5-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "ff4a7f2410496b7b584ed7c28fe01425",
                    "sha256": "5074f84d28bb918fc4d7f7f7f1695dc4a76f3b64203d327d48d94d0a6cfb4ed1"
                },
                "downloads": -1,
                "filename": "oradump-1.0.5.tar.gz",
                "has_sig": false,
                "md5_digest": "ff4a7f2410496b7b584ed7c28fe01425",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 3810,
                "upload_time": "2019-03-25T13:40:29",
                "url": "https://files.pythonhosted.org/packages/51/fc/17316dc650e1ef8881b42d384743e8733c424e777694c04ce09daa4fc635/oradump-1.0.5.tar.gz"
            }
        ],
        "1.0.6": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "05f6baf4168ce0984a0ac2cec7d78129",
                    "sha256": "3669057f4f17589df738ddfe6baa519bc5c13046dc108abc9878c3f3ae4d4d6d"
                },
                "downloads": -1,
                "filename": "oradump-1.0.6-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "05f6baf4168ce0984a0ac2cec7d78129",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 4404,
                "upload_time": "2019-03-25T14:16:18",
                "url": "https://files.pythonhosted.org/packages/fd/8a/2648a8598952afd8529eb6d54501e25096301e117a0b0ca65a6327088f55/oradump-1.0.6-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "4bfc779981523464e7b2a05225aeb66c",
                    "sha256": "6e00442f98c2b4eacca6922ef0010825bf9a4f8bfb8e229d2f55165d9d5d8cb3"
                },
                "downloads": -1,
                "filename": "oradump-1.0.6.tar.gz",
                "has_sig": false,
                "md5_digest": "4bfc779981523464e7b2a05225aeb66c",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 3821,
                "upload_time": "2019-03-25T14:16:19",
                "url": "https://files.pythonhosted.org/packages/15/9c/4861a7011cc1d18ec0ee0c9dc8b53d46d29fd0d1802e01446851dc122cce/oradump-1.0.6.tar.gz"
            }
        ],
        "1.0.7": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "7587241aba8161bb947ab863db4ac069",
                    "sha256": "7ed6004b24b98e7eb90c2f19bb59431136d0cf62e8e17f4431668e3b286347b5"
                },
                "downloads": -1,
                "filename": "oradump-1.0.7-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "7587241aba8161bb947ab863db4ac069",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 4403,
                "upload_time": "2019-03-25T15:36:05",
                "url": "https://files.pythonhosted.org/packages/57/88/0e5bbd4bc7e0d35c0d603342868b5b178535e69704f2327d41d9ebd4e7c8/oradump-1.0.7-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "0a37a4f38d6a14c8bf36611b3e9ac619",
                    "sha256": "403c6bd0b4ed944d8c4e255a0e7a1bcc5bd57757428be233ce286f0a233a4540"
                },
                "downloads": -1,
                "filename": "oradump-1.0.7.tar.gz",
                "has_sig": false,
                "md5_digest": "0a37a4f38d6a14c8bf36611b3e9ac619",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 3818,
                "upload_time": "2019-03-25T15:36:06",
                "url": "https://files.pythonhosted.org/packages/bd/99/1ae77430688549beda7efb952a8225f2e15826e298e56968116b55e0dece/oradump-1.0.7.tar.gz"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "7587241aba8161bb947ab863db4ac069",
                "sha256": "7ed6004b24b98e7eb90c2f19bb59431136d0cf62e8e17f4431668e3b286347b5"
            },
            "downloads": -1,
            "filename": "oradump-1.0.7-py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "7587241aba8161bb947ab863db4ac069",
            "packagetype": "bdist_wheel",
            "python_version": "py3",
            "requires_python": null,
            "size": 4403,
            "upload_time": "2019-03-25T15:36:05",
            "url": "https://files.pythonhosted.org/packages/57/88/0e5bbd4bc7e0d35c0d603342868b5b178535e69704f2327d41d9ebd4e7c8/oradump-1.0.7-py3-none-any.whl"
        },
        {
            "comment_text": "",
            "digests": {
                "md5": "0a37a4f38d6a14c8bf36611b3e9ac619",
                "sha256": "403c6bd0b4ed944d8c4e255a0e7a1bcc5bd57757428be233ce286f0a233a4540"
            },
            "downloads": -1,
            "filename": "oradump-1.0.7.tar.gz",
            "has_sig": false,
            "md5_digest": "0a37a4f38d6a14c8bf36611b3e9ac619",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 3818,
            "upload_time": "2019-03-25T15:36:06",
            "url": "https://files.pythonhosted.org/packages/bd/99/1ae77430688549beda7efb952a8225f2e15826e298e56968116b55e0dece/oradump-1.0.7.tar.gz"
        }
    ]
}