ok in_ uses bind params now, see if that works.
On Dec 19, 2005, at 5:54 AM, Robert Leftwich wrote:
in_() doesn't appear to work with dates, should it? Adding the
following to testin() test/select.py from rev 713, fails with an
error as shown below:
# test dates
import datetime
entries = Table('myentries', db,
Column('myid', Integer, key = 'id'),
Column('name', String, key = 'name'),
Column('description', String, key = 'description'),
Column('entrydate', DateTime),
)
dates = [datetime.datetime(2005,12,i) for i in range(1,6)]
dateStrings = tuple([str(d) for d in dates])
self.runtest(select([entries], entries.c.entrydate.in_
(*dates)),
"SELECT myentries.myid, myentries.name, myentries.description,
myentries.entrydate FROM myentries WHERE myentries.entrydate IN %s"
%dateStrings)
======================================================================
ERROR: testin (__main__.SelectTest)
----------------------------------------------------------------------
Traceback (most recent call last):
File "/home/robert/tools/python/sqlalchemy/test/select.py", line
400, in testin
self.runtest(select([entries], entries.c.entrydate.in_(*dates)),
File "../../lib/sqlalchemy/sql.py", line 394, in in_
File "../../lib/sqlalchemy/sql.py", line 475, in __init__
File "/usr/lib/python2.4/sre.py", line 142, in sub
return _compile(pattern, 0).sub(repl, string, count)
TypeError: expected string or buffer
Robert
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through
log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD
SPLUNK!
http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
_______________________________________________
Sqlalchemy-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
_______________________________________________
Sqlalchemy-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
