first attempt, not quite there
I am using ORM classes with declarative base, and meta.reflact()
>>> print join(SAPFEvent,SAEvent)
bt_pfevents JOIN bt_cevents ON bt_cevents."key" =
bt_pfevents.event_key
>>> print join(SAInsResp,SAPFEvent)
bt_insurance_responses JOIN bt_pfevents ON bt_pfevents."key" =
bt_insurance_responses.pfevent_key
but
print join( SAInsResp, SAPFEvent, SAEvent )
Traceback (most recent call last):
File "<input>", line 1, in <module>
File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.5.5-py2.5.egg/
sqlalchemy/sql/expression.py", line 1185, in __str__
return unicode(self.compile()).encode('ascii', 'backslashreplace')
File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.5.5-py2.5.egg/
sqlalchemy/sql/expression.py", line 1181, in compile
compiler.compile()
File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.5.5-py2.5.egg/
sqlalchemy/sql/compiler.py", line 214, in compile
self.string = self.process(self.statement)
File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.5.5-py2.5.egg/
sqlalchemy/sql/compiler.py", line 217, in process
return obj._compiler_dispatch(self, **kwargs)
File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.5.5-py2.5.egg/
sqlalchemy/sql/visitors.py", line 50, in _compiler_dispatch
return getter(visitor)(self, **kw)
File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.5.5-py2.5.egg/
sqlalchemy/sql/compiler.py", line 624, in visit_join
self.process(join.right, asfrom=True) + " ON " + self.process
(join.onclause))
File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.5.5-py2.5.egg/
sqlalchemy/sql/compiler.py", line 217, in process
return obj._compiler_dispatch(self, **kwargs)
AttributeError: type object 'SAEvent' has no attribute
'_compiler_dispatch'
??
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
