old_contents: import os
  import unittest
  import pymonetdb
  
  
  MAPIPORT = int(os.environ.get('MAPIPORT', 50000))
  TSTDB = os.environ.get('TSTDB', 'demo')
  TSTHOSTNAME = os.environ.get('TSTHOSTNAME', 'localhost')
  TSTUSERNAME = os.environ.get('TSTUSERNAME', 'monetdb')
  TSTPASSWORD = os.environ.get('TSTPASSWORD', 'monetdb')
  
  
  class TestExceptions(unittest.TestCase):
      def setUp(self):
          self.con = pymonetdb.connect(database=TSTDB, port=MAPIPORT,
                                       hostname=TSTHOSTNAME,
                                       username=TSTUSERNAME,
                                       password=TSTPASSWORD)
          cursor = self.con.cursor()
          cursor.execute('create table exceptions (s VARCHAR(1000) UNIQUE)')
  
      def tearDown(self):
          self.con.rollback()
  
      def test_unique_contraint_violated(self):
          """
          M0M29!INSERT INTO: UNIQUE constraint violated
          """
          cursor = self.con.cursor()
          x = u"something"
          cursor.execute(u'insert into exceptions VALUES (%s)', (x,))
          with self.assertRaises(pymonetdb.exceptions.IntegrityError):
               cursor.execute(u'insert into exceptions VALUES (%s)', (x,))
  
      def test_unique_contraint_violated(self):
          """
          '42S02!' no such table
          """
          cursor = self.con.cursor()
  
          with self.assertRaises(pymonetdb.exceptions.OperationalError):
               cursor.execute(u'select id from thistableshouldnotexist limit 1')
  
new_contents: import os
  import unittest
  import pymonetdb
  
  
  MAPIPORT = int(os.environ.get('MAPIPORT', 50000))
  TSTDB = os.environ.get('TSTDB', 'demo')
  TSTHOSTNAME = os.environ.get('TSTHOSTNAME', 'localhost')
  TSTUSERNAME = os.environ.get('TSTUSERNAME', 'monetdb')
  TSTPASSWORD = os.environ.get('TSTPASSWORD', 'monetdb')
  
  
  class TestExceptions(unittest.TestCase):
      def setUp(self):
          self.con = pymonetdb.connect(database=TSTDB, port=MAPIPORT,
                                       hostname=TSTHOSTNAME,
                                       username=TSTUSERNAME,
                                       password=TSTPASSWORD)
          cursor = self.con.cursor()
          cursor.execute('create table exceptions (s VARCHAR(1000) UNIQUE)')
  
      def tearDown(self):
          self.con.rollback()
  
      def test_unique_contraint_violated(self):
          """
          M0M29!INSERT INTO: UNIQUE constraint violated
          """
          cursor = self.con.cursor()
          x = u"something"
          cursor.execute(u'insert into exceptions VALUES (%s)', (x,))
          with self.assertRaises(pymonetdb.exceptions.IntegrityError):
               cursor.execute(u'insert into exceptions VALUES (%s)', (x,))
  
      def test_unique_contraint_violated(self):
          """
          '42S02!' no such table
          """
          cursor = self.con.cursor()
  
          self.assertRaises(pymonetdb.exceptions.OperationalError,
                            cursor.execute,
                            u'select id from thistableshouldnotexist limit 1')
  
subject: fix python26