ezsystems / ezpublish-kernel

     *

     * @return int

     */

    protected function getTotalBackupCount($table)

    {

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

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

        $queryBuilder

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

            ->from($table);

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

    }

    /**

     * Creates database table for custom Location 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.

        return $rows;

    }

    public function countTrashed(): int

    {

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

        $query = $this->connection->createQueryBuilder()

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

            ->from('ezcontentobject_trash');

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

    }

    /**

     * Removes every entries in the trash.