Symfony2 Doctrine2 query with array parameter

Question

I need to make query like this:

SELECT p.pid, p.url FROM products as p WHERE url_crc IN (FNV_64("http://url1.com/"),FNV_64("http://url2.com/"))

I need to use FNV_64 hash function for every array variable. I CAN'T make hashes before passing variables to query builder. This hash functions is only avaliable as MySQL extension.

How can i make this using Symfony2 ? For example, using:

$qb = $em->createQueryBuilder();
$query = $qb->select('p.pid')
            ->from('SRC\MainBundle\Entity\Product', 'p')
            ->where('p.url_crc IN (FNV_64(:urls))') // error HERE
            ->setParameter('urls', $hashes_array)
            ->getQuery();

Wouldn't work. The only way i can this of is:

$query = $em->createNativeQuery('SELECT p.pid, p.url FROM products as p
                                WHERE url_crc IN (' . join(',', $tmp_array) . ')', $rsm);

Where tmp_array looks like this:

Array
(
    [0] => FNV_64("http://url1.com/")
    [1] => FNV_64("http://url2.com/")
)

Is there better way ?

gview · Accepted Answer · 2012-07-26 01:17:53Z

1

You can always bypass DQL. However, Doctrine2 was designed to support various database engines, and allows you to add "vendor specific SQL functionalities in DQL". You can read This link to see how you could code in support for your mysql extension. There's also a link to a github repo with a number of extensions you can look at for examples.

One other thing-- I found at least one php implementation of the FNV hash here.

edited Jul 26, 2012 at 1:17

answered Jul 26, 2012 at 1:10

gview

15.5k3 gold badges53 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Symfony2 Doctrine2 query with array parameter

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related