Hi, Maybe you can use this $this->connection->getDatabasePlatform()->getName() http://doctrine-dbal.readthedocs.org/en/latest/reference/platforms.html to write queries for certain database?
2014-04-23 11:07 GMT+02:00 Ulrich Lichtenegger <[email protected]>: > Hi, > > i am new in the doctrine world. I'd like to use Doctrine DBAL (without the > ORM part). Is it somehow possible to write DQL Statements in Doctrine DBAL? > > I'd like to develop an application which works with different Databases > (MySQL; PostgreSQL, MS SQL, Oracle...) so i am searching for a way to write > database independent queries. DBAL does not warn me, when i add for example > a MySQL specific function to a QueryBuilder instance. > > e.g. this works very well with the mysql backend, but not with a postgresql > backend because postgres does not support IFNULL (but uses COALESCE): >> >> $qb->addSelect('IFNULL(user.phone,123456)'); >> $qb->from('mydb.usertable', 'user'); > > > How can Doctrine DBAL help me to do this? Or do i need to use Doctrine ORM > to get database independent queries? > > Thank you for your help! > > -- > You received this message because you are subscribed to the Google Groups > "doctrine-user" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/doctrine-user. > For more options, visit https://groups.google.com/d/optout. -- Best regards, Michal http://eventhorizon.pl/ -- You received this message because you are subscribed to the Google Groups "doctrine-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/doctrine-user. For more options, visit https://groups.google.com/d/optout.
