org.apache.calcite.sql.SqlDialect.unparseCall java code examples

Common ways to obtain SqlDialect

private void myMethod () {
 SqlDialect s =SqlDialectFactory dialectFactory;DataSource dataSource;JdbcSchema.createDialect(dialectFactory, dataSource)
SqlDialect.DatabaseProduct sqlDialectDatabaseProduct;sqlDialectDatabaseProduct.getDialect()
SqlDialect.Context context;new HiveSqlDialect(context)
Smart code suggestions by Tabnine
}

 @Override public void unparseCall(SqlWriter writer, SqlCall call,
   int leftPrec, int rightPrec) {
  if (call instanceof SqlSelect) {
   callsUnparseCallOnSqlSelect[0] = true;
  }
  super.unparseCall(writer, call, leftPrec, rightPrec);
 }
};

 @Override public void unparseCall(SqlWriter writer, SqlCall call,
   int leftPrec, int rightPrec) {
  if (call instanceof SqlSelect) {
   callsUnparseCallOnSqlSelect[0] = true;
  }
  super.unparseCall(writer, call, leftPrec, rightPrec);
 }
};

@Override public void unparseCall(SqlWriter writer, SqlCall call,
  int leftPrec, int rightPrec) {
 switch (call.getKind()) {
 case FLOOR:
  if (call.operandCount() != 2) {
   super.unparseCall(writer, call, leftPrec, rightPrec);
   return;
  }
  unparseFloor(writer, call);
  break;
 default:
  super.unparseCall(writer, call, leftPrec, rightPrec);
 }
}

@Override public void unparseCall(SqlWriter writer, SqlCall call,
  int leftPrec, int rightPrec) {
 switch (call.getKind()) {
 case FLOOR:
  if (call.operandCount() != 2) {
   super.unparseCall(writer, call, leftPrec, rightPrec);
   return;
  }
  unparseFloor(writer, call);
  break;
 default:
  super.unparseCall(writer, call, leftPrec, rightPrec);
 }
}

@Override public void unparse(SqlWriter writer, int leftPrec, int rightPrec) {
 if (!writer.inQuery()) {
  // If this SELECT is the topmost item in a sub-query, introduce a new
  // frame. (The topmost item in the sub-query might be a UNION or
  // ORDER. In this case, we don't need a wrapper frame.)
  final SqlWriter.Frame frame =
    writer.startList(SqlWriter.FrameTypeEnum.SUB_QUERY, "(", ")");
  writer.getDialect().unparseCall(writer, this, 0, 0);
  writer.endList(frame);
 } else {
  writer.getDialect().unparseCall(writer, this, leftPrec, rightPrec);
 }
}

@Override public void unparse(SqlWriter writer, int leftPrec, int rightPrec) {
 if (!writer.inQuery()) {
  // If this SELECT is the topmost item in a sub-query, introduce a new
  // frame. (The topmost item in the sub-query might be a UNION or
  // ORDER. In this case, we don't need a wrapper frame.)
  final SqlWriter.Frame frame =
    writer.startList(SqlWriter.FrameTypeEnum.SUB_QUERY, "(", ")");
  writer.getDialect().unparseCall(writer, this, 0, 0);
  writer.endList(frame);
 } else {
  writer.getDialect().unparseCall(writer, this, leftPrec, rightPrec);
 }
}

@Override public void unparseCall(SqlWriter writer, SqlCall call,
  int leftPrec, int rightPrec) {
 if (call.getOperator() == SqlStdOperatorTable.SUBSTRING) {
  if (call.operandCount() != 3) {
   throw new IllegalArgumentException("MSSQL SUBSTRING requires FROM and FOR arguments");
  }
  SqlUtil.unparseFunctionSyntax(MSSQL_SUBSTRING, writer, call);
 } else {
  switch (call.getKind()) {
  case FLOOR:
   if (call.operandCount() != 2) {
    super.unparseCall(writer, call, leftPrec, rightPrec);
    return;
   }
   unparseFloor(writer, call);
   break;
  default:
   super.unparseCall(writer, call, leftPrec, rightPrec);
  }
 }
}

@Override public void unparseCall(SqlWriter writer, SqlCall call,
  int leftPrec, int rightPrec) {
 if (call.getOperator() == SqlStdOperatorTable.SUBSTRING) {
  if (call.operandCount() != 3) {
   throw new IllegalArgumentException("MSSQL SUBSTRING requires FROM and FOR arguments");
  }
  SqlUtil.unparseFunctionSyntax(MSSQL_SUBSTRING, writer, call);
 } else {
  switch (call.getKind()) {
  case FLOOR:
   if (call.operandCount() != 2) {
    super.unparseCall(writer, call, leftPrec, rightPrec);
    return;
   }
   unparseFloor(writer, call);
   break;
  default:
   super.unparseCall(writer, call, leftPrec, rightPrec);
  }
 }
}

