Hi
SORRY for the delay to reply.
Here is what my definitions.
These are my class and table definitions:
class Task(DeclarativeBase):
task_id = Column(Integer,Sequence('id_
seq'), primary_key=True)
task_type = Column(Unicode(50), default=to_unicode('Task'))
name = Column(Unicode(256))
entity_id = Column(Unicode(256))
entity_name = Column(Unicode(50))
context = Column(PickleType)
params = Column(PickleType)
kw_params = Column(PickleType)
processors = Column(ImmutablePickleType)
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')
_tablename_="tasks"
TASK_ID Number
TASK_TYPE Varchar2
NAME Varchar2
ENTITY_ID Varchar2
ENTITY_NAME Varchar2
CONTEXT Blob
PARAMS Blob
KW_PARAMS Blob
PROCESSORS Blob
task = relation(Task, backref=backref('calendar'))
This is the query what am trying to do.
tasks=DBSession..query(TaskCalendar).options(eagerload('task')).\
filter((TaskCalendar.dow == 0) |\
TaskCalendar.dow.op('&')(1 << now[6]) > 0)
(3)SELECT task_calendars.cal_id AS task_calendars_cal_id,
task_calendars.task_id AS task_calendars_task_id, task_calendars.dow AS
task_calendars_dow, task_calendars.month AS task_calendars_month,
task_calendars.day AS task_calendars_day, task_calendars.hour AS
task_calendars_hour, task_calendars.minute AS task_calendars_minute,
tasks_1.task_id AS tasks_1_task_id, tasks_1.task_type AS tasks_1_task_type,
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, tasks_1.params AS tasks_1_params, tasks_1.kw_params AS
tasks_1_kw_params, tasks_1.processors AS tasks_1_processors,
tasks_1.user_name AS tasks_1_user_name, tasks_1.submitted_on AS
tasks_1_submitted_on, tasks_1.repeating AS tasks_1_repeating
FROM task_calendars LEFT OUTER JOIN tasks tasks_1 ON tasks_1.task_id =
task_calendars.task_id
I have the Blob error with thease....
ORA-00932: inconsistent datatypes: expected NUMBER got BLOB
HELP ME TO FIX THESE PROBLEM
THANKS
--
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.
