public void GetTableFromQuery_ShouldReturnSqlResult_WhenNotSelectStatement() { const string sql = @" DECLARE @sql nvarchar(max) = 'some dynamic sql' EXEC sp_executesql (@sql) "; Assert.That(ImportFileHelper.GetTableNameFromSelectStatement(sql), Is.EqualTo("SQL RESULT")); }
public void GetTableFromQuery_ShouldReturnTableName_WhenSelectStatement() { const string sql = @" SELECT id ,mytext ,foo ,bar from [Database].[schema].[table] t WHERE id = 1; "; Assert.That(ImportFileHelper.GetTableNameFromSelectStatement(sql), Is.EqualTo("[DATABASE].[SCHEMA].[TABLE]")); }
private void BrowseFile_Click(object sender, EventArgs e) { // Displays an OpenFileDialog so the user can select the Stock Input File. OpenFileDialog openFileDialog1 = new OpenFileDialog(); openFileDialog1.Filter = "Text Files|*.txt"; openFileDialog1.Title = "Select stock Input File"; this.GainLabel.Visible = false; this.GainDetailText.Visible = false; // Show the Dialog. // If the user clicked OK in the dialog and // a .TXT file was selected, open it. if (openFileDialog1.ShowDialog() == System.Windows.Forms.DialogResult.OK) { System.IO.StreamReader sr = new System.IO.StreamReader(openFileDialog1.FileName); try { this.GainLabel.Visible = true; if (sr.Peek() != -1) { string resultString = ImportFileHelper.ReadInputFile(sr); if (resultString == string.Empty) { SetGainText("Input file doesnt have sufficient stock quotes", Color.Red, FontStyle.Bold); } else { SetGainText("Biggest Gain Trading Dates:", Color.White, FontStyle.Regular); SetGainDetaiProperties(resultString); } } else { SetGainText("Input file doesnt have stock price(s)", Color.Red, FontStyle.Bold); } } catch (Exception ex) { Console.WriteLine(ex.ToString()); } finally { sr.Close(); } } }
public void ExecuteDataTableFromTextFile_ShouldImport_WhenCsv() { const string query = @"SELECT * FROM [Test#csv]"; var path = Path.Combine(TestContext.CurrentContext.WorkDirectory, "Data", "Test.csv"); var file = new FileInfo(path); var expected = Common.CreateDataTable("Expected", new[] { 0, 2 }); Common.AddDataRow(expected, "Text one.", 42, 2.00d, 2.00m); Common.AddDataRow(expected, "Text two.", 42, 3.00d, 3.00m); Common.AddDataRow(expected, "Text three.", 43, 4.00d, 4.00m); Common.AddDataRow(expected, "Text four.", 43, 5.00d, 5.00m); var actual = ImportFileHelper.ExecuteDataTableFromTextFile(query, file, expected.PrimaryKey); var diffs = DataTableHelper.CompareDataTables(expected, actual); Assert.That(diffs, Is.Null); }
private void ImportDataButton_Click(object sender, EventArgs e) { using (var dlg = new OpenFileDialog()) { dlg.Multiselect = false; dlg.Filter = "CSV files (.csv)|"; if (dlg.ShowDialog() != DialogResult.OK) { return; } Cursor.Current = Cursors.WaitCursor; try { ImportFileHelper.Import(dlg.FileName); } finally { Cursor.Current = Cursors.Default; RefreshData(); } } }
public ICommandResult ExecuteHendler(ImportFileCommand command) { if (command.IsValid) { var fileControllerReturn = new List <string>(); fileReadSales = new FileReadSalesBase(command.FileName, DateTime.Now); if (fileReadSales.Invalid) { return(new CommandResult(false, fileReadSales.AddErrorFromNotifications())); } foreach (string line in command.FileReader) { ELineType lineType = ImportFileHelper.IdentifyLineType(line); string errorReturn = string.Empty; switch (lineType) { case ELineType.ClienteData: Client cli = convertToClient.ExecuteConversion(line); if (cli.Invalid) { errorReturn = cli.AddErrorFromNotifications(); } fileReadSales.AddClient(cli); break; case ELineType.SalesData: SalesData sale = convertToSalesdata.ExecuteConversion(line); if (sale.Invalid) { errorReturn = sale.AddErrorFromNotifications(); } fileReadSales.AddSales(sale); break; case ELineType.SalesmanData: Salesman salesman = convertToSalesman.ExecuteConversion(line); if (salesman.Invalid) { errorReturn = salesman.AddErrorFromNotifications(); } fileReadSales.AddSalesman(salesman); break; } fileControllerReturn.Add($"{line} => {errorReturn}"); } var linesOutFile = fileReadSales.WriteFileLines(); _fileWriteServices.WriteFileFromLines(lines: linesOutFile, filePath: command.FilePath, fileName: command.FileName); _fileWriteServices.WriteFileFromLines(lines: fileControllerReturn.ToArray(), filePath: command.FilePath, fileName: $"{command.FileName}.RET"); } return(new CommandResult(true, "Dados importados com sucesso")); }