public async Task ExecuteAsync_SourceJsonFilePathIsNullOrEmpty_ReturnFailureWithCorrectMessage(
string sourceJsonFilePath)
{
// Arrange
_transformOptions.SourceJsonFilePath = sourceJsonFilePath;
// Act
var transformResult = await _testModule.ExecuteAsync(_transformOptions);
// Assert
Assert.True(transformResult.Failure);
Assert.Equal("Source file path is incorrect", transformResult.ToString());
}
static async Task Main(string[] args)
{
try
{
var version = Assembly.GetEntryAssembly().GetCustomAttribute <AssemblyInformationalVersionAttribute>()
.InformationalVersion;
Console.WriteLine("j2s - JSON to SQL files transformer.");
Console.WriteLine($"Version: {version}");
Console.WriteLine();
Console.WriteLine("Arguments:");
Console.WriteLine("\t--source-json=<path> Full path to source *.json file");
Console.WriteLine("\t--source-json-type=<type> One of available source JSON file types");
Console.WriteLine("\t--target-sql=<sql> One of available target SQL databases");
Console.WriteLine("\t--table-name=<name> Name of SQL table");
Console.WriteLine("\t--schema=<schema_name> Name of SQL table schema");
Console.WriteLine("\t--limit-inserts=<number> Max rows in INSERT statement per 1 *.sql file");
Console.WriteLine("\t--columns-definition-file=<path> Full path to *.json file for SQL table columns definition");
Console.WriteLine();
if (args == null || args.Length == 0)
{
return;
}
var jsonSourceFilePath = GetArgumentValue("--source-json", args);
var jsonSourceFileType = GetArgumentValue("--source-json-type", args);
if (!AvailableSourceJsonFileTypes.ContainsKey(jsonSourceFileType))
{
var errorBuilder = new StringBuilder();
errorBuilder.Append("Sorry, but now supports only next source json file types:");
foreach (var item in AvailableSourceJsonFileTypes)
{
errorBuilder.Append($"\n * {item.Key} - {item.Value};");
}
throw new ArgumentException(errorBuilder.ToString());
}
var targetSqlType = GetArgumentValue("--target-sql", args);
if (!AvailableSqlTypes.ContainsKey(targetSqlType))
{
var errorBuilder = new StringBuilder();
errorBuilder.Append("Sorry, but now supports only next SQL databases:");
foreach (var item in AvailableSqlTypes)
{
errorBuilder.Append($"\n * {item.Key} - {item.Value};");
}
throw new ArgumentException(errorBuilder.ToString());
}
var tableName = GetArgumentValue("--table-name", args);
var schema = GetArgumentValue("--schema", args);
var limitInserts = Convert.ToInt32(GetArgumentValue("--limit-inserts", args));
var columnsDefinitionFilePath = GetArgumentValue("--columns-definition-file", args);
var tableColumns = ParseTableDeColumnsDefinition(columnsDefinitionFilePath);
var jsonFileReader = new MongoDbCompass_1_17_0_JsonFileReader();
var fileWriter = new FileWriter();
var sqlBuilder = new PostgreSqlBuilder(tableColumns);
var transformer =
new Json2SqlTransformer(jsonFileReader, fileWriter, sqlBuilder);
var transformOptions = new Json2SqlTransformOptions()
{
SourceJsonFilePath = jsonSourceFilePath,
TableName = tableName,
TableSchema = schema,
MaxLinesPer1InsertValuesSqlFile = limitInserts
};
var transformResult = await transformer.ExecuteAsync(transformOptions);
if (transformResult.Success)
{
Console.WriteLine("Transform success!");
}
else
{
Error(transformResult.ToString());
}
}
catch (Exception ex)
{
Error(ex.Message);
}
Console.WriteLine("\nPress any key for exit...");
Console.ReadLine();
}