old_contents: from unittest import TestCase
  
  from pastycake.sqlite_backend import SqliteBackend
  
  
  class TestSqliteBackend(TestCase):
      def setUp(self):
          self.db = SqliteBackend(':memory:')
  
      def test_connected(self):
          self.assertFalse(self.db.connected())
  
      def test_connect(self):
          self.assertFalse(self.db.connected())
          self.db.connect()
          self.assertTrue(self.db.connected())
  
      def test_already_visited_url(self):
          self.db.connect()
          self.assertTrue(self.db.connected())
  
          self.assertFalse(self.db.already_visited_url('abc'))
  
      def test_save_url(self):
          self.db.connect()
          self.assertTrue(self.db.connected())
  
          self.db.save_url('abc', [('\d+', '123'), ])
          self.assertTrue(self.db.already_visited_url('abc'))
  
      def test_keywords(self):
          self.db.connect()
          self.db.enable_keyword('foobar')
          self.db.disable_keyword('zoo')
          self.assertEqual([u'foobar', u'zoo'],
                           self.db.available_keywords)
          self.assertEqual([u'foobar'], self.db.current_keywords)
          self.assertEqual(self.db.enabled_keywords, self.db.current_keywords)
          self.db.enable_keyword('zoo')
          self.db.disable_keyword('foobar')
          self.assertEqual([u'zoo'], self.db.enabled_keywords)
  
new_contents: from unittest import TestCase
  
  from pastycake.sqlite_backend import SqliteBackend
  
  
  class TestSqliteBackend(TestCase):
      def setUp(self):
          self.db = SqliteBackend(':memory:')
  
      def test_connected(self):
          self.assertFalse(self.db.connected())
  
      def test_connect(self):
          self.assertFalse(self.db.connected())
          self.db.connect()
          self.assertTrue(self.db.connected())
  
      def test_already_visited_url(self):
          self.db.connect()
          self.assertTrue(self.db.connected())
  
          self.assertFalse(self.db.already_visited_url('abc'))
  
      def test_save_url(self):
          self.db.connect()
          self.assertTrue(self.db.connected())
  
          self.db.save_url('abc', [('\d+', '123'), ])
          self.assertTrue(self.db.already_visited_url('abc'))
  
      def test_keywords(self):
          self.db.connect()
          self.db.enable_keyword('foobar')
          self.db.disable_keyword('zoo')
          self.assertEqual(['foobar', 'zoo'],
                           self.db.available_keywords)
          self.assertEqual(['foobar'], self.db.current_keywords)
          self.assertEqual(self.db.enabled_keywords, self.db.current_keywords)
          self.db.enable_keyword('zoo')
          self.db.disable_keyword('foobar')
          self.assertEqual(['zoo'], self.db.enabled_keywords)
  
subject: make the keyword reload testcase python 3 compatible