eu.bootstrep.Utilities
Class GeneralMethods

java.lang.Object
  eu.bootstrep.Utilities.GeneralMethods

public class GeneralMethods
extends java.lang.Object

This class contains general purpose methods to clear and load data into tables.

Field Summary

(package private) DbMethods	DB DB
(package private) Variables	LOV Variables
(package private) Logger	xmlLog Logger

Constructor Summary

GeneralMethods()
Creates a new instance of StagingTables

Method Summary

void	clearTables(PropertyBean PB, MainBean MB, MessageBean mesBn, TableBean tabBn, ListBean LB, java.lang.Integer when, java.lang.Boolean clean) This method creates table lists at various process steps.
void	clearTablesAtStart(PropertyBean PB, MainBean MB, MessageBean mesBn, java.lang.String tName) This method clears tables.
void	executeSelectTargetTables(PropertyBean PB, MainBean MB, MessageBean mesBn, TableBean tabBn, ListBean LB, java.lang.Integer when) This method executes select instructions to load data into tables belonging to target frame.
void	loadIntoTables(PropertyBean PB, MainBean MB, MessageBean mesBn, TableBean tabBn, ListBean LB, java.lang.Integer when) This method loads data into staging/target tables.
void	prepareTargetTables(PropertyBean PB, MainBean MB, MessageBean mesBn, TableBean tabBn, ListBean LB, java.lang.Integer when, java.lang.String alias) This method manages the TheTable bean.

Methods inherited from class java.lang.Object

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

Field Detail

LOV

Variables LOV

Variables

DB

DbMethods DB

DB

xmlLog

Logger xmlLog

Logger

Constructor Detail

GeneralMethods

public GeneralMethods()

Creates a new instance of StagingTables

Method Detail

clearTables

public void clearTables(PropertyBean PB,
                        MainBean MB,
                        MessageBean mesBn,
                        TableBean tabBn,
                        ListBean LB,
                        java.lang.Integer when,
                        java.lang.Boolean clean)

This method creates table lists at various process steps. The when parameter identifies these steps:

• 0, Staging tables
• 1, Target tables
• 2, Special tables
• 3, Final tables
• 4, Preferred tables
• 5, syntax and semantic tables

When clear is true, the clearTablesAtStart method is executed and tables are cleaned, otherwise TableBean bean is updated with lists of tables

Parameters:

PB - The PropertyBean

MB - The MainBean

mesBn - The MessageBean

tabBn - The TableBean

LB - The ListBean

when - The kind of table

clean - Boolean, true to clean tables

clearTablesAtStart

public void clearTablesAtStart(PropertyBean PB,
                               MainBean MB,
                               MessageBean mesBn,
                               java.lang.String tName)

This method clears tables.

Parameters:

PB - The PropertyBean

MB - The MainBean

mesBn - The MessageBean

tName - Table to clear

loadIntoTables

public void loadIntoTables(PropertyBean PB,
                           MainBean MB,
                           MessageBean mesBn,
                           TableBean tabBn,
                           ListBean LB,
                           java.lang.Integer when)

This method loads data into staging/target tables. Input parameter when selects kind of tables.
For staging tables, when=0, this method performs the following steps:

• retrieve sql instruction to load data into standard and correndondence staging tables by executing getInsertTables() and getInsertRelTables() methods
• retrieve the file containing data for the above tables by executing getFileNames() and getFileRelNames() methods
• execute sql load instructions

For other tables, this method performs:

• retrieve table list by executing appropriate methods, depending on when parameter
  • 1, getTgtTables() target tables
  • 2, getSpecialTables() special tables
  • 3, getFinalTables() final tables
  • 4, getPreferredTables() preferred tables
  • 5, getSynSemTables() syntax/semantic tables
• retrieve the file containing data for specific table type. File names are equal to table names.
• execute sql load instructions

Parameters:

PB - The PropertyBean

MB - The MainBean

mesBn - The MessageBean

tabBn - The TableBean

LB - The ListBean

executeSelectTargetTables

public void executeSelectTargetTables(PropertyBean PB,
                                      MainBean MB,
                                      MessageBean mesBn,
                                      TableBean tabBn,
                                      ListBean LB,
                                      java.lang.Integer when)

This method executes select instructions to load data into tables belonging to target frame.
Target and Staging frame, in the BioLexicon database, are in 1 to many relationship. This means that 1 "target" table contains data from 1 or more "staging" tables.
This method performs the following steps:

• retrieve table list contained in the table2Load list of ListBean input parameter
• retrieve the select instruction by executing the getTheQuery() method
• execute the query and add each record retrieved to n list
• update the hashTable by executing the setData2Write() method. The updated hashTable contains table to load and data to be loaded.

Parameters:

PB - The PropertyBean

MB - The MainBean

mesBn - The MessageBean

tabBn - The TableBean

LB - The ListBean

prepareTargetTables

public void prepareTargetTables(PropertyBean PB,
                                MainBean MB,
                                MessageBean mesBn,
                                TableBean tabBn,
                                ListBean LB,
                                java.lang.Integer when,
                                java.lang.String alias)

This method manages the TheTable bean. This is an essential method for loading target frame tables. Target frame and staging frame, in the BioLexicon database, are in 1 to many relationship. This means that 1 "target" table contains data from 1 or more "staging" tables.
This method performs the following steps:

• retrieve table list using the when parameter, as usual:
  • 1, getTgtTables() target tables
  • 2, getSpecialTables() special tables
  • 3, getFinalTables() final tables
  • 4, getPreferredTables() preferred tables
  • 5, getSynSemTables() syntax/semantic tables
• retrieve list of columns by querting the appropriate MAP table
• create the join condition among input staging tables by querying the approriate JOIN table
• create the WHERE condition by querying the appropriate JOIN table
• set TheTable features:
  • setTheCols(...) to set list of columns
  • setTheQuery(...) to set the query in the form SELECT .. FROM ... WHERE ...
  • setTheInputFile(...) to set the input file
  • setTheTableName(...) to set the table to load

This method is executed before the executeSelectTargetTable() method

Parameters:

PB - The PropertyBean

MB - The MainBean

mesBn - The MessageBean

tabBn - The TableBean

LB - The ListBean

when - An integer to select table type

alias - A string. Default is X, however C and S are used to manage tables defined by same XML element at various deep. For example, <Relation / > defines SENSERELATION table both with deep 4, as subnode of <Cluster /gt; (alias=C) and with deep 8 as subnode of <Entry /> (alias=S)