public void unparse(
  SqlWriter writer,
  int leftPrec,
  int rightPrec) {
 final SqlOperator operator = getOperator();
 final SqlDialect dialect = writer.getDialect();
 if (leftPrec > operator.getLeftPrec()
   || (operator.getRightPrec() <= rightPrec && (rightPrec != 0))
   || writer.isAlwaysUseParentheses() && isA(SqlKind.EXPRESSION)) {
  final SqlWriter.Frame frame = writer.startList("(", ")");
  dialect.unparseCall(writer, this, 0, 0);
  writer.endList(frame);
 } else {
  dialect.unparseCall(writer, this, leftPrec, rightPrec);
 }
}

public void unparse(
  SqlWriter writer,
  int leftPrec,
  int rightPrec) {
 final SqlOperator operator = getOperator();
 final SqlDialect dialect = writer.getDialect();
 if (leftPrec > operator.getLeftPrec()
   || (operator.getRightPrec() <= rightPrec && (rightPrec != 0))
   || writer.isAlwaysUseParentheses() && isA(SqlKind.EXPRESSION)) {
  final SqlWriter.Frame frame = writer.startList("(", ")");
  dialect.unparseCall(writer, this, 0, 0);
  writer.endList(frame);
 } else {
  dialect.unparseCall(writer, this, leftPrec, rightPrec);
 }
}

 @Override public void unparseCall(SqlWriter writer, SqlCall call,
   int leftPrec, int rightPrec) {
  switch (call.getKind()) {
  case FLOOR:
   if (call.operandCount() != 2) {
    super.unparseCall(writer, call, leftPrec, rightPrec);
    return;
   }

   final SqlLiteral timeUnitNode = call.operand(1);
   final TimeUnitRange timeUnit = timeUnitNode.getValueAs(TimeUnitRange.class);

   SqlCall call2 = SqlFloorFunction.replaceTimeUnitOperand(call, timeUnit.name(),
     timeUnitNode.getParserPosition());
   SqlFloorFunction.unparseDatetimeFunction(writer, call2, "DATE_TRUNC", false);
   break;

  default:
   super.unparseCall(writer, call, leftPrec, rightPrec);
  }
 }
}

@Override public void unparseCall(SqlWriter writer, SqlCall call,
  int leftPrec, int rightPrec) {
 switch (call.getKind()) {
 case FLOOR:
  if (call.operandCount() != 2) {
   super.unparseCall(writer, call, leftPrec, rightPrec);
   return;
  }
  final SqlLiteral timeUnitNode = call.operand(1);
  final TimeUnitRange timeUnit = timeUnitNode.getValueAs(TimeUnitRange.class);
  final String translatedLit = convertTimeUnit(timeUnit);
  SqlCall call2 = SqlFloorFunction.replaceTimeUnitOperand(call, translatedLit,
    timeUnitNode.getParserPosition());
  SqlFloorFunction.unparseDatetimeFunction(writer, call2, "TRUNC", true);
  break;
 default:
  super.unparseCall(writer, call, leftPrec, rightPrec);
 }
}

 @Override public void unparseCall(SqlWriter writer, SqlCall call,
   int leftPrec, int rightPrec) {
  switch (call.getKind()) {
  case FLOOR:
   if (call.operandCount() != 2) {
    super.unparseCall(writer, call, leftPrec, rightPrec);
    return;
   }

   final SqlLiteral timeUnitNode = call.operand(1);
   final TimeUnitRange timeUnit = timeUnitNode.getValueAs(TimeUnitRange.class);

   SqlCall call2 = SqlFloorFunction.replaceTimeUnitOperand(call, timeUnit.name(),
     timeUnitNode.getParserPosition());
   SqlFloorFunction.unparseDatetimeFunction(writer, call2, "DATE_TRUNC", false);
   break;

  default:
   super.unparseCall(writer, call, leftPrec, rightPrec);
  }
 }
}

