[sqlalchemy] Re: query stopped working in 0.3.6
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','Diabetes',
'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'}
[sqlalchemy] Re: query stopped working in 0.3.6
this is most likely a typing error and id need to see the types of
columns being used. in particular if you have any String columns
without a size, they are now interpreted as CLOBs which might be
where its tripping up.
On Mar 27, 2007, at 10:35 AM, shday wrote:
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
[sqlalchemy] Re: query stopped working in 0.3.6
Hi,
The table is reflected, with one column overridden, here:
model_table = Table('model',metadata,
Column('model_id',Numeric(precision=6,length=0),Sequence('model_seq'),
primary_key=True, nullable=False),
autoload=True)
Here is what the resulting Table object looks like:
Table('model',DynamicMetaData(),
Column('investigator_isid',OracleString(length=8),nullable=False),
Column('active',OracleNumeric(precision=1,length=0),nullable=False,default=PassiveDefault(sqlalchemy.sql._TextClause
object at 0x0193E850)),
Column('model_id',Numeric(precision=6,length=0),primary_key=True,nullable=False,
default=Sequence('model_seq',start=None,increment=None,optional=False)),
Column('model_acronym',OracleString(length=32),nullable=False),
Column('model_name',OracleString(length=256),nullable=False),
Column('therapeutic_area',OracleString(length=32)),
schema=None)
On Mar 27, 12:12 pm, Michael Bayer [EMAIL PROTECTED] wrote:
this is most likely a typing error and id need to see the types of
columns being used. in particular if you have any String columns
without a size, they are now interpreted as CLOBs which might be
where its tripping up.
On Mar 27, 2007, at 10:35 AM, shday wrote:
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
[sqlalchemy] Re: query stopped working in 0.3.6
Okay, I changed the NLS_LANG setting on the oracle client to match
that of the server, and now it works. I found out about it here:
http://www.theserverside.com/discussions/thread.tss?thread_id=14634
On Mar 27, 1:27 pm, shday [EMAIL PROTECTED] wrote:
Hi,
The table is reflected, with one column overridden, here:
model_table = Table('model',metadata,
Column('model_id',Numeric(precision=6,length=0),Sequence('model_seq'),
primary_key=True, nullable=False),
autoload=True)
Here is what the resulting Table object looks like:
Table('model',DynamicMetaData(),
Column('investigator_isid',OracleString(length=8),nullable=False),
Column('active',OracleNumeric(precision=1,length=0),nullable=False,default=PassiveDefault(sqlalchemy.sql._TextClause
object at 0x0193E850)),
Column('model_id',Numeric(precision=6,length=0),primary_key=True,nullable=False,
default=Sequence('model_seq',start=None,increment=None,optional=False)),
Column('model_acronym',OracleString(length=32),nullable=False),
Column('model_name',OracleString(length=256),nullable=False),
Column('therapeutic_area',OracleString(length=32)),
schema=None)
On Mar 27, 12:12 pm, Michael Bayer [EMAIL PROTECTED] wrote:
this is most likely a typing error and id need to see the types of
columns being used. in particular if you have any String columns
without a size, they are now interpreted as CLOBs which might be
where its tripping up.
On Mar 27, 2007, at 10:35 AM, shday wrote:
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,
[sqlalchemy] Re: query stopped working in 0.3.6
the probable change that revealed this error is that oracle in 0.3.6
will by default apply cursor.setinputsizes() to all queries, which is
necessary for CLOB/BLOB. So encoding/NLS_LANG stuff probably became
more significant once cx_oracle has less need to guess about bind
parameters.
this option can be disabled by sending auto_setinputsizes=False to
create_engine().
On Mar 27, 2007, at 2:48 PM, shday wrote:
Okay, I changed the NLS_LANG setting on the oracle client to match
that of the server, and now it works. I found out about it here:
http://www.theserverside.com/discussions/thread.tss?thread_id=14634
On Mar 27, 1:27 pm, shday [EMAIL PROTECTED] wrote:
Hi,
The table is reflected, with one column overridden, here:
model_table = Table('model',metadata,
Column('model_id',Numeric(precision=6,length=0),Sequence
('model_seq'),
primary_key=True, nullable=False),
autoload=True)
Here is what the resulting Table object looks like:
Table('model',DynamicMetaData(),
Column('investigator_isid',OracleString(length=8),nullable=False),
Column('active',OracleNumeric
(precision=1,length=0),nullable=False,default= PassiveDefault
(sqlalchemy.sql._TextClause
object at 0x0193E850)),
Column('model_id',Numeric
(precision=6,length=0),primary_key=True,nullable=F alse,
default=Sequence
('model_seq',start=None,increment=None,optional=False)),
Column('model_acronym',OracleString(length=32),nullable=False),
Column('model_name',OracleString(length=256),nullable=False),
Column('therapeutic_area',OracleString(length=32)),
schema=None)
On Mar 27, 12:12 pm, Michael Bayer [EMAIL PROTECTED] wrote:
this is most likely a typing error and id need to see the types of
columns being used. in particular if you have any String columns
without a size, they are now interpreted as CLOBs which might be
where its tripping up.
On Mar 27, 2007, at 10:35 AM, shday wrote:
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
