Export with QueryBuilder

Hi,

I use OroImportExportBundle to export datas in a custom action like this :

PHP

$query = $this->getDoctrine()->getRepository('RepositoryEntity') ->createQueryBuilder('s') ->setMaxResults(1) ->getQuery(); $options = [ 'queryBuilder' => $query ]; return $this->get('oro_importexport.handler.export')->handleExport( 'entity_export_to_csv', 'custom_service_oro_importexport.processor', 'export', 'csv', null, array_merge( $options, ['organization' => $this->get('oro_security.security_facade')->getOrganization()] ) );

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21

$query = $this->getDoctrine()->getRepository('RepositoryEntity')             ->createQueryBuilder('s')             ->setMaxResults(1)             ->getQuery();                  $options = [             'queryBuilder' => $query           ];                  return $this->get('oro_importexport.handler.export')->handleExport(             'entity_export_to_csv',             'custom_service_oro_importexport.processor',             'export',             'csv',             null,             array_merge(                 $options,                 ['organization' => $this->get('oro_security.security_facade')->getOrganization()]             )         );

When JobInstance Entity would persist it throw a serialization error :

Serialization of ‘Closure’ is not allowed

Due things in key _em of QueryBuilder Object…

Is the right to do ? Is another to way to use export bundle with complex query ?

Thanks

Topic

[Mike KudelyaParticipant]

Hi,

Probably doctrine is trying to serialize QueryBuilder to akeneo_batch_job_instance::rawConfiguration field and raise error. As workaround try to set for example [‘max_results’] => 1 to options in controller and process it in custom reader extended from here.

[Geoffroy CochardParticipant]

Hi,

Right, during createJobInstance(), it persist rawConfiguration property akeneo_batch_job_instance with who support options from ‘oro_importexport.handler.export service’.

in vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/ArrayType.php at line 45 - public function convertToDatabaseValue($value, AbstractPlatform $platform) { // @todo 3.0 - $value === null check to save real NULL in database return serialize($value); } /** at PDO ->__sleep () at SplObjectStorage ->serialize ()

1 2 3 4 5 6 7 8 9

in vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/ArrayType.php at line 45   -     public function convertToDatabaseValue($value, AbstractPlatform $platform)     {         // @todo 3.0 - $value === null check to save real NULL in database         return serialize($value);     }     /** at PDO ->__sleep () at SplObjectStorage ->serialize ()

So for the moment we can’t pass query or a queryBuilder to ExportHandler options to use in EntityReader::setSourceQueryBuilder()

max_results = 1 was an example, my needs would be more complex.

Should i see process to use in datagrid export ?

Geoffroy

[Geoffroy CochardParticipant]

But i don’t see how to param/change Reader to ItemStep class use by oro_importexport.handler.export.

Should i create a new connector to use another Reader ?
Should i push a custom context in my processor definition ?

YAML

dawkins_subscription.importexport.processor.export_subscription: parent: oro_importexport.processor.export_abstract calls: - [setDataConverter, [@dawkins_subscription.importexport.data_converter.subscription]] tags: - { name: oro_importexport.processor, type: export, entity: %dawkins.subscription.subscription.entity.class%, alias: dawkins_subscription_subscription }

1 2 3 4 5 6

dawkins_subscription.importexport.processor.export_subscription:         parent: oro_importexport.processor.export_abstract         calls:              - [setDataConverter, [@dawkins_subscription.importexport.data_converter.subscription]]         tags:             - { name: oro_importexport.processor, type: export, entity: %dawkins.subscription.subscription.entity.class%, alias: dawkins_subscription_subscription }

Thanks a lot for your advices.

[Mike KudelyaParticipant]

Hi,

How to override reader i have wrote there. Try to use custom options in controller like this and they automatically appear inside the reader.

PHP

$options = [ 'custom_option' => 1 ];

1 2 3 4

$options = [             'custom_option' => 1         ];

[Geoffroy CochardParticipant]

Hi,

I’m going to try this solution.
Thanks for all :) Great support.

[Mike KudelyaParticipant]

You are welcome!

[Author]

Replies