//HACK: Raw sql is not supported when running against in memory - this allows overriding and adjusting behavior
protected virtual void OnModelQueryTypes(ModelBuilder builder)
{
builder
.Entity <RoadNodeBoundingBox2D>()
.HasNoKey()
.ToQuery(() => RoadNodeBoundingBox.FromSqlRaw("SELECT MIN([BoundingBox_MinimumX]) AS MinimumX, MAX([BoundingBox_MaximumX]) AS MaximumX, MIN([BoundingBox_MinimumY]) AS MinimumY, MAX([BoundingBox_MaximumY]) AS MaximumY FROM [" + WellknownSchemas.BackOfficeSchema + "].[RoadNode]"));
builder
.Entity <RoadSegmentBoundingBox3D>()
.HasNoKey()
.ToQuery(() => RoadSegmentBoundingBox.FromSqlRaw("SELECT MIN([BoundingBox_MinimumX]) AS MinimumX, MAX([BoundingBox_MaximumX]) AS MaximumX, MIN([BoundingBox_MinimumY]) AS MinimumY, MAX([BoundingBox_MaximumY]) AS MaximumY, MIN([BoundingBox_MinimumM]) AS MinimumM, MAX([BoundingBox_MaximumM]) AS MaximumM FROM [" + WellknownSchemas.BackOfficeSchema + "].[RoadSegment]"));
}
public Task When_road_segments_are_imported()
{
var random = new Random();
var data = _fixture
.CreateMany <ImportedRoadSegment>(random.Next(1, 10))
.Select(importedRoadSegment =>
{
var geometry = GeometryTranslator.Translate(importedRoadSegment.Geometry);
var polyLineMShapeContent = new PolyLineMShapeContent(Be.Vlaanderen.Basisregisters.Shaperon.Geometries.GeometryTranslator.FromGeometryMultiLineString(geometry));
var expected = new RoadSegmentRecord
{
Id = importedRoadSegment.Id,
ShapeRecordContent = polyLineMShapeContent.ToBytes(_services.MemoryStreamManager, Encoding.UTF8),
ShapeRecordContentLength = polyLineMShapeContent.ContentLength.ToInt32(),
BoundingBox = RoadSegmentBoundingBox.From(polyLineMShapeContent.Shape),
DbaseRecord = new RoadSegmentDbaseRecord
{
WS_OIDN = { Value = importedRoadSegment.Id },
WS_UIDN = { Value = importedRoadSegment.Id + "_" + importedRoadSegment.Version },
WS_GIDN = { Value = importedRoadSegment.Id + "_" + importedRoadSegment.GeometryVersion },
B_WK_OIDN = { Value = importedRoadSegment.StartNodeId },
E_WK_OIDN = { Value = importedRoadSegment.EndNodeId },
STATUS = { Value = RoadSegmentStatus.Parse(importedRoadSegment.Status).Translation.Identifier },
LBLSTATUS = { Value = RoadSegmentStatus.Parse(importedRoadSegment.Status).Translation.Name },
MORF = { Value = RoadSegmentMorphology.Parse(importedRoadSegment.Morphology).Translation.Identifier },
LBLMORF = { Value = RoadSegmentMorphology.Parse(importedRoadSegment.Morphology).Translation.Name },
WEGCAT = { Value = RoadSegmentCategory.Parse(importedRoadSegment.Category).Translation.Identifier },
LBLWEGCAT = { Value = RoadSegmentCategory.Parse(importedRoadSegment.Category).Translation.Name },
LSTRNMID = { Value = importedRoadSegment.LeftSide.StreetNameId },
LSTRNM = { Value = importedRoadSegment.LeftSide.StreetName },
RSTRNMID = { Value = importedRoadSegment.RightSide.StreetNameId },
RSTRNM = { Value = importedRoadSegment.RightSide.StreetName },
BEHEER = { Value = importedRoadSegment.MaintenanceAuthority.Code },
LBLBEHEER = { Value = importedRoadSegment.MaintenanceAuthority.Name },
METHODE = { Value = RoadSegmentGeometryDrawMethod.Parse(importedRoadSegment.GeometryDrawMethod).Translation.Identifier },
LBLMETHOD = { Value = RoadSegmentGeometryDrawMethod.Parse(importedRoadSegment.GeometryDrawMethod).Translation.Name },
OPNDATUM = { Value = importedRoadSegment.RecordingDate },
BEGINTIJD = { Value = importedRoadSegment.Origin.Since },
BEGINORG = { Value = importedRoadSegment.Origin.OrganizationId },
LBLBGNORG = { Value = importedRoadSegment.Origin.Organization },
TGBEP = { Value = RoadSegmentAccessRestriction.Parse(importedRoadSegment.AccessRestriction).Translation.Identifier },
LBLTGBEP = { Value = RoadSegmentAccessRestriction.Parse(importedRoadSegment.AccessRestriction).Translation.Name }
}.ToBytes(_services.MemoryStreamManager, Encoding.UTF8)
};
return(new { importedRoadSegment, expected });
}).ToList();
return(new RoadRegistry.Product.Projections.RoadSegmentRecordProjection(_services.MemoryStreamManager, Encoding.UTF8)
.Scenario()
.Given(data.Select(d => d.importedRoadSegment))
.Expect(data.Select(d => d.expected)));
}
public RoadSegmentRecordProjection(RecyclableMemoryStreamManager manager,
Encoding encoding)
{
if (manager == null)
{
throw new ArgumentNullException(nameof(manager));
}
if (encoding == null)
{
throw new ArgumentNullException(nameof(encoding));
}
When <Envelope <ImportedRoadSegment> >(async(context, envelope, token) =>
{
var geometry =
GeometryTranslator.FromGeometryMultiLineString(BackOffice.Core.GeometryTranslator.Translate(envelope.Message.Geometry));
var polyLineMShapeContent = new PolyLineMShapeContent(geometry);
var statusTranslation = RoadSegmentStatus.Parse(envelope.Message.Status).Translation;
var morphologyTranslation = RoadSegmentMorphology.Parse(envelope.Message.Morphology).Translation;
var categoryTranslation = RoadSegmentCategory.Parse(envelope.Message.Category).Translation;
var geometryDrawMethodTranslation =
RoadSegmentGeometryDrawMethod.Parse(envelope.Message.GeometryDrawMethod).Translation;
var accessRestrictionTranslation =
RoadSegmentAccessRestriction.Parse(envelope.Message.AccessRestriction).Translation;
await context.RoadSegments.AddAsync(
new RoadSegmentRecord
{
Id = envelope.Message.Id,
ShapeRecordContent = polyLineMShapeContent.ToBytes(manager, encoding),
ShapeRecordContentLength = polyLineMShapeContent.ContentLength.ToInt32(),
BoundingBox = RoadSegmentBoundingBox.From(polyLineMShapeContent.Shape),
DbaseRecord = new RoadSegmentDbaseRecord
{
WS_OIDN = { Value = envelope.Message.Id },
WS_UIDN = { Value = $"{envelope.Message.Id}_{envelope.Message.Version}" },
WS_GIDN = { Value = $"{envelope.Message.Id}_{envelope.Message.GeometryVersion}" },
B_WK_OIDN = { Value = envelope.Message.StartNodeId },
E_WK_OIDN = { Value = envelope.Message.EndNodeId },
STATUS = { Value = statusTranslation.Identifier },
LBLSTATUS = { Value = statusTranslation.Name },
MORF = { Value = morphologyTranslation.Identifier },
LBLMORF = { Value = morphologyTranslation.Name },
WEGCAT = { Value = categoryTranslation.Identifier },
LBLWEGCAT = { Value = categoryTranslation.Name },
LSTRNMID = { Value = envelope.Message.LeftSide.StreetNameId },
LSTRNM = { Value = envelope.Message.LeftSide.StreetName },
RSTRNMID = { Value = envelope.Message.RightSide.StreetNameId },
RSTRNM = { Value = envelope.Message.RightSide.StreetName },
BEHEER = { Value = envelope.Message.MaintenanceAuthority.Code },
LBLBEHEER = { Value = envelope.Message.MaintenanceAuthority.Name },
METHODE = { Value = geometryDrawMethodTranslation.Identifier },
LBLMETHOD = { Value = geometryDrawMethodTranslation.Name },
OPNDATUM = { Value = envelope.Message.RecordingDate },
BEGINTIJD = { Value = envelope.Message.Origin.Since },
BEGINORG = { Value = envelope.Message.Origin.OrganizationId },
LBLBGNORG = { Value = envelope.Message.Origin.Organization },
TGBEP = { Value = accessRestrictionTranslation.Identifier },
LBLTGBEP = { Value = accessRestrictionTranslation.Name }
}.ToBytes(manager, encoding)
},
token);
});
When <Envelope <RoadNetworkChangesBasedOnArchiveAccepted> >(async(context, envelope, token) =>
{
foreach (var message in envelope.Message.Changes.Flatten())
{
switch (message)
{
case RoadSegmentAdded segment:
var geometry =
GeometryTranslator.FromGeometryMultiLineString(BackOffice.Core.GeometryTranslator.Translate(segment.Geometry));
var polyLineMShapeContent = new PolyLineMShapeContent(geometry);
var statusTranslation = RoadSegmentStatus.Parse(segment.Status).Translation;
var morphologyTranslation = RoadSegmentMorphology.Parse(segment.Morphology).Translation;
var categoryTranslation = RoadSegmentCategory.Parse(segment.Category).Translation;
var geometryDrawMethodTranslation =
RoadSegmentGeometryDrawMethod.Parse(segment.GeometryDrawMethod).Translation;
var accessRestrictionTranslation =
RoadSegmentAccessRestriction.Parse(segment.AccessRestriction).Translation;
await context.RoadSegments.AddAsync(
new RoadSegmentRecord
{
Id = segment.Id,
ShapeRecordContent = polyLineMShapeContent.ToBytes(manager, encoding),
ShapeRecordContentLength = polyLineMShapeContent.ContentLength.ToInt32(),
BoundingBox = RoadSegmentBoundingBox.From(polyLineMShapeContent.Shape),
DbaseRecord = new RoadSegmentDbaseRecord
{
WS_OIDN = { Value = segment.Id },
WS_UIDN = { Value = $"{segment.Id}_{segment.Version}" },
WS_GIDN = { Value = $"{segment.Id}_{segment.GeometryVersion}" },
B_WK_OIDN = { Value = segment.StartNodeId },
E_WK_OIDN = { Value = segment.EndNodeId },
STATUS = { Value = statusTranslation.Identifier },
LBLSTATUS = { Value = statusTranslation.Name },
MORF = { Value = morphologyTranslation.Identifier },
LBLMORF = { Value = morphologyTranslation.Name },
WEGCAT = { Value = categoryTranslation.Identifier },
LBLWEGCAT = { Value = categoryTranslation.Name },
LSTRNMID = { Value = segment.LeftSide.StreetNameId },
// TODO: Where does this come from?
LSTRNM = { Value = null },
RSTRNMID = { Value = segment.RightSide.StreetNameId },
// TODO: Where does this come from?
RSTRNM = { Value = null },
BEHEER = { Value = segment.MaintenanceAuthority.Code },
LBLBEHEER = { Value = segment.MaintenanceAuthority.Name },
METHODE = { Value = geometryDrawMethodTranslation.Identifier },
LBLMETHOD = { Value = geometryDrawMethodTranslation.Name },
OPNDATUM = { Value = LocalDateTimeTranslator.TranslateFromWhen(envelope.Message.When) },
BEGINTIJD = { Value = LocalDateTimeTranslator.TranslateFromWhen(envelope.Message.When) },
BEGINORG = { Value = envelope.Message.OrganizationId },
LBLBGNORG = { Value = envelope.Message.Organization },
TGBEP = { Value = accessRestrictionTranslation.Identifier },
LBLTGBEP = { Value = accessRestrictionTranslation.Name }
}.ToBytes(manager, encoding)
},
token);
break;
}
}
});
}
