Пример #1
0
        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);
        }
Пример #2
0
        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);
        }