API - Formatting Bug

[CrazyTim]

REQUEST:

SELECT field FROM rted ORDER BY field1, field2, field3

RESPONSE:

SELECT field
FROM   RTED
ORDER  BY field1,field2,field3 

Table name should be lowercase, and columns in ORDER BY clause need a space between them

[sqlparser]

You can send format options to FaaS to control the layout.

Here is the Java code

            String formatSql = sendPost( "http://www.gudusoft.com/format.php",
                    "rqst_db_vendor=oracle&rqst_isf_client=java_client&rqst_input_sql="
                            + URLEncoder.encode( sql, "utf-8" )
                            +"&rqst_formatOptions="+ URLEncoder.encode( fmtOptions, "utf-8" )
                        );

Source code of Java demo:

http://www.gudusoft.com/isf_client_java_demo.zip

API manual:

https://github.com/sqlparser/sql-pretty-printer/wiki/SQL-FaaS-API-manual

[sqlparser]

For your questions, case of table name can be set use this option. Space after order by item still need to be improved.

        "tableName":{
          "sqlid":"10219632",
          "fmt105_case_table_name":"upper"
        }