{ "info": { "author": "Reata", "author_email": "reddevil.hjw@gmail.com", "bugtrack_url": null, "classifiers": [ "Development Status :: 4 - Beta", "License :: OSI Approved :: MIT License", "Operating System :: OS Independent", "Programming Language :: Python :: 3", "Programming Language :: Python :: 3.5", "Programming Language :: Python :: 3.6", "Programming Language :: Python :: 3.7", "Programming Language :: Python :: Implementation :: CPython" ], "description": "# SQLLineage\nSQL Lineage Analysis Tool powered by Python\n\n[![image](https://img.shields.io/pypi/v/sqllineage.svg)](https://pypi.org/project/sqllineage/)\n[![image](https://img.shields.io/pypi/status/sqllineage.svg)](https://pypi.org/project/sqllineage/)\n[![image](https://img.shields.io/pypi/pyversions/sqllineage.svg)](https://pypi.org/project/sqllineage/)\n[![image](https://img.shields.io/pypi/l/sqllineage.svg)](https://pypi.org/project/sqllineage/)\n[![Build Status](https://travis-ci.org/reata/sqllineage.svg?branch=master)](https://travis-ci.org/reata/sqllineage)\n[![Documentation Status](https://readthedocs.org/projects/sqllineage/badge/?version=latest)](https://sqllineage.readthedocs.io/en/latest/?badge=latest)\n[![codecov](https://codecov.io/gh/reata/sqllineage/branch/master/graph/badge.svg)](https://codecov.io/gh/reata/sqllineage)\n\nNever get the hang of a SQL parser? SQLLineage comes to the rescue. Given a SQL command, SQLLineage will tell you its\nsource and target tables, without worrying about Tokens, Keyword, Identifier and all the jagons used by SQL parsers.\n\nBehind the scene, SQLLineage uses the fantastic [`sqlparse`](https://github.com/andialbrecht/sqlparse) library to parse \nthe SQL command, and bring you all the human-readable result with ease.\n\n\n## Quick Start\nInstall sqllineage via PyPI:\n```bash\n$ pip install sqllineage\n```\n\nUsing sqllineage command to parse a quoted-query-string:\n```\n$ sqllineage -e \"insert into table1 select * from table2\"\nStatements(#): 1\nSource Tables:\n table2\nTarget Tables:\n table1\n```\n\nOr you can parse a SQL file with -f option:\n```\n$ sqllineage -f foo.sqlStatements(#): 1\nStatements(#): 1\nSource Tables:\n table_foo\n table_bar\nTarget Tables:\n table_baz\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/reata/sqllineage", "keywords": "", "license": "", "maintainer": "", "maintainer_email": "", "name": "sqllineage", "package_url": "https://pypi.org/project/sqllineage/", "platform": "", "project_url": "https://pypi.org/project/sqllineage/", "project_urls": { "Homepage": "https://github.com/reata/sqllineage" }, "release_url": "https://pypi.org/project/sqllineage/0.1.0/", "requires_dist": [ "sqlparse (<0.4,>=0.3.0)", "flake8 ; extra == 'ci'", "flake8-blind-except ; extra == 'ci'", "flake8-builtins ; extra == 'ci'", "flake8-import-order ; extra == 'ci'", "flake8-logging-format ; extra == 'ci'", "pytest (<5.0,>=4.5.0) ; extra == 'ci'", "pytest-cov ; extra == 'ci'", "tox (<4.0,>=3.11.0) ; extra == 'ci'", "twine ; extra == 'ci'", "wheel ; extra == 'ci'" ], "requires_python": ">=3.5", "summary": "SQL Lineage Analysis Tool powered by Python", "version": "0.1.0" }, "last_serial": 5589464, "releases": { "0.0.1": [ { "comment_text": "", "digests": { "md5": "0013fba5b39bdcb75457c8ba83f2cc15", "sha256": "4862c8c8dca3ede7712d608fab01c1890a74ada9125e33c0fe8a69b288ff8abf" }, "downloads": -1, "filename": "sqllineage-0.0.1-py3-none-any.whl", "has_sig": false, "md5_digest": "0013fba5b39bdcb75457c8ba83f2cc15", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": ">=3.5", "size": 4047, "upload_time": "2019-06-16T11:51:56", "url": "https://files.pythonhosted.org/packages/29/30/7bc15b02791a9e7dbda3c5cf1b34c6adaa7011f047f7043460a72d78a127/sqllineage-0.0.1-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "1ba1c6abdd5615041a7f5be40022ef37", "sha256": "078198e041baf30337b12565722e9ea56454aa34b08e0863e535a0ad28400860" }, "downloads": -1, "filename": "sqllineage-0.0.1.tar.gz", "has_sig": false, "md5_digest": "1ba1c6abdd5615041a7f5be40022ef37", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.5", "size": 2536, "upload_time": "2019-06-16T11:51:59", "url": "https://files.pythonhosted.org/packages/ed/ab/8ab9f17c17a3935d38e26f6797842d4f59ffb454c3f6d6dc2e60416c5154/sqllineage-0.0.1.tar.gz" } ], "0.1.0": [ { "comment_text": "", "digests": { "md5": "345f79ef9daf865642ec1ef70c4c09c1", "sha256": "8b3dd1d6b70205be03c9cd5181edfacba3d1632b26f1615cfbca72a815c3bbc8" }, "downloads": -1, "filename": "sqllineage-0.1.0-py3-none-any.whl", "has_sig": false, "md5_digest": "345f79ef9daf865642ec1ef70c4c09c1", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": ">=3.5", "size": 5062, "upload_time": "2019-07-26T15:06:49", "url": "https://files.pythonhosted.org/packages/3c/d5/0446f202c6e61d533ba42ab98eb38bef23cc881f5ab7b3e7482216184bfc/sqllineage-0.1.0-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "4d8311c09a351311185f063222b9139e", "sha256": "5508f9d2619795c396bf97feda3b0d2deed2349fedf395e58e2abec2aa9cd6db" }, "downloads": -1, "filename": "sqllineage-0.1.0.tar.gz", "has_sig": false, "md5_digest": "4d8311c09a351311185f063222b9139e", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.5", "size": 3658, "upload_time": "2019-07-26T15:06:51", "url": "https://files.pythonhosted.org/packages/c9/82/940dea08194eeecdbc60f6ea4dfc7f95e9595636a6ee4bf1b21383df7fb3/sqllineage-0.1.0.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "345f79ef9daf865642ec1ef70c4c09c1", "sha256": "8b3dd1d6b70205be03c9cd5181edfacba3d1632b26f1615cfbca72a815c3bbc8" }, "downloads": -1, "filename": "sqllineage-0.1.0-py3-none-any.whl", "has_sig": false, "md5_digest": "345f79ef9daf865642ec1ef70c4c09c1", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": ">=3.5", "size": 5062, "upload_time": "2019-07-26T15:06:49", "url": "https://files.pythonhosted.org/packages/3c/d5/0446f202c6e61d533ba42ab98eb38bef23cc881f5ab7b3e7482216184bfc/sqllineage-0.1.0-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "4d8311c09a351311185f063222b9139e", "sha256": "5508f9d2619795c396bf97feda3b0d2deed2349fedf395e58e2abec2aa9cd6db" }, "downloads": -1, "filename": "sqllineage-0.1.0.tar.gz", "has_sig": false, "md5_digest": "4d8311c09a351311185f063222b9139e", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.5", "size": 3658, "upload_time": "2019-07-26T15:06:51", "url": "https://files.pythonhosted.org/packages/c9/82/940dea08194eeecdbc60f6ea4dfc7f95e9595636a6ee4bf1b21383df7fb3/sqllineage-0.1.0.tar.gz" } ] }