fabarea / media

     * @param \TYPO3\CMS\Core\Resource\ResourceStorage $storage

     * @return array

     */

    public function searchForDuplicateIdentifiers(ResourceStorage $storage)

    {

        // Detect duplicate records.

        $query = "SELECT identifier FROM sys_file WHERE storage = {$storage->getUid()} GROUP BY identifier, storage Having COUNT(*) > 1";

        $resource = $this->getDatabaseConnection()->sql_query($query);

        $duplicates = [];

        while ($row = $this->getDatabaseConnection()->sql_fetch_assoc($resource)) {

            $clause = sprintf('identifier = "%s" AND storage = %s', $row['identifier'], $storage->getUid());

            $records = $this->getDatabaseConnection()->exec_SELECTgetRows('*', 'sys_file', $clause);

            $duplicates[$row['identifier']] = $records;

        }

        return $duplicates;

    }

    /**

     * Return duplicates file records

     * @param \TYPO3\CMS\Core\Resource\ResourceStorage $storage

     * @return array

     */

    public function searchForDuplicateSha1(ResourceStorage $storage)

    {

        // Detect duplicate records.

        $query = "SELECT sha1 FROM sys_file WHERE storage = {$storage->getUid()} GROUP BY sha1, storage Having COUNT(*) > 1";

        $resource = $this->getDatabaseConnection()->sql_query($query);

        $duplicates = [];

        while ($row = $this->getDatabaseConnection()->sql_fetch_assoc($resource)) {

            $clause = sprintf('sha1 = "%s" AND storage = %s', $row['sha1'], $storage->getUid());

            $records = $this->getDatabaseConnection()->exec_SELECTgetRows('*', 'sys_file', $clause);

            $duplicates[$row['sha1']] = $records;

        }

        return $duplicates;

    }

    /**

     * @param string $tableName