public static void InitializeTests(TestContext tc)
{
_opt = new DbContextOptionsBuilder <DataContext>().UseInMemoryDatabase("VectorTests");
_node1 = new Node
{
NodeName = "France",
NodeType = NodeValueTypes.Name,
NodeTopic = NodeTopics.Country
};
_node2 = new Node
{
NodeName = "3",
NodeType = NodeValueTypes.Percentage,
NodeTopic = NodeTopics.Economic
};
_node3 = new Node
{
NodeName = "Belgium",
NodeType = NodeValueTypes.Name,
NodeTopic = NodeTopics.Political
};
_node4 = new Node
{
NodeName = "GDP",
NodeType = NodeValueTypes.Name,
NodeTopic = NodeTopics.Economic
};
_node5 = new Node
{
NodeName = "Employment",
NodeType = NodeValueTypes.Name,
NodeTopic = NodeTopics.Economic
};
_node6 = new Node
{
NodeName = "Canada",
NodeType = NodeValueTypes.Name,
NodeTopic = NodeTopics.Country
};
_reqParams = new DataRequestParams
{
PageNumber = 1,
PageSize = 4
};
}
/// <summary>
/// Retrieve all vectors from the database for a given node.
/// <summary>
/// <param name="nodeId">The ID of the embedded Subject Node.</param>
/// <returns>The found vector object collection</returns>
public async Task <IEnumerable <Vector> > SelectVectorsByNodeAsync(
int nodeId, DataRequestParams reqParams)
{
var vectorSet = await(
from vc in _ctx.Vectors
where vc.VectorStatus == VectorStatusValues.Active
where vc.NodeSubject == nodeId
orderby vc.VectorId
select vc
)
.Skip(reqParams.PageSize * (reqParams.PageNumber - 1))
.Take(reqParams.PageSize)
.ToListAsync();
if (vectorSet.Count() > 0)
{
return(vectorSet);
}
else
{
return(null);
}
}
