{
    "info": {
        "author": "Jonathan",
        "author_email": "",
        "bugtrack_url": null,
        "classifiers": [
            "License :: OSI Approved :: MIT License",
            "Operating System :: OS Independent",
            "Programming Language :: Python :: 3"
        ],
        "description": "## Connectivator\n\nSet of wrapper functions to abstract repetitive tasks such as reading data from a Redshift/postgres databases, and writing their contents to a CSV or Google sheet. The lack of flexibility is done on purpose to simplify and standardize importing/exporting procedures. For more flexibility, simply use the original packages these wrapper functions were built upon, i.e. pandas, gspread, etc.\n\n### Current State\n\n* Connect to Postgres / Redshift: `postgres.get_engine`\n* Read output of a sql query into a data frame: `transfer.read_sql_data`\n* Write output of SQL files to CSV: `transfer.sqls_to_csv`\n* Read contents of a Google sheet into a data frame: `gsheets.get_ws_data`\n* Update contents of a Google sheet using a data frame: `gsheets.update_ws`\n* Write output of SQL files to Google sheet: `transfer.sqls_to_gs`\n\n### Environment Variables\n\n* Add a `.env` file to the project root directory.\n* Add the following environment variables, replacing with values relevant for your connections. Format:\n\n**Postgres/Redshift Environment Variables**\n\n```\nexport PGHOST = instance-name.abc123.us-east-1.redshift.amazonaws.com\nexport PGPORT = 5439\nexport PGUSER = your_user_name\nexport PGPASSWORD = your_password\n```\n\n* Load the environment variables before running the script. For example, by running `source .env` in the terminal you are using to run Python scripts.\n\n**Google Sheets Credient File and Environment Variable**\n\nRequires a json credentials file, which can be downloaded when creating a service account within a Google developer console project. The Google Sheets API enabled also must be enabled. See: https://developers.google.com/sheets/api/quickstart/python\n\nAlso, the google sheet to be modified needs to give access to the Service Account. To do so, find the email associated to the service account under Credentials >> Manage Service Accounts of the Google Console project. Then go to the google sheet to be modified and allow edit access to this email.\n\n```\nexport GOOGLE_APPLICATION_CREDENTIALS=\"filepath/to.json\"\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/jonathan-marsan/connectivator",
        "keywords": "",
        "license": "",
        "maintainer": "",
        "maintainer_email": "",
        "name": "connectivator",
        "package_url": "https://pypi.org/project/connectivator/",
        "platform": "",
        "project_url": "https://pypi.org/project/connectivator/",
        "project_urls": {
            "Homepage": "https://github.com/jonathan-marsan/connectivator"
        },
        "release_url": "https://pypi.org/project/connectivator/0.0.7/",
        "requires_dist": [
            "pandas",
            "SQLAlchemy",
            "psycopg2",
            "gspread",
            "gspread-dataframe",
            "oauth2client"
        ],
        "requires_python": "",
        "summary": "Simple wrapper functions for connecting to and loading data",
        "version": "0.0.7"
    },
    "last_serial": 4679379,
    "releases": {
        "0.0.4": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "8ed8520f809aa24ad0f3706275b5d9aa",
                    "sha256": "902246f4db2553161732ccf3cd8995f65588b0ec2934a6e0b412e7feb5c49c8b"
                },
                "downloads": -1,
                "filename": "connectivator-0.0.4-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "8ed8520f809aa24ad0f3706275b5d9aa",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 4711,
                "upload_time": "2019-01-10T03:10:41",
                "url": "https://files.pythonhosted.org/packages/9d/b8/24b3c397bd9fa8dc92a12bc8892e76fd68c205ed894449c92e97760ffe2b/connectivator-0.0.4-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "5384502b5bd6c08a8b7042d771c47e2f",
                    "sha256": "e061ffefb27312161e6729029c5adfefa87bf0be3dd7bda1fb7bdb11cd3e6d9c"
                },
                "downloads": -1,
                "filename": "connectivator-0.0.4.tar.gz",
                "has_sig": false,
                "md5_digest": "5384502b5bd6c08a8b7042d771c47e2f",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 2996,
                "upload_time": "2019-01-10T03:10:47",
                "url": "https://files.pythonhosted.org/packages/1e/56/bc26531f32ae2979276fc50081391baf758f6d3e469de1dbb8c5c09b6afc/connectivator-0.0.4.tar.gz"
            }
        ],
        "0.0.5": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "6888c3558f773c1344be76eb9417b059",
                    "sha256": "d8406da1303d0fb056ddba249274e2a1c4de324e0169918a8b4c98e1b3380cf6"
                },
                "downloads": -1,
                "filename": "connectivator-0.0.5-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "6888c3558f773c1344be76eb9417b059",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 5055,
                "upload_time": "2019-01-10T03:10:43",
                "url": "https://files.pythonhosted.org/packages/5b/c0/d9ccd3189fcb506c447d1e1b648b2cce81f2b6ba392fa325abded6209b11/connectivator-0.0.5-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "26ff1379492dc517ad1ab9c3e70dac86",
                    "sha256": "160fb14c3d157a82975641eda9340572b8b673644c90c20fa78f3b56e4d592e5"
                },
                "downloads": -1,
                "filename": "connectivator-0.0.5.tar.gz",
                "has_sig": false,
                "md5_digest": "26ff1379492dc517ad1ab9c3e70dac86",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 3316,
                "upload_time": "2019-01-10T03:10:48",
                "url": "https://files.pythonhosted.org/packages/c5/e3/1038870ce7a7ec9f2a64bbcad75a2355ba88c05cef89dea90932b76b4bab/connectivator-0.0.5.tar.gz"
            }
        ],
        "0.0.6": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "c5fc464d2fc74782c81d56d68eaa1d83",
                    "sha256": "684af339f6277bc53271b0efb758f5900118fcb992d2c7fea609e62cfa6793f6"
                },
                "downloads": -1,
                "filename": "connectivator-0.0.6-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "c5fc464d2fc74782c81d56d68eaa1d83",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 5362,
                "upload_time": "2019-01-10T03:10:45",
                "url": "https://files.pythonhosted.org/packages/ab/eb/16fa9ed9a79f8c93537ce2788ca26592393f16edbde202234cce7f13b21e/connectivator-0.0.6-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "46d41868a0e010247eaa4608c2a15259",
                    "sha256": "4e79de3631c85b58014b1e23e13db7b6d245976a9c33b9e58c0b620562b7067a"
                },
                "downloads": -1,
                "filename": "connectivator-0.0.6.tar.gz",
                "has_sig": false,
                "md5_digest": "46d41868a0e010247eaa4608c2a15259",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 3589,
                "upload_time": "2019-01-10T03:10:50",
                "url": "https://files.pythonhosted.org/packages/28/74/dc15e1d370ded52ed6b1342c5f6c176d7c527bc5dcfddbcd5c2cb104ee37/connectivator-0.0.6.tar.gz"
            }
        ],
        "0.0.7": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "8b977b7e3870894cf8e011ff3369f9f9",
                    "sha256": "4e4172c2e21eaed45abb275b549637755fc4743148bf62a7413bb8a7f000a91b"
                },
                "downloads": -1,
                "filename": "connectivator-0.0.7-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "8b977b7e3870894cf8e011ff3369f9f9",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 5377,
                "upload_time": "2019-01-10T03:10:46",
                "url": "https://files.pythonhosted.org/packages/5b/4e/6e84655e1c0c727943c5481a274fd4d73260989e1e16b5dc3459b80c9ae6/connectivator-0.0.7-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "154334005143a2e2daeeb108ce2776c8",
                    "sha256": "cff655132e877d87147e2d5de189fd54f0cd58f7bcb9d919f1c17bef10526c5d"
                },
                "downloads": -1,
                "filename": "connectivator-0.0.7.tar.gz",
                "has_sig": false,
                "md5_digest": "154334005143a2e2daeeb108ce2776c8",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 3610,
                "upload_time": "2019-01-10T03:10:51",
                "url": "https://files.pythonhosted.org/packages/5e/0e/67bd42d2c3ba40d73a3b32ade53b0a0a70e41cdf89dd69e59e3ba58aa3b0/connectivator-0.0.7.tar.gz"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "8b977b7e3870894cf8e011ff3369f9f9",
                "sha256": "4e4172c2e21eaed45abb275b549637755fc4743148bf62a7413bb8a7f000a91b"
            },
            "downloads": -1,
            "filename": "connectivator-0.0.7-py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "8b977b7e3870894cf8e011ff3369f9f9",
            "packagetype": "bdist_wheel",
            "python_version": "py3",
            "requires_python": null,
            "size": 5377,
            "upload_time": "2019-01-10T03:10:46",
            "url": "https://files.pythonhosted.org/packages/5b/4e/6e84655e1c0c727943c5481a274fd4d73260989e1e16b5dc3459b80c9ae6/connectivator-0.0.7-py3-none-any.whl"
        },
        {
            "comment_text": "",
            "digests": {
                "md5": "154334005143a2e2daeeb108ce2776c8",
                "sha256": "cff655132e877d87147e2d5de189fd54f0cd58f7bcb9d919f1c17bef10526c5d"
            },
            "downloads": -1,
            "filename": "connectivator-0.0.7.tar.gz",
            "has_sig": false,
            "md5_digest": "154334005143a2e2daeeb108ce2776c8",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 3610,
            "upload_time": "2019-01-10T03:10:51",
            "url": "https://files.pythonhosted.org/packages/5e/0e/67bd42d2c3ba40d73a3b32ade53b0a0a70e41cdf89dd69e59e3ba58aa3b0/connectivator-0.0.7.tar.gz"
        }
    ]
}