{
    "info": {
        "author": "Andrew Yatsko",
        "author_email": "ayatsko@live.com",
        "bugtrack_url": null,
        "classifiers": [
            "Development Status :: 4 - Beta",
            "Environment :: Console",
            "Intended Audience :: Developers",
            "License :: OSI Approved :: MIT License",
            "Programming Language :: Python",
            "Topic :: Database"
        ],
        "description": "odbctools\n=========\n\nOverview\n--------\nodbc tools is a set of tools to simplify connecting to and working with an ODBC data source. It includes a context manager for handling connections to the data source and the ability to return a result set in an easy to use format or write the results to a file.\n\nInstall It\n----------\nFrom PyPI ::\n\n    $ pip install odbctools\n\n\nUse It\n------\nOdbctools by default uses a file called config.ini, or you can override this for different scenarios, including passing the dsn directly.\n\nCreate config.ini ::\n\n    [odbc]\n    DSN=SourceName\n\nCode Example ::\n\n    from odbctools import OdbcManager\n\n    query_string = \"Your query here\"\n    params = [p1, p2]\n\n    with OdbcManager() as datasource:\n        result_list = datasource.get_dictionaries(query_string, params)\n        for result_dict in result_list:\n            for col_name, col_data in result_dict.items():\n                print(\"{0}{1}\".format(str(col_name).ljust(25), col_data))\n\nAnother Example ::\n\n    from odbctools import OdbcManager\n\n    query_string = \"Your query here\"\n    params = [p1, p2]\n\n    with OdbcManager(dsn='ODBC Name Here') as datasource:\n        result_list = datasource.get_dictionaries_in_queue(query_string, params)\n        for result_dict in result_list:\n            for col_name, col_data in result_dict.items():\n                print(\"{0}{1}\".format(str(col_name).ljust(25), col_data))\n\nEncapsulating the connection in your classes is also possible ::\n\n        class Foo:\n            def __init__(self):\n                self.connection = OdbcManager(dsn='unity64')\n\n            def __enter__(self):\n                self.connection.open_connection()\n                return self\n\n            def __exit__(self, exc_type, exc_val, exc_tb):\n                self.connection.close_connection()\n\n        with Foo() as f:\n            data = f.connection.get_dictionaries('select top 1 * from people', list())\n\nReturning data from a query\n---------------------------\n**query** - Returns list that contains [0]A list containing the query columns [1:] A list of the resulting data (rows)\n\n**get_dictionaries** - Queries data source, returns a list of dictionaries.\n\n**get_dictionaries_in_queue** - Queries data source, returns a deque of dictionaries.\n\n**write_to_csv** - Queries data source and writes results to a CSV file\n\nUpdating data\n-------------\n*Note: by default commit is turned off, if you want to enable auto commit, you can set it when creating the OdbcManager object or when calling this function.*\n\n**query_no_resultset** - For running DDL/DML queries for creating, deleting, updating records.\n\n\nDependencies\n------------\n* pypyodbc\n\nLicense\n--------\nMIT\n\n\n\n",
        "description_content_type": "",
        "docs_url": null,
        "download_url": "",
        "downloads": {
            "last_day": -1,
            "last_month": -1,
            "last_week": -1
        },
        "home_page": "https://github.com/N-C-C/odbctools",
        "keywords": "odbc database data sql informix",
        "license": "MIT",
        "maintainer": "",
        "maintainer_email": "",
        "name": "odbctools",
        "package_url": "https://pypi.org/project/odbctools/",
        "platform": "",
        "project_url": "https://pypi.org/project/odbctools/",
        "project_urls": {
            "Homepage": "https://github.com/N-C-C/odbctools"
        },
        "release_url": "https://pypi.org/project/odbctools/0.5.1/",
        "requires_dist": [
            "pypyodbc"
        ],
        "requires_python": "",
        "summary": "A set of tools to simplify connecting to and working with an ODBC data source",
        "version": "0.5.1"
    },
    "last_serial": 4535429,
    "releases": {
        "0.1.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "f71fb0f07fb6f0de9c0c84b0b27deb41",
                    "sha256": "b380f72c3eac7706f99d937b168e3f8985d038c73088c41fd9942d4ab6ffbb4e"
                },
                "downloads": -1,
                "filename": "odbctools-0.1.0.tar.gz",
                "has_sig": false,
                "md5_digest": "f71fb0f07fb6f0de9c0c84b0b27deb41",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 2734,
                "upload_time": "2017-05-10T21:27:59",
                "url": "https://files.pythonhosted.org/packages/b0/66/a8481faa80a4ad7cf0b827c655514aa2cd34c66209c4d0494872795df5e6/odbctools-0.1.0.tar.gz"
            }
        ],
        "0.2.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "e54dc5347ce3d3e2c8e91e2d581f0eb8",
                    "sha256": "22e9497009c6db6c2ee7c968d9a093eac7c14df4ccd1e89da420a457b562e738"
                },
                "downloads": -1,
                "filename": "odbctools-0.2.0.tar.gz",
                "has_sig": false,
                "md5_digest": "e54dc5347ce3d3e2c8e91e2d581f0eb8",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 2971,
                "upload_time": "2017-08-11T16:16:07",
                "url": "https://files.pythonhosted.org/packages/30/f0/79af561be018dff23fa796adc9098346326d3a59e86ebf1c4199d902a42a/odbctools-0.2.0.tar.gz"
            }
        ],
        "0.3.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "09d4562c4fabd58a682bd98105db1df8",
                    "sha256": "f596efaf751b8244361eed55f494a5eb089b6360e315d7f799fdb9485d76f944"
                },
                "downloads": -1,
                "filename": "odbctools-0.3.0.tar.gz",
                "has_sig": false,
                "md5_digest": "09d4562c4fabd58a682bd98105db1df8",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 3246,
                "upload_time": "2017-09-22T13:43:39",
                "url": "https://files.pythonhosted.org/packages/8e/ac/c2095ceeb4bb7d76c5e6d72e21b92137d7771715ec8f3c3b02e1e2ddb565/odbctools-0.3.0.tar.gz"
            }
        ],
        "0.4.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "c49ea022c66bd0d6ffd3d313b060540b",
                    "sha256": "ad03b10ae22a5d38d3e6d3716b553d0f5c771f6bbb97f6afd38c5319d5fec5ba"
                },
                "downloads": -1,
                "filename": "odbctools-0.4.0.tar.gz",
                "has_sig": false,
                "md5_digest": "c49ea022c66bd0d6ffd3d313b060540b",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 3890,
                "upload_time": "2017-10-04T16:23:53",
                "url": "https://files.pythonhosted.org/packages/99/08/db1776b24b2c67ddc35fa254a44079be95e62e3e3f37e4bc503c1be9ba01/odbctools-0.4.0.tar.gz"
            }
        ],
        "0.5.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "7e9e9bce6f5843681c1283c6378818e3",
                    "sha256": "53851cbdbb2ba2c068fcf8088ee7b3dd29104d6aaf22ed99fc9bcc4e0674f9cb"
                },
                "downloads": -1,
                "filename": "odbctools-0.5.0-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "7e9e9bce6f5843681c1283c6378818e3",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 5755,
                "upload_time": "2018-10-11T16:27:33",
                "url": "https://files.pythonhosted.org/packages/8c/cd/ce6b9079d9fca28b6530fd59101fdb5c62bc9e509ce342cd3f1bf778ad6a/odbctools-0.5.0-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "83d1a24459f523071df0597d56cc4cca",
                    "sha256": "cb55b2564738152d13891fd7099019a9e48a5a9cc4fc54606290e76c0635583a"
                },
                "downloads": -1,
                "filename": "odbctools-0.5.0.tar.gz",
                "has_sig": false,
                "md5_digest": "83d1a24459f523071df0597d56cc4cca",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 4619,
                "upload_time": "2018-10-11T16:27:34",
                "url": "https://files.pythonhosted.org/packages/8d/13/403e1f5cda01c749fc95639c6c215470ab1ff18824152c93c50f20babd8a/odbctools-0.5.0.tar.gz"
            }
        ],
        "0.5.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "bf63925ad9e49959580adb6da81fe0b6",
                    "sha256": "819ad61d73c2c263f325e190da3ac2b8796a2465297a8054a004be95c9b1f18f"
                },
                "downloads": -1,
                "filename": "odbctools-0.5.1-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "bf63925ad9e49959580adb6da81fe0b6",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 5874,
                "upload_time": "2018-11-27T19:20:29",
                "url": "https://files.pythonhosted.org/packages/6b/70/3a2eebea5254095971d8be9eada59a6dd5d1e89eb92897a8c4d26c77ee93/odbctools-0.5.1-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "5f3876f3ca16d48923948456350859f4",
                    "sha256": "29d498520e665d7c817b055547c98b15d0d8ed5bd1c285ea1cf439b8187576d2"
                },
                "downloads": -1,
                "filename": "odbctools-0.5.1.tar.gz",
                "has_sig": false,
                "md5_digest": "5f3876f3ca16d48923948456350859f4",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 4698,
                "upload_time": "2018-11-27T19:20:30",
                "url": "https://files.pythonhosted.org/packages/d6/e5/693ddca63714a642255b8b664329e808680033df3b4aa280e72e7f3ae2e2/odbctools-0.5.1.tar.gz"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "bf63925ad9e49959580adb6da81fe0b6",
                "sha256": "819ad61d73c2c263f325e190da3ac2b8796a2465297a8054a004be95c9b1f18f"
            },
            "downloads": -1,
            "filename": "odbctools-0.5.1-py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "bf63925ad9e49959580adb6da81fe0b6",
            "packagetype": "bdist_wheel",
            "python_version": "py3",
            "requires_python": null,
            "size": 5874,
            "upload_time": "2018-11-27T19:20:29",
            "url": "https://files.pythonhosted.org/packages/6b/70/3a2eebea5254095971d8be9eada59a6dd5d1e89eb92897a8c4d26c77ee93/odbctools-0.5.1-py3-none-any.whl"
        },
        {
            "comment_text": "",
            "digests": {
                "md5": "5f3876f3ca16d48923948456350859f4",
                "sha256": "29d498520e665d7c817b055547c98b15d0d8ed5bd1c285ea1cf439b8187576d2"
            },
            "downloads": -1,
            "filename": "odbctools-0.5.1.tar.gz",
            "has_sig": false,
            "md5_digest": "5f3876f3ca16d48923948456350859f4",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 4698,
            "upload_time": "2018-11-27T19:20:30",
            "url": "https://files.pythonhosted.org/packages/d6/e5/693ddca63714a642255b8b664329e808680033df3b4aa280e72e7f3ae2e2/odbctools-0.5.1.tar.gz"
        }
    ]
}