← Back to branch summary

~geertjmvdk/+junk/myconnpy-buildbot

« back to all changes in this revision

Viewing changes to py3k/tests/test_cursor.py

  • Committer: Geert Vanderkelen
  • Date: 2010-01-25 17:15:07 UTC
  • Revision ID: geert.vanderkelen@sun.com-20100125171507-7xdivm5d4lwu1luw
Adding MySQL server errors and better exceptions (part 1)

* We try to raise appropriate exceptions based on the server errno we get
using the errors.raise_mysql_error()-method.
* Adding server side errno: this will take time to sort out (lots of them!)
* Updating test cases with new exceptions being thrown.

Show diffs side-by-side

added added

removed removed

Lines of Context:
py3k/tests/test_cursor.py
428
428
        self.db.set_warnings(fetch=True)
429
429
        self.c = self.db.cursor()
430
430
        
431
 
        self.assertRaises(errors.InterfaceError,self.c.execute,
 
431
        self.assertRaises(errors.ProgrammingError,self.c.execute,
432
432
            'SELECT %s,%s,%s', ('foo','bar',))
433
 
        self.assertRaises(errors.InterfaceError,self.c.execute,
 
433
        self.assertRaises(errors.ProgrammingError,self.c.execute,
434
434
            'SELECT %s,%s', ('foo','bar','foobar'))
435
435
        
436
436
        self.c.execute("SELECT 'a' + 'b'")
477
477
        self.c = self.db.cursor()
478
478
        self.assertRaises(errors.InterfaceError,self.c.executemany,
479
479
            'foo',None)
480
 
        self.assertRaises(errors.InterfaceError,self.c.executemany,
 
480
        self.assertRaises(errors.ProgrammingError,self.c.executemany,
481
481
            'foo','foo')
482
482
        self.assertEqual(0,self.c.executemany('foo',[]))
483
 
        self.assertRaises(errors.InterfaceError,self.c.executemany,
 
483
        self.assertRaises(errors.ProgrammingError,self.c.executemany,
484
484
            'foo',['foo'])
485
 
        self.assertRaises(errors.InterfaceError,self.c.executemany,
 
485
        self.assertRaises(errors.ProgrammingError,self.c.executemany,
486
486
            'SELECT %s', [('foo',),'foo'])
487
487
 
488
488
        self.c.executemany("SELECT SHA1(%s)", [('foo',),('bar',)])
755
755
        self.c = self.db.cursor()
756
756
        self.assertRaises(errors.InterfaceError,self.c.executemany,
757
757
            'foo',None)
758
 
        self.assertRaises(errors.InterfaceError,self.c.executemany,
 
758
        self.assertRaises(errors.ProgrammingError,self.c.executemany,
759
759
            'foo','foo')
760
760
        self.assertEqual(0,self.c.executemany('foo',[]))
761
 
        self.assertRaises(errors.InterfaceError,self.c.executemany,
 
761
        self.assertRaises(errors.ProgrammingError,self.c.executemany,
762
762
            'foo',['foo'])
763
 
        self.assertRaises(errors.InterfaceError,self.c.executemany,
 
763
        self.assertRaises(errors.ProgrammingError,self.c.executemany,
764
764
            'SELECT %s', [('foo',),'foo'])
765
765
 
766
766
        self.c.executemany("SELECT SHA1(%s)", [('foo',),('bar',),('foobar',)])