Mercurial > p > roundup > code
changeset 1550:905f92b97d4e maint-0.5
backport of mail address case problem from HEAD
| author | Richard Jones <richard@users.sourceforge.net> |
|---|---|
| date | Mon, 24 Mar 2003 04:53:15 +0000 |
| parents | a61ca144d3a4 |
| children | df49c7d31073 |
| files | CHANGES.txt roundup/backends/rdbms_common.py test/test_mailgw.py |
| diffstat | 3 files changed, 6 insertions(+), 5 deletions(-) [+] |
line wrap: on
line diff
--- a/CHANGES.txt Fri Mar 21 21:43:04 2003 +0000 +++ b/CHANGES.txt Mon Mar 24 04:53:15 2003 +0000 @@ -8,6 +8,7 @@ - required String properties not being flagged (thanks Ajit George) - only look for CSV files when importing (thanks Dan Grassi) - can now unset values in CSV editing (sf bug 704788) +- fixed rdbms email address lookup (case insensitivity) 2003-02-27 0.5.6
--- a/roundup/backends/rdbms_common.py Fri Mar 21 21:43:04 2003 +0000 +++ b/roundup/backends/rdbms_common.py Mon Mar 24 04:53:15 2003 +0000 @@ -1,4 +1,4 @@ -# $Id: rdbms_common.py,v 1.27.2.7 2003-03-14 02:52:03 richard Exp $ +# $Id: rdbms_common.py,v 1.27.2.8 2003-03-24 04:53:14 richard Exp $ ''' Relational database (SQL) backend common code. Basics: @@ -1666,7 +1666,7 @@ args.append(requirements[propname].lower()) # generate the where clause - s = ' and '.join(['_%s=%s'%(col, self.db.arg) for col in where]) + s = ' and '.join(['lower(_%s)=%s'%(col, self.db.arg) for col in where]) sql = 'select id from _%s where %s'%(self.classname, s) self.db.sql(sql, tuple(args)) l = [x[0] for x in self.db.sql_fetchall()]
--- a/test/test_mailgw.py Fri Mar 21 21:43:04 2003 +0000 +++ b/test/test_mailgw.py Mon Mar 24 04:53:15 2003 +0000 @@ -8,7 +8,7 @@ # but WITHOUT ANY WARRANTY; without even the implied warranty of # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. # -# $Id: test_mailgw.py,v 1.37.2.1 2003-02-06 05:44:49 richard Exp $ +# $Id: test_mailgw.py,v 1.37.2.2 2003-03-24 04:53:15 richard Exp $ import unittest, cStringIO, tempfile, os, shutil, errno, imp, sys, difflib @@ -122,7 +122,7 @@ self.instance.config.ADD_AUTHOR_TO_NOSY = 'yes' message = cStringIO.StringIO('''Content-Type: text/plain; charset="iso-8859-1" -From: Chef <chef@bork.bork.bork> +From: Chef <Chef@bork.bork.bork> To: issue_tracker@your.tracker.email.domain.example Cc: richard@test Message-Id: <dummy_test_message_id> @@ -143,7 +143,7 @@ def testAlternateAddress(self): message = cStringIO.StringIO('''Content-Type: text/plain; charset="iso-8859-1" -From: John Doe <john.doe@test> +From: john doe <John.Doe@test> To: issue_tracker@your.tracker.email.domain.example Message-Id: <dummy_test_message_id> Subject: [issue] Testing...