On Apr 27, 4:08 am, turbo2ltr <turbo2...@gmail.com> wrote:
> Thanks, This is precisely the schema I was going to use. I guess I'm
> not quite sure what I'm asking....or maybe it's that I already know
> the answer.. heh.
>
> Guess I'll just play with it and see what I come up with...I think my
> concern is more around building the view. With the right
> relationships, it should get all the data, it's just a matter of
> passing the names of the attributes to the view. Maybe it's easier
> than I thought. Thanks!
>
> -Mike
>
> On Apr 26, 7:42 pm, "Max H. Thayer" <maxtha...@gmail.com> wrote:
>
>
>
>
>
>
>
> > Cake relies heavily on pre-defined and configured schemas... for a system you describe you might create a relation (table) called "user_defined_attributes"
>
> > with a schema like:
> > table name: user_defined_attributes
> > id (PK)
> > user_id (FK to your user)
> > attrb_title
> > attrb_description
>
> > table name: user_entries (table containing actual entries)
> > id (PK)
> > user_Id(FK to your user/s)
> > user_defined_attribute_id (FK to the above table)
> > entry_value
>
> > a model like this keeps users out of the actual DB structure manipulation (which is a big issue to have to address)
> > Cake can then handle this with its standard HABTM/HasMany construct.
>
> > Max H. Thayer
> > maxtha...@gmail.com
>
> > On Apr 26, 2011, at 10:31 PM, turbo2ltr wrote:
>
> > > I'm working on a system that needs to allow users to add their own
> > > attributes to the DB. For instance if you had a movies database, I
> > > need to allow the user to go into the attribute configuration and add
> > > "genre" which would allow every record in the movie DB to have a genre
> > > field. When they view a movie, it would need to dynamically render a
> > > view for all the custom attributes based on the attribute
> > > configuration.
>
> > > I've done this many times in PHP using link tables so I know how to do
> > > it. The biggest hurdle with learning cakePHP is knowing what it can
> > > do. I could code this up manually then find out there was an easy way
> > > to do it. I didn't see anything in the manual about it so I'm just
> > > asking....are there any features of cake that would make this specific
> > > task easy(er)? Or will I have to handle it all manually? Any tips
> > > for those that have done it already?
>
> > > Thanks,
> > > Mike
>
> > > --
> > > Our newest site for the community: CakePHP Video Tutorialshttp://tv.cakephp.org
> > > Check out the new CakePHP Questions sitehttp://ask.cakephp.organdhelp others with their CakePHP related questions.
>
> > > To unsubscribe from this group, send email to
> > > cake-php+unsubscribe@googlegroups.com For more options, visit this group athttp://groups.google.com/group/cake-php
--
Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions.
To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
No comments:
Post a Comment