{
    "info": {
        "author": "Aaron Biller",
        "author_email": "aaronbiller@gmail.com",
        "bugtrack_url": null,
        "classifiers": [
            "Development Status :: 3 - Alpha",
            "Intended Audience :: Developers",
            "License :: OSI Approved :: MIT License",
            "Programming Language :: Python :: 2",
            "Programming Language :: Python :: 2.7",
            "Programming Language :: Python :: 3",
            "Programming Language :: Python :: 3.6",
            "Programming Language :: Python :: 3.7",
            "Topic :: Database",
            "Topic :: Utilities"
        ],
        "description": "# Spackl\nAbstracting data source idiosyncrasies so you can stop reading Q&A forums and start reading your data.\n\n## Installation\n```\npip install spackl\n```\n\n## Usage Overview\n#### Query Data\n```python\nfrom spackl import db, file\n\nconf = db.Config()\n\npg = db.Postgres(**conf.default)\nbq = db.BigQuery(**conf.bq_datalake)\ncsv = file.CSV('/path/to/file.csv')\n\n# Same method for all sources\npg_results = pg.query('SELECT id FROM schema.some_table')\nbq_results = bq.query('SELECT id FROM dataset.some_table')\ncsv_results = csv.query()\n```\n\n#### Access Query Results\n_by index_\n```python\nresults[0]\n# (1234,)\n```\n\n_by attribute_\n```python\nresults.id\n# (1234, 1235, 1236)\n```\n\n_by key_\n```python\nresults['id']\n# (1234, 1235, 1236)\n```\n\n_index by index_\n```python\nresults[0][0]\n# 1234\n```\n\n_attribute by index_\n```python\nresults.id[0]\n# 1234\n```\n\n_key by index_\n```python\nresults['id'][0]\n# 1234\n```\n\n_index by attribute_\n```python\nresults[0].id\n# 1234\n```\n\n_index by key_\n```python\nresults[0]['id']\n# 1234\n```\n\n#### Other Data Formats\n```python\n# Pandas Dataframe\nresults.df()\n\n# JSON String\nresults.json()\n\n# List of tuples\nresults.list()\n\n# Vertical dictionary\nresults.dict()\n```\n\n# CHANGELOG\n\n## 0.1.0 (2019-03-09)\n-  initial release",
        "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/aaronbiller/spackl",
        "keywords": "utility query database csv file",
        "license": "MIT",
        "maintainer": "",
        "maintainer_email": "",
        "name": "spackl",
        "package_url": "https://pypi.org/project/spackl/",
        "platform": "",
        "project_url": "https://pypi.org/project/spackl/",
        "project_urls": {
            "Homepage": "https://github.com/aaronbiller/spackl"
        },
        "release_url": "https://pypi.org/project/spackl/0.1.0/",
        "requires_dist": null,
        "requires_python": "",
        "summary": "Utility for unified querying across data sources",
        "version": "0.1.0"
    },
    "last_serial": 4918037,
    "releases": {
        "0.1.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "b7abfe96cd305ebb186ac5780faf34af",
                    "sha256": "1b3d5c0d9170ad45d4fb0aa1b7b84b9176f31119537829df8ec8ff7999cfef8c"
                },
                "downloads": -1,
                "filename": "spackl-0.1.0-py2.7.egg",
                "has_sig": false,
                "md5_digest": "b7abfe96cd305ebb186ac5780faf34af",
                "packagetype": "bdist_egg",
                "python_version": "2.7",
                "requires_python": null,
                "size": 34463,
                "upload_time": "2019-03-09T05:23:03",
                "url": "https://files.pythonhosted.org/packages/fa/56/83e1c120f8ed48592bab8f6aad8a238995cec92fc0d5b5ba48fa140b5e01/spackl-0.1.0-py2.7.egg"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "5b7e7b7d2c43607c4557fca31f506e6e",
                    "sha256": "e35a22508e8fd1365b1dad834ee2219328b51cb37be94c9963f0c1ae4676353e"
                },
                "downloads": -1,
                "filename": "spackl-0.1.0-py3.6.egg",
                "has_sig": false,
                "md5_digest": "5b7e7b7d2c43607c4557fca31f506e6e",
                "packagetype": "bdist_egg",
                "python_version": "3.6",
                "requires_python": null,
                "size": 35496,
                "upload_time": "2019-03-09T05:23:05",
                "url": "https://files.pythonhosted.org/packages/e7/92/2177eb783741f574bd5c93826f3b308ac8c03f149c06baeefd9349c47015/spackl-0.1.0-py3.6.egg"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "aaa5fb8f6d1e7a710a005f477f8d7cce",
                    "sha256": "3096e751d1ce27be8a5c6312b48f7ecb2bdc765a5898f86e125ef847be9af8ae"
                },
                "downloads": -1,
                "filename": "spackl-0.1.0-py3.7.egg",
                "has_sig": false,
                "md5_digest": "aaa5fb8f6d1e7a710a005f477f8d7cce",
                "packagetype": "bdist_egg",
                "python_version": "3.7",
                "requires_python": null,
                "size": 35598,
                "upload_time": "2019-03-09T05:23:06",
                "url": "https://files.pythonhosted.org/packages/e7/c5/eb8fb3a88a9cc3ed71ed19c4e2c24edb1f74128d5ebbc4706dfcd6171635/spackl-0.1.0-py3.7.egg"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "5a2bbc0b2776e0127f10ed78348f13a3",
                    "sha256": "43b552d0dc39d7a3a7fb7bf36f5db475b5f5311232965e39b3004dad57f89283"
                },
                "downloads": -1,
                "filename": "spackl-0.1.0.tar.gz",
                "has_sig": false,
                "md5_digest": "5a2bbc0b2776e0127f10ed78348f13a3",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 11778,
                "upload_time": "2019-03-09T05:23:08",
                "url": "https://files.pythonhosted.org/packages/4f/60/76d7352fd6d3b3f440f9a1aa8642585e231f8669a84f5bc5e537ef905d8a/spackl-0.1.0.tar.gz"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "b7abfe96cd305ebb186ac5780faf34af",
                "sha256": "1b3d5c0d9170ad45d4fb0aa1b7b84b9176f31119537829df8ec8ff7999cfef8c"
            },
            "downloads": -1,
            "filename": "spackl-0.1.0-py2.7.egg",
            "has_sig": false,
            "md5_digest": "b7abfe96cd305ebb186ac5780faf34af",
            "packagetype": "bdist_egg",
            "python_version": "2.7",
            "requires_python": null,
            "size": 34463,
            "upload_time": "2019-03-09T05:23:03",
            "url": "https://files.pythonhosted.org/packages/fa/56/83e1c120f8ed48592bab8f6aad8a238995cec92fc0d5b5ba48fa140b5e01/spackl-0.1.0-py2.7.egg"
        },
        {
            "comment_text": "",
            "digests": {
                "md5": "5b7e7b7d2c43607c4557fca31f506e6e",
                "sha256": "e35a22508e8fd1365b1dad834ee2219328b51cb37be94c9963f0c1ae4676353e"
            },
            "downloads": -1,
            "filename": "spackl-0.1.0-py3.6.egg",
            "has_sig": false,
            "md5_digest": "5b7e7b7d2c43607c4557fca31f506e6e",
            "packagetype": "bdist_egg",
            "python_version": "3.6",
            "requires_python": null,
            "size": 35496,
            "upload_time": "2019-03-09T05:23:05",
            "url": "https://files.pythonhosted.org/packages/e7/92/2177eb783741f574bd5c93826f3b308ac8c03f149c06baeefd9349c47015/spackl-0.1.0-py3.6.egg"
        },
        {
            "comment_text": "",
            "digests": {
                "md5": "aaa5fb8f6d1e7a710a005f477f8d7cce",
                "sha256": "3096e751d1ce27be8a5c6312b48f7ecb2bdc765a5898f86e125ef847be9af8ae"
            },
            "downloads": -1,
            "filename": "spackl-0.1.0-py3.7.egg",
            "has_sig": false,
            "md5_digest": "aaa5fb8f6d1e7a710a005f477f8d7cce",
            "packagetype": "bdist_egg",
            "python_version": "3.7",
            "requires_python": null,
            "size": 35598,
            "upload_time": "2019-03-09T05:23:06",
            "url": "https://files.pythonhosted.org/packages/e7/c5/eb8fb3a88a9cc3ed71ed19c4e2c24edb1f74128d5ebbc4706dfcd6171635/spackl-0.1.0-py3.7.egg"
        },
        {
            "comment_text": "",
            "digests": {
                "md5": "5a2bbc0b2776e0127f10ed78348f13a3",
                "sha256": "43b552d0dc39d7a3a7fb7bf36f5db475b5f5311232965e39b3004dad57f89283"
            },
            "downloads": -1,
            "filename": "spackl-0.1.0.tar.gz",
            "has_sig": false,
            "md5_digest": "5a2bbc0b2776e0127f10ed78348f13a3",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 11778,
            "upload_time": "2019-03-09T05:23:08",
            "url": "https://files.pythonhosted.org/packages/4f/60/76d7352fd6d3b3f440f9a1aa8642585e231f8669a84f5bc5e537ef905d8a/spackl-0.1.0.tar.gz"
        }
    ]
}