public void Delete_GivenPoco_ShouldDeletePoco()
{
// Arrange
DB.Insert(_person);
_order.PersonId = _person.Id;
DB.Insert(_order);
_orderLine.OrderId = _order.Id;
DB.Insert(_orderLine);
DB.Insert(_note);
// Act
DB.Delete(_orderLine);
DB.Delete(_order);
DB.Delete(_person);
DB.Delete(_note);
_person = DB.SingleOrDefault<Person>(_person.Id);
_order = DB.SingleOrDefault<Order>(_order.Id);
_orderLine = DB.SingleOrDefault<OrderLine>(_orderLine.Id);
_note = DB.SingleOrDefault<Note>(_note.Id);
// Assert
_person.ShouldBeNull();
_order.ShouldBeNull();
_orderLine.ShouldBeNull();
_note.ShouldBeNull();
}
public void ShouldBe(Person other)
{
Id.ShouldBe(other.Id);
Name.ShouldBe(other.Name);
Age.ShouldBe(other.Age);
Height.ShouldBe(other.Height);
Dob.ShouldBe(other.Dob);
}
public void ShouldNotBe(Person other, bool sameId)
{
if (sameId)
{
Id.ShouldBe(other.Id);
}
else
{
Id.ShouldNotBe(other.Id);
}
Name.ShouldNotBe(other.Name);
Age.ShouldNotBe(other.Age);
Height.ShouldNotBe(other.Height);
Dob.ShouldNotBe(other.Dob);
}
private void AddOrders(int ordersToAdd)
{
var orderStatuses = Enum.GetValues(typeof(OrderStatus)).Cast<int>().ToArray();
var people = new List<Person>(4);
for (var i = 0; i < 4; i++)
{
var p = new Person
{
Id = Guid.NewGuid(),
Age = 18 + i,
Dob = new DateTime(1980 - (18 + 1), 1, 1, 1, 1, 1, DateTimeKind.Utc),
};
DB.Insert(p);
people.Add(p);
}
for (var i = 0; i < ordersToAdd; i++)
{
var order = new Order
{
PoNumber = "PO" + i,
Status = (OrderStatus) orderStatuses.GetValue(i%orderStatuses.Length),
PersonId = people.Skip(i%4).Take(1).Single().Id,
CreatedOn = new DateTime(1990 - (i%4), 1, 1, 1, 1, 1, DateTimeKind.Utc),
CreatedBy = "Harry" + i
};
DB.Insert(order);
for (var j = 0; j < 2; j++)
{
DB.Insert(new OrderLine
{
OrderId = order.Id,
Quantity = (short) j,
SellPrice = 9.99m*j,
Total = 9.99m*j*j
});
}
}
}
public void Delete_GivenPocoOrPrimaryKey_ShouldDeletePoco()
{
DB.Insert(_note);
DB.Insert(_note2);
DB.Insert(_person);
DB.Delete<Person>(_person.Id).ShouldBe(1);
DB.Delete<Note>(_note).ShouldBe(1);
DB.Delete<Note>(new { _note2.Id }).ShouldBe(1);
_person = DB.SingleOrDefault<Person>(_person.Id);
_note = DB.SingleOrDefault<Note>(_note.Id);
_note2 = DB.SingleOrDefault<Note>(_note2.Id);
_person.ShouldBeNull();
_note.ShouldBeNull();
_note2.ShouldBeNull();
}
public void Delete_GivenSql_ShouldDeletePoco()
{
DB.Insert(_note);
DB.Insert(_person);
DB.Delete<Note>(new Sql($"WHERE {DB.Provider.EscapeSqlIdentifier("Id")} = @0", _note.Id)).ShouldBe(1);
DB.Delete<Person>(new Sql($"WHERE {DB.Provider.EscapeSqlIdentifier("Id")} = @0", _person.Id)).ShouldBe(1);
_person = DB.SingleOrDefault<Person>(_person.Id);
_note = DB.SingleOrDefault<Note>(_note.Id);
_person.ShouldBeNull();
_note.ShouldBeNull();
}
public void Delete_GivenTableNamePrimaryKeyNamePocoAndPrimaryKeyValue_ShouldDeletePoco()
{
DB.Insert(_person);
DB.Insert(_note);
DB.Delete("People", "Id", _person, _person.Id).ShouldBe(1);
DB.Delete("Note", "Id", _note, _note.Id).ShouldBe(1);
_person = DB.SingleOrDefault<Person>(_person.Id);
_note = DB.SingleOrDefault<Note>(_note.Id);
_person.ShouldBeNull();
_note.ShouldBeNull();
}
private static void UpdateProperties(Person person)
{
person.Name = "Feta";
person.Age = 19;
person.Dob = new DateTime(1946, 1, 12, 5, 9, 4, DateTimeKind.Utc);
person.Height = 190;
}
