private static void WriteTestDataToDB(NpgsqlConnection connection)
{
var pointIds1D = new int[pointArraySize];
var pointIds2D = new int[pointArraySize];
var pointIds3D = new int[pointArraySize];
Console.WriteLine("Creating Points");
for (var i = 0; i < pointArraySize; i++)
{
pointIds1D[i] = IntPointService.Create(connection, RandomNumber());
pointIds2D[i] = IntPointService.Create(connection, RandomNumber(), RandomNumber());
pointIds3D[i] = IntPointService.Create(connection, RandomNumber(), RandomNumber(), RandomNumber());
}
var positionIds1D = new int[positionArraySize];
var positionIds2D = new int[positionArraySize];
var positionIds3D = new int[positionArraySize];
Console.WriteLine("Creating Positions");
for (var i = 0; i < positionArraySize; i++)
{
if (i != 0 && i % 100 == 0)
{
Console.WriteLine("Created {0} positions", i);
}
var position1D = PositionService.CreateNewPosition(connection, (byte)DataType.Int);
var position2D = PositionService.CreateNewPosition(connection, (byte)DataType.Int);
var position3D = PositionService.CreateNewPosition(connection, (byte)DataType.Int);
positionIds1D[i] = position1D;
positionIds2D[i] = position2D;
positionIds3D[i] = position3D;
for (var j = 0; j < pointArraySize; j++)
{
PositionService.AddPoint(connection, position1D, pointIds1D[j]);
PositionService.AddPoint(connection, position2D, pointIds2D[j]);
PositionService.AddPoint(connection, position3D, pointIds3D[j]);
}
}
var matrixIds = new int[matrixArraySize];
Console.WriteLine("Creating Matrices");
for (var i = 0; i < matrixArraySize; i++)
{
if (i != 0 && i % 10 == 0)
{
Console.WriteLine("Created {0} matrices", i);
}
var matrixId = MatrixService.CreateNewMatrix(connection, (byte)DataType.Int);
matrixIds[i] = matrixId;
for (var j = 0; j < positionArraySize; j++)
{
switch (i / 20)
{
case 0:
MatrixService.AddPosition(connection, matrixId, positionIds1D[j]);
break;
case 1:
MatrixService.AddPosition(connection, matrixId, positionIds2D[j]);
break;
case 2:
MatrixService.AddPosition(connection, matrixId, positionIds3D[j]);
break;
}
}
}
var containerIds = new int[containerArraySize];
Console.WriteLine("Creating Containers");
for (var i = 0; i < containerArraySize; i++)
{
if (i != 0 && i % 100 == 0)
{
Console.WriteLine("Created {0} containers", i);
}
var containerId = ContainerService.CreateNewContainer(connection, (byte)DataType.Int);
containerIds[i] = containerId;
for (var j = 0; j < matrixArraySize; j++)
{
ContainerService.AddMatrix(connection, containerId, matrixIds[j]);
}
}
Console.WriteLine("Creating Container Collection.");
var containerCollectionId = ContainerCollectionService.CreateNewContainerCollection(connection, (byte)DataType.Int);
for (var i = 0; i < containerArraySize; i++)
{
if (i != 0 && i % 100 == 0)
{
Console.WriteLine("Added {0} containers to collection", i);
}
ContainerCollectionService.AddContainer(connection, containerCollectionId, containerIds[i]);
}
Console.WriteLine("All items are created.");
}
