Top Description Fields Constructors Methods
com.mysql.cj.xdevapi

public Class ExprUtil

extends Object
Class Inheritance
Imports
java.math.BigDecimal, .BigInteger, java.sql.Date, .Time, .Timestamp, java.text.SimpleDateFormat, java.util.stream.Collectors, com.google.protobuf.ByteString, com.mysql.cj.exceptions.FeatureNotAvailableException, .WrongArgumentException, com.mysql.cj.util.TimeUtil, com.mysql.cj.x.protobuf.MysqlxCrud.Collection, .MysqlxDatatypes.Any, .MysqlxDatatypes.Scalar, .MysqlxDatatypes.Scalar.Octets, .MysqlxExpr.Expr
Utilities to deal with Expr (and related) structures.

Field Summary

Modifier and TypeField and Description
private static SimpleDateFormat
javaSqlDateFormat

private static SimpleDateFormat
javaSqlTimeFormat

private static SimpleDateFormat
javaSqlTimestampFormat

private static SimpleDateFormat
javaUtilDateFormat

Constructor Summary

AccessConstructor and Description
public
ExprUtil()

Method Summary

Modifier and TypeMethod and Description
public static MysqlxDatatypes.Any

Returns:

Any
anyOf(MysqlxDatatypes.Scalar
value
s)

Protocol buffers helper to build an Any Scalar type.

public static MysqlxExpr.Expr

Returns:

Expr
argObjectToExpr(Object
value
value, boolean
Are relational columns identifiers allowed?
allowRelationalColumns)

Protocol buffers helper to build Expr with any object.

public static MysqlxDatatypes.Scalar

Returns:

Scalar
argObjectToScalar(Object
value
value)

Protocol buffers helper to build a Scalar type with any object.

public static MysqlxDatatypes.Any

Returns:

Any
argObjectToScalarAny(Object
value
value)

Protocol buffers helper to build an Any type with any object.

public static MysqlxDatatypes.Any

Returns:

Any
buildAny(String
value
str)

Build a Protocol buffers Any with a string value.

public static MysqlxDatatypes.Any

Returns:

Any
buildAny(boolean
value
b)

Build a Protocol buffers Any with a boolean value.

public static MysqlxCrud.Collection

Returns:

Collection
buildCollection(String
schema name
schemaName, String
collection name
collectionName)

Build a Protocol buffers Collection.

public static MysqlxExpr.Expr

Returns:

Expr
buildLiteralExpr(MysqlxDatatypes.Scalar
Scalar
scalar)

Wrap an Any value in a LITERAL expression.

public static MysqlxExpr.Expr

Returns:

Expr
buildLiteralNullScalar()

Protocol buffers helper to build a LITERAL Expr with a Scalar NULL type.

public static MysqlxExpr.Expr

Returns:

Expr
buildLiteralScalar(double
value
d)

Protocol buffers helper to build a LITERAL Expr with a Scalar DOUBLE type.

public static MysqlxExpr.Expr

Returns:

Expr
buildLiteralScalar(long
value
l)

Protocol buffers helper to build a LITERAL Expr with a Scalar SINT (signed int) type.

public static MysqlxExpr.Expr

Returns:

Expr
buildLiteralScalar(String
value
str)

Protocol buffers helper to build a LITERAL Expr with a Scalar STRING type.

public static MysqlxExpr.Expr

Returns:

Expr
buildLiteralScalar(byte[]
value
bytes)

Protocol buffers helper to build a LITERAL Expr with a Scalar OCTETS type.

public static MysqlxExpr.Expr

Returns:

Expr
buildLiteralScalar(boolean
value
b)

Protocol buffers helper to build a LITERAL Expr with a Scalar BOOL type.

public static MysqlxExpr.Expr

Returns:

Expr
buildPlaceholderExpr(int
the position of the placeholder in the args array
pos)

Creates a placeholder expression for the given position in the args array

public static MysqlxDatatypes.Scalar

Returns:

Scalar
nullScalar()

Protocol buffers helper to build a Scalar NULL type.

public static MysqlxDatatypes.Scalar

Returns:

Scalar
scalarOf(double
value
d)

Protocol buffers helper to build a Scalar DOUBLE type.

public static MysqlxDatatypes.Scalar

Returns:

Scalar
scalarOf(long
value
l)

Protocol buffers helper to build a Scalar SINT (signed int) type.

public static MysqlxDatatypes.Scalar

Returns:

Scalar
scalarOf(String
value
str)

Protocol buffers helper to build a Scalar STRING type.

public static MysqlxDatatypes.Scalar

Returns:

Scalar
scalarOf(byte[]
value
bytes)

Protocol buffers helper to build a Scalar OCTETS type.

public static MysqlxDatatypes.Scalar

Returns:

Scalar
scalarOf(boolean
value
b)

Protocol buffers helper to build a Scalar BOOL type.

Inherited from java.lang.Object:
cloneequalsfinalizegetClasshashCodenotifynotifyAlltoStringwaitwaitwait

Field Detail

javaSqlDateFormatback to summary
private static SimpleDateFormat javaSqlDateFormat
javaSqlTimeFormatback to summary
private static SimpleDateFormat javaSqlTimeFormat
javaSqlTimestampFormatback to summary
private static SimpleDateFormat javaSqlTimestampFormat
javaUtilDateFormatback to summary
private static SimpleDateFormat javaUtilDateFormat

Constructor Detail

ExprUtilback to summary
public ExprUtil()

Method Detail

