ezsystems / ezpublish-kernel

     *

     * The number excludes absolute root Location, which does not have an URL alias.

     */

    protected function getTotalLocationCount()

    {

        $platform = $this->connection->getDatabasePlatform();

        $queryBuilder = $this->connection->createQueryBuilder();

        $queryBuilder

            ->select($platform->getCountExpression('node_id'))

            ->from('ezcontentobject_tree')

            ->where(

                $queryBuilder->expr()->neq(

                    'node_id',

                    UrlAliasHandler::ROOT_LOCATION_ID

                )

            );

        return $queryBuilder->execute()->fetchColumn();

    }

    /**

     * Returns total number of Content objects having a Location in the database.

     *

     * The number excludes absolute root Location, which does not have an URL alias.

     */

    protected function getTotalLocationContentCount()

    {

        $platform = $this->connection->getDatabasePlatform();

        $queryBuilder = $this->connection->createQueryBuilder();

        $queryBuilder

            ->select($platform->getCountExpression('DISTINCT contentobject_id'))

            ->from('ezcontentobject_tree')

            ->where(

                $queryBuilder->expr()->neq(

                    'node_id',

                    UrlAliasHandler::ROOT_LOCATION_ID

                )

            );

        return $queryBuilder->execute()->fetchColumn();

    }

    /**

     * Return the number of rows in the given $table (on ID column).