public void testViews()
{
DBStringBuilder oracleSQL = new DBStringBuilder(DBType.OracleSQL, "db2.htl-kaindorf.at", "1521", "", "hofmad16", "Manuelh0");
OracleSQLConnection oracleS = OracleSQLConnection.getConnection();
oracleS.connectionString = oracleSQL;
oracleS.OpenConnection();
List <ConstraintInfo> llist = oracleS.getConstraintsFromTable("EMP");
foreach (ConstraintInfo l in llist)
{
Console.Out.WriteLine(l.constraintName + ", " + l.Condition + ", " + l.constraintType.ToString());
}
oracleS.CloseConnection();
}
public void migrateTables(OracleSQLConnection os, MSSQLConnection ms, CUBRIDConnection cs)
{
String cols = "";
if (ms == null)
{
tables = os.GetAllTables();
}
else
{
tables = ms.getTables();
}
for (int i = 0; i < tables.Count; i++)
{
cols = "";
//MessageBox.Show(cols);
if (ms == null)
{
infos = os.getInfo(tables[i]);
}
else
{
infos = ms.getInfo(tables[i]);
}
pks = "";
for (int j = 0; j < infos.Count; j++)
{
// MessageBox.Show(cols);
String name = infos[j].columnname;
String type = infos[j].datatype + "";
if (type == DataType.NUMBER + "")
{
type = "numeric";
}
Boolean nullable = infos[j].nullable;
Boolean pk = infos[j].isPrimaryKey;
if (pk)
{
pks += "[" + name + "],";
cols += "[" + name + "] " + type + ",";
}
else
{
if (!nullable)
{
cols += "[" + name + "] " + type + " not null " + ",";
}
else
{
cols += "[" + name + "] " + type + ",";
}
}
// MessageBox.Show(cols);
}
if (pks.Length == 0)
{
insert = "Create Table [" + tables[i] + "]( " + cols.Substring(0, cols.Length - 1) +
");\n";
}
if (pks.Length > 0)
{
insert = "Create Table [" + tables[i] + "]( " + cols + "Primary key (" +
pks.Substring(0, pks.Length - 1) + ")" + ");\n";
}
try
{
// MessageBox.Show(insert);
CUBRIDCommand cmd = new CUBRIDCommand(insert, cs);
cmd.ExecuteNonQuery();
gettableData(tables[i] + "", ms, os, cs);
}
catch (Exception e)
{
if ((e + "").Contains("OBJECT"))
{
int index = insert.IndexOf("[");
String substring1 = insert.Substring(index + 1);
String substring2 = insert.Substring(0, 14);
insert = substring2 + "_" + substring1;
CUBRIDCommand cmd = new CUBRIDCommand(insert, cs);
cmd.ExecuteNonQuery();
}
else
{
MessageBox.Show(e + "");
}
gettableData(tables[i] + "", ms, os, cs);
}
pks = "";
cols = "";
}
for (int i = 0; i < tables.Count; i++)
{
if (ms == null)
{
constraints = os.getConstraintsFromTable(tables[i]);
}
else
{
constraints = ms.getConstraintsFromTable(tables[i]);
// MessageBox.Show(tables[i] + " - " + constraints.Count);
}
for (int j = 0; j < constraints.Count; j++)
{
if (!tables[i].ToLower().Equals("object") && !constraints[j].FKtableName.ToLower().Equals("object"))
{
if ((constraints[j].constraintType + "").Equals("ForeignKey"))
{
String stat = "Alter table [" + tables[i] + "] add foreign key(" +
constraints[j].columnName +
")" +
" references [" + constraints[j].FKtableName + "](" +
constraints[j].FKcolumnName + ");\n";
altertablestatement += stat;
}
else if ((constraints[j].constraintType + "").Contains("Unique"))
{
if (os != null)
{
}
else
{
String stat = "Alter table [" + tables[i] + "] add unique(" +
constraints[j].columnName +
");";
// altertablestatement += stat;
}
}
else
{
String stat = "Alter table [" + tables[i] + "] add constraint " +
constraints[j].constraintName + " check (" + constraints[j].Condition +
");";
altertablestatement += stat;
// MessageBox.Show(altertablestatement);
}
}
}
}
//addViews(ms,os,cs);
// MessageBox.Show(insert);
// MessageBox.Show(altertablestatement);
try
{
// MessageBox.Show(altertablestatement);
CUBRIDCommand cmd2 = new CUBRIDCommand(altertablestatement, cs);
cmd2.ExecuteNonQuery();
addViews(ms, os, cs);
addSeq(ms, os, cs);
}
catch (Exception e)
{
if (e.Message.Contains("already defined"))
{
MessageBox.Show(e.Message);
altertablestatement = "";
}
else
{
MessageBox.Show(e + "");
}
}
}