anyOfback to summary
public static MysqlxDatatypes.Any anyOf(MysqlxDatatypes.Scalar s)

Protocol buffers helper to build an Any Scalar type.

Parameters
s:MysqlxDatatypes.Scalar

value

Returns:MysqlxDatatypes.Any

Any

argObjectToExprback to summary
public static MysqlxExpr.Expr argObjectToExpr(Object value, boolean allowRelationalColumns)

Protocol buffers helper to build Expr with any object.

Parameters
value:Object

value

allowRelationalColumns:boolean

Are relational columns identifiers allowed?

Returns:MysqlxExpr.Expr

Expr

argObjectToScalarback to summary
public static MysqlxDatatypes.Scalar argObjectToScalar(Object value)

Protocol buffers helper to build a Scalar type with any object.

Parameters
value:Object

value

Returns:MysqlxDatatypes.Scalar

Scalar

argObjectToScalarAnyback to summary
public static MysqlxDatatypes.Any argObjectToScalarAny(Object value)

Protocol buffers helper to build an Any type with any object.

Parameters
value:Object

value

Returns:MysqlxDatatypes.Any

Any

buildAnyback to summary
public static MysqlxDatatypes.Any buildAny(String str)

Build a Protocol buffers Any with a string value.

Parameters
str:String

value

Returns:MysqlxDatatypes.Any

Any

buildAnyback to summary
public static MysqlxDatatypes.Any buildAny(boolean b)

Build a Protocol buffers Any with a boolean value.

Parameters
b:boolean

value

Returns:MysqlxDatatypes.Any

Any

buildCollectionback to summary
public static MysqlxCrud.Collection buildCollection(String schemaName, String collectionName)

Build a Protocol buffers Collection.

Parameters
schemaName:String

schema name

collectionName:String

collection name

Returns:MysqlxCrud.Collection

Collection

buildLiteralExprback to summary
public static MysqlxExpr.Expr buildLiteralExpr(MysqlxDatatypes.Scalar scalar)

Wrap an Any value in a LITERAL expression.

Parameters
scalar:MysqlxDatatypes.Scalar

Scalar

Returns:MysqlxExpr.Expr

Expr

buildLiteralNullScalarback to summary
public static MysqlxExpr.Expr buildLiteralNullScalar()

Protocol buffers helper to build a LITERAL Expr with a Scalar NULL type.

Returns:MysqlxExpr.Expr

Expr

buildLiteralScalarback to summary
public static MysqlxExpr.Expr buildLiteralScalar(double d)

Protocol buffers helper to build a LITERAL Expr with a Scalar DOUBLE type.

Parameters
d:double

value

Returns:MysqlxExpr.Expr

Expr

buildLiteralScalarback to summary
public static MysqlxExpr.Expr buildLiteralScalar(long l)

Protocol buffers helper to build a LITERAL Expr with a Scalar SINT (signed int) type.

Parameters
l:long

value

Returns:MysqlxExpr.Expr

Expr

buildLiteralScalarback to summary
public static MysqlxExpr.Expr buildLiteralScalar(String str)

Protocol buffers helper to build a LITERAL Expr with a Scalar STRING type.

Parameters
str:String

value

Returns:MysqlxExpr.Expr

Expr

buildLiteralScalarback to summary
public static MysqlxExpr.Expr buildLiteralScalar(byte[] bytes)

Protocol buffers helper to build a LITERAL Expr with a Scalar OCTETS type.

Parameters
bytes:byte[]

value

Returns:MysqlxExpr.Expr

Expr

buildLiteralScalarback to summary
public static MysqlxExpr.Expr buildLiteralScalar(boolean b)

Protocol buffers helper to build a LITERAL Expr with a Scalar BOOL type.

Parameters
b:boolean

value

Returns:MysqlxExpr.Expr

Expr

buildPlaceholderExprback to summary
public static MysqlxExpr.Expr buildPlaceholderExpr(int pos)

Creates a placeholder expression for the given position in the args array

Parameters
pos:int

the position of the placeholder in the args array

Returns:MysqlxExpr.Expr

Expr

nullScalarback to summary
public static MysqlxDatatypes.Scalar nullScalar()

Protocol buffers helper to build a Scalar NULL type.

Returns:MysqlxDatatypes.Scalar

Scalar

scalarOfback to summary
public static MysqlxDatatypes.Scalar scalarOf(double d)

Protocol buffers helper to build a Scalar DOUBLE type.

Parameters
d:double

value

Returns:MysqlxDatatypes.Scalar

Scalar

scalarOfback to summary
public static MysqlxDatatypes.Scalar scalarOf(long l)

Protocol buffers helper to build a Scalar SINT (signed int) type.

Parameters
l:long

value

Returns:MysqlxDatatypes.Scalar

Scalar

scalarOfback to summary
public static MysqlxDatatypes.Scalar scalarOf(String str)

Protocol buffers helper to build a Scalar STRING type.

Parameters
str:String

value

Returns:MysqlxDatatypes.Scalar

Scalar

scalarOfback to summary
public static MysqlxDatatypes.Scalar scalarOf(byte[] bytes)

Protocol buffers helper to build a Scalar OCTETS type.

Parameters
bytes:byte[]

value

Returns:MysqlxDatatypes.Scalar

Scalar

scalarOfback to summary
public static MysqlxDatatypes.Scalar scalarOf(boolean b)

Protocol buffers helper to build a Scalar BOOL type.

Parameters
b:boolean

value

Returns:MysqlxDatatypes.Scalar

Scalar