| # |
Aug 8th 2008, 15:51 |
rose |
yeah thts true!! but i m looking for the best way not the easiest!! i dont fear challenegs!! |
| # |
Aug 8th 2008, 15:50 |
teknoid |
object comment i should say |
| # |
Aug 8th 2008, 15:50 |
teknoid |
rose: the easiest to make a separate table for each object :) |
| # |
Aug 8th 2008, 15:50 |
rose |
so yaa there is a way, but not easy! |
| # |
Aug 8th 2008, 15:50 |
teknoid |
rose: not sure what you mean, if your db supports compound key restraints, then it should be ok (cake does not by the way) |
| # |
Aug 8th 2008, 15:50 |
rose |
welll i guess i can set up triggers... |
| # |
Aug 8th 2008, 15:49 |
rose |
would not*** sorry! |
| # |
Aug 8th 2008, 15:48 |
rose |
hmm... but it both case, it would allow me to set up relations so that if object is deleted, comments should be deleted too (not in cake but in database) |
| # |
Aug 8th 2008, 15:47 |
teknoid |
rose: or object_type, sure |
| # |
Aug 8th 2008, 15:47 |
rose |
how can i without UUID??? with object_name field??? |
| # |
Aug 8th 2008, 15:47 |
teknoid |
rose: you can even without uuid, but for this case you could certainly use uuid just as well |
| # |
Aug 8th 2008, 15:46 |
rose |
UUID for objects so i can live with only one comments table |
| # |
Aug 8th 2008, 15:46 |
teknoid |
rose: in terms of what? |
| # |
Aug 8th 2008, 15:46 |
teknoid |
rose: of course you could also make separate tables for user_comments, image_comments, etc. |
| # |
Aug 8th 2008, 15:45 |
rose |
whts your thoughts on UUID ?? |
| # |
Aug 8th 2008, 15:44 |
teknoid |
lqdice____: np ;) |
| # |
Aug 8th 2008, 15:44 |
rose |
hmm |
| # |
Aug 8th 2008, 15:44 |
lqdice____ |
thanks tek. |
| # |
Aug 8th 2008, 15:44 |
lqdice____ |
oh she is so beautiful now :) |
| # |
Aug 8th 2008, 15:44 |
teknoid |
rose: or use the other option, depends on your app |
| # |
Aug 8th 2008, 15:44 |
rose |
if possible at all! |
| # |
Aug 8th 2008, 15:44 |
rose |
i m looking for something better! |
| # |
Aug 8th 2008, 15:43 |
rose |
hmm so lets say i have 15 different objects, u think i should create 15 different tables like <object>_comments ???? |
| # |
Aug 8th 2008, 15:43 |
lqdice____ |
ok that moves me forward a bit . .let me double check it onw .. silly mistake :) |
| # |
Aug 8th 2008, 15:43 |
teknoid |
rose: or has many with a column in comments specifying, what it is attached to |
| # |
Aug 8th 2008, 15:42 |
teknoid |
rose: habtm, with join table for each relation |
| # |
Aug 8th 2008, 15:42 |
lqdice____ |
ACTION whistles |
| # |
Aug 8th 2008, 15:41 |
teknoid |
lqdice____: oh... does ArchivesGroup have containable attached? |
| # |
Aug 8th 2008, 15:40 |
rose |
guys... need some of your experts opinion on this one: wht kind of db structure would u suggets when u need to attach a comment to multiple objects like users, images, messeges, etc |
| # |
Aug 8th 2008, 15:40 |
teknoid |
lqdice____: which line am i looking at? |
| # |
Aug 8th 2008, 15:39 |
lqdice____ |
teknoid: http://bin.cakephp.org/view/404172267 |
| # |
Aug 8th 2008, 15:37 |
teknoid |
beatzombies: np. you're welcome |
| # |
Aug 8th 2008, 15:37 |
beatzombies |
teknoid: thanks, good catch |
| # |
Aug 8th 2008, 15:35 |
teknoid |
lqdice____: can you show the code? |
| # |
Aug 8th 2008, 15:35 |
lqdice____ |
lol |
| # |
Aug 8th 2008, 15:35 |
lqdice____ |
if i do one way it ignores the condition i pass to GroupsNode.. if i do the other it ignores the condition i pass to Node |
| # |
Aug 8th 2008, 15:35 |
lqdice____ |
teknoid: i actually still havent fully figured out this problem |
| # |
Aug 8th 2008, 15:33 |
beatzombies |
teknoid: nice call |
| # |
Aug 8th 2008, 15:33 |
beatzombies |
ooh |
| # |
Aug 8th 2008, 15:32 |
teknoid |
beatzombies: should be Collection in the data array (i.e. same as model name) |
| # |
Aug 8th 2008, 15:30 |
beatzombies |
here is my controller and data: http://bin.cakephp.org/view/1208887425 |