{
"info": {
"author": "P G Jones",
"author_email": "philip.graham.jones@googlemail.com",
"bugtrack_url": null,
"classifiers": [
"Development Status :: 3 - Alpha",
"Environment :: Console",
"Framework :: Flake8",
"Intended Audience :: Developers",
"License :: OSI Approved :: MIT License",
"Operating System :: OS Independent",
"Programming Language :: Python",
"Programming Language :: Python :: 3",
"Topic :: Software Development :: Libraries :: Python Modules",
"Topic :: Software Development :: Quality Assurance"
],
"description": "Flake8-SQL\n==========\n\n|Build Status|\n\nFlake8-SQL is a `flake8 `__\nplugin that looks for SQL queries and checks then against an\nopinionated style. This style mostly follows `SQL Style Guide\n`__, but differ in the two following\nways. Firstly alignement should be with the ``INTO`` rather than\n``INSERT`` keyword, i.e.\n\n::\n\n INSERT INTO table (columns)\n VALUES (values)\n\nSecondly ``JOIN`` should be aligned to the left of the river, i.e.\n\n::\n\n SELECT *\n FROM table1\n JOIN table2 ON ...\n\nWarnings\n--------\n\nQ440 Keyword is not uppercase\n~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n\nAll the SQL reserved\n`keywords `__\nshould be uppercase.\n\nQ441 Name is not valid\n~~~~~~~~~~~~~~~~~~~~~~\n\nAll the non SQL keywords should be snake\\_case, start with a letter\nand not end with an `\\_`. Due to a limitation snake\\_case is checks\nensure that the word is lowercase.\n\nQ442 Avoid abbreviated keywords\n~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n\nAvoid using `abbreviated\nkeywords `__\ninstead use the full length version.\n\nQ443 Incorrect whitespace around comma\n~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n\nCommas should be followed by whitespace, but not preceded.\n\nQ444 Incorrect whitespace around equals\n~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n\nEquals should be surrounded with whitespace.\n\nQ445 Missing linespace between root keywords\n~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n\nThe root keywords ``SELECT``, ``FROM``, ``INSERT``, ``VALUES``, ``DELETE\nFROM``, ``WHERE``, ``UPDATE``, ``AND``, ``OR`` and ``SET`` should be\non separate lines (unless the entire query is on one line).\n\nQ446 Missing newline after semicolon\n~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n\nSemicolons must be at the end of the line.\n\nQ447 Root keywords should be right aligned\n~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n\nThe root keywords ``SELECT``, ``FROM``, ``INSERT``, ``VALUES``,\n``WHERE``, ``UPDATE``, ``AND``, ``OR``, ``JOIN`` and ``SET`` should be\nright aligned i.e.\n\n::\n\n SELECT *\n FROM table\n\nQ448 subquery should be aligned to the right of the river\n~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n\nAny subquery should be aligned to the right of the river i.e.\n\n::\n\n SELECT *\n FROM table\n WHERE column IN\n (SELECT column\n FROM table)\n\nQ449 tokens should be aligned to the right of the river\n~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n\nAny tokens should be aligned to the right of the river i.e\n\n::\n\n SELECT column1,\n column2\n FROM table\n\nConfiguration\n-------------\n\nAt times it is simpler to use a reserved keyword as an identifier than\ngo to the effort to avoid it. To allow for this set the\n``sql-excepted-names`` option to a comma separated list of these\nnames.\n\n\nLimitations\n-----------\n\nString constants are sought out in the code and considered SQL if they\ncontain select from, insert into values, update set or delete from in\norder. This may and is likely to lead to false positives, in which case\nsimply add ``# noqa`` to have this plugin ignore the string.\n\nF-Strings are formatted with the formatted values, ``{...}``, replaced\nwith the constant ``formatted_value`` before being linted. This leads\nto the error message referring to ``formatted_value``s rather than\nwhat was actually written.\n\n\n.. |Build Status| image:: https://travis-ci.org/pgjones/flake8-sql.svg?branch=master\n :target: https://travis-ci.org/pgjones/flake8-sql\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/pgjones/flake8-sql",
"keywords": "flake8,plugin,sql",
"license": "MIT",
"maintainer": "",
"maintainer_email": "",
"name": "flake8-SQL",
"package_url": "https://pypi.org/project/flake8-SQL/",
"platform": "",
"project_url": "https://pypi.org/project/flake8-SQL/",
"project_urls": {
"Homepage": "https://github.com/pgjones/flake8-sql"
},
"release_url": "https://pypi.org/project/flake8-SQL/0.3.0/",
"requires_dist": [
"flake8",
"setuptools",
"sqlparse",
"typing; python_version < \"3.5\""
],
"requires_python": "",
"summary": "Flake8 plugin that checks SQL code against opinionated style rules",
"version": "0.3.0"
},
"last_serial": 4161601,
"releases": {
"0.1": [
{
"comment_text": "",
"digests": {
"md5": "2b11ba265e4a0e3da05588fdae9ebb13",
"sha256": "2185468f6ca6decf8f9934e47c80c36eb8ab873796402137f61793d1e093b55d"
},
"downloads": -1,
"filename": "flake8_SQL-0.1-py2.py3-none-any.whl",
"has_sig": false,
"md5_digest": "2b11ba265e4a0e3da05588fdae9ebb13",
"packagetype": "bdist_wheel",
"python_version": "py2.py3",
"requires_python": null,
"size": 8329,
"upload_time": "2017-02-06T14:21:36",
"url": "https://files.pythonhosted.org/packages/bf/65/5066bd32121fb95699011e456da8efdb2602c5ec66eb498deea0d44a7184/flake8_SQL-0.1-py2.py3-none-any.whl"
},
{
"comment_text": "",
"digests": {
"md5": "f22d55c560cfb6ac3991557252dc4316",
"sha256": "f15b49c9212ab8f2b60e4cee020906b8169173fe4c90b65fe7e9296decdf4e6f"
},
"downloads": -1,
"filename": "flake8-SQL-0.1.tar.gz",
"has_sig": false,
"md5_digest": "f22d55c560cfb6ac3991557252dc4316",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 8939,
"upload_time": "2017-02-06T14:21:38",
"url": "https://files.pythonhosted.org/packages/2c/dd/cc41e1d4063e450e6483ebff1db16e84da47d8bc40ca476d1fd4b4b4dab1/flake8-SQL-0.1.tar.gz"
}
],
"0.2.0": [
{
"comment_text": "",
"digests": {
"md5": "3a3c925902ed464b165c6e0bca737872",
"sha256": "58c9972db3a31d893b4fd9cea59f00e0d58e50aae19751b5682393994d6a7432"
},
"downloads": -1,
"filename": "flake8_SQL-0.2.0-py2.py3-none-any.whl",
"has_sig": false,
"md5_digest": "3a3c925902ed464b165c6e0bca737872",
"packagetype": "bdist_wheel",
"python_version": "py2.py3",
"requires_python": null,
"size": 8572,
"upload_time": "2017-02-06T18:07:58",
"url": "https://files.pythonhosted.org/packages/d6/7a/7f3f24951a459e3ac0356bf3c950fb1853b0139c3f33b164dd66f3c7a43e/flake8_SQL-0.2.0-py2.py3-none-any.whl"
},
{
"comment_text": "",
"digests": {
"md5": "0652788f55737d2aae6bcfa9da98213d",
"sha256": "e6e970516b0c07932f291edfc9e8b0e4c66c88258370084c1beb10280b62dd85"
},
"downloads": -1,
"filename": "flake8-SQL-0.2.0.tar.gz",
"has_sig": false,
"md5_digest": "0652788f55737d2aae6bcfa9da98213d",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 9346,
"upload_time": "2017-02-06T18:08:00",
"url": "https://files.pythonhosted.org/packages/48/da/0ff11f1e3460aa586981316ac388101f2dc979acbba46cf168ceed4852ee/flake8-SQL-0.2.0.tar.gz"
}
],
"0.3.0": [
{
"comment_text": "",
"digests": {
"md5": "b2ee467ba07277feabcb1361a53e2a30",
"sha256": "f1f8c08d87e81ef1ad6c135257045d9b4a0a20a73a29cf09e93c66559aa33689"
},
"downloads": -1,
"filename": "flake8_SQL-0.3.0-py2.py3-none-any.whl",
"has_sig": false,
"md5_digest": "b2ee467ba07277feabcb1361a53e2a30",
"packagetype": "bdist_wheel",
"python_version": "py2.py3",
"requires_python": null,
"size": 6659,
"upload_time": "2018-08-12T13:01:15",
"url": "https://files.pythonhosted.org/packages/94/6a/3266f41dd59d67c9efa784178c1ebcdfbde2cacb8c8f0fe72925499b41d4/flake8_SQL-0.3.0-py2.py3-none-any.whl"
},
{
"comment_text": "",
"digests": {
"md5": "120b484e1986a4daad723f559c01d3ce",
"sha256": "5c2ff2c45333a104ec52a05f64668839be9484c081ea8a9b4abe215b383cad2c"
},
"downloads": -1,
"filename": "flake8-SQL-0.3.0.tar.gz",
"has_sig": false,
"md5_digest": "120b484e1986a4daad723f559c01d3ce",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 8612,
"upload_time": "2018-08-12T13:01:16",
"url": "https://files.pythonhosted.org/packages/41/7d/1d9cc003f2d9043802ecfb0d5142c260e4e2396cfcc28070f628c935d169/flake8-SQL-0.3.0.tar.gz"
}
]
},
"urls": [
{
"comment_text": "",
"digests": {
"md5": "b2ee467ba07277feabcb1361a53e2a30",
"sha256": "f1f8c08d87e81ef1ad6c135257045d9b4a0a20a73a29cf09e93c66559aa33689"
},
"downloads": -1,
"filename": "flake8_SQL-0.3.0-py2.py3-none-any.whl",
"has_sig": false,
"md5_digest": "b2ee467ba07277feabcb1361a53e2a30",
"packagetype": "bdist_wheel",
"python_version": "py2.py3",
"requires_python": null,
"size": 6659,
"upload_time": "2018-08-12T13:01:15",
"url": "https://files.pythonhosted.org/packages/94/6a/3266f41dd59d67c9efa784178c1ebcdfbde2cacb8c8f0fe72925499b41d4/flake8_SQL-0.3.0-py2.py3-none-any.whl"
},
{
"comment_text": "",
"digests": {
"md5": "120b484e1986a4daad723f559c01d3ce",
"sha256": "5c2ff2c45333a104ec52a05f64668839be9484c081ea8a9b4abe215b383cad2c"
},
"downloads": -1,
"filename": "flake8-SQL-0.3.0.tar.gz",
"has_sig": false,
"md5_digest": "120b484e1986a4daad723f559c01d3ce",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 8612,
"upload_time": "2018-08-12T13:01:16",
"url": "https://files.pythonhosted.org/packages/41/7d/1d9cc003f2d9043802ecfb0d5142c260e4e2396cfcc28070f628c935d169/flake8-SQL-0.3.0.tar.gz"
}
]
}