Re: SETFable join slots?

Bill Atkins wrote:
> What kinds of problems have people been having with the object- 
> relational mapping?  I'm planning on writing production code with  
> these mappings and while I haven't noticed any problems yet, it would  
> be good to know what to expect.  :-)

I'm not sure of the particulars, but there have been a few messages on
clsql-devel, mostly about 6 months ago. You can check the archive.

> One behavior that seems a little dangerous is this: if the user  
> doesn't specify that one field is a primary key in the DEF-VIEW- 
> CLASS, then calling (update-records-from-instance foo) will set the  
> columns in *all* rows of that table to the appropriate value in foo.

Yeah, that's not what people expect. Another reminder of the
discordance between lisp objects and relational tables. And, a
reminder of why I'm not much of a fan of the object-oriented aspect of
CLSQL. Probably a warning or an error would be appropriate for a
view-class without a primary key.

-- 
Kevin Rosenberg
[email protected]