oracle.pg.common

Class OracleConvertersUtilsBase

java.lang.Object

oracle.pg.common.OracleConvertersUtilsBase

public class OracleConvertersUtilsBase
extends java.lang.Object

A set of utilities for converting data (CSV, Relational Tables) into property graph data.

Constructor Summary

Constructors

Constructor and Description
OracleConvertersUtilsBase()

Method Summary

Modifier and Type	Method and Description
static void	convertCSV2OPE(java.io.InputStream inCSV, java.lang.String eidColName, long lOffsetEID, java.lang.String svidColName, java.lang.String dvidColName, boolean hasEdgeLabelCol, java.lang.String elColName, ColumnToAttrMapping[] ctams, int dop, char delimiterChar, char quotationChar, long lOffsetLines, java.text.DateFormat dateFormat, boolean allowMultiline, java.io.OutputStream opeOS, DataConverterListener dcl) Converts a property graph file for edges in CSV format into Oracle Flat File format.
static void	convertCSV2OPE(java.io.InputStream inCSV, java.lang.String eidColName, long lOffsetEID, java.lang.String svidColName, java.lang.String dvidColName, boolean hasEdgeLabelCol, java.lang.String elColName, ColumnToAttrMapping[] ctams, int dop, char delimiterChar, char quotationChar, long lOffsetLines, java.text.DateFormat dateFormat, java.io.OutputStream opeOS, DataConverterListener dcl) Converts a property graph file for edges in CSV format into Oracle Flat File format.
static void	convertCSV2OPE(java.io.InputStream inCSV, java.lang.String eidColName, long lOffsetEID, java.lang.String svidColName, java.lang.String dvidColName, boolean hasEdgeLabelCol, java.lang.String elColName, ColumnToAttrMapping[] ctams, int dop, long lOffsetLines, java.text.DateFormat dateFormat, java.io.OutputStream opeOS, DataConverterListener dcl) Converts a property graph file for edges in CSV format into Oracle Flat File format.
static void	convertCSV2OPE(java.io.InputStream inCSV, java.lang.String eidColName, long lOffsetEID, java.lang.String svidColName, java.lang.String dvidColName, boolean hasEdgeLabelCol, java.lang.String elColName, ColumnToAttrMapping[] ctams, int dop, long lOffsetLines, java.io.OutputStream opeOS, DataConverterListener dcl) Converts a property graph file for edges in CSV format into Oracle Flat File format.
static void	convertCSV2OPE(java.io.InputStream inCSV, java.lang.String eidColName, long lOffsetEID, java.lang.String svidColName, java.lang.String dvidColName, long lOffsetVID, boolean hasEdgeLabelCol, java.lang.String elColName, ColumnToAttrMapping[] ctams, int dop, char delimiterChar, char quotationChar, long lOffsetLines, java.text.DateFormat dateFormat, boolean allowMultiline, java.io.OutputStream opeOS, DataConverterListener dcl) Converts a property graph file for edges in CSV format into Oracle Flat File format.
static void	convertCSV2OPE(java.io.InputStream inCSV, java.lang.String eidColName, long lOffsetEID, java.lang.String svidColName, java.lang.String dvidColName, long lOffsetSVID, long lOffsetDVID, boolean hasEdgeLabelCol, java.lang.String elColName, ColumnToAttrMapping[] ctams, int dop, char delimiterChar, char quotationChar, long lOffsetLines, java.text.DateFormat dateFormat, boolean allowMultiline, java.io.OutputStream opeOS, DataConverterListener dcl) Converts a property graph file for edges in CSV format into Oracle Flat File format.
static void	convertCSV2OPV(java.io.InputStream inCSV, java.lang.String vidColName, long lOffsetVID, ColumnToAttrMapping[] ctams, int dop, char delimiterChar, char quotationChar, long lOffsetLines, java.text.DateFormat dateFormat, boolean allowMultiline, java.io.OutputStream opvOS, DataConverterListener dcl) Converts a property graph file for vertices in CSV format into Oracle Flat File format using the specified delimiters.
static void	convertCSV2OPV(java.io.InputStream inCSV, java.lang.String vidColName, long lOffsetVID, ColumnToAttrMapping[] ctams, int dop, char delimiterChar, char quotationChar, long lOffsetLines, java.text.DateFormat dateFormat, java.io.OutputStream opvOS, DataConverterListener dcl) Converts a property graph file for vertices in CSV format into Oracle Flat File format using the specified delimiters.
static void	convertCSV2OPV(java.io.InputStream inCSV, java.lang.String vidColName, long lOffsetVID, ColumnToAttrMapping[] ctams, int dop, long lOffsetLines, java.text.DateFormat dateFormat, java.io.OutputStream opvOS, DataConverterListener dcl) Converts a property graph file for vertices in CSV format into Oracle Flat File format using the specified delimiters.
static void	convertCSV2OPV(java.io.InputStream inCSV, java.lang.String vidColName, long lOffsetVID, ColumnToAttrMapping[] ctams, int dop, long lOffsetLines, java.io.OutputStream opvOS, DataConverterListener dcl) Converts a property graph file for vertices in CSV format into Oracle Flat File format using the specified delimiters.
static void	convertRDBMSTable2OPE(java.sql.Connection conn, java.lang.String rdbmsTableName, java.lang.String eidColName, long lEIDOffset, java.lang.String svidColName, java.lang.String dvidColName, long lVIDOffset, boolean bHasEdgeLabelCol, java.lang.String elColName, ColumnToAttrMapping[] ctams, int dop, java.io.OutputStream opeOS, DataConverterListener dcl) This method converts given rdbms table to a ope file
static void	convertRDBMSTable2OPE(java.sql.Connection conn, java.lang.String rdbmsTableName, java.lang.String eidColName, long lEIDOffset, java.lang.String svidColName, java.lang.String dvidColName, long lSVIDOffset, long lDVIDOffset, boolean bHasEdgeLabelCol, java.lang.String elColName, ColumnToAttrMapping[] ctams, int dop, java.io.OutputStream opeOS, DataConverterListener dcl) This method converts given rdbms table to a ope file
static void	convertRDBMSTable2OPV(java.sql.Connection conn, java.lang.String rdbmsTableName, java.lang.String vidColName, long lVIDOffset, ColumnToAttrMapping[] ctams, int dop, java.io.OutputStream opvOS, DataConverterListener dcl) Converts given rdbms table to a opv file.

