public static XS__metadataDB[] Load_fromURI(
XS__RootMetadata root_ref_in,
params Uri[] filePath_in
) {
XS__metadataDB[] _output
= new XS__metadataDB[filePath_in.Length];
for (int i = 0; i < filePath_in.Length; i++) {
if (filePath_in[i].IsFile) {
_output[i] = XS__metadataDB.Load_fromFile(
filePath_in[i].LocalPath
)[0];
// no need! everything's been taken care at: XS__metadataDB.Load_fromFile(...)
//_output[i].root_metadatadb_ = ROOT + "." + METADATADB + "[" + i + "]";
//_output[i].parent_ref = root_ref_in; // ToDos: now!
//if (root_ref_in != null) _output[i].root_ref = root_ref_in;
} else {
try {
_output[i] = (XS__metadataDB)new XmlSerializer(typeof(XS__metadataDB)).Deserialize(
OGen.Libraries.PresentationLayer.WebForms.Utilities.ReadURL(
filePath_in[i].ToString()
)
);
} catch (Exception _ex) {
throw new Exception(string.Format(
System.Globalization.CultureInfo.CurrentCulture,
"\n---\n{0}.{1}.Load_fromURI():\nERROR READING XML:\n{2}\n---\n{3}",
typeof(XS__metadataDB).Namespace,
typeof(XS__metadataDB).Name,
//(filePath_in[i].IsFile)
// ? filePath_in[i].LocalPath
// :
filePath_in[i].ToString(),
_ex.Message
));
}
_output[i].root_metadatadb_ = ROOT + "." + METADATADB + "[" + i + "]";
_output[i].parent_ref = root_ref_in; // ToDos: now!
if (root_ref_in != null) _output[i].root_ref = root_ref_in;
}
}
return _output;
}
public static XS__metadataDB[] Load_fromFile(
XS__RootMetadata root_ref_in,
params string[] filePath_in
) {
FileStream _stream;
XS__metadataDB[] _output
= new XS__metadataDB[filePath_in.Length];
for (int i = 0; i < filePath_in.Length; i++) {
_stream = new FileStream(
filePath_in[i],
FileMode.Open,
FileAccess.Read,
FileShare.Read
);
try {
_output[i] = (XS__metadataDB)new XmlSerializer(typeof(XS__metadataDB)).Deserialize(
_stream
);
_stream.Close();
#if !NET_1_1
_stream.Dispose();
#endif
} catch (Exception _ex) {
throw new Exception(string.Format(
System.Globalization.CultureInfo.CurrentCulture,
"\n---\n{0}.{1}.Load_fromFile():\nERROR READING XML:\n{2}\n---\n{3}\n---\n{4}\n---\n",
typeof(XS__metadataDB).Namespace,
typeof(XS__metadataDB).Name,
filePath_in[i],
_ex.Message,
_ex.InnerException
));
}
_output[i].root_metadatadb_ = ROOT + "." + METADATADB + "[" + i + "]";
_output[i].parent_ref = root_ref_in; // ToDos: now!
if (root_ref_in != null) _output[i].root_ref = root_ref_in;
}
return _output;
}
public XS__metadataDBCollection(
XS__metadataDB[] metadatadbcollection_in
) : base (
metadatadbcollection_in
) {
}
public XS__metadataDBCollection(
#endif
XS__metadataDB[] metadataDBCollection_in
) {
this.metadatadbcollection_ = metadataDBCollection_in;
}
public XS__RootMetadata(
#endif
string metadataFilepath_in
)
{
string _metadataPath = System.IO.Path.GetDirectoryName(metadataFilepath_in);
metadatafiles_ = Metadatas.Load_fromFile(metadataFilepath_in);
#region int _total_xxx = ...;
int _total_metadataextended = 0;
int _total_metadatadb = 0;
int _total_metadatabusiness = 0;
for (int f = 0; f < metadatafiles_.MetadataFiles.Count; f++)
{
switch (metadatafiles_.MetadataFiles[f].XMLFileType)
{
case XS__metadataExtended.METADATAEXTENDED:
_total_metadataextended++;
break;
case XS__metadataDB.METADATADB:
_total_metadatadb++;
break;
case XS__metadataBusiness.METADATABUSINESS:
_total_metadatabusiness++;
break;
}
}
#endregion
#region string[] _xxxFilepath = new string[_total_xxx];
string[] _metadataextendedFilepath = new string[
_total_metadataextended
];
string[] _metadatadbFilepath = new string[
_total_metadatadb
];
string[] _metadatabusinessFilepath = new string[
_total_metadatabusiness
];
#endregion
_total_metadataextended = 0;
_total_metadatadb = 0;
_total_metadatabusiness = 0;
for (int f = 0; f < metadatafiles_.MetadataFiles.Count; f++)
{
switch (metadatafiles_.MetadataFiles[f].XMLFileType)
{
case XS__metadataExtended.METADATAEXTENDED:
_metadataextendedFilepath[_total_metadataextended] = System.IO.Path.Combine(
_metadataPath,
metadatafiles_.MetadataFiles[f].XMLFilename
);
_total_metadataextended++;
break;
case XS__metadataDB.METADATADB:
_metadatadbFilepath[_total_metadatadb] = System.IO.Path.Combine(
_metadataPath,
metadatafiles_.MetadataFiles[f].XMLFilename
);
_total_metadatadb++;
break;
case XS__metadataBusiness.METADATABUSINESS:
_metadatabusinessFilepath[_total_metadatabusiness] = System.IO.Path.Combine(
_metadataPath,
metadatafiles_.MetadataFiles[f].XMLFilename
);
_total_metadatabusiness++;
break;
}
}
metadataextendedcollection_ = new XS__metadataExtendedCollection(
XS__metadataExtended.Load_fromFile(
(XS__RootMetadata)this,
_metadataextendedFilepath
)
);
metadatadbcollection_ = new XS__metadataDBCollection(
XS__metadataDB.Load_fromFile(
(XS__RootMetadata)this,
_metadatadbFilepath
)
);
metadatabusinesscollection_ = new XS__metadataBusinessCollection(
XS__metadataBusiness.Load_fromFile(
(XS__RootMetadata)this,
_metadatabusinessFilepath
)
);
}
public static XS__metadataDB Load_fromDB(
OGen.NTier.Libraries.Metadata.MetadataDB.Load_fromDatabase notifyBack_in,
string subAppName_in,
XS__RootMetadata root_ref_in,
int index_in,
params DBSimpleConnectionstring[] dbConnectionParam_in
) {
#region XS__metadataDB _output = ...;
XS__metadataDB _output = new XS__metadataDB();
_output.root_metadatadb_ = string.Concat(ROOT, ".", METADATADB, "[", index_in.ToString(System.Globalization.CultureInfo.CurrentCulture), "]");
_output.parent_ref = root_ref_in; // ToDos: now!
if (root_ref_in != null) _output.root_ref = root_ref_in;
#endregion
bool _getTables_exists;
bool _getTableFields_exists;
DBConnection _connection;
DBTable[] _tables_aux;
DBTableField[] _fields_aux;
XS_tableType _table;
XS_tableDBType _tabledb;
XS_tableFieldType _field;
XS_tableFieldDBType _fielddb;
int _searchindex;
const string OGEN_SP0__GETTABLEFIELDS = "OGen_sp0__getTableFields";
const string OGEN_SP0__GETTABLES = "OGen_sp0__getTables";
for (int c = 0; c < dbConnectionParam_in.Length; c++) {
#region notifyBack_in(...);
if (notifyBack_in != null) {
notifyBack_in(
string.Format(
System.Globalization.CultureInfo.CurrentCulture,
"#{0}/{1} - {2}",
c + 1,
dbConnectionParam_in.Length,
dbConnectionParam_in[c].DBServerType.ToString()
),
true
);
}
#endregion
_connection = DBConnectionsupport.CreateInstance(
dbConnectionParam_in[c].DBServerType,
dbConnectionParam_in[c].Connectionstring
);
#region _tables_aux = ...;
_getTables_exists = _connection.SQLStoredProcedure_exists(OGEN_SP0__GETTABLES);
_tables_aux = _connection.SchemaDatabaseTables(
subAppName_in,
_getTables_exists
? OGEN_SP0__GETTABLES
: string.Empty
);
#endregion
#region _fields_aux = ...;
switch ((DBServerTypes)Enum.Parse(typeof(DBServerTypes), _connection.DBServerType)) {
#if PostgreSQL
case DBServerTypes.PostgreSQL:
_getTableFields_exists = _connection.SQLFunction_exists(OGEN_SP0__GETTABLEFIELDS);
break;
#endif
default:
_getTableFields_exists = _connection.SQLStoredProcedure_exists(OGEN_SP0__GETTABLEFIELDS);
break;
}
_fields_aux = _connection.SchemaDatabaseTableFields(
// _tables_aux[t].Name, // get's specific table fields
string.Empty, // get's fields for all tables
_getTableFields_exists
? OGEN_SP0__GETTABLEFIELDS
: string.Empty
);
#endregion
for (int t = 0; t < _tables_aux.Length; t++) {
#region _table = ...; _table.Name = ...;
_searchindex = _output.Tables.TableCollection.Search(
_tables_aux[t].Name
);
if (_searchindex >= 0) {
_table = _output.Tables.TableCollection[_searchindex];
} else {
_table = new XS_tableType(
_tables_aux[t].Name
);
_output.Tables.TableCollection.Add(_table);
}
#endregion
_table.IsVirtualTable = _tables_aux[t].IsVirtualTable;
#region _tabledb = ...; _tabledb.DBServerType = ...;
_searchindex = _table.TableDBs.TableDBCollection.Search(
dbConnectionParam_in[c].DBServerType.ToString()
);
if (_searchindex >= 0) {
_tabledb = _table.TableDBs.TableDBCollection[_searchindex];
} else {
_tabledb = new XS_tableDBType(
dbConnectionParam_in[c].DBServerType.ToString()
);
_table.TableDBs.TableDBCollection.Add(_tabledb);
}
#endregion
_tabledb.DBTableName = _tables_aux[t].Name;
_tabledb.DBDescription = _tables_aux[t].DBDescription;
for (int f = 0; f < _fields_aux.Length; f++) {
if (
#if MySQL
(
(dbConnectionParam_in[c].DBServerType == DBServerTypes.MySQL)
&&
(_tables_aux[t].Name.ToLower() != _fields_aux[f].TableName.ToLower())
)
||
#endif
(_tables_aux[t].Name != _fields_aux[f].TableName)
) {
continue;
}
#region _field = ...; _field.Name = ...;
_searchindex = _table.TableFields.TableFieldCollection.Search(
_fields_aux[f].Name
);
if (_searchindex >= 0) {
_field = _table.TableFields.TableFieldCollection[_searchindex];
} else {
_field = new XS_tableFieldType(
_fields_aux[f].Name
);
_table.TableFields.TableFieldCollection.Add(_field);
}
#endregion
_field.IsPK = _fields_aux[f].IsPK;
_field.IsIdentity = _fields_aux[f].IsIdentity;
_field.IsNullable = _fields_aux[f].IsNullable;
_field.NumericPrecision = _fields_aux[f].Numeric_Precision;
_field.NumericScale = _fields_aux[f].Numeric_Scale;
_field.Size = _fields_aux[f].Size;
#if MySQL
if (
(dbConnectionParam_in[c].DBServerType == DBServerTypes.MySQL)
&&
(_field.FKTableName == string.Empty)
) {
_field.FKTableName = _fields_aux[f].ForeignKey_TableName;
} else if (
(dbConnectionParam_in[c].DBServerType != DBServerTypes.MySQL)
) {
_field.FKTableName = _fields_aux[f].ForeignKey_TableName;
}
#else
_field.FKTableName = _fields_aux[f].ForeignKey_TableName;
#endif
_field.FKFieldName = _fields_aux[f].ForeignKey_TableFieldName;
#region _fielddb = ...; _fielddb.DBServerType = ...;
_searchindex = _field.TableFieldDBs.TableFieldDBCollection.Search(
dbConnectionParam_in[c].DBServerType
);
if (_searchindex >= 0) {
_fielddb = _field.TableFieldDBs.TableFieldDBCollection[_searchindex];
} else {
_fielddb = new XS_tableFieldDBType(
dbConnectionParam_in[c].DBServerType.ToString()
);
_field.TableFieldDBs.TableFieldDBCollection.Add(_fielddb);
}
#endregion
_fielddb.DBType = _fields_aux[f].DBType_inDB_name;
_fielddb.DBDescription = _fields_aux[f].DBDescription;
_fielddb.DBDefaultValue = _fields_aux[f].DBDefaultValue;
_fielddb.DBCollationName = _fields_aux[f].DBCollationName;
_fielddb.DBFieldName = _fields_aux[f].Name;
}
}
}
return _output;
}
public static XS__metadataDB Load_fromDB(
OGen.NTier.Libraries.Metadata.MetadataDB.Load_fromDatabase notifyBack_in,
string subAppName_in,
XS__RootMetadata root_ref_in,
int index_in,
params DBSimpleConnectionstring[] dbConnectionParam_in
)
{
#region XS__metadataDB _output = ...;
XS__metadataDB _output = new XS__metadataDB();
_output.root_metadatadb_ = string.Concat(ROOT, ".", METADATADB, "[", index_in.ToString(System.Globalization.CultureInfo.CurrentCulture), "]");
_output.parent_ref = root_ref_in; // ToDos: now!
if (root_ref_in != null)
{
_output.root_ref = root_ref_in;
}
#endregion
bool _getTables_exists;
bool _getTableFields_exists;
DBConnection _connection;
DBTable[] _tables_aux;
DBTableField[] _fields_aux;
XS_tableType _table;
XS_tableDBType _tabledb;
XS_tableFieldType _field;
XS_tableFieldDBType _fielddb;
int _searchindex;
const string OGEN_SP0__GETTABLEFIELDS = "OGen_sp0__getTableFields";
const string OGEN_SP0__GETTABLES = "OGen_sp0__getTables";
for (int c = 0; c < dbConnectionParam_in.Length; c++)
{
#region notifyBack_in(...);
if (notifyBack_in != null)
{
notifyBack_in(
string.Format(
System.Globalization.CultureInfo.CurrentCulture,
"#{0}/{1} - {2}",
c + 1,
dbConnectionParam_in.Length,
dbConnectionParam_in[c].DBServerType.ToString()
),
true
);
}
#endregion
_connection = DBConnectionsupport.CreateInstance(
dbConnectionParam_in[c].DBServerType,
dbConnectionParam_in[c].Connectionstring
);
#region _tables_aux = ...;
_getTables_exists = _connection.SQLStoredProcedure_exists(OGEN_SP0__GETTABLES);
_tables_aux = _connection.SchemaDatabaseTables(
subAppName_in,
_getTables_exists
? OGEN_SP0__GETTABLES
: string.Empty
);
#endregion
#region _fields_aux = ...;
switch ((DBServerTypes)Enum.Parse(typeof(DBServerTypes), _connection.DBServerType))
{
#if PostgreSQL
case DBServerTypes.PostgreSQL:
_getTableFields_exists = _connection.SQLFunction_exists(OGEN_SP0__GETTABLEFIELDS);
break;
#endif
default:
_getTableFields_exists = _connection.SQLStoredProcedure_exists(OGEN_SP0__GETTABLEFIELDS);
break;
}
_fields_aux = _connection.SchemaDatabaseTableFields(
// _tables_aux[t].Name, // get's specific table fields
string.Empty, // get's fields for all tables
_getTableFields_exists
? OGEN_SP0__GETTABLEFIELDS
: string.Empty
);
#endregion
for (int t = 0; t < _tables_aux.Length; t++)
{
#region _table = ...; _table.Name = ...;
_searchindex = _output.Tables.TableCollection.Search(
_tables_aux[t].Name
);
if (_searchindex >= 0)
{
_table = _output.Tables.TableCollection[_searchindex];
}
else
{
_table = new XS_tableType(
_tables_aux[t].Name
);
_output.Tables.TableCollection.Add(_table);
}
#endregion
_table.IsVirtualTable = _tables_aux[t].IsVirtualTable;
#region _tabledb = ...; _tabledb.DBServerType = ...;
_searchindex = _table.TableDBs.TableDBCollection.Search(
dbConnectionParam_in[c].DBServerType.ToString()
);
if (_searchindex >= 0)
{
_tabledb = _table.TableDBs.TableDBCollection[_searchindex];
}
else
{
_tabledb = new XS_tableDBType(
dbConnectionParam_in[c].DBServerType.ToString()
);
_table.TableDBs.TableDBCollection.Add(_tabledb);
}
#endregion
_tabledb.DBTableName = _tables_aux[t].Name;
_tabledb.DBDescription = _tables_aux[t].DBDescription;
for (int f = 0; f < _fields_aux.Length; f++)
{
if (
#if MySQL
(
(dbConnectionParam_in[c].DBServerType == DBServerTypes.MySQL)
&&
(_tables_aux[t].Name.ToLower() != _fields_aux[f].TableName.ToLower())
)
||
#endif
(_tables_aux[t].Name != _fields_aux[f].TableName)
)
{
continue;
}
#region _field = ...; _field.Name = ...;
_searchindex = _table.TableFields.TableFieldCollection.Search(
_fields_aux[f].Name
);
if (_searchindex >= 0)
{
_field = _table.TableFields.TableFieldCollection[_searchindex];
}
else
{
_field = new XS_tableFieldType(
_fields_aux[f].Name
);
_table.TableFields.TableFieldCollection.Add(_field);
}
#endregion
_field.IsPK = _fields_aux[f].IsPK;
_field.IsIdentity = _fields_aux[f].IsIdentity;
_field.IsNullable = _fields_aux[f].IsNullable;
_field.NumericPrecision = _fields_aux[f].Numeric_Precision;
_field.NumericScale = _fields_aux[f].Numeric_Scale;
_field.Size = _fields_aux[f].Size;
#if MySQL
if (
(dbConnectionParam_in[c].DBServerType == DBServerTypes.MySQL)
&&
(_field.FKTableName == string.Empty)
)
{
_field.FKTableName = _fields_aux[f].ForeignKey_TableName;
}
else if (
(dbConnectionParam_in[c].DBServerType != DBServerTypes.MySQL)
)
{
_field.FKTableName = _fields_aux[f].ForeignKey_TableName;
}
#else
_field.FKTableName = _fields_aux[f].ForeignKey_TableName;
#endif
_field.FKFieldName = _fields_aux[f].ForeignKey_TableFieldName;
#region _fielddb = ...; _fielddb.DBServerType = ...;
_searchindex = _field.TableFieldDBs.TableFieldDBCollection.Search(
dbConnectionParam_in[c].DBServerType
);
if (_searchindex >= 0)
{
_fielddb = _field.TableFieldDBs.TableFieldDBCollection[_searchindex];
}
else
{
_fielddb = new XS_tableFieldDBType(
dbConnectionParam_in[c].DBServerType.ToString()
);
_field.TableFieldDBs.TableFieldDBCollection.Add(_fielddb);
}
#endregion
_fielddb.DBType = _fields_aux[f].DBType_inDB_name;
_fielddb.DBDescription = _fields_aux[f].DBDescription;
_fielddb.DBDefaultValue = _fields_aux[f].DBDefaultValue;
_fielddb.DBCollationName = _fields_aux[f].DBCollationName;
_fielddb.DBFieldName = _fields_aux[f].Name;
}
}
}
return(_output);
}
