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: Jul 31, 2008 4:34:17 PM
structmap: org.sandev.generator.PostgreSQLStructMapper@798797

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_Account_heapsTable() Create the THD_Account_heaps relation.
void	createTHD_AccountTable() Create the THD_Account table.
void	createTHD_DataManagementTable() Create the THD_DataManagement table.
void	createTHD_ExternalPlanTable() Create the THD_ExternalPlan table.
void	createTHD_HeapAssociation_responsibilitiesTable() Create the THD_HeapAssociation_responsibilities relation.
void	createTHD_HeapAssociationTable() Create the THD_HeapAssociation table.
void	createTHD_HeapAttributesTable() Create the THD_HeapAttributes table.
void	createTHD_Plan_componentsTable() Create the THD_Plan_components relation.
void	createTHD_PlanComponent_responsibilitiesTable() Create the THD_PlanComponent_responsibilities relation.
void	createTHD_PlanComponentTable() Create the THD_PlanComponent table.
void	createTHD_PlanTable() Create the THD_Plan table.
void	createTHD_RoleTable() Create the THD_Role table.
void	createTHD_SystemStatusTable() Create the THD_SystemStatus 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_Account_heapsBrokenFields(java.sql.ResultSetMetaData rsmd) Check the meta data matches what we need
java.lang.String	getTHD_AccountBrokenFields(java.sql.ResultSetMetaData rsmd) Verify that the meta data we have matches the struct definition.
java.lang.String	getTHD_DataManagementBrokenFields(java.sql.ResultSetMetaData rsmd) Verify that the meta data we have matches the struct definition.
java.lang.String	getTHD_ExternalPlanBrokenFields(java.sql.ResultSetMetaData rsmd) Verify that the meta data we have matches the struct definition.
java.lang.String	getTHD_HeapAssociation_responsibilitiesBrokenFields(java.sql.ResultSetMetaData rsmd) Check the meta data matches what we need
java.lang.String	getTHD_HeapAssociationBrokenFields(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_PlanComponent_responsibilitiesBrokenFields(java.sql.ResultSetMetaData rsmd) Check the meta data matches what we need
java.lang.String	getTHD_PlanComponentBrokenFields(java.sql.ResultSetMetaData rsmd) Verify that the meta data we have matches the struct definition.
java.lang.String	getTHD_RoleBrokenFields(java.sql.ResultSetMetaData rsmd) Verify that the meta data we have matches the struct definition.
java.lang.String	getTHD_SystemStatusBrokenFields(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_Account_heaps() Verify the THD_Account_heaps table exists
void	verifyTHD_Account() Verify the THD_Account table exists
void	verifyTHD_DataManagement() Verify the THD_DataManagement table exists
void	verifyTHD_ExternalPlan() Verify the THD_ExternalPlan table exists
void	verifyTHD_HeapAssociation_responsibilities() Verify the THD_HeapAssociation_responsibilities table exists
void	verifyTHD_HeapAssociation() Verify the THD_HeapAssociation 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_responsibilities() Verify the THD_PlanComponent_responsibilities table exists
void	verifyTHD_PlanComponent() Verify the THD_PlanComponent table exists
void	verifyTHD_Role() Verify the THD_Role table exists
void	verifyTHD_SystemStatus() Verify the THD_SystemStatus 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_Account

public void verifyTHD_Account()
                       throws java.sql.SQLException

Verify the THD_Account table exists

Throws:

java.sql.SQLException

createTHD_AccountTable

public void createTHD_AccountTable()
                            throws java.sql.SQLException

Create the THD_Account table.

Throws:

java.sql.SQLException

getTHD_AccountBrokenFields

public java.lang.String getTHD_AccountBrokenFields(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_Account_heaps

public void verifyTHD_Account_heaps()
                             throws java.sql.SQLException

Verify the THD_Account_heaps table exists

Throws:

java.sql.SQLException

createTHD_Account_heapsTable

public void createTHD_Account_heapsTable()
                                  throws java.sql.SQLException

Create the THD_Account_heaps relation.

Throws:

java.sql.SQLException

getTHD_Account_heapsBrokenFields

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

Check the meta data matches what we need

Throws:

java.sql.SQLException

verifyTHD_DataManagement

public void verifyTHD_DataManagement()
                              throws java.sql.SQLException

Verify the THD_DataManagement table exists

Throws:

java.sql.SQLException

createTHD_DataManagementTable

public void createTHD_DataManagementTable()
                                   throws java.sql.SQLException

Create the THD_DataManagement table.

Throws:

java.sql.SQLException

getTHD_DataManagementBrokenFields

public java.lang.String getTHD_DataManagementBrokenFields(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_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_HeapAssociation

public void verifyTHD_HeapAssociation()
                               throws java.sql.SQLException

Verify the THD_HeapAssociation table exists

Throws:

java.sql.SQLException

createTHD_HeapAssociationTable

public void createTHD_HeapAssociationTable()
                                    throws java.sql.SQLException

Create the THD_HeapAssociation table.

Throws:

java.sql.SQLException

getTHD_HeapAssociationBrokenFields

public java.lang.String getTHD_HeapAssociationBrokenFields(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_HeapAssociation_responsibilities

public void verifyTHD_HeapAssociation_responsibilities()
                                                throws java.sql.SQLException

Verify the THD_HeapAssociation_responsibilities table exists

Throws:

java.sql.SQLException

createTHD_HeapAssociation_responsibilitiesTable

public void createTHD_HeapAssociation_responsibilitiesTable()
                                                     throws java.sql.SQLException

Create the THD_HeapAssociation_responsibilities relation.

Throws:

java.sql.SQLException

getTHD_HeapAssociation_responsibilitiesBrokenFields

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

Check the meta data matches what we need

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_PlanComponent_responsibilities

public void verifyTHD_PlanComponent_responsibilities()
                                              throws java.sql.SQLException

Verify the THD_PlanComponent_responsibilities table exists

Throws:

java.sql.SQLException

createTHD_PlanComponent_responsibilitiesTable

public void createTHD_PlanComponent_responsibilitiesTable()
                                                   throws java.sql.SQLException

Create the THD_PlanComponent_responsibilities relation.

Throws:

java.sql.SQLException

getTHD_PlanComponent_responsibilitiesBrokenFields

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

Check the meta data matches what we need

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_Role

public void verifyTHD_Role()
                    throws java.sql.SQLException

Verify the THD_Role table exists

Throws:

java.sql.SQLException

createTHD_RoleTable

public void createTHD_RoleTable()
                         throws java.sql.SQLException

Create the THD_Role table.

Throws:

java.sql.SQLException

getTHD_RoleBrokenFields

public java.lang.String getTHD_RoleBrokenFields(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_SystemStatus

public void verifyTHD_SystemStatus()
                            throws java.sql.SQLException

Verify the THD_SystemStatus table exists

Throws:

java.sql.SQLException

createTHD_SystemStatusTable

public void createTHD_SystemStatusTable()
                                 throws java.sql.SQLException

Create the THD_SystemStatus table.

Throws:

java.sql.SQLException

getTHD_SystemStatusBrokenFields

public java.lang.String getTHD_SystemStatusBrokenFields(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