public void convertAllTable(DataBase sourceDB, DBUser suser,
DataBase targetDB, DBUser tuser, DataFilter filter)
throws Exception
{
List<SqlRecord> records = null;
String userName = suser.getUserName();
records = filter.getSqls();
Connection sconn = sourceDB.getConn(suser.getUserName(), suser
.getPassword());
Connection tconn = targetDB.getConn(tuser.getUserName(), tuser
.getPassword());
sconn.setAutoCommit(true);
tconn.setAutoCommit(true);
for (SqlRecord record : records)
{
String tableName = record.getTableName();
record.setUser(suser.getUserName());
if (DataConvertor.user_TableMap.get(userName).contains(tableName))
{
// System.out.println("user:"+userName+" table:"+tableName);
convertAllTable(sourceDB, sconn, tconn, record);
}
}
}
public void convertSequence(DataBase sourceDB, DBUser suser,
DataBase targetDB, DBUser tuser)
{
Connection sconn = sourceDB.getConn(suser.getUserName(), suser
.getPassword());
Connection tconn = targetDB.getConn(tuser.getUserName(), tuser
.getPassword());
try
{
convertSeque(sconn, tconn);
} catch (Exception e1)
{
e1.printStackTrace();
}
}
/**
* @param originDB
* @param user
* @param targetDB
* @param user2
* @param filter
*/
public void convertAllViews(DataBase originDB, DBUser user,
DataBase targetDB, DBUser user2, DataFilter filter)
{
// TODO Auto-generated method stub
}
DataBase targetDB, DBUser tuser, DataFilter filter)
throws Exception
{
List<SqlRecord> records = null;
String userName = suser.getUserName();
records = filter.getSqls();
Connection sconn = sourceDB.getConn(suser.getUserName(), suser
.getPassword());
Connection tconn = targetDB.getConn(tuser.getUserName(), tuser
.getPassword());
sconn.setAutoCommit(true);
tconn.setAutoCommit(true);
for (SqlRecord record : records)
{
String tableName = record.getTableName();
record.setUser(suser.getUserName());
if (DataConvertor.user_TableMap.get(userName).contains(tableName))
{
// System.out.println("user:"+userName+" table:"+tableName);
convertAllTable(sourceDB, sconn, tconn, record);
}
}
}
public void convertSequence(DataBase sourceDB, DBUser suser,
DataBase targetDB, DBUser tuser)
{
Connection sconn = sourceDB.getConn(suser.getUserName(), suser
.getPassword());
Connection tconn = targetDB.getConn(tuser.getUserName(), tuser
.getPassword());
try
{
convertSeque(sconn, tconn);
} catch (Exception e1)
{
e1.printStackTrace();
}
}
/**
* @param originDB
* @param user
* @param targetDB
* @param user2
* @param filter
*/
public void convertAllViews(DataBase originDB, DBUser user,
DataBase targetDB, DBUser user2, DataFilter filter)
{
// TODO Auto-generated method stub
}