Methods inherited from class java.lang.Object

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

Constructor Detail

OracleConvertersUtilsBase

public OracleConvertersUtilsBase()

Method Detail

convertCSV2OPE

public static void convertCSV2OPE(java.io.InputStream inCSV,
                                  java.lang.String eidColName,
                                  long lOffsetEID,
                                  java.lang.String svidColName,
                                  java.lang.String dvidColName,
                                  boolean hasEdgeLabelCol,
                                  java.lang.String elColName,
                                  ColumnToAttrMapping[] ctams,
                                  int dop,
                                  char delimiterChar,
                                  char quotationChar,
                                  long lOffsetLines,
                                  java.text.DateFormat dateFormat,
                                  boolean allowMultiline,
                                  java.io.OutputStream opeOS,
                                  DataConverterListener dcl)

Converts a property graph file for edges in CSV format into Oracle Flat File format. The files in this converter must not include a header if the ColumnToAttrMapping array is supplied with all the details of the column names and their type. If the ColumnToAttrMapping array supplied is null then the files must include a header in the first line.

Parameters:

inCSV - an InputStream object for the CSV file

eidColName - the column name that will be used as EID. If NULL, then the EID will be generated based on the line number. If the given column name does not have a numeric value, the value will be hashed into a long number for the ID.

lOffsetEID - the offset to the EID. Each EID will have a value of (lOffsetEID + EID).

svidColName - the column name that will be used as SVID. If the given column name does not have a numeric value, the value will be hashed into a long number for the ID.

dvidColName - the column name that will be used as DVID. If the given column name does not have a numeric value, the value will be hashed into a long number for the ID.

hasEdgeLabelCol - if true, read from elColName and treat the values as edge labels. If false, use elColName as a constant for all edge labels

elColName - the column name that will be used as edge label

ctams - an array of ColumnToAttrMapping objects. Each ColumnToAttrMapping object defines a mapping from a column in CSV file to an attribute of certain type in an OPE file. These mappings must be in the same order as the values are presented in the CSV file. E.g. If a CSV file includes a header for name,age,weight; the ctams array must include these mappings in the same order.

