ezsystems / ezpublish-kernel

     *

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

     */

    protected function getTotalCustomUrlAliasBackupCount()

    {

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

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

        $queryBuilder

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

            ->from(static::CUSTOM_ALIAS_BACKUP_TABLE);

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

    }

    /**

     * Creates database table for custom URL alias backup.

     *

     * @return bool

     */

    protected function isTableEmpty($name)

    {

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

        $queryBuilder

            ->select($this->connection->getDatabasePlatform()->getCountExpression('*'))

            ->from($name);

        $count = $queryBuilder->execute()->fetchColumn();

        return $count == 0;

    }

    /**

     * Returns configured progress bar helper.