Doctrine\DBAL\Query\QueryBuilder::getSQL PHP Method

QueryBuilder Interface Documentation Usage Examples Of Doctrine\DBAL\Query\QueryBuilder::getSQL Exibir arquivo Open project: doctrine/dbal

getSQL() public method


    $qb = $em->createQueryBuilder()
        ->select('u')
        ->from('User', 'u')
    echo $qb->getSQL(); // SELECT u FROM User u

public getSQL ( ) : string
return	string	The SQL query string.

    public function getSQL()
    {
        if ($this->sql !== null && $this->state === self::STATE_CLEAN) {
            return $this->sql;
        }
        switch ($this->type) {
            case self::INSERT:
                $sql = $this->getSQLForInsert();
                break;
            case self::DELETE:
                $sql = $this->getSQLForDelete();
                break;
            case self::UPDATE:
                $sql = $this->getSQLForUpdate();
                break;
            case self::SELECT:
            default:
                $sql = $this->getSQLForSelect();
                break;
        }
        $this->state = self::STATE_CLEAN;
        $this->sql = $sql;
        return $sql;
    }

Usage Example

Exemplo n.º 1

Exibir arquivo

Arquivo: QueryBuilderTest.php Projeto: dachcom-digital/TYPO3.CMS

 /**
  * @test
  */
 public function getSQLDelegatesToConcreteQueryBuilder()
 {
     $this->concreteQueryBuilder->getSQL()->shouldBeCalled()->willReturn('UPDATE aTable SET pid = 7');
     $this->concreteQueryBuilder->getType()->willReturn(2);
     // Update Type
     $this->subject->getSQL();
 }

All Usage Examples Of Doctrine\DBAL\Query\QueryBuilder::getSQL

QueryBuilder

__clone

__construct

__toString

add

addGroupBy

addOrderBy

addSelect

andHaving

andWhere

createNamedParameter