public class OracleConvertersUtilsBase
extends java.lang.Object
Constructor and Description |
---|
OracleConvertersUtilsBase() |
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.
|
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)
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.inCSV
- an InputStream
object for the CSV fileeidColName
- 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
labelselColName
- the column name that will be used as edge labelctams
- 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 filedateFormat
- 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 writtendcl
- an instance of DataConverterListener that can be used to report
progress and control the conversion process when an error occurs.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)
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.inCSV
- an InputStream
object for the CSV fileeidColName
- 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
labelselColName
- the column name that will be used as edge labelctams
- 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 filedateFormat
- 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 writtendcl
- an instance of DataConverterListener that can be used to report
progress and control the conversion process when an error occurs.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)
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.inCSV
- an InputStream
object for the CSV fileeidColName
- 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
labelselColName
- the column name that will be used as edge labelctams
- 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 filedateFormat
- 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 writtendcl
- an instance of DataConverterListener that can be used to report
progress and control the conversion process when an error occurs.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)
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.inCSV
- an InputStream
object for the CSV fileeidColName
- 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
labelselColName
- the column name that will be used as edge labelctams
- 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 fileopeOS
- the OutputStream
object where the OPE file will be writtendcl
- an instance of DataConverterListener that can be used to report
progress and control the conversion process when an error occurs.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)
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.inCSV
- an InputStream
object for the CSV fileeidColName
- 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
labelselColName
- the column name that will be used as edge labelctams
- 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 filedateFormat
- 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 writtendcl
- an instance of DataConverterListener that can be used to report
progress and control the conversion process when an error occurs.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)
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.inCSV
- an InputStream
object for the CSV fileeidColName
- 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
labelselColName
- the column name that will be used as edge labelctams
- 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 filedateFormat
- 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 writtendcl
- an instance of DataConverterListener that can be used to report
progress and control the conversion process when an error occurs.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)
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.inCSV
- an InputStream
object for the CSV filevidColName
- 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 filedateFormat
- 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 writtendcl
- an instance of DataConverterListener that can be used to report
progress and control the conversion process when an error occurs.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)
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.inCSV
- an InputStream
object for the CSV filevidColName
- 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 filedateFormat
- 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 writtendcl
- an instance of DataConverterListener that can be used to report
progress and control the conversion process when an error occurs.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)
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.inCSV
- an InputStream
object for the CSV filevidColName
- 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 filedateFormat
- 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 writtendcl
- an instance of DataConverterListener that can be used to report
progress and control the conversion process when an error occurs.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)
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.inCSV
- an InputStream
object for the CSV filevidColName
- 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 fileopvOS
- the OutputStream
object where the OPV file will be writtendcl
- an instance of DataConverterListener that can be used to report
progress and control the conversion process when an error occurs.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)
conn
- an connection instance to Oracle relational databaserdbmsTableName
- the name of RDBMS table to be convertedeidColName
- 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 eidlEIDOffset
- the offset to the eidsvidColName
- 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 sviddvidColName
- 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 dvidlVIDOffset
- 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 labelselColName
- 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 opedop
- degree of parallelismopeOS
- ope output stream to be written todcl
- an instance of DataConverterListener that can be used to report
progress and control the conversion process when an error occurrs.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)
conn
- an connection instance to Oracle relational databaserdbmsTableName
- the name of RDBMS table to be convertedeidColName
- 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 eidlEIDOffset
- the offset to the eidsvidColName
- 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 sviddvidColName
- 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 dvidlSVIDOffset
- 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 labelselColName
- 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 opedop
- degree of parallelismopeOS
- ope output stream to be written todcl
- an instance of DataConverterListener that can be used to report
progress and control the conversion process when an error occurrs.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)
conn
- an connection instance to Oracle relational databaserdbmsTableName
- the name of RDBMS table to be convertedvidColName
- 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 vidlVIDOffset
- the offset to the vidctams
- an array of ColumnToAttrMapping objects; each ColumnToAttrMapping
object defines a mapping from a column in rdbms table to an
attribute of certain type in opvdop
- degree of parallelismopvOS
- opv output stream to be written todcl
- an instance of DataConverterListener that can be used to report
progress and control the conversion process when an error occurrs.Copyright © 2015, 2019, Oracle and/or its afflilates. All Rights Reserved.