public static void Main(string[] args)
{
TCmdOpts cmdLine = new TCmdOpts();
string operation, xmlfile, outputfile;
new TAppSettingsManager(false);
new TLogging(System.IO.Path.GetDirectoryName(Environment.GetCommandLineArgs()[0]) + "/../../log/generatesql.log");
try
{
operation = cmdLine.GetOptValue("do");
xmlfile = cmdLine.GetOptValue("petraxml");
outputfile = cmdLine.GetOptValue("outputFile");
TWriteSQL.eDatabaseType dbms = TWriteSQL.StringToDBMS(cmdLine.GetOptValue("dbms"));
if (operation == "sql")
{
System.Console.WriteLine("Reading xml file {0}...", xmlfile);
TDataDefinitionParser parser = new TDataDefinitionParser(xmlfile);
TDataDefinitionStore store = new TDataDefinitionStore();
if (parser.ParseDocument(ref store))
{
// create an sql script that will be loaded into the database later
TWriteSQL.WriteSQL(store, dbms, outputfile);
}
}
if (operation == "load")
{
if (dbms == TWriteSQL.eDatabaseType.MySQL)
{
System.Console.WriteLine("Reading xml file {0}...", xmlfile);
TDataDefinitionParser parser = new TDataDefinitionParser(xmlfile);
TDataDefinitionStore store = new TDataDefinitionStore();
if (parser.ParseDocument(ref store))
{
// we want to write directly to the database
TLoadMysql.ExecuteLoadScript(store, cmdLine.GetOptValue("host"), cmdLine.GetOptValue("database"), cmdLine.GetOptValue("username"),
cmdLine.GetOptValue("password"), cmdLine.GetOptValue("sqlfile"));
}
}
}
}
catch (Exception e)
{
System.Console.WriteLine("Error " + e.GetType().ToString() + ": " + e.Message);
System.Console.WriteLine(e.StackTrace);
System.Console.WriteLine();
System.Console.WriteLine("generate the SQL files to create the database in SQL");
System.Console.WriteLine(
"usage: GenerateSQL -do:<operation> -dbms:<type of database system> -petraxml:<path and filename of petra.xml> -outputFile:<path and filename of the output file>");
System.Console.WriteLine("operations available:");
System.Console.WriteLine(" sql ");
System.Console.WriteLine(" sample call: ");
System.Console.WriteLine(
" GenerateSQL -do:sql -dbms:postgresql -petraxml:u:/sql/datadefinition/petra.xml -outputFile:U:/setup/petra0300/petra.sql");
System.Console.WriteLine("Available database managment systems and their code:");
System.Console.WriteLine(" mysql (recommended)");
System.Console.WriteLine(" postgresql (supported)");
System.Environment.Exit(-1);
}
}
public static void Main(string[] args)
{
TCmdOpts cmdLine = new TCmdOpts();
string operation, xmlfile, outputfile;
try
{
operation = cmdLine.GetOptValue("do");
xmlfile = cmdLine.GetOptValue("petraxml");
outputfile = cmdLine.GetOptValue("outputFile");
TWriteSQL.eDatabaseType dbms = TWriteSQL.StringToDBMS(cmdLine.GetOptValue("dbms"));
if (operation == "sql")
{
System.Console.WriteLine("Reading xml file {0}...", xmlfile);
TDataDefinitionParser parser = new TDataDefinitionParser(xmlfile);
TDataDefinitionStore store = new TDataDefinitionStore();
if (parser.ParseDocument(ref store))
{
if (dbms == TWriteSQL.eDatabaseType.Sqlite)
{
// we want to write directly to the database
string password = "";
if (cmdLine.IsFlagSet("password"))
{
password = cmdLine.GetOptValue("password");
}
if (!TSQLiteWriter.CreateDatabase(store, outputfile, password))
{
Environment.Exit(-1);
}
}
else
{
// create an sql script that will be loaded into the database later
TWriteSQL.WriteSQL(store, dbms, outputfile);
}
}
}
if (operation == "load")
{
if (dbms == TWriteSQL.eDatabaseType.MySQL)
{
TLoadMysql.LoadData(cmdLine.GetOptValue("database"), cmdLine.GetOptValue("username"),
cmdLine.GetOptValue("password"), cmdLine.GetOptValue("sqlfile"));
}
else if (dbms == TWriteSQL.eDatabaseType.Sqlite)
{
System.Console.WriteLine("Reading xml file {0}...", xmlfile);
TDataDefinitionParser parser = new TDataDefinitionParser(xmlfile);
TDataDefinitionStore store = new TDataDefinitionStore();
if (parser.ParseDocument(ref store))
{
if (dbms == TWriteSQL.eDatabaseType.Sqlite)
{
// we want to write directly to the database
string password = "";
if (cmdLine.IsFlagSet("password"))
{
password = cmdLine.GetOptValue("password");
}
TSQLiteWriter.ExecuteLoadScript(store, outputfile,
cmdLine.GetOptValue("datapath"),
cmdLine.GetOptValue("sqlfile"),
password);
}
}
}
}
}
catch (Exception e)
{
System.Console.WriteLine("Error " + e.GetType().ToString() + ": " + e.Message);
System.Console.WriteLine(e.StackTrace);
System.Console.WriteLine();
System.Console.WriteLine("generate the SQL files to create the database in SQL");
System.Console.WriteLine(
"usage: GenerateSQL -do:<operation> -dbms:<type of database system> -petraxml:<path and filename of petra.xml> -outputFile:<path and filename of the output file>");
System.Console.WriteLine("operations available:");
System.Console.WriteLine(" sql ");
System.Console.WriteLine(" sample call: ");
System.Console.WriteLine(
" GenerateSQL -do:sql -dbms:postgresql -petraxml:u:/sql/datadefinition/petra.xml -outputFile:U:/setup/petra0300/petra.sql");
System.Console.WriteLine("Available database managment systems and their code:");
System.Console.WriteLine(" postgresql (Recommended)");
System.Console.WriteLine(" mysql (experimental)");
System.Console.WriteLine(" sqlite (for the light version)");
System.Environment.Exit(-1);
}
}
