Doctrine2 QueryBuilder Executable SQL Without Running The Query
How to extract executable SQL, ordered parameters, and parameter types from a Doctrine2 Query without running it, using reflection and restoring selected-column aliases.
Read the postCategory: Doctrine
Posts in the Doctrine category from Setfive.
From the archive
12 posts
Making Doctrine and Symfony Logged Queries Runnable
A tool that converts Doctrine and Symfony SQL log entries into runnable queries for debugging background processes without the web debug toolbar.
Read the postIncluding Foreign Keys in Doctrine2 Array Results
How to include Doctrine foreign key columns in array results for efficient Symfony/PHP data exports without joining related tables or hydrating entities.
Read the postDoctrine2: Using ResultSetMapping and MySQL temporary tables
Using Doctrine2's ResultSetMapping and runtime entity metadata to hydrate User entities from MySQL temporary tables created for analytics queries.
Read the postSymfony2: Logging users in programatically with Doctrine2 and FOSUserBundle
How Doctrine2 proxy entities can break Symfony2 and FOSUserBundle programmatic logins, and how a joined repository query preserves the user ID.
Read the post