dop - degree of parallelism used to optimize converting performance.

delimiterChar - the character used to delimit values in a CSV file, e.g. ','

quotationChar - the character used to delimit how to treat quotation characters for values, e.g. '"'

lOffsetLines - in order to skip the first lines of the input file

dateFormat - the preferred Date format used to parse the dates in the CSV file, it can be null.

allowMultiline - Whether or not fields from can contain multiple lines, i.e. contain newline character.

opeOS - the OutputStream object where the OPE file will be written

dcl - an instance of DataConverterListener that can be used to report progress and control the conversion process when an error occurs.

convertCSV2OPE

public static void convertCSV2OPE(java.io.InputStream inCSV,
                                  java.lang.String eidColName,
                                  long lOffsetEID,
                                  java.lang.String svidColName,
                                  java.lang.String dvidColName,
                                  boolean hasEdgeLabelCol,
                                  java.lang.String elColName,
                                  ColumnToAttrMapping[] ctams,
                                  int dop,
                                  char delimiterChar,
                                  char quotationChar,
                                  long lOffsetLines,
                                  java.text.DateFormat dateFormat,
                                  java.io.OutputStream opeOS,
                                  DataConverterListener dcl)

Converts a property graph file for edges in CSV format into Oracle Flat File format. The files in this converter must not include a header if the ColumnToAttrMapping array is supplied with all the details of the column names and their type. If the ColumnToAttrMapping array supplied is null then the files must include a header in the first line.

Parameters:

inCSV - an InputStream object for the CSV file

eidColName - the column name that will be used as EID. If NULL, then the EID will be generated based on the line number. If the given column name does not have a numeric value, the value will be hashed into a long number for the ID.

lOffsetEID - the offset to the EID. Each EID will have a value of (lOffsetEID + EID).

svidColName - the column name that will be used as SVID. If the given column name does not have a numeric value, the value will be hashed into a long number for the ID.

dvidColName - the column name that will be used as DVID. If the given column name does not have a numeric value, the value will be hashed into a long number for the ID.

hasEdgeLabelCol - if true, read from elColName and treat the values as edge labels. If false, use elColName as a constant for all edge labels

elColName - the column name that will be used as edge label

ctams - an array of ColumnToAttrMapping objects. Each ColumnToAttrMapping object defines a mapping from a column in CSV file to an attribute of certain type in an OPE file. These mappings must be in the same order as the values are presented in the CSV file. E.g. If a CSV file includes a header for name,age,weight; the ctams array must include these mappings in the same order.

dop - degree of parallelism used to optimize converting performance.

delimiterChar - the character used to delimit values in a CSV file, e.g. ','

quotationChar - the character used to delimit how to treat quotation characters for values, e.g. '"'

lOffsetLines - in order to skip the first lines of the input file

dateFormat - the preferred Date format used to parse the dates in the CSV file, it can be null.

opeOS - the OutputStream object where the OPE file will be written

dcl - an instance of DataConverterListener that can be used to report progress and control the conversion process when an error occurs.

convertCSV2OPE

public static void convertCSV2OPE(java.io.InputStream inCSV,
                                  java.lang.String eidColName,
                                  long lOffsetEID,
                                  java.lang.String svidColName,
                                  java.lang.String dvidColName,
                                  boolean hasEdgeLabelCol,
                                  java.lang.String elColName,
                                  ColumnToAttrMapping[] ctams,
                                  int dop,
                                  long lOffsetLines,
                                  java.text.DateFormat dateFormat,
                                  java.io.OutputStream opeOS,
                                  DataConverterListener dcl)

Converts a property graph file for edges in CSV format into Oracle Flat File format. The files in this converter must not include a header if the ColumnToAttrMapping array is supplied with all the details of the column names and their type. If the ColumnToAttrMapping array supplied is null then the files must include a header in the first line.

Parameters:

inCSV - an InputStream object for the CSV file

eidColName - the column name that will be used as EID. If NULL, then the EID will be generated based on the line number. If the given column name does not have a numeric value, the value will be hashed into a long number for the ID.

lOffsetEID - the offset to the EID. Each EID will have a value of (lOffsetEID + EID).

svidColName - the column name that will be used as SVID. If the given column name does not have a numeric value, the value will be hashed into a long number for the ID.

