public void AddExtraNumberFields_Should_Add_Label_And_Message_Fields_With_Lenghts_When_Where_Are_In_OutExtraNumberFields()
{
// Arrange
string label = "label";
int length = 100;
string message = "message";
int lengthMessage = 200;
string dummy = "dummy";
string lengthDummy = "xxx";
string fieldName = $"{label}={length},{message}={lengthMessage},{dummy}={lengthDummy}";
this.configMock.Setup(m => m.OutExtraNumberFields).Returns(fieldName);
GenerateFiles generateFiles = new GenerateFiles(this.config, this.spreadsheet, this.fileSystem, this.outputWriter);
Header header = new Header();
// Act
generateFiles.AddExtraNumberFields(header);
// Assert
header.Fields.Find(f => f.Name == label).Length.Should().Be(length);
header.Fields.Find(f => f.Name == message).Length.Should().Be(lengthMessage);
header.Fields.Find(f => f.Name == dummy).Length.Should().Be(10);
}
public List <GeneralFileModel> DeleteDuplicateFiles(string [] files)
{
GenerateFiles gf = new GenerateFiles();
var allFiles = gf.StringsToModels(files);
return(new FileModelDeleteDuplicates(new FileHasherMd5()).Run(allFiles));
}
private static void CreateFiles(Template T)
{
ODMSetting ODMSetting = Context.ODMSettingRepository.FindBy(x => x.SettingName == "WORKING_DIR").FirstOrDefault();
GenerateFiles.GeneratePARFile(ODMSetting.SettingValue + '\\' + T.PARFileName.ToString(), T.Id.ToString());
GenerateFiles.GenerateBATFile(ODMSetting.SettingValue + '\\' + T.BATFileName.ToString(), T.Id.ToString());
Utility.ExecuteAsAdmin(ODMSetting.SettingValue + '\\' + T.BATFileName.ToString());
}
public void CreateSqlScript_Return_Oracle_Script_When_Vendor_Is_Postpres()
{
// Arrange
this.configMock.Setup(c => c.DatabaseVendor).Returns(DatabaseEnum.Vendor.Oracle);
this.configMock.Setup(c => c.OutTablename).Returns("person");
GenerateFiles generateFiles = new GenerateFiles(this.config, this.spreadsheet, this.fileSystem, this.outputWriter);
List <string> lines = new List <string>();
this.fileSystemMock.Setup(o => o.WriteAllLines(It.IsAny <string>(), It.IsAny <List <string> >(), It.IsAny <Encoding>())).Callback((string path, List <string> contents, Encoding encoding) => lines = contents);
Header header = new Header
{
Fields = new List <Field>
{
new Field
{
Column = 0,
Extra = false,
Length = 10,
Row = 0,
Text = "Name",
Type = DatabaseEnum.TypeField.Text
},
new Field
{
Column = 1,
Extra = false,
Length = 20,
Row = 0,
Text = "BirthDay",
Type = DatabaseEnum.TypeField.Date
},
new Field
{
Column = 2,
Extra = true,
Length = 9,
Row = 0,
Text = "Id",
Type = DatabaseEnum.TypeField.Number
}
}
};
// Act
bool result = generateFiles.CreateSqlScript(header);
// Assert
result.Should().BeTrue();
lines.Count.Should().BeGreaterThan(0);
lines[0].Should().Be("CREATE TABLE person (");
lines[1].Should().Be("name VARCHAR2(10),");
lines[2].Should().Be("birthday DATE,");
lines[3].Should().Be("id NUMBER(9));");
lines[4].Should().Be(string.Empty);
lines[5].Should().Be("CREATE UNIQUE INDEX person_pk_index ON person (id);");
}
private void rgvTemplate_cmdGeneratePAR_CommandCellClick(object sender, EventArgs e)
{
gridTimer.Enabled = true;
GridViewCellEventArgs args = (GridViewCellEventArgs)e;
ODMSetting ODMSetting = Context.ODMSettingRepository.FindBy(x => x.SettingName == "WORKING_DIR").FirstOrDefault();
Template tmpl = Context.TemplateRepository.FindBy(x => x.Id == args.Value.ToString()).FirstOrDefault();
GenerateFiles.GeneratePARFile(ODMSetting.SettingValue + '\\' + tmpl.PARFileName.ToString(), args.Value.ToString());
GenerateFiles.GenerateBATFile(ODMSetting.SettingValue + '\\' + tmpl.BATFileName.ToString(), args.Value.ToString());
Utility.ExecuteAsAdmin(ODMSetting.SettingValue + '\\' + tmpl.BATFileName.ToString());
}
public void AddIdField_Should_Add_Id_To_The_Header()
{
// Arrange
GenerateFiles generateFiles = new GenerateFiles(this.config, this.spreadsheet, this.fileSystem, this.outputWriter);
Header header = new Header();
// Act
generateFiles.AddIdField(header);
// Assert
header.Fields.Find(f => f.Name == "id").Length.Should().Be(Constant.Key.ID_LENGHT);
}
public void CreateSqlScript_Return_False_When_Header_Is_Null()
{
// Arrange
GenerateFiles generateFiles = new GenerateFiles(this.config, this.spreadsheet, this.fileSystem, this.outputWriter);
Header header = null;
// Act
bool result = generateFiles.CreateSqlScript(header);
// Assert
result.Should().BeFalse();
}
public void AddExtraFields_Let_Header_Null_When_Is_Null()
{
// Arrange
GenerateFiles generateFiles = new GenerateFiles(this.config, this.spreadsheet, this.fileSystem, this.outputWriter);
Header header = null;
// Act
generateFiles.AddExtraFields(header);
// Assert
header.Should().BeNull();
}
public void InsertSqlScript_Should_Return_0_When_HeaderFileds_And_DataTableRows_Are_Null()
{
// Arrange
GenerateFiles generateFiles = new GenerateFiles(this.config, this.spreadsheet, this.fileSystem, this.outputWriter);
Header header = new Header();
DataTable dataTable = new DataTable();
// Act
int result = generateFiles.InsertSqlScript(header, dataTable);
// Assert
result.Should().Be(0);
}
public void AddExtraDateFields_Let_Header_Null_When_Is_Null()
{
// Arrange
this.configMock.Setup(m => m.OutExtraDateFields).Returns("label");
GenerateFiles generateFiles = new GenerateFiles(this.config, this.spreadsheet, this.fileSystem, this.outputWriter);
Header header = null;
// Act
generateFiles.AddExtraDateFields(header);
// Assert
header.Should().BeNull();
}
public void SetFieldLength_Should_Let_DataTable_And_Null_When_There_Are_Null()
{
// Arrange
DataTable dataTable = null;
Header header = null;
GenerateFiles generateFiles = new GenerateFiles(this.config, this.spreadsheet, this.fileSystem, this.outputWriter);
// Act
generateFiles.SetFieldLength(dataTable, header);
// Assert
dataTable.Should().BeNull();
header.Should().BeNull();
}
public void SetFieldLength_Should_Let_DataTable_Null_When_It_Is_Null()
{
// Arrange
DataTable dataTable = new DataTable();
int dataTableHash = dataTable.GetHashCode();
Header header = null;
GenerateFiles generateFiles = new GenerateFiles(this.config, this.spreadsheet, this.fileSystem, this.outputWriter);
// Act
generateFiles.SetFieldLength(dataTable, header);
// Assert
dataTable.GetHashCode().Should().Be(dataTableHash);
}
public void GetHeaderTest_Should_Return_Header_With_8_Fields()
{
// Arrange
GenerateFiles generateFiles = new GenerateFiles(this.config, this.spreadsheet, this.fileSystem, this.outputWriter);
string spreadsheetString = "[{\"Column0\":\"OrderDate\",\"Column1\":\"Region's\",\"Column2\":\"Rep\",\"Column3\":\"Item\",\"Column4\":\"Units\",\"Column5\":\"Unit Cost\",\"Column6\":\"Total\"},{\"Column0\":\"2016-01-06T00:00:00\",\"Column1\":\"East's\",\"Column2\":\"Jones\",\"Column3\":\"Pencil\",\"Column4\":95.0,\"Column5\":1.99,\"Column6\":189.05}]".Replace("\\", "");
DataTable dataTable = JsonConvert.DeserializeObject <DataTable>(spreadsheetString);
// Act
Header header = generateFiles.GetHeader(dataTable);
// Assert
header.Should().NotBeNull();
header.Fields.Count.Should().Be(8);
}
public void InsertSqlScript_Should_Return_0_When_DataTable_Is_Null()
{
// Arrange
GenerateFiles generateFiles = new GenerateFiles(this.config, this.spreadsheet, this.fileSystem, this.outputWriter);
Header header = new Header
{
Fields = new List <Field>()
};
DataTable dataTable = null;
// Act
int result = generateFiles.InsertSqlScript(header, dataTable);
// Assert
result.Should().Be(0);
}
public void GenerateToXMLTest()
{
GenerateFiles files = GenerateFiles.getInstance();
List <Region> testList = new List <Region>();
testList.Add(new Region("P1", "prueba1"));
testList.Add(new Region("P2", "prueba2"));
StringWriter sw = new StringWriter();
XmlSerializer s = new XmlSerializer(testList.GetType(), new XmlRootAttribute("Data"));
s.Serialize(sw, testList);
var stest = sw.ToString();
var result = files.GenerateToXML <List <Region> >(testList);
Assert.AreEqual(result, stest);
}
public void AddExtraDateFields_Should_Add_Label_Field_And_Length_When_It_Is_a_OutExtraDateFields()
{
// Arrange
string label = "label";
string fieldName = $"{label}";
this.configMock.Setup(m => m.OutExtraDateFields).Returns(fieldName);
GenerateFiles generateFiles = new GenerateFiles(this.config, this.spreadsheet, this.fileSystem, this.outputWriter);
Header header = new Header();
// Act
generateFiles.AddExtraDateFields(header);
// Assert
header.Fields.Find(f => f.Name == label).Length.Should().Be(20);
}
public void AddExtraDateFields_Should_Add_Label_Field_When_It_Is_a_OutExtraDateFields()
{
// Arrange
string fieldName = "label";
this.configMock.Setup(m => m.OutExtraDateFields).Returns(fieldName);
GenerateFiles generateFiles = new GenerateFiles(this.config, this.spreadsheet, this.fileSystem, this.outputWriter);
Header header = new Header();
// Act
generateFiles.AddExtraDateFields(header);
// Assert
header.Fields.Find(f => f.Name == fieldName).Name.Should().Be(fieldName);
header.Fields.Find(f => f.Name == fieldName).Type.Should().Be(DatabaseEnum.TypeField.Date);
header.Fields.Find(f => f.Name == fieldName).Extra.Should().BeTrue();
}
public void RunTest_Return_False_When_Header()
{
// Arrange
//string tabularString = JsonConvert.SerializeObject(tabular).Replace("\"","\\\"");
//string spreadsheetString = "[{\"Column0\":\"OrderDate\",\"Column1\":\"Region's\",\"Column2\":\"Rep\",\"Column3\":\"Item\",\"Column4\":\"Units\",\"Column5\":\"Unit Cost\",\"Column6\":\"Total\"},{\"Column0\":\"2016-01-06T00:00:00\",\"Column1\":\"East's\",\"Column2\":\"Jones\",\"Column3\":\"Pencil\",\"Column4\":95.0,\"Column5\":1.99,\"Column6\":189.05}]".Replace("\\", "");
//DataTable dataTable = JsonConvert.DeserializeObject<DataTable>(spreadsheetString);
spreadsheetMock.Setup(s => s.GetTabular()).Returns((DataTable)null);
GenerateFiles generateFiles = new GenerateFiles(this.config, this.spreadsheet, this.fileSystem, this.outputWriter);
// Act
bool result = generateFiles.Run();
// Assert
result.Should().BeFalse();
spreadsheetMock.Verify(s => s.GetTabular(), Times.Once);
}
public void AddExtraDateFields_Should_Add_Label_And_Message_Fields_With_Lenghts_When_Where_Are_In_OutExtraDateFields()
{
// Arrange
string label = "label";
string message = "messageextralongbighuge";
string fieldName = $"{label},{message}";
this.configMock.Setup(m => m.OutExtraDateFields).Returns(fieldName);
GenerateFiles generateFiles = new GenerateFiles(this.config, this.spreadsheet, this.fileSystem, this.outputWriter);
Header header = new Header();
// Act
generateFiles.AddExtraDateFields(header);
// Assert
header.Fields.Find(f => f.Name == label).Length.Should().Be(20);
header.Fields.Find(f => f.Name == message).Length.Should().Be(30);
}
public void Test9_DeleteDuplicates()
{
if (!Directory.Exists(TestRunDirectoryPath))
{
Setup();
}
IFilesSeeker filesSeeker = new FilesSeeker();
var files = filesSeeker.ByPath(TestRunDirectoryPath);
files = files.Where(x => !x.Contains(".directory")).ToList();
GenerateFiles gf = new GenerateFiles();
var allFiles = gf.StringsToModels(files.ToArray());
var value = new FileModelDeleteDuplicates(new FileHasherMd5()).Run(allFiles);
Assert.AreEqual(CountOfOriginFiles, value.Count);
}
public void GenerateToCSVTest()
{
GenerateFiles files = GenerateFiles.getInstance();
List <Region> testList = new List <Region>();
testList.Add(new Region {
iso = "P1", name = "prueba1"
});
testList.Add(new Region {
iso = "P2", name = "prueba2"
});
StringBuilder sList = new StringBuilder();
sList.Append("iso,name");
sList.Append(Environment.NewLine);
sList.Append("P1,prueba1");
sList.Append(Environment.NewLine);
sList.Append("P2,prueba2");
sList.Append(Environment.NewLine);
var result = files.GenerateToCSV(testList);
Assert.AreEqual(result, sList.ToString());
}
public void SetFieldLength_Should_Set_The_Length_Followed_The_Field_Length()
{
// Arrange
GenerateFiles generateFiles = new GenerateFiles(this.config, this.spreadsheet, this.fileSystem, this.outputWriter);
DataTable dataTable = GetPeopleTest1();
int dataTableHash = dataTable.GetHashCode();
Header header = new Header
{
Fields = new List <Field>
{
new Field
{
Column = 0,
Text = "LastName",
Length = 0,
Row = 0,
Type = Enum.DatabaseEnum.TypeField.Text
},
new Field
{
Column = 1,
Text = "FirstName",
Length = 0,
Row = 0,
Type = Enum.DatabaseEnum.TypeField.Text
},
new Field
{
Column = 2,
Text = "Name",
Length = 4,
Row = 0,
Type = Enum.DatabaseEnum.TypeField.Text
},
new Field
{
Column = 3,
Text = "DateOfBirth",
Length = 0,
Row = 0,
Type = Enum.DatabaseEnum.TypeField.Date
},
new Field
{
Column = 4,
Text = "Salary",
Length = 0,
Row = 0,
Type = Enum.DatabaseEnum.TypeField.Number
}
}
};
// Act
generateFiles.SetFieldLength(dataTable, header);
// Assert
header.Should().NotBeNull();
header.Fields.Find(f => f.Name == "LastName".ToLower()).Length.Should().Be(20);
header.Fields.Find(f => f.Name == "FirstName".ToLower()).Length.Should().Be(30);
header.Fields.Find(f => f.Name == "Name".ToLower()).Length.Should().Be(10);
header.Fields.Find(f => f.Name == "DateOfBirth".ToLower()).Length.Should().Be(10);
header.Fields.Find(f => f.Name == "Salary".ToLower()).Length.Should().Be(30);
}
public async static Task <IDTO> AddUpdateMode(Attachment attachment)
{
string SPName = "";
string message = "";
OracleDynamicParameters oracleParams = new OracleDynamicParameters();
ComplateOperation <int> complate = new ComplateOperation <int>();
if (attachment.ID.HasValue)
{
oracleParams.Add(AttachmentsSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)attachment.ID ?? DBNull.Value);
SPName = AttachmentsSpName.SP_UPADTE_ATTACHMENT;
message = "Updated Successfully";
}
else
{
oracleParams.Add(AttachmentsSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Output);
SPName = AttachmentsSpName.SP_INSERT_ATTACHMENT;
message = "Inserted Successfully";
}
oracleParams.Add(AttachmentsSpParams.PARAMETER_SERIAL, OracleDbType.Int64, ParameterDirection.Input, (object)attachment.Serial ?? DBNull.Value);
attachment.FullPath = GenerateFiles.FilePath(attachment.Path, attachment.Type);
if (attachment.File != null)
{
string path = "";
if (attachment.DocumentID.HasValue)
{
path = await GenerateFiles.InsertFileAsync(attachment.File, attachment.FullPath, attachment.DocumentID.ToString());
}
if (attachment.RiskID.HasValue)
{
path = await GenerateFiles.InsertFileAsync(attachment.File, attachment.FullPath, attachment.RiskID.ToString());
}
if (attachment.ClaimID.HasValue)
{
path = await GenerateFiles.InsertFileAsync(attachment.File, attachment.FullPath, attachment.ClaimID.ToString());
}
attachment.FullPath = path;
}
else
{
if (!string.IsNullOrEmpty(attachment.AttachedPath))
{
attachment.FullPath = attachment.AttachedPath;
}
else
{
attachment.FullPath = "";
}
}
oracleParams.Add(AttachmentsSpParams.PARAMETER_ATTACHED_PATH, OracleDbType.Varchar2, ParameterDirection.Input, (object)attachment.FullPath ?? DBNull.Value);
oracleParams.Add(AttachmentsSpParams.PARAMETER_CREATED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)attachment.CreatedBy ?? DBNull.Value);
oracleParams.Add(AttachmentsSpParams.PARAMETER_CREATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)attachment.CreationDate ?? DBNull.Value);
oracleParams.Add(AttachmentsSpParams.PARAMETER_MODIFIED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)attachment.ModifiedBy ?? DBNull.Value);
oracleParams.Add(AttachmentsSpParams.PARAMETER_MODIFICATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)attachment.ModificationDate ?? DBNull.Value);
oracleParams.Add(AttachmentsSpParams.PARAMETER_UW_DOC_ID, OracleDbType.Int64, ParameterDirection.Input, (object)attachment.DocumentID ?? DBNull.Value);
oracleParams.Add(AttachmentsSpParams.PARAMETER_UW_RISK_ID, OracleDbType.Int64, ParameterDirection.Input, (object)attachment.RiskID ?? DBNull.Value);
oracleParams.Add(AttachmentsSpParams.PARAMETER_IS_RECEIVED, OracleDbType.Int64, ParameterDirection.Input, (object)attachment.IsReceived ?? DBNull.Value);
oracleParams.Add(AttachmentsSpParams.PARAMETER_RECEIVED_DATE, OracleDbType.Date, ParameterDirection.Input, (object)attachment.ReceivedDate ?? DBNull.Value);
oracleParams.Add(AttachmentsSpParams.PARAMETER_REMARKS, OracleDbType.Varchar2, ParameterDirection.Input, (object)attachment.Remarks ?? DBNull.Value);
oracleParams.Add(AttachmentsSpParams.PARAMETER_ST_PRD_ATT_ID, OracleDbType.Int64, ParameterDirection.Input, (object)attachment.ProductAttachmentID ?? DBNull.Value);
oracleParams.Add(AttachmentsSpParams.PARAMETER_CLM_ID, OracleDbType.Int64, ParameterDirection.Input, (object)attachment.ClaimID ?? DBNull.Value);
oracleParams.Add(AttachmentsSpParams.PARAMETER_LOC_LEVEL, OracleDbType.Int64, ParameterDirection.Input, (object)attachment.Level ?? DBNull.Value);
if (await NonQueryExecuter.ExecuteNonQueryAsync(SPName, oracleParams) == -1)
{
complate.message = message;
complate.ID = oracleParams.Get(0);
}
else
{
complate.message = "Operation Failed";
}
return(complate);
}
public void InsertSqlScript_Should_Return_Oracle_Insert_Script()
{
// Arrange
this.configMock.Setup(c => c.DatabaseVendor).Returns(DatabaseEnum.Vendor.Oracle);
this.configMock.Setup(c => c.OutTablename).Returns("person");
GenerateFiles generateFiles = new GenerateFiles(this.config, this.spreadsheet, this.fileSystem, this.outputWriter);
List <string> lines = new List <string>();
this.fileSystemMock.Setup(o => o.WriteAllLines(It.IsAny <string>(), It.IsAny <List <string> >(), It.IsAny <Encoding>())).Callback((string path, List <string> contents, Encoding encoding) => lines = contents);
DataTable dataTable = GetPeopleTest1();
Header header = new Header
{
Fields = new List <Field>
{
new Field
{
Column = 0,
Text = "LastName",
Length = 10,
Row = 0,
Type = Enum.DatabaseEnum.TypeField.Text
},
new Field
{
Column = 1,
Text = "FirstName",
Length = 20,
Row = 0,
Type = Enum.DatabaseEnum.TypeField.Text
},
new Field
{
Column = 2,
Text = "Name",
Length = 4,
Row = 0,
Type = Enum.DatabaseEnum.TypeField.Text
},
new Field
{
Column = 3,
Text = "DateOfBirth",
Length = 20,
Row = 0,
Type = Enum.DatabaseEnum.TypeField.Date
},
new Field
{
Column = 4,
Text = "Salary",
Length = 30,
Row = 0,
Type = Enum.DatabaseEnum.TypeField.Number
},
new Field
{
Column = 5,
Extra = false,
Text = "id",
Length = 9,
Row = 0,
Type = Enum.DatabaseEnum.TypeField.Number
},
new Field
{
Column = 6,
Extra = true,
Text = "ExternalNumber",
Length = 9,
Row = 0,
Type = Enum.DatabaseEnum.TypeField.Number
},
new Field
{
Column = 7,
Extra = true,
Text = "Message",
Length = 2000,
Row = 0,
Type = Enum.DatabaseEnum.TypeField.Text
}
}
};
// Act
int result = generateFiles.InsertSqlScript(header, dataTable);
// Assert
result.Should().Be(2);
lines.Count.Should().BeGreaterThan(0);
lines[0].Should().Be("INSERT INTO person (lastname, firstname, name, dateofbirth, salary, id, externalnumber, message) VALUES ('abcdefghijk', 'abc', 'aa', '15-1-2001', '10000000000', 1, null, null);");
lines[1].Should().Be("INSERT INTO person (lastname, firstname, name, dateofbirth, salary, id, externalnumber, message) VALUES ('abc', 'abcdefghijklmnopqrstw', 'aaa', '15-10-1901', '1000000000000000000000', 2, null, null);");
lines[2].Should().Be("");
lines[3].Should().Be($"{Constant.Key.COMMIT};");
}
