public void GetPoliciesTest_AddDynamicIScriptPolicies() { EnterpriseConfiguration cfg = new EnterpriseConfiguration(); ScriptPolicy pol1 = new ScriptPolicy(); pol1.PolicyId = PolicyIdKey.WithNoLockPolicy; pol1.Enforce = true; ScriptPolicy pol2 = new ScriptPolicy(); pol2.PolicyId = PolicyIdKey.GrantExecutePolicy; pol2.Enforce = true; cfg.ScriptPolicy = new ScriptPolicy[] { pol1, pol2 }; EnterpriseConfigHelper.EnterpriseConfig = cfg; List <IScriptPolicy> actual; actual = PolicyHelper.GetPolicies(); Assert.IsTrue(actual.Count == 2, "Expected 2 policies but got " + actual.Count.ToString()); Assert.IsTrue(actual[0] is WithNoLockPolicy); Assert.IsTrue(actual[1] is GrantExecutePolicy); }
public void GetPoliciesTest_AddDynamicStoredProcParamPolicies() { EnterpriseConfiguration cfg = new EnterpriseConfiguration(); ScriptPolicyArgument arg = new ScriptPolicyArgument(); arg.Name = "Schema"; arg.Value = "dbo"; ScriptPolicy pol1 = new ScriptPolicy(); pol1.PolicyId = PolicyIdKey.StoredProcParameterPolicy; pol1.Enforce = true; pol1.Argument = new ScriptPolicyArgument[] { arg }; ScriptPolicy pol2 = new ScriptPolicy(); pol2.PolicyId = PolicyIdKey.StoredProcParameterPolicy; pol2.Enforce = true; pol2.Argument = new ScriptPolicyArgument[] { arg }; cfg.ScriptPolicy = new ScriptPolicy[] { pol1, pol2 }; EnterpriseConfigHelper.EnterpriseConfig = cfg; List <IScriptPolicy> actual; actual = PolicyHelper.GetPolicies(); Assert.IsTrue(actual.Count == 2, "Expected 2 policies but got " + actual.Count.ToString()); Assert.IsTrue(actual[0] is StoredProcParameterPolicy); Assert.IsTrue(actual[1] is StoredProcParameterPolicy); }
public void GetPoliciesTest_GetStandardIScriptPolicy() { EnterpriseConfigHelper.EnterpriseConfig = new EnterpriseConfiguration(); List <IScriptPolicy> actual; actual = PolicyHelper.GetPolicies(); Assert.IsTrue(actual.Count == 9, "Expected 9 policies and got " + actual.Count.ToString()); Assert.IsTrue(actual[0] is GrantExecutePolicy, "Expected GrantExecutePolicy got " + actual[0].GetType().ToString()); Assert.IsTrue(actual[1] is GrantExecuteToPublicPolicy, "Expected GrantExecuteToPublicPolicy got " + actual[0].GetType().ToString()); Assert.IsTrue(actual[2] is WithNoLockPolicy, "Expected WithNoLockPolicy got " + actual[0].GetType().ToString()); Assert.IsTrue(actual[3] is ReRunablePolicy, "Expected ReRunablePolicy got " + actual[0].GetType().ToString()); Assert.IsTrue(actual[4] is QualifiedNamesPolicy, "Expected QualifiedNamesPolicy got " + actual[0].GetType().ToString()); Assert.IsTrue(actual[5] is CommentHeaderPolicy, "Expected CommentHeaderPolicy got " + actual[0].GetType().ToString()); Assert.IsTrue(actual[6] is SelectStarPolicy, "Expected SelectStarPolicy got " + actual[0].GetType().ToString()); Assert.IsTrue(actual[7] is ViewAlterPolicy, "Expected ViewAlterPolicy got " + actual[0].GetType().ToString()); Assert.IsTrue(actual[8] is ConstraintNamePolicy, "Expected ConstraintNamePolicy got " + actual[0].GetType().ToString()); }
private void PolicyForm_Load(object sender, EventArgs e) { if (this.buildData == null || this.buildData.Script == null) { MessageBox.Show("You need to have an open build project prior to running policy checks", "Project needed", MessageBoxButtons.OK, MessageBoxIcon.Warning); this.Close(); } List <IScriptPolicy> lstPol = PolicyHelper.GetPolicies(); for (int i = 0; i < lstPol.Count; i++) { ListViewItem item = new ListViewItem(new string[] { lstPol[i].ShortDescription, lstPol[i].LongDescription }); item.Checked = true; item.Tag = lstPol[i]; lstPolicies.Items.Add(item); } listSorter.CurrentColumn = 2; listSorter.Sort = SortOrder.Ascending; lstResults.ListViewItemSorter = listSorter; lstResults.Sort(); }