at.ac.iiasa.kolp.gamsage.database

Class Database

java.lang.Object

at.ac.iiasa.kolp.gamsage.database.Database

public class Database
extends java.lang.Object

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
class	Database.WatchDog

Field Summary

Fields

Modifier and Type	Field and Description
java.sql.Connection	dbConn

Constructor Summary

Constructors

Constructor and Description
Database()

Method Summary

Modifier and Type	Method and Description
void	cleanupById(int pRunid)
void	copyCaCase(java.lang.String pUser, java.lang.String pSrcProject, java.lang.String pSrcScenario, java.lang.String pTgtProject, java.lang.String pTgtScenario)
void	copyCaseOld(java.lang.String pSrcProject, java.lang.String pSrcScenario, java.lang.String pTgtProject, java.lang.String pTgtScenario)
int	getIdByRunid(java.lang.String pTable, java.lang.String pName, int pRunid)
int	getRunid(java.lang.String pProject, java.lang.String pScenario)
int	getRunid(java.lang.String pUser, java.lang.String pProject, java.lang.String pScenario)
int	getSomeId(java.lang.String pTable, java.lang.String pName)
java.sql.Connection	getSourceConn()
java.sql.Connection	getTargetConn()
void	openSourceConnection()
void	queryCase(java.lang.String pProject, java.lang.String pScenario)
void	saveEntities(int pRunid, java.util.TreeSet<java.lang.String> pSet)
void	savePardata(int pRunid, java.util.TreeMap<java.lang.String,java.util.TreeMap<java.lang.Integer,java.lang.Double>> pData)
void	savePardata2(int pRunid, java.lang.String pColnames, java.util.TreeMap<java.lang.String,java.util.TreeMap<java.lang.Integer,java.lang.Double>> pData) version with n-period data columns
void	savePeriods(int pRunid, java.util.TreeSet<java.lang.Integer> pSet)
void	saveRegions(int pRunid, java.util.TreeSet<java.lang.String> pSet)
void	saveSomethingByRunid(int pRunid, java.lang.String pTable, java.util.TreeSet<java.lang.String> pSet)
void	saveTecActs(int pRunid, java.util.TreeSet<java.lang.String> pSet)
void	updateCreate(java.lang.String pUser, int pRunid)
void	updateUpdate(java.lang.String pUser, int pRunid)

Methods inherited from class java.lang.Object

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

Field Detail

dbConn

public java.sql.Connection dbConn

Constructor Detail

Database

public Database()
         throws java.lang.Exception

Throws:

java.lang.Exception

Method Detail

getSourceConn

public java.sql.Connection getSourceConn()

getTargetConn

public java.sql.Connection getTargetConn()

openSourceConnection

public void openSourceConnection()
                          throws java.lang.Exception

Throws:

java.lang.Exception

getRunid

public int getRunid(java.lang.String pProject,
                    java.lang.String pScenario)
             throws java.lang.Exception

Throws:

java.lang.Exception

getRunid

public int getRunid(java.lang.String pUser,
                    java.lang.String pProject,
                    java.lang.String pScenario)
             throws java.lang.Exception

Throws:

java.lang.Exception

getSomeId

public int getSomeId(java.lang.String pTable,
                     java.lang.String pName)
              throws java.lang.Exception

Throws:

java.lang.Exception

getIdByRunid

public int getIdByRunid(java.lang.String pTable,
                        java.lang.String pName,
                        int pRunid)
                 throws java.lang.Exception

Throws:

java.lang.Exception

saveRegions

public void saveRegions(int pRunid,
                        java.util.TreeSet<java.lang.String> pSet)
                 throws java.lang.Exception

Throws:

java.lang.Exception

saveSomethingByRunid

public void saveSomethingByRunid(int pRunid,
                                 java.lang.String pTable,
                                 java.util.TreeSet<java.lang.String> pSet)
                          throws java.lang.Exception

Throws:

java.lang.Exception

saveEntities

public void saveEntities(int pRunid,
                         java.util.TreeSet<java.lang.String> pSet)
                  throws java.lang.Exception

Throws:

java.lang.Exception

savePeriods

public void savePeriods(int pRunid,
                        java.util.TreeSet<java.lang.Integer> pSet)
                 throws java.lang.Exception

Throws:

java.lang.Exception

saveTecActs

public void saveTecActs(int pRunid,
                        java.util.TreeSet<java.lang.String> pSet)
                 throws java.lang.Exception

Throws:

java.lang.Exception

savePardata

public void savePardata(int pRunid,
                        java.util.TreeMap<java.lang.String,java.util.TreeMap<java.lang.Integer,java.lang.Double>> pData)
                 throws java.lang.Exception

Throws:

java.lang.Exception

savePardata2

public void savePardata2(int pRunid,
                         java.lang.String pColnames,
                         java.util.TreeMap<java.lang.String,java.util.TreeMap<java.lang.Integer,java.lang.Double>> pData)
                  throws java.lang.Exception

version with n-period data columns

Parameters:

pRunid -

pData -

Throws:

java.lang.Exception

cleanupById

public void cleanupById(int pRunid)
                 throws java.lang.Exception

Throws:

java.lang.Exception

queryCase

public void queryCase(java.lang.String pProject,
                      java.lang.String pScenario)
               throws java.lang.Exception

Throws:

java.lang.Exception

copyCaseOld

public void copyCaseOld(java.lang.String pSrcProject,
                        java.lang.String pSrcScenario,
                        java.lang.String pTgtProject,
                        java.lang.String pTgtScenario)
                 throws java.lang.Exception

Throws:

java.lang.Exception

updateCreate

public void updateCreate(java.lang.String pUser,
                         int pRunid)
                  throws java.lang.Exception

Throws:

java.lang.Exception

updateUpdate

public void updateUpdate(java.lang.String pUser,
                         int pRunid)
                  throws java.lang.Exception

Throws:

java.lang.Exception

copyCaCase

public void copyCaCase(java.lang.String pUser,
                       java.lang.String pSrcProject,
                       java.lang.String pSrcScenario,
                       java.lang.String pTgtProject,
                       java.lang.String pTgtScenario)
                throws java.lang.Exception

Throws:

java.lang.Exception