You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@netbeans.apache.org by "Christian Lenz (JIRA)" <ji...@apache.org> on 2018/11/14 12:54:00 UTC

[jira] [Updated] (NETBEANS-1682) Adding real formatting for SQL

     [ https://issues.apache.org/jira/browse/NETBEANS-1682?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Christian Lenz updated NETBEANS-1682:
-------------------------------------
    Description: 
Unfortunately there is no real formatter for SQL files.

So this: {code:sql}SELECT * FROM tableName WHERE ...{code}

Should expand to:
{code:sql}
SELECT
   *
FROM
   tableName
WHERE
   ...
{code}

For this, we need formatting options for SQL, which will be handled in this ticket: NETBEANS-1681.

  was:
As you can see it in the external ticket and in this one: https://netbeans.org/bugzilla/show_bug.cgi?id=249760 it is not possible to format a one line, minifed HTML back to the original one. Or any other code snippets, that you copied from somewhere else.

In JSON this is working great, a one line JSON, will format and beautify the JSON to a more readable one.

In HTML it will only fix indentation but will not beautify minified HTML.

So this: {code:html}<div><div><ul><li></li></ul></div></div>{code}

Should expand to:
{code:html}
<div>
    <div>
        <ul>
            <li></li>
        </ul>
    </div>
</div>
{code}

Please let me know whether you need more information.


Cheers

Chris


> Adding real formatting for SQL
> ------------------------------
>
>                 Key: NETBEANS-1682
>                 URL: https://issues.apache.org/jira/browse/NETBEANS-1682
>             Project: NetBeans
>          Issue Type: Improvement
>          Components: web - HTML Editor
>    Affects Versions: 8.2, 10.0
>            Reporter: Christian Lenz
>            Priority: Major
>
> Unfortunately there is no real formatter for SQL files.
> So this: {code:sql}SELECT * FROM tableName WHERE ...{code}
> Should expand to:
> {code:sql}
> SELECT
>    *
> FROM
>    tableName
> WHERE
>    ...
> {code}
> For this, we need formatting options for SQL, which will be handled in this ticket: NETBEANS-1681.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@netbeans.apache.org
For additional commands, e-mail: commits-help@netbeans.apache.org

For further information about the NetBeans mailing lists, visit:
https://cwiki.apache.org/confluence/display/NETBEANS/Mailing+lists