public void TestQueryGroupParseExpressionValueIntClassParameterMethod(QueryGroupTestExpressionClass item)
{
// Setup
var parsed = QueryGroup.Parse <QueryGroupTestExpressionClass>(e => e.PropertyInt == item.PropertyInt);
// Act
var actual = parsed.QueryFields.First().Parameter.Value;
var expected = 1;
// Assert
Assert.AreEqual(expected, actual);
}
public void TestQueryGroupParseExpressionDoubleClassProperty()
{
// Setup
var value = new QueryGroupTestExpressionClass
{
PropertyDouble = 1.0
};
// Act
var actual = QueryGroup.Parse <QueryGroupTestExpressionClass>(e => e.PropertyDouble == value.PropertyDouble).GetString(m_dbSetting);
var expected = "([PropertyDouble] = @PropertyDouble)";
// Assert
Assert.AreEqual(expected, actual);
}
public void TestParseExpressionBooleanClassProperty()
{
// Setup
var value = new QueryGroupTestExpressionClass
{
PropertyBoolean = true
};
// Act
var actual = QueryGroup.Parse <QueryGroupTestExpressionClass>(e => e.PropertyBoolean == value.PropertyBoolean).GetString();
var expected = "([PropertyBoolean] = @PropertyBoolean)";
// Assert
Assert.AreEqual(expected, actual);
}
public void TestParseExpressionByteClassProperty()
{
// Setup
var value = new QueryGroupTestExpressionClass
{
PropertyBytes = new[] { byte.Parse("0") }
};
// Act
var actual = QueryGroup.Parse <QueryGroupTestExpressionClass>(e => e.PropertyBytes == value.PropertyBytes).GetString();
var expected = "([PropertyBytes] = @PropertyBytes)";
// Assert
Assert.AreEqual(expected, actual);
}
public void TestParseExpressionDateTimeClassProperty()
{
// Setup
var value = new QueryGroupTestExpressionClass
{
PropertyDateTime = DateTime.UtcNow
};
// Act
var actual = QueryGroup.Parse <QueryGroupTestExpressionClass>(e => e.PropertyDateTime == value.PropertyDateTime).GetString();
var expected = "([PropertyDateTime] = @PropertyDateTime)";
// Assert
Assert.AreEqual(expected, actual);
}
public void TestQueryGroupParseExpressionStringClassProperty()
{
// Setup
var value = new QueryGroupTestExpressionClass
{
PropertyString = "A"
};
// Act
var actual = QueryGroup.Parse <QueryGroupTestExpressionClass>(e => e.PropertyString == value.PropertyString).GetString();
var expected = "([PropertyString] = @PropertyString)";
// Assert
Assert.AreEqual(expected, actual);
}
public void TestQueryGroupParseExpressionGuidClassProperty()
{
// Setup
var value = new QueryGroupTestExpressionClass
{
PropertyGuid = Guid.NewGuid()
};
// Act
var actual = QueryGroup.Parse <QueryGroupTestExpressionClass>(e => e.PropertyGuid == value.PropertyGuid).GetString();
var expected = "([PropertyGuid] = @PropertyGuid)";
// Assert
Assert.AreEqual(expected, actual);
}
public void TestQueryGroupParseExpressionNotAnyFromClassProperty()
{
// Setup
var @class = new QueryGroupTestExpressionClass
{
PropertyInt = 500
};
var parsed = QueryGroup.Parse <QueryGroupTestExpressionClass>(e => !(new[] { @class.PropertyInt, @class.PropertyInt }).Any(p => p == e.PropertyInt));
// Act
var actual = parsed.GetString(m_dbSetting);
var expected = "NOT ([PropertyInt] = @PropertyInt OR [PropertyInt] = @PropertyInt_1)";
// Assert
Assert.AreEqual(expected, actual);
}
public void TestQueryGroupParseExpressionAllEqualsTrueFromClassProperty()
{
// Setup
var @class = new QueryGroupTestExpressionClass
{
PropertyInt = 500
};
var parsed = QueryGroup.Parse <QueryGroupTestExpressionClass>(e => (new[] { @class.PropertyInt, @class.PropertyInt }).All(p => p == e.PropertyInt) == true);
// Act
var actual = parsed.GetString();
var expected = "([PropertyInt] = @PropertyInt AND [PropertyInt] = @PropertyInt_1)";
// Assert
Assert.AreEqual(expected, actual);
}
public void TestParseExpressionContainsEqualsTrueFromClassProperty()
{
// Setup
var @class = new QueryGroupTestExpressionClass
{
PropertyString = "A"
};
var parsed = QueryGroup.Parse <QueryGroupTestExpressionClass>(e => e.PropertyString.Contains(@class.PropertyString) == true);
// Act
var actual = parsed.GetString();
var expected = "([PropertyString] LIKE @PropertyString)";
// Assert
Assert.AreEqual(expected, actual);
}
public void TestQueryGroupParseExpressionValueIntClassProperty()
{
// Setup
var value = new QueryGroupTestExpressionClass
{
PropertyInt = 1
};
var parsed = QueryGroup.Parse <QueryGroupTestExpressionClass>(e => e.PropertyInt == value.PropertyInt);
// Act
var actual = parsed.QueryFields.First().Parameter.Value;
var expected = value.PropertyInt;
// Assert
Assert.AreEqual(expected, actual);
}
public void TestQueryGroupParseExpressionValueStringClassProperty()
{
// Setup
var value = new QueryGroupTestExpressionClass
{
PropertyString = Guid.NewGuid().ToString()
};
var parsed = QueryGroup.Parse <QueryGroupTestExpressionClass>(e => e.PropertyString == value.PropertyString);
// Act
var actual = parsed.QueryFields.First().Parameter.Value;
var expected = value.PropertyString;
// Assert
Assert.AreEqual(expected, actual);
}
public void TestQueryGroupParseExpressionNotStringContainsEqualsFalseFromClassProperty()
{
// Setup
var @class = new QueryGroupTestExpressionClass
{
PropertyString = "A"
};
var parsed = QueryGroup.Parse <QueryGroupTestExpressionClass>(e => !e.PropertyString.Contains(@class.PropertyString) == false);
// Act
var actual = parsed.GetString(m_dbSetting);
var expected = "NOT ([PropertyString] NOT LIKE @PropertyString)";
// Assert
Assert.AreEqual(expected, actual);
}
