join keys redux

Cyrus Harmon <ch-clsql-dl6SmSK5uza1Z/[email protected]>
Newsgroups gmane.lisp.clsql.devel
Message-ID <[email protected]>
Ok, so upon further experimentation, it looks as if :home-key and 
:foreign-key need to be atoms. The LW def-view-class docs indicate that 
these can in fact be lists, so I'm assuming that, as far as API 
compatibility with CommonSQL goes, this is a bug in CLSQL. I'm open to 
spending some time trying to fix this, if that is deemed the right 
thing to do. The part of the LW spec that I really want, at the moment, 
is the ability to not just specify a slot-name, but also a value:

> The syntax for :home-key  and :foreign-key  means that an object from 
> a join class will only be included in the join slot if the values from 
> the home-key are equal  to the values in the :foreign-key , in order. 
> These values are calculated as follows: if the element in the list is 
> a symbol it is taken to be a slot name and the value of the slot is 
> used, otherwise the element is taken to be the value

doing a join on multiple columns with arbitrary values, not just slot 
names, thrown in to the mix is what I'm looking for. Thoughts? Any 
problem with trying to make CLSQL do this?

Thanks,

Cyrus
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.