public static XS__metadataDB Load_fromDB(
XS__metadataDB.Load_fromDBDelegate notifyBack_in,
string subAppName_in,
params DBSimpleConnectionstring[] dbConnectionParam_in
)
{
return(Load_fromDB(
notifyBack_in,
subAppName_in,
null,
0,
dbConnectionParam_in
));
}
public static XS__metadataDB Load_fromDB(
XS__metadataDB.Load_fromDBDelegate 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_ = ROOT + "." + METADATADB + "[" + index_in.ToString() + "]";
_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(
"#{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.getTables(
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.getTableFields(
// _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].FK_TableName;
}
else if (
(dbConnectionParam_in[c].DBServerType != DBServerTypes.MySQL)
)
{
_field.FKTableName = _fields_aux[f].FK_TableName;
}
#else
_field.FKTableName = _fields_aux[f].FK_TableName;
#endif
_field.FKFieldName = _fields_aux[f].FK_FieldName;
#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);
}
