public static HistoricalCaseNote AddCaseNoteForASpecificPersonToDb(HistoricalDataContext context, long personId, bool includeNoteContent = true)
{
var faker = new Faker();
var noteTypeCode = faker.Random.String2(5);
var noteTypeDescription = faker.Random.String2(15);
var noteType = HistoricalTestHelper.CreateDatabaseNoteType(noteTypeCode, noteTypeDescription);
context.HistoricalNoteTypes.Add(noteType);
var savedWorker = HistoricalTestHelper.CreateDatabaseWorker();
context.HistoricalWorkers.Add(savedWorker);
var caseNoteId = faker.Random.Long(min: 1);
var savedCaseNote = HistoricalTestHelper.CreateDatabaseCaseNote(caseNoteId, personId, savedWorker, noteType);
context.HistoricalCaseNotes.Add(savedCaseNote);
context.SaveChanges();
return(new HistoricalCaseNote
{
CreatedBy = $"{savedWorker.FirstNames} {savedWorker.LastNames}",
CreatedByWorker = savedCaseNote.CreatedByWorker,
Id = savedCaseNote.Id,
LastUpdatedBy = savedCaseNote.LastUpdatedBy,
Note = includeNoteContent == true ? savedCaseNote.Note : null,
PersonId = savedCaseNote.PersonId,
Title = savedCaseNote.Title,
CreatedOn = savedCaseNote.CreatedOn,
NoteType = noteType.Description,
HistoricalNoteType = noteType
});
}
public static HistoricalWorker AddWorkerToDatabase(HistoricalDataContext socialCareContext)
{
var worker = HistoricalTestHelper.CreateDatabaseWorker();
socialCareContext.HistoricalWorkers.Add(worker);
socialCareContext.SaveChanges();
return(worker);
}
public static HistoricalVisit AddVisitToDatabase(HistoricalDataContext socialCareContext, HistoricalWorker?worker = null)
{
var visitInformation = HistoricalTestHelper.CreateDatabaseVisit(worker: worker);
socialCareContext.HistoricalVisits.Add(visitInformation);
socialCareContext.SaveChanges();
return(visitInformation);
}
public void RunBeforeAnyTests()
{
var builder = new DbContextOptionsBuilder <HistoricalDataContext>();
builder.UseNpgsql(ConnectionString.HistoricalDataTestDatabase());
HistoricalSocialCareContext = new HistoricalDataContext(builder.Options);
//context is configured to be read only on production
HistoricalSocialCareContext.ChangeTracker.QueryTrackingBehavior = QueryTrackingBehavior.NoTracking;
HistoricalSocialCareContext.Database.EnsureCreated();
_transaction = HistoricalSocialCareContext.Database.BeginTransaction();
}
public static void MyTest()
{
// create the data context (to get data from)
var ds = new UniversalDataSource(
new FooDataSource(),
new BarDataSource()
);
var realTimeDataContext = new RealTimeDataContext(ds);
var historicalDataContext = new HistoricalDataContext(ds, DateTime.MinValue);
var fooId = new FooIdentifier("onetuhoenthuo");
var barId = new BarIdentifier("onetuhoenthuo");
// testing dispatch
Assert.AreEqual(-1, realTimeDataContext.GetValue(fooId));
Assert.AreEqual(-2, historicalDataContext.GetValue(fooId));
Assert.AreEqual(-3, realTimeDataContext.GetValue(barId));
Assert.AreEqual(-4, historicalDataContext.GetValue(barId));
}
protected override void ConfigureWebHost(IWebHostBuilder builder)
{
builder.ConfigureAppConfiguration(b => b.AddEnvironmentVariables());
builder.ConfigureServices(services =>
{
var dbBuilder = new DbContextOptionsBuilder <DatabaseContext>();
dbBuilder.UseNpgsql(_connection);
var context = new DatabaseContext(dbBuilder.Options);
services.AddSingleton(context);
var historicalDataDbBuilder = new DbContextOptionsBuilder <HistoricalDataContext>();
historicalDataDbBuilder.UseNpgsql(_historicalDataDbConnection);
var historicalDataContext = new HistoricalDataContext(historicalDataDbBuilder.Options);
services.AddSingleton(historicalDataContext);
var serviceProvider = services.BuildServiceProvider();
var dbContext = serviceProvider.GetRequiredService <DatabaseContext>();
var historicalDbContext = serviceProvider.GetRequiredService <HistoricalDataContext>();
dbContext.Database.EnsureCreated();
historicalDataContext.Database.EnsureCreated();
});
}
public static HistoricalCaseNote AddCaseNoteWithNoteTypeAndWorkerToDatabase(HistoricalDataContext socialCareContext)
{
var noteType = HistoricalTestHelper.CreateDatabaseNoteType();
var worker = HistoricalTestHelper.CreateDatabaseWorker();
var caseNote = HistoricalTestHelper.CreateDatabaseCaseNote(createdWorker: worker, noteType: noteType);
socialCareContext.HistoricalWorkers.Add(worker);
socialCareContext.HistoricalCaseNotes.Add(caseNote);
socialCareContext.SaveChanges();
return(new HistoricalCaseNote
{
CreatedBy = $"{worker.FirstNames} {worker.LastNames}",
CreatedByWorker = caseNote.CreatedByWorker,
Id = caseNote.Id,
LastUpdatedBy = caseNote.LastUpdatedBy,
Note = caseNote.Note,
PersonId = caseNote.PersonId,
Title = caseNote.Title,
CreatedOn = caseNote.CreatedOn,
NoteType = noteType.Type,
HistoricalNoteType = noteType
});
}
public HistoricalDataGateway(HistoricalDataContext databaseContext)
{
_databaseContext = databaseContext;
}
