public int Search(XS_templateType collectionItem_in)
{
for (int i = 0; i < this.cols_.Count; i++)
{
if (
(
#if NET_1_1
((XS_templateType)this.cols_[i])
#else
this.cols_[i]
#endif
.ID.Equals(
collectionItem_in.ID,
StringComparison.CurrentCulture
)
)
)
{
return(i);
}
}
return(-1);
}
public void CopyFrom(XS_templateType templateType_in)
{
this.id_ = templateType_in.id_;
this.name_ = templateType_in.name_;
this.templatetype_ = templateType_in.templatetype_;
this.parsertype_ = templateType_in.parsertype_;
this.iterationtype_ = templateType_in.iterationtype_;
if (templateType_in.arguments__ != null)
{
this.arguments__.CopyFrom(templateType_in.arguments__);
}
if (templateType_in.conditions__ != null)
{
this.conditions__.CopyFrom(templateType_in.conditions__);
}
if (templateType_in.outputs__ != null)
{
this.outputs__.CopyFrom(templateType_in.outputs__);
}
if (templateType_in.dependencies__ != null)
{
this.dependencies__.CopyFrom(templateType_in.dependencies__);
}
}
public int Search(XS_templateType collectionItem_in) {
for (int i = 0; i < this.cols_.Count; i++) {
if (
(
#if NET_1_1
((XS_templateType)this.cols_[i])
#else
this.cols_[i]
#endif
.ID.Equals(
collectionItem_in.ID,
StringComparison.CurrentCulture
)
)
) {
return i;
}
}
return -1;
}
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 CopyFrom(XS_templateType templateType_in) {
this.id_ = templateType_in.id_;
this.name_ = templateType_in.name_;
this.templatetype_ = templateType_in.templatetype_;
this.parsertype_ = templateType_in.parsertype_;
this.iterationtype_ = templateType_in.iterationtype_;
if (templateType_in.arguments__ != null) this.arguments__.CopyFrom(templateType_in.arguments__);
if (templateType_in.conditions__ != null) this.conditions__.CopyFrom(templateType_in.conditions__);
if (templateType_in.outputs__ != null) this.outputs__.CopyFrom(templateType_in.outputs__);
if (templateType_in.dependencies__ != null) this.dependencies__.CopyFrom(templateType_in.dependencies__);
}
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;
}
}
}
}
}
}