dvidColName - the column name that will be used as DVID. If the given column name does not have a numeric value, the value will be hashed into a long number for the ID.

hasEdgeLabelCol - if true, read from elColName and treat the values as edge labels. If false, use elColName as a constant for all edge labels

elColName - the column name that will be used as edge label

ctams - an array of ColumnToAttrMapping objects. Each ColumnToAttrMapping object defines a mapping from a column in CSV file to an attribute of certain type in an OPE file. These mappings must be in the same order as the values are presented in the CSV file. E.g. If a CSV file includes a header for name,age,weight; the ctams array must include these mappings in the same order.

dop - degree of parallelism used to optimize converting performance.

lOffsetLines - in order to skip the first lines of the input file

dateFormat - the preferred Date format used to parse the dates in the CSV file, it can be null.

opeOS - the OutputStream object where the OPE file will be written

dcl - an instance of DataConverterListener that can be used to report progress and control the conversion process when an error occurs.

convertCSV2OPE

public static void convertCSV2OPE(java.io.InputStream inCSV,
                                  java.lang.String eidColName,
                                  long lOffsetEID,
                                  java.lang.String svidColName,
                                  java.lang.String dvidColName,
                                  boolean hasEdgeLabelCol,
                                  java.lang.String elColName,
                                  ColumnToAttrMapping[] ctams,
                                  int dop,
                                  long lOffsetLines,
                                  java.io.OutputStream opeOS,
                                  DataConverterListener dcl)

Converts a property graph file for edges in CSV format into Oracle Flat File format. The files in this converter must not include a header if the ColumnToAttrMapping array is supplied with all the details of the column names and their type. If the ColumnToAttrMapping array supplied is null then the files must include a header in the first line.

Parameters:

inCSV - an InputStream object for the CSV file

eidColName - the column name that will be used as EID. If NULL, then the EID will be generated based on the line number. If the given column name does not have a numeric value, the value will be hashed into a long number for the ID.

lOffsetEID - the offset to the EID. Each EID will have a value of (lOffsetEID + EID).

svidColName - the column name that will be used as SVID. If the given column name does not have a numeric value, the value will be hashed into a long number for the ID.

dvidColName - the column name that will be used as DVID. If the given column name does not have a numeric value, the value will be hashed into a long number for the ID.

hasEdgeLabelCol - if true, read from elColName and treat the values as edge labels. If false, use elColName as a constant for all edge labels

elColName - the column name that will be used as edge label

ctams - an array of ColumnToAttrMapping objects. Each ColumnToAttrMapping object defines a mapping from a column in CSV file to an attribute of certain type in an OPE file. These mappings must be in the same order as the values are presented in the CSV file. E.g. If a CSV file includes a header for name,age,weight; the ctams array must include these mappings in the same order.

dop - degree of parallelism used to optimize converting performance.

lOffsetLines - in order to skip the first lines of the input file

opeOS - the OutputStream object where the OPE file will be written

dcl - an instance of DataConverterListener that can be used to report progress and control the conversion process when an error occurs.

convertCSV2OPE

public static void convertCSV2OPE(java.io.InputStream inCSV,
                                  java.lang.String eidColName,
                                  long lOffsetEID,
                                  java.lang.String svidColName,
                                  java.lang.String dvidColName,
                                  long lOffsetVID,
                                  boolean hasEdgeLabelCol,
                                  java.lang.String elColName,
                                  ColumnToAttrMapping[] ctams,
                                  int dop,
                                  char delimiterChar,
                                  char quotationChar,
                                  long lOffsetLines,
                                  java.text.DateFormat dateFormat,
                                  boolean allowMultiline,
                                  java.io.OutputStream opeOS,
                                  DataConverterListener dcl)

Converts a property graph file for edges in CSV format into Oracle Flat File format. The files in this converter must not include a header if the ColumnToAttrMapping array is supplied with all the details of the column names and their type. If the ColumnToAttrMapping array supplied is null then the files must include a header in the first line.

Parameters:

inCSV - an InputStream object for the CSV file

eidColName - the column name that will be used as EID. If NULL, then the EID will be generated based on the line number. If the given column name does not have a numeric value, the value will be hashed into a long number for the ID.

lOffsetEID - the offset to the EID. Each EID will have a value of (lOffsetEID + EID).

