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 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'}- Hide
> >> quoted text -
>
> - Show quoted text -
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
