{
    "info": {
        "author": "Jonas H\u00f6rsch",
        "author_email": "coroa@posteo.de",
        "bugtrack_url": null,
        "classifiers": [
            "Development Status :: 3 - Alpha",
            "Intended Audience :: Developers",
            "License :: OSI Approved :: MIT License",
            "Programming Language :: Python :: 3",
            "Programming Language :: Python :: 3.4",
            "Programming Language :: Python :: 3.5",
            "Programming Language :: Python :: 3.6",
            "Programming Language :: Python :: 3.7",
            "Topic :: Software Development :: Build Tools"
        ],
        "description": "# SQLAlchemyIO (saio)\n\nModule hack for autoloading table definitions.\n\nAlso provides a helper function `as_pandas` to read an `sqlalchemy.orm.query.Query` into a (Geo)Pandas dataframe.\n\n## Usage\n\nAfter\n```python\nimport saio\nsaio.register_schema(\"model_draft\", engine)\n````\none can import table declarations easily using\n```python\nfrom saio.model_draft import lis_charging_poi as LisChargingPoi\n```\n\nNote that `ipython` and Jupyter Notebook, allow using `<TAB>` to auto-complete\ntable names.\n\nThe helper function `as_pandas` reads a query into a GeoDataFrame:\n```python\nsaio.register_schema(\"boundaries\", engine)\n\nfrom saio.boundaries import bkg_vg250_2_lan as BkgLan\ndf = saio.as_pandas(session.query(BkgLan))\ndf.plot()\n```\n\n## Installation\n\nUntil we decide to register this package with pypi and/or conda-forge, please install it directly from git using pip:\n```python\npip install git+https://github.com/coroa/saio.git#egg=saio\n```\nor add it to the environment.yaml file you are working with as\n```yaml\nname: ...\nchannels:\n  - [ ... ]\ndependencies:\n  -  [ ... ]\n  - pip:\n    - [ ... ]\n    - git+https://github.com/coroa/saio.git#egg=saio\n```\n\n## Implementation details\n\n`saio.register_schema` instantiates a declarative base using\n```python\nfrom sqlalchemy.ext.declarative import declarative_base\nBase = declarative_base(bind=engine)\n# The Base can be imported using from saio.model_draft import Base\n```\nand then whenever one imports any table from `saio.model_draft`, ie. by calling\n`from saio.model_draft import lis_charging_poi as LisChargingPoi`, saio does\napproximately\n```python\nclass LisChargingPoi(Base):\n    __tablename__ =  'lis_charging_poi'\n    __table_args__ = {'schema': 'model_draft', 'autoload': True}\n```\n\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/coroa/saio",
        "keywords": "",
        "license": "",
        "maintainer": "",
        "maintainer_email": "",
        "name": "saio",
        "package_url": "https://pypi.org/project/saio/",
        "platform": "",
        "project_url": "https://pypi.org/project/saio/",
        "project_urls": {
            "Bug Reports": "https://github.com/coroa/saio/issues",
            "Homepage": "https://github.com/coroa/saio",
            "Source": "https://github.com/coroa/saio/"
        },
        "release_url": "https://pypi.org/project/saio/0.2/",
        "requires_dist": [
            "sqlalchemy"
        ],
        "requires_python": ">=3.4, <4",
        "summary": "SQLAlchemyIO (saio): Module hack for autoloading table definitions",
        "version": "0.2"
    },
    "last_serial": 5106780,
    "releases": {
        "0.2": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "7ad97d17f0149f598750ba6b68cfa230",
                    "sha256": "d7a248ec5bf0ca1892f48c05c04ec711589011858b760295eecc625accc62617"
                },
                "downloads": -1,
                "filename": "saio-0.2-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "7ad97d17f0149f598750ba6b68cfa230",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": ">=3.4, <4",
                "size": 4994,
                "upload_time": "2019-04-06T08:17:53",
                "url": "https://files.pythonhosted.org/packages/69/70/0085d8dd4b5fd84a527ef37705d706230696eda4765b09e2666bf456f3a8/saio-0.2-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "cbc4c537df17c4d53c8b760a9f0f267d",
                    "sha256": "b43373d2b84e524126faf1c62318d4da20becd4329021b9d7cdf32ba98a1449f"
                },
                "downloads": -1,
                "filename": "saio-0.2.tar.gz",
                "has_sig": false,
                "md5_digest": "cbc4c537df17c4d53c8b760a9f0f267d",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": ">=3.4, <4",
                "size": 4837,
                "upload_time": "2019-04-06T08:17:56",
                "url": "https://files.pythonhosted.org/packages/28/3e/a3196723da50696486836f467f05195a4f78f3c73fc877cc9df28d40ea28/saio-0.2.tar.gz"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "7ad97d17f0149f598750ba6b68cfa230",
                "sha256": "d7a248ec5bf0ca1892f48c05c04ec711589011858b760295eecc625accc62617"
            },
            "downloads": -1,
            "filename": "saio-0.2-py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "7ad97d17f0149f598750ba6b68cfa230",
            "packagetype": "bdist_wheel",
            "python_version": "py3",
            "requires_python": ">=3.4, <4",
            "size": 4994,
            "upload_time": "2019-04-06T08:17:53",
            "url": "https://files.pythonhosted.org/packages/69/70/0085d8dd4b5fd84a527ef37705d706230696eda4765b09e2666bf456f3a8/saio-0.2-py3-none-any.whl"
        },
        {
            "comment_text": "",
            "digests": {
                "md5": "cbc4c537df17c4d53c8b760a9f0f267d",
                "sha256": "b43373d2b84e524126faf1c62318d4da20becd4329021b9d7cdf32ba98a1449f"
            },
            "downloads": -1,
            "filename": "saio-0.2.tar.gz",
            "has_sig": false,
            "md5_digest": "cbc4c537df17c4d53c8b760a9f0f267d",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": ">=3.4, <4",
            "size": 4837,
            "upload_time": "2019-04-06T08:17:56",
            "url": "https://files.pythonhosted.org/packages/28/3e/a3196723da50696486836f467f05195a4f78f3c73fc877cc9df28d40ea28/saio-0.2.tar.gz"
        }
    ]
}