anime-db / catalog-bundle

                `cover` != "" AND

                `cover`  NOT LIKE "example/%"'

        );

        foreach ($items as $item) {

            $path = date('Y/m/d/His/', strtotime($item['date_add']));

            $file = new File($this->media_dir.$item['cover']);

            $file->move($this->media_dir.$path);

            $this->addSql('

                UPDATE

                    `item`

                SET

                    `cover` = ?

                WHERE

                    `id` = ?',

                [

                    $path.$file->getBasename(),

                    $item['id'],

                ]

            );

        }

        // move images

        $images = $this->connection->fetchAll('

                ON

                    im.`item` = i.`id`'

        );

        foreach ($images as $image) {

            $path = date('Y/m/d/His/', strtotime($image['date_add']));

            $file = new File($this->media_dir.$image['source']);

            $file->move($this->media_dir.$path);

            $this->addSql('

                UPDATE

                    `image`

                SET

                    `source` = ?

                WHERE

                    `id` = ?',

                [

                    $path.$file->getBasename(),

                    $image['id'],

                ]

            );

        }

        // skip if no data

        $this->skipIf(!($items && $images), 'No data to migrate');