public void Compare_BlankNullEmpty_True(object x, object y)
{
var comparer = new CellComparer();
var result = comparer.Compare(x, y, ColumnType.Text, null, null);
Assert.That(result.AreEqual, Is.True);
}
protected override DataRow CompareRows(DataRow rx, DataRow ry)
{
var isRowOnError = false;
for (int i = 0; i < rx.Table.Columns.Count; i++)
{
if (settings.GetColumnRole(i) == ColumnRole.Value)
{
var x = rx.IsNull(i) ? DBNull.Value : rx[i];
var y = ry.IsNull(i) ? DBNull.Value : ry[i];
var rounding = settings.IsRounding(i) ? settings.GetRounding(i) : null;
var result = CellComparer.Compare(x, y, settings.GetColumnType(i), settings.GetTolerance(i), rounding);
if (!result.AreEqual)
{
ry.SetColumnError(i, result.Message);
if (!isRowOnError)
{
isRowOnError = true;
}
}
}
}
if (isRowOnError)
{
return(ry);
}
else
{
return(null);
}
}
public void Compare_ToValue_True(object value, ColumnType columnType)
{
var comparer = new CellComparer();
var result = comparer.Compare(value, "(value)", columnType, null, null);
Assert.That(result.AreEqual, Is.True);
}
public void ShouldReturnOneWhenCell2IsNull()
{
//Arrange
var key01 = "key01";
string key02 = null;
var expectedResult = 1;
var cell01 = new Cell <string, string>(key01);
Cell <string, string> cell02 = null;
var mockEqualityServiceProvider = MockRepository.GenerateMock <IComparer <string> >();
var sut = new CellComparer <string, string>(mockEqualityServiceProvider);
//Act
var result = sut.Compare(cell01, cell02);
//Assert
Assert.That(result, Is.EqualTo(expectedResult));
}
/// <summary>
///
/// </summary>
/// <param name="R1"></param>
/// <param name="R2"></param>
/// <param name="K"></param>
/// <returns></returns>
public static int Compare(Record R1, Record R2, Key K)
{
int c = 0;
for (int i = 0; i < K.Count; i++)
{
c = CellComparer.Compare(R1[K[i]], R2[K[i]]);
if (K.Affinity(i) == KeyAffinity.Descending)
{
c = -c;
}
if (c != 0)
{
return(c);
}
}
return(0);
}
/// <summary>
///
/// </summary>
/// <param name="R1"></param>
/// <param name="R2"></param>
/// <returns></returns>
public static int Compare(Record R1, Record R2)
{
if (R1.Count != R2.Count)
{
throw new Exception("Record sizes do not match " + R1.Count.ToString() + " : " + R2.Count.ToString());
}
int c = 0;
for (int i = 0; i < R1.Count; i++)
{
c = CellComparer.Compare(R1[i], R2[i]);
if (c != 0)
{
return(c);
}
}
return(0);
}
public void ShouldReturnTheSameResultThatKeyComparerReturn()
{
//Arrange
var key01 = 1;
var key02 = 2;
var cell01 = new Cell <int, string>(key01);
var cell02 = new Cell <int, string>(key02);
var keyComparerResult = 99;
var mockEqualityServiceProvider = MockRepository.GenerateMock <IComparer <int> >();
mockEqualityServiceProvider.Stub(x => x.Compare(key01, key02)).Return(keyComparerResult);
var sut = new CellComparer <int, string>(mockEqualityServiceProvider);
//Act
var result = sut.Compare(cell01, cell02);
//Assert
Assert.That(result, Is.EqualTo(keyComparerResult));
}
// Comparers //
/// <summary>
///
/// </summary>
/// <param name="R1"></param>
/// <param name="K1"></param>
/// <param name="R2"></param>
/// <param name="K2"></param>
/// <returns></returns>
public static int Compare(Record R1, Key K1, Record R2, Key K2)
{
if (K1.Count != K2.Count)
{
throw new Exception("Keys size do not match " + K1.Count.ToString() + " : " + K2.Count.ToString());
}
int c = 0;
for (int i = 0; i < K1.Count; i++)
{
c = CellComparer.Compare(R1[K1[i]], R2[K2[i]]);
if (K1.Affinity(i) == KeyAffinity.Descending || K2.Affinity(i) == KeyAffinity.Descending)
{
c = -c;
}
if (c != 0)
{
return(c);
}
}
return(0);
}
public override Cell Evaluate(SpoolSpace Memory)
{
return(CellComparer.Compare(this._Children[0].Evaluate(Memory), this._Children[1].Evaluate(Memory).valueINT) >= 0 ? CellValues.True : CellValues.False);
}