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
