CakePHP’s cache that wouldn’t quit

I had the joy of debugging some unit tests the other day on AMO and ran into caching trouble. Turns out the bug for this was filed over a year ago, but I tested it in the latest build of Cake ( and it’s still not fixed.

Cake’s models have a Boolean variable called $cacheQueries which I misplaced my faith in early on. Turns out this does disable query caching…sometimes.
The test I was writing was pretty straight forward: Look in the database for some information to make sure it wasn’t there, add the info, look in the database to make sure it was there. You can see the actual code, but this example is simplified:

1. $this->Addon->cacheQueries = false; // Disable the built-in caching.
2. $ret = $this->Addon->query("SELECT addon_id FROM `addons_tags` WHERE addon_id={$this->testdata['addonid']}");
3. $this->assertEmpty($ret, 'Data exists!'); // this should be empty
4. $this->Addon->doSomething($this->testdata['addonid']);
5. $ret = $this->Addon->query("SELECT addon_id FROM `addons_tags` WHERE addon_id={$this->testdata['addonid']}");
6. $this->assertNotEmpty($ret, 'Data exists!'); // The array should have info in it

The problem is, line 5 always returned an empty array. I turned the DEBUG mode to 2 so Cake would print out all the queries it was doing and discovered it never actually made the second SELECT call. I smell query caching!
Let’s dig through some CakePHP code to figure out what’s up:
$this->Addon->query() is passed through AppModel::query() to Model::query() and eventually works it’s way down to DboSource::query() with the same arguments. This is where things go south. Near the top of that function you’ll see:

if (count($args) == 1) {
return $this->fetchAll($args[0]);

The function signature for DboSource::fetchAll() looks like:

function fetchAll($sql, $cache = true, $modelName = null)

You can see the second parameter is a Boolean for caching and by default it’s on. That’s the fly in my clam chowder!
So, two ways around it:
The first way is to scroll up about 20 lines and look at the end of DboSource::query(). There is a handler there for a second parameter to your original query() function. Pass in false and voila, things just work. Of course, I didn’t realize this until I was writing this post. I’m pretty sure it’s not documented anywhere unless you look at the code.
The second way is to use execute() instead of query(). If you look at DboSource::execute() you’ll see it suffers no caching and is as close to a direct SQL call as you can get.
The CakePHP manual has this to say about query() and execute():
Custom SQL calls can be made using the model’s query() and execute() methods. The difference between the two is that query() is used to make custom SQL queries (the results of which are returned), and execute() is used to make custom SQL commands (which require no return value).
Apparently there are some other differences as well. (The fact that execute() returns results seems counter to what the manual suggests in the paragraph above but I may just be misinterpreting what they mean.) Regardless, if your tests are failing double check that you’re not fighting the cache and save yourself some time.