old_contents: import pickle
  from sqlobject import *
  from sqlobject.tests.dbtest import *
  
  ########################################
  ## Pickle instances
  ########################################
  
  class TestPickle(SQLObject):
      question = StringCol()
      answer = IntCol()
  
  test_question = 'The Ulimate Question of Life, the Universe and Everything'
  test_answer = 42
  
  def test_pickleCol():
      setupClass(TestPickle)
      connection = TestPickle._connection
      test = TestPickle(question=test_question, answer=test_answer)
  
      pickle_data = pickle.dumps(test, pickle.HIGHEST_PROTOCOL)
      connection.cache.clear()
      test = pickle.loads(pickle_data)
      test2 = connection.cache.tryGet(test.id, TestPickle)
  
      assert test2 is test
      assert test.question == test_question
      assert test.answer == test_answer
  
      if (connection.dbName == 'sqlite') and connection._memory:
          return # The following test requires a different connection
  
      test = TestPickle.get(test.id,
          connection=getConnection(registry='')) # to make a different DB URI
                                                 # and open another connection
      raises(pickle.PicklingError, pickle.dumps, test, pickle.HIGHEST_PROTOCOL)
  
new_contents: import pickle
  from sqlobject import *
  from sqlobject.tests.dbtest import *
  
  ########################################
  ## Pickle instances
  ########################################
  
  class TestPickle(SQLObject):
      question = StringCol()
      answer = IntCol()
  
  test_question = 'The Ulimate Question of Life, the Universe and Everything'
  test_answer = 42
  
  def test_pickleCol():
      setupClass(TestPickle)
      connection = TestPickle._connection
      test = TestPickle(question=test_question, answer=test_answer)
  
      pickle_data = pickle.dumps(test, pickle.HIGHEST_PROTOCOL)
      connection.cache.clear()
      test = pickle.loads(pickle_data)
      test2 = connection.cache.tryGet(test.id, TestPickle)
  
      assert test2 is test
      assert test.question == test_question
      assert test.answer == test_answer
  
      if (connection.dbName == 'sqlite') and connection._memory:
          return # The following test requires a different connection
  
      test = TestPickle.get(
          test.id,
          # make a different DB URI and open another connection
          connection=getConnection(registry=''))
      raises(pickle.PicklingError, pickle.dumps, test, pickle.HIGHEST_PROTOCOL)
  
subject: Fix flake8 E113 unexpected indentation