Java
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
docs
jp.co.future.eclipse.usqlfmt.feature
jp.co.future.eclipse.usqlfmt.update
jp.co.future.eclipse.usqlfmt
.gitattributes
.gitignore
LICENSE
Readme.ja.md
Readme.md

Readme.md

Eclipse uroboroSQL Formatter

Eclipse Marketplace

UroboroSQL Formatter is often used in enterprise systems, For formatting to a highly maintainable style even for very long SQL (1 K step or more) It is a plug-in of Eclipse.

In particular, in countries where English is not their mother tongue, such as Japan, comments may be included in SELECT clauses. In that case, we will align the vertical position of the AS clause and the comment, pursuing the viewability which can be said as artistic anymore, This was developed to realize this automatically.

for Japanese, Readme.ja.md

In case of general formatter

SELECT MI.MAKER_CD AS ITEM_MAKER_CD -- メーカーコード
,
       MI.BRAND_CD AS ITEM_BRAND_CD -- ブランドコード
,
       MI.ITEM_CD AS ITEM_CD -- 商品コード
,
       MI.CATEGORY AS ITEM_CATEGORY -- 商品カテゴリ
FROM M_ITEM MI -- 商品マスタ

WHERE 1 = 1
  AND MI.ARRIVAL_DATE = '2016-12-01' -- 入荷日

In case of uroboroSQL Formatter

SELECT
    MI.MAKER_CD AS  ITEM_MAKER_CD   -- メーカーコード
,   MI.BRAND_CD AS  ITEM_BRAND_CD   -- ブランドコード
,   MI.ITEM_CD  AS  ITEM_CD         -- 商品コード
,   MI.CATEGORY AS  ITEM_CATEGORY   -- 商品カテゴリ
FROM
    M_ITEM  MI  -- 商品マスタ
WHERE
    1               =   1
AND MI.ARRIVAL_DATE =   '2016-12-01'    -- 入荷日

Install

Update site

From the Eclipse menu, choose Help -> Install new software and enter the URL below.

https://future-architect.github.io/eclipse-uroborosql-formatter/

After that, select "Eclipse uroboroSQL Formatter" and install it.

Eclipse Marketplace

Drag the button below into the running Eclipse workspace.

Drag to your running Eclipse* workspace. *Requires Eclipse Marketplace Client

Features

  • Formatting by aligning the vertical position of AS and operator in SELECT clause, WHERE clause
  • Even if there is a comment at the end of each line, the format

How to Use

  • With the file with the extension sql open, select "Format SQL" from the Edit menu.
  • With the file with the extension sql open, select "Format SQL" from the context menu of the editor.
  • Use Ctrl + Shift + L on Windows, Cmd + Shift + L on OS X to format currently active document.

Preferences

  • Select "uroboroSQL Formatter" from Eclipse's Preferences.

License

python-sqlparse library and this code are both on 2-clauses BSD


Copyright 2018 by Future Architect.