So what you have is a:
<Opinion>--1-to-many --<OpinionFeature>--many-to-1--<Feature>
(above is a good way to show a schema)
So you have to set up your schema to reflect that:
Keep in mind that you have to create the Parents, before creating the
children.
Parents HAVE an ID, Children are GIVEN or USE and ID.
Parents are 'Opinion' and 'Feature'.
Opinion:
tableName: opinion
columns:
opinion_id:
type: integer(8)
primary: true
sequence: opinion_opinion_id
opinion_name:
type: string(65)
notnull: true
relations:
OpinionFeature:
local: opinion_id
foreign: opinion_id
type: many
foreignType: one
Feature:
tableName: feature
columns:
feature_id:
type: integer(8)
primary: true
sequence: feature_feature_id
feature_name:
type: string(32)
notnull: true
feature_desc:
type: string(128)
notnull: true
relations:
OpinionFeature:
local: feature_id
foreign: feature_id
type: many
foreignType: one
OpinionFeature:
tableName: opinionfeature
columns:
opinion_id:
type: integer(8)
primary: true
feature_id:
type: integer(8)
primary: true
score:
type: integer(2)
notnull: true
relations:
Opinion:
local: opinion_id
foreign: opinion_id
type: one
foreignType: many
Feature:
local: feature_id
foreign: feature_id
type: one
foreignType: many
See if this works :-)
Personally, I like graphical database design tools. I make the design,
have it spit out the code for the database that I'm using, then make
the database, use Doctrine to build the schema (instead of composing
it like above), make my model-forms-filters, and go.
I've had good luck using DezignForDatabases. The guy who makes it is
very helpful and friendly. It's not perfect, but it's great for the
price.
On Oct 2, 3:39 am, Francisco José Núñez Rivera <[email protected]>
wrote:
> But all the opinions have the same features.
>
> Feature -> id , desc
> 1,Feature 1 ; 2, Feature2...
>
> Opinion shows all the features..
> Feature 1 -Score:
> Feature 2 - Score:
>
> OpinionFeature -> opinion_id , feature_id , score
> I only insert a row here when im scoring a feature.
>
> I think my schema is right... no?
>
> Thank you very much.
>
> 2009/10/1 Abraham Montilla <[email protected]>
>
> > elkrema, if you have I have an Opinion with many Features then the right
> > schema is
>
> > Feature is: id, opinion_id, desc
> > OpinionFeature is: opinion_id, score
>
> > that's why you have an integrity constraint violation.... I don't know how
> > i missed that first time i read your post hehe, that's all the problem
>
> > 2009/10/1 elkrema <[email protected]>
>
> >> With unsetting only option id doesn't work.
>
> >> The problem is that i am inserting the object of main form and the
> >> embedded objects too.
>
> >> But i found a solution... I rewrite the function saveEmbeddedForms in
> >> OpinionForm
>
> >> public function saveEmbeddedForms($con = null, $forms = null)
> >> {
>
> >> foreach($this->getEmbeddedForms() as $opinionForm)
> >> {
>
> >> $opinionForm->getObject()->setOpinionId($this->getObject()->getId
> >> ());
> >> }
>
> >> parent::saveEmbeddedForms($con, $forms);
> >> }
>
> >> I set the opinionid before saving the embed forms....I dont know if is
> >> the good way..
>
> >> Otherwise i have a new problem..
>
> >> when i'm editing an opinion the value of the last feature is not
> >> showed.. ¿?
>
> >> Thank you!
>
> >> On 30 sep, 07:21, Abraham Montilla <[email protected]> wrote:
> >> > try just unsetting opinion_id, tell me if works
>
> >> > 2009/9/29 elkrema <[email protected]>
>
> >> > > Hello Abraham,
>
> >> > > This is my code with i'm embedding forms in OpinionForm:
>
> >> > > foreach($this->getObject()->getFeatures() as $feature)
> >> > > {
> >> > > $opinionf = new OpinionFeature();
> >> > > $opinionf->setOpinionId($this->getObject()->id);
> >> > > $opinionf->setFeatureId($feature->getId());
> >> > > $this->embedForm($feature->getName(), new OpinionFeatureForm
> >> > > ($opinionf));
> >> > > }
>
> >> > > With this code in when saving always get this flash message in the
> >> > > first Feature...
>
> >> > > * Feature id: Invalid.
>
> >> > > And if i configure OpinionFeatureForm to unset the fields (just for
> >> > > testing)
>
> >> > > unset($this['opinion_id'], $this['feature_id']);
>
> >> > > I get ..
>
> >> > > SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or
> >> > > update a child row: a foreign key constraint fails
> >> > > (`opinion`.`opinion_feature`, CONSTRAINT `opinion_feature_ibfk_1`
> >> > > FOREIGN KEY (`opinion_id`) REFERENCES `opinion` (`id`) ON DELETE
> >> > > CASCADE)
>
> >> > > Thank you for helping
>
> >> > > On 29 sep, 01:25, Abraham Montilla <[email protected]> wrote:
> >> > > > i think it's because when embedding the OpinionFeatureForms you're
> >> not
> >> > > > setting properly the foreign key to the objects, would be something
> >> like
>
> >> > > > for ( $i ..... ){
> >> > > > $opfeat = new OpinionFeature();
> >> > > > $opfeat->setOpinionId($this->getObject->getId());
> >> > > > $OFform = new OpinionFeatureForm($opfeat);
> >> > > > $this->embedForm('Feature_'.$i, $OFform);
>
> >> > > > }
>
> >> > > > 2009/9/28 elkrema <[email protected]>
>
> >> > > > > Hello
>
> >> > > > > i have some problems with my embed forms and i can't find a
> >> > > > > solution...
>
> >> > > > > I have an Opinion with many Features..
>
> >> > > > > Feature is: id, desc
> >> > > > > OpinionFeature is: opinion_id, feature_id,score
>
> >> > > > > In OpinionForm i'm inserting with [for each] all the features, but
> >> > > > > when im creating a new opinion i always get [Integrity constraint
> >> > > > > violation]
>
> >> > > > > I'ts easy get the id of the feature but i can get the ID of the
> >> > > > > opinion because it isnt created yet... is null.
>
> >> > > > > Somebody can help me please? I get trought many forums and jobeet
> >> > > > > tutorial but i cant get the solution!
>
> >> > > > > PS. Sorry for me english!!
>
> >> > > > --
> >> > > > Have a nice day.
> >> > > > Abraham Montilla.
>
> >> > --
> >> > Have a nice day.
> >> > Abraham Montilla.
>
> > --
> > Have a nice day.
> > Abraham Montilla.
>
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"symfony users" 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/symfony-users?hl=en
-~----------~----~----~----~------~----~------~--~---
