On Apr 23, 4:25 pm, Thomas Allen <[email protected]> wrote:
> Hello,
>
> I have some data that must be stored in a tree structure. Here is the
> SQL used to create that data's table:
>
> drop table if exists fields;
> create table fields (
> id int(11) unsigned not null auto_increment,
> created_at datetime not null,
> updated_at datetime not null,
>
> template_id int(11) unsigned not null,
> field_id int(11) unsigned,
> type varchar(255) not null,
> name varchar(255) not null,
> label varchar(255) not null,
> required tinyint(1) default 0,
> weight tinyint(1) default 0,
>
> primary key (id)
> );
>
> I baked a model and a scaffold controller for this data using `cake
> bake` but the SQL generated from this model is faulty. Specifically,
> the following is invalid as the same name "Field" is aliased twice:
>
> SELECT COUNT(*) AS `count` FROM `fields` AS `Field` LEFT JOIN
> `templates` AS `Template` ON (`Field`.`template_id` = `Template`.`id`)
> LEFT JOIN `fields` AS `Field` ON (`Field`.`field_id` = `Field`.`id`)
> WHERE 1 = 1;
>
> Here are the model relationships that are generating this SQL:
>
> <?php
> class Field extends AppModel {
> var $name = 'Field';
> var $displayField = 'name';
>
> // Validations omitted
>
> var $belongsTo = array(
> 'Template' => array(
> 'className' => 'Template',
> 'foreignKey' => 'template_id',
> 'conditions' => '',
> 'fields' => '',
> 'order' => ''
> ),
> 'Field' => array(
> 'className' => 'Field',
> 'foreignKey' => 'field_id',
> 'conditions' => '',
> 'fields' => '',
> 'order' => ''
> )
> );
>
> var $hasMany = array(
> 'Field' => array(
> 'className' => 'Field',
> 'foreignKey' => 'field_id',
> 'dependent' => false,
> 'conditions' => '',
> 'fields' => '',
> 'order' => '',
> 'limit' => '',
> 'offset' => '',
> 'exclusive' => '',
> 'finderQuery' => '',
> 'counterQuery' => ''
> )
> );
>
> }
>
> Does anyone know what I can do so that there is no duplicate alias on
> the self-join?
The array key is the alias, so you can name it whatever. That's why
the className key is there. It took me a while to figure that one out.
I always thought it was redundant.
var $hasMany = array(
'ChildField' => array(
'className' => 'Field',
...
);
Check out the new CakePHP Questions site http://cakeqs.org and help others with
their CakePHP related questions.
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected] For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
