dang-sqlfluffer 0.1.1

my convenient opinionated wrapper around sqlfluff

dang-sqlfluffer

my convenient opinionated wrapper around sqlfluff

Current status

Invoke either lint or fix; lint is default.

# default behavior is to lint using config/my.sqlfluff
$ echo 'select 1 as id, 2 hello, 3 world order by id' | dang-sqlfluff -

== [stdin] FAIL                                                                                                                      L:   1 | P:   1 | CP01 | Keywords must be upper case.
                       | [capitalisation.keywords]
L:   1 | P:   1 | LT09 | Select targets should be on a new line unless there is
                       | only one select target. [layout.select_targets]
L:   1 | P:  10 | CP01 | Keywords must be upper case.
                       | [capitalisation.keywords]
L:   1 | P:  19 | AL02 | Implicit/explicit aliasing of columns.
                       | [aliasing.column]
L:   1 | P:  28 | AL02 | Implicit/explicit aliasing of columns.
                       | [aliasing.column]
L:   1 | P:  34 | CP01 | Keywords must be upper case.
                       | [capitalisation.keywords]
L:   1 | P:  40 | CP01 | Keywords must be upper case.
                       | [capitalisation.keywords]
All Finished 📜 🎉!

Boilerplate

Installation

Install this tool using pip:

pip install dang-sqlfluffer

Usage

For help, run:

dang-sqlfluff --help

You can also use:

python -m dang_sqlfluffer --help

Development

To contribute to this tool, first checkout the code. Then create a new virtual environment:

cd dang-sqlfluffer
python -m venv venv
source venv/bin/activate

Now install the dependencies and test dependencies:

pip install -e '.[test]'

To run the tests:

python -m pytest

How to build and package

(notes for foregetful dan)

# https://packaging.python.org/en/latest/tutorials/packaging-projects/
python3 -m build
python3 -m twine upload dist/*