Examples of com.amazonaws.services.dynamodb.model.QueryRequest

Package com.amazonaws.services.dynamodb.model

Examples of com.amazonaws.services.dynamodb.model.QueryRequest

com.amazonaws.services.dynamodb.model.QueryRequest
Container for the parameters to the {@link com.amazonaws.services.dynamodb.AmazonDynamoDB#query(QueryRequest) Query operation}.
Gets the values of one or more items and its attributes by primary key (composite primary key, only).

Narrow the scope of the query using comparison operators on the RangeKeyValue of the composite key. Use the ScanIndexForward parameter to get results in forward or reverse order by range key.
@see com.amazonaws.services.dynamodb.AmazonDynamoDB#query(QueryRequest)


  @Test
  public void queryWithHashKeyAndRangeKeyConditionBETWEENTest() {
        AttributeValue hashKey = setupTableWithSeveralItems();


        QueryRequest request = new QueryRequest().withTableName(tableName).withHashKeyValue(hashKey);


    Condition rangeKeyCondition = new Condition();
    List<AttributeValue> attributeValueList = new ArrayList<AttributeValue>();
    attributeValueList.add(new AttributeValue().withS("Range2"));
    attributeValueList.add(new AttributeValue().withS("Range3"));
    rangeKeyCondition.setAttributeValueList(attributeValueList);
    rangeKeyCondition.setComparisonOperator(ComparisonOperator.BETWEEN);
    request.setRangeKeyCondition(rangeKeyCondition);
    QueryResult result = getClient().query(request);
    Assert.assertNotNull("Null result.", result);
    Assert.assertNotNull("No items returned.", result.getItems());
        Assert.assertEquals("Should return two items.", 2, result.getItems().size());
    for (Map<String, AttributeValue> item : result.getItems()) {

View Full Code Here


  @Test
  public void queryWithHashKeyAndRangeKeyConditionBEGINSWITHTest() {
        AttributeValue hashKey = setupTableWithSeveralItems();


        QueryRequest request = new QueryRequest().withTableName(tableName).withHashKeyValue(hashKey);


    Condition rangeKeyCondition = new Condition();
    List<AttributeValue> attributeValueList = new ArrayList<AttributeValue>();
    attributeValueList.add(new AttributeValue().withS("Range"));
    rangeKeyCondition.setAttributeValueList(attributeValueList);
    rangeKeyCondition.setComparisonOperator(ComparisonOperator.BEGINS_WITH);
    request.setRangeKeyCondition(rangeKeyCondition);
    QueryResult result = getClient().query(request);
    Assert.assertNotNull("Null result.", result);
    Assert.assertNotNull("No items returned.", result.getItems());
        Assert.assertEquals("Should return four items.", 4, result.getItems().size());
    for (Map<String, AttributeValue> item : result.getItems()) {

View Full Code Here


  @Test
  public void queryWithHashKeyAndRangeKeyConditionCONTAINSTest() {
        AttributeValue hashKey = setupTableWithSeveralItems();


        QueryRequest request = new QueryRequest().withTableName(tableName).withHashKeyValue(hashKey);


    Condition rangeKeyCondition = new Condition();
    List<AttributeValue> attributeValueList = new ArrayList<AttributeValue>();
    attributeValueList.add(new AttributeValue().withS("ange1"));
    rangeKeyCondition.setAttributeValueList(attributeValueList);
    rangeKeyCondition.setComparisonOperator(ComparisonOperator.CONTAINS);
    request.setRangeKeyCondition(rangeKeyCondition);
    QueryResult result = getClient().query(request);
    Assert.assertNotNull("Null result.", result);
    Assert.assertNotNull("No items returned.", result.getItems());
        Assert.assertEquals("Should return two items.", 2, result.getItems().size());
    for (Map<String, AttributeValue> item : result.getItems()) {

View Full Code Here


  @Test
  public void queryWithHashKeyAndNumericRangeKeyConditionEQTest() {
        AttributeValue hashKey = setupNumericRangeTableWithSeveralItems();


        QueryRequest request = new QueryRequest().withTableName(tableName).withHashKeyValue(hashKey);


    Condition rangeKeyCondition = new Condition();
    List<AttributeValue> attributeValueList = new ArrayList<AttributeValue>();
    attributeValueList.add(createNumberAttribute(2));
    rangeKeyCondition.setAttributeValueList(attributeValueList);
    rangeKeyCondition.setComparisonOperator(ComparisonOperator.EQ);
    request.setRangeKeyCondition(rangeKeyCondition);
    QueryResult result = getClient().query(request);
    Assert.assertNotNull("Null result.", result);
    Assert.assertNotNull("No items returned.", result.getItems());
        Assert.assertEquals("Should return one item.", 1, result.getItems().size());
    for (Map<String, AttributeValue> item : result.getItems()) {

View Full Code Here


  @Test
  public void queryWithHashKeyAndNumericRangeKeyConditionLTTest() {
        AttributeValue hashKey = setupNumericRangeTableWithSeveralItems();


        QueryRequest request = new QueryRequest().withTableName(tableName).withHashKeyValue(hashKey);


    Condition rangeKeyCondition = new Condition();
    List<AttributeValue> attributeValueList = new ArrayList<AttributeValue>();
    attributeValueList.add(createNumberAttribute(2));
    rangeKeyCondition.setAttributeValueList(attributeValueList);
    rangeKeyCondition.setComparisonOperator(ComparisonOperator.LT);
    request.setRangeKeyCondition(rangeKeyCondition);
    QueryResult result = getClient().query(request);
    Assert.assertNotNull("Null result.", result);
    Assert.assertNotNull("No items returned.", result.getItems());
        // NOTE: LT is currently a string comparison, so "11" is < "2".
        Assert.assertEquals("Should return two items.", 2, result.getItems().size());

View Full Code Here


  @Test
  public void queryWithHashKeyAndNumericRangeKeyConditionLETest() {
        AttributeValue hashKey = setupNumericRangeTableWithSeveralItems();


        QueryRequest request = new QueryRequest().withTableName(tableName).withHashKeyValue(hashKey);


    Condition rangeKeyCondition = new Condition();
    List<AttributeValue> attributeValueList = new ArrayList<AttributeValue>();
    attributeValueList.add(createNumberAttribute(2));
    rangeKeyCondition.setAttributeValueList(attributeValueList);
    rangeKeyCondition.setComparisonOperator(ComparisonOperator.LE);
    request.setRangeKeyCondition(rangeKeyCondition);
    QueryResult result = getClient().query(request);
    Assert.assertNotNull("Null result.", result);
    Assert.assertNotNull("No items returned.", result.getItems());
        // NOTE: LE is currently a string comparison, so "11" is <= "2".
        Assert.assertEquals("Should return three items.", 3, result.getItems().size());

View Full Code Here


  @Test
  public void queryWithHashKeyAndNumericRangeKeyConditionGTTest() {
        AttributeValue hashKey = setupNumericRangeTableWithSeveralItems();


        QueryRequest request = new QueryRequest().withTableName(tableName).withHashKeyValue(hashKey);


    Condition rangeKeyCondition = new Condition();
    List<AttributeValue> attributeValueList = new ArrayList<AttributeValue>();
    attributeValueList.add(createNumberAttribute(2));
    rangeKeyCondition.setAttributeValueList(attributeValueList);
    rangeKeyCondition.setComparisonOperator(ComparisonOperator.GT);
    request.setRangeKeyCondition(rangeKeyCondition);
    QueryResult result = getClient().query(request);
    Assert.assertNotNull("Null result.", result);
    Assert.assertNotNull("No items returned.", result.getItems());
        // NOTE: GT is currently a string comparison, so "11" is NOT > "2".
        Assert.assertEquals("Should return three items.", 3, result.getItems().size());

View Full Code Here


  @Test
  public void queryWithHashKeyAndNumericRangeKeyConditionGETest() {
        AttributeValue hashKey = setupNumericRangeTableWithSeveralItems();


        QueryRequest request = new QueryRequest().withTableName(tableName).withHashKeyValue(hashKey);


    Condition rangeKeyCondition = new Condition();
    List<AttributeValue> attributeValueList = new ArrayList<AttributeValue>();
    attributeValueList.add(createNumberAttribute(2));
    rangeKeyCondition.setAttributeValueList(attributeValueList);
    rangeKeyCondition.setComparisonOperator(ComparisonOperator.GE);
    request.setRangeKeyCondition(rangeKeyCondition);
    QueryResult result = getClient().query(request);
    Assert.assertNotNull("Null result.", result);
    Assert.assertNotNull("No items returned.", result.getItems());
        // NOTE: GE is currently a string comparison, so "11" is NOT > "2".
        Assert.assertEquals("Should return four items.", 4, result.getItems().size());

View Full Code Here


  @Test
  public void queryWithHashKeyAndNumericRangeKeyConditionINTest() {
        AttributeValue hashKey = setupNumericRangeTableWithSeveralItems();


        QueryRequest request = new QueryRequest().withTableName(tableName).withHashKeyValue(hashKey);


    Condition rangeKeyCondition = new Condition();
    List<AttributeValue> attributeValueList = new ArrayList<AttributeValue>();
    attributeValueList.add(createNumberAttribute(2));
    attributeValueList.add(createNumberAttribute(4));
    attributeValueList.add(createNumberAttribute(0));
    rangeKeyCondition.setAttributeValueList(attributeValueList);
    rangeKeyCondition.setComparisonOperator(ComparisonOperator.IN);
    request.setRangeKeyCondition(rangeKeyCondition);
    QueryResult result = getClient().query(request);
    Assert.assertNotNull("Null result.", result);
    Assert.assertNotNull("No items returned.", result.getItems());
        Assert.assertEquals("Should return two items.", 2, result.getItems().size());
    for (Map<String, AttributeValue> item : result.getItems()) {

View Full Code Here


  @Test
  public void queryWithHashKeyAndNumericRangeKeyConditionBETWEENTest() {
        AttributeValue hashKey = setupNumericRangeTableWithSeveralItems();


        QueryRequest request = new QueryRequest().withTableName(tableName).withHashKeyValue(hashKey);


    Condition rangeKeyCondition = new Condition();
    List<AttributeValue> attributeValueList = new ArrayList<AttributeValue>();
    attributeValueList.add(createNumberAttribute(2));
    attributeValueList.add(createNumberAttribute(3));
    rangeKeyCondition.setAttributeValueList(attributeValueList);
    rangeKeyCondition.setComparisonOperator(ComparisonOperator.BETWEEN);
    request.setRangeKeyCondition(rangeKeyCondition);
    QueryResult result = getClient().query(request);
    Assert.assertNotNull("Null result.", result);
    Assert.assertNotNull("No items returned.", result.getItems());
        Assert.assertEquals("Should return two items.", 2, result.getItems().size());
  }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of com.amazonaws.services.dynamodb.model.QueryRequest

com.amazonaws.services.dynamodb.datamodeling.DynamoDBMapper

com.amazonaws.services.dynamodb.model.transform.QueryRequestJsonUnmarshaller

com.fluxcapacitor.middletier.store.dynamodb.FluxDynamoDbStore

com.michelboudreau.alternator.AlternatorDBHandler

com.michelboudreau.alternator.validators.QueryRequestValidator

com.michelboudreau.alternatorv2.AlternatorDBApiVersion2Mapper

com.michelboudreau.test.AlternatorQueryTest

com.michelboudreau.test.AlternatorSaveRestoreTest

com.michelboudreau.test.AlternatorUpdateTest

com.netflix.bdp.s3mper.metastore.impl.DynamoDBMetastore$QueryTask

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.