What is in the 'Stuff', 'MoreStuff' and 'StuffToChange' arrays? On Tuesday, July 24, 2012 2:05:40 AM UTC+2, lsiden wrote: > > I created a component test that modifies and saves a model with HABTM > associated data. > > Before I upgraded to CakePHP 2.0, I tried to accomplish this with > unbindModel() all over my code, but wanted to try something a little > cleaner albeit less efficient. I spent hours reading > http://book.cakephp.org/2.0/en/models/saving-your-data.html and wanted to > try doing it the "Cake" way: > > $data = array( >> 'User' => array( >> 'id' => 99, >> ... >> ), >> 'Stuff' => array( ... some stuff ...), >> 'MoreStuff => array( .. more stuff ...), >> 'StuffToChange' => array( ... this is the stuff I added a record to ...) >> ); > > > When I look at the query log, Cake generated queries to delete Stuff, > MoreStuff, and ReallyImportantStuff, but only does inserts into > StuffToChange. > > I'm wondering if this is somehow related to the fact that I'm using > fixtures in my test. I suppose I could clone the real database and try it > on that to see if its a fixture problem. (I'm too exhausted now to try > anything. I need a break!) > > So in order to make progress I had to give up for now and do it the "brute > force" (but much more effiicient way): > > $model->query("insert into stuff_to_change where user_id=99 and >> something_id=xxx") > > > I suppose Cake purists will tell me that this is wrong and could create > problems in the future if I were to migrate the data to a different > database platform, for example, but I wasted half a day trying to get this > to work and I can't afford to spend much more time when I have a > functioning workaround. Even if it turns out to be an issue that will only > happen when I use my fixtures, I want it to work the same way in a unit > test as it works in the field. > > Anyone else having this problem in Cake 2.x? (I'm actually in the master > branch from the Git repo - yeah, I'm bleeding edge now). >
-- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php