public void TestGetDistinctConstraintNames()
{
var testData = new NoFuture.Hbm.DbQryContainers.SortedKeys();
var testOutput = new List<ColumnMetadata>();
var testResult = testData.GetKeyManyToOneColumns("dbo.TableWithCompositePk", ref testOutput);
Assert.IsTrue(testResult);
}
public void TestConstraintNameComparer()
{
var testData = new NoFuture.Hbm.DbQryContainers.SortedKeys();
var testOutput = new List<ColumnMetadata>();
var testInput = testData.GetKeyManyToOneColumns("dbo.TableWithCompositePk", ref testOutput);
foreach(var cd in testOutput)
System.Diagnostics.Debug.WriteLine(cd.constraint_name);
var testResult = testOutput.Distinct(new ConstraintNameComparer()).ToList();
Assert.AreEqual(1,testResult.Count);
}
/// <summary>
/// Generates JSON formatted file whose contents are of form and fit to many-to-one nodes of an hbm.xml file.
/// This is the second of the three hbm sorting cmdlets that should
/// be called.
///
/// The effort of this cmdlet is to determine, of all
/// tables having a primary key, what this tables foreign keys
/// are which were not already accounted for as part of a
/// composite-id primary key by the former cmdlet.
/// </summary>
/// <param name="sortedKeys">The output of GetHbmDbPkData</param>
/// <returns></returns>
public static SortedOneToMany GetHbmDbFkData(SortedKeys sortedKeys)
{
var pkItems = sortedKeys.Data;
//get load/re-load psobjects to have output paths matching current settings
Settings.LoadOutputPathCurrentSettings();
//get needed json
var cnJson = DbContainers.Fks.Data;
var pkJson = DbContainers.Pks.Data;
var akJson = DbContainers.AllKeys.Data;
var aiJson = DbContainers.AllIndex.Data;
var colJson = DbContainers.AllColumns.Data;
//get a list of all the tables having a primary key
var fks = new Dictionary<string, FkItem>();
var allTables = pkJson.Select(x => x.table_name).Distinct();
//proceed through each table
foreach (var tbl in allTables)
{
var fkManifold = GetHbmDistinctFks(tbl);
var iFkManifold = GetHbmFksNoRelToPks(fkManifold, pkItems, tbl);
//produce output that is not already represented in the pk json hash
if (iFkManifold == null || iFkManifold.Keys.Count <= 0)
continue;
foreach (var iFkKeyValue in iFkManifold.Keys)
{
//by constraint_name find the json entry for this table
var residentTableJsonData =
cnJson.First(
x => string.Equals(x.table_name, tbl, C) && string.Equals(x.constraint_name, iFkKeyValue, C));
//from json data entry discover the matching unique_constraint_name
var fkConstraintName = residentTableJsonData.unique_constraint_name;
//find the table-name this FK's unique_constraint_name is referring to
var matchedTable = akJson.FirstOrDefault(x => string.Equals(x.constraint_name, fkConstraintName)) ??
aiJson.First(x => string.Equals(x.constraint_name, fkConstraintName));
var matchedTableName = matchedTable.table_name;
//get all the columns, not just first
var matchedFkColumns =
cnJson.Where(
x => string.Equals(x.table_name, tbl, C) && string.Equals(x.constraint_name, iFkKeyValue, C))
.ToList();
foreach(var matchCol in matchedFkColumns)
matchCol.CopyFromDataSrc(colJson);
if (!fks.ContainsKey(tbl))
{
var fkItem = new FkItem
{
ManyToOne = new Dictionary<string, List<ColumnMetadata>>
{
{matchedTableName, matchedFkColumns}
}
};
fks.Add(tbl, fkItem);
}
else if (!fks[tbl].ManyToOne.ContainsKey(matchedTableName))
{
fks[tbl].ManyToOne.Add(matchedTableName, matchedFkColumns);
}
else
{
fks[tbl].ManyToOne[matchedTableName].AddRange(matchedFkColumns);
}
}
}
return new SortedOneToMany() {Data = fks};
}
