Exemplo n.º 1
0
        public void CreateTermAdmin_FromCache_ReturnsValidObject()
        {
            ModerationClassListTest.InitialiseClasses();
            TermsList termsList = TermsListTest.GetTermsList();
            const int modClassId = 1;

            var cacheManager = Mocks.DynamicMock<ICacheManager>();

            TermDetails termDetail = new TermDetails();
            termDetail.Id = 1;
            termDetail.Value = "whoopsy";
            termDetail.Reason = "It's not right";
            DateTime updatedDate = DateTime.Now;
            termDetail.UpdatedDate = new DateElement(updatedDate);
            termDetail.UserID = 123456978;
            termDetail.UserName = "******";
            termDetail.Action = TermAction.ReEdit;

            var reader = Mocks.DynamicMock<IDnaDataReader>();
            reader.Stub(x => x.AddParameter("modClassId", modClassId)).Return(reader);
            reader.Stub(x => x.Execute()).Return(reader);
            reader.Stub(x => x.Read()).Return(true).Repeat.Once();
            reader.Stub(x => x.GetInt32NullAsZero("TermID")).Return(termDetail.Id);
            reader.Stub(x => x.GetStringNullAsEmpty("Term")).Return(termDetail.Value);
            reader.Stub(x => x.GetStringNullAsEmpty("Reason")).Return(termDetail.Reason);
            reader.Stub(x => x.GetDateTime("UpdatedDate")).Return(updatedDate);
            reader.Stub(x => x.GetInt32NullAsZero("UserID")).Return(termDetail.UserID);
            reader.Stub(x => x.GetStringNullAsEmpty("UserName")).Return(termDetail.UserName);
            reader.Stub(x => x.GetByteNullAsZero("actionId")).Return((byte)termDetail.Action);

            var readerCreator = Mocks.DynamicMock<IDnaDataReaderCreator>();
            readerCreator.Stub(x => x.CreateDnaDataReader("gettermsbymodclassid")).Return(reader);

            Mocks.ReplayAll();

            var termAdmin = TermsFilterAdmin.CreateTermAdmin(readerCreator, cacheManager, modClassId);

            Assert.AreEqual(1, termAdmin.TermsList.Terms.Count);
            Assert.AreEqual(1, termAdmin.ModerationClasses.ModClassList.Count);
            Assert.AreEqual(termDetail.Id, termAdmin.TermsList.Terms[0].Id);
            Assert.AreEqual(termDetail.Value, termAdmin.TermsList.Terms[0].Value);
            Assert.AreEqual(termDetail.Reason, termAdmin.TermsList.Terms[0].Reason);
            Assert.AreEqual(termDetail.UpdatedDate.Date.DateTime, termAdmin.TermsList.Terms[0].UpdatedDate.Date.DateTime);
            Assert.AreEqual(termDetail.UserID, termAdmin.TermsList.Terms[0].UserID);
            Assert.AreEqual(termDetail.UserName, termAdmin.TermsList.Terms[0].UserName);
            Assert.AreEqual(termDetail.Action, termAdmin.TermsList.Terms[0].Action);
        }
Exemplo n.º 2
0
        public void FilterListByTermIdTest()
        {
            var term = new TermDetails(){Id=1};
            var termsList = new TermsList(1);
            termsList.Terms.Add(term);

            var target = new TermsLists();
            target.Termslist.Add(TermsListTest.GetTermsList());
            target.Termslist.Add(termsList);
            
            target.FilterListByTermId(1);
            Assert.AreEqual(1, target.Termslist.Count);

        }
Exemplo n.º 3
0
        /// <summary>
        /// Checks the term is in the db correctly
        /// </summary>
        /// <param name="termStr"></param>
        private void CheckTermsInDB(string termStr)
        {
            var threadModId = 0;
            var modClassId = 0;
            var userId = 6;
            var termId = 0;
            using (FullInputContext inputcontext = new FullInputContext(""))
            {
                using (IDnaDataReader reader = inputcontext.CreateDnaDataReader(""))
                {
                    reader.ExecuteDEBUGONLY("select * from threadmod where modid = (select max(modid) from threadmod)");
                    Assert.IsTrue(reader.Read());
                    Assert.AreEqual("Filtered terms: " + termStr, reader.GetStringNullAsEmpty("notes"));

                    reader.ExecuteDEBUGONLY("select ID from TermsLookUp where term='" + termStr + "'");
                    Assert.IsTrue(reader.Read());
                    termId = reader.GetInt32("ID");

                    reader.ExecuteDEBUGONLY("select * from ForumModTermMapping where threadmodid = (select max(modid) from threadmod)");
                    Assert.IsTrue(reader.Read());
                    Assert.AreEqual(termId, reader.GetInt32("TermID"));

                    threadModId = reader.GetInt32("ThreadModID");

                    reader.ExecuteDEBUGONLY("SELECT s.modclassid AS ModClassID FROM threadmod TM INNER JOIN sites S ON TM.SiteID = S.SiteID WHERE modid = (select max(modid) from threadmod) ");
                    Assert.IsTrue(reader.Read());
                    modClassId = reader.GetInt32("ModClassID");
                }
            }

            //ensure an update so that there is a reson in db
            var reason = "test reason";
            IDnaDataReaderCreator creator = DnaMockery.CreateDatabaseReaderCreator();

            var termsLists = new TermsLists();

            var term = new TermDetails() { Value = termStr, Action = TermAction.Refer };
            var termsList = new TermsList(modClassId);
            termsList.Terms.Add(term);

            termsLists.Termslist.Add(termsList);

            termsLists.UpdateTermsInDatabase(creator, CacheFactory.GetCacheManager(), reason, userId, true);

            //check reason is valid in output
            termsList = TermsList.GetTermsListByThreadModIdFromThreadModDB(creator, threadModId, true);
            Assert.AreEqual(termStr, termsList.Terms[0].Value);
            Assert.AreEqual(reason, termsList.Terms[0].Reason);
        }