コード例 #1
0
 public function testParseExpression2()
 {
     $expressionProvider = new PHPExpressionProvider('$lt');
     $filterExpression = 'UnitPrice ge 6';
     $resourceType = $this->_northWindMetadata->resolveResourceSet('Order_Details')->getResourceType();
     $filterInfo = ExpressionParser2::parseExpression2($filterExpression, $resourceType, $expressionProvider);
     $this->assertTrue(!is_null($filterInfo));
     //There are no navigation properties in the expression so should be empty.
     $this->assertEquals(array(), $filterInfo->getNavigationPropertiesUsed());
     $this->assertEquals('(!(is_null($lt->UnitPrice)) && ($lt->UnitPrice >= 6))', $filterInfo->getExpressionAsString());
     $filterExpression = 'Order/Customer/CustomerID eq \'ANU\' or Product/ProductID gt 123 and UnitPrice ge 6';
     $filterInfo = ExpressionParser2::parseExpression2($filterExpression, $resourceType, $expressionProvider);
     $this->assertTrue(!is_null($filterInfo));
     $navigationsUsed = $filterInfo->getNavigationPropertiesUsed();
     $this->assertTrue(!is_null($navigationsUsed));
     $this->assertTrue(is_array($navigationsUsed));
     $this->assertEquals(count($navigationsUsed), 2);
     //Order/Customer
     $this->assertTrue(is_array($navigationsUsed[0]));
     $this->assertEquals(count($navigationsUsed[0]), 2);
     //Product
     $this->assertTrue(is_array($navigationsUsed[1]));
     $this->assertEquals(count($navigationsUsed[1]), 1);
     //Verify 'Order/Customer'
     $this->assertTrue(is_object($navigationsUsed[0][0]));
     $this->assertTrue(is_object($navigationsUsed[0][1]));
     $this->assertTrue($navigationsUsed[0][0] instanceof ResourceProperty);
     $this->assertTrue($navigationsUsed[0][1] instanceof ResourceProperty);
     $this->assertEquals($navigationsUsed[0][0]->getName(), 'Order');
     $this->assertEquals($navigationsUsed[0][1]->getName(), 'Customer');
     //Verify 'Product'
     $this->assertTrue(is_object($navigationsUsed[1][0]));
     $this->assertTrue($navigationsUsed[1][0] instanceof ResourceProperty);
     $this->assertEquals($navigationsUsed[1][0]->getName(), 'Product');
     $filterExpression = 'Customer/Address/LineNumber add 4 eq 8';
     $resourceType = $this->_northWindMetadata->resolveResourceSet('Orders')->getResourceType();
     $filterInfo = ExpressionParser2::parseExpression2($filterExpression, $resourceType, $expressionProvider);
     $this->assertTrue(!is_null($filterInfo));
     $navigationsUsed = $filterInfo->getNavigationPropertiesUsed();
     //Customer
     $this->assertTrue(!is_null($navigationsUsed));
     $this->assertTrue(is_array($navigationsUsed));
     $this->assertEquals(count($navigationsUsed), 1);
     $this->assertTrue(is_array($navigationsUsed[0]));
     $this->assertEquals(count($navigationsUsed[0]), 1);
     //Verify 'Customer'
     $this->assertTrue(is_object($navigationsUsed[0][0]));
     $this->assertTrue($navigationsUsed[0][0] instanceof ResourceProperty);
     $this->assertEquals($navigationsUsed[0][0]->getName(), 'Customer');
     //Test with property acess expression in function call
     $filterExpression = 'replace(Customer/CustomerID, \'LFK\', \'RTT\') eq \'ARTTI\'';
     $filterInfo = ExpressionParser2::parseExpression2($filterExpression, $resourceType, $expressionProvider);
     $this->assertTrue(!is_null($filterInfo));
     $navigationsUsed = $filterInfo->getNavigationPropertiesUsed();
     //Customer
     $this->assertTrue(!is_null($navigationsUsed));
     $this->assertTrue(is_array($navigationsUsed));
     $this->assertEquals(count($navigationsUsed), 1);
     $this->assertTrue(is_array($navigationsUsed[0]));
     $this->assertEquals(count($navigationsUsed[0]), 1);
     //Verify 'Customer'
     $this->assertTrue(is_object($navigationsUsed[0][0]));
     $this->assertTrue($navigationsUsed[0][0] instanceof ResourceProperty);
     $this->assertEquals($navigationsUsed[0][0]->getName(), 'Customer');
 }
コード例 #2
0
ファイル: QueryProcessor.php プロジェクト: lionsoft/phpodata
 /**
  * Process the $filter option in the request and update request decription.
  * 
  * @return void
  * 
  * @throws ODataException Throws error in the following cases:
  *                          (1) If $filter cannot be applied to the 
  *                              resource targeted by the request uri
  *                          (2) If any error occured while parsing and
  *                              translating the odata $filter expression
  *                              to expression tree
  *                          (3) If any error occured while generating
  *                              php expression from expression tree
  */
 private function _processFilter()
 {
     $filter = $this->service->getHost()->getQueryStringItem(ODataConstants::HTTPQUERY_STRING_FILTER);
     if (is_null($filter)) {
         return;
     }
     $kind = $this->request->getTargetKind();
     if (!($kind == TargetKind::RESOURCE() || $kind == TargetKind::COMPLEX_OBJECT() || $this->request->queryType == QueryType::COUNT())) {
         throw ODataException::createBadRequestError(Messages::queryProcessorQueryFilterOptionNotApplicable());
     }
     $resourceType = $this->request->getTargetResourceType();
     $expressionProvider = $this->service->getProvidersWrapper()->getExpressionProvider();
     $filterInfo = ExpressionParser2::parseExpression2($filter, $resourceType, $expressionProvider);
     $this->request->setFilterInfo($filterInfo);
 }