public override string createPrivilege(Privilege privIn) { throw new NotImplementedException(); }
public override List <string> alterPrivilege(Privilege privIn) { throw new NotImplementedException(); }
public DbSyncPrivilegeDiff(Privilege privAin, Privilege privBin) { this.privA = privAin; this.privB = privBin; privAtrListA = new List <ObjectAtribute>(); privAtrListB = new List <ObjectAtribute>(); if (privA == null || privB == null) { if (privA != null) { this.privilegeName = privA.Grantee + " " + privA.Privilege_type; privAtrListA.Add(new ObjectAtribute("Object name", privA.Table_name, true)); privAtrListA.Add(new ObjectAtribute("Grantee", privA.Grantee, true)); //privAtrListA.Add(new ObjectAtribute("Is Grantable", privA.Is_grantable.ToString(), true)); privAtrListA.Add(new ObjectAtribute("Privilege type", privA.Privilege_type, true)); } else if (privB != null) { this.privilegeName = privB.Grantee + " " + privB.Privilege_type; privAtrListB.Add(new ObjectAtribute("Object name", privB.Table_name, true)); privAtrListB.Add(new ObjectAtribute("Grantee", privB.Grantee, true)); //privAtrListB.Add(new ObjectAtribute("Is Grantable", privB.Is_grantable.ToString(), true)); privAtrListB.Add(new ObjectAtribute("Privilege type", privB.Privilege_type, true)); } else { this.privilegeName = "UNDEFINED"; } } if (privA != null && privB != null) { this.privilegeName = privA.Grantee + " " + privA.Privilege_type; if (privA.Grantee != privB.Grantee) { diffGrantee = true; } //if (privA.Is_grantable != privB.Is_grantable) diffISGrantable = true; if (privA.Table_name != privB.Table_name) { diffTableNAme = true; } if (privA.Privilege_type != privB.Privilege_type) { diffprivilegeType = true; } if (diffGrantee || diffISGrantable || diffprivilegeType || diffTableNAme) { different = true; } else { different = false; } ObjectAtribute cObjectname = new ObjectAtribute("Object name ", privA.Table_name, false); privAtrListA.Add(cObjectname); privAtrListB.Add(cObjectname); if (diffGrantee) { ObjectAtribute cGranteA = new ObjectAtribute("Grantee ", privA.Grantee, true); privAtrListA.Add(cGranteA); ObjectAtribute cGranteB = new ObjectAtribute("Grantee ", privB.Grantee, true); privAtrListB.Add(cGranteB); } else { ObjectAtribute cGrantee = new ObjectAtribute("Grantee ", privB.Grantee, false); privAtrListA.Add(cGrantee); privAtrListB.Add(cGrantee); } /*if (diffISGrantable) * { * ObjectAtribute cIsGrantableA = new ObjectAtribute("Is Grantable ", privA.Is_grantable.ToString(), true); * privAtrListA.Add(cIsGrantableA); * ObjectAtribute cIsGrantableB = new ObjectAtribute("Is Grantable ", privB.Is_grantable.ToString(), true); * privAtrListB.Add(cIsGrantableB); * } * else * { * ObjectAtribute cIsGrantable = new ObjectAtribute("Is Grantable ", privB.Is_grantable.ToString(), false); * privAtrListA.Add(cIsGrantable); * privAtrListB.Add(cIsGrantable); * } */ if (diffprivilegeType) { ObjectAtribute cPrivilegeTypeA = new ObjectAtribute("Privilege type ", privA.Privilege_type, true); privAtrListA.Add(cPrivilegeTypeA); ObjectAtribute cPrivilegeTypeB = new ObjectAtribute("Privilege type ", privB.Privilege_type, true); privAtrListB.Add(cPrivilegeTypeB); } else { ObjectAtribute cPrivilegeType = new ObjectAtribute("Privilege type ", privB.Privilege_type, false); privAtrListA.Add(cPrivilegeType); privAtrListB.Add(cPrivilegeType); } } else { different = true; } }