On 19 июн, 20:12, [EMAIL PROTECTED] wrote:
> once mapped, the link is the otherway around:
> class -> mapper -> sqltable.
> the backlink... u have to cache it yourself when u create things?
> e.g. mytablemap[tablename,schemaname]=TableClass
>
> why need that? i mean why starting from tablename?
'cause mine application is designed in such way - every record in the
database is the document with it's unique id. (additionally with
rights) there is document_types reference which shows the
document_types with its location in database - so user clicks - i want
to get the content of the object - and receives the exact content -
but in methods i define additional filters. So this would be great to
make working
so creating own tables cache... that's a solution... but I've been
thinking there is something which would help me.
Additional question (maybe of the topic of mine base question)
when I autogenerate the table from the database and then map it to the
TableClass how can I get the object from one-to-many relation??
i.e. 2 simple tables with 1 to many relation autogenerated.
table1 = Table(..., autogenerate=True)
class Table1Class(object):
pass
table2 = Table(..., autogenerate=True)
class Table2Class(object):
pass
mapper(Table1Class, table1)
mapper(Table2Class, table2)
so would be genereated there the one-to-many relation between
Table1Class and Table2Class??
If yes - how to get all subsequent records from slave (Table2Class)
table from instance of master table(Table1Class)
table1ref = Table1Class()
table2refs = table1ref.getall_table2_subsequent()
???
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
