/// <summary>
/// load test data written in PostgreSQL syntax into MySQL
/// </summary>
private static void LoadTestDataMySQL(string fileName)
{
// parse the sql file, and for each table (are there multiple???) load the data
string sqlfileContent = LoadCSVFileToString(fileName);
string[] lines = sqlfileContent.Split(new char[] { '\n' });
string currenttable = string.Empty;
string sqlStmt = string.Empty;
TDataDefinitionParser parser = new TDataDefinitionParser(rootPath + Path.DirectorySeparatorChar + "db" + Path.DirectorySeparatorChar + "petra.xml");
TDataDefinitionStore store = new TDataDefinitionStore();
TTable table = null;
if (!parser.ParseDocument(ref store))
{
throw new Exception("failed to parse petra.xml");
}
TDBTransaction LoadTransaction = new TDBTransaction();
TDataBase db = DBAccess.Connect("LoadTestDataMySQL");
bool SubmissionOK = false;
db.WriteTransaction(ref LoadTransaction,
ref SubmissionOK,
delegate
{
foreach (string line in lines)
{
if (line.StartsWith("--") || (line.Trim() == String.Empty))
{
continue;
}
else if (line.StartsWith("COPY "))
{
currenttable = line.Substring("COPY ".Length, line.IndexOf("(") - "COPY ".Length - 1);
table = store.GetTable(currenttable);
sqlStmt = table.PrepareSQLInsertStatement();
}
else if (line == "\\.")
{
currenttable = String.Empty;
}
else if (currenttable != String.Empty)
{
List <OdbcParameter> Parameters = table.PrepareParametersInsertStatement(line);
if (db.ExecuteNonQuery(sqlStmt, LoadTransaction, Parameters.ToArray()) == 0)
{
throw new Exception("failed to import line for table " + currenttable);
}
}
}
SubmissionOK = true;
});
}
/// <summary>
/// create a Progress .p program for dumping the Progress data to CSV files
/// </summary>
public void GenerateFulldumpCode()
{
string PetraOldPath = TAppSettingsManager.GetValue("oldpetraxml", "petra23.xml");
TDataDefinitionParser parserOld = new TDataDefinitionParser(PetraOldPath);
parserOld.SupportPetra2xLegacyStandard = true;
storeOld = new TDataDefinitionStore();
System.Console.WriteLine("Reading 2.x xml file {0}...", PetraOldPath);
if (!parserOld.ParseDocument(ref storeOld, false, true))
{
return;
}
string OutputFile = "fulldump23.p";
System.Console.WriteLine("Writing file to {0}...", OutputFile);
StreamWriter progressWriter = new StreamWriter(OutputFile);
// print file header
progressWriter.WriteLine("/* Generated with Ict.Tools.DataDumpPetra2x.exe */");
System.Resources.ResourceManager RM = new System.Resources.ResourceManager("Ict.Tools.DataDumpPetra2.templateCode",
System.Reflection.Assembly.GetExecutingAssembly());
progressWriter.WriteLine(RM.GetString("progress_dump_functions"));
progressWriter.WriteLine();
List <TTable> oldTables = storeOld.GetTables();
foreach (TTable oldTable in oldTables)
{
DumpTable(ref progressWriter, oldTable);
}
DumpSequences(ref progressWriter);
progressWriter.WriteLine();
progressWriter.Close();
System.Console.WriteLine("Success: file written: {0}", Path.GetFullPath(OutputFile));
}
/// <summary>
/// get the data structure for the new version
/// </summary>
public static TDataDefinitionStore GetStoreNew()
{
if (storeNew == null)
{
string PetraNewPath = TAppSettingsManager.GetValue("newpetraxml", "petra.xml");
TLogging.Log(String.Format("Reading OpenPetra xml file {0}...", PetraNewPath));
TDataDefinitionParser parserNew = new TDataDefinitionParser(PetraNewPath, false);
storeNew = new TDataDefinitionStore();
if (!parserNew.ParseDocument(ref storeNew, false, true))
{
return(null);
}
}
return(storeNew);
}
/// <summary>
/// get the data structure for the version that should be upgraded
/// </summary>
public static TDataDefinitionStore GetStoreOld()
{
if (storeOld == null)
{
string PetraOldPath = TAppSettingsManager.GetValue("oldpetraxml", "petra23.xml");
TLogging.Log(String.Format("Reading 2.x xml file {0}...", PetraOldPath));
TDataDefinitionParser parserOld = new TDataDefinitionParser(PetraOldPath);
storeOld = new TDataDefinitionStore();
parserOld.SupportPetra2xLegacyStandard = true;
if (!parserOld.ParseDocument(ref storeOld, false, true))
{
return(null);
}
}
return(storeOld);
}
public static void Main(string[] args)
{
new TAppSettingsManager(false);
//enable execution without nant -> debugging easier
bool independentmode = false;
if (independentmode)
{
TLogging.Log("started in independent-mode");
}
try
{
if ((TAppSettingsManager.HasValue("do") && (TAppSettingsManager.GetValue("do") == "removeDoNotTranslate")) || independentmode)
{
string doNotTranslatePath;
string poFilePath;
if (independentmode)
{
doNotTranslatePath = "E:\\openpetra\\bzr\\work-690\\i18n\\doNotTranslate.po";
poFilePath = "E:\\openpetra\\bzr\\work-690\\i18n\\template.pot";
}
else
{
doNotTranslatePath = TAppSettingsManager.GetValue("dntFile");
poFilePath = TAppSettingsManager.GetValue("poFile");
}
// remove all strings from po file that are listed in the "Do Not Translate" file
TDropUnwantedStrings.RemoveUnwantedStringsFromTranslation(doNotTranslatePath, poFilePath);
}
else if (TAppSettingsManager.HasValue("do") && (TAppSettingsManager.GetValue("do") == "errorcodedoc"))
{
TGenerateErrorCodeDoc.Execute(TAppSettingsManager.GetValue("csharppath"),
TAppSettingsManager.GetValue("templatefilepath"),
TAppSettingsManager.GetValue("outfilepath"));
}
else if (TAppSettingsManager.HasValue("do") && (TAppSettingsManager.GetValue("do") == "yamlfiles"))
{
GenerateYamlFiles.WriteYamlFiles(
TAppSettingsManager.GetValue("language"),
TAppSettingsManager.GetValue("path"),
TAppSettingsManager.GetValue("pofile"));
}
else if (TAppSettingsManager.HasValue("file"))
{
TGenerateCatalogStrings.Execute(TAppSettingsManager.GetValue("file"), null, null);
}
else if (TAppSettingsManager.HasValue("filelist"))
{
TDataDefinitionStore store = new TDataDefinitionStore();
Console.WriteLine("parsing " + TAppSettingsManager.GetValue("petraxml", true));
TDataDefinitionParser parser = new TDataDefinitionParser(TAppSettingsManager.GetValue("petraxml", true));
parser.ParseDocument(ref store, true, true);
string CollectedStringsFilename = TAppSettingsManager.GetValue("tmpPath") +
Path.DirectorySeparatorChar +
"GenerateI18N.CollectedGettext.cs";
StreamWriter writerCollectedStringsFile = new StreamWriter(CollectedStringsFilename);
string GettextApp = TAppSettingsManager.GetValue("gettext");
string filesToParseWithGettext = string.Empty;
StreamReader readerFilelist = new StreamReader(TAppSettingsManager.GetValue("filelist"));
while (!readerFilelist.EndOfStream)
{
string pathCodeFile = readerFilelist.ReadLine().Trim();
string ext = Path.GetExtension(pathCodeFile);
if (".cs" == ext)
{
if (TGenerateCatalogStrings.Execute(pathCodeFile, store, writerCollectedStringsFile))
{
filesToParseWithGettext += "\"" + pathCodeFile + "\" ";
if (filesToParseWithGettext.Length > 1500)
{
ParseWithGettext(GettextApp, TAppSettingsManager.GetValue("poFile"), filesToParseWithGettext);
filesToParseWithGettext = string.Empty;
}
}
}
else if (".yml" == ext)
{
TGenerateCatalogStrings.AddTranslationUINavigation(pathCodeFile, writerCollectedStringsFile);
}
else
{
Console.WriteLine("the file " + pathCodeFile + " has an unknown extension! File ignored!");
}
}
if (filesToParseWithGettext.Length > 0)
{
ParseWithGettext(GettextApp, TAppSettingsManager.GetValue("poFile"), filesToParseWithGettext);
}
writerCollectedStringsFile.Close();
// delete the file if it is empty
if (File.ReadAllText(CollectedStringsFilename).Length == 0)
{
File.Delete(CollectedStringsFilename);
}
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
Console.WriteLine(e.StackTrace);
Environment.Exit(-1);
}
}
public static void Main(string[] args)
{
new TLogging("delivery/bin/Ict.Tools.DataMigrateStatistics.log");
new TAppSettingsManager(false);
string row_count_location = TAppSettingsManager.GetValue("fulldumpPath", "delivery/bin/fulldump") +
Path.DirectorySeparatorChar + "_row_count.txt";
if (File.Exists(row_count_location))
{
DBAccess.GDBAccessObj = new TDataBase();
TCmdOpts cmdLine = new TCmdOpts();
string xmlfile = cmdLine.GetOptValue("petraxml");
DBAccess.GDBAccessObj.EstablishDBConnection(CommonTypes.ParseDBType(cmdLine.GetOptValue("type")), cmdLine.GetOptValue("host"),
cmdLine.GetOptValue("port"), cmdLine.GetOptValue("database"), cmdLine.GetOptValue("username"), cmdLine.GetOptValue(
"password"), "", "ICT.Tools.DataMigrateStatistics.Program.Main DB Connection");
TDataDefinitionParser parserNew = new TDataDefinitionParser(xmlfile, false);
TDataDefinitionStore storeNew = new TDataDefinitionStore();
parserNew.ParseDocument(ref storeNew, false, true);
List <TTable> newTables = storeNew.GetTables();
// table names and row numbers on alternate lines
string[] checkRows = File.ReadAllLines(row_count_location);
Console.WriteLine();
Console.WriteLine("--- Testing all rows have loaded successfully ---");
int totalRows = 0; // total number of rows in database
int totalCheckRows = 0; // total number of rows there should be in the database
bool rowsMissing = false;
foreach (TTable newTable in newTables)
{
if (newTable.strName != "s_login") // ignore this table as the row count changes everytime a connection is made to the database
{
int i = 0;
int rowCount; // number of rows actually in table
int rowCountCheck = 0; // number of rows there should be in table
// count rows in table
string sql = "SELECT count(*) from " + newTable.strName + ";";
rowCount = Convert.ToInt32(DBAccess.GDBAccessObj.ExecuteScalar(sql, IsolationLevel.ReadUncommitted));
// read how many rows there should be in the same table
while (i < checkRows.Length)
{
if (checkRows[i] == newTable.strName)
{
rowCountCheck = Convert.ToInt32(checkRows[i + 1]);
break;
}
i += 2;
}
totalRows += rowCount;
totalCheckRows += rowCountCheck;
// if there are rows missing
if (rowCount != rowCountCheck)
{
Console.Write(newTable.strName + " is incomplete. ");
Console.WriteLine((rowCountCheck - rowCount) + " out of " + rowCountCheck + " rows did not load!");
rowsMissing = true;
}
}
}
// if all rows are present
if (!rowsMissing)
{
Console.WriteLine("All rows successfully loaded.");
}
// write a summary of the number of rows successfully loaded
Console.WriteLine();
Console.WriteLine("--- Total number of rows loaded ---");
Console.WriteLine(totalRows + " out of " + totalCheckRows + " rows loaded successfully.");
string percentage = (decimal.Divide(totalRows * 100, totalCheckRows)).ToString("#.##");
Console.WriteLine(percentage + "%");
Console.WriteLine();
DBAccess.GDBAccessObj.CloseDBConnection();
}
else
{
TLogging.Log("Warning: unable to perform a row count test. _row_count.txt is missing from the folder .../delivery/bin/fulldump.");
TLogging.Log("");
}
}
int run()
{
new TAppSettingsManager(false);
cmdLine = new TCmdOpts();
if (!cmdLine.IsFlagSet("do") ||
((cmdLine.GetOptValue("do") == "dataset") && (!cmdLine.IsFlagSet("input") || !cmdLine.IsFlagSet("outputNamespace"))) ||
((cmdLine.GetOptValue("do") == "referencecount") &&
(!cmdLine.IsFlagSet("inputclient") || !cmdLine.IsFlagSet("outputserver") || !cmdLine.IsFlagSet("templatedir"))))
{
System.Console.WriteLine("GenerateORM: generate Typed Tables and Datasets");
System.Console.WriteLine("usage: GenerateORM -do:<operation> -petraxml:<xyz/petra.xml>");
System.Console.WriteLine("operations available:");
System.Console.WriteLine(" defaulttables ");
System.Console.WriteLine(" with parameters: ");
System.Console.WriteLine(" -outputshared:<path to ICT/Petra/Shared>");
System.Console.WriteLine(" dataaccess ");
System.Console.WriteLine(" with parameters: ");
System.Console.WriteLine(" -outputshared:<path to ICT/Petra/Shared>");
System.Console.WriteLine(" dataset ");
System.Console.WriteLine(" with parameters: ");
System.Console.WriteLine(" -input:<dataset XML file>");
System.Console.WriteLine(" -outputNamespace:<Namespace of the file>");
System.Console.WriteLine(" cachedtables ");
System.Console.WriteLine(" with parameters: ");
System.Console.WriteLine(" -cachedef:<dataset XML file>");
System.Console.WriteLine(" -outputshared:<path to ICT/Petra/Shared>");
System.Console.WriteLine(" referencecount ");
System.Console.WriteLine(" with parameters: ");
System.Console.WriteLine(" -inputclient:<path to ICT/Petra/Client>");
System.Console.WriteLine(" -outputserver:<path to ICT/Petra/Server>");
System.Console.WriteLine(" -templatedir:<path to inc/template/src>");
System.Console.WriteLine(
" e.g. GenerateORM -do:dataset -petraxml:U:/sql/datadefinition/petra.xml -input:U:/sql/datadefinition/dataset.xml -outputNamespace:Ict.Petra.Shared.MCommon.Data.Dataset");
return(100);
}
try
{
parser = new TDataDefinitionParser(cmdLine.GetOptValue("petraxml"));
store = new TDataDefinitionStore();
if (parser.ParseDocument(ref store))
{
if ((cmdLine.GetOptValue("do") == "defaulttables") || (cmdLine.GetOptValue("do") == "datatables"))
{
CodeGenerationTable.WriteTypedTable(store, "partner", cmdLine.GetOptValue(
"outputshared") + "/lib/data/",
"Ict.Petra.Shared.MPartner.Partner.Data",
"Partner.Tables");
CodeGenerationTable.WriteTypedTable(store, "mailroom", cmdLine.GetOptValue(
"outputshared") + "/lib/data/",
"Ict.Petra.Shared.MPartner.Mailroom.Data",
"Mailroom.Tables");
CodeGenerationTable.WriteTypedTable(store, "personnel", cmdLine.GetOptValue(
"outputshared") + "/lib/data/",
"Ict.Petra.Shared.MPersonnel.Personnel.Data",
"Personnel.Tables");
CodeGenerationTable.WriteTypedTable(store, "units", cmdLine.GetOptValue(
"outputshared") + "/lib/data/",
"Ict.Petra.Shared.MPersonnel.Units.Data",
"Units.Tables");
CodeGenerationTable.WriteTypedTable(store, "conference", cmdLine.GetOptValue(
"outputshared") + "/lib/data/",
"Ict.Petra.Shared.MConference.Data",
"Conference.Tables");
CodeGenerationTable.WriteTypedTable(store, "hospitality", cmdLine.GetOptValue(
"outputshared") + "/lib/data/",
"Ict.Petra.Shared.MHospitality.Data",
"Hospitality.Tables");
CodeGenerationTable.WriteTypedTable(store, "account", cmdLine.GetOptValue(
"outputshared") + "/lib/data/",
"Ict.Petra.Shared.MFinance.Account.Data",
"Account.Tables");
CodeGenerationTable.WriteTypedTable(store, "ap", cmdLine.GetOptValue(
"outputshared") + "/lib/data/",
"Ict.Petra.Shared.MFinance.AP.Data",
"AP.Tables");
CodeGenerationTable.WriteTypedTable(store, "ar", cmdLine.GetOptValue(
"outputshared") + "/lib/data/",
"Ict.Petra.Shared.MFinance.AR.Data",
"AR.Tables");
CodeGenerationTable.WriteTypedTable(store, "gift", cmdLine.GetOptValue(
"outputshared") + "/lib/data/",
"Ict.Petra.Shared.MFinance.Gift.Data",
"Gift.Tables");
CodeGenerationTable.WriteTypedTable(store, "sysman", cmdLine.GetOptValue(
"outputshared") + "/lib/data/",
"Ict.Petra.Shared.MSysMan.Data",
"SysMan.Tables");
CodeGenerationTable.WriteTypedTable(store, "common", cmdLine.GetOptValue(
"outputshared") + "/lib/data/",
"Ict.Petra.Shared.MCommon.Data",
"Common.Tables");
CodeGenerationTableValidation.WriteValidation(store, "partner", cmdLine.GetOptValue(
"outputshared") + "/lib/MPartner/validation/",
"Ict.Petra.Shared.MPartner.Partner.Validation",
"Partner.Validation");
CodeGenerationTableValidation.WriteValidation(store, "mailroom", cmdLine.GetOptValue(
"outputshared") + "/lib/MPartner/validation/",
"Ict.Petra.Shared.MPartner.Mailroom.Validation",
"Mailroom.Validation");
CodeGenerationTableValidation.WriteValidation(store, "personnel", cmdLine.GetOptValue(
"outputshared") + "/lib/MPersonnel/validation/",
"Ict.Petra.Shared.MPersonnel.Personnel.Validation",
"Personnel.Validation");
CodeGenerationTableValidation.WriteValidation(store, "units", cmdLine.GetOptValue(
"outputshared") + "/lib/MPersonnel/validation/",
"Ict.Petra.Shared.MPersonnel.Units.Validation",
"Units.Validation");
CodeGenerationTableValidation.WriteValidation(store, "conference", cmdLine.GetOptValue(
"outputshared") + "/lib/MConference/validation/",
"Ict.Petra.Shared.MConference.Validation",
"Conference.Validation");
CodeGenerationTableValidation.WriteValidation(store, "hospitality", cmdLine.GetOptValue(
"outputshared") + "/lib/MHospitality/validation/",
"Ict.Petra.Shared.MHospitality.Validation",
"Hospitality.Validation");
CodeGenerationTableValidation.WriteValidation(store, "account", cmdLine.GetOptValue(
"outputshared") + "/lib/MFinance/validation/",
"Ict.Petra.Shared.MFinance.Account.Validation",
"Account.Validation");
CodeGenerationTableValidation.WriteValidation(store, "ap", cmdLine.GetOptValue(
"outputshared") + "/lib/MFinance/validation/",
"Ict.Petra.Shared.MFinance.AP.Validation",
"AP.Validation");
CodeGenerationTableValidation.WriteValidation(store, "ar", cmdLine.GetOptValue(
"outputshared") + "/lib/MFinance/validation/",
"Ict.Petra.Shared.MFinance.AR.Validation",
"AR.Validation");
CodeGenerationTableValidation.WriteValidation(store, "gift", cmdLine.GetOptValue(
"outputshared") + "/lib/MFinance/validation/",
"Ict.Petra.Shared.MFinance.Gift.Validation",
"Gift.Validation");
CodeGenerationTableValidation.WriteValidation(store, "sysman", cmdLine.GetOptValue(
"outputshared") + "/lib/MSysMan/validation/",
"Ict.Petra.Shared.MSysMan.Validation",
"SysMan.Validation");
CodeGenerationTableValidation.WriteValidation(store, "common", cmdLine.GetOptValue(
"outputshared") + "/lib/MCommon/validation/",
"Ict.Petra.Shared.MCommon.Validation",
"Common.Validation");
TGenerateTableList.WriteTableList(store, cmdLine.GetOptValue(
"outputshared") + Path.DirectorySeparatorChar + "TableList-generated.cs");
TGenerateTableList.WriteDBClean(store, Path.GetDirectoryName(cmdLine.GetOptValue(
"petraxml")) + Path.DirectorySeparatorChar + "basedata" + Path.DirectorySeparatorChar + "clean.sql");
}
else if (cmdLine.GetOptValue("do") == "dataaccess")
{
CodeGenerationAccess.WriteTypedDataAccess(store, "partner", cmdLine.GetOptValue(
"outputshared") + "/lib/data/",
"Ict.Petra.Server.MPartner.Partner.Data.Access",
"Partner.Access");
CodeGenerationAccess.WriteTypedDataAccess(store, "mailroom", cmdLine.GetOptValue(
"outputshared") + "/lib/data/",
"Ict.Petra.Server.MPartner.Mailroom.Data.Access",
"Mailroom.Access");
CodeGenerationAccess.WriteTypedDataAccess(store, "personnel", cmdLine.GetOptValue(
"outputshared") + "/lib/data/",
"Ict.Petra.Server.MPersonnel.Personnel.Data.Access",
"Personnel.Access");
CodeGenerationAccess.WriteTypedDataAccess(store, "units", cmdLine.GetOptValue(
"outputshared") + "/lib/data/",
"Ict.Petra.Server.MPersonnel.Units.Data.Access",
"Units.Access");
CodeGenerationAccess.WriteTypedDataAccess(store, "conference", cmdLine.GetOptValue(
"outputshared") + "/lib/data/",
"Ict.Petra.Server.MConference.Data.Access",
"Conference.Access");
CodeGenerationAccess.WriteTypedDataAccess(store, "hospitality", cmdLine.GetOptValue(
"outputshared") + "/lib/data/",
"Ict.Petra.Server.MHospitality.Data.Access",
"Hospitality.Access");
CodeGenerationAccess.WriteTypedDataAccess(store, "account", cmdLine.GetOptValue(
"outputshared") + "/lib/data/",
"Ict.Petra.Server.MFinance.Account.Data.Access",
"Account.Access");
CodeGenerationAccess.WriteTypedDataAccess(store, "ap", cmdLine.GetOptValue(
"outputshared") + "/lib/data/",
"Ict.Petra.Server.MFinance.AP.Data.Access",
"AP.Access");
CodeGenerationAccess.WriteTypedDataAccess(store, "ar", cmdLine.GetOptValue(
"outputshared") + "/lib/data/",
"Ict.Petra.Server.MFinance.AR.Data.Access",
"AR.Access");
CodeGenerationAccess.WriteTypedDataAccess(store, "gift", cmdLine.GetOptValue(
"outputshared") + "/lib/data/",
"Ict.Petra.Server.MFinance.Gift.Data.Access",
"Gift.Access");
CodeGenerationAccess.WriteTypedDataAccess(store, "sysman", cmdLine.GetOptValue(
"outputshared") + "/lib/data/",
"Ict.Petra.Server.MSysMan.Data.Access",
"SysMan.Access");
CodeGenerationAccess.WriteTypedDataAccess(store, "common", cmdLine.GetOptValue(
"outputshared") + "/lib/data/",
"Ict.Petra.Server.MCommon.Data.Access",
"Common.Access");
CodeGenerationCascading.WriteTypedDataCascading(store, cmdLine.GetOptValue(
"outputshared") + "/lib/data/",
"Ict.Petra.Server.MCommon.Data.Cascading",
"Cascading");
}
else if (cmdLine.GetOptValue("do") == "dataset")
{
string[] groups = new string[] {
"common", "mailroom", "sysman", "partner",
"account", "gift", "ap", "ar", "personnel", "units", "conference", "hospitality"
};
CodeGenerationDataset.CreateTypedDataSets(cmdLine.GetOptValue("input"),
cmdLine.GetOptValue("outputdir"),
cmdLine.GetOptValue("outputNamespace"),
store, groups,
cmdLine.GetOptValue("outputFilename"));
}
else if (cmdLine.GetOptValue("do") == "datasetaccess")
{
string[] groups = new string[] {
"common", "mailroom", "sysman", "partner",
"account", "gift", "ap", "ar", "personnel", "units", "conference", "hospitality"
};
CodeGenerationDatasetAccess.CreateTypedDataSets(cmdLine.GetOptValue("input"),
cmdLine.GetOptValue("outputdir"),
cmdLine.GetOptValue("outputNamespace"),
store, groups,
cmdLine.GetOptValue("outputFilename"));
}
else if (cmdLine.GetOptValue("do") == "cachedtables")
{
Ict.Tools.CodeGeneration.CachedTables.TGenerateCachedTables.WriteCachedTables(
store,
cmdLine.GetOptValue("cachedef"),
cmdLine.GetOptValue("outputshared"),
cmdLine.GetOptValue("TemplateDir"));
}
else
{
Console.WriteLine("could not recognise: " + cmdLine.GetOptValue("do"));
}
}
}
catch (Exception E)
{
System.Console.WriteLine(E.Message);
System.Console.WriteLine(E.StackTrace);
return(100);
// System.Console.ReadLine();
}
return(0);
}
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)
{
try
{
new TAppSettingsManager(false);
if (Directory.Exists(TAppSettingsManager.GetValue("logPath")))
{
new TLogging(TAppSettingsManager.GetValue("logPath") + "/generateextjsforms.log");
}
else
{
new TLogging("generateextjsforms.log");
}
TLogging.DebugLevel = TAppSettingsManager.GetInt16("DebugLevel", 0);
if (!TAppSettingsManager.HasValue("ymlfile"))
{
Console.WriteLine("call: GenerateExtJsForms -ymlfile:c:\\test.yaml -petraxml:petra.xml -localisation:en");
Console.Write("Press any key to continue . . . ");
Console.ReadLine();
Environment.Exit(-1);
return;
}
// calculate ICTPath from ymlfile path
string fullYmlfilePath = Path.GetFullPath(TAppSettingsManager.GetValue("ymlfile")).Replace("\\", "/");
string SelectedLocalisation = null; // none selected by default
if (TAppSettingsManager.HasValue("localisation"))
{
SelectedLocalisation = TAppSettingsManager.GetValue("localisation");
}
CSParser.ICTPath = fullYmlfilePath.Substring(0, fullYmlfilePath.IndexOf("csharp/ICT") + "csharp/ICT".Length);
TDataBinding.FPetraXMLStore = new TDataDefinitionStore();
Console.WriteLine("parsing " + TAppSettingsManager.GetValue("petraxml", true));
TDataDefinitionParser parser = new TDataDefinitionParser(TAppSettingsManager.GetValue("petraxml", true));
parser.ParseDocument(ref TDataBinding.FPetraXMLStore, true, true);
string ymlfileParam = TAppSettingsManager.GetValue("ymlfile", true);
if (ymlfileParam.Contains(","))
{
StringCollection collection = StringHelper.StrSplit(ymlfileParam, ",");
foreach (string file in collection)
{
ProcessFile(file, SelectedLocalisation);
}
}
else if (System.IO.Directory.Exists(ymlfileParam))
{
ProcessDirectory(ymlfileParam, SelectedLocalisation);
}
else
{
ProcessFile(ymlfileParam, SelectedLocalisation);
}
// TODO: generate localised versions
// TODO: generate minified version. either using YUICompressor, or simple string operation?
// Or should the xsp server do that? generate js files on the fly? figure out the language of the client? cache files?
}
catch (Exception e)
{
string commandline = "";
foreach (string s in args)
{
commandline += s + " ";
}
Console.WriteLine("Problem while processing " + commandline);
Console.WriteLine(e.GetType().ToString() + ": " + e.Message);
if (e.InnerException != null)
{
Console.WriteLine(e.InnerException.GetType().ToString() + ": " + e.InnerException.Message);
}
// do not print a stacktrace for custom generated exception, eg. by the YML parser
if ((e.GetType() != typeof(System.Exception)) || (TLogging.DebugLevel > 0))
{
Console.WriteLine(e.StackTrace);
}
Environment.Exit(-1);
}
}
public static void Main(string[] args)
{
try
{
new TAppSettingsManager(false);
if (Directory.Exists("log"))
{
new TLogging("log/generatewinforms.log");
}
else
{
new TLogging("generatewinforms.log");
}
TLogging.DebugLevel = TAppSettingsManager.GetInt16("Server.DebugLevel", 0);
if (!TAppSettingsManager.HasValue("op"))
{
Console.WriteLine("call: GenerateWinForms -op:generate -ymlfile:c:\\test.yaml -petraxml:petra.xml -localisation:en");
Console.WriteLine(" or: GenerateWinForms -op:generate -ymldir:c:\\myclient -petraxml:petra.xml -localisation:en");
Console.WriteLine(" or: GenerateWinForms -op:clean -ymldir:c:\\myclient");
Console.WriteLine(" or: GenerateWinForms -op:preview");
Console.Write("Press any key to continue . . . ");
Console.ReadLine();
Environment.Exit(-1);
return;
}
// calculate ICTPath from ymlfile path
string fullYmlfilePath =
Path.GetFullPath(TAppSettingsManager.GetValue("ymlfile", TAppSettingsManager.GetValue("ymldir", false))).Replace(
"\\",
"/");
if (!fullYmlfilePath.Contains("csharp/ICT"))
{
Console.WriteLine("ymlfile must be below the csharp/ICT directory");
}
CSParser.ICTPath = fullYmlfilePath.Substring(0, fullYmlfilePath.IndexOf("csharp/ICT") + "csharp/ICT".Length);
if (TAppSettingsManager.GetValue("op") == "clean")
{
if (!Directory.Exists(fullYmlfilePath))
{
throw new Exception("invalid directory " + fullYmlfilePath);
}
// delete all generated files in the directory
foreach (string file in System.IO.Directory.GetFiles(fullYmlfilePath, "*.yaml", SearchOption.AllDirectories))
{
DeleteGeneratedFile(file, "-generated.cs");
DeleteGeneratedFile(file, "-generated.Designer.cs");
DeleteGeneratedFile(file, "-generated.resx");
}
}
else if (TAppSettingsManager.GetValue("op") == "preview")
{
string SelectedLocalisation = null; // none selected by default; winforms autosize works quite well
if (TAppSettingsManager.HasValue("localisation"))
{
SelectedLocalisation = TAppSettingsManager.GetValue("localisation");
}
TDataBinding.FPetraXMLStore = new TDataDefinitionStore();
Console.WriteLine("parsing " + TAppSettingsManager.GetValue("petraxml", true));
TDataDefinitionParser parser = new TDataDefinitionParser(TAppSettingsManager.GetValue("petraxml", true));
parser.ParseDocument(ref TDataBinding.FPetraXMLStore, true, true);
TFrmYamlPreview PreviewWindow = new TFrmYamlPreview(
TAppSettingsManager.GetValue("ymlfile"),
SelectedLocalisation);
AppDomain.CurrentDomain.UnhandledException += new UnhandledExceptionEventHandler(UnhandledExceptionHandler);
Application.ThreadException += new ThreadExceptionEventHandler(UnhandledThreadExceptionHandler);
PreviewWindow.ShowDialog();
return;
}
else if (TAppSettingsManager.GetValue("op") == "generate")
{
string SelectedLocalisation = null; // none selected by default; winforms autosize works quite well
if (TAppSettingsManager.HasValue("localisation"))
{
SelectedLocalisation = TAppSettingsManager.GetValue("localisation");
}
TDataBinding.FPetraXMLStore = new TDataDefinitionStore();
Console.WriteLine("parsing " + TAppSettingsManager.GetValue("petraxml", true));
TDataDefinitionParser parser = new TDataDefinitionParser(TAppSettingsManager.GetValue("petraxml", true));
parser.ParseDocument(ref TDataBinding.FPetraXMLStore, true, true);
string ymlfileParam = TAppSettingsManager.GetValue("ymlfile", TAppSettingsManager.GetValue("ymldir", false));
if (ymlfileParam.Contains(","))
{
StringCollection collection = StringHelper.StrSplit(ymlfileParam, ",");
foreach (string file in collection)
{
ProcessFile(file, SelectedLocalisation);
}
}
else if (System.IO.Directory.Exists(ymlfileParam))
{
string[] yamlfiles = System.IO.Directory.GetFiles(ymlfileParam, "*.yaml", SearchOption.AllDirectories);
// sort the files so that the deepest files are first processed,
// since the files higher up are depending on them
// eg. FinanceMain.yaml needs to check for GLBatch-generated.cs
List <string> yamlFilesSorted = new List <string>(yamlfiles.Length);
foreach (string file in yamlfiles)
{
yamlFilesSorted.Add(file);
}
yamlFilesSorted.Sort(new YamlFileOrderComparer());
foreach (string file in yamlFilesSorted)
{
// only look for main files, not language specific files (*.xy-XY.yaml or *.xy.yaml)
if (TProcessYAMLForms.IgnoreLanguageSpecificYamlFile(file))
{
continue;
}
Console.WriteLine("working on " + file);
ProcessFile(file, SelectedLocalisation);
}
}
else
{
ProcessFile(ymlfileParam, SelectedLocalisation);
}
}
}
catch (Exception e)
{
string commandline = "";
foreach (string s in args)
{
commandline += s + " ";
}
Console.WriteLine("Problem while processing " + commandline);
Console.WriteLine(e.GetType().ToString() + ": " + e.Message);
if (e.InnerException != null)
{
Console.WriteLine(e.InnerException.GetType().ToString() + ": " + e.InnerException.Message);
}
// do not print a stacktrace for custom generated exception, eg. by the YML parser
if ((e.GetType() != typeof(System.Exception)) || (TLogging.DebugLevel > 0))
{
Console.WriteLine(e.StackTrace);
}
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);
}
}