Hi
This is my class definition
class TaskCalendar(DeclarativeBase):
__tablename__ = 'task_calendars1'
cal_id = Column(Integer,Sequence('id_seq'), primary_key=True)
task_id = Column(Integer, ForeignKey('tasks.task_id'))
dow = Column(Integer)
month = Column(Integer)
day = Column(Integer)
hour = Column(Integer)
minute = Column(Integer)
task = relation(Task, backref=backref('calendar'))
This is what am trying to do
tasks=DBSession.query(TaskCalendar).options(eagerload('task'))
The query is as follows
SELECT task_calendars1.cal_id AS task_calendars1_cal_id,
task_calendars1.task_id AS task_calendars1_task_id,tasks_1.name AS
tasks_1_name, tasks_1.entity_id AS tasks_1_entity_id,
tasks_1.entity_name AS tasks_1_entity_name, tasks_1.context AS
tasks_1_context
FROM task_calendars1 LEFT OUTER JOIN tasks tasks_1 ON tasks_1.task_id
= task_calendars1.task_id
if i remove tasks_1.context this query works fine
context column is of pickletype datatype in class and Blob in Database
This is the error message:
ORA-00932: inconsistent datatypes: expected NUMBER got BLOB
Thankful for any suggestions
--
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.
