gov.nasa.pds.citool.ingestor
Class CatalogDB

java.lang.Object
  extended by gov.nasa.pds.citool.ingestor.CatalogDB

public class CatalogDB
extends java.lang.Object

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

Author:
hyunleex

Field Summary
static int failCount
           
static int okCount
           
 
Constructor Summary
CatalogDB(java.lang.String user, java.lang.String pass, java.lang.String server, java.lang.String dbname)
          Constructor
 
Method Summary
 void close()
          Method to close the database connection
protected  java.lang.String collapse(java.lang.String source)
          Method to remove extra spaces from the string specified by the string attributes.
protected  int deleteRecords(java.lang.String query)
          Method to delete records in the database
protected  int getRowCount(java.lang.String query)
          Method to get the row count from the database
protected  void ingestDataSetColObject(java.util.Map lblMap)
          Method to ingest DATA_SET_COLLECTION object
protected  void ingestDataSetObject(java.util.Map lblMap)
          Method to ingest DATA_SET object
protected  void ingestDDCol(java.util.Map lblMap)
          Method to ingest the data into 'ddcol' table
protected  void ingestDDColD(java.util.Map lblMap)
          Method to ingest the data into 'ddcold' table
protected  void ingestDDFormRule(java.util.Map lblMap)
          Method to ingest the data into 'ddformrule' table
protected  void ingestDDGenClass(java.util.Map lblMap)
          Method to ingest the data into 'ddgenclass' table
protected  void ingestDDStdValD(java.util.Map lblMap)
          Method to ingest the data into 'ddstdvald' table
protected  void ingestDDSysClass(java.util.Map lblMap)
          Method to ingest the data into 'ddsysclass' table
protected  void ingestDSCollAssocDSObject(java.util.Map lblMap)
          Method to ingest the data into 'dscollds' table
protected  void ingestDSCollD(java.util.Map lblMap)
          Method to ingest the data into 'dscolld' table
protected  void ingestDSCollDoc(java.util.Map lblMap)
          Method to ingest the data into 'dscolldoc' table
protected  void ingestDSCollInfo(java.util.Map lblMap)
          Method to ingest the data into 'dscollinfo' table
protected  void ingestDSCollUsgd(java.util.Map lblMap)
          Method to ingest the data into 'dscollusgd' table
protected  void ingestDSConf(java.util.Map lblMap)
          Method to ingest the data into 'dsconf' table
protected  void ingestDSD(java.util.Map lblMap)
          Method to ingest the data into 'dsd' table
protected  void ingestDSHost(java.util.Map lblMap)
          Method to ingest the data into 'dshost' table
protected  void ingestDSInfo(java.util.Map lblMap)
          Method to ingest the data into 'dsinfo' table
protected  void ingestDSMsn(java.util.Map lblMap)
          Method to ingest the data into 'dsmsn' table
protected  void ingestDSRefInfoObject(java.util.Map lblMap)
          Method to ingest the data into 'dsdoc' table
protected  void ingestDSReleaseObject(java.util.Map lblMap)
          Method to ingest DATA_SET_RELEASE object
protected  void ingestDSTarg(java.util.Map lblMap)
          Method to ingest the data into 'dstarg' table
protected  void ingestElemDefObject(java.util.Map lblMap)
          Method to ingest ELEMENT_DEFINITION object
protected  void ingestHostD(java.util.Map lblMap)
          Method to ingest the data into 'hostd' table
protected  void ingestHostInfo(java.util.Map lblMap)
          Method to ingest the data into 'hostinfo' table
protected  void ingestInstD(java.util.Map lblMap)
          Method to ingest the data into 'instd' table
protected  void ingestInstHostObject(java.util.Map lblMap)
          Method to ingest INSTRUMENT_HOST object
protected  void ingestInstHostRefInfoObject(java.util.Map lblMap)
          Method to ingest the data into 'hostdoc' table
protected  void ingestInstInfo(java.util.Map lblMap)
          Method to ingest the data into 'instinfo' table
protected  void ingestInstObject(java.util.Map lblMap)
          Method to ingest INSTRUMENT object
protected  void ingestInstRefInfoObject(java.util.Map lblMap)
          Method to ingest the data into 'instdoc' table
 void ingestInventoryObject(java.util.Map lblMap)
          Method to ingest INVENTORY object
protected  void ingestInvNodeMedia(java.util.Map lblMap)
          Method to ingest the data into 'invnodemedia' table
protected  void ingestInvSpcOrdNt(java.util.Map lblMap)
          Method to ingest the data into 'invspcordnt' table
