org.sandev.tools.JDBC
Class THD_SchemaVerifier

java.lang.Object
  org.sandev.tools.JDBC.THD_SchemaVerifier

public class THD_SchemaVerifier

extends java.lang.Object

Write table verification code to make sure the struct definitions we are working with match what is in the database. AUTOGENERATED FILE, DO NOT EDIT DIRECTLY.
source: declared in build
generator: org.sandev.generator.SQLSchemaVerifierGenerator
time: Dec 2, 2005 6:38:59 PM

If anything doesn't match, then call the Converter (if configured) to fix it.

Field Summary

protected java.sql.Connection	conn The connection we use for our work so we don't have to pass it around.
protected org.sandev.basics.DataManager.DataManagerNode	dm Our back reference so we don't have to pass it around

Constructor Summary

THD_SchemaVerifier(java.sql.Connection conn, org.sandev.basics.DataManager.DataManagerNode dm)
set up our local references for work

Method Summary

void	createTHD_ExternalPlanTable() Create the THD_ExternalPlan table.
void	createTHD_HeapAttributesTable() Create the THD_HeapAttributes table.
void	createTHD_Plan_componentsTable() Create the THD_Plan_components relation.
void	createTHD_PlanComponentTable() Create the THD_PlanComponent table.
void	createTHD_PlanTable() Create the THD_Plan table.
void	createTHD_ReaderTable() Create the THD_Reader table.
void	createTHD_ResourceTable() Create the THD_Resource table.
void	createTHD_TaskPhaseTable() Create the THD_TaskPhase table.
void	createTHD_TaskTable() Create the THD_Task table.
void	createTHD_TaskType_phasesTable() Create the THD_TaskType_phases relation.
void	createTHD_TaskTypeTable() Create the THD_TaskType table.
protected int	findColumnIndex(java.sql.ResultSetMetaData rsmd, java.lang.String colName) Given a ResultSetMetaData, verify that the specified column exists with the specified type.
java.sql.Connection	getConnection() accessor for conn
java.lang.String	getTHD_ExternalPlanBrokenFields(java.sql.ResultSetMetaData rsmd) Verify that the meta data we have matches the struct definition.
java.lang.String	getTHD_HeapAttributesBrokenFields(java.sql.ResultSetMetaData rsmd) Verify that the meta data we have matches the struct definition.
java.lang.String	getTHD_Plan_componentsBrokenFields(java.sql.ResultSetMetaData rsmd) Check the meta data matches what we need
java.lang.String	getTHD_PlanBrokenFields(java.sql.ResultSetMetaData rsmd) Verify that the meta data we have matches the struct definition.
java.lang.String	getTHD_PlanComponentBrokenFields(java.sql.ResultSetMetaData rsmd) Verify that the meta data we have matches the struct definition.
java.lang.String	getTHD_ReaderBrokenFields(java.sql.ResultSetMetaData rsmd) Verify that the meta data we have matches the struct definition.
java.lang.String	getTHD_ResourceBrokenFields(java.sql.ResultSetMetaData rsmd) Verify that the meta data we have matches the struct definition.
java.lang.String	getTHD_TaskBrokenFields(java.sql.ResultSetMetaData rsmd) Verify that the meta data we have matches the struct definition.
java.lang.String	getTHD_TaskPhaseBrokenFields(java.sql.ResultSetMetaData rsmd) Verify that the meta data we have matches the struct definition.
java.lang.String	getTHD_TaskType_phasesBrokenFields(java.sql.ResultSetMetaData rsmd) Check the meta data matches what we need
java.lang.String	getTHD_TaskTypeBrokenFields(java.sql.ResultSetMetaData rsmd) Verify that the meta data we have matches the struct definition.
void	verifyTables() Verify that the tables we need for persistency exist and match the current struct definitions.
void	verifyTHD_ExternalPlan() Verify the THD_ExternalPlan table exists
void	verifyTHD_HeapAttributes() Verify the THD_HeapAttributes table exists
void	verifyTHD_Plan_components() Verify the THD_Plan_components table exists
void	verifyTHD_Plan() Verify the THD_Plan table exists
void	verifyTHD_PlanComponent() Verify the THD_PlanComponent table exists
void	verifyTHD_Reader() Verify the THD_Reader table exists
void	verifyTHD_Resource() Verify the THD_Resource table exists
void	verifyTHD_Task() Verify the THD_Task table exists
void	verifyTHD_TaskPhase() Verify the THD_TaskPhase table exists
void	verifyTHD_TaskType_phases() Verify the THD_TaskType_phases table exists
void	verifyTHD_TaskType() Verify the THD_TaskType table exists

