public MatchedRecordComparer(ComparisonData data, RoundingSettings settings, DiscrepancyOutputter outputter) { List <int> list = new List <int>(); foreach (string ignoredColumn in data.ignoredColumns) { list.Add(XLSXUtils.CellReferenceToColumnIndex(ignoredColumn)); } ignoredColumnIndices = list.ToArray(); this.settings = settings; this.outputter = outputter; }
public SQLComparer( string connectionString, string connStr1, string query1, string connStr2, string query2, ComparisonData data, RoundingSettings settings) : base(connectionString, data, settings) { this.connStr1 = connStr1; this.query1 = query1; this.connStr2 = connStr2; this.query2 = query2; }
public Comparer(string connectionString, ComparisonData comparisonData, RoundingSettings roundingSettings) { this.connectionString = connectionString; this.comparisonData = comparisonData; this.roundingSettings = roundingSettings; matcher = new SQLHashRecordMatcher( new string[] { TABLE_NAME_ONE, TABLE_NAME_TWO }, connectionString, comparisonData, roundingSettings); }
public SQLHashRecordMatcher(string[] srcTables, string connectionString, ComparisonData data, RoundingSettings settings) { this.srcTables = srcTables; this.data = data; this.settings = settings; db = new SqlServerDB(connectionString); db.Connect(); db.Query(@" IF OBJECT_ID('dbo.table1', 'U') IS NOT NULL DROP TABLE dbo.table1; IF OBJECT_ID('dbo.table2', 'U') IS NOT NULL DROP TABLE dbo.table2; "); }
public XLSXComparer(string[] filePaths, string[] sheetNames, string connectionString, ComparisonData data, RoundingSettings settings) : base(connectionString, data, settings) { this.filePaths = filePaths; this.sheetNames = sheetNames; this.data = data; }