svidColName - the column name that will be used as SVID. If the given column name does not have a numeric value, the value will be hashed into a long number for the ID.

dvidColName - the column name that will be used as DVID. If the given column name does not have a numeric value, the value will be hashed into a long number for the ID.

lOffsetVID - the offset to the VID. Each SVID and DVID will have a value of (lOffsetVID + SVID or lOffsetVID + DVID).

hasEdgeLabelCol - if true, read from elColName and treat the values as edge labels. If false, use elColName as a constant for all edge labels

elColName - the column name that will be used as edge label

ctams - an array of ColumnToAttrMapping objects. Each ColumnToAttrMapping object defines a mapping from a column in CSV file to an attribute of certain type in an OPE file. These mappings must be in the same order as the values are presented in the CSV file. E.g. If a CSV file includes a header for name,age,weight; the ctams array must include these mappings in the same order.

dop - degree of parallelism used to optimize converting performance.

delimiterChar - the character used to delimit values in a CSV file, e.g. ','

quotationChar - the character used to delimit how to treat quotation characters for values, e.g. '"'

lOffsetLines - in order to skip the first lines of the input file

dateFormat - the preferred Date format used to parse the dates in the CSV file, it can be null.

allowMultiline - Whether or not fields from can contain multiple lines, i.e. contain newline character.

opeOS - the OutputStream object where the OPE file will be written

dcl - an instance of DataConverterListener that can be used to report progress and control the conversion process when an error occurs.

convertCSV2OPE

public static void convertCSV2OPE(java.io.InputStream inCSV,
                                  java.lang.String eidColName,
                                  long lOffsetEID,
                                  java.lang.String svidColName,
                                  java.lang.String dvidColName,
                                  long lOffsetSVID,
                                  long lOffsetDVID,
                                  boolean hasEdgeLabelCol,
                                  java.lang.String elColName,
                                  ColumnToAttrMapping[] ctams,
                                  int dop,
                                  char delimiterChar,
                                  char quotationChar,
                                  long lOffsetLines,
                                  java.text.DateFormat dateFormat,
                                  boolean allowMultiline,
                                  java.io.OutputStream opeOS,
                                  DataConverterListener dcl)

Converts a property graph file for edges in CSV format into Oracle Flat File format. The files in this converter must not include a header if the ColumnToAttrMapping array is supplied with all the details of the column names and their type. If the ColumnToAttrMapping array supplied is null then the files must include a header in the first line.

Parameters:

inCSV - an InputStream object for the CSV file

eidColName - the column name that will be used as EID. If NULL, then the EID will be generated based on the line number. If the given column name does not have a numeric value, the value will be hashed into a long number for the ID.

lOffsetEID - the offset to the EID. Each EID will have a value of (lOffsetEID + EID).

svidColName - the column name that will be used as SVID. If the given column name does not have a numeric value, the value will be hashed into a long number for the ID.

dvidColName - the column name that will be used as DVID. If the given column name does not have a numeric value, the value will be hashed into a long number for the ID.

lOffsetSVID - the offset to the SVID. Each SVID will have a value of (lOffsetSVID + SVID).

lOffsetDVID - the offset to the DVID. Each DVID will have a value of (lOffsetDVID + DVID).

hasEdgeLabelCol - if true, read from elColName and treat the values as edge labels. If false, use elColName as a constant for all edge labels

elColName - the column name that will be used as edge label

ctams - an array of ColumnToAttrMapping objects. Each ColumnToAttrMapping object defines a mapping from a column in CSV file to an attribute of certain type in an OPE file. These mappings must be in the same order as the values are presented in the CSV file. E.g. If a CSV file includes a header for name,age,weight; the ctams array must include these mappings in the same order.

dop - degree of parallelism used to optimize converting performance.

delimiterChar - the character used to delimit values in a CSV file, e.g. ','

quotationChar - the character used to delimit how to treat quotation characters for values, e.g. '"'

lOffsetLines - in order to skip the first lines of the input file

dateFormat - the preferred Date format used to parse the dates in the CSV file, it can be null.

allowMultiline - Whether or not fields from can contain multiple lines, i.e. contain newline character.

opeOS - the OutputStream object where the OPE file will be written

dcl - an instance of DataConverterListener that can be used to report progress and control the conversion process when an error occurs.