Methods inherited from class java.lang.Object

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

Field Detail

conn

protected java.sql.Connection conn

The connection we use for our work so we don't have to pass it around.

dm

protected org.sandev.basics.DataManager.DataManagerNode dm

Our back reference so we don't have to pass it around

Constructor Detail

THD_SchemaVerifier

public THD_SchemaVerifier(java.sql.Connection conn,
                          org.sandev.basics.DataManager.DataManagerNode dm)

set up our local references for work

Method Detail

getConnection

public java.sql.Connection getConnection()

accessor for conn

verifyTables

public void verifyTables()
                  throws java.sql.SQLException

Verify that the tables we need for persistency exist and match the current struct definitions.

Throws:

java.sql.SQLException

verifyTHD_ExternalPlan

public void verifyTHD_ExternalPlan()
                            throws java.sql.SQLException

Verify the THD_ExternalPlan table exists

Throws:

java.sql.SQLException

createTHD_ExternalPlanTable

public void createTHD_ExternalPlanTable()
                                 throws java.sql.SQLException

Create the THD_ExternalPlan table.

Throws:

java.sql.SQLException

getTHD_ExternalPlanBrokenFields

public java.lang.String getTHD_ExternalPlanBrokenFields(java.sql.ResultSetMetaData rsmd)
                                                 throws java.sql.SQLException

Verify that the meta data we have matches the struct definition. If there were any diffs, then we call the Converter (if available) to fix things up.

Throws:

java.sql.SQLException

verifyTHD_HeapAttributes

public void verifyTHD_HeapAttributes()
                              throws java.sql.SQLException

Verify the THD_HeapAttributes table exists

Throws:

java.sql.SQLException

createTHD_HeapAttributesTable

public void createTHD_HeapAttributesTable()
                                   throws java.sql.SQLException

Create the THD_HeapAttributes table.

Throws:

java.sql.SQLException

getTHD_HeapAttributesBrokenFields

public java.lang.String getTHD_HeapAttributesBrokenFields(java.sql.ResultSetMetaData rsmd)
                                                   throws java.sql.SQLException

Verify that the meta data we have matches the struct definition. If there were any diffs, then we call the Converter (if available) to fix things up.

Throws:

java.sql.SQLException

verifyTHD_PlanComponent

public void verifyTHD_PlanComponent()
                             throws java.sql.SQLException

Verify the THD_PlanComponent table exists

Throws:

java.sql.SQLException

createTHD_PlanComponentTable

public void createTHD_PlanComponentTable()
                                  throws java.sql.SQLException

Create the THD_PlanComponent table.

Throws:

java.sql.SQLException

getTHD_PlanComponentBrokenFields

public java.lang.String getTHD_PlanComponentBrokenFields(java.sql.ResultSetMetaData rsmd)
                                                  throws java.sql.SQLException

Verify that the meta data we have matches the struct definition. If there were any diffs, then we call the Converter (if available) to fix things up.

Throws:

java.sql.SQLException

verifyTHD_Plan

public void verifyTHD_Plan()
                    throws java.sql.SQLException

Verify the THD_Plan table exists

Throws:

java.sql.SQLException

createTHD_PlanTable

public void createTHD_PlanTable()
                         throws java.sql.SQLException

Create the THD_Plan table.

Throws:

java.sql.SQLException

getTHD_PlanBrokenFields

public java.lang.String getTHD_PlanBrokenFields(java.sql.ResultSetMetaData rsmd)
                                         throws java.sql.SQLException

Verify that the meta data we have matches the struct definition. If there were any diffs, then we call the Converter (if available) to fix things up.

Throws:

java.sql.SQLException

verifyTHD_Plan_components

public void verifyTHD_Plan_components()
                               throws java.sql.SQLException

Verify the THD_Plan_components table exists

Throws:

java.sql.SQLException

createTHD_Plan_componentsTable

public void createTHD_Plan_componentsTable()
                                    throws java.sql.SQLException

Create the THD_Plan_components relation.

Throws:

java.sql.SQLException

getTHD_Plan_componentsBrokenFields

public java.lang.String getTHD_Plan_componentsBrokenFields(java.sql.ResultSetMetaData rsmd)
                                                    throws java.sql.SQLException

Check the meta data matches what we need

Throws:

