public static void Main(string[] args_in) {
#region Console.WriteLine("Copyright (C) 2002 Francisco Monteiro");
Console.WriteLine(
@"
OGen
Copyright (C) 2002 Francisco Monteiro
Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the ""Software""), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:
The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.
THE SOFTWARE IS PROVIDED ""AS IS"", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
"
);
#endregion
if (args_in.Length >= 1) {
if (File.Exists(args_in[0])) {
#region string[] _templateTypes = ...;
string[] _templateTypes = new string[args_in.Length - 1];
for (int a = 1; a < args_in.Length; a++) {
_templateTypes[a - 1] = args_in[a];
}
#endregion
DoIt(
args_in[0],
null,
_templateTypes
);
} else {
Console.WriteLine("file doesn't exist");
}
} else {
#if DEBUG
try {
long _begin_ticks = DateTime.Now.Ticks;
Statistics _statistics
= new Statistics(
true,
true,
true
);
DoIt(
System.IO.Path.Combine(
#if !NET_1_1
System.Configuration.ConfigurationManager.AppSettings
#else
System.Configuration.ConfigurationSettings.AppSettings
#endif
["ogenPath"],
//@"..\..\OGen-NTier_UTs\OGen-metadatas\MD_OGen-NTier_UTs.OGen-metadata.xml"
//@"..\..\OGen-NTier_UTs-newTest\OGen-metadatas\MD_OGen-NTier_UTs.OGenXSD-metadata.xml"
//@"..\..\OGen-NTier_UTs\OGen-metadatas\MD_OGen-NTier_UTs.OGenXSD-metadata.xml"
@"..\..\OGen-Kick\OGen-metadatas\MD_Kick.OGenXSD-metadata.xml"
),
_statistics
//,
//new string[] {
// "business",
// "data"
//}
);
Console.WriteLine(
"time: {0}",
new DateTime(DateTime.Now.Ticks - _begin_ticks).ToString(
"HH'H' mm'm' ss's' fff",
System.Globalization.CultureInfo.CurrentCulture
)
);
Console.WriteLine(
"lines: {0}\nbytes: {1} ~ {2}",
_statistics.Lines,
_statistics.Bytes_ToString(false),
_statistics.Bytes_ToString(true)
);
} catch (Exception _ex) {
Console.WriteLine(_ex.ToString());
}
Console.WriteLine("Press any key to continue...");
#if !NET_1_1
Console.ReadKey();
#else
Console.ReadLine();
#endif
#else
Console.WriteLine("must provide xml file");
#endif
}
}
public static void DoIt(
string filePath_in,
Statistics statistics_in,
params string[] templateTypes_in
) {
NTierGenerator _generator = new NTierGenerator();
_generator.Open(
filePath_in,
true,
Notify
);
_generator.Build(
Notify,
statistics_in,
templateTypes_in
);
#region oldstuff...
// #region string _outputDir = ...;
// string _outputDir = System.IO.Directory.GetParent(
// Path.GetDirectoryName(filePath_in)
// ).FullName;
// #endregion
//
// Notify("", true);
// Notify("opening...", true);
// #region _metadata_temp = new cDBMetadata().LoadState_fromXML(filePath_in);
// Notify("- reading configuration from xml file", true);
// cDBMetadata _metadata_temp = new cDBMetadata();
// _metadata_temp.LoadState_fromXML(filePath_in);
// #endregion
// #region _metadata = new cDBMetadata().LoadState_fromDB(...);
// Notify("- reading metadata from db", true);
// cDBMetadata _metadata = new cDBMetadata();
// _metadata.LoadState_fromDB(
// new cDBMetadata.dLoadState_fromDB(
// Notify
// ),
// _metadata_temp.DBs.Default.DBServerType,
// _metadata_temp.DBs.Default.Connectionstring,
// _metadata_temp.SubAppName
// );
// #endregion
// #region _metadata.LoadState_fromXML(filePath_in, All_butDatabaseER);
// Notify("- updating metadata with xml file", true);
// _metadata.LoadState_fromXML(
// filePath_in,
// cDBMetadata.eMetadata.All_butDatabaseER
// );
// #endregion
// #region string _metadataFilePath = ...;
// string _metadataFilePath = string.Format(
// System.Globalization.CultureInfo.CurrentCulture,
// "{0}{1}OGen-metadatas{1}MD0_{2}-{3}.OGen-metadata.xml",
// /*00*/ _outputDir,
// /*01*/ Path.DirectorySeparatorChar,
// /*02*/ _metadata_temp.ApplicationName,
// /*03*/ _metadata_temp.DBs.Default.DBServerType.ToString()
// );
// string _dir = Path.GetDirectoryName(_metadataFilePath);
// if (!Directory.Exists(_dir)) Directory.CreateDirectory(_dir);
// #endregion
// _metadata.SaveState_toXML(_metadataFilePath);
// Notify("...finished!", true);
// Notify("", true);
//
// Notify("generating...", true);
// #region new OGenGenerator(...).Build(...);
// new OGenGenerator(
// ConfigurationSettingsBinder.Read("OGen"),
// _metadataFilePath,
// cDBMetadata.root4xml,
// ConfigurationSettingsBinder.Read("Templates"),
// cTemplates.root4xml,
// _metadata_temp.DBs.Default.DBServerType,
// _metadata_temp.DBs.Default.Connectionstring,
// _outputDir
// ).Build(
// Notify,
// _metadata
// );
// #endregion
// Notify("...finished!", true);
// //Notify("", true);
#endregion
}
public void Build(
OGen.Libraries.Generator.Build notifyBack_in,
IMetadata metadata_in,
Statistics statistics_in,
params string[] templateTypes_in
) {
this.build(
notifyBack_in,
// false,
metadata_in,
statistics_in,
templateTypes_in
);
}
private void build(
OGen.Libraries.Generator.Build notifyBack_in,
// bool loadMetadata_in,
IMetadata metadata_in,
Statistics statistics_in,
params string[] templateTypes_in
) {
this.notifyback_ = notifyBack_in;
//this.notifyback_("- common items", true);
if (this.xmltemplatesfileuri_.IsFile) {
this.xmltemplatesdir_ = Path.GetDirectoryName(
this.xmltemplatesfileuri_.LocalPath
);
} else {
this.xmltemplatesdir_ = this.xmltemplatesfileuri_.ToString().Substring(
0,
this.xmltemplatesfileuri_.ToString().LastIndexOf("/", StringComparison.CurrentCulture)
);
}
//this.metadata_ = new cDBMetadata(this.xmlmetadatafile_, this.xmlmetadataroot_);
this.metadata_ = metadata_in;
// if (loadMetadata_in) {
//// ToDos: now! index must be sinchronized, not very convenient :(
// for (int m = 0; m < this.metadatas_.Length; m++) {
// this.metadatas_[m].LoadState_fromFile(
// //this.xmlmetadatafile_,
// this.metafiles_[m].Path,
// //this.xmlmetadataroot_
// this.metafiles_[m].Root
// );
// }
// }
this.templates_ = (this.xmltemplatesfileuri_.IsFile)
? XS__templates.Load_fromFile(this.xmltemplatesfileuri_.LocalPath)[0]
: XS__templates.Load_fromURI(this.xmltemplatesfileuri_)[0]
;
#region int _templateName_MaxLength = ...;
int _templateName_MaxLength = 0;
for (int i = 0; i < this.templates_.TemplateCollection.Count; i++) {
if (this.templates_.TemplateCollection[i].ID.Length > _templateName_MaxLength) {
_templateName_MaxLength = this.templates_.TemplateCollection[i].ID.Length;
}
}
#endregion
#if NET_1_1
OGen.Libraries.Worker.WorkItem[] _templatesState
= new Worker.WorkItem[templates_.TemplateCollection.Count];
#else
OGen.Libraries.Worker.WorkItem<XS_templateType>[] _templatesState
= new Worker.WorkItem<XS_templateType>[this.templates_.TemplateCollection.Count];
#endif
int _threadIterarionCounter = 0;
object _threadIterarionCounterLocker = new object();
for (int i = 0; i < this.templates_.TemplateCollection.Count; i++) {
// must check priorities, hence Waiting, otherwise Ready
#region WorkItemState _state = (skipping) ? WorkItemState.Done : WorkItemState.Waiting;
OGen.Libraries.Worker.WorkItemState _state
= OGen.Libraries.Worker.WorkItemState.Waiting;
if (
(templateTypes_in != null)
&&
(templateTypes_in.Length > 0)
&&
!string.IsNullOrEmpty(this.templates_.TemplateCollection[i].TemplateType)
&&
!OGen.Libraries.Utilities.StringArrayContains(
templateTypes_in,
this.templates_.TemplateCollection[i].TemplateType
)
) {
string _stepNum = (++_threadIterarionCounter).ToString(System.Globalization.CultureInfo.CurrentCulture);
string _stepOf = this.templates_.TemplateCollection.Count.ToString(System.Globalization.CultureInfo.CurrentCulture);
this.notifyback_(
string.Format(
System.Globalization.CultureInfo.CurrentCulture,
"thread 0: {0}#{1}/{2} - {3} {4} skipping!",
string.Empty.PadLeft(_stepOf.Length - _stepNum.Length, ' '),
_stepNum,
_stepOf,
this.templates_.TemplateCollection[i].ID,
string.Empty.PadLeft(_templateName_MaxLength - this.templates_.TemplateCollection[i].ID.Length + 3, '.')
),
true
);
_state = OGen.Libraries.Worker.WorkItemState.Done;
}
#endregion
#if NET_1_1
_templatesState[i] = new OGen.Libraries.Worker.WorkItem(
#else
_templatesState[i] = new OGen.Libraries.Worker.WorkItem<XS_templateType>(
#endif
this.templates_.TemplateCollection[i],
_state
);
}
OGen.Libraries.Worker.Worker _worker = new Worker.Worker();
int _numthreads = 4;
WorkerThread[] _workthreads = new WorkerThread[_numthreads];
for (int t = 0; t < _workthreads.Length; t++) {
#region DBConnectionstrings _dbconnectionstrings = ...;
DBConnectionstrings _dbconnectionstrings = new DBConnectionstrings();
for (int d = 0; d < this.dbconnectionstrings_.Count; d++) {
_dbconnectionstrings.Add(
this.dbconnectionstrings_[d].DBServerType,
this.dbconnectionstrings_[d].Connectionstring
);
}
for (int d = 0; d < _dbconnectionstrings.Count; d++) {
_dbconnectionstrings[d].Connection_createInstance();
}
#endregion
#if DEBUG
int T = t;
#endif
System.Threading.Thread _thread = new System.Threading.Thread(delegate() {
#if NET_1_1
_worker.DoWork(
#else
_worker.DoWork<XS_templateType>(
#endif
_templatesState,
delegate(
#if NET_1_1
object template_in
#else
XS_templateType template_in
#endif
) {
#if NET_1_1
XS_templateType _template = (XS_templateType)template_in;
#else
XS_templateType _template = template_in;
#endif
#region int _finishedDependencies = ...;
int _finishedDependencies = 0;
for (int d = 0; d < _template.Dependencies.DependencyCollection.Count; d++) {
for (int f = 0; f < _templatesState.Length; f++) {
if (
_template.Dependencies.DependencyCollection[d].TemplateID
==
#if NET_1_1
((XS_templateType)_templatesState[f].Item).ID
#else
_templatesState[f].Item.ID
#endif
) {
if (_templatesState[f].State == Worker.WorkItemState.Done) {
_finishedDependencies++;
}
break;
}
}
}
#endregion
return (_finishedDependencies == _template.Dependencies.DependencyCollection.Count);
},
delegate(
#if NET_1_1
object template_in
#else
XS_templateType template_in
#endif
) {
#if NET_1_1
XS_templateType _template = (XS_templateType)template_in;
#else
XS_templateType _template = template_in;
#endif
#if DEBUG
long _begin = DateTime.Now.Ticks;
#endif
#region RUNNING: _template ...
bool _valuehasbeenfound_out = false;
this.metadata_.IterateThrough_fromRoot(
_template.IterationType,
delegate(string message_in) {
this.notifyme(
message_in,
_template,
_dbconnectionstrings,
statistics_in
);
},
ref _valuehasbeenfound_out
);
#endregion
int _threaditerarion;
lock (_threadIterarionCounterLocker) {
_threaditerarion = _threadIterarionCounter;
_threadIterarionCounter = ++_threaditerarion;
}
#if DEBUG
_workthreads[T].TotalTicks += DateTime.Now.Ticks - _begin;
TimeSpan _end = new TimeSpan(DateTime.Now.Ticks - _begin);
#endif
string _stepNum = _threaditerarion.ToString(System.Globalization.CultureInfo.CurrentCulture);
string _stepOf = this.templates_.TemplateCollection.Count.ToString(System.Globalization.CultureInfo.CurrentCulture);
this.notifyback_(
string.Format(
System.Globalization.CultureInfo.CurrentCulture,
#if DEBUG
"thread {6}: {0}#{1}/{2} - {3} {4} {5} ({7}s {8}m)",
#else
"thread {6}: {0}#{1}/{2} - {3} {4} {5}",
#endif
string.Empty.PadLeft(_stepOf.Length - _stepNum.Length, ' '),
_stepNum,
_stepOf,
#if NET_1_1
((XS_templateType)template_in).ID,
"".PadLeft(_templateName_MaxLength - ((XS_templateType)template_in).ID.Length + 3, '.'),
#else
template_in.ID,
string.Empty.PadLeft(_templateName_MaxLength - template_in.ID.Length + 3, '.'),
#endif
(_valuehasbeenfound_out ? "DONE!" : "NOT doing!"),
System.Threading.Thread.CurrentThread.Name
#if DEBUG
,
Convert.ToInt32(_end.TotalSeconds),
_end.Milliseconds
#endif
),
true
);
}
);
});
_thread.Name = string.Format(
System.Globalization.CultureInfo.CurrentCulture,
"{0}",
t + 1
);
_thread.IsBackground = true;
_workthreads[t] = new WorkerThread(
_thread,
_dbconnectionstrings
);
_thread.Start();
}
for (int t = 0; t < _workthreads.Length; t++) {
_workthreads[t].Thread.Join();
#region _workthreads[t].DBConnectionstrings[0..n].Connection_createInstance();
for (int d = 0; d < _workthreads[t].DBConnectionstrings.Count; d++) {
_workthreads[t].DBConnectionstrings[d].Connection_clearInstance();
}
#endregion
}
#if DEBUG
for (int t = 0; t < _workthreads.Length; t++) {
TimeSpan _span = new TimeSpan(_workthreads[t].TotalTicks);
Console.WriteLine(
"thread {0}: work span: {1}s {2}m",
_workthreads[t].Thread.Name,
Convert.ToInt32(_span.TotalSeconds),
_span.Milliseconds
);
}
#endif
}
private void notifyme(
string message_in,
XS_templateType template_in,
DBConnectionstrings dbConnectionStrings_in,
Statistics statistics_in
) {
// ToDos: here!
// cDBConnection _con = null;
#region int _verifiedConditions = ...;
int _verifiedConditions = 0;
for (int c = 0; c < template_in.Conditions.ConditionCollection.Count; c++) {
if (
this.translate(
template_in.Conditions.ConditionCollection[c].Eval,
message_in
)
==
template_in.Conditions.ConditionCollection[c].To
) _verifiedConditions++;
}
#endregion
if (_verifiedConditions == template_in.Conditions.ConditionCollection.Count) {
#region Hashtable _args = ...;
Hashtable _args = new Hashtable(template_in.Arguments.ArgumentCollection.Count);
for (int a = 0; a < template_in.Arguments.ArgumentCollection.Count; a++) {
_args.Add(
template_in.Arguments.ArgumentCollection[a].Name,
//System.Web.HttpUtility.UrlEncode(
this.translateFully(
template_in.Arguments.ArgumentCollection[a].Value,
message_in
)
//)
);
}
#endregion
for (int o = 0; o < template_in.Outputs.OutputCollection.Count; o++) {
#region if (!dbConnectionStrings_in.Contains(DBServerTypes. ...)) continue;
switch (template_in.Outputs.OutputCollection[o].Type) {
#region case XS_OutputEnumeration.someDBServer_whatever: ... break;
#if PostgreSQL
case XS_OutputEnumeration.PostgreSQL_Function:
case XS_OutputEnumeration.PostgreSQL_StoredProcedure:
case XS_OutputEnumeration.PostgreSQL_View: {
if (!dbConnectionStrings_in.Contains_disableIfNot(DBServerTypes.PostgreSQL)) continue;
// _con = (cDBConnection)connection_[DBServerTypes.PostgreSQL];
break;
}
#else
case XS_OutputEnumeration.PostgreSQL_Function:
case XS_OutputEnumeration.PostgreSQL_StoredProcedure:
case XS_OutputEnumeration.PostgreSQL_View: {
continue;
}
#endif
#if MySQL
case XS_OutputEnumeration.MySQL_Function:
case XS_OutputEnumeration.MySQL_StoredProcedure:
case XS_OutputEnumeration.MySQL_View: {
if (!dbConnectionStrings_in.Contains_disableIfNot(DBServerTypes.MySQL)) continue;
// _con = (cDBConnection)connection_[DBServerTypes.MySQL];
break;
}
#else
case XS_OutputEnumeration.MySQL_Function:
case XS_OutputEnumeration.MySQL_StoredProcedure:
case XS_OutputEnumeration.MySQL_View: {
continue;
}
#endif
case XS_OutputEnumeration.SQLServer_Function:
case XS_OutputEnumeration.SQLServer_StoredProcedure:
case XS_OutputEnumeration.SQLServer_View: {
if (!dbConnectionStrings_in.Contains_disableIfNot(DBServerTypes.SQLServer)) continue;
// _con = (cDBConnection)connection_[DBServerTypes.SQLServer];
break;
}
#endregion
}
#endregion
string _ouputTo = this.translateFully(
template_in.Outputs.OutputCollection[o].To,
message_in
);
// #region bool _exists = ...;
bool _exists_aux = false;
for (int d = 0; d < dbConnectionStrings_in.Count; d++) {
dbConnectionStrings_in[d].exists_aux__ = false;
}
switch (template_in.Outputs.OutputCollection[o].Type) {
case XS_OutputEnumeration.File: {
_exists_aux = (_ouputTo == DEVNULL) ? true : File.Exists(_ouputTo);
break;
}
#region case XS_OutputEnumeration.someDBServer_whatever: ... break;
case XS_OutputEnumeration.MySQL_Function:
case XS_OutputEnumeration.PostgreSQL_Function:
case XS_OutputEnumeration.SQLServer_Function: {
//_exists = _con.SQLFunction_exists(_ouputTo);
for (int d = 0; d < dbConnectionStrings_in.Count; d++) {
if (!dbConnectionStrings_in[d].enabled_aux__) continue;
dbConnectionStrings_in[d].exists_aux__
= dbConnectionStrings_in[d].Connection.SQLFunction_exists(_ouputTo);
if (!_exists_aux && dbConnectionStrings_in[d].exists_aux__) _exists_aux = true;
}
break;
}
case XS_OutputEnumeration.MySQL_StoredProcedure:
case XS_OutputEnumeration.PostgreSQL_StoredProcedure:
case XS_OutputEnumeration.SQLServer_StoredProcedure: {
//_exists = _con.SQLStoredProcedure_exists(_ouputTo);
for (int d = 0; d < dbConnectionStrings_in.Count; d++) {
if (!dbConnectionStrings_in[d].enabled_aux__) continue;
dbConnectionStrings_in[d].exists_aux__
= dbConnectionStrings_in[d].Connection.SQLStoredProcedure_exists(_ouputTo);
if (!_exists_aux && dbConnectionStrings_in[d].exists_aux__) _exists_aux = true;
}
break;
}
case XS_OutputEnumeration.MySQL_View:
case XS_OutputEnumeration.PostgreSQL_View:
case XS_OutputEnumeration.SQLServer_View: {
//_exists = _con.SQLView_exists(_ouputTo);
for (int d = 0; d < dbConnectionStrings_in.Count; d++) {
if (!dbConnectionStrings_in[d].enabled_aux__) continue;
dbConnectionStrings_in[d].exists_aux__
= dbConnectionStrings_in[d].Connection.SQLView_exists(_ouputTo);
if (!_exists_aux && dbConnectionStrings_in[d].exists_aux__) _exists_aux = true;
}
break;
}
#endregion
default: {
throw notifyme_Exception;
}
}
// #endregion
if (
!_exists_aux
||
(template_in.Outputs.OutputCollection[o].Mode == XS_OutputModeEnumeration.Replace)
||
(template_in.Outputs.OutputCollection[o].Mode == XS_OutputModeEnumeration.Append)
) {
#region string _parsedOutput = ...;
string _parsedOutput;
if (template_in.ParserType == XS_ParserEnumeration.xslt) {
System.Text.StringBuilder _stringbuilder = new System.Text.StringBuilder();
StringWriter _stringwriter = new StringWriter(_stringbuilder, System.Globalization.CultureInfo.CurrentCulture);
string _xmltemplatesfile
= this.xmltemplatesdir_
+ (this.xmltemplatesfileuri_.IsFile
? Path.DirectorySeparatorChar.ToString()
: "/")
+ template_in.Name;
ParserXSLT.Parse(
//xmlmetadatafile_,
this.metafiles_[
Utilities.MetaFile_find(
this.metafiles_,
message_in.Split('.')[1]
)
].Path,
_xmltemplatesfile,
_args,
_stringwriter
);
_parsedOutput = _stringbuilder.ToString();
} else {
if (this.xmltemplatesfileuri_.IsFile) {
switch (template_in.ParserType) {
case XS_ParserEnumeration.aspx: {
ParserASPX.Parse(
this.xmltemplatesdir_,
template_in.Name,
_args,
out _parsedOutput
);
if (statistics_in != null) {
statistics_in.Lines_Add(_parsedOutput);
statistics_in.Bytes_Add(_parsedOutput);
}
break;
}
case XS_ParserEnumeration.none: {
if (template_in.Outputs.OutputCollection[o].Type == XS_OutputEnumeration.File) {
_parsedOutput = null; // will be copied
} else {
// needs to be read
_parsedOutput = new StreamReader(
Path.Combine(
this.xmltemplatesdir_,
template_in.Name
)
).ReadToEnd();
}
break;
}
default: {
// ToDos: here!
throw new Exception("ToDos: here!");
}
}
} else {
switch (template_in.ParserType) {
case XS_ParserEnumeration.aspx:
case XS_ParserEnumeration.none: {
_parsedOutput = OGen.Libraries.PresentationLayer.WebForms.Utilities.ReadURL_ToString(
this.xmltemplatesdir_ + "/" + template_in.Name,
_args
);
if (statistics_in != null) {
statistics_in.Lines_Add(_parsedOutput);
statistics_in.Bytes_Add(_parsedOutput);
}
break;
}
default: {
// ToDos: here!
throw new Exception("ToDos: here!");
}
}
}
}
#endregion
switch (template_in.Outputs.OutputCollection[o].Type) {
case XS_OutputEnumeration.File: {
if (
string.IsNullOrEmpty(_ouputTo)
||
(_ouputTo == DEVNULL)
||
(Directory.Exists(_ouputTo))
)
break;
#region Directory.CreateDirectory(_ouputTo);
string _directory = System.IO.Path.GetDirectoryName(_ouputTo);
if (!System.IO.Directory.Exists(_directory)) {
System.IO.Directory.CreateDirectory(
_directory
);
}
#endregion
if (
(template_in.ParserType == XS_ParserEnumeration.none)
&&
(this.xmltemplatesfileuri_.IsFile)
) {
// #region File.Copy(...);
// ToDos: here!
if (
(template_in.Outputs.OutputCollection[o].Mode == XS_OutputModeEnumeration.Append)
)
throw new Exception(string.Format(
System.Globalization.CultureInfo.CurrentCulture,
"not implemented (at template: {0})",
template_in.Name
));
File.Copy(
Path.Combine(
this.xmltemplatesdir_,
template_in.Name
),
_ouputTo,
true // (!_exists || template_in.Outputs.OutputCollection[o].Replace)
);
// #endregion
} else {
#region new StreamWriter(_ouputTo).Write(_parsedOutput);
StreamWriter _writer = new StreamWriter(
_ouputTo,
(template_in.Outputs.OutputCollection[o].Mode == XS_OutputModeEnumeration.Append)
);
_writer.Write(_parsedOutput);
_writer.Close();
#endregion
}
break;
}
#region case XS_OutputEnumeration.someDBServer_whatever: ... break;
case XS_OutputEnumeration.MySQL_Function:
case XS_OutputEnumeration.MySQL_StoredProcedure:
case XS_OutputEnumeration.MySQL_View:
case XS_OutputEnumeration.PostgreSQL_Function:
case XS_OutputEnumeration.PostgreSQL_StoredProcedure:
case XS_OutputEnumeration.PostgreSQL_View:
case XS_OutputEnumeration.SQLServer_Function:
case XS_OutputEnumeration.SQLServer_StoredProcedure:
case XS_OutputEnumeration.SQLServer_View: {
if (template_in.Outputs.OutputCollection[o].Mode == XS_OutputModeEnumeration.Append)
throw new Exception("can't handle append over a db function");
// #region if (_exists_aux) connection_.Function_delete(_ouputTo);
if (_exists_aux) {
switch (template_in.Outputs.OutputCollection[o].Type) {
case XS_OutputEnumeration.MySQL_Function:
case XS_OutputEnumeration.SQLServer_Function: {
//_con.SQLFunction_delete(_ouputTo);
for (int d = 0; d < dbConnectionStrings_in.Count; d++) {
if (!dbConnectionStrings_in[d].enabled_aux__) continue;
switch (dbConnectionStrings_in[d].DBServerType) {
#if MySQL
case DBServerTypes.MySQL:
#endif
case DBServerTypes.SQLServer: {
if (dbConnectionStrings_in[d].exists_aux__)
dbConnectionStrings_in[d].Connection.SQLFunction_delete(_ouputTo);
break;
}
}
}
break;
}
case XS_OutputEnumeration.MySQL_StoredProcedure:
case XS_OutputEnumeration.SQLServer_StoredProcedure: {
//_con.SQLStoredProcedure_delete(_ouputTo);
for (int d = 0; d < dbConnectionStrings_in.Count; d++) {
if (!dbConnectionStrings_in[d].enabled_aux__) continue;
switch (dbConnectionStrings_in[d].DBServerType) {
#if MySQL
case DBServerTypes.MySQL:
#endif
case DBServerTypes.SQLServer: {
if (dbConnectionStrings_in[d].exists_aux__)
dbConnectionStrings_in[d].Connection.SQLStoredProcedure_delete(_ouputTo);
break;
}
}
}
break;
}
case XS_OutputEnumeration.MySQL_View:
case XS_OutputEnumeration.SQLServer_View: {
//_con.SQLView_delete(_ouputTo);
for (int d = 0; d < dbConnectionStrings_in.Count; d++) {
if (!dbConnectionStrings_in[d].enabled_aux__) continue;
switch (dbConnectionStrings_in[d].DBServerType) {
#if MySQL
case DBServerTypes.MySQL:
#endif
case DBServerTypes.SQLServer: {
if (dbConnectionStrings_in[d].exists_aux__)
dbConnectionStrings_in[d].Connection.SQLView_delete(_ouputTo);
break;
}
}
}
break;
}
case XS_OutputEnumeration.PostgreSQL_Function:
case XS_OutputEnumeration.PostgreSQL_StoredProcedure:
case XS_OutputEnumeration.PostgreSQL_View:
// No Need! unlike SQL Server and MySQL,
// PostgreSQL allows:
// "CREATE OR REPLACE FUNCTION/VIEW" :)
break;
default: {
break;
}
}
}
// #endregion
//_con.Execute_SQLQuery(_parsedOutput);
for (int d = 0; d < dbConnectionStrings_in.Count; d++) {
if (!dbConnectionStrings_in[d].enabled_aux__) continue;
try {
dbConnectionStrings_in[d].Connection.Execute_SQLQuery(_parsedOutput);
} catch (Exception _ex) {
System.Text.StringBuilder _sb = new System.Text.StringBuilder();
for (int a = 0; a < template_in.Arguments.ArgumentCollection.Count; a++) {
_sb.Append(string.Format(
System.Globalization.CultureInfo.CurrentCulture,
"{0}:\n\t{1}\n\t{2}\n",
template_in.Arguments.ArgumentCollection[a].Name,
template_in.Arguments.ArgumentCollection[a].Value,
_args[template_in.Arguments.ArgumentCollection[a].Name]
));
}
throw new Exception(string.Format(
System.Globalization.CultureInfo.CurrentCulture,
"---\nTEMPLATE: {0}\n---\nARGUMENTS:\n\n{5}\n---\nDBServerType:\n\n{2}\n---\nQUERY:\n\n{1}\n---\nEXCEPTION:\n\n{3}\n---\nINNER-EXCEPTION:\n\n{4}\n---\n",
template_in.Name,
_parsedOutput,
dbConnectionStrings_in[d].DBServerType.ToString(),
_ex.Message,
_ex.InnerException,
_sb.ToString()
));
}
}
break;
}
#endregion
default: {
throw notifyme_Exception;
}
}
}
}
}
}
public void Build(
OGen.Libraries.Generator.Build notifyBase_in,
Statistics statistics_in,
params string[] templateTypes_in
) {
#region string _outputDir = ...;
string _outputDir = this.ParentDirectoryname;
#endregion
if (notifyBase_in != null) notifyBase_in("generating...", true);
// ToDos: now! need to save MetadataDB to xml file
MetaFile[] _metafiles = new MetaFile[this.metadata_.MetadataFiles.MetadataFiles.Count];
for (int i = 0; i < this.metadata_.MetadataFiles.MetadataFiles.Count; i++) {
_metafiles[i] = new MetaFile(
Path.Combine(
this.Directoryname,
this.metadata_.MetadataFiles.MetadataFiles[i].XMLFileName
),
this.metadata_.MetadataFiles.MetadataFiles[i].XMLFileType
);
}
new OGenGenerator(
#if !NET_1_1
System.Configuration.ConfigurationManager.AppSettings
#else
System.Configuration.ConfigurationSettings.AppSettings
#endif
["Templates"],
this.metadata_dbconnectionstrings(),
_outputDir,
_metafiles
).Build(
notifyBase_in,
this.metadata_,
statistics_in,
templateTypes_in
);
if (notifyBase_in != null) notifyBase_in("...finished", true);
}
