public void TestDateTimeToString(Type type, object value, string expected, TimeZoneInfo timeZoneInfo) { var converter = new CsvSheetConverter("csvdata", timeZoneInfo, fileSystem: _fileSystem); var data = converter.ValueToString(type, value); Assert.Equal(expected, data); }
public void TestStringToDateTime(Type type, string data, object expected, TimeZoneInfo timeZoneInfo) { var converter = new CsvSheetConverter("csvdata", timeZoneInfo, fileSystem: _fileSystem); var value = converter.StringToValue(type, data); Assert.Equal(expected, value); }
public CsvImportTests() { _fileSystem = new TestFileSystem(); _logger = new TestLogger(); _container = new TestSheetContainer(_logger); _converter = new CsvSheetConverter("testdata", TimeZoneInfo.Utc, fileSystem: _fileSystem); }
static async void OnPostprocessAllAssets(string[] importedAssets, string[] deletedAssets, string[] movedAssets, string[] movedFromAssetPaths) { // automatically run postprocessor if any excel file is imported string csvAsset = importedAssets.FirstOrDefault(x => x.EndsWith(".csv")); if (csvAsset != null) { var csvPath = Path.GetDirectoryName(csvAsset); var resultPath = Path.Combine(Application.streamingAssetsPath, "CSV"); var logger = new UnityLogger(); var sheetContainer = new SheetContainer(logger); // create csv converter from path var csvImporter = new CsvSheetConverter(csvPath, TimeZoneInfo.Utc); // bake sheets from csv converter await sheetContainer.Bake(csvImporter); // create csv converter to path var csvExporter = new CsvSheetConverter(resultPath, TimeZoneInfo.Utc); // save datasheet to streaming assets await sheetContainer.Store(csvExporter); AssetDatabase.Refresh(); Debug.Log("CSV sheet converted."); } }
public MultiConvertTests() { _fileSystem = new TestFileSystem(); _logger = new TestLogger(); _container = new TestSheetContainer(_logger); _csvConverter = new CsvSheetConverter("csvdata", TimeZoneInfo.Utc, fileSystem: _fileSystem); _jsonConverter = new JsonSheetConverter("jsondata", fileSystem: _fileSystem); }