![]() LEFT JOIN table2 as b - and here a comment Then you can use this package to format it so that it is better readable from sql_re import format_sqlĬREATE OR REPLACE TABLE mytable AS - mytable example SeLecT a.asdf, b.qwer, - some comment here To exemplify the formatting let's say you have a SQL query like this example_sql = """Ĭreate or replace table mytable as - mytable example Or repos : - repo : local hooks : - id : sql_formatter name : SQL formatter language : system entry : sql-formatter -max-line-length=50 files : \.sql$įor a custom maximum line length truncation of e.g. pre-commit-config.yaml file: repos : - repo : local hooks : - id : sql_formatter name : SQL formatter language : system entry : sql-formatter files : \.sql$ If you want to install sql-formatter locally and use that instead of using pre-commit's default environment, set repo: local in your. pre-commit-config.yaml: repos : - repo : rev : master hooks : - id : sql_formatter To add sql-formatter as a hook to your pre-commit configuration to format your SQL files before commit, just add the following lines to your. After installation and configuration pre-commit will run your hooks before you commit any change. Pre-commit is a nice development tool to automatize the binding of pre-commit hooks. Sql-formatter sql_file.sql -max-line-length=50 Usage with pre-commit You can control the maximum length line using e.g. The default maximum line length is 82 after line stripping. The sql_formatter will try to truncate too long lines in the SELECT clause for either ![]() Sql-formatter -r "*.sql" Controlling maximum length line via truncation To format all your SQL files recursively use You can also format all your SQL-files via ![]() Conda install -c pablormira sql_formatter How to useįormat your SQL files via the command line ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |