public void unparse( SqlWriter writer, int leftPrec, int rightPrec) { writer.print("?"); writer.setNeedWhitespace(true); }
private void unparseFloorWithUnit(SqlWriter writer, SqlCall call, int charLen, String offset) { writer.print("CONVERT"); SqlWriter.Frame frame = writer.startList("(", ")"); writer.print("DATETIME, CONVERT(VARCHAR(" + charLen + "), "); call.operand(0).unparse(writer, 0, 0); writer.print(", 126)"); if (offset.length() > 0) { writer.print("+'" + offset + "'"); } writer.endList(frame); } }
private void unparseFloorWithUnit(SqlWriter writer, SqlCall call, int charLen, String offset) { writer.print("CONVERT"); SqlWriter.Frame frame = writer.startList("(", ")"); writer.print("DATETIME, CONVERT(VARCHAR(" + charLen + "), "); call.operand(0).unparse(writer, 0, 0); writer.print(", 126)"); if (offset.length() > 0) { writer.print("+'" + offset + "'"); } writer.endList(frame); } }
private void printIndent(SqlWriter writer) { writer.sep(",", false); writer.newlineAndIndent(); writer.print(" "); }
public void unparse( SqlWriter writer, SqlCall call, int leftPrec, int rightPrec) { writer.print("{fn "); writer.print(jdbcName); final SqlWriter.Frame frame = writer.startList("(", ")"); for (SqlNode operand : call.getOperandList()) { writer.sep(","); operand.unparse(writer, leftPrec, rightPrec); } writer.endList(frame); writer.print("}"); }
public void unparse( SqlWriter writer, SqlCall call, int leftPrec, int rightPrec) { writer.print("{fn "); writer.print(jdbcName); final SqlWriter.Frame frame = writer.startList("(", ")"); for (SqlNode operand : call.getOperandList()) { writer.sep(","); operand.unparse(writer, leftPrec, rightPrec); } writer.endList(frame); writer.print("}"); }
@Override public void unparse(SqlWriter writer, int leftPrec, int rightPrec) { this.name.unparse(writer, leftPrec, rightPrec); writer.print(" "); this.type.unparse(writer, leftPrec, rightPrec); if (this.isHeader) { writer.keyword("HEADER"); } if (this.comment != null) { writer.print(" COMMENT "); this.comment.unparse(writer, leftPrec, rightPrec); } }
@Override public void unparse(SqlWriter writer, int leftPrec, int rightPrec) { name.unparse(writer, leftPrec, rightPrec); writer.keyword("AS"); writer.print(type + "()"); if (hidden) { writer.keyword("HIDDEN"); } }
@Override public void unparse(SqlWriter writer, SqlCall call, int leftPrec, int rightPrec) { writer.keyword("PERMUTE"); SqlWriter.Frame frame = writer.startList("(", ")"); for (int i = 0; i < call.getOperandList().size(); i++) { SqlNode pattern = call.getOperandList().get(i); pattern.unparse(writer, 0, 0); if (i != call.getOperandList().size() - 1) { writer.print(","); } } writer.endList(frame); } };
@Override public void unparse(SqlWriter writer, SqlCall call, int leftPrec, int rightPrec) { writer.keyword("PERMUTE"); SqlWriter.Frame frame = writer.startList("(", ")"); for (int i = 0; i < call.getOperandList().size(); i++) { SqlNode pattern = call.getOperandList().get(i); pattern.unparse(writer, 0, 0); if (i != call.getOperandList().size() - 1) { writer.print(","); } } writer.endList(frame); } };
@Override public void unparse(SqlWriter writer, SqlCall call, int leftPrec, int rightPrec) { writer.keyword("PERMUTE"); SqlWriter.Frame frame = writer.startList("(", ")"); for (int i = 0; i < call.getOperandList().size(); i++) { SqlNode pattern = call.getOperandList().get(i); pattern.unparse(writer, 0, 0); if (i != call.getOperandList().size() - 1) { writer.print(","); } } writer.endList(frame); } };
public void unparse( SqlWriter writer, int leftPrec, int rightPrec) { writer.keyword("CREATE"); writer.keyword("FUNCTION"); functionName.unparse(writer, leftPrec, rightPrec); writer.keyword("AS"); writer.print("'" + className + "'"); }
@Override public void unparseSqlIntervalLiteral(SqlWriter writer, SqlIntervalLiteral literal, int leftPrec, int rightPrec) { // A duration is a positive or negative number representing an interval of time. // If one operand is a date, the other labeled duration of YEARS, MONTHS, or DAYS. // If one operand is a time, the other must be labeled duration of HOURS, MINUTES, or SECONDS. // If one operand is a timestamp, the other operand can be any of teh duration. SqlIntervalLiteral.IntervalValue interval = (SqlIntervalLiteral.IntervalValue) literal.getValue(); if (interval.getSign() == -1) { writer.print("-"); } writer.literal(literal.getValue().toString()); unparseSqlIntervalQualifier(writer, interval.getIntervalQualifier(), RelDataTypeSystem.DEFAULT); }
@Override public void unparseSqlIntervalLiteral(SqlWriter writer, SqlIntervalLiteral literal, int leftPrec, int rightPrec) { // A duration is a positive or negative number representing an interval of time. // If one operand is a date, the other labeled duration of YEARS, MONTHS, or DAYS. // If one operand is a time, the other must be labeled duration of HOURS, MINUTES, or SECONDS. // If one operand is a timestamp, the other operand can be any of teh duration. SqlIntervalLiteral.IntervalValue interval = (SqlIntervalLiteral.IntervalValue) literal.getValue(); if (interval.getSign() == -1) { writer.print("-"); } writer.literal(literal.getValue().toString()); unparseSqlIntervalQualifier(writer, interval.getIntervalQualifier(), RelDataTypeSystem.DEFAULT); }
public void unparse( SqlWriter writer, int leftPrec, int rightPrec) { final SqlWriter.Frame frame = writer.startList(SqlWriter.FrameTypeEnum.IDENTIFIER); for (String name : names) { writer.sep("."); if (name.equals("")) { writer.print("*"); } else { writer.identifier(name); } } if (null != collation) { collation.unparse(writer, leftPrec, rightPrec); } writer.endList(frame); }
public void unparse( SqlWriter writer, int leftPrec, int rightPrec) { final SqlWriter.Frame frame = writer.startList(SqlWriter.FrameTypeEnum.IDENTIFIER); for (String name : names) { writer.sep("."); if (name.equals("")) { writer.print("*"); } else { writer.identifier(name); } } if (null != collation) { collation.unparse(writer, leftPrec, rightPrec); } writer.endList(frame); }
private void unparseSqlIntervalLiteralMssql( SqlWriter writer, SqlIntervalLiteral literal, int sign) { final SqlIntervalLiteral.IntervalValue interval = (SqlIntervalLiteral.IntervalValue) literal.getValue(); unparseSqlIntervalQualifier(writer, interval.getIntervalQualifier(), RelDataTypeSystem.DEFAULT); writer.sep(",", true); if (interval.getSign() * sign == -1) { writer.print("-"); } writer.literal(literal.getValue().toString()); }
private void unparseSqlIntervalLiteralMssql( SqlWriter writer, SqlIntervalLiteral literal, int sign) { SqlIntervalLiteral.IntervalValue interval = (SqlIntervalLiteral.IntervalValue) literal.getValue(); unparseSqlIntervalQualifier(writer, interval.getIntervalQualifier(), RelDataTypeSystem.DEFAULT); writer.sep(",", true); if (interval.getSign() * sign == -1) { writer.print("-"); } writer.literal(literal.getValue().toString()); }
/** Converts an interval literal to a SQL string. The default implementation * returns strings such as * <code>INTERVAL '1 2:3:4' DAY(4) TO SECOND(4)</code>. */ public void unparseSqlIntervalLiteral(SqlWriter writer, SqlIntervalLiteral literal, int leftPrec, int rightPrec) { SqlIntervalLiteral.IntervalValue interval = (SqlIntervalLiteral.IntervalValue) literal.getValue(); writer.keyword("INTERVAL"); if (interval.getSign() == -1) { writer.print("-"); } writer.literal("'" + literal.getValue().toString() + "'"); unparseSqlIntervalQualifier(writer, interval.getIntervalQualifier(), RelDataTypeSystem.DEFAULT); }
/** Converts an interval literal to a SQL string. The default implementation * returns strings such as * <code>INTERVAL '1 2:3:4' DAY(4) TO SECOND(4)</code>. */ public void unparseSqlIntervalLiteral(SqlWriter writer, SqlIntervalLiteral literal, int leftPrec, int rightPrec) { SqlIntervalLiteral.IntervalValue interval = (SqlIntervalLiteral.IntervalValue) literal.getValue(); writer.keyword("INTERVAL"); if (interval.getSign() == -1) { writer.print("-"); } writer.literal("'" + literal.getValue().toString() + "'"); unparseSqlIntervalQualifier(writer, interval.getIntervalQualifier(), RelDataTypeSystem.DEFAULT); }