internal void Enforce(ISet <CheckResultAssocToFKey> result, LL.MDE.DataModels.SimpleRDBMS.ForeignKey fk) { foreach (CheckResultAssocToFKey match in result) { // Extracting variables binded in source domains LL.MDE.DataModels.SimpleUML.Association a = match.matchDomainA.a; string an = match.matchDomainA.an; LL.MDE.DataModels.SimpleUML.Package p = match.matchDomainA.p; LL.MDE.DataModels.SimpleUML.Class sc = match.matchDomainA.sc; string scn = match.matchDomainA.scn; LL.MDE.DataModels.SimpleUML.Class dc = match.matchDomainA.dc; string dcn = match.matchDomainA.dcn; // Assigning variables binded in the where clause string fkn = scn + "_" + an + "_" + dcn; string fcn = fkn + "_tid"; // Enforcing each enforced domain MatchDomainFk targetMatchDomainFk = EnforceFk(match, fkn, fcn, fk); // Retrieving variables binded in the enforced domains LL.MDE.DataModels.SimpleRDBMS.Table srcTbl = targetMatchDomainFk.srcTbl; LL.MDE.DataModels.SimpleRDBMS.Schema s = targetMatchDomainFk.s; LL.MDE.DataModels.SimpleRDBMS.Key pkey = targetMatchDomainFk.pkey; LL.MDE.DataModels.SimpleRDBMS.Table destTbl = targetMatchDomainFk.destTbl; LL.MDE.DataModels.SimpleRDBMS.Column cl = targetMatchDomainFk.cl; // Calling other relations as defined in the where clause } }
internal MatchDomainFk EnforceFk(CheckResultAssocToFKey checkresult, string fkn, string fcn, LL.MDE.DataModels.SimpleRDBMS.ForeignKey fk) { MatchDomainFk match = new MatchDomainFk(); LL.MDE.DataModels.SimpleUML.Association a = checkresult.matchDomainA.a; LL.MDE.DataModels.SimpleUML.Package p = checkresult.matchDomainA.p; LL.MDE.DataModels.SimpleUML.Class sc = checkresult.matchDomainA.sc; LL.MDE.DataModels.SimpleUML.Class dc = checkresult.matchDomainA.dc; // Querying when relations and storing results LL.MDE.DataModels.SimpleRDBMS.Schema s = transformation.RelationPackageToSchema.FindPreviousResult(p).s; LL.MDE.DataModels.SimpleRDBMS.Table srcTbl = transformation.RelationClassToTable.FindPreviousResult(sc).t; LL.MDE.DataModels.SimpleRDBMS.Table destTbl = transformation.RelationClassToTable.FindPreviousResult(dc).t; // Contructing fk editor.AddOrSetInField(fk, "name", fkn); //LL.MDE.DataModels.SimpleRDBMS.Table srcTbl = null; // srcTbl = (LL.MDE.DataModels.SimpleRDBMS.Table)editor.CreateNewObjectInField(fk, "owner"); LL.MDE.DataModels.SimpleRDBMS.Key pkey = null; pkey = (LL.MDE.DataModels.SimpleRDBMS.Key)editor.CreateNewObjectInField(fk, "key"); LL.MDE.DataModels.SimpleRDBMS.Column cl = null; cl = (LL.MDE.DataModels.SimpleRDBMS.Column)editor.CreateNewObjectInField(fk, "column"); // Contructing srcTbl // LL.MDE.DataModels.SimpleRDBMS.Schema s = null; // s = (LL.MDE.DataModels.SimpleRDBMS.Schema)editor.CreateNewObjectInField(srcTbl, "schema"); // Contructing s // Contructing pkey // LL.MDE.DataModels.SimpleRDBMS.Table destTbl = null; // destTbl = (LL.MDE.DataModels.SimpleRDBMS.Table)editor.CreateNewObjectInField(pkey, "owner"); // Contructing destTbl // Contructing cl editor.AddOrSetInField(cl, "type", "NUMBER"); editor.AddOrSetInField(cl, "name", fcn); // Return newly binded variables match.fk = fk; match.srcTbl = srcTbl; match.s = s; match.pkey = pkey; match.destTbl = destTbl; match.cl = cl; return(match); }
internal void CheckAndEnforce(LL.MDE.DataModels.SimpleUML.Association a, LL.MDE.DataModels.SimpleRDBMS.ForeignKey fk) { CheckOnlyDomains input = new CheckOnlyDomains(a); EnforceDomains output = new EnforceDomains(fk); if (traceabilityMap.ContainsKey(input) && !traceabilityMap[input].Equals(output)) { throw new Exception("This relation has already been used with different enforced parameters!"); } if (!traceabilityMap.ContainsKey(input)) { ISet <CheckResultAssocToFKey> result = Check(a); Enforce(result, fk); traceabilityMap[input] = output; } }
internal static ISet <CheckResultAssocToFKey> Check(LL.MDE.DataModels.SimpleUML.Association a) { ISet <CheckResultAssocToFKey> result = new HashSet <CheckResultAssocToFKey>(); ISet <MatchDomainA> matchDomainAs = CheckDomainA(a); foreach (MatchDomainA matchDomainA in matchDomainAs) { string an = matchDomainA.an; LL.MDE.DataModels.SimpleUML.Package p = matchDomainA.p; LL.MDE.DataModels.SimpleUML.Class sc = matchDomainA.sc; string scn = matchDomainA.scn; LL.MDE.DataModels.SimpleUML.Class dc = matchDomainA.dc; string dcn = matchDomainA.dcn; CheckResultAssocToFKey checkonlysMatch = new CheckResultAssocToFKey() { matchDomainA = matchDomainA, }; result.Add(checkonlysMatch); } // End foreach return(result); }
internal static ISet <MatchDomainA> CheckDomainA(LL.MDE.DataModels.SimpleUML.Association a) { ISet <MatchDomainA> result = new HashSet <MatchDomainA>(); if (a != null) { string an = (string)a.name; LL.MDE.DataModels.SimpleUML.Package p = (LL.MDE.DataModels.SimpleUML.Package)a.@namespace; LL.MDE.DataModels.SimpleUML.Class sc = (LL.MDE.DataModels.SimpleUML.Class)a.source; LL.MDE.DataModels.SimpleUML.Class dc = (LL.MDE.DataModels.SimpleUML.Class)a.destination; if (p != null) { if (sc != null) { string scn = (string)sc.name; if (dc != null) { string dcn = (string)dc.name; MatchDomainA match = new MatchDomainA() { a = a, an = an, p = p, sc = sc, scn = scn, dc = dc, dcn = dcn, }; result.Add(match); } } } } return(result); }
public EnforceDomains FindPreviousResult(LL.MDE.DataModels.SimpleUML.Association a) { CheckOnlyDomains input = new CheckOnlyDomains(a); return(traceabilityMap.ContainsKey(input) ? traceabilityMap[input] : null); }