//JAVA TO C# CONVERTER WARNING: Method 'throws' clauses are not available in C#:
//ORIGINAL LINE: public static void moveDataNotSameInstanceAppendProjects(nomitech.common.ui.UIProgress paramUIProgress, nomitech.common.ProjectDBUtil paramProjectDBUtil1, nomitech.common.ProjectDBUtil paramProjectDBUtil2) throws Exception
public static void moveDataNotSameInstanceAppendProjects(UIProgress paramUIProgress, ProjectDBUtil paramProjectDBUtil1, ProjectDBUtil paramProjectDBUtil2)
{
ProjectUrlTable projectUrlTable = paramProjectDBUtil2.ProjectUrl;
if (projectUrlTable.ProjectUrlId == null)
{
projectUrlTable.ProjectUrlId = Convert.ToInt64(DateTimeHelper.CurrentUnixTimeMillis());
}
ProjectDBDataMover projectDBDataMover = new ProjectDBDataMover(paramUIProgress, paramProjectDBUtil1.ProjectUrl, paramProjectDBUtil2.ProjectUrl);
if (paramProjectDBUtil1 is nomitech.common.ProjectFileDBUtil)
{
projectDBDataMover.sourceConnection = paramProjectDBUtil1.createJdbcConnection();
projectDBDataMover.sourceConnection.AutoCommit = false;
}
if (paramProjectDBUtil2 is nomitech.common.ProjectFileDBUtil)
{
projectDBDataMover.destConnection = paramProjectDBUtil2.createJdbcConnection();
projectDBDataMover.destConnection.AutoCommit = false;
}
projectDBDataMover.moveDataNotSameInstanceAppendProjects();
}
//JAVA TO C# CONVERTER WARNING: Method 'throws' clauses are not available in C#:
//ORIGINAL LINE: public static void mergeProjectsInOneDatabase(nomitech.common.ui.UIProgress paramUIProgress, String paramString1, String paramString2, String paramString3, nomitech.common.db.local.ProjectDbmsTable paramProjectDbmsTable, String paramString4, String paramString5, java.util.Set<String> paramSet, boolean paramBoolean1, boolean paramBoolean2) throws Exception
public static void mergeProjectsInOneDatabase(UIProgress paramUIProgress, string paramString1, string paramString2, string paramString3, ProjectDbmsTable paramProjectDbmsTable, string paramString4, string paramString5, ISet <string> paramSet, bool paramBoolean1, bool paramBoolean2)
{
ProjectDBUtil.initDriver(ProjectDBUtil.SQLSERVER_DBMS);
ProjectDBDataMover projectDBDataMover;
(projectDBDataMover = new ProjectDBDataMover(paramUIProgress)).setProgress(paramUIProgress, "Connecting to master database " + paramString1 + " port " + paramString2 + "...");
string str = ProjectDBUtil.createJdbcUrl(paramString1, paramString3, paramString2, ProjectDBUtil.SQLSERVER_DBMS);
Connection connection1 = DriverManager.getConnection(str + ";useLOBs=false", paramString4, paramString5);
connection1.AutoCommit = false;
setProgress(paramUIProgress, "Connecting to project database " + paramString1 + " port " + paramString2 + "...");
str = ProjectDBUtil.createJdbcUrl(paramProjectDbmsTable.HostName, paramProjectDbmsTable.DatabaseName, paramProjectDbmsTable.HostPort, ProjectDBUtil.SQLSERVER_DBMS);
Connection connection2 = projectDBDataMover.loginDatabase(str + ";useLOBs=false", paramString4, paramString5);
connection2.AutoCommit = false;
setProgress(paramUIProgress, "Loading databases from master...");
System.Collections.IList list = projectDBDataMover.getAllProjectUrls(connection1, paramSet, false);
ProjectUrlTable projectUrlTable = new ProjectUrlTable();
projectUrlTable.Dbms = Convert.ToInt32(ProjectDBUtil.SQLSERVER_DBMS);
projectUrlTable.DatabaseName = paramProjectDbmsTable.DatabaseName;
projectUrlTable.Hostname = paramProjectDbmsTable.HostName;
projectUrlTable.Port = paramProjectDbmsTable.HostPort;
projectUrlTable.DbmsName = paramProjectDbmsTable.InstanceName;
projectUrlTable.CreatesNewDatabases = Convert.ToBoolean(false);
projectUrlTable.Username = paramProjectDbmsTable.HostUsername;
projectUrlTable.Password = paramProjectDbmsTable.HostPassword;
projectUrlTable.Url = str;
setProgress(paramUIProgress, "Processing " + list.Count + " databases...");
System.Collections.ICollection collection = projectDBDataMover.filterOutUrlsAlreadyInTarget(connection2, list);
connection2.close();
setProgress(paramUIProgress, "Target Database is " + projectUrlTable.DatabaseName + " and " + collection.Count + " will be processed...");
foreach (ProjectUrlTable projectUrlTable1 in collection)
{
if (projectUrlTable1.DatabaseName.Equals(projectUrlTable.DatabaseName, StringComparison.OrdinalIgnoreCase))
{
continue;
}
projectUrlTable.ProjectUrlId = projectUrlTable1.ProjectUrlId;
setProgress(paramUIProgress, "\nMerging Database: " + projectUrlTable1.DatabaseName + ", Project ID: " + projectUrlTable1.Id + ", Name: " + projectUrlTable1.Name + " ...");
try
{
if (projectUrlTable1.Dbms == projectUrlTable.Dbms && projectUrlTable1.Hostname.Equals(projectUrlTable.Hostname))
{
projectDBDataMover.initialize(projectUrlTable1, projectUrlTable);
projectDBDataMover.moveDataSameInstance();
}
else
{
projectDBDataMover.initialize(projectUrlTable1, projectUrlTable);
projectDBDataMover.moveDataNotSameInstance();
}
projectDBDataMover.executeUpdateQuery(connection1, "UPDATE PROJECTURL SET DBSINGLE=0, DBNAME= '" + projectUrlTable.DatabaseName + "', DBSRV = " + projectUrlTable.Dbms + ", DBSRVNAME= '" + projectUrlTable.DbmsName + "', DBUSR= '******', DBPSWD= '" + projectUrlTable.Password + "', URL = '" + projectUrlTable.Url + "' WHERE PROJECTURLID=" + projectUrlTable.ProjectUrlId);
setProgress(paramUIProgress, "Done");
}
catch (Exception exception)
{
Console.WriteLine("Could not merge " + projectUrlTable1.DatabaseName + " to " + projectUrlTable.DatabaseName);
Console.WriteLine(exception.ToString());
Console.Write(exception.StackTrace);
}
if (paramBoolean2 && projectUrlTable1.Dbms.Value == ProjectDBUtil.SQLSERVER_DBMS)
{
try
{
setProgress(paramUIProgress, "Dropping " + projectUrlTable1.DatabaseName + " ...");
projectDBDataMover.executeUpdateQuery(connection1, "DROP DATABASE [" + projectUrlTable1.DatabaseName + "]");
setProgress(paramUIProgress, "Done");
}
catch (Exception)
{
Console.WriteLine("Could not drop " + projectUrlTable1.DatabaseName);
}
}
}
connection1.close();
}
//JAVA TO C# CONVERTER WARNING: Method 'throws' clauses are not available in C#:
//ORIGINAL LINE: public static void moveDataSameInstanceAppendProjects(nomitech.common.ui.UIProgress paramUIProgress, nomitech.common.db.local.ProjectUrlTable paramProjectUrlTable1, nomitech.common.db.local.ProjectUrlTable paramProjectUrlTable2) throws Exception
public static void moveDataSameInstanceAppendProjects(UIProgress paramUIProgress, ProjectUrlTable paramProjectUrlTable1, ProjectUrlTable paramProjectUrlTable2)
{
ProjectDBDataMover projectDBDataMover = new ProjectDBDataMover(paramUIProgress, paramProjectUrlTable1, paramProjectUrlTable2);
projectDBDataMover.moveDataSameInstanceAppendProjects();
}
