private void describeMenu_Click(object sender, EventArgs e)
{
ssh.Connect();
DescribeOutput descOutput = ssh.Describe(listBox1.SelectedItem.ToString());
DataTable dtDescribe = new DataTable();
dtDescribe.Columns.Add("Name");
dtDescribe.Columns.Add("Type");
dtDescribe.Columns.Add("Modifiers");
dtDescribe.Columns.Add("Primary Key");
foreach (DBColumn column in descOutput.Columns)
{
DataRow r = dtDescribe.NewRow();
r["Name"] = column.ColumnName;
r["Type"] = column.Type;
r["Modifiers"] = column.Modifiers;
r["Primary Key"] = column.IsPrimaryKey ? "X" : "";
dtDescribe.Rows.Add(r);
}
describeTable.DataSource = dtDescribe;
ssh.Disconnect();
}
private List <DBColumn> GetMissingColumn(string table,
SshDbWrapper sourceConnection,
SshDbWrapper destinationConnection)
{
DescribeOutput sourceTabDescription = sourceConnection.Describe(table);
DescribeOutput destinationTabDescription = destinationConnection.Describe(table);
List <DBColumn> missingColumns = new List <DBColumn>();
foreach (DBColumn col in sourceTabDescription.Columns)
{
if (!ExistColumn(destinationTabDescription, col))
{
missingColumns.Add(col);
}
}
return(missingColumns);
}
