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 postTag: sql
Posts tagged sql from Setfive.
From the archive
4 posts
SQL: 5 Tips and tricks to impress your DBA friends
Five MySQL techniques for custom sorting, filtering LEFT JOINs, reusing aggregate variables, generating ranked columns, and selecting maximum rows per group.
Read the postSQL Join Checker, Making Sure Your Joins Are Right
A PHP SQL join checker parses hand-written queries against database foreign keys to catch incorrect joins and reveal missing constraints.
Read the postsfPropelPager and GROUP BY criteria
So for one reason or another (actually a few bad ones) I ended up having to use a Criteria object looking like this: My issue came when I tried to use it with a sfPropelPager. I set up the pager per usual but for some reason the results that were coming back weren’t correct. For some reason, the COUNT being returned by the sfPropelPager was completely wrong. It turns out the offending lines are here in sfPropelPager.class.php
Read the post