douhuanqiao5290
2014-10-03 11:01
浏览 46
已采纳

PHP - Azure表存储,包含1000多个实体

I am trying to query from my table storage by using the Azure SDK for PHP.

My query looks like:

    $tableRestProxy = ServicesBuilder::getInstance()->createTableService($this->connectionString);
    $filter = "( PartitionKey eq '$id' )";

    $options = new QueryEntitiesOptions();
    $options->setFilter(Filter::applyQueryString($filter));

    $result = $tableRestProxy->queryEntities('test', $options);
    $entities = $result->getEntities();

    $nextPartitionKey = $result->getNextPartitionKey();
    $nextRowKey = $result->getNextRowKey();

    while (!is_null($nextRowKey) && !is_null($nextPartitionKey) ) {

        $options = new QueryEntitiesOptions();
        $options->setNextPartitionKey($nextPartitionKey);
        $options->setNextRowKey($nextRowKey);
        $options->setFilter(Filter::applyQueryString($filter));

        $result2 = $tableRestProxy->queryEntities("test", $options);
        $newentities = $result2->getEntities();
        $entities=array_merge($newentities, $entities);    

    }

The issue: When running into the while loop I always get the first 1000 back entities, with the same nextrowkey and nextpartitionkey for each query. Thus it creates an infinit loop.

What am I getting wrong with the continuation of a query? Any help is appreciated.

图片转代码服务由CSDN问答提供 功能建议

我试图通过使用Azure SDK for PHP从我的表存储中查询。 \ n

我的查询如下:

  $ tableRestProxy = ServicesBuilder :: getInstance() - > createTableService($ this-> connectionString); 
 $ filter =  “(PartitionKey eq'$ id')”; 
 
 $ options = new QueryEntitiesOptions(); 
 $ options-> setFilter(Filter :: applyQueryString($ filter)); 
 
 $ result = $  tableRestProxy-> queryEntities('test',$ options); 
 $ entities = $ result-> getEntities(); 
 
 $ nextPartitionKey = $ result-> getNextPartitionKey(); 
 $ nextRowKey = $  result-> getNextRowKey(); 
 
 while(!is_null($ nextRowKey)&&!is_null($ nextPartitionKey)){
 
 $ options = new QueryEntitiesOptions(); 
 $ options-&gt  ; setNextPartitionKey($ nextPartitionKey); 
 $ options-> setNextRowKey($ nextRowKey); 
 $ options-> setFilter(Filter :: applyQueryString($ filter)); 
 
 $ result2 = $ tableRestPr  oxy-> queryEntities(“test”,$ options); 
 $ newentities = $ result2-> getEntities(); 
 $ entities = array_merge($ newentities,$ entities);  
 
} 
   
 
 

问题:当进入while循环时,我总是得到前1000个实体,每个查询都有相同的nextrowkey和nextpartitionkey。 因此它创建了一个无限循环。

我对查询的延续出了什么问题? 非常感谢。

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 邀请回答

1条回答 默认 最新

  • donglun2010 2014-10-03 12:16
    已采纳

    @Gaurav: this is true, but occurs only on the second loop (I forgot to add the two lines when posting my code).

    I've been trying to find out what's wrong for at least half a day. Finally I got it: It is due to an older version of the Windows Azure PHP SDK which has a "bug". I stumbled across this "bug" at the bottom of this thread: https://github.com/Azure/azure-sdk-for-php/issues/702 The older version of Windows Azure SDK uses _encodeODataUriValue which seems to be unnecessary.

    点赞 打赏 评论

相关推荐 更多相似问题