oracle.pg.rdbms.pgql

Class PgqlCreatePgTranslator

java.lang.Object

oracle.pg.rdbms.pgql.PgqlCreatePgTranslator

public class PgqlCreatePgTranslator
extends java.lang.Object

This class is the main driver for PGQL-to-SQL translation of CREATE PROPERTY GRAPH statement.

Constructor Summary

Constructors

Constructor and Description
PgqlCreatePgTranslator()

Method Summary

Modifier and Type	Method and Description
static int	getPGSchemaType(java.lang.String columnType) Returns the PG schema type that corresponds to given column type
static int	getPGSchemaTypeForNumber(java.lang.String columnType) Returns the PG schema type that corresponds to the NUMBER column with the given scale and precision
static int	getPGSchemaTypeForNumber(java.lang.String dataPrecision, java.lang.String dataScale) Returns the PG schema type that corresponds to a NUMBER column with the given scale and precision
static java.lang.String	getPGSchemaValueExpression(java.lang.String columnType) Returns the PG schema expression that can be used to populate v, vn or vt column according to the given column type
static java.lang.StringBuilder	getValueColumnsTranslation(java.lang.String columnType) Returns a SQL select expression to populate v, vn and vt columns depending on the column type
static java.lang.String	getVColumnTranslation(java.lang.String columnType) Returns a SQL select expression to populate V column from V, VN and VT columns depending on the column type
static PgqlSqlCreateTrans	translateCreatePropertyGraph(oracle.pgql.lang.ddl.propertygraph.CreatePropertyGraph cpg, QueryContext ctx) Main translation method for PGQL CREATE PROPERTY GRAPH.

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

PgqlCreatePgTranslator

public PgqlCreatePgTranslator()

Method Detail

getPGSchemaType

public static int getPGSchemaType(java.lang.String columnType)

Returns the PG schema type that corresponds to given column type

Parameters:

columnType - the column type

Returns:

the corresponding PG schema type

getPGSchemaTypeForNumber

public static int getPGSchemaTypeForNumber(java.lang.String columnType)

Returns the PG schema type that corresponds to the NUMBER column with the given scale and precision

Parameters:

columnType - the NUMBER column type

Returns:

the corresponding PG schema type

getPGSchemaTypeForNumber

public static int getPGSchemaTypeForNumber(java.lang.String dataPrecision,
                                           java.lang.String dataScale)

Returns the PG schema type that corresponds to a NUMBER column with the given scale and precision

Parameters:

dataPrecision - the precision of the column

dataScale - the scale of the column

Returns:

the orresponding PG schema type

getPGSchemaValueExpression

public static java.lang.String getPGSchemaValueExpression(java.lang.String columnType)

Returns the PG schema expression that can be used to populate v, vn or vt column according to the given column type

Parameters:

columnType - the column type

Returns:

the corresponding PG schema expression

getValueColumnsTranslation

public static java.lang.StringBuilder getValueColumnsTranslation(java.lang.String columnType)

Returns a SQL select expression to populate v, vn and vt columns depending on the column type

Parameters:

columnType - the column type

Returns:

the select expression to populate v, vn and vt

getVColumnTranslation

public static java.lang.String getVColumnTranslation(java.lang.String columnType)

Returns a SQL select expression to populate V column from V, VN and VT columns depending on the column type

Parameters:

columnType - the column type

Returns:

the select expression to populate v

translateCreatePropertyGraph

public static PgqlSqlCreateTrans translateCreatePropertyGraph(oracle.pgql.lang.ddl.propertygraph.CreatePropertyGraph cpg,
                                                              QueryContext ctx)

Main translation method for PGQL CREATE PROPERTY GRAPH. Creates a couple of SQL queries that can be used to populate PG schema tables.

Parameters:

cpg - the create property graph that should be translated

ctx - the Query context

Returns:

the SQL translation of given CREATE PROPERTY GRAPH