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); }