anbt-sql-formatter icon indicating copy to clipboard operation
anbt-sql-formatter copied to clipboard

A tool for SQL formatting written in Ruby.

= anbt-sql-formatter

(C) 2010-2018 sonota88 ([email protected])

== Description

A tool for SQL formatting ported from {BlancoSqlFormatter}[http://sourceforge.jp/projects/blancofw/releases/?package_id=4732].

== Install

$ ruby setup.rb

== Usage

$ echo "select a,b from c;" | anbt-sql-formatter SELECT a , b FROM c ; $

== License

GNU Lesser General Public License.

== Authors

sonota:: Porting to Ruby

Following are Authors of BlancoSqlFormatter(original Java version).

渡辺義則 / Yoshinori WATANABE / A-san:: Early development 伊賀敏樹 (Tosiki Iga / いがぴょん):: Maintainance

== Customize

  • In AnbtSql::Rule:
    • Function names
    • Rules for linefeed and indentation
    • Characters for indentation
    • Upcase or Downcase
  • More farther: Override AnbtSql::Formatter#format_list_main_loop by inheritance or monkeypathcing.

== Test

$ ./test.sh