public void QueryRequestTest3()
{
var query = DynamoExpression.FromExpression(Expression.Eq("name", "sortable"));
var request = new DynamoQuery {
TableName = "Libraries",
KeyConditionExpression = query.Text,
ExpressionAttributeValues = query.AttributeValues,
ExpressionAttributeNames = query.AttributeNames,
Limit = 1
};
Assert.Equal(@"{
""TableName"": ""Libraries"",
""KeyConditionExpression"": ""#name = :v0"",
""ExpressionAttributeNames"": {
""#name"": ""name""
},
""ExpressionAttributeValues"": {
"":v0"": {
""S"": ""sortable""
}
},
""Limit"": 1
}", request.ToJson().ToString());
}
public void QueryRequestTest4()
{
var request = new DynamoQuery
{
TableName = "Libraries",
KeyConditionExpression = "id = :v1",
ExpressionAttributeValues = new AttributeCollection
{
[":v1"] = new DbValue(1)
},
Limit = 1
}.Include("name", "version");
Assert.Equal(@"{
""TableName"": ""Libraries"",
""KeyConditionExpression"": ""id = :v1"",
""ExpressionAttributeNames"": {
""#name"": ""name""
},
""ExpressionAttributeValues"": {
"":v1"": {
""N"": ""1""
}
},
""ProjectionExpression"": ""#name,version"",
""Limit"": 1
}", request.ToJson().ToString());
}
// [Fact]
public void A()
{
var query = new DynamoQuery
{
TableName = "Posts",
ConsistentRead = true,
ProjectionExpression = "a > 0",
Select = SelectEnum.ALL_ATTRIBUTES
};
}
public void QueryRequestTest1()
{
var request = new DynamoQuery(Expression.Eq("id", 1))
{
TableName = "Libraries",
Limit = 1
};
Assert.Equal(@"{
""TableName"": ""Libraries"",
""KeyConditionExpression"": ""id = :v0"",
""ExpressionAttributeValues"": {
"":v0"": {
""N"": ""1""
}
},
""Limit"": 1
}", request.ToJson().ToString());
}
public void QueryRequestTest5()
{
var query = new DynamoQuery(Expression.Eq("userId", 1))
.Filter(Expression.Contains("participantIds", Expression.Constant(2)));
query.TableName = "Conversations";
Assert.Equal(@"{
""TableName"": ""Conversations"",
""KeyConditionExpression"": ""userId = :v0"",
""ExpressionAttributeValues"": {
"":v0"": {
""N"": ""1""
},
"":v1"": {
""N"": ""2""
}
},
""FilterExpression"": ""contains(participantIds, :v1)""
}", query.ToJson().ToString());
}
public static IDynamoQueryClause SelectMyRecordsAndMyOtherRecords(string recordId) => DynamoQuery.SelectPKFormat(MY_RECORD_PK_PATTERN, recordId) .WhereSKMatchesAny() .WithTypeFilter <MyRecord>() .WithTypeFilter <MyOtherRecord>();
public static IDynamoQueryClause <MyRecord> SelectMyRecords(string recordId) => DynamoQuery.SelectPKFormat <MyRecord>(MY_RECORD_PK_PATTERN, recordId) .WhereSKBeginsWith(string.Format(MY_RECORD_SK_PATTERN, "", ""));
