public WorkerThread(
System.Threading.Thread thread_int,
DBConnectionstrings dbConnectionstrings_in
)
{
this.Thread = thread_int;
this.DBConnectionstrings = dbConnectionstrings_in;
}
/// <summary>
/// ToDos: here! (use if you're generating code on a Database)
/// </summary>
/// <param name="xmlTemplatesFile_in">ToDos: here!</param>
/// <param name="dbConnectionStrings_in">Database Connectionstring (use if you're generating code on a Database)</param>
/// <param name="outputDir_in">ToDos: here!</param>
/// <param name="metaFiles_in">ToDos: here!</param>
public OGenGenerator(
string xmlTemplatesFile_in,
DBConnectionstrings dbConnectionStrings_in,
string outputDir_in,
params MetaFile[] metaFiles_in
) {
//---
this.xmltemplatesfileuri_ = new Uri(xmlTemplatesFile_in);
this.dbconnectionstrings_ = dbConnectionStrings_in;
this.outputdir_ = outputDir_in;
this.metafiles_ = metaFiles_in;
//---
}
/// <summary>
/// ToDos: here! (use if you're generating code on a Database)
/// </summary>
/// <param name="xmlTemplatesFile_in">ToDos: here!</param>
/// <param name="dbConnectionStrings_in">Database Connectionstring (use if you're generating code on a Database)</param>
/// <param name="outputDir_in">ToDos: here!</param>
/// <param name="metaFiles_in">ToDos: here!</param>
public OGenGenerator(
string xmlTemplatesFile_in,
DBConnectionstrings dbConnectionStrings_in,
string outputDir_in,
params MetaFile[] metaFiles_in
)
{
//---
this.xmltemplatesfileuri_ = new Uri(xmlTemplatesFile_in);
this.dbconnectionstrings_ = dbConnectionStrings_in;
this.outputdir_ = outputDir_in;
this.metafiles_ = metaFiles_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
}
public WorkerThread(
System.Threading.Thread thread_int,
DBConnectionstrings dbConnectionstrings_in
) {
this.Thread = thread_int;
this.DBConnectionstrings = dbConnectionstrings_in;
}
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;
}
}
}
}
}
}
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
);
}
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;
}
}
}
}
}
}
// #endregion
#region private DBConnectionstrings metadata_dbconnectionstrings();
private DBConnectionstrings metadata_dbconnectionstrings(
) {
//#region int _paramCount = ...;
//int _paramCount = 0;
//for (int d = 0; d < metadata_.MetadataExtendedCollection[0].DBs.DBCollection.Count; d++)
// for (int c = 0; c < metadata_.MetadataExtendedCollection[0].DBs.DBCollection[d].DBConnections.DBConnectionCollection.Count; c++)
// if (metadata_.MetadataExtendedCollection[0].DBs.DBCollection[d].DBConnections.DBConnectionCollection[c].generateSQL)
// _paramCount++;
//#endregion
//DBSimpleConnectionstring[] _output = new DBSimpleConnectionstring[_paramCount];
//_paramCount = 0;
//for (int d = 0; d < metadata_.MetadataExtendedCollection[0].DBs.DBCollection.Count; d++) {
// for (int c = 0; c < metadata_.MetadataExtendedCollection[0].DBs.DBCollection[d].DBConnections.DBConnectionCollection.Count; c++) {
// if (metadata_.MetadataExtendedCollection[0].DBs.DBCollection[d].DBConnections.DBConnectionCollection[c].generateSQL) {
// _output[_paramCount] = new DBSimpleConnectionstring(
// (DBServerTypes)Enum.Parse(
// typeof(DBServerTypes),
// metadata_.MetadataExtendedCollection[0].DBs.DBCollection[d].DBServerType
// ),
// metadata_.MetadataExtendedCollection[0].DBs.DBCollection[d].DBConnections.DBConnectionCollection[c].Connectionstring
// );
// _paramCount++;
// }
// }
//}
//return _output;
DBConnectionstrings _output = new DBConnectionstrings();
for (int d = 0; d < this.metadata_.MetadataExtendedCollection[0].DBs.DBCollection.Count; d++) {
if (this.metadata_.MetadataExtendedCollection[0].DBs.DBCollection[d].GenerateSQL) {
_output.Add(
(DBServerTypes)Enum.Parse(
typeof(DBServerTypes),
this.metadata_.MetadataExtendedCollection[0].DBs.DBCollection[d].DBServerType
),
this.metadata_.MetadataExtendedCollection[0].DBs.DBCollection[d].ConnectionString
);
}
}
return _output;
}
