thanks for your previous post, I've found the mapper in MyDeclarativeTable.__mapper__
On Sat, Dec 25, 2010 at 10:05 PM, Viktor Nagy <[email protected]>wrote: > On Sat, Dec 25, 2010 at 6:59 PM, Michael Bayer > <[email protected]>wrote: > >> >> On Dec 25, 2010, at 11:02 AM, Viktor Nagy wrote: >> >> > hi, >> > >> > I have function defined in one of my postgresql schemas, and my Session >> is bound to tables in both schemas. How can I run in this case a simple >> function call like the following: >> > >> > select public."fnPunctajAngajatPeZI"(23, cast(now() as timestamp)); >> > >> > I've tried session.execute, but - as the docs state - a mapper should be >> specified. What does this mean in my case? >> >> The session would like to know which engine it should be using, if it >> isn't just using session.bind. So you'd pass a mapper or SQL clause that >> would point it to one engine or the other. >> >> We'll be adding "bind" to session.execute() and session.connection() soon >> so that you can just pass the actual engine you'd like to use. >> > > sorry for my stupid question, but how can I get a mapper or an SQL clause > that points to an engine? I have declaratively defined tables, and as this > is a function call, no table could be mapped to its results. > > >> >> -- >> >> 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]<sqlalchemy%[email protected]> >> . >> For more options, visit this group at >> http://groups.google.com/group/sqlalchemy?hl=en. >> >> > > > -- > ToolPart Team Ltd > 6725 Szeged, Boldogasszony sgt. 65. > Info: +36 30 430 4971 > Tel.: +36 62 469 321 > Fax: +36 62 426 738 > E-mail: [email protected] > Web: www.toolpart.hu > > -- ToolPart Team Ltd 6725 Szeged, Boldogasszony sgt. 65. Info: +36 30 430 4971 Tel.: +36 62 469 321 Fax: +36 62 426 738 E-mail: [email protected] Web: www.toolpart.hu -- 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.
