Re: Fixes and questions

Martin Simmons <[email protected]> writes:

>>>>>> On Fri, 7 Nov 2003 12:11:54 +0100, [email protected] said:
>  
>   rm> On Fri, Nov 07, 2003 at 10:59:11AM +0000, Martin Simmons wrote:
>   >> >>>>> On 05 Nov 2003 17:20:43 +0800, Robert Marlow <[email protected]> said:
>   >> 
>   Robert> Also, I like this idea of the object-relational mapping. However, is
>   Robert> there any provided way to extract relational data from a database and
>   Robert> place it into the object system? That'd be real handy...
>   >> 
>   >> Forgive my ignorance of UncommonSQL, but in CommonSQL the object-relational
>   >> mapping does just that.  After using DEF-VIEW-CLASS to define a Lisp class for
>   >> some table, calling SELECT will create an object for each row in table,
>   >> containing the data.
>
>   rm> Hmm, my initial understanding of the OP was that he was looking or
>   rm> a way to create a mapping between objects<->reldata for an existing 
>   rm> relation.
>
> But that *is* what CommonSQL's DEF-VIEW-CLASS does!  E.g.

I believe what Robert is looking for is something that will inspect a
relational database and generate the needed def-view-class statements
automagically.  There is not anything to do that in USql.  There is an
interface for inspecting tables and their attributes and their types,
which would be the information one would need to generate these in
both usql and csql.


-- 
Craig Brozefsky <[email protected]>	             Senior Programmer
onShore Development                       http://www.onshore-devel.com
Free Common Lisp Software      http://alpha.onshored.com/lisp-software