public async Task GetVectorsByNode()
{
Node _node;
int _vectorCount = 0;
//arrange
using (var ctxSaveNode = new DataContext(_opt.Options))
{
NodeRepository _db = new NodeRepository(ctxSaveNode);
await _db.InsertNodeAsync(_node2);
}
using (var ctxReadNode = new DataContext(_opt.Options))
{
_node = (
from n in ctxReadNode.Nodes
where n.NodeName == "3"
select n
).FirstOrDefault();
}
Vector _vector1 = new Vector
{
VectorPhrase = "Gross Domestic Product",
NodeSubject = _node.NodeId
};
Vector _vector2 = new Vector
{
VectorPhrase = "in 2017",
NodeSubject = _node.NodeId
};
using (var ctxSave = new DataContext(_opt.Options))
{
VectorRepository _db = new VectorRepository(ctxSave);
await _db.InsertVectorAsync(_vector1);
await _db.InsertVectorAsync(_vector2);
}
//act
using (var ctxReadVector = new DataContext(_opt.Options))
{
VectorRepository _db = new VectorRepository(ctxReadVector);
_vectorCount = (
from v in await _db.SelectVectorsByNodeAsync(_node.NodeId, _reqParams)
select v
).ToList().Count();
}
//assert
Assert.AreEqual(2, _vectorCount);
}
public async Task DeleteOneVector()
{
Node _node;
Vector _activeVector;
Vector _deletedVector;
Vector _unretrievableVector;
//arrange
using (var ctxSave = new DataContext(_opt.Options))
{
NodeRepository _db = new NodeRepository(ctxSave);
await _db.InsertNodeAsync(_node6);
}
using (var ctxReadNode = new DataContext(_opt.Options))
{
_node = (
from n in ctxReadNode.Nodes
where n.NodeName == "Canada"
select n
).FirstOrDefault();
}
Vector _newVector = new Vector
{
VectorPhrase = "Not Updated",
VectorStatus = VectorStatusValues.Active,
NodeSubject = _node.NodeId
};
using (var ctxSave = new DataContext(_opt.Options))
{
VectorRepository _db = new VectorRepository(ctxSave);
_activeVector = await _db.InsertVectorAsync(_newVector);
}
// act
_activeVector.VectorStatus = VectorStatusValues.Deleted;
_activeVector.HasEdits = true;
using (var ctxDelete = new DataContext(_opt.Options))
{
VectorRepository _db = new VectorRepository(ctxDelete);
_deletedVector = await _db.DeleteVectorAsync(_activeVector);
}
using (var ctxRead = new DataContext(_opt.Options))
{
VectorRepository _db = new VectorRepository(ctxRead);
_unretrievableVector = await _db.SelectVectorAsync(_node.NodeId, _deletedVector.VectorId);
}
// assert
Assert.IsNotNull(_activeVector);
Assert.AreEqual(VectorStatusValues.Deleted, _deletedVector.VectorStatus);
Assert.IsNull(_unretrievableVector);
}
public async Task SaveAndSelectOneVector()
{
int _vectorCount = 0;
int _nodeId = 0;
Vector _saveResult;
//arrange
Vector _vector = new Vector
{
VectorPhrase = "Empty Vector"
};
using (var ctxSave = new DataContext(_opt.Options))
{
NodeRepository _db = new NodeRepository(ctxSave);
await _db.InsertNodeAsync(_node1);
}
using (var ctxReader = new DataContext(_opt.Options))
{
VectorRepository _db = new VectorRepository(ctxReader);
_nodeId = (
from n in ctxReader.Nodes
where n.NodeName == "France"
select n.NodeId
).FirstOrDefault();
}
_vector.NodeSubject = _nodeId;
//act
using (var ctxSaveVector = new DataContext(_opt.Options))
{
VectorRepository _db = new VectorRepository(ctxSaveVector);
_saveResult = await _db.InsertVectorAsync(_vector);
}
using (var ctxReadVector = new DataContext(_opt.Options))
{
VectorRepository _db = new VectorRepository(ctxReadVector);
_vectorCount = (_db.SelectVectorAsync(_nodeId, _saveResult.VectorId) != null ? 1 : 0);
}
//assert
Assert.AreEqual(1, _vectorCount);
}
public async Task UpdateOneVector()
{
Node _node;
Vector _vectorToUpdate;
Vector _updatedVector;
// arrange
using (var ctxSave = new DataContext(_opt.Options))
{
NodeRepository _db = new NodeRepository(ctxSave);
await _db.InsertNodeAsync(_node5);
}
using (var ctxReadNode = new DataContext(_opt.Options))
{
_node = (
from n in ctxReadNode.Nodes
where n.NodeName == "Employment"
select n
).FirstOrDefault();
}
Vector _newVector = new Vector
{
VectorPhrase = "Not Updated",
VectorStatus = VectorStatusValues.Active,
NodeSubject = _node.NodeId,
NodeObject = 100,
NodeParent = 110,
NodeRoot = 120
};
using (var ctxSave = new DataContext(_opt.Options))
{
VectorRepository _db = new VectorRepository(ctxSave);
_vectorToUpdate = await _db.InsertVectorAsync(_newVector);
}
// act
_vectorToUpdate.HasEdits = true;
_vectorToUpdate.VectorPhrase = "Updated";
_vectorToUpdate.NodeObject = 200;
_vectorToUpdate.NodeParent = 210;
using (var ctxUpdate = new DataContext(_opt.Options))
{
VectorRepository _db = new VectorRepository(ctxUpdate);
await _db.UpdateVectorAsync(_vectorToUpdate);
}
using (var ctxReadVector = new DataContext(_opt.Options))
{
_updatedVector = (
from v in ctxReadVector.Vectors
where v.VectorId == _vectorToUpdate.VectorId
select v
).FirstOrDefault();
}
// assert
Assert.AreEqual(_updatedVector.VectorPhrase, _vectorToUpdate.VectorPhrase);
Assert.AreNotEqual(_updatedVector.NodeObject, 100);
Assert.AreNotEqual(_updatedVector.NodeParent, 110);
Assert.AreEqual(_updatedVector.NodeRoot, _vectorToUpdate.NodeRoot);
}