public IEnumerable <City> LoadCities()
{
string citiesFilePath = Path.Combine(settings.GameDirectoryPath, "game", "common", "province_setup.csv");
IRepository <CityEntity> vanillaCityRepository = new CsvRepository <CityEntity>(citiesFilePath);
return(vanillaCityRepository.GetAll().ToServiceModels());
}
public async Task FindEmployees_ReturnsListOfAllmployees_IfInvoked()
{
CsvRepository csvRepository = new CsvRepository();
var result = await csvRepository.FindEmployees("EmployeeData.csv");
Assert.Equal(5, result.Count);
}
public CsvRepositoryTest()
{
// Определение пути тестовой директории
_testDir = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments), "ExpertSystem");
// Создание тестовой директории
Directory.CreateDirectory(_testDir);
// Определение имени тестового CSV файла
_testCsvFileName = Path.Combine(_testDir, "csvTest.csv");
// Определение имени тестового WAL файла
_testWalFileName = Path.Combine(_testDir, "walTest.txt");
// Обновление тестовых CSV данных
UpdateTestCsvData();
// Создание мока репозитория
var serializer = new CustomSocketSerializer();
var parser = new CsvRecordParser <CustomSocket>(serializer);
var options = new CsvRepositoryOptions
{
CsvFileName = _testCsvFileName,
WalFileName = _testWalFileName,
IdPropertyName = "SocketName"
};
_repositoryMock = new CsvRepository <CustomSocket>(serializer, parser, options);
// Синхронизируем репозиторий
UpdateTestWalData();
_repositoryMock.Sync();
}
void WriteProvincesSetup()
{
string filePath = Path.Combine(settings.ModDirectoryPath, "common", "province_setup.csv");
string fileContent = "#ProvID;Culture;Religion;TradeGoods;Citizens;Freedmen;Slaves;Tribesmen;Civilization;Barbarian;NameRef;AraRef" + Environment.NewLine;
IRepository <CityEntity> repo = new CsvRepository <CityEntity>(filePath);
foreach (City city in entityManager.GetCities())
{
repo.Add(city.ToDataObject());
fileContent +=
$"{city.Id}," +
$"{city.CultureId}," +
$"{city.ReligionId}," +
$"{city.TradeGoodId}," +
$"{city.CitizensCount}," +
$"{city.FreemenCount}," +
$"{city.TribesmenCount}," +
$"{city.SlavesCount}," +
$"{city.CivilizationLevel}," +
$"{city.BarbarianLevel}," +
$"{city.NameId}," +
$"{city.ProvinceId}" + Environment.NewLine;
}
WriteUnicodeFile(filePath, fileContent);
}
public void BasictestToReturnDataFromEmbeddedResource()
{
CsvRepository r = new CsvRepository("market.csv");
var res = r.RetrieveAvailableLenders();
Assert.AreEqual(7, res.Count);
}
public static List <BirthdayMessage> FromCsvFile(string filename, DateTime today)
{
IRepository <Employee> repository = new CsvRepository(filename);
var birthdayMessages = new BirthdayStoreService(repository);
return(birthdayMessages.CreateMessages(today));
}
public void load_lenders_from_a_csv_file()
{
var location = $"{AppDomain.CurrentDomain.SetupInformation.ApplicationBase}\\market.csv";
var repository = new CsvRepository(location);
var lenders = repository.GetLenders();
Assert.IsTrue(lenders.Any());
}
public void invalid_csv_file_location_should_have_empty_lenders()
{
var location = $"{AppDomain.CurrentDomain.SetupInformation.ApplicationBase}\\doesnotexists.csv";
var repository = new CsvRepository(location);
var lenders = repository.GetLenders();
Assert.IsFalse(lenders.Any());
}
public void TestThatGetUniqueWorksWhenFileNotThere()
{
// Arrange
var csvName = Path.GetTempFileName() + ".csv";
var sut = new CsvRepository(csvName);
// Act
var res = sut.GetUniqueNewNumber2(new DateTime(2018, 4, 5), "031069-0503", "Anders Juul", "Grass");
// Assert
Assert.AreEqual("20180405-01", res.Id);
}
public void AddOrderToRepository_CheckTotalCount()
{
var csvRepository = new CsvRepository();
csvRepository.LoadFiles();
NorthWind nw = new NorthWind(csvRepository);
int totalOrdersBefore = nw.Orders.Count();
nw.AddOrder("Doegn Netto", "Rued Langgaards Vej 23a", "Copenhagen", "South", "2300", "Denmark");
int totalOrdersAfter = nw.Orders.Count();
Assert.AreEqual(totalOrdersBefore + 1, totalOrdersAfter);
}
public void Get_Product_With_Id_11()
{
var csvRepository = new CsvRepository();
csvRepository.LoadFiles();
NorthWind nw = new NorthWind(csvRepository);
var products = nw.Products;
var productName = (from p in products
where p.ProductID == 11
select p.ProductName).FirstOrDefault();
string expectedResult = "Queso Cabrales";
Assert.AreEqual(productName, expectedResult);
}
public void Get_Order_With_Id_10571()
{
var csvRepository = new CsvRepository();
csvRepository.LoadFiles();
NorthWind nw = new NorthWind(csvRepository);
var orders = nw.Orders;
var productName = (from o in orders
where o.OrderID == 10571
select o.ShipName).FirstOrDefault();
string expectedResult = "Ernst Handel";
Assert.AreEqual(productName, expectedResult);
}
private static void Main()
{
var dataDir = new DirectoryInfo(@"C:\historicaldata");
var csvRepo = new CsvRepository(dataDir);
var sqlRepo = new SqlRepository(@"Data Source=.;Initial Catalog=HistoricalQuotes;Integrated Security=True");
string processedFilesDir = Path.Combine(@"C:\historicaldata", "processed");
if (!Directory.Exists(processedFilesDir))
{
Directory.CreateDirectory(processedFilesDir);
}
FileInfo[] files = dataDir.GetFiles();
foreach (FileInfo file in files)
{
string symbol = Path.GetFileNameWithoutExtension(file.Name);
Console.Write(symbol);
IEnumerable<Quote> quotes = csvRepo.Set<Quote>(new Query {Symbol = symbol});
var fromDate = new DateTime(2011, 1, 1);
var toDate = new DateTime(2011, 12, 31);
// we're only interested in 2011 data
sqlRepo.AddMany(quotes.Where(q => q.Timestamp >= fromDate && q.Timestamp <= toDate));
string processedFileName = Path.Combine(processedFilesDir, file.Name);
if (File.Exists(processedFileName))
{
Console.Write("...Error (symbol already processed)");
Console.WriteLine();
continue;
}
if (file.Exists)
{
file.MoveTo(processedFileName);
}
Console.Write("...Done");
Console.WriteLine();
}
}
public static IRepository <IBasic> GetRepository(DataSource repositoryType)
{
IRepository <IBasic> repo = null;
switch (repositoryType)
{
//break;
case DataSource.Csv:
repo = new CsvRepository();
break;
case DataSource.Oracle:
repo = new OracleRepository();
break;
default:
throw new ArgumentException("Invalid Repository Type");
}
return(repo);
}
private Program(ServerProgramOptions options) : base(options)
{
var dataPath = Path.Combine(GetThisFileDirectory(), "..", "..", "data", "csvdb");
var socketSerializer = new CustomSocketSerializer();
var socketParser = new CsvRecordParser <CustomSocket>(socketSerializer);
var socketOptions = new CsvRepositoryOptions
{
IdPropertyName = "SocketName",
CsvFileName = Path.Combine(dataPath, "socket.csv"),
WalFileName = Path.Combine(dataPath, "wal_socket.txt")
};
var socketsRepository =
new CsvRepository <CustomSocket>(socketSerializer, socketParser, socketOptions).Sync();
var socketService = new SocketService(socketsRepository);
var socketGroupSerializer = new SocketGroupSerializer();
var socketGroupParser = new CsvRecordParser <SocketGroup>(socketGroupSerializer);
var socketGroupOptions = new CsvRepositoryOptions
{
IdPropertyName = "GroupName",
CsvFileName = Path.Combine(dataPath, "socketGroup.csv"),
WalFileName = Path.Combine(dataPath, "wal_socketGroup.txt")
};
var socketGroupRepository =
new CsvRepository <SocketGroup>(socketGroupSerializer, socketGroupParser, socketGroupOptions).Sync();
var socketGroupService = new GroupService(socketGroupRepository);
var socketExchangeOptions = new SocketExchangeOptions {
Version = Options.Version, Debug = options.Debug
};
var socketExchange = new SocketExchangeImpl(socketService, socketGroupService, socketExchangeOptions);
Server = new Grpc.Core.Server
{
Services = { SocketExchange.BindService(socketExchange) },
Ports = { new ServerPort("localhost", Options.Port, ServerCredentials.Insecure) }
};
}
public static IPersonReader GetRepository(string repositoryType)
{
IPersonReader personRepository;
switch (repositoryType)
{
case "Service":
personRepository = new ServiceRepository();
break;
case "CSV":
personRepository = new CsvRepository();
break;
case "SQL":
personRepository = new SqlRepository();
break;
default:
throw new ArgumentException("Argument not valid");
}
return(personRepository);
}
public GroupService(CsvRepository <SocketGroup> groupRepository)
{
_groupRepository = groupRepository;
}
public SocketService(CsvRepository <CustomSocket> socketRepository)
{
_socketRepository = socketRepository;
}
