public void EndsWithTest()
{
Expect.IsTrue(_testDatabases.Count > 0);
string methodName = MethodBase.GetCurrentMethod().Name;
string endsWith = 7.RandomLetters();
_testDatabases.Each(db =>
{
OutLineFormat("{0}.{1}: {2}", ConsoleColor.DarkYellow, this.GetType().Name, methodName, db.GetType().Name);
3.Times(i =>
{
DataTools.CreateTestTable("{0}{1}"._Format(4.RandomLetters(), endsWith), db);
});
5.Times(i =>
{
DataTools.CreateTestTable(11.RandomLetters(), db);
});
TestTableCollection endsWithResults = TestTable.Where(c => c.Name.EndsWith(endsWith), db);
Expect.AreEqual(3, endsWithResults.Count);
TestTableCollection doesntEndWithResults = TestTable.Where(c => c.Name.DoesntEndWith(endsWith), db);
Expect.IsTrue(doesntEndWithResults.Count > 0);
doesntEndWithResults.Each(endsWithResults.ToList(), (ewr, tt) =>
{
Expect.IsFalse(ewr.Contains(tt));
});
});
}
public void TopQueryTest()
{
Setup();
CleanUp();
Setup();
Expect.IsTrue(_testDatabases.Count > 0);
string startsWith = 8.RandomLetters();
string methodName = MethodBase.GetCurrentMethod().Name;
_testDatabases.Each(db =>
{
OutLineFormat("{0}.{1}: {2}", ConsoleColor.DarkYellow, this.GetType().Name, methodName, db.GetType().Name);
8.Times(i =>
{
DataTools.CreateTestTable("{0}_{1}"._Format(startsWith, 6.RandomLetters()), db);
});
3.Times(i =>
{
DataTools.CreateTestTable(5.RandomLetters(), db);
});
TestTableCollection top4 = TestTable.Top(4, c => c.Name.StartsWith(startsWith), db);
Expect.AreEqual(4, top4.Count);
});
}
public void OrTest()
{
Expect.IsTrue(_testDatabases.Count > 0);
string methodName = MethodBase.GetCurrentMethod().Name;
string one = 4.RandomLetters();
string two = 4.RandomLetters();
_testDatabases.Each(db =>
{
OutLineFormat("{0}.{1}: {2}", ConsoleColor.DarkYellow, this.GetType().Name, methodName, db.GetType().Name);
TestTable first = DataTools.CreateTestTable("{0}_{1}"._Format(one, 4.RandomLetters()), db);
TestTable second = DataTools.CreateTestTable("{0}_{1}"._Format(two, 4.RandomLetters()), db);
TestTable third = DataTools.CreateTestTable(8.RandomLetters(), db);
TestTableCollection results = TestTable.Where(c => c.Name.StartsWith(one).Or(c.Name.StartsWith(two)), db);
Expect.AreEqual(2, results.Count);
List <TestTable> list = results.ToList();
Expect.IsTrue(list.Contains(first));
Expect.IsTrue(list.Contains(second));
Expect.IsFalse(list.Contains(third));
results = TestTable.Where(c => c.Name.StartsWith(one) || c.Name.StartsWith(two), db);
Expect.AreEqual(2, results.Count);
list = results.ToList();
Expect.IsTrue(list.Contains(first));
Expect.IsTrue(list.Contains(second));
Expect.IsFalse(list.Contains(third));
});
}
private static TestTableCollection CreateTestTableEntries(string name, Database db)
{
TestTableCollection testTables = new TestTableCollection();
8.Times(i =>
{
testTables.Add(DataTools.CreateTestTable("{0}_{1}"._Format(name, 10.RandomLetters()), "Description ".RandomLetters(6), db, false));
});
4.Times(i =>
{
testTables.Add(DataTools.CreateTestTable("{0}_{1}"._Format(8.RandomLetters(), name), "Different Description ".RandomLetters(4), db, false));
});
testTables.Save(db);
return(testTables);
}
public void InQueryTest()
{
Expect.IsTrue(_testDatabases.Count > 0);
string methodName = MethodBase.GetCurrentMethod().Name;
_testDatabases.Each(db =>
{
OutLineFormat("{0}.{1}: {2}", ConsoleColor.DarkYellow, this.GetType().Name, methodName, db.GetType().Name);
List <TestTable> tables = new List <TestTable>();
8.Times(i =>
{
tables.Add(DataTools.CreateTestTable(4.RandomLetters(), db));
});
Expect.AreEqual(8, tables.Count);
List <long> ids = new List <long>(tables.Select(t => t.Id.Value).ToArray());
TestTableCollection retrieved = TestTable.Where(c => c.Id.In(ids.ToArray()), db);
Expect.AreEqual(tables.Count, retrieved.Count);
});
}
public void AndTest()
{
Expect.IsTrue(_testDatabases.Count > 0);
string methodName = MethodBase.GetCurrentMethod().Name;
string nameStartsWith = 4.RandomLetters();
string descriptionStartsWith = 4.RandomLetters();
_testDatabases.Each(db =>
{
OutLineFormat("{0}.{1}: {2}", ConsoleColor.DarkYellow, this.GetType().Name, methodName, db.GetType().Name);
TestTable one = DataTools.CreateTestTable("{0}_{1}"._Format(nameStartsWith, 4.RandomLetters()), "{0}_{1}"._Format(descriptionStartsWith, 4.RandomLetters()), db);
TestTable two = DataTools.CreateTestTable("{0}_{1}"._Format(nameStartsWith, 4.RandomLetters()), "{0}_{1}"._Format(descriptionStartsWith, 4.RandomLetters()), db);
TestTable three = DataTools.CreateTestTable(nameStartsWith, db);
TestTableCollection results = TestTable.Where(c => c.Name.StartsWith(nameStartsWith).And(c.Description.StartsWith(descriptionStartsWith)), db);
TestTableCollection results2 = TestTable.Where(c => c.Name.StartsWith(nameStartsWith) && c.Description.StartsWith(descriptionStartsWith), db);
Expect.AreEqual(2, results.Count);
Expect.AreEqual(2, results2.Count);
});
}