convertCSV2OPV

public static void convertCSV2OPV(java.io.InputStream inCSV,
                                  java.lang.String vidColName,
                                  long lOffsetVID,
                                  ColumnToAttrMapping[] ctams,
                                  int dop,
                                  char delimiterChar,
                                  char quotationChar,
                                  long lOffsetLines,
                                  java.text.DateFormat dateFormat,
                                  boolean allowMultiline,
                                  java.io.OutputStream opvOS,
                                  DataConverterListener dcl)

Converts a property graph file for vertices in CSV format into Oracle Flat File format using the specified delimiters. The files in this converter must not include a header if the ColumnToAttrMapping array is supplied with all the details of the column names and their type. If the ColumnToAttrMapping array supplied is null then the files must include a header in the first line.

Parameters:

inCSV - an InputStream object for the CSV file

vidColName - the column name that will be used as VID. If NULL, then the VID will be generated based on the line number. If the given column name does not have a numeric value, the value will be hashed into a long number for the ID.

lOffsetVID - the offset to the VID. Each VID will have a value of (lOffsetVID + VID).

ctams - an array of ColumnToAttrMapping objects. Each ColumnToAttrMapping object defines a mapping from a column in CSV file to an attribute of certain type in an OPV file. These mappings must be in the same order as the values are presented in the CSV file. E.g. If a CSV file includes a header for name,age,weight; the ctams array must include these mappings in the same order.

dop - degree of parallelism used to optimize converting performance.

delimiterChar - the character used to delimit values in a CSV file, e.g. ','

quotationChar - the character used to delimit how to treat quotation characters for values, e.g. '"'

lOffsetLines - in order to skip the first lines of the input file

dateFormat - the preferred Date format used to parse the dates in the CSV file, it can be null.

allowMultiline - Whether or not fields from can contain multiple lines, i.e. contain newline character.

opvOS - the OutputStream object where the OPV file will be written

dcl - an instance of DataConverterListener that can be used to report progress and control the conversion process when an error occurs.

convertCSV2OPV

public static void convertCSV2OPV(java.io.InputStream inCSV,
                                  java.lang.String vidColName,
                                  long lOffsetVID,
                                  ColumnToAttrMapping[] ctams,
                                  int dop,
                                  char delimiterChar,
                                  char quotationChar,
                                  long lOffsetLines,
                                  java.text.DateFormat dateFormat,
                                  java.io.OutputStream opvOS,
                                  DataConverterListener dcl)

Converts a property graph file for vertices in CSV format into Oracle Flat File format using the specified delimiters. The files in this converter must not include a header if the ColumnToAttrMapping array is supplied with all the details of the column names and their type. If the ColumnToAttrMapping array supplied is null then the files must include a header in the first line.

Parameters:

inCSV - an InputStream object for the CSV file

vidColName - the column name that will be used as VID. If NULL, then the VID will be generated based on the line number. If the given column name does not have a numeric value, the value will be hashed into a long number for the ID.

lOffsetVID - the offset to the VID. Each VID will have a value of (lOffsetVID + VID).

ctams - an array of ColumnToAttrMapping objects. Each ColumnToAttrMapping object defines a mapping from a column in CSV file to an attribute of certain type in an OPV file. These mappings must be in the same order as the values are presented in the CSV file. E.g. If a CSV file includes a header for name,age,weight; the ctams array must include these mappings in the same order.

dop - degree of parallelism used to optimize converting performance.

delimiterChar - the character used to delimit values in a CSV file, e.g. ','

quotationChar - the character used to delimit how to treat quotation characters for values, e.g. '"'

lOffsetLines - in order to skip the first lines of the input file

dateFormat - the preferred Date format used to parse the dates in the CSV file, it can be null.

opvOS - the OutputStream object where the OPV file will be written

dcl - an instance of DataConverterListener that can be used to report progress and control the conversion process when an error occurs.

convertCSV2OPV

public static void convertCSV2OPV(java.io.InputStream inCSV,
                                  java.lang.String vidColName,
                                  long lOffsetVID,
                                  ColumnToAttrMapping[] ctams,
                                  int dop,
                                  long lOffsetLines,
                                  java.text.DateFormat dateFormat,
                                  java.io.OutputStream opvOS,
                                  DataConverterListener dcl)

