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.

  • 写回答

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.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 如何让企业微信机器人实现消息汇总整合
  • ¥50 关于#ui#的问题:做yolov8的ui界面出现的问题
  • ¥15 如何用Python爬取各高校教师公开的教育和工作经历
  • ¥15 TLE9879QXA40 电机驱动
  • ¥20 对于工程问题的非线性数学模型进行线性化
  • ¥15 Mirare PLUS 进行密钥认证?(详解)
  • ¥15 物体双站RCS和其组成阵列后的双站RCS关系验证
  • ¥20 想用ollama做一个自己的AI数据库
  • ¥15 关于qualoth编辑及缝合服装领子的问题解决方案探寻
  • ¥15 请问怎么才能复现这样的图呀