Re: [nyphp-talk] Database Design Patterns

2007-05-11 Thread Joseph Crawford
Jon, AFAIK CI does not have this ability, that's the issue with CI is that it is maintained by 1 person and not a community project. -- Joseph Crawford Jr. Zend Certified Engineer Codebowl Solutions, Inc. http://www.codebowl.com/ Blog: http://www.josephcrawford.com/ 1-802-671-2021 [EMAIL PROTECT

Re: [nyphp-talk] Database Design Patterns

2007-05-11 Thread Jon Baer
Im biased and was talking specifically re: CakePHP AR HBTM implementation ... http://manual.cakephp.org/chapter/models Your simple join would be as simple as: class A extends AppModel { $var hasMany = array("B"); } class B extends AppModel { $var belongsTo = array("A"); } $a = $this->A->findByI

Re: [nyphp-talk] Database Design Patterns

2007-05-11 Thread Joseph Crawford
Jon, I was aware that the CI active record pattern is not the best implementation and if we were to go with a true active record i would roll my own and integrate it into CI in one way or another. I am just not sure what the benefits are for this as I read documentation i do not see how the join

Re: [nyphp-talk] Database Design Patterns

2007-05-11 Thread Jon Baer
The key you are missing is the idea of a "hasMany", "hasOne", "hasAndBelongsToMany", "belongsTo", and the other conventions. With that many of the joins are automagically created for you and you generally dont need to worry about your bindings are they will happen unless you tell them not t

[nyphp-talk] Database Design Patterns

2007-05-11 Thread Joseph Crawford
Guys, We are using CodeIgniter for our framework that will run our sites, however the database implementation that they offer is based on the Active Record pattern. I have been running into issues that are making me think this is not the pattern for us to use. I have been going through the php|