{ "info": { "author": "Joseph Wortmann", "author_email": "joseph.wortmann@gmail.com", "bugtrack_url": null, "classifiers": [ "Development Status :: 3 - Alpha", "Intended Audience :: Developers", "License :: OSI Approved :: Apache Software License", "Programming Language :: Python :: 2.7", "Topic :: System :: Software Distribution" ], "description": "redshiftsql\n===========\n\nA simple command line batch processing tool for Redshift SQL\n^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n\nThis tool accepts either a Redshift username and password OR an AWS\nAccess Key ID and Secret Key.\n\nIf you use the IAM Access/Secret method, the user that you are\nreferencing MUST have the correct policy to get temporary credentials\nfrom the database. For example:\n\n::\n\n {\n \"Version\": \"2012-10-17\",\n \"Statement\": {\n \"Effect\": \"Allow\",\n \"Action\": \"redshift:GetClusterCredentials\",\n \"Resource\": [\n \"arn:aws:redshift:us-west-2:123456789012:dbuser:examplecluster/temp_creds_user\",\n \"arn:aws:redshift:us-west-2:123456789012:dbname:examplecluster/dev_database\"\n ]\n }\n }\n\nUsage\n~~~~~\n\n::\n\n python -m redshiftsql host dbname user file --password password --port port\n\n**OR**\n\n::\n\n python -m redshiftsql host dbname user file --aws-access-key-id aws-access-key-id --aws-secret-key aws-secret-key --cluster-name cluster-name --port port\n\nArguments\n~~~~~~~~~\n\n- **host** The Redshift endpoint, minus the port\n- **dbname** The Redshift database to connect to\n- **user** The Redshift user\n- **password** The Redshift password. Ignored if **aws-access-key-id**\n is present\n- **port** The port on the **host**. Defaults to *5439*\n- **region** The region that the Redshift cluster is in. Defaults to\n *us-east-1*\n- **file** The file to read the SQL commands from\n- **aws-access-key-id** The AWS Access Key ID for the IAM user to\n obtain temporary credentials\n- **aws-secret-key** The AWS Secret Key for the IAM user to obtain\n temporary credentials\n- **cluster-name** The Redshift cluster name to obtain temporary\n credentials from\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/QuiNovas/redshiftsql", "keywords": "quinovas", "license": "APL 2.0", "maintainer": "", "maintainer_email": "", "name": "redshiftsql", "package_url": "https://pypi.org/project/redshiftsql/", "platform": "", "project_url": "https://pypi.org/project/redshiftsql/", "project_urls": { "Homepage": "https://github.com/QuiNovas/redshiftsql" }, "release_url": "https://pypi.org/project/redshiftsql/0.0.7/", "requires_dist": [ "argparse", "boto3", "psycopg2-binary" ], "requires_python": "", "summary": "Executes SQL commands from STDIN in a single transaction", "version": "0.0.7" }, "last_serial": 3673868, "releases": { "0.0.1": [ { "comment_text": "", "digests": { "md5": "8fd7e4d833edf9be23b9c22d00208e47", "sha256": "1be6aeaa8edf52ffb67cb603b2df0c5f9bddf3c45899f14a7124126bc7acdc89" }, "downloads": -1, "filename": "redshiftsql-0.0.1-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "8fd7e4d833edf9be23b9c22d00208e47", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 5182, "upload_time": "2018-03-14T01:35:44", "url": "https://files.pythonhosted.org/packages/63/9d/ab78e07f71d5c980bd19ebed18ce571a9935593b2d61879b7a2ef9a53063/redshiftsql-0.0.1-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "e681a0751ecf94f11cc82c39c11c5b70", "sha256": "6ed38597a8c033c35f5dc6b691e937b25c9b024bfc5d490ee59dcc612cad345c" }, "downloads": -1, "filename": "redshiftsql-0.0.1.tar.gz", "has_sig": false, "md5_digest": "e681a0751ecf94f11cc82c39c11c5b70", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3830, "upload_time": "2018-03-14T01:35:45", "url": "https://files.pythonhosted.org/packages/25/ea/5149b166de92333482d98cecb7968ab4e414b6f4c729d60b14f904733118/redshiftsql-0.0.1.tar.gz" } ], "0.0.2": [ { "comment_text": "", "digests": { "md5": "f2d79102d5c1a8d7c4432b19a1176bbf", "sha256": "4715e2621680a3ebc239ad27c3387475b413fc62361b302ea07eee2e49298419" }, "downloads": -1, "filename": "redshiftsql-0.0.2-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "f2d79102d5c1a8d7c4432b19a1176bbf", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 5199, "upload_time": "2018-03-14T20:34:31", "url": "https://files.pythonhosted.org/packages/52/e5/319e15dba66f24a6fbdc6a1a5e5b83b526b9994004975598169c047bff82/redshiftsql-0.0.2-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "018bcd7212a85e88858ab93cc1321ff7", "sha256": "145d21eddacbdb3703251091cde652787a4c668eb61c1f99e0e124fd1a536919" }, "downloads": -1, "filename": "redshiftsql-0.0.2.tar.gz", "has_sig": false, "md5_digest": "018bcd7212a85e88858ab93cc1321ff7", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3859, "upload_time": "2018-03-14T20:34:33", "url": "https://files.pythonhosted.org/packages/26/94/96559c1d9ad52631f43ac0385347501a5c5d5897dcaaf4d60d69b3af47a7/redshiftsql-0.0.2.tar.gz" } ], "0.0.3": [ { "comment_text": "", "digests": { "md5": "9e704c83b3ac5356e8bb000f7621c8c8", "sha256": "a5095cb6278a4c1b59e199f6d797a9b940ef85af3544690d0667febe4a891cea" }, "downloads": -1, "filename": "redshiftsql-0.0.3-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "9e704c83b3ac5356e8bb000f7621c8c8", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 5212, "upload_time": "2018-03-14T21:32:26", "url": "https://files.pythonhosted.org/packages/f2/58/f081cf58521db31d317b9328710f35f69b45d862bae156eedfd48a624fcb/redshiftsql-0.0.3-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "8f5b066719ca4e2564a559198993d143", "sha256": "cd6218c74dcdd8b5b782140d0546d22f4931be6b3529f1a469e3c060e1991930" }, "downloads": -1, "filename": "redshiftsql-0.0.3.tar.gz", "has_sig": false, "md5_digest": "8f5b066719ca4e2564a559198993d143", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3819, "upload_time": "2018-03-14T21:32:27", "url": "https://files.pythonhosted.org/packages/57/c4/98733771bab9a6bfb26a9a6dd17afa1a294dc1ba2ef24cc617f70a53851e/redshiftsql-0.0.3.tar.gz" } ], "0.0.4": [ { "comment_text": "", "digests": { "md5": "cb9ab8a388187ae404413475e9bd4e80", "sha256": "b1d2bbaed87089e1276ac0c19248a39d3849253ef8fb7c511a05d69e256f53fe" }, "downloads": -1, "filename": "redshiftsql-0.0.4-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "cb9ab8a388187ae404413475e9bd4e80", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 5315, "upload_time": "2018-03-15T07:18:46", "url": "https://files.pythonhosted.org/packages/1f/e0/ef4e5a2c8bf2e36ba64af59937bd8077a8604940dc9e16e7de9cbc1c82e5/redshiftsql-0.0.4-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "615fab93d25d129f75c40da48eb63240", "sha256": "4c7fb863541df478da57835d1142100bdff1f2e7175ed2beb0ee411ddf6db40e" }, "downloads": -1, "filename": "redshiftsql-0.0.4.tar.gz", "has_sig": false, "md5_digest": "615fab93d25d129f75c40da48eb63240", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3935, "upload_time": "2018-03-15T07:18:46", "url": "https://files.pythonhosted.org/packages/cf/c5/fc5aa7cb6a436e2e40faf7fc03fb5bbca999fbf00316f54dbdb72052c07b/redshiftsql-0.0.4.tar.gz" } ], "0.0.5": [ { "comment_text": "", "digests": { "md5": "72782e9178a7e48474456e69d38944d0", "sha256": "b645434b017c6280edbaa1460ac1c3d526ba14569393800c68ba5e32acf71df9" }, "downloads": -1, "filename": "redshiftsql-0.0.5-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "72782e9178a7e48474456e69d38944d0", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 5426, "upload_time": "2018-03-15T19:15:38", "url": "https://files.pythonhosted.org/packages/6e/4b/6395b42a317183de41b02bf10a2fd1f3edaccc95749b0a24510674157dfc/redshiftsql-0.0.5-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "e3e5053d3518ec2fbd6434e294576c01", "sha256": "c967a6e5479c51f156e61399700b2d0beb353f6d0988c8093c1974c890659339" }, "downloads": -1, "filename": "redshiftsql-0.0.5.tar.gz", "has_sig": false, "md5_digest": "e3e5053d3518ec2fbd6434e294576c01", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4027, "upload_time": "2018-03-15T19:15:40", "url": "https://files.pythonhosted.org/packages/35/69/f1e2712c501c09fdc45a27aee0c1cdbe6c2942e0cc66d2b58b7381b0c3de/redshiftsql-0.0.5.tar.gz" } ], "0.0.6": [ { "comment_text": "", "digests": { "md5": "d6079be5abd13690b8b4b0663a5ac634", "sha256": "6653d610116c9e42e522406aa52c1ea775383d2e2a595b18c6b04a58daa38c45" }, "downloads": -1, "filename": "redshiftsql-0.0.6-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "d6079be5abd13690b8b4b0663a5ac634", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 5445, "upload_time": "2018-03-15T19:28:05", "url": "https://files.pythonhosted.org/packages/96/4c/0857741f996713a03ba282ee893da43c2250a35e1e81147e1f87e2ce7433/redshiftsql-0.0.6-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "a390ef33535cfc340c7421c85f4c0c13", "sha256": "b7072cc58a8936c5b0d570856940ccad1d850e2bf39d4b8958ffb2209ee073e0" }, "downloads": -1, "filename": "redshiftsql-0.0.6.tar.gz", "has_sig": false, "md5_digest": "a390ef33535cfc340c7421c85f4c0c13", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4003, "upload_time": "2018-03-15T19:28:06", "url": "https://files.pythonhosted.org/packages/f9/bb/f0f9e2429fd1dac20b30b369e23c8943b24c65d46fe616e3536149925202/redshiftsql-0.0.6.tar.gz" } ], "0.0.7": [ { "comment_text": "", "digests": { "md5": "d5d883a4d8b31c4ec0d6ff0543d4f9a6", "sha256": "83a29ed0fa71da9d6c54c1199687440b6a5b57cfe2646e7587d98b64997d47c1" }, "downloads": -1, "filename": "redshiftsql-0.0.7-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "d5d883a4d8b31c4ec0d6ff0543d4f9a6", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 5397, "upload_time": "2018-03-15T19:36:06", "url": "https://files.pythonhosted.org/packages/90/66/999d0edd5495059b0549ca31649c2cac17eb2191d7b7489291ce2b69a0c6/redshiftsql-0.0.7-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "2a8b9fee4b7d5ddc8c30bb0a69b733cb", "sha256": "ba8c0f6a8b9d222719172d76714040b3d7ef6c22e3ff3ba5f0c2bf4712ddf51d" }, "downloads": -1, "filename": "redshiftsql-0.0.7.tar.gz", "has_sig": false, "md5_digest": "2a8b9fee4b7d5ddc8c30bb0a69b733cb", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3973, "upload_time": "2018-03-15T19:36:07", "url": "https://files.pythonhosted.org/packages/7a/40/db5c942a00f36c329086d6d6c0b63712b6f0f53e255eea2a90397cd5cafa/redshiftsql-0.0.7.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "d5d883a4d8b31c4ec0d6ff0543d4f9a6", "sha256": "83a29ed0fa71da9d6c54c1199687440b6a5b57cfe2646e7587d98b64997d47c1" }, "downloads": -1, "filename": "redshiftsql-0.0.7-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "d5d883a4d8b31c4ec0d6ff0543d4f9a6", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 5397, "upload_time": "2018-03-15T19:36:06", "url": "https://files.pythonhosted.org/packages/90/66/999d0edd5495059b0549ca31649c2cac17eb2191d7b7489291ce2b69a0c6/redshiftsql-0.0.7-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "2a8b9fee4b7d5ddc8c30bb0a69b733cb", "sha256": "ba8c0f6a8b9d222719172d76714040b3d7ef6c22e3ff3ba5f0c2bf4712ddf51d" }, "downloads": -1, "filename": "redshiftsql-0.0.7.tar.gz", "has_sig": false, "md5_digest": "2a8b9fee4b7d5ddc8c30bb0a69b733cb", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3973, "upload_time": "2018-03-15T19:36:07", "url": "https://files.pythonhosted.org/packages/7a/40/db5c942a00f36c329086d6d6c0b63712b6f0f53e255eea2a90397cd5cafa/redshiftsql-0.0.7.tar.gz" } ] }