text: import unittest
  
  import programytest.storage.engines as Engines
  from programy.storage.stores.sql.config import SQLStorageConfiguration
  from programy.storage.stores.sql.engine import SQLStorageEngine
  from programy.storage.stores.sql.store.lookups import SQLPerson2Store
  from programytest.storage.asserts.store.assert_person2s import Person2sStoreAsserts
  
  
  class SQLPerson2StoreTests(Person2sStoreAsserts):
  
      @unittest.skipIf(Engines.sql is False, Engines.sql_disabled)
      def test_initialise(self):
          config = SQLStorageConfiguration()
          engine = SQLStorageEngine(config)
          engine.initialise()
          store = SQLPerson2Store(engine)
          self.assertEqual(store.storage_engine, engine)
  
      @unittest.skipIf(Engines.sql is False, Engines.sql_disabled)
      def test_lookup_storage(self):
          config = SQLStorageConfiguration()
          engine = SQLStorageEngine(config)
          engine.initialise()
          store = SQLPerson2Store(engine)
  
          self.assert_lookup_storage(store)
  
      @unittest.skipIf(Engines.sql is False, Engines.sql_disabled)
      def test_upload_from_text(self):
          config = SQLStorageConfiguration()
          engine = SQLStorageEngine(config)
          engine.initialise()
          store = SQLPerson2Store(engine)
  
          self.assert_upload_from_text(store)
  
      @unittest.skipIf(Engines.sql is False, Engines.sql_disabled)
      def test_upload_from_text_file(self):
          config = SQLStorageConfiguration()
          engine = SQLStorageEngine(config)
          engine.initialise()
          store = SQLPerson2Store(engine)
  
          self.assert_upload_from_text_file(store)
  
      @unittest.skipIf(Engines.sql is False, Engines.sql_disabled)
      def test_upload_csv_file(self):
          config = SQLStorageConfiguration()
          engine = SQLStorageEngine(config)
          engine.initialise()
          store = SQLPerson2Store(engine)
  
          self.assert_upload_csv_file(store)
  