com.netrics.likeit

Class NetricsRecFile

java.lang.Object

com.netrics.likeit.NetricsRecFile

All Implemented Interfaces:

java.io.Serializable

public class NetricsRecFile
extends java.lang.Object
implements java.io.Serializable

This class is used to define a file of records read by the Netrics Server. File types currently supported are:

CSV Excel format CSV files.
Fixed WidthFixed width files.

In both cases the files may start with an optional header line defining the field names, and/or an optional header line defining the field types. If both are given the field names must be given first.

Record keys are defined in one of four ways:

No key - no key is given in the file, keys are generated by the server.
Leading key - an unnamed, untyped initial field in each data record provides the record key. This field does not appear in the header records, so data records will have one more field than the header records.
Field Index - the index position (starting at 0) of the field containing the key is given. This field appears in all header records as well as data records, but this field is loaded as the record key and does not appear as a record data field.
Field Name - the name of the field containing the key is given. If this method is used then the field names header record must be present. This is like Field Index in behavior.

Simple examples of each file type are given below. All file types except Field Index are show with both header records. They are optional in all file types except Field Name where the Field Names header record is required.

No Key
first,middle,last,order
5,5,5,6
William,Jefferson,Clinton,42
George,W,Bush,43

Leading Key
first,middle,last,order
5,5,5,6
key1,William,Jefferson,Clinton,42
key1,George,W,Bush,43

Field Index (value 4)
William,Jefferson,Clinton,42,key1
George,W,Bush,43,key2

Field Name(value key)
first,middle,last,order,key
5,5,5,6,2
William,Jefferson,Clinton,42,key1
key1,George,W,Bush,43,key2


See Also:

NetricsServerInterface.tblload(NetricsTable,NetricsRecFile), NetricsServerInterface.addRecsFromFile(String,boolean,NetricsLock,NetricsRecFile), Serialized Form

Constructor Summary

Constructors

Constructor and Description
NetricsRecFile(java.lang.String fileName) Define a default CSV file record source.
NetricsRecFile(java.lang.String fileName, int keyIndex) Define a default CSV file record source.
NetricsRecFile(java.lang.String fileName, int[] fieldLengths, java.lang.String encoding, boolean doMaxWork, boolean leadingKey, int initialKey, boolean fieldNamesFirst, boolean fieldTypesFirst, int keyIndex, java.lang.String keyName) Define a Fixed Width file record source.
NetricsRecFile(java.lang.String fileName, java.lang.String encoding, boolean doMaxWork, boolean leadingKey, int initialKey, boolean fieldNamesFirst, boolean fieldTypesFirst, int keyIndex, java.lang.String keyName) Define a CSV file record source with attributes.

Method Summary

Methods

Modifier and Type	Method and Description
boolean	getDoMaxWork() Return the Do Max Work setting.
java.lang.String	getEncoding() Return the value of character encoding setting.
boolean	getFieldNamesFirst() Return the state of the field names first setting.
boolean	getFieldTypesFirst() Return the state of the field types first setting.
java.lang.String	getFileName() Return the source file name.
int	getInitialKey() Return the initial key setting.
int	getKeyIndex() Return the value of the key index.
java.lang.String	getKeyName() Return the value of the key name.
boolean	getLeadingKey() Return the leading key setting.
void	setDoMaxWork(boolean doMaxWork) Set the Do Max Work (ignore errors) setting.
void	setEncoding(java.lang.String encoding) Set the character set encoding of the source file.
void	setFieldNamesFirst(boolean fieldNamesFirst) Set the field names first flag.
void	setFieldTypesFirst(boolean fieldTypesFirst) Set the state of the field types first flag.
void	setFileName(java.lang.String fileName) Set the source file name.
void	setInitialKey(int initialKey) Set the initial key value.
void	setKeyIndex(int keyIndex) Set the key index value.
void	setKeyName(java.lang.String keyName) Set the name of the field holding the record key.
void	setLeadingKey(boolean leadingKey) Set the leading key.

Methods inherited from class java.lang.Object

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

Constructor Detail

NetricsRecFile

public NetricsRecFile(java.lang.String fileName)
               throws NetricsException

Define a default CSV file record source.

This is the same as:
NetricsRecFile(fileName,null,false,false,-1,true,false,-1,null)

Parameters:

fileName - The name of the file containing the records.

Throws:

NetricsException - If an invalid or illegal combination of values is given.

NetricsRecFile

public NetricsRecFile(java.lang.String fileName,
              int keyIndex)
               throws NetricsException

Define a default CSV file record source.

This is the same as:
NetricsRecFile(fileName,null,false,false,-1,true,false,keyIndex,null)

Parameters:

fileName - The name of the file containing the records.

keyIndex - If this is non-negative it defines the index (0 based) of the key field in the file records.

Throws:

NetricsException - If an invalid or illegal combination of values is given.

NetricsRecFile

