org.LexGrid.util.sql.lgTables
Class SQLLiteTableUtilities

java.lang.Object
  extended by org.LexGrid.util.sql.lgTables.SQLLiteTableUtilities

public class SQLLiteTableUtilities
extends java.lang.Object

Class for creating, adding/removing constraints, and cleaning the SQLLite tables.

Author:
Dan Armbrust

Constructor Summary
SQLLiteTableUtilities(java.sql.Connection sqlConnection)
           
 
Method Summary
 void cleanTables(java.lang.String codingScheme)
          Remove all data from the tables of a given Coding Scheme
 void createAllTables()
          Creates the Tables
 void createTableConstraints()
          Creates the constraints on the tables
 void dropTableConstraints()
           
 java.lang.String getDatabaseType()
          Returns the specific database type
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

SQLLiteTableUtilities

public SQLLiteTableUtilities(java.sql.Connection sqlConnection)
                      throws java.lang.Exception
Parameters:
sqlConnection -
Throws:
java.lang.Exception
Method Detail

getDatabaseType

public java.lang.String getDatabaseType()
Returns the specific database type

Returns:
database type

createAllTables

public void createAllTables()
                     throws java.sql.SQLException
Creates the Tables

Throws:
java.sql.SQLException

createTableConstraints

public void createTableConstraints()
                            throws java.sql.SQLException
Creates the constraints on the tables

Throws:
java.sql.SQLException

dropTableConstraints

public void dropTableConstraints()
                          throws java.sql.SQLException
Throws:
java.sql.SQLException

cleanTables

public void cleanTables(java.lang.String codingScheme)
                 throws java.sql.SQLException
Remove all data from the tables of a given Coding Scheme

Parameters:
codingScheme - target Coding Scheme
Throws:
java.sql.SQLException

Copyright: (c) 2004-2006 Mayo Foundation for Medical Education and Research (MFMER). All rights reserved. MAYO, MAYO CLINIC, and the triple-shield Mayo logo are trademarks and service marks of MFMER.