please use func. for database functions. http://www.sqlalchemy.org/docs/reference/sqlalchemy/expressions.html?highlight=func#sqlalchemy.sql.expression.func
On Jun 14, 2010, at 10:09 AM, dhanil anupurath wrote: > Hi > > I am using SA-oracle for my application. > I need to write an oracle query in which i need to use BITAND > oracle bitwise operator > function. > > Is SA provides this functionality? > DECODE(BITAND(task_calendars.day ,day1))) > > The SA QUERY is > > 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, tasks_1.cancellable AS tasks_1_cancellable \nFROM > task_calendars LEFT OUTER JOIN tasks tasks_1 ON tasks_1.task_id = > task_calendars.task_id > WHERE (task_calendars.dow = :dow_1 OR (task_calendars.dow & :dow_2)) >> :param_1' {'dow_2': 1, 'dow_1': 0, 'param_1': False} > > I would appreciate any help. > Thanks > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To post to this group, send email to sqlalch...@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. > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalch...@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.