public void TranslateWithRecordsReturnsExpectedResult()
{
var records = _fixture
.CreateMany <NumberedRoadChangeDbaseRecord>(new Random().Next(1, 5))
.Select((record, index) =>
{
record.GW_OIDN.Value = index + 1;
record.RECORDTYPE.Value = (short)RecordType.Added.Translation.Identifier;
return(record);
})
.ToArray();
var enumerator = records.ToDbaseRecordEnumerator();
var result = _sut.Translate(_entry, enumerator, TranslatedChanges.Empty);
var expected = records.Aggregate(
TranslatedChanges.Empty,
(changes, current) => changes.Append(
new Uploads.AddRoadSegmentToNumberedRoad(
new AttributeId(current.GW_OIDN.Value),
new RoadSegmentId(current.WS_OIDN.Value),
NumberedRoadNumber.Parse(current.IDENT8.Value),
RoadSegmentNumberedRoadDirection.ByIdentifier[current.RICHTING.Value],
new RoadSegmentNumberedRoadOrdinal(current.VOLGNUMMER.Value)))
);
Assert.Equal(expected, result, new TranslatedChangeEqualityComparer());
}
private AddRoadSegmentToNumberedRoad Translate(Messages.AddRoadSegmentToNumberedRoad command, IRequestedChangeIdentityTranslator translator)
{
var permanent = _nextNumberedRoadAttributeId();
var temporary = new AttributeId(command.TemporaryAttributeId);
var segmentId = new RoadSegmentId(command.SegmentId);
RoadSegmentId?temporarySegmentId;
if (translator.TryTranslateToPermanent(segmentId, out var permanentSegmentId))
{
temporarySegmentId = segmentId;
segmentId = permanentSegmentId;
}
else
{
temporarySegmentId = null;
}
var number = NumberedRoadNumber.Parse(command.Ident8);
var direction = RoadSegmentNumberedRoadDirection.Parse(command.Direction);
var ordinal = new RoadSegmentNumberedRoadOrdinal(command.Ordinal);
return(new AddRoadSegmentToNumberedRoad
(
permanent,
temporary,
segmentId,
temporarySegmentId,
number,
direction,
ordinal
));
}
public AddRoadSegmentToNumberedRoad(
AttributeId temporaryAttributeId,
RoadSegmentId segmentId,
NumberedRoadNumber number,
RoadSegmentNumberedRoadDirection direction,
RoadSegmentNumberedRoadOrdinal ordinal)
{
TemporaryAttributeId = temporaryAttributeId;
SegmentId = segmentId;
Number = number;
Direction = direction;
Ordinal = ordinal;
}
public TranslatedChanges Translate(ZipArchiveEntry entry, IDbaseRecordEnumerator <NumberedRoadChangeDbaseRecord> records, TranslatedChanges changes)
{
if (entry == null)
{
throw new ArgumentNullException(nameof(entry));
}
if (records == null)
{
throw new ArgumentNullException(nameof(records));
}
if (changes == null)
{
throw new ArgumentNullException(nameof(changes));
}
while (records.MoveNext())
{
var record = records.Current;
if (record != null)
{
switch (record.RECORDTYPE.Value)
{
case RecordType.AddedIdentifier:
changes = changes.Append(
new AddRoadSegmentToNumberedRoad(
new AttributeId(record.GW_OIDN.Value),
new RoadSegmentId(record.WS_OIDN.Value),
NumberedRoadNumber.Parse(record.IDENT8.Value),
RoadSegmentNumberedRoadDirection.ByIdentifier[record.RICHTING.Value],
new RoadSegmentNumberedRoadOrdinal(record.VOLGNUMMER.Value)
)
);
break;
}
}
}
return(changes);
}
static void Main(string[] args)
{
Directory.CreateDirectory("output");
Encoding.RegisterProvider(CodePagesEncodingProvider.Instance);
var node1Record = new RoadNodeChangeDbaseRecord();
node1Record.TYPE.Value = (short)RoadNodeType.EndNode.Translation.Identifier;
node1Record.RECORDTYPE.Value = (short)RecordType.Added.Translation.Identifier;
node1Record.WEGKNOOPID.Value = 1;
var node1Shape = new PointShapeContent(new Point(0.0, 0.0));
var node2Record = new RoadNodeChangeDbaseRecord();
node2Record.TYPE.Value = (short)RoadNodeType.EndNode.Translation.Identifier;
node2Record.RECORDTYPE.Value = (short)RecordType.Added.Translation.Identifier;
node2Record.WEGKNOOPID.Value = 2;
var node2Shape = new PointShapeContent(new Point(0.0, 1.0));
var segment1Record = new RoadSegmentChangeDbaseRecord();
segment1Record.WS_OIDN.Value = 1;
segment1Record.B_WK_OIDN.Value = 1;
segment1Record.E_WK_OIDN.Value = 2;
segment1Record.TGBEP.Value = (short)RoadSegmentAccessRestriction.PublicRoad.Translation.Identifier;
segment1Record.STATUS.Value = RoadSegmentStatus.InUse.Translation.Identifier;
segment1Record.WEGCAT.Value = RoadSegmentCategory.SecondaryRoad.Translation.Identifier;
segment1Record.METHODE.Value = (short)RoadSegmentGeometryDrawMethod.Measured.Translation.Identifier;
segment1Record.MORFOLOGIE.Value = (short)RoadSegmentMorphology.Motorway.Translation.Identifier;
segment1Record.LSTRNMID.Value = 123;
segment1Record.RSTRNMID.Value = 456;
segment1Record.BEHEERDER.Value = "-8";
segment1Record.RECORDTYPE.Value = (short)RecordType.Added.Translation.Identifier;
var segmentShape = new PolyLineMShapeContent(GeometryTranslator.FromGeometryMultiLineString(new NetTopologySuite.Geometries.MultiLineString(new NetTopologySuite.Geometries.LineString[]
{
new NetTopologySuite.Geometries.LineString(new NetTopologySuite.Geometries.Implementation.CoordinateArraySequence(new[]
{
new NetTopologySuite.Geometries.CoordinateM(0.0, 0.0, 0.0),
new NetTopologySuite.Geometries.CoordinateM(0.0, 1.0, 1.0)
}), GeometryConfiguration.GeometryFactory)
})));
var laneRecord = new RoadSegmentLaneChangeDbaseRecord();
laneRecord.RS_OIDN.Value = 1;
laneRecord.WS_OIDN.Value = 1;
laneRecord.RICHTING.Value = (short)RoadSegmentLaneDirection.Independent.Translation.Identifier;
laneRecord.AANTAL.Value = 2;
laneRecord.VANPOSITIE.Value = 0.0;
laneRecord.TOTPOSITIE.Value = 1.0;
laneRecord.RECORDTYPE.Value = (short)RecordType.Added.Translation.Identifier;
var surfaceRecord = new RoadSegmentSurfaceChangeDbaseRecord();
surfaceRecord.WV_OIDN.Value = 1;
surfaceRecord.WS_OIDN.Value = 1;
surfaceRecord.TYPE.Value = (short)RoadSegmentSurfaceType.SolidSurface.Translation.Identifier;
surfaceRecord.VANPOSITIE.Value = 0.0;
surfaceRecord.TOTPOSITIE.Value = 1.0;
surfaceRecord.RECORDTYPE.Value = (short)RecordType.Added.Translation.Identifier;
var widthRecord = new RoadSegmentWidthChangeDbaseRecord();
widthRecord.WB_OIDN.Value = 1;
widthRecord.WS_OIDN.Value = 1;
widthRecord.BREEDTE.Value = 1;
widthRecord.VANPOSITIE.Value = 0.0;
widthRecord.TOTPOSITIE.Value = 1.0;
widthRecord.RECORDTYPE.Value = (short)RecordType.Added.Translation.Identifier;
var nodeDbaseHeader = new DbaseFileHeader(
DateTime.Now,
DbaseCodePage.Western_European_ANSI,
new DbaseRecordCount(2),
new RoadNodeChangeDbaseSchema());
var nodeShapeHeader = new ShapeFileHeader(
ShapeFileHeader.Length.Plus(node1Shape.ContentLength).Plus(node2Shape.ContentLength),
ShapeType.Point,
BoundingBox3D
.FromGeometry(node1Shape.Shape)
.ExpandWith(
BoundingBox3D.FromGeometry(node2Shape.Shape)
)
);
// node
using (var nodeDbaseFile = new BinaryWriter(File.OpenWrite("output/WEGKNOOP_ALL.dbf")))
using (var nodeDbaseWriter = new DbaseBinaryWriter(nodeDbaseHeader, nodeDbaseFile))
{
nodeDbaseWriter.Write(node1Record);
nodeDbaseWriter.Write(node2Record);
}
using (var nodeShapeIndexFile = new BinaryWriter(File.OpenWrite("output/WEGKNOOP_ALL.shx")))
using (var nodeShapeFile = new BinaryWriter(File.OpenWrite("output/WEGKNOOP_ALL.shp")))
using (var nodeShapeWriter = new ShapeBinaryWriter(nodeShapeHeader, nodeShapeFile))
using (var nodeShapeIndexWriter =
new ShapeIndexBinaryWriter(nodeShapeHeader.ForIndex(new ShapeRecordCount(2)), nodeShapeIndexFile))
{
var node1ShapeRecord = node1Shape.RecordAs(RecordNumber.Initial);
nodeShapeWriter.Write(node1ShapeRecord);
var node2ShapeRecord = node2Shape.RecordAs(RecordNumber.Initial.Next());
nodeShapeWriter.Write(node2ShapeRecord);
var offset = ShapeIndexRecord.InitialOffset;
var node1ShapeIndexRecord = node1ShapeRecord.IndexAt(offset);
var node2ShapeIndexRecord = node2ShapeRecord.IndexAt(offset.Plus(node1ShapeRecord.Length));
nodeShapeIndexWriter.Write(node1ShapeIndexRecord);
nodeShapeIndexWriter.Write(node2ShapeIndexRecord);
}
// segment
var segmentDbaseHeader = new DbaseFileHeader(
DateTime.Now,
DbaseCodePage.Western_European_ANSI,
new DbaseRecordCount(1),
new RoadSegmentChangeDbaseSchema());
var segmentShapeHeader = new ShapeFileHeader(
ShapeFileHeader.Length.Plus(segmentShape.ContentLength),
ShapeType.PolyLineM,
BoundingBox3D
.FromGeometry(segmentShape.Shape)
);
using (var segmentDbaseFile = new BinaryWriter(File.OpenWrite("output/WEGSEGMENT_ALL.dbf")))
using (var segmentDbaseWriter = new DbaseBinaryWriter(segmentDbaseHeader, segmentDbaseFile))
{
segmentDbaseWriter.Write(segment1Record);
}
using (var segmentShapeIndexFile = new BinaryWriter(File.OpenWrite("output/WEGSEGMENT_ALL.shx")))
using (var segmentShapeFile = new BinaryWriter(File.OpenWrite("output/WEGSEGMENT_ALL.shp")))
using (var segmentShapeWriter = new ShapeBinaryWriter(segmentShapeHeader, segmentShapeFile))
using (var segmentShapeIndexWriter =
new ShapeIndexBinaryWriter(segmentShapeHeader.ForIndex(new ShapeRecordCount(2)), segmentShapeIndexFile))
{
var segment1ShapeRecord = segmentShape.RecordAs(RecordNumber.Initial);
segmentShapeWriter.Write(segment1ShapeRecord);
var offset = ShapeIndexRecord.InitialOffset;
var segment1ShapeIndexRecord = segment1ShapeRecord.IndexAt(offset);
segmentShapeIndexWriter.Write(segment1ShapeIndexRecord);
}
// lane
var laneDbaseHeader = new DbaseFileHeader(
DateTime.Now,
DbaseCodePage.Western_European_ANSI,
new DbaseRecordCount(1),
new RoadSegmentLaneChangeDbaseSchema());
using (var laneDbaseFile = new BinaryWriter(File.OpenWrite("output/ATTRIJSTROKEN_ALL.DBF")))
using (var laneDbaseWriter = new DbaseBinaryWriter(laneDbaseHeader, laneDbaseFile))
{
laneDbaseWriter.Write(laneRecord);
}
// width
var widthDbaseHeader = new DbaseFileHeader(
DateTime.Now,
DbaseCodePage.Western_European_ANSI,
new DbaseRecordCount(1),
new RoadSegmentWidthChangeDbaseSchema());
using (var widthDbaseFile = new BinaryWriter(File.OpenWrite("output/ATTWEGBREEDTE_ALL.DBF")))
using (var widthDbaseWriter = new DbaseBinaryWriter(widthDbaseHeader, widthDbaseFile))
{
widthDbaseWriter.Write(widthRecord);
}
// surface
var surfaceDbaseHeader = new DbaseFileHeader(
DateTime.Now,
DbaseCodePage.Western_European_ANSI,
new DbaseRecordCount(1),
new RoadSegmentSurfaceChangeDbaseSchema());
using (var surfaceDbaseFile = new BinaryWriter(File.OpenWrite("output/ATTWEGVERHARDING_ALL.DBF")))
using (var surfaceDbaseWriter = new DbaseBinaryWriter(surfaceDbaseHeader, surfaceDbaseFile))
{
surfaceDbaseWriter.Write(surfaceRecord);
}
// european road
var europeanRoadRecord = new EuropeanRoadChangeDbaseRecord();
europeanRoadRecord.EU_OIDN.Value = 1;
europeanRoadRecord.WS_OIDN.Value = 1;
europeanRoadRecord.EUNUMMER.Value = EuropeanRoadNumber.E40.ToString();
europeanRoadRecord.RECORDTYPE.Value = (short)RecordType.Added.Translation.Identifier;
var europeanDbaseHeader = new DbaseFileHeader(
DateTime.Now,
DbaseCodePage.Western_European_ANSI,
new DbaseRecordCount(1),
new EuropeanRoadChangeDbaseSchema());
using (var europeanDbaseFile = new BinaryWriter(File.OpenWrite("output/ATTEUROPWEG_ALL.DBF")))
using (var europeanDbaseWriter = new DbaseBinaryWriter(europeanDbaseHeader, europeanDbaseFile))
{
europeanDbaseWriter.Write(europeanRoadRecord);
}
// national road
var nationalRoadRecord = new NationalRoadChangeDbaseRecord();
nationalRoadRecord.NW_OIDN.Value = 1;
nationalRoadRecord.WS_OIDN.Value = 1;
nationalRoadRecord.IDENT2.Value = NationalRoadNumber.All[5].ToString();
nationalRoadRecord.RECORDTYPE.Value = (short)RecordType.Added.Translation.Identifier;
var nationalDbaseHeader = new DbaseFileHeader(
DateTime.Now,
DbaseCodePage.Western_European_ANSI,
new DbaseRecordCount(1),
new NationalRoadChangeDbaseSchema());
using (var nationalDbaseFile = new BinaryWriter(File.OpenWrite("output/ATTNATIONWEG_ALL.DBF")))
using (var nationalDbaseWriter = new DbaseBinaryWriter(nationalDbaseHeader, nationalDbaseFile))
{
nationalDbaseWriter.Write(nationalRoadRecord);
}
// numbered road
var numberedRoadRecord = new NumberedRoadChangeDbaseRecord();
numberedRoadRecord.GW_OIDN.Value = 1;
numberedRoadRecord.WS_OIDN.Value = 1;
numberedRoadRecord.IDENT8.Value = NumberedRoadNumber.Parse("A0001231").ToString();
numberedRoadRecord.RICHTING.Value = (short)RoadSegmentNumberedRoadDirection.Backward.Translation.Identifier;
numberedRoadRecord.VOLGNUMMER.Value = 1;
numberedRoadRecord.RECORDTYPE.Value = (short)RecordType.Added.Translation.Identifier;
var numberedDbaseHeader = new DbaseFileHeader(
DateTime.Now,
DbaseCodePage.Western_European_ANSI,
new DbaseRecordCount(1),
new NumberedRoadChangeDbaseSchema());
using (var numberedDbaseFile = new BinaryWriter(File.OpenWrite("output/ATTGENUMWEG_ALL.DBF")))
using (var numberedDbaseWriter = new DbaseBinaryWriter(numberedDbaseHeader, numberedDbaseFile))
{
numberedDbaseWriter.Write(numberedRoadRecord);
}
// grade separated junction
var gradeSeparatedJunctionRecord = new GradeSeparatedJunctionChangeDbaseRecord();
gradeSeparatedJunctionRecord.OK_OIDN.Value = 1;
gradeSeparatedJunctionRecord.BO_WS_OIDN.Value = 1;
gradeSeparatedJunctionRecord.ON_WS_OIDN.Value = 1;
gradeSeparatedJunctionRecord.TYPE.Value = (short)GradeSeparatedJunctionType.Unknown.Translation.Identifier;
gradeSeparatedJunctionRecord.RECORDTYPE.Value = (short)RecordType.Added.Translation.Identifier;
var gradeSeparatedJunctionDbaseHeader = new DbaseFileHeader(
DateTime.Now,
DbaseCodePage.Western_European_ANSI,
new DbaseRecordCount(1),
new GradeSeparatedJunctionChangeDbaseSchema());
using (var gradeSeparatedJunctionDbaseFile = new BinaryWriter(File.OpenWrite("output/RLTOGKRUISING_ALL.DBF")))
using (var gradeSeparatedJunctionDbaseWriter = new DbaseBinaryWriter(gradeSeparatedJunctionDbaseHeader, gradeSeparatedJunctionDbaseFile))
{
gradeSeparatedJunctionDbaseWriter.Write(gradeSeparatedJunctionRecord);
}
// transaction zone
var transactionZoneRecord = new TransactionZoneDbaseRecord();
transactionZoneRecord.ORG.Value = "11053";
transactionZoneRecord.OPERATOR.Value = "Yves Reynhout";
transactionZoneRecord.TYPE.Value = 1;
transactionZoneRecord.SOURCE_ID.Value = 1;
transactionZoneRecord.BESCHRIJV.Value = "Nieuwe wijk";
transactionZoneRecord.APPLICATIE.Value = "Wegenregister BLL";
var transactionZoneDbaseHeader = new DbaseFileHeader(
DateTime.Now,
DbaseCodePage.Western_European_ANSI,
new DbaseRecordCount(1),
TransactionZoneDbaseRecord.Schema);
using (var transactionZoneDbaseFile = new BinaryWriter(File.OpenWrite("output/TRANSACTIEZONE.DBF")))
using (var transactionZoneDbaseWriter = new DbaseBinaryWriter(transactionZoneDbaseHeader, transactionZoneDbaseFile))
{
transactionZoneDbaseWriter.Write(transactionZoneRecord);
}
var suffix =
DateTimeOffset.UtcNow.ToString("yyyyMMdd") + "-" +
Convert.ToInt32(DateTimeOffset.UtcNow.TimeOfDay.TotalSeconds);
using (var archiveStream = File.OpenWrite($"output/oplading-{suffix}.zip"))
using (var archive = new ZipArchive(archiveStream, ZipArchiveMode.Create))
{
foreach (var file in Directory.EnumerateFiles("output"))
{
if (file.ToLowerInvariant().EndsWith(".dbf") ||
file.ToLowerInvariant().EndsWith(".shp") ||
file.ToLowerInvariant().EndsWith(".shx"))
{
var entry = archive.CreateEntry(Path.GetFileName(file));
using (var fileStream = File.OpenRead(file))
using (var entryStream = entry.Open())
{
fileStream.CopyTo(entryStream);
}
}
}
}
}
public ZipArchiveProblems Validate(ZipArchiveEntry entry, IDbaseRecordEnumerator <NumberedRoadChangeDbaseRecord> records)
{
if (entry == null)
{
throw new ArgumentNullException(nameof(entry));
}
if (records == null)
{
throw new ArgumentNullException(nameof(records));
}
var problems = ZipArchiveProblems.None;
try
{
var identifiers = new Dictionary <AttributeId, RecordNumber>();
var moved = records.MoveNext();
if (moved)
{
while (moved)
{
var recordContext = entry.AtDbaseRecord(records.CurrentRecordNumber);
var record = records.Current;
if (record != null)
{
if (!record.RECORDTYPE.HasValue)
{
problems += recordContext.RequiredFieldIsNull(record.RECORDTYPE.Field);
}
else
{
if (!RecordType.ByIdentifier.ContainsKey(record.RECORDTYPE.Value))
{
problems += recordContext.RecordTypeMismatch(record.RECORDTYPE.Value);
}
}
if (record.GW_OIDN.HasValue)
{
if (record.GW_OIDN.Value == 0)
{
problems += recordContext.IdentifierZero();
}
else
{
var identifier = new AttributeId(record.GW_OIDN.Value);
if (identifiers.TryGetValue(identifier, out var takenByRecordNumber))
{
problems += recordContext.IdentifierNotUnique(
identifier,
takenByRecordNumber
);
}
else
{
identifiers.Add(identifier, records.CurrentRecordNumber);
}
}
}
else
{
problems += recordContext.RequiredFieldIsNull(record.GW_OIDN.Field);
}
if (record.IDENT8.Value == null)
{
problems += recordContext.RequiredFieldIsNull(record.IDENT8.Field);
}
else if (!NumberedRoadNumber.CanParse(record.IDENT8.Value))
{
problems += recordContext.NotNumberedRoadNumber(record.IDENT8.Value);
}
if (!record.RICHTING.HasValue)
{
problems += recordContext.RequiredFieldIsNull(record.RICHTING.Field);
}
else if (!RoadSegmentNumberedRoadDirection.ByIdentifier.ContainsKey(record.RICHTING.Value))
{
problems += recordContext.NumberedRoadDirectionMismatch(record.RICHTING.Value);
}
if (!record.VOLGNUMMER.HasValue)
{
problems += recordContext.RequiredFieldIsNull(record.VOLGNUMMER.Field);
}
else if (!RoadSegmentNumberedRoadOrdinal.Accepts(record.VOLGNUMMER.Value))
{
problems += recordContext.NumberedRoadOrdinalOutOfRange(record.VOLGNUMMER.Value);
}
if (!record.WS_OIDN.HasValue)
{
problems += recordContext.RequiredFieldIsNull(record.WS_OIDN.Field);
}
else if (!RoadSegmentId.Accepts(record.WS_OIDN.Value))
{
problems += recordContext.RoadSegmentIdOutOfRange(record.WS_OIDN.Value);
}
}
moved = records.MoveNext();
}
}
else
{
problems += entry.HasNoDbaseRecords(true);
}
}
catch (Exception exception)
{
problems += entry.AtDbaseRecord(records.CurrentRecordNumber).HasDbaseRecordFormatError(exception);
}
return(problems);
}
