{
    "info": {
        "author": "David Wobrock",
        "author_email": "david.wobrock@gmail.com",
        "bugtrack_url": null,
        "classifiers": [
            "Development Status :: 3 - Alpha",
            "Intended Audience :: Developers",
            "Programming Language :: Python",
            "Programming Language :: Python :: 2",
            "Programming Language :: Python :: 2.7",
            "Programming Language :: Python :: 3",
            "Programming Language :: Python :: 3.5",
            "Programming Language :: Python :: 3.6",
            "Programming Language :: Python :: 3.7"
        ],
        "description": "# sqlvalidator\n\nSQL queries formatting (and soon basic schema less validation)\n\n## Formatting\n\nFormatting can be used in 2 ways:\n* formatting Python files that contain SQL strings tagged with `# sqlformat` from the command line:\n\n`sqlvalidator --format myfile.py` or `sqlvalidator --format myproject/`\n\n* formatting Python strings that represent SQL:\n\n`sqlvalidator.format_sql(\"SELECT * FROM table\")`\n\nBoth output the same formatted string for the same input SQL.\n\nOne can verify that all files are correctly formatted using\n`sqlvalidator --check-format pyfile.py`\n\nWhich won't write the file back and just return a status code.\nStatus code 0 means nothing would change.\nStatus code 1 means some files would reformatted.\n\n## Validation\n\nTo be implemented yet, but should become the main added-value of this lib.\n\nSuggested API:\n```python\nimport sqlvalidator\n\nsql_query = sqlvalidator.parse(\"SELECT * from table\")\n\nif not sql_query.is_valid():\n    print(sql_query.errors)\n```\n\nIdeally, this package should provide a basic SQL validation:\n* not using a missing column\n* existing functions\n* correct aggregations\n* schema-less (not assume that table names and columns in those exist)\n* types correctness in functions\n\n(only on SELECT-statements)\n\nMore advanced features:\n* depending on the backend (standard SQL, postgresql, BigQuery, Legacy BigQuery...)\n* Flexible internal SQL representation to do advanced validation\n* With provided schema (to validate that columns exist)\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/David-Wobrock/sqlvalidator",
        "keywords": "python sql format formatter formatting validation validator validate automation",
        "license": "MIT",
        "maintainer": "",
        "maintainer_email": "",
        "name": "sqlvalidator",
        "package_url": "https://pypi.org/project/sqlvalidator/",
        "platform": "",
        "project_url": "https://pypi.org/project/sqlvalidator/",
        "project_urls": {
            "Homepage": "https://github.com/David-Wobrock/sqlvalidator"
        },
        "release_url": "https://pypi.org/project/sqlvalidator/0.0.2/",
        "requires_dist": [
            "sqlparse (==0.3.0)"
        ],
        "requires_python": "",
        "summary": "SQL queries formatting (and soon basic schema less validation)",
        "version": "0.0.2"
    },
    "last_serial": 5319499,
    "releases": {
        "0.0.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "434b7c61106d9b65d6a95bccde61fd0d",
                    "sha256": "cb05ebed9a2ffb1fe7a1b688512fad1514719f9b08366aa653094bf0a6d07677"
                },
                "downloads": -1,
                "filename": "sqlvalidator-0.0.1-py2.py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "434b7c61106d9b65d6a95bccde61fd0d",
                "packagetype": "bdist_wheel",
                "python_version": "py2.py3",
                "requires_python": ">=3.6",
                "size": 25602,
                "upload_time": "2019-05-26T17:51:41",
                "url": "https://files.pythonhosted.org/packages/a2/fe/3be24f603f3c89d0872f7b18d7c1043b45a75882cff8e4c0d0ce1f8ee57f/sqlvalidator-0.0.1-py2.py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "5111ec640f9b6000486d81847c84e142",
                    "sha256": "5b8196da7517cecd445b5657fb84d7c01f9c906ce06d846399c9de2ae9410d46"
                },
                "downloads": -1,
                "filename": "sqlvalidator-0.0.1.tar.gz",
                "has_sig": false,
                "md5_digest": "5111ec640f9b6000486d81847c84e142",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": ">=3.6",
                "size": 18841,
                "upload_time": "2019-05-26T17:51:44",
                "url": "https://files.pythonhosted.org/packages/b4/9d/f41d392356f659b173d08afd9e36a64aacf5f56c445a571de985e91b579c/sqlvalidator-0.0.1.tar.gz"
            }
        ],
        "0.0.2": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "738b51191d74bd0cba09d6e8e3863e2c",
                    "sha256": "bee1e9f2a0a48150cb169085611b2c55835c397962ece7af0abd575948c74081"
                },
                "downloads": -1,
                "filename": "sqlvalidator-0.0.2-py2.py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "738b51191d74bd0cba09d6e8e3863e2c",
                "packagetype": "bdist_wheel",
                "python_version": "py2.py3",
                "requires_python": null,
                "size": 25609,
                "upload_time": "2019-05-26T18:10:04",
                "url": "https://files.pythonhosted.org/packages/75/63/5d2c9dd793189439a3ae08fbafafc1c588c9642993b7e7fd2ade7e141376/sqlvalidator-0.0.2-py2.py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "e453301f64d2d14d5b667c85e96e6016",
                    "sha256": "0ddb9fee1c7ae6430580bc18868536572c42f2e43d9c7e668315b4b76af48b5e"
                },
                "downloads": -1,
                "filename": "sqlvalidator-0.0.2.tar.gz",
                "has_sig": false,
                "md5_digest": "e453301f64d2d14d5b667c85e96e6016",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 18842,
                "upload_time": "2019-05-26T18:10:06",
                "url": "https://files.pythonhosted.org/packages/da/76/d7d6208d7618de20d0d3d31a7fa31e954b32be4475868201a4be19908930/sqlvalidator-0.0.2.tar.gz"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "738b51191d74bd0cba09d6e8e3863e2c",
                "sha256": "bee1e9f2a0a48150cb169085611b2c55835c397962ece7af0abd575948c74081"
            },
            "downloads": -1,
            "filename": "sqlvalidator-0.0.2-py2.py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "738b51191d74bd0cba09d6e8e3863e2c",
            "packagetype": "bdist_wheel",
            "python_version": "py2.py3",
            "requires_python": null,
            "size": 25609,
            "upload_time": "2019-05-26T18:10:04",
            "url": "https://files.pythonhosted.org/packages/75/63/5d2c9dd793189439a3ae08fbafafc1c588c9642993b7e7fd2ade7e141376/sqlvalidator-0.0.2-py2.py3-none-any.whl"
        },
        {
            "comment_text": "",
            "digests": {
                "md5": "e453301f64d2d14d5b667c85e96e6016",
                "sha256": "0ddb9fee1c7ae6430580bc18868536572c42f2e43d9c7e668315b4b76af48b5e"
            },
            "downloads": -1,
            "filename": "sqlvalidator-0.0.2.tar.gz",
            "has_sig": false,
            "md5_digest": "e453301f64d2d14d5b667c85e96e6016",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 18842,
            "upload_time": "2019-05-26T18:10:06",
            "url": "https://files.pythonhosted.org/packages/da/76/d7d6208d7618de20d0d3d31a7fa31e954b32be4475868201a4be19908930/sqlvalidator-0.0.2.tar.gz"
        }
    ]
}