format-sql 0.0.1

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

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

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

Install format-sql via pip:

$ pip install format-sql

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

$ format-sql my_python_file.py my/python/dir/

An example:

    sql = """
select *
from my_table as mt join ma_table as ta on ma.id = k.id
where idt=4 and ih in ('syds', 'sdsd');

    """

Will result in:

sql = """
    SELECT
        *
    FROM
        my_table AS mt
        JOIN ma_table AS ta ON ma.id = k.id
    WHERE
        idt=4
        AND ih IN ('syds', 'sdsd'); """

This is an early version and work in progress. Don’t expect too much right now.