{
    "info": {
        "author": "Jamie Davis",
        "author_email": "jamjam@umich.edu",
        "bugtrack_url": null,
        "classifiers": [],
        "description": "# Slate DB\nA Python wrapper for executing Slate Custom SQL in Python.\n\n## Installation\nYou must first install the [ODBC Driver for SQL Server](https://docs.microsoft.com/en-us/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-2017).\n\nThen install via pip:\n```\npip install git+https://github.com/jamie-r-davis/slate_db\n```\n\n## Usage\nThe `SlateDB.select` method returns a generator which will yield any records that match your `sql` query. By default, each record is returned as an AttrDict, enabling access via keys or via attributes:\n\n```python\n>>> from slate_db import SlateDB\n>>> db = SlateDB(server='your.server.com',\n                 port=1441,\n                 db='dbname-test',\n                 username='user',\n                 password='secret-password')\n\n# select all records with last name \"Smith\"\n>>> sql = \"\"\"select * from person where last = 'Smith'\"\"\"\n>>> for record in db.select(sql):\n>>>     print(\"Via attribute: {} <{}>\".format(record.name, record.email))\n>>>     print(\"Via key: {} <{}>\".format(record['name'], record['email']])\n# Via attribute: Smith, John <john.smith@example.com>\n# Via key: Smith, John <john.smith@example.com>\n# Via attribute: Smith, Granny <granny.smith@example.com>\n# Via key: Smith, Granny <granny.smith@example.com> \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/jamie-r-davis/slate_db",
        "keywords": "",
        "license": "MIT",
        "maintainer": "",
        "maintainer_email": "",
        "name": "slate-db",
        "package_url": "https://pypi.org/project/slate-db/",
        "platform": "",
        "project_url": "https://pypi.org/project/slate-db/",
        "project_urls": {
            "Homepage": "https://github.com/jamie-r-davis/slate_db"
        },
        "release_url": "https://pypi.org/project/slate-db/0.1.1/",
        "requires_dist": [
            "attrdict",
            "pyodbc"
        ],
        "requires_python": "",
        "summary": "Wrapper for working with Slate databases.",
        "version": "0.1.1"
    },
    "last_serial": 4621413,
    "releases": {
        "0.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "393c031fccb5ee2da0d5769f4a59ffff",
                    "sha256": "09c0c2741097706508afbf89bc6f1ea9016dfdf7053b44a71fe2cad8200574b5"
                },
                "downloads": -1,
                "filename": "slate_db-0.1-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "393c031fccb5ee2da0d5769f4a59ffff",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 3179,
                "upload_time": "2018-12-19T20:38:42",
                "url": "https://files.pythonhosted.org/packages/f5/b7/69cc3e1f54afe72ce6b8f9c002e3d74a4f35be4437d0a6281e1d82940e7f/slate_db-0.1-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "1f411c7bd8ced6fcea1d6b44c743ad79",
                    "sha256": "dc6fc2d8fa0c689ef360f09cdee77e5ad7cdbf1f39541004fca7d394cf1c3357"
                },
                "downloads": -1,
                "filename": "slate_db-0.1.tar.gz",
                "has_sig": false,
                "md5_digest": "1f411c7bd8ced6fcea1d6b44c743ad79",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 2808,
                "upload_time": "2018-12-19T20:38:44",
                "url": "https://files.pythonhosted.org/packages/a2/58/59e581cc5ea3ffde0529ad1e9dc01202b7fb63b3c16e34db7a67dcfb97b4/slate_db-0.1.tar.gz"
            }
        ],
        "0.1.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "24df718715389589f530e7b6cddc01af",
                    "sha256": "ed522042f3721d17ba05db67faede885f7f10ef9aafb745a525dcc1139c0009d"
                },
                "downloads": -1,
                "filename": "slate_db-0.1.1-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "24df718715389589f530e7b6cddc01af",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 3087,
                "upload_time": "2018-12-20T15:46:57",
                "url": "https://files.pythonhosted.org/packages/77/e6/77dcacc02c9f8924f728ecb66bf907bea6f02985f57491c499c00314bc6a/slate_db-0.1.1-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "3023c1785f65bb23a5dadd482b299a2c",
                    "sha256": "ccbd9ca2b603aff9e6466413cd441ea3ef8946c717d01b57cde21f9faea8d4b4"
                },
                "downloads": -1,
                "filename": "slate_db-0.1.1.tar.gz",
                "has_sig": false,
                "md5_digest": "3023c1785f65bb23a5dadd482b299a2c",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 2688,
                "upload_time": "2018-12-20T15:46:58",
                "url": "https://files.pythonhosted.org/packages/e9/ba/714d326b07ecfecfc255ed64678852eec728d016f2901e11baa86fce96e7/slate_db-0.1.1.tar.gz"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "24df718715389589f530e7b6cddc01af",
                "sha256": "ed522042f3721d17ba05db67faede885f7f10ef9aafb745a525dcc1139c0009d"
            },
            "downloads": -1,
            "filename": "slate_db-0.1.1-py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "24df718715389589f530e7b6cddc01af",
            "packagetype": "bdist_wheel",
            "python_version": "py3",
            "requires_python": null,
            "size": 3087,
            "upload_time": "2018-12-20T15:46:57",
            "url": "https://files.pythonhosted.org/packages/77/e6/77dcacc02c9f8924f728ecb66bf907bea6f02985f57491c499c00314bc6a/slate_db-0.1.1-py3-none-any.whl"
        },
        {
            "comment_text": "",
            "digests": {
                "md5": "3023c1785f65bb23a5dadd482b299a2c",
                "sha256": "ccbd9ca2b603aff9e6466413cd441ea3ef8946c717d01b57cde21f9faea8d4b4"
            },
            "downloads": -1,
            "filename": "slate_db-0.1.1.tar.gz",
            "has_sig": false,
            "md5_digest": "3023c1785f65bb23a5dadd482b299a2c",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 2688,
            "upload_time": "2018-12-20T15:46:58",
            "url": "https://files.pythonhosted.org/packages/e9/ba/714d326b07ecfecfc255ed64678852eec728d016f2901e11baa86fce96e7/slate_db-0.1.1.tar.gz"
        }
    ]
}