Re: [SQLObject] higher-level types for attributes..

[Bud P. B. <bu...@si...>]

On 10 Apr 2003 13:32:09 -0500
Ian Bicking <ia...@co...> wrote:

> 
> Hmmm... I'm not clear here.  You mean that the fields have subfields,
> like some_table.some_point.x ?  

Yes.  Say I have the attribute "location" of type "Point" in the say
"Office" class.  A Point is basically specified by a coordinate pair
(x/y or lat/long or whatever).  Currently, I could define Point as a
subclass of SQLObject and join Point and Office--but since an office
is always in a single location, this would degenerate into 1:1
relationships that are rather inefficient...  So if one could define
1:1 relationships that cause an "inlining" of the attributes or the
related object, that would be great.

> You could add something to SQLBuilder to
> use this in queries fairly easily.  For actual retrieval, it's up to
> either some (not-yet-implemented) Constraint system to handle it, or the
> database adapter.  And the sqlRepr method I mentioned in the other
> email.

/-----------------------------------------------------------------
| Bud P. Bruegger, Ph.D. 
| Sistema (www.sistema.it)
| Via U. Bassi, 54
| 58100 Grosseto, Italy
| +39-0564-411682 (voice and fax)
\-----------------------------------------------------------------