[CDBI] Simple join
peterspeltz at gmail.com
Fri Dec 30 20:13:49 GMT 2005
On 12/30/05, Jon Molin <jon.molin at gmail.com> wrote:
> On 12/30/05, Peter Speltz <peterspeltz at gmail.com> wrote:
> > On 12/29/05, Jon Molin <jon.molin at gmail.com> wrote:
> > > Hi list,
> > >
> > > I've just started looking at Class:DBI after only using DBI directly
> > > own written sql. I've read through the beginners guide and there's one
> > > I wonder about:
> > >
> > > In the search_like example:
> > > my @cd = Music::CD->search_like(title => 'Hits%', artist =>
> > >
> > > It searches for "cd.title like 'Hits%' or artist.name like 'Varios%'"?
> > > can't really understand how to make a relationship that makes such a
> > > I need one of them with a similar db but can't find examples except this
> > > the documentation.
> > Why did you pick the 'name' column from artist? I think artist is a
> > field in CD. The above searches CD "WHERE cd.artist LIKE 'Various%'
> > AND cd.title LIKE 'Hits%'. If it does as you thought that would
> > be pretty magical and downright amazing as how would it know to look
> > in artist.name or artist.id or whatever. I guess it could look in all
> > fields of artist however I think the search method is intended to be
> > more exact than that. At least you tell it exactly what fields to
> > search on.
> Yes I know it'd be magical if it was the artist.name field it was looking
> in, but looking at the table def cd has no text field which would match
> 'Various%' and the only text field in Artist is name, that's why I assumed
> that's the field they are using.
> > From right above your example in the docs it says ;
> > "This is a simple search for all objects where the columns specified
> > are like the values specified."
> Yes I know of that and it confuses me :) There is no column artist in the
> database the examples are using. I guess this example isn't at all related
> to the database.
Ahh, so you were paying to close attention . I did not mean to accuse
you of the opposite.
> > I'm glad to see I am not the only one who misses things right on the
> > screen in front of them Today was one of those days for me where I
> > swore I read something one way but it turned out I did not. It cost me
> > several hours of messing around. Finally someone else had a look and
> > saw my typo right away. I'm going to increase the size of my text on
> > my screen :)
> I know that feeling :)
Thanks for sympathizing. I feel better.
> > Oh yeah. Check out Class;;DBI::Sweet for joins and search functionality .
Come to think of it , it would be pretty cool to have it Magical like
you were thinking. Maybe it would search artist table where the
stringified version of of the object was like 'Various'. I bet Sweet
does something like this. I may try it soon.
More information about the ClassDBI