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