Michael Bayer ha scritto:
> youre looking for the mappers to express the relational concepts as
> fully as Tables. but thats what Tables are for, why not just use
> them ?
Main reason is select_by function, i think it's very usefull....
Another reason is because in a Big DB modeling is a good feature define
only 1 time mapper of some tables, with relationship and then use it for
all reference to it.
Otherwise using Table Obj all mapper referring to it must redefine all
times tables and relationship
I don't understand why this pythonic approach is so far from commo use
of SA. I think if i define a complex mapper for a group of tables,
relationship, primary_key, alias and so on it's a good think refer to
it and use it in all other mapper refering to it
Another little feature is the possibility to specify select_clause in a
Mapper select function.
The SA can create a perfect where_clause in composing the qry, but is i
use referenced Model we cannot select all field.
Amodel.select_by( Amodel.c.afield == x ) ----> generate "select * from
a ...." perfect.
Amodel.select_by( Bmodel.c.bfield == x ) ----> generate "select a.*
from a JOIN b on a.id = ...." perfect, but select only a field.
> SA's philosophy is very much about "dont pretend theres no
> database".
>
>
SA is an ORM and can present DB data in Object Form, so my intent is to
use all Objetcs features.
This is non a critique but a proposal...
i hope my poor english is enougth for explain it.
Tnak's
Glauco
--
+------------------------------------------------------------+
Glauco Uri - Programmatore
glauco(at)allevatori.com
Sfera Carta Software® [EMAIL PROTECTED]
Via Bazzanese,69 Casalecchio di Reno(BO) - Tel. 051591054
+------------------------------------------------------------+
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
