public void test_SelectBetweenTeams()
{
/* Test with test data , kärpät, tps and tappara. Function should
* returns all rows which contain only teams from parameter list (=6). */
List <string> teams = new List <string>();
teams.Add("Kärpät");
teams.Add("Tappara");
teams.Add("TPS");
MatchQuery mq = new MatchQuery();
mq.addSubQuery(db.SelectBetweenTeams(teams));
List <Match> rows = db.QueryMatches(mq.getQueryString());
Assert.AreEqual(6, rows.Count);
teams.Clear();
teams.Add("TPS");
teams.Add("TPS");
teams.Add("TPS");
mq.clearSubQueries();
mq.addSubQuery(db.SelectBetweenTeams(teams));
rows = db.QueryMatches(mq.getQueryString());
Assert.AreEqual(0, rows.Count);
}
public void test_clearSubQueries()
{
MatchQuery mq = new MatchQuery();
mq.addSubQuery("test");
mq.clearSubQueries();
Assert.AreEqual(0, mq.get_sub_queries().Count);
}
public void test_SelectWhereGD_GD_0()
{
MatchQuery mq = new MatchQuery();
mq.addSubQuery(db.SelectWhereGD(0, false));
List <Match> matches = db.QueryMatches(mq.getQueryString());
Assert.AreEqual(0, matches.Count);
mq.clearSubQueries();
mq.addSubQuery(db.SelectWhereGD(0, true));
matches = db.QueryMatches(mq.getQueryString());
Assert.AreEqual(18, matches.Count);
}
public void test_SelectWhereGD_GD_negative()
{
/*negative goal difference is changed to 0, so test results should be equal
* to test_SelectWhereGD_GD_0().*/
MatchQuery mq = new MatchQuery();
mq.addSubQuery(db.SelectWhereGD(-1, false));
List <Match> matches = db.QueryMatches(mq.getQueryString());
Assert.AreEqual(0, matches.Count);
mq.clearSubQueries();
mq.addSubQuery(db.SelectWhereGD(-2, true));
matches = db.QueryMatches(mq.getQueryString());
Assert.AreEqual(18, matches.Count);
}
public void test_SelectBetweenTeamsFromSeasons()
{
MatchQuery mq = new MatchQuery();
List <string> teams = new List <string>()
{
"Kärpät", "Tappara"
};
List <string> seasons = new List <string>()
{
"16-17"
};
mq.addSubQuery(db.SelectBetweenTeamsFromSeasons(teams, seasons));
List <Match> matches = db.QueryMatches(mq.getQueryString());
Assert.AreEqual(2, matches.Count);
seasons.RemoveAt(0);
mq.clearSubQueries();
mq.addSubQuery(db.SelectBetweenTeamsFromSeasons(teams, seasons));
matches = db.QueryMatches(mq.getQueryString());
Assert.AreEqual(4, matches.Count);
}
public void test_SelectBeforeOrAfterDate_teamOverload()
{
/* 1. Test with incorrect date format, should throw DateConversionError
* 2. Test with a list of Kärpät, Kärpät after date '2017/03/25'.
* Should return 2 matches.
* 3. Test with list of Kärpät, Kärpät, TPS after date '2017-03-25.
* Should return 3 matches.'*/
List <string> teams = new List <string>()
{
"Kärpät", "Kärpät"
};
MatchQuery mq = new MatchQuery();
mq.addSubQuery(db.SelectBeforeOrAfterDate(teams, "2017/03/25", true));
List <Match> rows = db.QueryMatches(mq.getQueryString());
Assert.AreEqual(2, rows.Count);
teams.Add("TPS");
mq.clearSubQueries();
mq.addSubQuery(db.SelectBeforeOrAfterDate(teams, "2017-03-25", true));
rows = db.QueryMatches(mq.getQueryString());
Assert.AreEqual(3, rows.Count);
}
