oracle.pg.common.csvconverter

Class OraclePropertyGraphCSVConverter

java.lang.Object

oracle.pg.common.csvconverter.OraclePropertyGraphCSVConverter

public abstract class OraclePropertyGraphCSVConverter
extends java.lang.Object

This class contains utility functions to help manage property graphs.

Constructor Summary

Constructors

Constructor and Description
OraclePropertyGraphCSVConverter()

Method Summary

Modifier and Type	Method and Description
static void	convertCSV2OPE(java.io.InputStream inCSV, CSV2OPEConfig config, java.io.OutputStream opeOS) Converts a property graph file for edges in CSV format into Oracle Flat File format using the specified configuration.
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	convertCSV2OPG(java.io.InputStream inCSV, CSV2OPGConfig config, java.io.OutputStream opVOS, java.io.OutputStream opEOS) Converts a single property graph file in CSV format into Oracle Flat Files format using the specified configuration.
static void	convertCSV2OPV(java.io.InputStream inCSV, CSV2OPVConfig config, java.io.OutputStream opvOS) Converts a property graph file for vertices in CSV format into Oracle Flat File format using the specified configuration.
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 ColumnToAttrMapping[]	parseHeaderToColumnToAttrMappings(java.lang.String header, char delimiterChar) Splits the header using the delimiterChar and returns an array of ColumnToAttrMapping
static java.lang.String	readCsvRecord(java.io.BufferedReader br, boolean allowMultiline, char quotChar) Reads a CSV Record with the BufferedReader br.

Methods inherited from class java.lang.Object

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

Constructor Detail

OraclePropertyGraphCSVConverter

public OraclePropertyGraphCSVConverter()

Method Detail

convertCSV2OPE

public static void convertCSV2OPE(java.io.InputStream inCSV,
                                  CSV2OPEConfig config,
                                  java.io.OutputStream opeOS)

Converts a property graph file for edges in CSV format into Oracle Flat File format using the specified configuration.

Parameters:

inCSV - an InputStream object for the CSV file

config - a CSV2OPEConfig object specifying the desired tuning

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

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.

convertCSV2OPG

public static void convertCSV2OPG(java.io.InputStream inCSV,
                                  CSV2OPGConfig config,
                                  java.io.OutputStream opVOS,
                                  java.io.OutputStream opEOS)
                           throws java.io.IOException

Converts a single property graph file in CSV format into Oracle Flat Files format using the specified configuration.

Parameters:

inCSV - an InputStream object for the CSV file

config - a CSV2OPEConfig object specifying the desired tuning

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

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

Throws:

java.io.IOException

convertCSV2OPV

public static void convertCSV2OPV(java.io.InputStream inCSV,
                                  CSV2OPVConfig config,
                                  java.io.OutputStream opvOS)

Converts a property graph file for vertices in CSV format into Oracle Flat File format using the specified configuration.

Parameters:

inCSV - an InputStream object for the CSV file

config - a CSV2OPEConfig object specifying the desired tuning

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

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.

parseHeaderToColumnToAttrMappings

public static ColumnToAttrMapping[] parseHeaderToColumnToAttrMappings(java.lang.String header,
                                                                      char delimiterChar)

Splits the header using the delimiterChar and returns an array of ColumnToAttrMapping

readCsvRecord

public static java.lang.String readCsvRecord(java.io.BufferedReader br,
                                             boolean allowMultiline,
                                             char quotChar)
                                      throws java.io.IOException

Reads a CSV Record with the BufferedReader br. If allowMultiline is true, then quoted strings will be allowed to contain new line and carriage return characters. A new line marks the end of a CSV Record.

Throws:

java.io.IOException