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);
}
