public bool copyCreationTable(MysqlHandler connection, string sourceTable, MysqlHandler targetConnection)
{
bool disconnecting = false;
bool targetDisconnecting = false;
if (!connection.isConnected())
{
disconnecting = true;
connection.connect();
}
if (!targetConnection.isConnected())
{
targetDisconnecting = true;
targetConnection.connect();
}
string createSql = connection.getTableCreationString(sourceTable);
if (createSql != "")
{
targetConnection.sql_update(createSql);
}
if (disconnecting)
{
connection.disConnect();
}
if (targetDisconnecting)
{
targetConnection.disConnect();
}
targetConnection.resetTableList();
return(targetConnection.tableExists(sourceTable));
}
public void copyTable(MysqlHandler connection, string sourceTable, MysqlHandler targetConnection)
{
bool disconnecting = false;
bool targetDisconnecting = false;
if (!connection.isConnected())
{
disconnecting = true;
connection.connect();
}
if (!targetConnection.isConnected())
{
targetDisconnecting = true;
targetConnection.connect();
}
targetConnection.lastSqlErrorMessage = "";
if (!targetConnection.tableExists(sourceTable))
{
string createSql = connection.getTableCreationString(sourceTable);
targetConnection.sql_update(createSql);
if (targetConnection.lastSqlErrorMessage.Length > 0)
{
MessageBox.Show(createSql + "\n\n" + targetConnection.lastSqlErrorMessage);
targetConnection.lastSqlErrorMessage = "";
}
else
{
copyRows(connection, sourceTable, targetConnection);
}
}
if (disconnecting)
{
connection.disConnect();
}
if (targetDisconnecting)
{
targetConnection.disConnect();
}
targetConnection.resetTableList();
}
public String alterTableFromSource(MysqlHandler connection, string sourceTable, MysqlHandler targetConnection, Boolean addOnly)
{
bool disconnecting = false;
bool targetDisconnecting = false;
if (!connection.isConnected())
{
disconnecting = true;
connection.connect();
}
if (!targetConnection.isConnected())
{
targetDisconnecting = true;
targetConnection.connect();
}
string createSql = connection.getTableCreationString(sourceTable);
List <MysqlStruct> sourceStruct = connection.getAllFieldsStruct(sourceTable);
List <MysqlStruct> targetStruct = targetConnection.getAllFieldsStruct(sourceTable);
String alterSql = getAlterTableSql(sourceStruct, targetStruct, addOnly);
if (alterSql.Length > 0)
{
alterSql = "ALTER TABLE `" + sourceTable + "` " + alterSql;
}
if (disconnecting)
{
connection.disConnect();
}
if (targetDisconnecting)
{
targetConnection.disConnect();
}
targetConnection.resetTableList();
return(alterSql);
}
