Plsql beautifier online12/31/2023 ![]() ![]() Select asdf, cast(qwer as numeric), - some comment It can even deal with subqueries and it will correct my favourite simple careless mistake (comma at the end of SELECT statement before of FROM) for you on the flow :-) print(format_sql(""" 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 |