diff test/db_test_base.py @ 2536:70ede89e8056

handle postgresql bug in SQL generation [SF#984591]
author Richard Jones <richard@users.sourceforge.net>
date Sat, 03 Jul 2004 23:05:15 +0000
parents 0a63854816ee
children 113548baeed2
line wrap: on
line diff
--- a/test/db_test_base.py	Sat Jul 03 22:46:30 2004 +0000
+++ b/test/db_test_base.py	Sat Jul 03 23:05:15 2004 +0000
@@ -15,7 +15,7 @@
 # BASIS, AND THERE IS NO OBLIGATION WHATSOEVER TO PROVIDE MAINTENANCE,
 # SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS.
 # 
-# $Id: db_test_base.py,v 1.38 2004-07-03 22:43:59 richard Exp $ 
+# $Id: db_test_base.py,v 1.39 2004-07-03 23:05:15 richard Exp $ 
 
 import unittest, os, shutil, errno, imp, sys, time, pprint
 
@@ -836,7 +836,7 @@
         iss = self.db.issue
         for issue in (
                 {'title': 'issue one', 'status': '2', 'assignedto': '1',
-                    'foo': date.Interval('1:10'), 'priority': '1',
+                    'foo': date.Interval('1:10'), 'priority': '3',
                     'deadline': date.Date('2003-01-01.00:00')},
                 {'title': 'issue two', 'status': '1', 'assignedto': '2',
                     'foo': date.Interval('1d'), 'priority': '3',
@@ -844,7 +844,7 @@
                     {'title': 'issue three', 'status': '1', 'priority': '2',
                     'nosy': ['1','2'], 'deadline': date.Date('2003-02-18')},
                 {'title': 'non four', 'status': '3',
-                    'foo': date.Interval('0:10'), 'priority': '1',
+                    'foo': date.Interval('0:10'), 'priority': '2',
                     'nosy': ['1'], 'deadline': date.Date('2004-03-08')}):
             self.db.issue.create(**issue)
         file_content = ''.join([chr(i) for i in range(255)])
@@ -893,6 +893,8 @@
         ae, filt = self.filteringSetup()
         ae(filt(None, {'nosy': '2'}, ('+','id'), (None,None)), ['3'])
         ae(filt(None, {'nosy': '-1'}, ('+','id'), (None,None)), ['1', '2'])
+        ae(filt(None, {'nosy': ['1','2']}, ('+', 'status'),
+            ('-', 'activity')), ['4', '3'])
 
     def testFilteringMany(self):
         ae, filt = self.filteringSetup()

Roundup Issue Tracker: http://roundup-tracker.org/