H!i
I'm trying to write a simple behavior for binding models but may be I
do something wrong cause using behavior causes errors in sql queries
generated by CakePHP.
Here is detailed info (a snippet from whole application):
One model "Offer" (primary used) which *hasMany* "Category" & "Type".
For every one of these three models I have a three models "OfferI18n",
"CategoryI18n" & "TypeI18n" where I want to store translated details
for the primary models (yes, I know that there is built-in translate
behavior but it's not suitable for my purposes).
So I try to bind these *I18n models to "primary" models in behavior.
Here is the code of behavior:
############################
class LanguageBehavior extends ModelBehavior{
function setup(&$model, $config) {
$db =& ConnectionManager::getDataSource($model->useDbConfig);
if (!$db->connected) {
trigger_error('Datasource '.$model->useDbConfig.' for
LanguageBehavior of model '.$model->alias.' is not connected',
E_USER_ERROR);
return false;
}
$lang_model=array($model->name.'I18n'=>array('foreignKey'=>
$config['key']));
$model->bindModel(array('hasMany'=>$lang_model));
}
}
############################
And there is how I'm trying to use the behavior in models:
############################
class Offer extends AppModel{
var $actsAs=array('Language'=>array('key'=>'offer_id'));
.
.
.
}
class Category extends AppModel{
var $actsAs=array('Language'=>array('key'=>'category_id'));
.
.
.
}
class Type extends AppModel{
var $actsAs=array('Language'=>array('key'=>'type_id'));
.
.
.
}
############################
So here is the problem - in Offer controller if I try to fetch data,
doing for example "$this->Offer->findAll()" and everything is OK
(models are binded and data is fetched). But after receiving all
offers I try to receive some Category (""$this->Offer->Category-
>findAll()"") and I receive error like this:
"Query: SELECT `Category18n`.`id`, `Category18n`.`category_id`,
`CategoryI18n`.`locale`, `Category18n`.`content`, `CategoryI18n`. FROM
`category_i18ns` AS `CategoryI18n` WHERE locale="bul" AND
Category18n`. IN (1, 2, 3, 4)"
As you can see - the query fails because this: "Category18n`. IN (1,
2, 3, 4)" the field of the table CategoryI18n is missing.
Very strange, but if I don't execute any query on Offer before,
Categories are fetched OK, but if I run any query on Offer and other
models (Category & Type) broke.
I suppose there is something wrong in my behavior but I don't know
what.
Please help.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
