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