public function testAddSummationClause() { $quote = DatabaseCompatibilityUtil::getQuote(); $adapter = new RedBeanModelSelectQueryAdapter(); $this->assertEquals(0, $adapter->getClausesCount()); $adapter->addSummationClause('abc', 'c'); $this->assertEquals(1, $adapter->getClausesCount()); $compareString = "select sum(abc) c "; $this->assertEquals($compareString, $adapter->getSelect()); $adapter = new RedBeanModelSelectQueryAdapter(true); $this->assertEquals(0, $adapter->getClausesCount()); $adapter->addSummationClause('def', 'c'); $this->assertEquals(1, $adapter->getClausesCount()); $compareString = "select distinct sum(def) c "; $this->assertEquals($compareString, $adapter->getSelect()); }
public function testAddClauseByQueryString() { $adapter = new RedBeanModelSelectQueryAdapter(); $this->assertEquals(0, $adapter->getClausesCount()); $adapter->addClauseByQueryString('querystring'); $this->assertEquals(1, $adapter->getClausesCount()); $compareString = "select querystring "; $this->assertEquals($compareString, $adapter->getSelect()); //Test with aliasName $quote = DatabaseCompatibilityUtil::getQuote(); $adapter = new RedBeanModelSelectQueryAdapter(); $this->assertEquals(0, $adapter->getClausesCount()); $adapter->addClauseByQueryString('querystring', 'aliasName'); $this->assertEquals(1, $adapter->getClausesCount()); $compareString = "select querystring aliasName "; $this->assertEquals($compareString, $adapter->getSelect()); }