Converts a property graph file for vertices in CSV format into Oracle Flat File format using the specified delimiters. The files in this converter must not include a header if the ColumnToAttrMapping array is supplied with all the details of the column names and their type. If the ColumnToAttrMapping array supplied is null then the files must include a header in the first line.

Parameters:

inCSV - an InputStream object for the CSV file

vidColName - the column name that will be used as VID. If NULL, then the VID will be generated based on the line number. If the given column name does not have a numeric value, the value will be hashed into a long number for the ID.

lOffsetVID - the offset to the VID. Each VID will have a value of (lOffsetVID + VID).

ctams - an array of ColumnToAttrMapping objects. Each ColumnToAttrMapping object defines a mapping from a column in CSV file to an attribute of certain type in an OPV file. These mappings must be in the same order as the values are presented in the CSV file. E.g. If a CSV file includes a header for name,age,weight; the ctams array must include these mappings in the same order.

dop - degree of parallelism used to optimize converting performance.

lOffsetLines - in order to skip the first lines of the input file

dateFormat - the preferred Date format used to parse the dates in the CSV file, it can be null.

opvOS - the OutputStream object where the OPV file will be written

dcl - an instance of DataConverterListener that can be used to report progress and control the conversion process when an error occurs.

convertCSV2OPV

public static void convertCSV2OPV(java.io.InputStream inCSV,
                                  java.lang.String vidColName,
                                  long lOffsetVID,
                                  ColumnToAttrMapping[] ctams,
                                  int dop,
                                  long lOffsetLines,
                                  java.io.OutputStream opvOS,
                                  DataConverterListener dcl)

Converts a property graph file for vertices in CSV format into Oracle Flat File format using the specified delimiters. The files in this converter must not include a header if the ColumnToAttrMapping array is supplied with all the details of the column names and their type. If the ColumnToAttrMapping array supplied is null then the files must include a header in the first line.

Parameters:

inCSV - an InputStream object for the CSV file

vidColName - the column name that will be used as VID. If NULL, then the VID will be generated based on the line number. If the given column name does not have a numeric value, the value will be hashed into a long number for the ID.

lOffsetVID - the offset to the VID. Each VID will have a value of (lOffsetVID + VID).

ctams - an array of ColumnToAttrMapping objects. Each ColumnToAttrMapping object defines a mapping from a column in CSV file to an attribute of certain type in an OPV file. These mappings must be in the same order as the values are presented in the CSV file. E.g. If a CSV file includes a header for name,age,weight; the ctams array must include these mappings in the same order.

dop - degree of parallelism used to optimize converting performance.

lOffsetLines - in order to skip the first lines of the input file

opvOS - the OutputStream object where the OPV file will be written

dcl - an instance of DataConverterListener that can be used to report progress and control the conversion process when an error occurs.

convertRDBMSTable2OPE

public static void convertRDBMSTable2OPE(java.sql.Connection conn,
                                         java.lang.String rdbmsTableName,
                                         java.lang.String eidColName,
                                         long lEIDOffset,
                                         java.lang.String svidColName,
                                         java.lang.String dvidColName,
                                         long lVIDOffset,
                                         boolean bHasEdgeLabelCol,
                                         java.lang.String elColName,
                                         ColumnToAttrMapping[] ctams,
                                         int dop,
                                         java.io.OutputStream opeOS,
                                         DataConverterListener dcl)

This method converts given rdbms table to a ope file

Parameters:

conn - an connection instance to Oracle relational database

rdbmsTableName - the name of RDBMS table to be converted

eidColName - the column in given RDBMS table to be treated as eid, can be NULL when eidColName is not null and of type integer/long: use (column value + lEIDOffset) as eid when eidColName is not null and not of type integer/long: use (hash(column value) + lEIDOffset) as eid when eidColName is null: use (rownum + lEIDOffset) as eid

lEIDOffset - the offset to the eid

svidColName - the column in given RDBMS table to be treated as svid, can not be NULL when svidColName is of type integer/long: use (column value + lVIDOffset) as svid when svidColName is not of type integer/long: use (hash(column value) + lVIDOffset) as svid

dvidColName - the column in given RDBMS table to be treated as dvid, can not be NULL when eidColName is of type integer/long: use (column value + lVIDOffset) as dvid when eidColName is not of type integer/long: use (hash(column value) + lVIDOffset) as dvid

