public void t02_should_be_two_notices_already() { List<FuneralNotice> results; using (NoticesContext ctx = new NoticesContext()) { results = ctx.FuneralNotices.Where(x => x.Id > 0).ToList(); } Assert.IsTrue(results.Count == 2); }
public void Setup() { LoggingHelper.PointLoggerToElmahDb(); //excluded ELMAH ///LoggingHelper.ClearElmahLogs(); LoggingHelper.EnableLoggingAll(); ctx = new NoticesContext(); logger = new NoticeLogger(); }
public void t01_verify_if_can_create_db() { int result; using (NoticesContext ctx = new NoticesContext()) { FuneralNotice notice = noticeBuilder.WithId(3); ctx.FuneralNotices.Add(notice); result = ctx.SaveChanges(); } Assert.IsTrue(result == 1); }
public override void Up() { var notice = new FuneralNotice(1, "test", "test") { MemorialId = 1, ParentBranchId = "1", CedarCode = "cedarCode", BranchId = "1", KnownAs = "knownAs", Obituary = "Obituary", Source = SourceType.PERMAVITA, DateOfDeath = DateTime.UtcNow, DateOfFuneral = DateTime.UtcNow, }; using (var context = new NoticesContext()) { context.FuneralNotices.Add(notice); } }
public void t05_notice_check_enums_trick() { List<FuneralNotice> result; using (NoticesContext ctx = new NoticesContext()) { FuneralNotice notice = noticeBuilder .WithId(5) .WithSourceType(SourceType.RAINBOW); ctx.FuneralNotices.Add(notice); ctx.SaveChanges(); result = ctx.FuneralNotices .Where(x => x.Source == SourceType.RAINBOW) .ToList(); } Assert.That(result, Is.Not.Empty); Assert.That(result.First().SourceString, Is.EqualTo(SourceType.RAINBOW.ToString()) ); }
public void t03_add_notice_and_auditlog() { AuditFuneralNotice audit; using (NoticesContext ctx = new NoticesContext()) { FuneralNotice notice = noticeBuilder.WithId(4); ctx.FuneralNotices.Add(notice); audit = new AuditFuneralNotice(notice, AuditState.SavedToDb); ctx.AuditLogFuneralNotices.Add(audit); int result = ctx.SaveChanges(); Assert.IsTrue(result == 2); } //read using (NoticesContext ctx = new NoticesContext()) { audit = ctx.AuditLogFuneralNotices.FirstOrDefault(x => x.Id == 1); } Assert.IsTrue(audit.Id == 1); }
protected virtual void Seed(NoticesContext context) { var notice = new FuneralNotice(1, "test", "test") { MemorialId = 1, ParentBranchId = "1", CedarCode = "cedarCode", BranchId = "1", KnownAs = "knownAs", Obituary = "Obituary", Source = SourceType.PERMAVITA, DateOfDeath = DateTime.UtcNow, DateOfFuneral = DateTime.UtcNow, }; try { context.FuneralNotices.Add(notice); context.SaveChanges(); } catch (DbEntityValidationException e) { StringBuilder builder = new StringBuilder(); foreach (var eve in e.EntityValidationErrors) { builder.AppendLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:".Frmt( eve.Entry.Entity.GetType().Name, eve.Entry.State)); foreach (var ve in eve.ValidationErrors) { builder.AppendLine("- Property: \"{0}\", Error: \"{1}\"".Frmt(ve.PropertyName, ve.ErrorMessage)); } } Console.Write(builder.ToString()); throw; } }
public void t07_SeedIndex() { indexer.ClearAllNoticesInIndex(); LoggerConfiguration.Inst.NoticesTimeToLeave = new TimeSpan(0,1,0); int id = 2; using (var ctx = new NoticesContext()) { for (int i = 0; i < 999; i++) { FuneralNotice fn = noticeBuilder.WithId(2 + i); fn.OnlineMemorialUrl = string.Empty; ctx.FuneralNotices.Add(fn); } ctx.SaveChanges(); } Assert.That(1, Is.EqualTo(1)); indexer.ReIndexAll(); var result = indexer.ReindexedCount; Assert.That(result, Is.GreaterThan(2)); }
public void t06_Reindex_all() { var date = DateTime.UtcNow.AddDays(-8); //too old FuneralNotice fn1 = noticeBuilder.WithId(5).WithDateOfFunerale(date); //funeral fn1.OnlineMemorialUrl = string.Empty; FuneralNotice fn2 = noticeBuilder.WithId(6).WithDateOfFunerale(date); //online using (var ctx = new NoticesContext()) { ctx.FuneralNotices.Add(fn1); ctx.FuneralNotices.Add(fn2); ctx.SaveChanges(); } indexer.Add(fn1); indexer.Add(fn2); indexer.ReIndexAll(); var result = indexer.ReindexedCount; Assert.That(result, Is.EqualTo(2)); }
public NoticeLogger(NoticesContext ctx) : this() { _ctx = ctx; }
public NoticeLogger() { _ctx = _ctx ?? new NoticesContext(); }
public string ReIndexAll() { ReindexedCount = 0; var builder = new StringBuilder(); var watch = new Stopwatch(); watch.Start(); DateTime prevWeek = DateTime.UtcNow.AddDays(-7); using (var ctx = new NoticesContext()) { IEnumerable<FuneralNotice> results = ctx.FuneralNotices.Where(x => (x.DateOfFuneral > prevWeek) //funeral || !String.IsNullOrEmpty(x.OnlineMemorialUrl) //online ).Select(x => x).ToList(); foreach (FuneralNotice fn in results) { Add(fn); ReindexedCount++; if (ReIndexShouldStop) break; } } watch.Stop(); string completed = (!ReIndexShouldStop) ? "ReIndexAll compleated. <br/>" : "ReIndexAll was stopped. <br/>"; builder.AppendLine(completed); builder.AppendLine("Execution time: {0}minutes {1}seconds <br/>".Frmt(watch.Elapsed.Minutes, watch.Elapsed.Seconds)); builder.AppendLine("Number of items indexed: {0} <br/>".Frmt(ReindexedCount)); return builder.ToString(); }
public void t06_audits_verify_getLast() { AuditFuneralNotice result; using (NoticesContext ctx = new NoticesContext()) { FuneralNotice notice = noticeBuilder .WithId(6); var audit1 = new AuditFuneralNotice(notice, AuditState.Creating); var audit2 = new AuditFuneralNotice(notice, AuditState.IndexingFailed); ctx.FuneralNotices.Add(notice); ctx.AuditLogFuneralNotices.AddRange(new[] { audit1, audit2 }); ctx.SaveChanges(); } using (NoticesContext ctx = new NoticesContext()) { result = ctx.AuditLogFuneralNotices.GetLast(6); } Assert.That(result.AuditState, Is.EqualTo(AuditState.IndexingFailed) ); }