开发者

cakephp hasMany gives empty data set

I have a "Motor" model:

class Motor extends AppModel
{
   var $name = 'Motor';
   var $hasMany = array(
                       'MotorPictures' => array(
                          'className'       开发者_如何学编程=> 'MotorPicture',
                          'foreignKey'      => 'motor_id',
                          'dependent'       => true
                          )
                   );
}

Along with a MotorPicture model:

class MotorPicture extends AppModel
{
   var $name = 'MotorPicture';
   var $actsAs = array(
      'FileUpload.FileUpload' => array
      (
         'uploadDir' => 'img/motors',
         'required' => true
      )
   );

}

Here is the database:

--
-- Table structure for table `motors`
--

CREATE TABLE IF NOT EXISTS `motors` (
  `id` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT,
  `make` varchar(64) NOT NULL,
  `model` varchar(64) NOT NULL,
  `year` year(4) NOT NULL,
  `notes` text NOT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `edited` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;

--
-- Dumping data for table `motors`
--

INSERT INTO `motors` (`id`, `make`, `model`, `year`, `notes`, `created`, `edited`)
VALUES (0000000001, 'Audi', 'S4', 2000, 'This is a freaking sweet car.', '2011-01-11 21:04:00', '0000-00-00 00:00:00');

-- --------------------------------------------------------

--
-- Table structure for table `motor_pictures`
--

CREATE TABLE IF NOT EXISTS `motor_pictures` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `motor_id` int(11) unsigned NOT NULL,
  `name` varchar(256) NOT NULL,
  `type` varchar(256) NOT NULL,
  `size` int(11) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `motor_pictures`
--

INSERT INTO `motor_pictures` (`id`, `motor_id`, `name`, `type`, `size`, `created`, `modified`)
VALUES (1, 1, 'kitten.JPG', 'image/jpeg', 80518, '2011-01-12 20:13:55', '2011-01-12 20:13:55'),
(2, 1, 'kitten-1.JPG', 'image/jpeg', 80518, '2011-01-12 20:15:28', '2011-01-12 20:15:28');

When I bring up my view and print_r($motor) the output is such:

 Array ( [Motor] => Array ( [id] => 0000000001 [make] => Audi [model] => S4 [year] => 2000 [notes] => This is a freaking sweet car. [created] => 2011-01-11 21:04:00 [edited] => 0000-00-00 00:00:00 ) [MotorPictures] => Array ( ) )

As you can see (at the end of that long thing), the "MotorPictures" array is empty, even though the SELECT that the hasMany relationship enforces returns 2 results in the debug output.

Can anyone point me towards the thing I am doing wrong or just plain omitting?

Thanks!


I see in your Motor model Moter.id = 0000000001 and in your MotorPicture you have MotorPicture.moder_id=1.

0000000001 is not the same as 1


Oftentimes this sort of thing is caused by a too-restrictive recursion setting. Try setting $Motor->recursive = 1 in your controller before you call $Motor->find.


As it turns out my key and foreign key did not exactly match. One was an int (10) and the other was an int (11). Once I made one match the other in my database, it all started working.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