java.sql.SQLException

verifyTHD_Reader

public void verifyTHD_Reader()
                      throws java.sql.SQLException

Verify the THD_Reader table exists

Throws:

java.sql.SQLException

createTHD_ReaderTable

public void createTHD_ReaderTable()
                           throws java.sql.SQLException

Create the THD_Reader table.

Throws:

java.sql.SQLException

getTHD_ReaderBrokenFields

public java.lang.String getTHD_ReaderBrokenFields(java.sql.ResultSetMetaData rsmd)
                                           throws java.sql.SQLException

Verify that the meta data we have matches the struct definition. If there were any diffs, then we call the Converter (if available) to fix things up.

Throws:

java.sql.SQLException

verifyTHD_Resource

public void verifyTHD_Resource()
                        throws java.sql.SQLException

Verify the THD_Resource table exists

Throws:

java.sql.SQLException

createTHD_ResourceTable

public void createTHD_ResourceTable()
                             throws java.sql.SQLException

Create the THD_Resource table.

Throws:

java.sql.SQLException

getTHD_ResourceBrokenFields

public java.lang.String getTHD_ResourceBrokenFields(java.sql.ResultSetMetaData rsmd)
                                             throws java.sql.SQLException

Verify that the meta data we have matches the struct definition. If there were any diffs, then we call the Converter (if available) to fix things up.

Throws:

java.sql.SQLException

verifyTHD_TaskPhase

public void verifyTHD_TaskPhase()
                         throws java.sql.SQLException

Verify the THD_TaskPhase table exists

Throws:

java.sql.SQLException

createTHD_TaskPhaseTable

public void createTHD_TaskPhaseTable()
                              throws java.sql.SQLException

Create the THD_TaskPhase table.

Throws:

java.sql.SQLException

getTHD_TaskPhaseBrokenFields

public java.lang.String getTHD_TaskPhaseBrokenFields(java.sql.ResultSetMetaData rsmd)
                                              throws java.sql.SQLException

Verify that the meta data we have matches the struct definition. If there were any diffs, then we call the Converter (if available) to fix things up.

Throws:

java.sql.SQLException

verifyTHD_Task

public void verifyTHD_Task()
                    throws java.sql.SQLException

Verify the THD_Task table exists

Throws:

java.sql.SQLException

createTHD_TaskTable

public void createTHD_TaskTable()
                         throws java.sql.SQLException

Create the THD_Task table.

Throws:

java.sql.SQLException

getTHD_TaskBrokenFields

public java.lang.String getTHD_TaskBrokenFields(java.sql.ResultSetMetaData rsmd)
                                         throws java.sql.SQLException

Verify that the meta data we have matches the struct definition. If there were any diffs, then we call the Converter (if available) to fix things up.

Throws:

java.sql.SQLException

verifyTHD_TaskType

public void verifyTHD_TaskType()
                        throws java.sql.SQLException

Verify the THD_TaskType table exists

Throws:

java.sql.SQLException

createTHD_TaskTypeTable

public void createTHD_TaskTypeTable()
                             throws java.sql.SQLException

Create the THD_TaskType table.

Throws:

java.sql.SQLException

getTHD_TaskTypeBrokenFields

public java.lang.String getTHD_TaskTypeBrokenFields(java.sql.ResultSetMetaData rsmd)
                                             throws java.sql.SQLException

Verify that the meta data we have matches the struct definition. If there were any diffs, then we call the Converter (if available) to fix things up.

Throws:

java.sql.SQLException

verifyTHD_TaskType_phases

public void verifyTHD_TaskType_phases()
                               throws java.sql.SQLException

Verify the THD_TaskType_phases table exists

Throws:

java.sql.SQLException

createTHD_TaskType_phasesTable

public void createTHD_TaskType_phasesTable()
                                    throws java.sql.SQLException

Create the THD_TaskType_phases relation.

Throws:

java.sql.SQLException

getTHD_TaskType_phasesBrokenFields

public java.lang.String getTHD_TaskType_phasesBrokenFields(java.sql.ResultSetMetaData rsmd)
                                                    throws java.sql.SQLException

Check the meta data matches what we need

Throws:

java.sql.SQLException

findColumnIndex

protected int findColumnIndex(java.sql.ResultSetMetaData rsmd,
                              java.lang.String colName)
                       throws java.sql.SQLException

Given a ResultSetMetaData, verify that the specified column exists with the specified type.

Throws:

java.sql.SQLException