lVIDOffset - the offset to the VID. Each SVID and DVID will have a value of (lVIDOffset + SVID or lVIDOffset + DVID).

bHasEdgeLabelCol - a boolean flag represents if the given rdbms table has a column for edge labels if true, use (value of column elColName) as edge label if false, use elColName as a constant for all edge labels

elColName -

ctams - an array of ColumnToAttrMapping objects; each ColumnToAttrMapping object defines a mapping from a column in rdbms table to an attribute of certain type in ope

dop - degree of parallelism

opeOS - ope output stream to be written to

dcl - an instance of DataConverterListener that can be used to report progress and control the conversion process when an error occurrs.

convertRDBMSTable2OPE

public static void convertRDBMSTable2OPE(java.sql.Connection conn,
                                         java.lang.String rdbmsTableName,
                                         java.lang.String eidColName,
                                         long lEIDOffset,
                                         java.lang.String svidColName,
                                         java.lang.String dvidColName,
                                         long lSVIDOffset,
                                         long lDVIDOffset,
                                         boolean bHasEdgeLabelCol,
                                         java.lang.String elColName,
                                         ColumnToAttrMapping[] ctams,
                                         int dop,
                                         java.io.OutputStream opeOS,
                                         DataConverterListener dcl)

This method converts given rdbms table to a ope file

Parameters:

conn - an connection instance to Oracle relational database

rdbmsTableName - the name of RDBMS table to be converted

eidColName - the column in given RDBMS table to be treated as eid, can be NULL when eidColName is not null and of type integer/long: use (column value + lEIDOffset) as eid when eidColName is not null and not of type integer/long: use (hash(column value) + lEIDOffset) as eid when eidColName is null: use (rownum + lEIDOffset) as eid

lEIDOffset - the offset to the eid

svidColName - the column in given RDBMS table to be treated as svid, can not be NULL when svidColName is of type integer/long: use (column value + lVIDOffset) as svid when svidColName is not of type integer/long: use (hash(column value) + lVIDOffset) as svid

dvidColName - the column in given RDBMS table to be treated as dvid, can not be NULL when eidColName is of type integer/long: use (column value + lVIDOffset) as dvid when eidColName is not of type integer/long: use (hash(column value) + lVIDOffset) as dvid

lSVIDOffset - the offset to the SVID. Each SVID will have a value of (lSVIDOffset + SVID).

lDVIDOffset - the offset to the DVID. Each DVID will have a value of (lDVIDOffset + DVID).

bHasEdgeLabelCol - a boolean flag represents if the given rdbms table has a column for edge labels if true, use (value of column elColName) as edge label if false, use elColName as a constant for all edge labels

elColName -

ctams - an array of ColumnToAttrMapping objects; each ColumnToAttrMapping object defines a mapping from a column in rdbms table to an attribute of certain type in ope

dop - degree of parallelism

opeOS - ope output stream to be written to

dcl - an instance of DataConverterListener that can be used to report progress and control the conversion process when an error occurrs.

convertRDBMSTable2OPV

public static void convertRDBMSTable2OPV(java.sql.Connection conn,
                                         java.lang.String rdbmsTableName,
                                         java.lang.String vidColName,
                                         long lVIDOffset,
                                         ColumnToAttrMapping[] ctams,
                                         int dop,
                                         java.io.OutputStream opvOS,
                                         DataConverterListener dcl)

Converts given rdbms table to a opv file.

Parameters:

conn - an connection instance to Oracle relational database

rdbmsTableName - the name of RDBMS table to be converted

vidColName - the column in given RDBMS table to be treated as vid when vidColName is not null and of type integer/long: use (column value + lVIDOffset) as vid when vidColName is not null and not of type integer/long: use (hash(column value) + lVIDOffset) as vid when vidColName is null: use (rownum + lVIDOffset) as vid

lVIDOffset - the offset to the vid

ctams - an array of ColumnToAttrMapping objects; each ColumnToAttrMapping object defines a mapping from a column in rdbms table to an attribute of certain type in opv

dop - degree of parallelism

opvOS - opv output stream to be written to

dcl - an instance of DataConverterListener that can be used to report progress and control the conversion process when an error occurrs.