@Override public void unparseCall(SqlWriter writer, SqlCall call,
  int leftPrec, int rightPrec) {
 switch (call.getKind()) {
 case FLOOR:
  if (call.operandCount() != 2) {
   super.unparseCall(writer, call, leftPrec, rightPrec);
   return;
  }
  final SqlLiteral timeUnitNode = call.operand(1);
  final TimeUnitRange timeUnit = timeUnitNode.getValueAs(TimeUnitRange.class);
  final String translatedLit = convertTimeUnit(timeUnit);
  SqlCall call2 = SqlFloorFunction.replaceTimeUnitOperand(call, translatedLit,
    timeUnitNode.getParserPosition());
  SqlFloorFunction.unparseDatetimeFunction(writer, call2, "TRUNC", true);
  break;
 default:
  super.unparseCall(writer, call, leftPrec, rightPrec);
 }
}

 @Override public void unparseCall(SqlWriter writer, SqlCall call,
   int leftPrec, int rightPrec) {
  if (call.getOperator() == SqlStdOperatorTable.SUBSTRING) {
   SqlUtil.unparseFunctionSyntax(OracleSqlOperatorTable.SUBSTR, writer, call);
  } else {
   switch (call.getKind()) {
   case FLOOR:
    if (call.operandCount() != 2) {
     super.unparseCall(writer, call, leftPrec, rightPrec);
     return;
    }

    final SqlLiteral timeUnitNode = call.operand(1);
    final TimeUnitRange timeUnit = timeUnitNode.getValueAs(TimeUnitRange.class);

    SqlCall call2 = SqlFloorFunction.replaceTimeUnitOperand(call, timeUnit.name(),
      timeUnitNode.getParserPosition());
    SqlFloorFunction.unparseDatetimeFunction(writer, call2, "TRUNC", true);
    break;

   default:
    super.unparseCall(writer, call, leftPrec, rightPrec);
   }
  }
 }
}

 @Override public void unparseCall(SqlWriter writer, SqlCall call,
   int leftPrec, int rightPrec) {
  if (call.getOperator() == SqlStdOperatorTable.SUBSTRING) {
   SqlUtil.unparseFunctionSyntax(OracleSqlOperatorTable.SUBSTR, writer, call);
  } else {
   switch (call.getKind()) {
   case FLOOR:
    if (call.operandCount() != 2) {
     super.unparseCall(writer, call, leftPrec, rightPrec);
     return;
    }

    final SqlLiteral timeUnitNode = call.operand(1);
    final TimeUnitRange timeUnit = timeUnitNode.getValueAs(TimeUnitRange.class);

    SqlCall call2 = SqlFloorFunction.replaceTimeUnitOperand(call, timeUnit.name(),
      timeUnitNode.getParserPosition());
    SqlFloorFunction.unparseDatetimeFunction(writer, call2, "TRUNC", true);
    break;

   default:
    super.unparseCall(writer, call, leftPrec, rightPrec);
   }
  }
 }
}

Popular methods of SqlDialect

quoteStringLiteral
Converts a string into a string literal. For example, can't run becomes 'can''t run'.
<init>
Creates a SqlDialect.
quoteIdentifier
Quotes a multi-part identifier.
supportsAggregateFunction
supportsCharSet
Returns whether the dialect supports character set names as part of a data type, for instance VARCHA
allowsAs
containsNonAscii
Returns whether the string contains any characters outside the comfortable 7-bit ASCII range (32 thr
defaultNullDirection
Returns whether NULL values are sorted first or last, in this dialect, in an ORDER BY item of a give
emulateNullDirection
Returns the SqlNode for emulating the null direction for the given field or null if no emulation ne
getCalendarPolicy
getCastSpec
getDatabaseProduct
Returns the database this dialect belongs to, SqlDialect.DatabaseProduct#UNKNOWN if not known, never

Popular in Java

Running tasks concurrently on multiple threads
onRequestPermissionsResult (Fragment)
runOnUiThread (Activity)
orElseThrow (Optional)
Return the contained value, if present, otherwise throw an exception to be created by the provided s
ResultSet (java.sql)
An interface for an object which represents a database table entry, returned as the result of the qu
DecimalFormat (java.text)
A concrete subclass of NumberFormat that formats decimal numbers. It has a variety of features desig
Iterator (java.util)
An iterator over a sequence of objects, such as a collection.If a collection has been changed since
Stack (java.util)
Stack is a Last-In/First-Out(LIFO) data structure which represents a stack of objects. It enables u
Base64 (org.apache.commons.codec.binary)
Provides Base64 encoding and decoding as defined by RFC 2045.This class implements section 6.8. Base
DateTimeFormat (org.joda.time.format)
Factory that creates instances of DateTimeFormatter from patterns and styles. Datetime formatting i
Top 15 Vim Plugins

How to use unparseCallmethodin org.apache.calcite.sql.SqlDialect

Best Java code snippets using org.apache.calcite.sql.SqlDialect.unparseCall (Showing top 16 results out of 315)

How to use
unparseCall
method
in
org.apache.calcite.sql.SqlDialect