// Получение погодных данных для города с порядковым номером 2
// за дату date
public List<City2Entity> GetCity2Weather(WeatherService wservice,
string date)
{
List<City2Entity> queryResult = new List<City2Entity>();
try
{
// Подключаемся к СУБД
WeatherDBEntity weatherDB = new WeatherDBEntity(wservice.ConnectionString);
// Запрос погодных данных за дату date
queryResult =
(from item in weatherDB.City2Entity.ToList<City2Entity>().AsParallel()
where item.Date.Contains(date)
orderby item.Date descending
select item).ToList<City2Entity>();
weatherDB.Dispose();
}
catch (Exception exception)
{
// Делаем запись в лог файл
Logger.WriteLog(System.DateTime.Now.ToString()
+ " "
+ exception.TargetSite.ToString()
+ " "
+ exception.Message);
}
return queryResult;
}
public void WeatherServiceInitTest()
{
WeatherService wService1 = new WeatherService("Yahoo", "CnctStr1");
WeatherService wService2 = new WeatherService("Yandex", "CnctStr2");
// Сравниваем ожидаемые и фактические значения
Assert.AreEqual("Yahoo", wService1.Name);
Assert.AreEqual("Yandex", wService2.Name);
Assert.AreEqual("CnctStr1", wService1.ConnectionString);
Assert.AreEqual("CnctStr2", wService2.ConnectionString);
}
public void ReadFromDBTest_2()
{
// Формируем объекты класса WeatherService
EntityConnectionStringBuilder ConnectionString = new EntityConnectionStringBuilder();
ConnectionString.ProviderConnectionString =
@"data source=../../Test_Data/ReadFromDBTest_2/YahooWeatherDB.sqlite";
ConnectionString.Provider = @"System.Data.SQLite";
ConnectionString.Metadata = @"res://*/Model1.csdl|res://*/Model1.ssdl|res://*/Model1.msl";
WeatherService wService1 = new WeatherService("Yahoo", ConnectionString.ToString());
ConnectionString.ProviderConnectionString =
@"data source=../../Test_Data/ReadFromDBTest_2/YandexWeatherDB.sqlite";
WeatherService wService2 = new WeatherService("Yandex", ConnectionString.ToString());
// Параметр даты для запроса к БД
LittleLogger logger =
new LittleLogger("../../Test_Data/ReadFromDBTest_2/log.txt");
DateString dateStr = new DateString(logger);
string date1 = dateStr.GetYahooDate("05.06.2014");
string date2 = dateStr.GetYandexDate("05.06.2014");
// Запрос погодных данных за 05.06.2014
Forecaster forecaster = new Forecaster(logger);
List<City1Entity> weather1_1 = forecaster.GetCity1Weather(wService1, date1);
List<City2Entity> weather1_2 = forecaster.GetCity2Weather(wService1, date1);
List<City3Entity> weather1_3 = forecaster.GetCity3Weather(wService1, date1);
List<City1Entity> weather2_1 = forecaster.GetCity1Weather(wService2, date2);
List<City2Entity> weather2_2 = forecaster.GetCity2Weather(wService2, date2);
List<City3Entity> weather2_3 = forecaster.GetCity3Weather(wService2, date2);
// Сравниваем ожидаемые и фактические значения
Assert.AreEqual(5, weather1_1.Count);
Assert.AreEqual(3, weather1_2.Count);
Assert.AreEqual(4, weather1_3.Count);
Assert.AreEqual(10, weather2_1.Count);
Assert.AreEqual(9, weather2_2.Count);
Assert.AreEqual(8, weather2_3.Count);
}
public void ReadFromDBTest_1()
{
// Формируем объект класса WeatherService
EntityConnectionStringBuilder ConnectionString = new EntityConnectionStringBuilder();
ConnectionString.ProviderConnectionString =
@"data source=../../Test_Data/ReadFromDBTest_1/YandexWeatherDB.sqlite";
ConnectionString.Provider = @"System.Data.SQLite";
ConnectionString.Metadata = @"res://*/Model1.csdl|res://*/Model1.ssdl|res://*/Model1.msl";
WeatherService wService = new WeatherService("Yandex", ConnectionString.ToString());
// Параметр даты для запроса к СУБД
LittleLogger logger =
new LittleLogger("../../Test_Data/ReadFromDBTest_1/log.txt");
DateString dateStr = new DateString(logger);
string date = dateStr.GetYandexDate("05.06.2014");
// Запрос погодных данных за 05.06.2014
Forecaster forecaster = new Forecaster(logger);
List<City1Entity> weather = forecaster.GetCity1Weather(wService, date);
// Сравниваем ожидаемые и фактические значения
Assert.AreEqual("2014-06-05 T22:58:10", weather[0].Date);
}
