I got this off of a Fabien post, somewhere. If you look at it, it
makes everything connect to the same parent record. It SHOULD save
correctly. I am goin to try it in my project tonight. Let me know if
it works for you.
$user = new User();
$profile = new $user->Profile;
$userForm = new UserForm($user);
$profileForm = new ProfileForm($profile);
$userForm->embedForm('Profile', $profileForm);
On Oct 5, 2:13 am, elkrema <[email protected]> wrote:
> Hi Dennis,
>
> there is my schema:
>
> Feature:
> tableName: feature
> columns:
> id:
> type: integer(8)
> primary: true
> autoincrement: true
> name:
> type: string(255)
> notnull: true
> created_at: timestamp(25)
> updated_at: timestamp(25)
> relations:
> OpinionFeature:
> local: id
> foreign: feature_id
> type: many
>
> Opinion:
> tableName: opinion
> columns:
> id:
> type: integer(8)
> primary: true
> autoincrement: true
> title:
> type: string(255)
> notnull: true
> opiniontxt:
> type: string(2147483647)
> notnull: true
> is_active:
> type: integer(1)
> default: '0'
> notnull: true
> token:
> type: string(255)
> notnull: true
> created_at: timestamp(25)
> updated_at: timestamp(25)
> relations:
> OpinionFeature:
> local: id
> foreign: opinion_id
> type: many
>
> OpinionFeature:
> tableName: opinion_feature
> columns:
> opinion_id:
> type: integer(8)
> primary: true
> feature_id:
> type: integer(8)
> primary: true
> score:
> type: float(2147483647)
> notnull: true
> created_at: timestamp(25)
> updated_at: timestamp(25)
> relations:
> Opinion:
> local: opinion_id
> foreign: id
> type: one
> Feature:
> local: feature_id
> foreign: id
> type: one
>
> Its very similar to your schema. Mine havent got foreign_type but i
> think it works same yours... no?
>
> I did that with mysql workbench and then build schema... :)
>
> I think the problem was save embed forms i have to overwrite the
> saveEmbedForms function to set the opinionid of the OpinionFeature
> just at the moment of insert the opinion. Doing that it works, but i
> dont know if its the right way.
>
> Thank you very much.
>
> On 5 oct, 05:10, Dennis <[email protected]> wrote:
>
> > 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
-~----------~----~----~----~------~----~------~--~---
