@Override public void writeWithItem(SqlCall call, SqlWithItem.SqlWithItemOperator sqlWithItemOperator, int leftPrec, int rightPrec) { final SqlWithItem withItem = (SqlWithItem) call; leftPrec = sqlWithItemOperator.getLeftPrec(); rightPrec = sqlWithItemOperator.getRightPrec(); withItem.name.unparse(this, leftPrec, rightPrec); if (withItem.columnList != null) { withItem.columnList.unparse(this, leftPrec, rightPrec); } this.keyword("AS"); Frame frame = this.startList(FrameTypeEnum.WITH_ITEM, "(", ")"); withItem.query.unparse(this, 10, 10); this.endList(frame); } }
public void unparse( SqlWriter writer, SqlCall call, int leftPrec, int rightPrec) { final SqlWithItem withItem = (SqlWithItem) call; withItem.name.unparse(writer, getLeftPrec(), getRightPrec()); if (withItem.columnList != null) { withItem.columnList.unparse(writer, getLeftPrec(), getRightPrec()); } writer.keyword("AS"); withItem.query.unparse(writer, 10, 10); }
public void unparse( SqlWriter writer, SqlCall call, int leftPrec, int rightPrec) { final SqlWithItem withItem = (SqlWithItem) call; withItem.name.unparse(writer, getLeftPrec(), getRightPrec()); if (withItem.columnList != null) { withItem.columnList.unparse(writer, getLeftPrec(), getRightPrec()); } writer.keyword("AS"); withItem.query.unparse(writer, 10, 10); }
@Override public void writeWithItem(SqlCall call, SqlWithItem.SqlWithItemOperator sqlWithItemOperator, int leftPrec, int rightPrec) { final SqlWithItem withItem = (SqlWithItem) call; leftPrec = sqlWithItemOperator.getLeftPrec(); rightPrec = sqlWithItemOperator.getRightPrec(); withItem.name.unparse(this, leftPrec, rightPrec); if (withItem.columnList != null) { withItem.columnList.unparse(this, leftPrec, rightPrec); } this.keyword("AS"); Frame frame = this.startList(FrameTypeEnum.WITH_ITEM, "(", ")"); withItem.query.unparse(this, 10, 10); this.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); }
writer.keyword("PRIMARY KEY"); SqlWriter.Frame keyFrame = writer.startList("(", ")"); primaryKeyList.unparse(writer, leftPrec, rightPrec); writer.endList(keyFrame); writer.keyword("UNIQUE"); SqlWriter.Frame keyFrame = writer.startList("(", ")"); uniqueKeyList.unparse(writer, leftPrec, rightPrec); writer.endList(keyFrame); index.indexKeys.unparse(writer, leftPrec, rightPrec); writer.endList(keyFrame);
writer.sep("PARTITION BY"); final SqlWriter.Frame partitionFrame = writer.startList("", ""); window.partitionList.unparse(writer, 0, 0); writer.endList(partitionFrame); writer.sep("ORDER BY"); final SqlWriter.Frame orderFrame = writer.startList("", ""); window.orderList.unparse(writer, 0, 0); writer.endList(orderFrame);
writer.sep("PARTITION BY"); final SqlWriter.Frame partitionFrame = writer.startList("", ""); window.partitionList.unparse(writer, 0, 0); writer.endList(partitionFrame); writer.sep("ORDER BY"); final SqlWriter.Frame orderFrame = writer.startList("", ""); window.orderList.unparse(writer, 0, 0); writer.endList(orderFrame);
writer.sep("PARTITION BY"); final SqlWriter.Frame partitionFrame = writer.startList("", ""); pattern.partitionList.unparse(writer, 0, 0); writer.endList(partitionFrame); writer.sep("MEASURES"); final SqlWriter.Frame measureFrame = writer.startList("", ""); pattern.measureList.unparse(writer, 0, 0); writer.endList(measureFrame); writer.sep("SUBSET"); SqlWriter.Frame subsetFrame = writer.startList("", ""); pattern.subsetList.unparse(writer, 0, 0); writer.endList(subsetFrame); call2.operand(0))); newDefineList.unparse(writer, 0, 0); writer.endList(patternDefFrame); writer.endList(mrFrame);
writer.sep("PARTITION BY"); final SqlWriter.Frame partitionFrame = writer.startList("", ""); pattern.partitionList.unparse(writer, 0, 0); writer.endList(partitionFrame); writer.sep("MEASURES"); final SqlWriter.Frame measureFrame = writer.startList("", ""); pattern.measureList.unparse(writer, 0, 0); writer.endList(measureFrame); writer.sep("SUBSET"); SqlWriter.Frame subsetFrame = writer.startList("", ""); pattern.subsetList.unparse(writer, 0, 0); writer.endList(subsetFrame); call2.operand(0))); newDefineList.unparse(writer, 0, 0); writer.endList(patternDefFrame); writer.endList(mrFrame);
writer.keyword("WHEN NOT MATCHED THEN INSERT"); if (insertCall.getTargetColumnList() != null) { insertCall.getTargetColumnList().unparse(writer, opLeft, opRight);
writer.keyword("WHEN NOT MATCHED THEN INSERT"); if (insertCall.getTargetColumnList() != null) { insertCall.getTargetColumnList().unparse(writer, opLeft, opRight);