On Fri, Aug 20, 2010 at 8:13 PM, toki <[email protected]> wrote: > Here is the context: > I want to store theorems objects in my database. > A theorem as many sons and many fathers. > So it's a graph and not a simple tree. > > I can't create a table like (id, theorem_id, theorem_id) : this > syntaxe is forbidden > > An ugly solution : (id, parentid, theorem_id), with added code in > controllers > > Do you see a better way todo ? Can cakephp do such things ? >
I think what you're dealing with is a "directed acyclic graph". Have a look at this article: "A Model to Represent Directed Acyclic Graphs (DAG) on SQL Databases": http://www.codeproject.com/KB/database/Modeling_DAGs_on_SQL_DBs.aspx It's been awhile for me since I thought about these, and I haven't attempted to use this with Cake. But I think that article might help you come up with a solution. If all works out, please consider posting something at the Bakery. 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
