> I've have two tables:
> authors, has a column called id (amongst others)
> books, has columns called id and authorid (amongst others)
> Obviously a book has an author, so any value of authorid must exist in the
> authors table.
> When I retrieve an authors row, I also want to return the corresponding
> authors row (books.authorid = authors.id).
> However, when trying to update my Book model, it always seems to link from
> the id column - how do I make it work against a different column?
> Cheers,
> N.
> --
> 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
Thanks for the response, but I'm not entirely sure what your suggesting.
An author has many books, and so I can amend the author model to point author.id at book.authorid. Conversely, many books have the same author, so I want the book model to allow book.authorid to reference author.id. However, as has been pointed out, the model on book wants to use the primary key for book which would be book.id and not book.authorid. There are a number of other fields I need to apply this too as well.
Looking through the cakePHP cookbook, there's section on models and linking models together. At the bottom of the section on hasMany (User hasMany Comment), it says
"One thing to remember is that you'll need a complimentary Comment belongsTo User association in order to get the date in both directions."
However, it doesn't give any suggestion on what this needs to look like, and that's what I'm trying to set up.
I've not tried this, but do I need to give both keys the same name or something like that?
On Sunday, July 29, 2012 9:58:00 PM UTC+1, MaJerle.Eu wrote:
> it always search for primary key, set $primaryKey variable in model to > your column > -- > Lep pozdrav, Tilen Majerle > http://majerle.eu
> 2012/7/29 newt_e <snip>
>> Hi,
>> I've have two tables: >> authors, has a column called id (amongst others) >> books, has columns called id and authorid (amongst others)
>> Obviously a book has an author, so any value of authorid must exist in >> the authors table.
>> When I retrieve an authors row, I also want to return the corresponding >> authors row (books.authorid = authors.id).
>> However, when trying to update my Book model, it always seems to link >> from the id column - how do I make it work against a different column?
>> Cheers, >> N.
>> -- >> 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
...is where belongsTo is documented, you should look over that.
But -- even though I hate to be that jerk who points out problems other
than the one you asked about -- before you get too far, the data model you
describe only lets a book have a single author. If you're storing actual
real-world books in there, you probably want to support books having
multiple authors, which means a HABTM "hasAndBelongsToMany" association.
For that you need a third table authors_books, etc as described in the
cookbook.
On Wed, Aug 1, 2012 at 7:53 AM, newt_e <new...@blueyonder.co.uk> wrote:
> Hi,
> Thanks for the response, but I'm not entirely sure what your suggesting.
> An author has many books, and so I can amend the author model to point
> author.id at book.authorid.
> Conversely, many books have the same author, so I want the book model to
> allow book.authorid to reference author.id. However, as has been pointed
> out, the model on book wants to use the primary key for book which would be
> book.id and not book.authorid. There are a number of other fields I need
> to apply this too as well.
> Looking through the cakePHP cookbook, there's section on models and
> linking models together. At the bottom of the section on hasMany (User
> hasMany Comment), it says
> "One thing to remember is that you'll need a complimentary Comment
> belongsTo User association in order to get the date in both directions."
> However, it doesn't give any suggestion on what this needs to look like,
> and that's what I'm trying to set up.
> I've not tried this, but do I need to give both keys the same name or
> something like that?
> N.
> On Sunday, July 29, 2012 9:58:00 PM UTC+1, MaJerle.Eu wrote:
>> it always search for primary key, set $primaryKey variable in model to
>> your column
>> --
>> Lep pozdrav, Tilen Majerle
>> http://majerle.eu
>> 2012/7/29 newt_e <snip>
>> Hi,
>>> I've have two tables:
>>> authors, has a column called id (amongst others)
>>> books, has columns called id and authorid (amongst others)
>>> Obviously a book has an author, so any value of authorid must exist in
>>> the authors table.
>>> When I retrieve an authors row, I also want to return the corresponding
>>> authors row (books.authorid = authors.id).
>>> However, when trying to update my Book model, it always seems to link
>>> from the id column - how do I make it work against a different column?
>>> Cheers,
>>> N.
>>> --
>>> 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.
>> --
> 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
-- Daniel Baird
I've tried going to the XHTML <bar /> a few times, but it's always closed.
Gah - I'm a numpty. Kept putting the foreignKey as the column on the table I'm joining to.
As for books/authors - I took the simple approach and gave each book one author. If a book is written by John Smith and Bob Jones, then there is a row in the author table "John Smith & Bob Jones". Makes the design easier, but it does mean if I want to find all the books by Bob Jones then I need to search for "%Bob Jones%'. But I may change that design anyway, but at least I can now do all the other foreignKey look ups.
> ...is where belongsTo is documented, you should look over that.
> But -- even though I hate to be that jerk who points out problems other > than the one you asked about -- before you get too far, the data model you > describe only lets a book have a single author. If you're storing actual > real-world books in there, you probably want to support books having > multiple authors, which means a HABTM "hasAndBelongsToMany" association. > For that you need a third table authors_books, etc as described in the > cookbook.
> Good luck
> ;Daniel
> -- > Daniel Baird > I've tried going to the XHTML <bar /> a few times, but it's always closed.
That also makes it rather difficult to list authors alphabetically.
Better to do it the right way the first time than to have to come up
with hacks later.
On Wed, Aug 1, 2012 at 4:14 PM, newt_e <new...@blueyonder.co.uk> wrote:
> Gah - I'm a numpty. Kept putting the foreignKey as the column on the table
> I'm joining to.
> As for books/authors - I took the simple approach and gave each book one
> author. If a book is written by John Smith and Bob Jones, then there is a
> row in the author table "John Smith & Bob Jones". Makes the design easier,
> but it does mean if I want to find all the books by Bob Jones then I need to
> search for "%Bob Jones%'. But I may change that design anyway, but at least
> I can now do all the other foreignKey look ups.
> Thanks,
> N.
> On Wednesday, August 1, 2012 12:10:17 AM UTC+1, Daniel Baird wrote:
>> But -- even though I hate to be that jerk who points out problems other
>> than the one you asked about -- before you get too far, the data model you
>> describe only lets a book have a single author. If you're storing actual
>> real-world books in there, you probably want to support books having
>> multiple authors, which means a HABTM "hasAndBelongsToMany" association.
>> For that you need a third table authors_books, etc as described in the
>> cookbook.
>> Good luck
>> ;Daniel
>> --
>> Daniel Baird
>> I've tried going to the XHTML <bar /> a few times, but it's always closed.
> --
> 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
