Examples of org.eigenbase.sql.pretty.SqlPrettyWriter

org.eigenbase.sql.pretty.SqlPrettyWriter

Pretty printer for SQL statements.

There are several options to control the format.

Formatting options
Option	Description	Default
{@link #setSelectListItemsOnSeparateLines SelectListItemsOnSeparateLines}	Whether each item in the select clause is on its own line	false
{@link #setCaseClausesOnNewLines CaseClausesOnNewLines}	Whether the WHEN, THEN and ELSE clauses of a CASE expression appear at the start of a new line.	false
{@link #setIndentation Indentation}	Number of spaces to indent	4
{@link #setKeywordsLowerCase KeywordsLowerCase}	Whether to print keywords (SELECT, AS, etc.) in lower-case.	false
{@link #isAlwaysUseParentheses ParenthesizeAllExprs}	Whether to enclose all expressions in parentheses, even if the operator has high enough precedence that the parentheses are not required. For example, the parentheses are required in the expression `(a + b) c` because the '' operator has higher precedence than the '+' operator, and so without the parentheses, the expression would be equivalent to `a + (b c)`. The fully-parenthesized expression, `((a + b) * c)` is unambiguous even if you don't know the precedence of every operator.
{@link #setQuoteAllIdentifiers QuoteAllIdentifiers}	Whether to quote all identifiers, even those which would be correct according to the rules of the {@link SqlDialect} if quotation marks wereomitted.	true
{@link #setSelectListItemsOnSeparateLines SelectListItemsOnSeparateLines}	Whether each item in the select clause is on its own line.	false
{@link #setSubqueryStyle SubqueryStyle}	Style for formatting sub-queries. Values are: {@link org.eigenbase.sql.SqlWriter.SubqueryStyle#HYDE Hyde}, {@link org.eigenbase.sql.SqlWriter.SubqueryStyle#BLACK Black}.	{@link org.eigenbase.sql.SqlWriter.SubqueryStyle#HYDE Hyde}
{@link #setLineLength LineLength}	Set the desired maximum length for lines (to look nice in editors, printouts, etc.).	0

                new SqlIdentifier("*", SqlParserPos.ZERO)),
            SqlParserPos.ZERO);
    SqlSelect node =
        new SqlSelect(SqlParserPos.ZERO, SqlNodeList.EMPTY, selectList,
            tableName(), null, null, null, null, null, null, null);
    final SqlPrettyWriter writer = new SqlPrettyWriter(jdbcSchema.dialect);
    node.unparse(writer, 0, 0);
    return writer.toSqlString();
  }

View Full Code Here

    SqlNode node =
        SqlParser.create("alter system set schema = true").parseStmt();
    SqlSetOption opt = (SqlSetOption) node;
    assertThat(opt.getScope(), equalTo("SYSTEM"));
    assertThat(opt.getName(), equalTo("SCHEMA"));
    SqlPrettyWriter writer = new SqlPrettyWriter(SqlDialect.EIGENBASE);
    assertThat(writer.format(opt.getValue()), equalTo("TRUE"));
    writer = new SqlPrettyWriter(SqlDialect.EIGENBASE);
    assertThat(writer.format(opt),
        equalTo("ALTER SYSTEM SET \"SCHEMA\" = TRUE"));


    check("alter system set \"a number\" = 1",
        "ALTER SYSTEM SET `a number` = 1");
    check("alter system set flag = false",

View Full Code Here

    SqlNode node =
        SqlParser.create("alter system set schema = true").parseStmt();
    SqlSetOption opt = (SqlSetOption) node;
    assertThat(opt.getScope(), equalTo("SYSTEM"));
    assertThat(opt.getName(), equalTo("SCHEMA"));
    SqlPrettyWriter writer = new SqlPrettyWriter(SqlDialect.EIGENBASE);
    assertThat(writer.format(opt.getValue()), equalTo("TRUE"));
    writer = new SqlPrettyWriter(SqlDialect.EIGENBASE);
    assertThat(writer.format(opt),
        equalTo("ALTER SYSTEM SET \"SCHEMA\" = TRUE"));


    check("alter system set \"a number\" = 1",
        "ALTER SYSTEM SET `a number` = 1");
    check("alter system set flag = false",

View Full Code Here

                new SqlIdentifier("*", SqlParserPos.ZERO)),
            SqlParserPos.ZERO);
    SqlSelect node =
        new SqlSelect(SqlParserPos.ZERO, SqlNodeList.EMPTY, selectList,
            tableName(), null, null, null, null, null, null, null);
    final SqlPrettyWriter writer = new SqlPrettyWriter(jdbcSchema.dialect);
    node.unparse(writer, 0, 0);
    return writer.toSqlString();
  }

View Full Code Here

                new SqlIdentifier("*", SqlParserPos.ZERO)),
            SqlParserPos.ZERO);
    SqlSelect node =
        new SqlSelect(SqlParserPos.ZERO, SqlNodeList.EMPTY, selectList,
            tableName(), null, null, null, null, null, null, null);
    final SqlPrettyWriter writer = new SqlPrettyWriter(jdbcSchema.dialect);
    node.unparse(writer, 0, 0);
    return writer.toSqlString();
  }

View Full Code Here

  // implement RelDataTypeImpl
  protected void generateTypeString(StringBuilder sb, boolean withDetail) {
    sb.append("INTERVAL ");
    SqlDialect dialect = null;
    dialect = SqlDialect.DUMMY;
    SqlPrettyWriter writer = new SqlPrettyWriter(dialect);
    writer.setAlwaysUseParentheses(false);
    writer.setSelectListItemsOnSeparateLines(false);
    writer.setIndentation(0);
    intervalQualifier.unparse(writer, 0, 0);
    final String sql = writer.toString();
    sb.append(new SqlString(dialect, sql).getSql());
  }

View Full Code Here

TOP

Related Classes of org.eigenbase.sql.pretty.SqlPrettyWriter

net.hydromatic.optiq.impl.jdbc.JdbcTable

org.eigenbase.sql.parser.SqlParserTest

org.eigenbase.sql.type.IntervalSqlType

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.