public void Select_Single_Returns_Single_Element_Matching_SellerId()
{
BagDML bagdml = new BagDML();
ClearDatabase();
InsertTestData();
Bag expected = new Bag(1);
Bag actual = bagdml.Select_Single("sellerId:1");
Assert.AreEqual(expected, actual);
}
public void Insert_Single_Inserts_Bag()
{
ClearDatabase();
BagDML bagdml = new BagDML();
Bag expected = new Bag(0);
bagdml.Insert_Single(expected);
Bag actual = getMultipleBags()[0];
bool eql = expected.Equals(actual);
Assert.AreEqual(expected, actual);
}
public void Update_Single_Updates_Row_Matching_Id()
{
ClearDatabase();
InsertTestData();
BagDML bagdml = new BagDML();
Bag expected = new Bag(1, 2, DateTime.Now);
bagdml.Update_Single(expected);
Bag actual = getBagById(1);
Assert.AreEqual(expected, actual);
}
public void Select_Single_With_No_Conditions_Throws_ArgumentException()
{
BagDML bagdml = new BagDML();
ArgumentException expected = null;
try
{
bagdml.Select_Single("");
}
catch (ArgumentException e)
{
expected = e;
}
Assert.IsNotNull(expected);
}
public void Update_Single_Given_Bag_Without_Id_Throws_ArgumentException()
{
BagDML bagdml = new BagDML();
ArgumentException expected = null;
Bag bag = new Bag(0);
try
{
bagdml.Update_Single(bag);
}
catch (ArgumentException e)
{
expected = e;
}
Assert.IsNotNull(expected);
}
public void Insert_Single_Runs_Without_Errors()
{
ClearDatabase();
BagDML bagdml = new BagDML();
Bag bag = new Bag(0);
try
{
bagdml.Insert_Single(bag);
Assert.IsTrue(true);
}
catch (Exception e)
{
Console.WriteLine(e);
Assert.Fail();
}
}
public void Delete_Single_Deletes_Single_Entry()
{
BagDML bagDML = new BagDML();
ClearDatabase();
InsertTestData();
int expected = Count() - 1;
Bag bag = new Bag(1, 1, DateTime.Now);
bagDML.Delete_Single(bag);
int actual = Count();
Assert.AreEqual(expected, actual);
}
public void Insert_Multiple_Inserts_Bags()
{
ClearDatabase();
BagDML bagdml = new BagDML();
List <Bag> expected = new List <Bag>()
{
new Bag(0),
new Bag(0)
};
bagdml.Insert_Multiple(expected);
List <Bag> actual = getMultipleBags();
for (int i = 0; i < actual.Count; i++)
{
Assert.AreEqual(expected[i], actual[i]);
}
}
public void Select_Multiple_Returns_Multiple_Elements_Matching_SellerId()
{
ClearDatabase();
BagDML bagdml = new BagDML();
InsertTestData();
List <Bag> expected = new List <Bag> {
new Bag(1),
new Bag(1)
};
List <Bag> actual = bagdml.Select_Multiple("sellerId:1");
// Do not know another way to compare list items
for (int i = 0; i < actual.Count; i++)
{
Assert.AreEqual(expected[i], actual[i]);
}
}
public void Update_Multiple_Given_Bag_Without_Id_Throws_ArgumentException()
{
BagDML bagdml = new BagDML();
ArgumentException expected = null;
List <Bag> bags = new List <Bag> {
new Bag(0),
new Bag(0)
};
try
{
bagdml.Update_Multiple(bags);
}
catch (ArgumentException e)
{
expected = e;
}
Assert.IsNotNull(expected);
}
public void Update_Multiple_Updates_Row_Matching_Id()
{
BagDML bagdml = new BagDML();
ClearDatabase();
InsertTestData();
List <Bag> expected = new List <Bag> {
new Bag(1, 2, DateTime.Now),
new Bag(2, 2, DateTime.Now),
new Bag(3, 1, DateTime.Now)
};
bagdml.Update_Multiple(expected);
List <Bag> actual = getMultipleBags();
for (int i = 0; i < actual.Count; i++)
{
Assert.AreEqual(expected[i], actual[i]);
}
}
public void Delete_Multiple_Deletes_Multiple_Entries()
{
BagDML bagdml = new BagDML();
ClearDatabase();
InsertTestData();
int expected = Count() - 2;
List <Bag> bags = new List <Bag>
{
new Bag(1, 1, DateTime.Now),
new Bag(2, 1, DateTime.Now),
};
bagdml.Delete_Multiple(bags);
int actual = Count();
Assert.AreEqual(expected, actual);
}
public void Insert_Multiple_Runs_Without_Errors()
{
ClearDatabase();
BagDML bagdml = new BagDML();
List <Bag> bags = new List <Bag>()
{
new Bag(0),
new Bag(0)
};
try
{
bagdml.Insert_Multiple(bags);
// Pass test if it runs without error
Assert.IsTrue(true);
}
catch (Exception e)
{
Console.WriteLine(e);
Assert.Fail();
}
}
public void Delete_Multiple_Runs_Without_Errors()
{
BagDML bagdml = new BagDML();
List <Bag> bags = new List <Bag>
{
new Bag(0),
new Bag(0)
};
ArgumentException expected = null;
try
{
bagdml.Delete_Multiple(bags);
}
catch (ArgumentException e)
{
expected = e;
}
Assert.IsNotNull(expected);
}