protected  void ingestMissionObject(java.util.Map lblMap)
          Method to ingest MISSION object
protected  void ingestMsnD(java.util.Map lblMap)
          Method to ingest the data into 'msnd' table
protected  void ingestMsnDoc(java.util.Map lblMap)
          Method to ingest the data into 'msndoc' table
protected  void ingestMsnHost(java.util.Map lblMap)
          Method to ingest the data into 'msnhost' table
protected  void ingestMsnInfo(java.util.Map lblMap)
          Method to ingest the data into 'msninfo' table
protected  void ingestMsnObjsmy(java.util.Map lblMap)
          Method to ingest the data into 'msnobjsmy' table
protected  void ingestNssdcdsidObject(java.util.Map lblMap)
          Method to ingest NSSDCDSID object
protected  void ingestPersElecmail(java.util.Map lblMap)
          Method to ingest the data into 'perselecmail' table
protected  void ingestPersInfo(java.util.Map lblMap)
          Method to ingest the data into 'persinfo' table
protected  void ingestPersMailAddr(java.util.Map lblMap)
          Method to ingest the data into 'persmailaddr' table
protected  void ingestPersonnelObject(java.util.Map lblMap)
          Method to ingest PERSONNEL object
 void ingestReferenceObject(java.util.Map lblMap)
          Method to ingest the data into 'refd' table
protected  void ingestResDS(java.util.Map lblMap)
          Method to ingest the data into 'resds' table
protected  void ingestResInfo(java.util.Map lblMap)
          Method to ingest the data into 'resinfo' table
protected  void ingestResourceObject(java.util.Map lblMap)
          Method to ingest DATA_SET_HOUSEKEEPING & RESOURCE objects
protected  void ingestSoftwareObject(java.util.Map lblMap)
          Method to ingest SOFTWARE object
 void ingestSoftwareOnlineObject(java.util.Map lblMap)
          Method to ingest the data into 'swonline' table
protected  void ingestStdValObject(java.util.Map lblMap)
          Method to ingest the data into 'ddcolstdval' table
protected  void ingestSWD(java.util.Map lblMap)
          Method to ingest the data into 'swd' table
protected  void ingestSWInfo(java.util.Map lblMap)
          Method to ingest the data into 'swinfo' table
protected  void ingestSWPur(java.util.Map lblMap)
          Method to ingest the data into 'swpur' table
protected  void ingestTargetD(java.util.Map lblMap)
          Method to ingest the data into 'targetd' table
protected  void ingestTargetDoc(java.util.Map lblMap)
          Method to ingest the data into 'targetdoc' table
protected  void ingestTargetInfo(java.util.Map lblMap)
          Method to ingest the data into 'targetinfo' table
 void ingestTargetObject(java.util.Map lblMap)
          Method to ingest TARGET object
protected  void ingestVolDesc(java.util.Map lblMap)
          Method to ingest the data into 'voldesc' table
protected  void ingestVolDS(java.util.Map lblMap)
          Method to ingest the data into 'volds' table
protected  void ingestVolInfo(java.util.Map lblMap)
          Method to ingest the data into 'volinfo' table
protected  void ingestVolOnline(java.util.Map lblMap)
          Method to ingest the data into 'volonline' table
protected  void ingestVolSerInfo(java.util.Map lblMap)
          Method to ingest the data into 'volserinfo' table
protected  void ingestVolSerSet(java.util.Map lblMap)
          Method to ingest the data into 'volserset' table
protected  void ingestVolSetInfo(java.util.Map lblMap)
          Method to ingest the data into 'volsetinfo' table
 void ingestVolumeObject(java.util.Map lblMap)
          Method to ingest VOLUME object
protected  java.lang.String itrim(java.lang.String source)
          Replace multiple whitespaces between words with single blank
