public void TearDown()
{
Criteria criteria1 = new Criteria("ShapeName", Criteria.ComparisonOp.Equals, "MyShape");
Criteria criteria2 = new Criteria("ShapeName", Criteria.ComparisonOp.Equals, "MyShapeChanged");
Criteria criteria = new Criteria(criteria1, Criteria.LogicalOp.Or, criteria2);
Shape shape = BORegistry.DataAccessor.BusinessObjectLoader.GetBusinessObject <Shape>(
criteria);
if (shape != null)
{
shape.MarkForDelete();
shape.Save();
}
criteria1 = new Criteria("ShapeName", Criteria.ComparisonOp.Equals, "Circle");
criteria2 = new Criteria("ShapeName", Criteria.ComparisonOp.Equals, "CircleChanged");
criteria = new Criteria(criteria1, Criteria.LogicalOp.Or, criteria2);
Circle circle = BORegistry.DataAccessor.BusinessObjectLoader.GetBusinessObject <Circle>(
criteria);
if (circle != null)
{
circle.MarkForDelete();
circle.Save();
}
criteria1 = new Criteria("ShapeName", Criteria.ComparisonOp.Equals, "FilledCircle");
criteria2 = new Criteria("ShapeName", Criteria.ComparisonOp.Equals, "FilledCircleChanged");
criteria = new Criteria(criteria1, Criteria.LogicalOp.Or, criteria2);
FilledCircle filledCircle = BORegistry.DataAccessor.BusinessObjectLoader.GetBusinessObject <FilledCircle>(
criteria);
if (filledCircle == null)
{
return;
}
filledCircle.MarkForDelete();
filledCircle.Save();
}
public void TestDatabaseReadWrite()
{
// Test inserting & selecting
Shape shape = new Shape();
shape.ShapeName = "MyShape";
shape.Save();
BusinessObjectCollection<Shape> shapes = new BusinessObjectCollection<Shape>();
shapes.LoadAll();
Assert.AreEqual(1, shapes.Count);
BusinessObjectCollection<Circle> circles = new BusinessObjectCollection<Circle>();
circles.LoadAll();
Assert.AreEqual(0, circles.Count);
BusinessObjectCollection<FilledCircle> filledCircles = new BusinessObjectCollection<FilledCircle>();
filledCircles.LoadAll();
Assert.AreEqual(0, filledCircles.Count);
Circle circle = new Circle();
circle.Radius = 5;
circle.ShapeName = "Circle";
circle.Save();
shapes.LoadAll("ShapeName");
Assert.AreEqual(2, shapes.Count);
Assert.AreEqual("Circle", shapes[0].ShapeName);
Assert.AreEqual("MyShape", shapes[1].ShapeName);
circles.LoadAll("ShapeName");
Assert.AreEqual(1, circles.Count);
Assert.AreEqual(circles[0].ShapeID, shapes[0].ShapeID);
Assert.AreEqual(5, circles[0].Radius);
Assert.AreEqual("Circle", circles[0].ShapeName);
FilledCircle filledCircle = new FilledCircle();
filledCircle.Colour = 3;
filledCircle.Radius = 7;
filledCircle.ShapeName = "FilledCircle";
filledCircle.Save();
shapes.LoadAll("ShapeName");
Assert.AreEqual(3, shapes.Count);
Assert.AreEqual("Circle", shapes[0].ShapeName);
Assert.AreEqual("FilledCircle", shapes[1].ShapeName);
Assert.AreEqual("MyShape", shapes[2].ShapeName);
circles.LoadAll("ShapeName");
Assert.AreEqual(2, circles.Count);
Assert.AreEqual(circles[0].ShapeID, shapes[0].ShapeID);
Assert.AreEqual(7, circles[1].Radius);
Assert.AreEqual("FilledCircle", circles[1].ShapeName);
filledCircles.LoadAll();
Assert.AreEqual(1, filledCircles.Count);
Assert.AreEqual(filledCircles[0].ShapeID, shapes[1].ShapeID);
Assert.AreEqual(7, filledCircles[0].Radius);
Assert.AreEqual("FilledCircle", filledCircles[0].ShapeName);
Assert.AreEqual(3, filledCircles[0].Colour);
// Test updating
shape.ShapeName = "MyShapeChanged";
shape.Save();
circle.ShapeName = "CircleChanged";
circle.Radius = 10;
circle.Save();
filledCircle.ShapeName = "FilledCircleChanged";
filledCircle.Radius = 12;
filledCircle.Colour = 4;
filledCircle.Save();
shapes.LoadAll("ShapeName");
Assert.AreEqual("CircleChanged", shapes[0].ShapeName);
Assert.AreEqual("FilledCircleChanged", shapes[1].ShapeName);
Assert.AreEqual("MyShapeChanged", shapes[2].ShapeName);
circles.LoadAll("ShapeName");
Assert.AreEqual(10, circles[0].Radius);
Assert.AreEqual(12, circles[1].Radius);
Assert.AreEqual("CircleChanged", circles[0].ShapeName);
Assert.AreEqual("FilledCircleChanged", circles[1].ShapeName);
filledCircles.LoadAll();
Assert.AreEqual(4, filledCircles[0].Colour);
Assert.AreEqual(12, filledCircles[0].Radius);
Assert.AreEqual("FilledCircleChanged", filledCircles[0].ShapeName);
// Test deleting
shape.MarkForDelete();
shape.Save();
circle.MarkForDelete();
circle.Save();
filledCircle.MarkForDelete();
filledCircle.Save();
shapes.LoadAll();
Assert.AreEqual(0, shapes.Count);
circles.LoadAll();
Assert.AreEqual(0, circles.Count);
filledCircles.LoadAll();
Assert.AreEqual(0, filledCircles.Count);
}
public void TestDatabaseReadWrite()
{
// Test inserting & selecting
Shape shape = new Shape();
shape.ShapeName = "MyShape";
shape.Save();
BusinessObjectCollection <Shape> shapes = new BusinessObjectCollection <Shape>();
shapes.LoadAll();
Assert.AreEqual(1, shapes.Count);
BusinessObjectCollection <Circle> circles = new BusinessObjectCollection <Circle>();
circles.LoadAll();
Assert.AreEqual(0, circles.Count);
BusinessObjectCollection <FilledCircle> filledCircles = new BusinessObjectCollection <FilledCircle>();
filledCircles.LoadAll();
Assert.AreEqual(0, filledCircles.Count);
Circle circle = new Circle();
circle.Radius = 5;
circle.ShapeName = "Circle";
circle.Save();
shapes.LoadAll("ShapeName");
Assert.AreEqual(2, shapes.Count);
Assert.AreEqual("Circle", shapes[0].ShapeName);
Assert.AreEqual("MyShape", shapes[1].ShapeName);
circles.LoadAll("ShapeName");
Assert.AreEqual(1, circles.Count);
Assert.AreEqual(circles[0].ShapeID, shapes[0].ShapeID);
Assert.AreEqual(5, circles[0].Radius);
Assert.AreEqual("Circle", circles[0].ShapeName);
FilledCircle filledCircle = new FilledCircle();
filledCircle.Colour = 3;
filledCircle.Radius = 7;
filledCircle.ShapeName = "FilledCircle";
filledCircle.Save();
shapes.LoadAll("ShapeName");
Assert.AreEqual(3, shapes.Count);
Assert.AreEqual("Circle", shapes[0].ShapeName);
Assert.AreEqual("FilledCircle", shapes[1].ShapeName);
Assert.AreEqual("MyShape", shapes[2].ShapeName);
circles.LoadAll("ShapeName");
Assert.AreEqual(2, circles.Count);
Assert.AreEqual(circles[0].ShapeID, shapes[0].ShapeID);
Assert.AreEqual(7, circles[1].Radius);
Assert.AreEqual("FilledCircle", circles[1].ShapeName);
filledCircles.LoadAll();
Assert.AreEqual(1, filledCircles.Count);
Assert.AreEqual(filledCircles[0].ShapeID, shapes[1].ShapeID);
Assert.AreEqual(7, filledCircles[0].Radius);
Assert.AreEqual("FilledCircle", filledCircles[0].ShapeName);
Assert.AreEqual(3, filledCircles[0].Colour);
// Test updating
shape.ShapeName = "MyShapeChanged";
shape.Save();
circle.ShapeName = "CircleChanged";
circle.Radius = 10;
circle.Save();
filledCircle.ShapeName = "FilledCircleChanged";
filledCircle.Radius = 12;
filledCircle.Colour = 4;
filledCircle.Save();
shapes.LoadAll("ShapeName");
Assert.AreEqual("CircleChanged", shapes[0].ShapeName);
Assert.AreEqual("FilledCircleChanged", shapes[1].ShapeName);
Assert.AreEqual("MyShapeChanged", shapes[2].ShapeName);
circles.LoadAll("ShapeName");
Assert.AreEqual(10, circles[0].Radius);
Assert.AreEqual(12, circles[1].Radius);
Assert.AreEqual("CircleChanged", circles[0].ShapeName);
Assert.AreEqual("FilledCircleChanged", circles[1].ShapeName);
filledCircles.LoadAll();
Assert.AreEqual(4, filledCircles[0].Colour);
Assert.AreEqual(12, filledCircles[0].Radius);
Assert.AreEqual("FilledCircleChanged", filledCircles[0].ShapeName);
// Test deleting
shape.MarkForDelete();
shape.Save();
circle.MarkForDelete();
circle.Save();
filledCircle.MarkForDelete();
filledCircle.Save();
shapes.LoadAll();
Assert.AreEqual(0, shapes.Count);
circles.LoadAll();
Assert.AreEqual(0, circles.Count);
filledCircles.LoadAll();
Assert.AreEqual(0, filledCircles.Count);
}
