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