protected  java.lang.String ltrim(java.lang.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(java.lang.String[] args)
           
protected  java.lang.String rtrim(java.lang.String source)
          Trim the string of any spaces on the right end (ie., trailing spaces removed)
 
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
Constructor Detail

CatalogDB

public CatalogDB(java.lang.String user,
                 java.lang.String pass,
                 java.lang.String server,
                 java.lang.String dbname)
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
Method Detail

close

public void close()
Method to close the database connection


ingestMissionObject

protected void ingestMissionObject(java.util.Map lblMap)
Method to ingest MISSION object

Parameters:
lblMap - Hashmap of the PDS label(s)

ingestMsnD

protected void ingestMsnD(java.util.Map lblMap)
Method to ingest the data into 'msnd' table

Parameters:
lblMap - Hashmap of the PDS label(s)

ingestMsnObjsmy

protected void ingestMsnObjsmy(java.util.Map lblMap)
Method to ingest the data into 'msnobjsmy' table


ingestMsnHost

protected void ingestMsnHost(java.util.Map lblMap)
Method to ingest the data into 'msnhost' table


ingestMsnInfo

protected void ingestMsnInfo(java.util.Map lblMap)
Method to ingest the data into 'msninfo' table


ingestMsnDoc

protected void ingestMsnDoc(java.util.Map lblMap)
Method to ingest the data into 'msndoc' table


ingestInstHostObject

protected void ingestInstHostObject(java.util.Map lblMap)
Method to ingest INSTRUMENT_HOST object


ingestHostD

protected void ingestHostD(java.util.Map lblMap)
Method to ingest the data into 'hostd' table


ingestHostInfo

protected void ingestHostInfo(java.util.Map lblMap)
Method to ingest the data into 'hostinfo' table


ingestInstHostRefInfoObject

protected void ingestInstHostRefInfoObject(java.util.Map lblMap)
Method to ingest the data into 'hostdoc' table


ingestInstObject

protected void ingestInstObject(java.util.Map lblMap)
Method to ingest INSTRUMENT object


ingestInstD

protected void ingestInstD(java.util.Map lblMap)
Method to ingest the data into 'instd' table


ingestInstInfo

protected void ingestInstInfo(java.util.Map lblMap)
Method to ingest the data into 'instinfo' table


ingestInstRefInfoObject

protected void ingestInstRefInfoObject(java.util.Map lblMap)
Method to ingest the data into 'instdoc' table


ingestDataSetObject

protected void ingestDataSetObject(java.util.Map lblMap)
Method to ingest DATA_SET object


ingestDSMsn

protected void ingestDSMsn(java.util.Map lblMap)
Method to ingest the data into 'dsmsn' table


ingestDSD

protected void ingestDSD(java.util.Map lblMap)
Method to ingest the data into 'dsd' table


ingestDSConf

protected void ingestDSConf(java.util.Map lblMap)
Method to ingest the data into 'dsconf' table


ingestDSTarg

protected void ingestDSTarg(java.util.Map lblMap)
Method to ingest the data into 'dstarg' table


ingestDSHost

protected void ingestDSHost(java.util.Map lblMap)
Method to ingest the data into 'dshost' table


ingestDSInfo

protected void ingestDSInfo(java.util.Map lblMap)
Method to ingest the data into 'dsinfo' table


ingestDSRefInfoObject

protected void ingestDSRefInfoObject(java.util.Map lblMap)
Method to ingest the data into 'dsdoc' table


ingestReferenceObject

public void ingestReferenceObject(java.util.Map lblMap)
Method to ingest the data into 'refd' table


ingestPersonnelObject

protected void ingestPersonnelObject(java.util.Map lblMap)
Method to ingest PERSONNEL object


ingestPersMailAddr

protected void ingestPersMailAddr(java.util.Map lblMap)
Method to ingest the data into 'persmailaddr' table


ingestPersInfo

protected void ingestPersInfo(java.util.Map lblMap)
Method to ingest the data into 'persinfo' table


ingestPersElecmail

protected void ingestPersElecmail(java.util.Map lblMap)
Method to ingest the data into 'perselecmail' table


ingestDSCollAssocDSObject

protected void ingestDSCollAssocDSObject(java.util.Map lblMap)
Method to ingest the data into 'dscollds' table


ingestDataSetColObject

protected void ingestDataSetColObject(java.util.Map lblMap)
Method to ingest DATA_SET_COLLECTION object


ingestDSCollUsgd

protected void ingestDSCollUsgd(java.util.Map lblMap)
Method to ingest the data into 'dscollusgd' table


ingestDSCollInfo

protected void ingestDSCollInfo(java.util.Map lblMap)
Method to ingest the data into 'dscollinfo' table


ingestDSCollD

protected void ingestDSCollD(java.util.Map lblMap)
Method to ingest the data into 'dscolld' table


ingestDSCollDoc

protected void ingestDSCollDoc(java.util.Map lblMap)
Method to ingest the data into 'dscolldoc' table


ingestInventoryObject

public void ingestInventoryObject(java.util.Map lblMap)
Method to ingest INVENTORY object


ingestInvSpcOrdNt

protected void ingestInvSpcOrdNt(java.util.Map lblMap)
Method to ingest the data into 'invspcordnt' table


ingestInvNodeMedia

protected void ingestInvNodeMedia(java.util.Map lblMap)
Method to ingest the data into 'invnodemedia' table


ingestSoftwareObject

protected void ingestSoftwareObject(java.util.Map lblMap)
Method to ingest SOFTWARE object


ingestSWD

protected void ingestSWD(java.util.Map lblMap)
Method to ingest the data into 'swd' table


ingestSWInfo

protected void ingestSWInfo(java.util.Map lblMap)
Method to ingest the data into 'swinfo' table


ingestSWPur

protected void ingestSWPur(java.util.Map lblMap)
Method to ingest the data into 'swpur' table


ingestSoftwareOnlineObject

public void ingestSoftwareOnlineObject(java.util.Map lblMap)
Method to ingest the data into 'swonline' table


ingestTargetObject

public void ingestTargetObject(java.util.Map lblMap)
Method to ingest TARGET object


ingestTargetD

protected void ingestTargetD(java.util.Map lblMap)
Method to ingest the data into 'targetd' table


ingestTargetInfo

protected void ingestTargetInfo(java.util.Map lblMap)
Method to ingest the data into 'targetinfo' table


ingestTargetDoc

protected void ingestTargetDoc(java.util.Map lblMap)
Method to ingest the data into 'targetdoc' table


ingestVolumeObject

public void ingestVolumeObject(java.util.Map lblMap)
Method to ingest VOLUME object


ingestVolDS

protected void ingestVolDS(java.util.Map lblMap)
Method to ingest the data into 'volds' table


ingestVolDesc

protected void ingestVolDesc(java.util.Map lblMap)
Method to ingest the data into 'voldesc' table


ingestVolInfo

protected void ingestVolInfo(java.util.Map lblMap)
Method to ingest the data into 'volinfo' table


ingestVolSetInfo

protected void ingestVolSetInfo(java.util.Map lblMap)
Method to ingest the data into 'volsetinfo' table


ingestVolSerSet

protected void ingestVolSerSet(java.util.Map lblMap)
Method to ingest the data into 'volserset' table


ingestVolSerInfo

protected void ingestVolSerInfo(java.util.Map lblMap)
Method to ingest the data into 'volserinfo' table


ingestVolOnline

protected void ingestVolOnline(java.util.Map lblMap)
Method to ingest the data into 'volonline' table


ingestNssdcdsidObject

protected void ingestNssdcdsidObject(java.util.Map lblMap)
Method to ingest NSSDCDSID object


ingestDSReleaseObject

protected void ingestDSReleaseObject(java.util.Map lblMap)
Method to ingest DATA_SET_RELEASE object


ingestResourceObject

protected void ingestResourceObject(java.util.Map lblMap)
Method to ingest DATA_SET_HOUSEKEEPING & RESOURCE objects


ingestResDS

protected void ingestResDS(java.util.Map lblMap)
Method to ingest the data into 'resds' table


ingestResInfo

protected void ingestResInfo(java.util.Map lblMap)
Method to ingest the data into 'resinfo' table


ingestElemDefObject

protected void ingestElemDefObject(java.util.Map lblMap)
Method to ingest ELEMENT_DEFINITION object


ingestDDCol

protected void ingestDDCol(java.util.Map lblMap)
Method to ingest the data into 'ddcol' table


ingestDDColD

protected void ingestDDColD(java.util.Map lblMap)
Method to ingest the data into 'ddcold' table


ingestDDStdValD

protected void ingestDDStdValD(java.util.Map lblMap)
Method to ingest the data into 'ddstdvald' table


ingestDDFormRule

protected void ingestDDFormRule(java.util.Map lblMap)
Method to ingest the data into 'ddformrule' table


ingestDDSysClass

protected void ingestDDSysClass(java.util.Map lblMap)
Method to ingest the data into 'ddsysclass' table


ingestDDGenClass

protected void ingestDDGenClass(java.util.Map lblMap)
Method to ingest the data into 'ddgenclass' table


ingestStdValObject

protected void ingestStdValObject(java.util.Map lblMap)
Method to ingest the data into 'ddcolstdval' table


collapse

protected java.lang.String collapse(java.lang.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 java.lang.String itrim(java.lang.String source)
Replace multiple whitespaces between words with single blank


ltrim

protected java.lang.String ltrim(java.lang.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 java.lang.String rtrim(java.lang.String source)
Trim the string of any spaces on the right end (ie., trailing spaces removed)


getRowCount

protected int getRowCount(java.lang.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(java.lang.String query)
Method to delete records in the database

Parameters:
query - SQL query sting
Returns:
number of deleted records

main

public static void main(java.lang.String[] args)


Copyright © 2005-2009 Planetary Data System. All Rights Reserved.