Here is the surrounding code: def model_list(therapeutic_area='All'): if therapeutic_area == 'All': s = model_table.select(order_by=[model_table.c.model_acronym]) elif therapeutic_area == 'Other': s = model_table.select(~(model_table.c.therapeutic_area.in_('Respiratory','Diabetes', 'Inflammation','CVD')), order_by=[model_table.c.model_acronym]) else: s = model_table.select(model_table.c.therapeutic_area==therapeutic_area,order_by=[model_table.c.model_acronym]) rs = s.execute() return [(str(row['model_id']),(row['model_acronym'] +" - "+row['model_name'])[:80]) for row in rs.fetchall()]
On Mar 27, 10:29 am, "shday" <[EMAIL PROTECTED]> wrote: > I upgraded to 0.3.6 from 0.3.5 and one of my querys stopped working: > > s = > model_table.select(~(model_table.c.therapeutic_area.in_('Respiratory','DiabĀetes', > > 'Inflammation','CVD')), > order_by=[model_table.c.model_acronym]) > > All my other query still work fine. Although this is the only one > using in_() and "~". > > The funny thing is that the created sql appears to be exactly the same > as before. Here is the error: > > 2007-03-26 15:11:20,851 INFO sqlalchemy.engine.base.Engine.0x..d0 > SELECT model.i > nvestigator_isid, model.active, model.model_id, model.model_acronym, > model.model > _name, model.therapeutic_area > FROM model > WHERE model.therapeutic_area NOT IN > (:model_therapeutic_area, :model_therapeutic > _ar_1, :model_therapeutic_ar_2, :model_therapeutic_ar_3) ORDER BY > model.model_ac > ronym > 2007-03-26 15:11:20,851 sqlalchemy.engine.base.Engine.0x..d0 INFO > SELECT model.i > nvestigator_isid, model.active, model.model_id, model.model_acronym, > model.model > _name, model.therapeutic_area > FROM model > WHERE model.therapeutic_area NOT IN > (:model_therapeutic_area, :model_therapeutic > _ar_1, :model_therapeutic_ar_2, :model_therapeutic_ar_3) ORDER BY > model.model_ac > ronym > 2007-03-26 15:11:20,861 INFO sqlalchemy.engine.base.Engine.0x..d0 > {'model_therap > eutic_area': 'Respiratory', 'model_therapeutic_ar_3': 'CVD', > 'model_therapeutic_ > ar_2': 'Inflammation', 'model_therapeutic_ar_1': 'Diabetes'} > 2007-03-26 15:11:20,861 sqlalchemy.engine.base.Engine.0x..d0 INFO > {'model_therap > eutic_area': 'Respiratory', 'model_therapeutic_ar_3': 'CVD', > 'model_therapeutic_ > ar_2': 'Inflammation', 'model_therapeutic_ar_1': 'Diabetes'} > 2007-03-26 15:11:20,861 INFO sqlalchemy.engine.base.Engine.0x..d0 > ROLLBACK > 2007-03-26 15:11:20,861 sqlalchemy.engine.base.Engine.0x..d0 INFO > ROLLBACK > Traceback (most recent call last): > File "C:\Documents and Settings\Daystev\Desktop\srt-trunk\srt-project > \start-sr > t.py", line 23, in ? > from srt.controllers import Root > File "C:\Documents and Settings\Daystev\Desktop\srt-trunk\srt-project > \srt\cont > rollers.py", line 9, in ? > model_list = [('Respiratory',[('','Please select a model')] > +dbmodel.model_li > st('Respiratory')), > File "C:\Documents and Settings\Daystev\Desktop\srt-trunk\srt-project > \srt\mode > l.py", line 158, in model_list > rs = s.execute() > File "c:\python24\lib\site-packages\sqlalchemy-0.3.6-py2.4.egg > \sqlalchemy\sql. > py", line 776, in execute > return self.compile(engine=self.engine, > parameters=compile_params).execute(* > multiparams, **params) > File "c:\python24\lib\site-packages\sqlalchemy-0.3.6-py2.4.egg > \sqlalchemy\sql. > py", line 669, in execute > return e.execute_compiled(self, *multiparams, **params) > File "c:\python24\lib\site-packages\sqlalchemy-0.3.6-py2.4.egg > \sqlalchemy\engi > ne\base.py", line 726, in execute_compiled > return connection.execute_compiled(compiled, *multiparams, > **params) > File "c:\python24\lib\site-packages\sqlalchemy-0.3.6-py2.4.egg > \sqlalchemy\engi > ne\base.py", line 503, in execute_compiled > proxy(str(compiled), parameters) > File "c:\python24\lib\site-packages\sqlalchemy-0.3.6-py2.4.egg > \sqlalchemy\engi > ne\base.py", line 499, in proxy > self._execute_raw(statement, parameters, cursor=cursor, > context=context) > File "c:\python24\lib\site-packages\sqlalchemy-0.3.6-py2.4.egg > \sqlalchemy\engi > ne\base.py", line 547, in _execute_raw > self._execute(cursor, statement, parameters, context=context) > File "c:\python24\lib\site-packages\sqlalchemy-0.3.6-py2.4.egg > \sqlalchemy\engi > ne\base.py", line 566, in _execute > raise exceptions.SQLError(statement, parameters, e) > sqlalchemy.exceptions.SQLError: (DatabaseError) ORA-01460: > unimplemented or unre > asonable conversion requested > 'SELECT model.investigator_isid, model.active, model.model_id, > model.model_acro > nym, model.model_name, model.therapeutic_area \nFROM model \nWHERE > model.therape > utic_area NOT IN > (:model_therapeutic_area, :model_therapeutic_ar_1, :model_thera > peutic_ar_2, :model_therapeutic_ar_3) ORDER BY > model.model_acronym' {'model_ther > apeutic_area': 'Respiratory', 'model_therapeutic_ar_3': 'CVD', > 'model_therapeuti > c_ar_2': 'Inflammation', 'model_therapeutic_ar_1': 'Diabetes'} --~--~---------~--~----~------------~-------~--~----~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---