Package edu.suffolk.litlab.efspserver.db

Class DatabaseVersion

java.lang.Object

edu.suffolk.litlab.efspserver.db.DatabaseVersion

public class DatabaseVersion
extends Object

Updates all of the collective tables for a consistent "schema". Since this class should work going back to extremely old versions of the code, this class should be completely self contained, only using SQL queries from here.

Author:

brycew

Constructor Summary

Constructors

Constructor	Description
DatabaseVersion(Connection codeConn, Connection userConn)

Method Summary

Modifier and Type	Method	Description
void	createTablesIfAbsent(boolean brandNew)
int	getSchemaVersion()
boolean	setSchemaVersion(int newVersion)
void	update5To6()
void	update8To9()
void	update9To10()
boolean	updateToLatest()

Methods inherited from class java.lang.Object

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

Constructor Details

DatabaseVersion

public DatabaseVersion(Connection codeConn,
 Connection userConn)

Method Details

createTablesIfAbsent

public void createTablesIfAbsent(boolean brandNew)
                          throws SQLException

Throws:

SQLException

setSchemaVersion

public boolean setSchemaVersion(int newVersion)
                         throws SQLException

Throws:

SQLException

getSchemaVersion

public int getSchemaVersion()
                     throws SQLException

Throws:

SQLException

updateToLatest

public boolean updateToLatest()
                       throws NoSuchAlgorithmException

Throws:

NoSuchAlgorithmException

update5To6

public void update5To6()
                throws SQLException

Throws:

SQLException

update8To9

public void update8To9()
                throws SQLException

Throws:

SQLException

update9To10

public void update9To10()
                 throws SQLException

Throws:

SQLException