public void GenerateScript()
{
LoadData();
var tables = data.Select(x => x.table_name).Distinct().ToList();
MyConn conn;
foreach (string table in tables)
{
query += "\nTable " + table + " {";
var columns = data.Where(x => x.table_name == table).ToList();
foreach (var column in columns)
{
query += "\n" + column.column_name;
switch (column.type_name)
{
case "nvarchar": query += " varchar"; break;
case "datetime2": query += " datetime"; break;
default: query += " " + column.type_name; break;
}
if (column.is_key)
{
query += " [pk]";
}
}
query += "\n}";
conn = new MyConn();
conn.OnRead += Conn_OnRead1;
conn.ExecQuery(MySchm.getForeignKeys(table));
}
System.IO.File.WriteAllText("script.txt", query + foreignKeys);
Console.ReadLine();
}
private void Conn_OnRead(object sender, System.Data.SqlClient.SqlDataReader reader)
{
MySchm structure = new MySchm();
structure.column_name = reader["column_name"].ToString();
structure.table_name = reader["table_name"].ToString();
structure.type_name = reader["type_name"].ToString();
structure.is_identity = (bool)reader["is_identity"];
structure.is_nullable = (bool)reader["is_nullable"];
structure.is_key = (bool)reader["is_key"];
data.Add(structure);
}
public void GenerateScript()
{
LoadData();
var tables = data.Select(x => x.table_name).Distinct().ToList();
MyConn conn;
foreach (string table in tables)
{
query += "\ncreate table " + table + " (";
var columns = data.Where(x => x.table_name == table).ToList();
int counter = 0;
foreach (var column in columns)
{
query += "\n" + column.column_name;
counter += 1;
switch (column.type_name)
{
case "nvarchar": query += " varchar(50)"; break;
case "datetime2": query += " datetime"; break;
case "int": query += " number(10)"; break;
case "bit": query += " boolean"; break;
default: query += " " + column.type_name; break;
}
if (column.is_key)
{
query += " primary key";
}
if (!column.is_nullable)
{
query += " not null";
}
if (counter != columns.Count)
{
query += ",";
}
}
query += "\n);";
conn = new MyConn();
conn.OnRead += Conn_OnRead1;
conn.ExecQuery(MySchm.getForeignKeys(table));
}
System.IO.File.WriteAllText("script.txt", query + foreignKeys);
Console.ReadLine();
}
