|
public static NotIn ( string name ) : |
||
| name | string | The name of the element to test. |
| return | ||
public void TestNinParams()
{
var query = Query.NotIn("j", 2, 4, null, 6); // null will be skipped due to functional construction semantics
var expected = "{ \"j\" : { \"$nin\" : [2, 4, 6] } }";
Assert.AreEqual(expected, query.ToJson());
}
public void TestNinIEnumerableBsonValue()
{
var enumerable = new List <BsonValue> {
2, 4, null, 6
}; // null will be skipped due to functional construction semantics
var query = Query.NotIn("j", enumerable);
var expected = "{ \"j\" : { \"$nin\" : [2, 4, 6] } }";
Assert.AreEqual(expected, query.ToJson());
}
public void TestNinBsonArray()
{
var array = new BsonArray {
2, 4, null, 6
}; // null will be skipped due to functional construction semantics
var query = Query.NotIn("j", array);
var expected = "{ \"j\" : { \"$nin\" : [2, 4, 6] } }";
Assert.AreEqual(expected, query.ToJson());
}
public void TestQueryNin()
{
var query1 = Query.NotIn("name", _bsonValue);
var query2 = Query.NotIn("name", _bsonArray);
var query3 = Query.NotIn("name", _bsonValueArray);
var query4 = Query.NotIn("name", _bsonValueList);
var query5 = Query.NotIn("name", _ienumerableBsonValue);
var expectedSingle = "{ 'name' : { '$nin' : [1] } }".Replace("'", "\"");
var expectedMultiple = "{ 'name' : { '$nin' : [1, 2, 3] } }".Replace("'", "\"");
Assert.AreEqual(expectedSingle, query1.ToJson());
Assert.AreEqual(expectedMultiple, query2.ToJson());
Assert.AreEqual(expectedMultiple, query3.ToJson());
Assert.AreEqual(expectedMultiple, query4.ToJson());
Assert.AreEqual(expectedMultiple, query5.ToJson());
}
public void TestAndInNotIn()
{
var query = Query.And(
Query.In("value", 1, 2, 3, 4),
Query.NotIn("value", 11, 12, 13, 14)
);
Assert.AreEqual(
new BsonDocument
{
{ "value", new BsonDocument
{
{ "$in", new BsonArray {
1, 2, 3, 4
} },
{ "$nin", new BsonArray {
11, 12, 13, 14
} }
} }
},
query.ToBsonDocument());
}
public void TestAndGtLt()
{
var query = Query.And(
Query.NotIn("value", 1, 2, 3),
Query.EQ("OtherValue", 1),
Query.GT("value", 6),
Query.LT("value", 20)
);
Assert.AreEqual(
new BsonDocument
{
{ "value", new BsonDocument
{
{ "$nin", new BsonArray {
1, 2, 3
} },
{ "$gt", 6 },
{ "$lt", 20 }
} },
{ "OtherValue", 1 }
},
query.ToBsonDocument());
}