format-sql 0.0.2

format-sql is a tool to format SQL in your Python strings!

format-sql is a tool to format SQL in your Python strings!

An example:

    sql = """ SELECT country, product, SUM(profit) FROM
sales   left join x on x.id=sales.k GROUP BY country,
product having f > 7 and fk=9 limit 5;    """

Will result in:

sql = """
    SELECT
        country,
        product,
        SUM(profit)
    FROM
        sales
        LEFT JOIN x
            ON x.id = sales.k
    GROUP BY
        country,
        product
    HAVING
        f > 7
        AND fk = 9
    LIMIT
        5
    ; """

Install format-sql via pip:

$ pip install format-sql

You can then just call format-sql with files and directories:

$ format-sql -h
usage: format-sql [-h] [--types [TYPES [TYPES ...]]] [-r] [--no-semicolon]
                  paths [paths ...]

positional arguments:
  paths

optional arguments:
  -h, --help            show this help message and exit
  --types [TYPES [TYPES ...]]
                        Process given file types. Default value is "py".
  -r, --recursive       Process files found in subdirectories.
  --no-semicolon        Try to detect SQL queries with no trailing semicolon.

Copyright (c) 2014, Friedrich Paetzke ([e-mail]). All rights reserved.