3

I have a model Post -> hasAndBelongsToMany -> Tag

For testing, I created the fixtures for each model, for example, a fixture for the model Post looks like this

class PostFixture extends CakeTestFixture {
    var $import = array('model' => 'Post', 'records' => true, 'connection' => 'fixtures');
}

And everything works great for that Model, but when I try to create the fixture for the HABTM relationship, using the same approach doesn’t work:

class PostsTagFixture extends CakeTestFixture {
    var $import = array('model' => 'PostTag', 'records' => true, 'connection' => 'fixtures');
}

The SQL generated by CakePHP is the following

CREATE TABLE `service_types_technicals` (
    `technical_id` int(20) NOT NULL AUTO_INCREMENT,
    `service_type_id` int(20) NOT NULL AUTO_INCREMENT,
    `id` varchar(255) NOT NULL, PRIMARY KEY  (`id`))    ;

Wich is not correct because the table does not have a field named id.

Then, I tried this:

class PostsTagFixture extends CakeTestFixture {
    var $name = 'PostsTag';
    var $import = array('table' => 'posts_tags', 'records' => true, 'connection' => 'fixtures');
}

And again, error, but this time the SQL was:

CREATE TABLE `service_types_technicals` (
    `technical_id` int(20) NOT NULL AUTO_INCREMENT,
    `service_type_id` int(20) NOT NULL AUTO_INCREMENT,  PRIMARY KEY  (`service_type_id`))   ;

What am I doing wrong? What is the correct way to import fixtures from another database for has and belongs to many relationships?

Thank you!

benjamin
  • 2,185
  • 1
  • 14
  • 19
Mauro Zadunaisky
  • 798
  • 1
  • 11
  • 21
  • 2
    I don't know too much about this, but as far as I know, HABTM relationships need an ID field. This might be why Cake is trying to create one – JohnP Apr 04 '11 at 17:34
  • 1
    Second that, every table has an id column afaik. – benjamin Apr 05 '11 at 05:36
  • @JonhP that's right, putting an id field solved the issue. Can you post it as an answer so I can mark it as responded and you earn the points? thank you! – Mauro Zadunaisky Apr 08 '11 at 11:41

2 Answers2

1

Mauro Zadunaisky,

as you state that service_types_technicals does not have an id field, I guess that CakePHP automatically deduces a HABTM from service_types to technicals, as both are nouns written in plural (CakePHP convention). If this is not what you had in mind, then you are forced to alter the name of the table to stay within the conventions.

benjamin
  • 2,185
  • 1
  • 14
  • 19
1

The problem was the missing of the field id in the habtm relation table, it's fixed now

Mauro Zadunaisky
  • 798
  • 1
  • 11
  • 21