gov.nasa.pds.citool.ingestor

Class CatalogDB

java.lang.Object

gov.nasa.pds.citool.ingestor.CatalogDB

public class CatalogDB
extends Object

Class to insert the specific catalog data into the corresponding table(s).

Author:

hyunlee

Field Summary

Fields

Modifier and Type	Field and Description
static int	failCount
static int	newStdValueCount
static int	okCount

Constructor Summary

Constructors

Constructor and Description
CatalogDB(String user, String pass, String server, String dbname, Target target, IngestReport report) Constructor

Method Summary

Methods

Modifier and Type	Method and Description
void	close() Method to close the database connection
protected String	collapse(String source) Method to remove extra spaces from the string specified by the string attributes.
protected int	deleteRecords(String query) Method to delete records in the database
Map<String,String>	getIngestedStdValues() Returns a map of standard values found from the most recent ingestion run.
protected int	getRowCount(String query) Method to get the row count from the database
protected void	ingestDataSetColObject(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest DATA_SET_COLLECTION object
protected void	ingestDataSetObject(Map<String,gov.nasa.pds.tools.label.AttributeStatement> attrSmts) Method to ingest DATA_SET object
protected void	ingestDDCol(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest the data into 'ddcol' table
protected void	ingestDDColD(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest the data into 'ddcold' table
protected void	ingestDDFormRule(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest the data into 'ddformrule' table
protected void	ingestDDGenClass(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest the data into 'ddgenclass' table
protected void	ingestDDObjAlias(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest the data into 'ddobjhier' table
protected void	ingestDDObjD(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest the data into 'ddobjd' table
protected void	ingestDDObjects(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest the data into 'ddobjects' table
protected void	ingestDDObjElm(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest the data into 'ddobjelm' table
protected void	ingestDDObjHier(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest the data into 'ddobjhier' table
protected void	ingestDDObjStsNote(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest the data into 'ddobjstsnote' table
protected void	ingestDDStdValD(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest the data into 'ddstdvald' table
protected void	ingestDDSysClass(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest the data into 'ddsysclass' table
protected void	ingestDSCollAssocDSObject(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest the data into 'dscollds' table
protected void	ingestDSCollD(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest the data into 'dscolld' table
protected void	ingestDSCollDoc(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest the data into 'dscolldoc' table
protected void	ingestDSCollInfo(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest the data into 'dscollinfo' table
protected void	ingestDSCollUsgd(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest the data into 'dscollusgd' table
protected void	ingestDSConf(Map<String,gov.nasa.pds.tools.label.AttributeStatement> attrSmts) Method to ingest the data into 'dsconf' table
protected void	ingestDSD(Map<String,gov.nasa.pds.tools.label.AttributeStatement> attrSmts) Method to ingest the data into 'dsd' table
protected void	ingestDSHost(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest the data into 'dshost' table
protected void	ingestDSInfo(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest the data into 'dsinfo' table
protected void	ingestDSMsn(Map<String,gov.nasa.pds.tools.label.AttributeStatement> attrSmts) Method to ingest the data into 'dsmsn' table
protected void	ingestDSRefInfoObject(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest the data into 'dsdoc' table
protected void	ingestDSReleaseObject(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest DATA_SET_RELEASE object
protected void	ingestDSTarg(Map<String,gov.nasa.pds.tools.label.AttributeStatement> attrSmts) Method to ingest the data into 'dstarg' table
protected void	ingestElemDefObject(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest ELEMENT_DEFINITION object
protected void	ingestHostD(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest the data into 'hostd' table
protected void	ingestHostInfo(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest the data into 'hostinfo' table
protected void	ingestInstD(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest the data into 'instd' table
protected void	ingestInstHostObject(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest INSTRUMENT_HOST object
protected void	ingestInstHostRefInfoObject(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest the data into 'hostdoc' table
protected void	ingestInstInfo(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest the data into 'instinfo' table
protected void	ingestInstObject(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest INSTRUMENT object
protected void	ingestInstRefInfoObject(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest the data into 'instdoc' table
void	ingestInventoryObject(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest INVENTORY object
protected void	ingestInvNodeMedia(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest the data into 'invnodemedia' table
protected void	ingestInvSpcOrdNt(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest the data into 'invspcordnt' table
protected void	ingestMissionObject(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest MISSION object
protected void	ingestMsnD(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest the data into 'msnd' table
protected void	ingestMsnDoc(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest the data into 'msndoc' table
protected void	ingestMsnHost(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest the data into 'msnhost' table
protected void	ingestMsnInfo(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest the data into 'msninfo' table
protected void	ingestMsnObjsmy(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest the data into 'msnobjsmy' table
protected void	ingestNewStdValues(Map<String,String> stdValues) Method to ingest new standard values into the ddcolstdval table.
protected void	ingestNssdcdsidObject(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest NSSDCDSID object
protected void	ingestObjDefObject(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest OBJECT_DEFINTION object
protected void	ingestPersElecmail(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest the data into 'perselecmail' table
protected void	ingestPersInfo(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest the data into 'persinfo' table
protected void	ingestPersMailAddr(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest the data into 'persmailaddr' table
protected void	ingestPersonnelObject(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest PERSONNEL object
void	ingestReferenceObject(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest the data into 'refd' table
protected void	ingestResDS(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest the data into 'resds' table
protected void	ingestResInfo(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest the data into 'resinfo' table
protected void	ingestResourceObject(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest DATA_SET_HOUSEKEEPING & RESOURCE objectsccc
protected void	ingestSoftwareObject(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest SOFTWARE object
void	ingestSoftwareOnlineObject(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest the data into 'swonline' table
protected void	ingestStdValObject(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest the data into 'ddcolstdval' table
protected void	ingestSWD(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest the data into 'swd' table
protected void	ingestSWInfo(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest the data into 'swinfo' table
protected void	ingestSWPur(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest the data into 'swpur' table
protected void	ingestTargetD(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest the data into 'targetd' table
protected void	ingestTargetDoc(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest the data into 'targetdoc' table
protected void	ingestTargetInfo(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest the data into 'targetinfo' table
void	ingestTargetObject(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest TARGET object
protected void	ingestVolDesc(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest the data into 'voldesc' table
protected void	ingestVolDS(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest the data into 'volds' table
protected void	ingestVolInfo(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest the data into 'volinfo' table
protected void	ingestVolOnline(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest the data into 'volonline' table
protected void	ingestVolSerInfo(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest the data into 'volserinfo' table
protected void	ingestVolSerSet(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest the data into 'volserset' table
protected void	ingestVolSetInfo(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest the data into 'volsetinfo' table
void	ingestVolumeObject(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap) Method to ingest VOLUME object
boolean	isConnected()
boolean	isFailed()
protected String	itrim(String source) Replace multiple whitespaces between words with single blank
protected String	ltrim(String source) Trim the string of any spaces on the left end (ie., leading spaces removed) Remove leading spaces for each line when there is multiple lines of string
static void	main(String[] args) Main method
protected String	rtrim(String source) Trim the string of any spaces on the right end (ie., trailing spaces removed)
void	setIsFailed(boolean failed)
void	setLabel(gov.nasa.pds.tools.label.Label label)
void	setReport(IngestReport report)

Methods inherited from class java.lang.Object

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

Field Detail

okCount

public static int okCount

failCount

public static int failCount

newStdValueCount

public static int newStdValueCount

Constructor Detail

CatalogDB

public CatalogDB(String user,
         String pass,
         String server,
         String dbname,
         Target target,
         IngestReport report)
          throws SQLException,
                 Exception

Constructor

Parameters:

user - Name of the database user

pass - Password of the database connection

server - Server name of the database

dbname - Name of the database

Throws:

SQLException

Exception

Method Detail

setReport

public void setReport(IngestReport report)

setLabel

public void setLabel(gov.nasa.pds.tools.label.Label label)

close

public void close()
           throws SQLException

Method to close the database connection

Throws:

SQLException

isConnected

public boolean isConnected()

isFailed

public boolean isFailed()

setIsFailed

public void setIsFailed(boolean failed)

ingestMissionObject

protected void ingestMissionObject(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest MISSION object

Parameters:

lblMap - Hashmap of the PDS label(s)

ingestMsnD

protected void ingestMsnD(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest the data into 'msnd' table

Parameters:

lblMap - Hashmap of the PDS label(s)

ingestMsnObjsmy

protected void ingestMsnObjsmy(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest the data into 'msnobjsmy' table

ingestMsnHost

protected void ingestMsnHost(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest the data into 'msnhost' table

ingestMsnInfo

protected void ingestMsnInfo(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest the data into 'msninfo' table

ingestMsnDoc

protected void ingestMsnDoc(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest the data into 'msndoc' table

ingestInstHostObject

protected void ingestInstHostObject(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest INSTRUMENT_HOST object

ingestHostD

protected void ingestHostD(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest the data into 'hostd' table

ingestHostInfo

protected void ingestHostInfo(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest the data into 'hostinfo' table

ingestInstHostRefInfoObject

protected void ingestInstHostRefInfoObject(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest the data into 'hostdoc' table

ingestInstObject

protected void ingestInstObject(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest INSTRUMENT object

ingestInstD

protected void ingestInstD(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest the data into 'instd' table

ingestInstInfo

protected void ingestInstInfo(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest the data into 'instinfo' table

ingestInstRefInfoObject

protected void ingestInstRefInfoObject(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest the data into 'instdoc' table

ingestDataSetObject

protected void ingestDataSetObject(Map<String,gov.nasa.pds.tools.label.AttributeStatement> attrSmts)

Method to ingest DATA_SET object

ingestDSMsn

protected void ingestDSMsn(Map<String,gov.nasa.pds.tools.label.AttributeStatement> attrSmts)

Method to ingest the data into 'dsmsn' table

ingestDSD

protected void ingestDSD(Map<String,gov.nasa.pds.tools.label.AttributeStatement> attrSmts)

Method to ingest the data into 'dsd' table

ingestDSConf

protected void ingestDSConf(Map<String,gov.nasa.pds.tools.label.AttributeStatement> attrSmts)

Method to ingest the data into 'dsconf' table

ingestDSTarg

protected void ingestDSTarg(Map<String,gov.nasa.pds.tools.label.AttributeStatement> attrSmts)

Method to ingest the data into 'dstarg' table

ingestDSHost

protected void ingestDSHost(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest the data into 'dshost' table

ingestDSInfo

protected void ingestDSInfo(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest the data into 'dsinfo' table

ingestDSRefInfoObject

protected void ingestDSRefInfoObject(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest the data into 'dsdoc' table

ingestReferenceObject

public void ingestReferenceObject(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest the data into 'refd' table

ingestPersonnelObject

protected void ingestPersonnelObject(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest PERSONNEL object

ingestPersMailAddr

protected void ingestPersMailAddr(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest the data into 'persmailaddr' table

ingestPersInfo

protected void ingestPersInfo(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest the data into 'persinfo' table

ingestPersElecmail

protected void ingestPersElecmail(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest the data into 'perselecmail' table

ingestDSCollAssocDSObject

protected void ingestDSCollAssocDSObject(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest the data into 'dscollds' table

ingestDataSetColObject

protected void ingestDataSetColObject(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest DATA_SET_COLLECTION object

ingestDSCollUsgd

protected void ingestDSCollUsgd(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest the data into 'dscollusgd' table

ingestDSCollInfo

protected void ingestDSCollInfo(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest the data into 'dscollinfo' table

ingestDSCollD

protected void ingestDSCollD(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest the data into 'dscolld' table

ingestDSCollDoc

protected void ingestDSCollDoc(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest the data into 'dscolldoc' table

ingestInventoryObject

public void ingestInventoryObject(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest INVENTORY object

ingestInvSpcOrdNt

protected void ingestInvSpcOrdNt(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest the data into 'invspcordnt' table

ingestInvNodeMedia

protected void ingestInvNodeMedia(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest the data into 'invnodemedia' table

ingestSoftwareObject

protected void ingestSoftwareObject(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest SOFTWARE object

ingestSWD

protected void ingestSWD(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest the data into 'swd' table

ingestSWInfo

protected void ingestSWInfo(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest the data into 'swinfo' table

ingestSWPur

protected void ingestSWPur(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest the data into 'swpur' table

ingestSoftwareOnlineObject

public void ingestSoftwareOnlineObject(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest the data into 'swonline' table

ingestTargetObject

public void ingestTargetObject(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest TARGET object

ingestTargetD

protected void ingestTargetD(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest the data into 'targetd' table

ingestTargetInfo

protected void ingestTargetInfo(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest the data into 'targetinfo' table

ingestTargetDoc

protected void ingestTargetDoc(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest the data into 'targetdoc' table

ingestVolumeObject

public void ingestVolumeObject(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest VOLUME object

ingestVolDS

protected void ingestVolDS(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest the data into 'volds' table

ingestVolDesc

protected void ingestVolDesc(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest the data into 'voldesc' table

ingestVolInfo

protected void ingestVolInfo(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest the data into 'volinfo' table

ingestVolSetInfo

protected void ingestVolSetInfo(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest the data into 'volsetinfo' table

ingestVolSerSet

protected void ingestVolSerSet(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest the data into 'volserset' table

ingestVolSerInfo

protected void ingestVolSerInfo(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest the data into 'volserinfo' table

ingestVolOnline

protected void ingestVolOnline(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest the data into 'volonline' table

ingestNssdcdsidObject

protected void ingestNssdcdsidObject(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest NSSDCDSID object

ingestDSReleaseObject

protected void ingestDSReleaseObject(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest DATA_SET_RELEASE object

ingestResourceObject

protected void ingestResourceObject(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest DATA_SET_HOUSEKEEPING & RESOURCE objectsccc

ingestResDS

protected void ingestResDS(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest the data into 'resds' table

ingestResInfo

protected void ingestResInfo(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest the data into 'resinfo' table

ingestElemDefObject

protected void ingestElemDefObject(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest ELEMENT_DEFINITION object

ingestDDCol

protected void ingestDDCol(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest the data into 'ddcol' table

ingestDDColD

protected void ingestDDColD(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest the data into 'ddcold' table

ingestDDStdValD

protected void ingestDDStdValD(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest the data into 'ddstdvald' table

ingestDDFormRule

protected void ingestDDFormRule(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest the data into 'ddformrule' table

ingestDDSysClass

protected void ingestDDSysClass(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest the data into 'ddsysclass' table

ingestDDGenClass

protected void ingestDDGenClass(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest the data into 'ddgenclass' table

ingestStdValObject

protected void ingestStdValObject(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest the data into 'ddcolstdval' table

getIngestedStdValues

public Map<String,String> getIngestedStdValues()

Returns a map of standard values found from the most recent ingestion run.

Returns:

A map containing standard values and its associated table/column name. Example: instinfo.instid - VG

ingestNewStdValues

protected void ingestNewStdValues(Map<String,String> stdValues)

Method to ingest new standard values into the ddcolstdval table. The method first checks to see if the standard value in the given map already exists in the database.

Parameters:

stdValues - A map containing a list of standard values and its associated table/column name. Example: instinfo.instid - VG

ingestObjDefObject

protected void ingestObjDefObject(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest OBJECT_DEFINTION object

ingestDDObjAlias

protected void ingestDDObjAlias(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest the data into 'ddobjhier' table

ingestDDObjD

protected void ingestDDObjD(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest the data into 'ddobjd' table

ingestDDObjects

protected void ingestDDObjects(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest the data into 'ddobjects' table

ingestDDObjElm

protected void ingestDDObjElm(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest the data into 'ddobjelm' table

ingestDDObjHier

protected void ingestDDObjHier(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest the data into 'ddobjhier' table

ingestDDObjStsNote

protected void ingestDDObjStsNote(Map<String,gov.nasa.pds.tools.label.AttributeStatement> lblMap)

Method to ingest the data into 'ddobjstsnote' table

collapse

protected String collapse(String source)

Method to remove extra spaces from the string specified by the string attributes. It returns the collapsed string without any additional spaces at the beginning of the string and '\r\n' characters. Example (orignal line): OBJECT = "THIS LINE IS BAD" (collapsed): OBJECT = "THIS LINE IS BAD"

itrim

protected String itrim(String source)

Replace multiple whitespaces between words with single blank

ltrim

protected String ltrim(String source)

Trim the string of any spaces on the left end (ie., leading spaces removed) Remove leading spaces for each line when there is multiple lines of string

rtrim

protected String rtrim(String source)

Trim the string of any spaces on the right end (ie., trailing spaces removed)

getRowCount

protected int getRowCount(String query)

Method to get the row count from the database

Parameters:

query - SQL query string

Returns:

Number of rows with given SQL query

deleteRecords

protected int deleteRecords(String query)

Method to delete records in the database

Parameters:

query - SQL query sting

Returns:

number of deleted records

main

public static void main(String[] args)

Main method