gov.nasa.pds.citool.ingestor
Class CatalogDB

java.lang.Object
  extended by 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
static int failCount
           
static int newStdValueCount
           
static int okCount
           
 
Constructor Summary
CatalogDB(String user, String pass, String server, String dbname, Target target, IngestReport report)
          Constructor
 
Method Summary
 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



Copyright © 2010-2013 Planetary Data System. All Rights Reserved.