///-------------------------------------------------------------------------------- /// <summary>This loads information from a MySQL table.</summary> /// /// <param name="sqlConnection">The input sql connection</param> /// <param name="variables">Database level variables</param> /// <param name="table">The table row data</param> /// <param name="columns">The columns table data</param> /// <param name="indexes">The indexes table data</param> /// <param name="indexColumns">The index columns table data</param> /// <param name="keys">The keys table data</param> /// <param name="keyColumns">The key columns table data</param> ///-------------------------------------------------------------------------------- public void LoadMySQLTable(MySqlConnection sqlConnection, NameObjectCollection variables, DataRow table, DataTable columns, DataTable indexes, DataTable indexColumns, DataTable keys, DataTable keyColumns) { try { // load table information foreach (DataColumn column in table.Table.Columns) { // load important properties into table, the rest as additional sql properties switch (column.ColumnName) { case "TABLE_NAME": SqlTableName = table[column.ColumnName].GetString(); break; case "CREATE_TIME": CreateDate = table[column.ColumnName].GetDateTime(); break; case "UPDATE_TIME": DateLastModified = table[column.ColumnName].GetDateTime(); break; default: SqlProperty property = new SqlProperty(); property.SqlPropertyID = Guid.NewGuid(); property.SqlTable = this; property.LoadMySQLProperty(column.ColumnName, null, table[column.ColumnName].GetString()); SqlPropertyList.Add(property); break; } } // load information for each column if (columns != null) { foreach (DataRow row in columns.Rows) { if (DebugHelper.DebugAction == DebugAction.Stop) { return; } if (row["TABLE_NAME"].GetString() == SqlTableName) { SqlColumn column = new SqlColumn(); column.SqlColumnID = Guid.NewGuid(); column.SqlTable = this; column.LoadMySQLColumn(sqlConnection, variables, row); SqlColumnList.Add(column); } } } // load information for each index if (indexes != null) { foreach (DataRow row in indexes.Rows) { if (DebugHelper.DebugAction == DebugAction.Stop) { return; } if (row["TABLE_NAME"].GetString() == SqlTableName) { SqlIndex index = new SqlIndex(); index.SqlIndexID = Guid.NewGuid(); index.SqlTable = this; index.LoadMySQLIndex(sqlConnection, variables, row, indexColumns); SqlIndexList.Add(index); } } } // load information for each foreign key if (keys != null) { foreach (DataRow row in keys.Rows) { if (DebugHelper.DebugAction == DebugAction.Stop) { return; } if (row["table_name"].GetString() == SqlTableName) { SqlForeignKey key = new SqlForeignKey(); key.SqlForeignKeyID = Guid.NewGuid(); key.SqlTable = this; key.LoadMySQLForeignKey(sqlConnection, variables, row, keyColumns); SqlForeignKeyList.Add(key); } } } } catch (ApplicationAbortException) { throw; } catch (Exception) { throw; } }