@Override public void unparse( SqlWriter writer, SqlCall call, int leftPrec, int rightPrec) { List<SqlNode> opList = call.getOperandList(); assert (opList.size() >= 1); SqlNode sqlNode = opList.get(0); sqlNode.unparse(writer, leftPrec, getLeftPrec()); writer.sep("IN"); Frame frame = writer.startList(FrameTypeEnum.SETOP, "(", ")"); for (SqlNode op : opList.subList(1, opList.size())) { writer.sep(","); op.unparse(writer, 0, 0); } writer.endList(frame); } }
@Override public void unparse(SqlWriter writer, SqlCall call, int leftPrec, int rightPrec) { SqlWriter.Frame frame = writer.startList("{-", "-}"); SqlNode node = call.getOperandList().get(0); node.unparse(writer, 0, 0); writer.endList(frame); } };
@Override public void unparse(SqlWriter writer, SqlCall call, int leftPrec, int rightPrec) { SqlWriter.Frame frame = writer.startList("{-", "-}"); SqlNode node = call.getOperandList().get(0); node.unparse(writer, 0, 0); writer.endList(frame); } };
@Override public void unparse(SqlWriter writer, SqlCall call, int leftPrec, int rightPrec) { SqlWriter.Frame frame = writer.startList("{-", "-}"); SqlNode node = call.getOperandList().get(0); node.unparse(writer, 0, 0); writer.endList(frame); } };
public void unparse( SqlWriter writer, SqlCall call, int leftPrec, int rightPrec) { final SqlWriter.Frame frame = writer.startList("(", ")"); call.operand(0).unparse(writer, 0, 0); writer.endList(frame); }
public void unparse( SqlWriter writer, SqlCall call, int leftPrec, int rightPrec) { final SqlWriter.Frame frame = writer.startList("(", ")"); call.operand(0).unparse(writer, 0, 0); writer.endList(frame); }
@Override public void unparse(SqlWriter writer, SqlCall call, int leftPrec, int rightPrec) { final SqlWriter.Frame frame = writer.startList(SqlWriter.FrameTypeEnum.SIMPLE); arg(writer, call, leftPrec, rightPrec, 0); writer.sep(getName()); arg(writer, call, leftPrec, rightPrec, 1); 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); } }
@Override public void unparse( SqlWriter writer, SqlCall call, int leftPrec, int rightPrec) { call.operand(0).unparse(writer, leftPrec, 0); final SqlWriter.Frame frame = writer.startList("[", "]"); call.operand(1).unparse(writer, 0, 0); writer.endList(frame); }
public void unparse( SqlWriter writer, SqlCall call, int leftPrec, int rightPrec) { writer.keyword("CURSOR"); final SqlWriter.Frame frame = writer.startList("(", ")"); assert call.operandCount() == 1; call.operand(0).unparse(writer, leftPrec, rightPrec); writer.endList(frame); }
@Override public void unparse( SqlWriter writer, SqlCall call, int leftPrec, int rightPrec) { call.operand(0).unparse(writer, leftPrec, 0); final SqlWriter.Frame frame = writer.startList("[", "]"); call.operand(1).unparse(writer, 0, 0); writer.endList(frame); }
@Override public void unparse(SqlWriter writer, SqlCall call, int leftPrec, int rightPrec) { final SqlWriter.Frame frame = writer.startList(SqlWriter.FrameTypeEnum.IDENTIFIER); call.operand(0).unparse(writer, leftPrec, 0); writer.sep("."); call.operand(1).unparse(writer, 0, 0); writer.endList(frame); }
public void unparse( SqlWriter writer, SqlCall call, int leftPrec, int rightPrec) { writer.keyword(getName()); final SqlWriter.Frame frame = writer.startList("(", ")"); assert call.operandCount() == 1; call.operand(0).unparse(writer, leftPrec, rightPrec); writer.endList(frame); }
public void unparseSqlDatetimeArithmetic(SqlWriter writer, SqlCall call, SqlKind sqlKind, int leftPrec, int rightPrec) { final SqlWriter.Frame frame = writer.startList("(", ")"); call.operand(0).unparse(writer, leftPrec, rightPrec); writer.sep((SqlKind.PLUS == sqlKind) ? "+" : "-"); call.operand(1).unparse(writer, leftPrec, rightPrec); writer.endList(frame); //Only two parameters are present normally //Checking parameter count to prevent errors if (call.getOperandList().size() > 2) { call.operand(2).unparse(writer, leftPrec, rightPrec); } }
@Override public void unparse(SqlWriter writer, SqlCall call, int leftPrec, int rightPrec) { assert call.operandCount() == 2; call.operand(0).unparse(writer, 0, 0); writer.keyword("WITHIN GROUP"); final SqlWriter.Frame orderFrame = writer.startList(SqlWriter.FrameTypeEnum.ORDER_BY_LIST, "(", ")"); writer.keyword("ORDER BY"); ((SqlNodeList) call.operand(1)).commaList(writer); writer.endList(orderFrame); }
@Override protected void unparseAlterOperation(SqlWriter writer, int leftPrec, int rightPrec) { writer.keyword("UPLOAD"); writer.keyword("JAR"); SqlWriter.Frame frame = writer.startList("", ""); for (SqlNode jarPath : jarPaths) { jarPath.unparse(writer, leftPrec, rightPrec); } writer.endList(frame); } }
@Override protected void unparseAlterOperation(SqlWriter writer, int leftPrec, int rightPrec) { writer.keyword("UPLOAD"); writer.keyword("JAR"); SqlWriter.Frame frame = writer.startList("", ""); for (SqlNode jarPath : jarPaths) { jarPath.unparse(writer, leftPrec, rightPrec); } writer.endList(frame); } }
@Override public void unparse(SqlWriter writer, int leftPrec, int rightPrec) { writer.startList(SqlWriter.FrameTypeEnum.SELECT); writer.sep(isUpsert() ? "UPSERT INTO" : "INSERT INTO"); final int opLeft = getOperator().getLeftPrec(); final int opRight = getOperator().getRightPrec(); targetTable.unparse(writer, opLeft, opRight); if (columnList != null) { columnList.unparse(writer, opLeft, opRight); } writer.newlineAndIndent(); source.unparse(writer, 0, 0); }
@Override public void unparse(SqlWriter writer, int leftPrec, int rightPrec) { writer.startList(SqlWriter.FrameTypeEnum.SELECT); writer.sep(isUpsert() ? "UPSERT INTO" : "INSERT INTO"); final int opLeft = getOperator().getLeftPrec(); final int opRight = getOperator().getRightPrec(); targetTable.unparse(writer, opLeft, opRight); if (columnList != null) { columnList.unparse(writer, opLeft, opRight); } writer.newlineAndIndent(); source.unparse(writer, 0, 0); }