public void testToInsertSuccess()
{
using (var personReader = EntityDataMock.mockPersonReader())
{
Address addr = new Address(null, null, null, null, 0, 0);
addr.id = 67;
Person person = new Person(personReader);
person.address = addr;
string correctString = $"(id, name, surname, address_id) " +
$"VALUES (NULL, '{personReader["name"]}', '{personReader["surname"]}', " +
$"{addr.id});";
Assert.AreEqual(person.ToInsert(), correctString);
}
}
public void testToUpdateSuccess()
{
using (var personReader = EntityDataMock.mockPersonReader())
{
Address addr = new Address(null, null, null, null, 0, 0);
addr.id = 67;
Person person = new Person(personReader);
person.address = addr;
string correctString = $"name='{personReader["name"]}', " +
$"surname='{personReader["surname"]}', " +
$"address_id={addr.id}";
Assert.AreEqual(person.ToUpdate(), correctString);
}
}
public void testToString()
{
using (var personReader = EntityDataMock.mockPersonReader())
{
using (var addrReader = EntityDataMock.mockAddressReader())
{
string correctString = $"" +
$"{personReader["name"]} {personReader["surname"]} - " +
$"{addrReader["country"]}, {addrReader["city"]}, " +
$"{addrReader["postal_code"]}, {addrReader["street"]} " +
$"{addrReader["building_number"]}/{addrReader["apartment_number"]}";
Address addr = new Address(addrReader);
Person person = new Person(personReader);
person.address = addr;
Assert.AreEqual(person.ToString(), correctString);
}
}
}
