Subcategories

[Dan Coutu]

I see that the schema for categories has a parent_id that is clearly intended to provide an ability to support subcategories to an arbitrary depth. However the model doesn't seem reflect this with a belongs_to.

Am I misunderstanding the purpose of the parent_id field?

Dan

[Bruno Bornsztein]

Hi Dan,

There's no category_id on the categories table, or at least there shouldn't be. Not sure why yours has one. Can you check your migrations?

Dan

--
You received this message because you are subscribed to the Google Groups "CommunityEngine" group.
To unsubscribe from this group and stop receiving emails from it, send an email to communityengi...@googlegroups.com.
To post to this group, send email to communi...@googlegroups.com.
Visit this group at http://groups.google.com/group/communityengine?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

[Dan Coutu]

Okay so now we have two mysteries:

1. What is the purpose of the parent_id in the categories table?

2. Why is it that the tables violate the active record convention of having an id value on all tables?

I would offer that not having an id value on all table is a serious mistake. I had just assumed that the tables had an id value and in fact had created migrations intended to create an association between categories and a table of my own that I added. But without an id value on the categories table that won't work well. I guess I'll be adding it. I do think that for the CE code to be world-class reusable and flexible it should be revised to include id values on all tables.

Dan 

[Bruno Bornsztein]

Uh.. again, I'm not sure why your categories table has a parent_id on, or why it doesn't have an id column. It seems like something's amiss with your migrations. I get the sense that your CE install is not quite right. Here's what your schema should look like with a default install:

https://gist.github.com/bborn/5214271

[Dan Coutu]

Oh lord, I had forgotten that parent_id was in my own extensions to the table and in looking at the schema.rb file forgot that the id value is implicit in all tables. Need more coffee...

I had added parent_id explicitly to support subcategories.

Sorry for the confusion. I'll be better soon. :-)

BTW, can I suggest adding support for subcategories to the base code?

Dan

--
You received this message because you are subscribed to a topic in the Google Groups "CommunityEngine" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/communityengine/q81FHFScDNQ/unsubscribe?hl=en.
To unsubscribe from this group and all its topics, send an email to communityengi...@googlegroups.com.