public function testStatements() { //simple query, should be sql $this->qb->from($this->qf->selector('nt:base', "nt:base")); $this->assertSame('sql', $this->qb->getQuery()->getLanguage()); $this->assertSame("SELECT s FROM nt:base", $this->qb->getQuery()->getStatement()); //localname is not supported by sql1 $this->qb->where($this->qf->comparison($this->qf->nodeLocalName('nt:base'), Constants::JCR_OPERATOR_EQUAL_TO, $this->qf->literal('foo'))); $this->assertSame('JCR-SQL2', $this->qb->getQuery()->getLanguage()); $this->assertSame("SELECT * FROM [nt:base] WHERE LOCALNAME(nt:base) = 'foo'", $this->qb->getQuery()->getStatement()); //descendantNode is supported by sql1 $this->qb->where($this->qf->descendantNode('nt:base', "/foo")); //$this->assertSame('sql', $this->qb->getQuery()->getLanguage()); $this->assertSame("SELECT s FROM nt:base WHERE jcr:path LIKE '/foo[%]/%'", $this->qb->getQuery()->getStatement()); //joins are not supported by sql1 $this->qb->join($this->qf->selector('nt:unstructured', "nt:unstructured"), $this->qf->equiJoinCondition("nt:base", "data", "nt:unstructured", "data")); $this->assertSame('JCR-SQL2', $this->qb->getQuery()->getLanguage()); $this->assertSame("SELECT * FROM [nt:base] INNER JOIN [nt:unstructured] ON [nt:base].data=[nt:unstructured].data WHERE ISDESCENDANTNODE([nt:base], [/foo])", $this->qb->getQuery()->getStatement()); }
public function testJoin() { $source1 = $this->getMock('PHPCR\\Query\\QOM\\SourceInterface', array(), array()); $source2 = $this->getMock('PHPCR\\Query\\QOM\\SourceInterface', array(), array()); $joinCondition = $this->getMock('PHPCR\\Query\\QOM\\SameNodeJoinConditionInterface', array(), array()); $this->qf->expects($this->once())->method('join')->with($source1, $source2, $this->equalTo(\PHPCR\Query\QOM\QueryObjectModelConstantsInterface::JCR_JOIN_TYPE_INNER), $joinCondition); $qb = new QueryBuilder($this->qf); $qb->from($source1); $qb->join($source2, $joinCondition); }
public function testJoin() { $source1 = $this->getMock('PHPCR\\Query\\QOM\\SourceInterface', array(), array()); $source2 = $this->getMock('PHPCR\\Query\\QOM\\SourceInterface', array(), array()); $joinCondition = $this->getMock('PHPCR\\Query\\QOM\\SameNodeJoinConditionInterface', array(), array()); $qb = new QueryBuilder($this->qf); $qb->from($source1); $qb->join($source2, $joinCondition); }