public NetricsRecFile(java.lang.String fileName,
              java.lang.String encoding,
              boolean doMaxWork,
              boolean leadingKey,
              int initialKey,
              boolean fieldNamesFirst,
              boolean fieldTypesFirst,
              int keyIndex,
              java.lang.String keyName)
               throws NetricsException

Define a CSV file record source with attributes.

Parameters:

fileName - The name of the file containing the records.

encoding - This defines the character encoding used in the file. Currently supported encodings are: "UTF-8" or "LATIN1". DEFAULT: "LATIN1"

doMaxWork - Ignore badly formatted records.

leadingKey - This parameter is true if the file has the Leading Key format.

initialKey - If the No Key format is used this defines the initial key value for the generated keys. If this is less than 0 the default value of 0 is used. Keys are sequential numbers starting at the initial key.

fieldNamesFirst - If true the field names header line is present in the file.

fieldTypesFirst - If true the field types header line is present in the file.

keyIndex - If this is non-negative it defines the index (0 based) of the key field in the file records.

keyName - If this is non-null it defines the name of the key field in the file records and the file must contain a field names header record and fieldNamesFirst must be true.

Throws:

NetricsException - If an invalid or illegal combination of values is given.

NetricsRecFile

public NetricsRecFile(java.lang.String fileName,
              int[] fieldLengths,
              java.lang.String encoding,
              boolean doMaxWork,
              boolean leadingKey,
              int initialKey,
              boolean fieldNamesFirst,
              boolean fieldTypesFirst,
              int keyIndex,
              java.lang.String keyName)
               throws NetricsException

Define a Fixed Width file record source.

Parameters:

fileName - The name of the file containing the records.

fieldLengths - This array contains the field widths in characters. The length of the array must be the same as the number of fields in the record, including and key field, even if it is a leading key field.

encoding - This defines the character encoding used in the file. Currently supported encodings are: "UTF-8" or "LATIN1". DEFAULT: "LATIN1"

doMaxWork - Ignore badly formatted records.

leadingKey - This parameter is true if the file has the Leading Key format.

initialKey - If the No Key format is used this defines the initial key value for the generated keys. If this is less than 0 the default value of 0 is used. Keys are sequential numbers starting at the initial key.

fieldNamesFirst - If true the field names header line is present in the file.

fieldTypesFirst - If true the field types header line is present in the file.

keyIndex - If this is non-negative it defines the index (0 based) of the key field in the file records.

keyName - If this is non-null it defines the name of the key field in the file records and the file must contain a field names header record and fieldNamesFirst must be true.

Throws:

NetricsException - If an invalid or illegal combination of values is given.

Method Detail

getFileName

public java.lang.String getFileName()

Return the source file name. Returns the CSV or Fixed width file name. Null if it was not set.

setFileName

public void setFileName(java.lang.String fileName)

Set the source file name. Sets the name of the source file for either CSV or fixed width files.

getEncoding

public java.lang.String getEncoding()

Return the value of character encoding setting. Returns the character encoding. Null if it was not set.

setEncoding

public void setEncoding(java.lang.String encoding)

Set the character set encoding of the source file.

getDoMaxWork

public boolean getDoMaxWork()

Return the Do Max Work setting. Returns false if it was never set.

setDoMaxWork

public void setDoMaxWork(boolean doMaxWork)

Set the Do Max Work (ignore errors) setting.

getLeadingKey

public boolean getLeadingKey()

Return the leading key setting. Returns false if it was never set.

setLeadingKey

public void setLeadingKey(boolean leadingKey)

Set the leading key.

getInitialKey

public int getInitialKey()

Return the initial key setting. Returns the initial key setting. -1 if initial key was not set.

setInitialKey

public void setInitialKey(int initialKey)

Set the initial key value. Sets the initial key value, use -1 to get the default value.

getKeyIndex

public int getKeyIndex()

Return the value of the key index. Returns the key index setting. -1 if key index was not set.

setKeyIndex

public void setKeyIndex(int keyIndex)

Set the key index value. This sets the index of the field (zero based) to be used as the record key. Use -1 to indicate the key field is not specified.

getKeyName

public java.lang.String getKeyName()

Return the value of the key name. Returns the key name setting. Null if key name was not set.

setKeyName

public void setKeyName(java.lang.String keyName)

Set the name of the field holding the record key. This sets the name of the field to be used as the record key. Use null to indicate the key field is not specified.

getFieldNamesFirst

public boolean getFieldNamesFirst()

Return the state of the field names first setting.

setFieldNamesFirst

public void setFieldNamesFirst(boolean fieldNamesFirst)

Set the field names first flag. If true is given the first line of the file is used as the field names.

getFieldTypesFirst

public boolean getFieldTypesFirst()

Return the state of the field types first setting.

setFieldTypesFirst

public void setFieldTypesFirst(boolean fieldTypesFirst)

Set the state of the field types first flag. If this is true the first line of the file (after any field names) contains the integer values of the field types.