Exemple #1
0
class SQLAlchemyDriverTestCase(base.TestCase):
    def setUp(self):
        super(SQLAlchemyDriverTestCase, self).setUp()

        self.driver = SQLAlchemyDriver()
        self.store = TemplateStore(self.driver)

    @patch('tuskar.storage.drivers.sqlalchemy.SQLAlchemyDriver._generate_uuid')
    def test_create(self, mock_uuid):

        # Setup
        expected_uuid = 'b4b85dc2-0b0a-48ed-a56c-e4d582fd1473'
        mock_uuid.return_value = expected_uuid

        # Test
        result = self.driver.create(self.store, "swift.yaml", "YAML")

        # Verify
        self.assertEqual(result.uuid, expected_uuid)
        self.assertEqual(result.version, 1)
        self.assertEqual(type(result.created_at), datetime)
        self.assertEqual(result.updated_at, None)

    @patch('tuskar.storage.drivers.sqlalchemy.SQLAlchemyDriver._generate_uuid')
    def test_create_no_versioning(self, mock_uuid):

        # Setup
        store = DeploymentPlanStore(self.driver)
        expected_uuid = 'b4b85dc2-0b0a-48ed-a56c-e4d582fd1473'
        mock_uuid.return_value = expected_uuid

        # Test
        result = self.driver.create(store, "swift.yaml", "YAML")

        # Verify
        self.assertEqual(result.uuid, expected_uuid)
        self.assertEqual(result.version, None)

    @patch('tuskar.storage.drivers.sqlalchemy.SQLAlchemyDriver._generate_uuid')
    def test_retrieve(self, mock_uuid):

        # Setup
        expected_uuid = 'b4b85dc2-0b0a-48ed-a56c-e4d582fd1473'
        expected_name = "swift.yaml"
        expected_contents = "YAML"
        mock_uuid.return_value = expected_uuid
        self.driver.create(self.store, expected_name, expected_contents)

        # Test
        result = self.driver.retrieve(self.store, expected_uuid)

        # Verify
        self.assertEqual(result.uuid, expected_uuid)
        self.assertEqual(result.name, expected_name)
        self.assertEqual(result.contents, expected_contents)

    def test_retrieve_invalid(self):

        # Setup
        retrieve_call = partial(self.driver.retrieve, self.store, "uuid")

        # Test & Verify
        self.assertRaises(UnknownUUID, retrieve_call)

    def test_update(self):

        # Setup
        expected_name = "swift.yaml"
        original_contents = "YAML"
        created = self.driver.create(self.store, expected_name,
                                     original_contents)

        # Test
        new_contents = "YAML2"
        updated = self.driver.update(self.store, created.uuid, new_contents)

        # Verify
        retrieved = self.driver.retrieve(self.store, created.uuid)
        self.assertEqual(retrieved.uuid, created.uuid)
        self.assertEqual(retrieved.name, expected_name)
        self.assertEqual(type(created.created_at), datetime)
        self.assertEqual(created.updated_at, None)

        # Original and retrieved have not been updated
        self.assertEqual(retrieved.contents, original_contents)
        self.assertEqual(created.version, 1)
        self.assertEqual(retrieved.version, 1)

        # Updated has a new version, and new contents
        self.assertEqual(updated.contents, new_contents)
        self.assertEqual(updated.version, 2)
        self.assertEqual(type(updated.created_at), datetime)
        self.assertEqual(updated.updated_at, None)

    def test_update_no_versioning(self):

        # Setup
        store = DeploymentPlanStore(self.driver)
        expected_name = "swift.yaml"
        original_contents = "YAML"
        created = self.driver.create(store, expected_name, original_contents)

        # Test
        new_contents = "YAML2"
        updated = self.driver.update(store, created.uuid, new_contents)

        # Verify
        self.assertEqual(updated.uuid, created.uuid)
        self.assertEqual(updated.name, expected_name)
        self.assertEqual("YAML2", updated.contents)
        self.assertEqual(updated.version, None)

        self.assertEqual(type(created.created_at), datetime)
        self.assertEqual(created.updated_at, None)
        self.assertEqual(type(updated.created_at), datetime)
        self.assertEqual(type(updated.updated_at), datetime)

    def test_update_invalid_uuid(self):

        # Setup
        update_call = partial(self.driver.update, self.store, "uuid", "YAML2")

        # Test & Verify
        self.assertRaises(UnknownUUID, update_call)

    @patch('tuskar.storage.drivers.sqlalchemy.SQLAlchemyDriver._generate_uuid')
    def test_delete(self, mock_uuid):

        # Setup
        expected_uuid = 'b4b85dc2-0b0a-48ed-a56c-e4d582fd1473'
        expected_name = "swift.yaml"
        contents = "YAML"
        mock_uuid.return_value = expected_uuid
        self.driver.create(self.store, expected_name, contents)

        # Test
        result = self.driver.delete(self.store, expected_uuid)

        # Verify
        self.assertEqual(None, result)
        retrieve_call = partial(self.driver.retrieve, self.store,
                                expected_uuid)
        self.assertRaises(UnknownUUID, retrieve_call)

    def test_delete_invalid(self):
        self.assertRaises(UnknownUUID, self.driver.delete, self.store, "uuid")

    def test_list(self):

        name = "swift.yaml"
        template = self.driver.create(self.store, name, "YAML1")

        self.assertEqual(1, len(self.driver.list(self.store)))

        self.driver.update(self.store, template.uuid, "YAML2")

        self.assertEqual(2, len(self.driver.list(self.store)))

    def test_list_only_latest(self):

        # setup
        name = "swift.yaml"
        template = self.driver.create(self.store, name, "YAML1")
        updated = self.driver.update(self.store, template.uuid, "YAML2")

        # test
        listed = self.driver.list(self.store, only_latest=True)

        # verify
        self.assertEqual(1, len(listed))
        self.assertEqual([
            updated.uuid,
        ], [t.uuid for t in listed])

    def test_list_only_latest_multi(self):

        # setup
        name = "swift.yaml"
        template1 = self.driver.create(self.store, name, "YAML1")
        template1 = self.driver.update(self.store, template1.uuid, "YAML2")
        template2 = self.driver.create(self.store, "other", "YAML1")

        # test
        listed = self.driver.list(self.store, only_latest=True)

        # verify
        self.assertEqual(2, len(listed))
        self.assertEqual(set([template1.uuid, template2.uuid]),
                         set(t.uuid for t in listed))

    def test_retrieve_by_name(self):

        # Setup
        create_result = self.driver.create(self.store, "name", "YAML")
        self.driver.update(self.store, create_result.uuid, "YAML2")

        # Test
        retrieved = self.driver.retrieve_by_name(self.store, "name")

        # Verify
        self.assertNotEqual(create_result.uuid, retrieved.uuid)
        self.assertEqual(retrieved.contents, "YAML2")
        self.assertEqual(retrieved.version, 2)

    def test_retrieve_by_name_version(self):

        name = "swift.yaml"

        # Setup
        first = self.driver.create(self.store, name, "YAML1")
        second = self.driver.update(self.store, first.uuid, "YAML2")
        third = self.driver.update(self.store, first.uuid, "YAML3")

        # Test
        retrieved_first = self.driver.retrieve_by_name(self.store, name, 1)
        retrieved_second = self.driver.retrieve_by_name(self.store, name, 2)
        retrieved_third = self.driver.retrieve_by_name(self.store, name, 3)

        # Verify

        self.assertEqual(3, len(self.driver.list(self.store)))

        self.assertEqual(retrieved_first.uuid, first.uuid)
        self.assertEqual(1, retrieved_first.version)
        self.assertEqual("YAML1", retrieved_first.contents)

        self.assertEqual(retrieved_second.uuid, second.uuid)
        self.assertEqual(2, retrieved_second.version)
        self.assertEqual("YAML2", retrieved_second.contents)

        self.assertEqual(retrieved_third.uuid, third.uuid)
        self.assertEqual(3, retrieved_third.version)
        self.assertEqual("YAML3", retrieved_third.contents)

    def test_retrieve_by_name_invalid_name(self):

        retrieve_by_name_call = partial(self.driver.retrieve_by_name,
                                        self.store, "name")
        self.assertRaises(UnknownName, retrieve_by_name_call)

    def test_retrieve_by_name_invalid_version(self):

        self.driver.create(self.store, "name", "YAML")

        retrieve_by_name_call = partial(self.driver.retrieve_by_name,
                                        self.store, "name", 2)

        self.assertRaises(UnknownVersion, retrieve_by_name_call)

    def test_retrieve_by_name_other_error(self):
        """Verify that a NoResultFound exception is re-raised (and not
        lost/squashed) if it isn't detected to be due to a missing name or
        version that wasn't found.
        """

        self.driver.create(self.store, "name", "YAML")

        with patch('tuskar.storage.drivers.sqlalchemy.get_session') as mock:

            query_mock = Mock()
            query_mock.query.side_effect = NoResultFound()

            mock.return_value = query_mock

            retrieve_by_name_call = partial(self.driver.retrieve_by_name,
                                            self.store, "name")

            self.assertRaises(NoResultFound, retrieve_by_name_call)
Exemple #2
0
class SQLAlchemyDriverTestCase(base.TestCase):

    def setUp(self):
        super(SQLAlchemyDriverTestCase, self).setUp()

        self.driver = SQLAlchemyDriver()
        self.store = TemplateStore(self.driver)

    @patch('tuskar.storage.drivers.sqlalchemy.SQLAlchemyDriver._generate_uuid')
    def test_create(self, mock_uuid):

        # Setup
        expected_uuid = 'b4b85dc2-0b0a-48ed-a56c-e4d582fd1473'
        mock_uuid.return_value = expected_uuid

        # Test
        result = self.driver.create(self.store, "swift.yaml", "YAML")

        # Verify
        self.assertEqual(result.uuid, expected_uuid)
        self.assertEqual(result.version, 1)
        self.assertEqual(type(result.created_at), datetime)
        self.assertEqual(result.updated_at, None)

    @patch('tuskar.storage.drivers.sqlalchemy.SQLAlchemyDriver._generate_uuid')
    def test_create_no_versioning(self, mock_uuid):

        # Setup
        store = DeploymentPlanStore(self.driver)
        expected_uuid = 'b4b85dc2-0b0a-48ed-a56c-e4d582fd1473'
        mock_uuid.return_value = expected_uuid

        # Test
        result = self.driver.create(store, "swift.yaml", "YAML")

        # Verify
        self.assertEqual(result.uuid, expected_uuid)
        self.assertEqual(result.version, None)

    @patch('tuskar.storage.drivers.sqlalchemy.SQLAlchemyDriver._generate_uuid')
    def test_retrieve(self, mock_uuid):

        # Setup
        expected_uuid = 'b4b85dc2-0b0a-48ed-a56c-e4d582fd1473'
        expected_name = "swift.yaml"
        expected_contents = "YAML"
        mock_uuid.return_value = expected_uuid
        self.driver.create(self.store, expected_name, expected_contents)

        # Test
        result = self.driver.retrieve(self.store, expected_uuid)

        # Verify
        self.assertEqual(result.uuid, expected_uuid)
        self.assertEqual(result.name, expected_name)
        self.assertEqual(result.contents, expected_contents)

    def test_retrieve_invalid(self):

        # Setup
        retrieve_call = partial(
            self.driver.retrieve,
            self.store, "uuid"
        )

        # Test & Verify
        self.assertRaises(UnknownUUID, retrieve_call)

    def test_update(self):

        # Setup
        expected_name = "swift.yaml"
        original_contents = "YAML"
        created = self.driver.create(
            self.store, expected_name, original_contents)

        # Test
        new_contents = "YAML2"
        updated = self.driver.update(self.store, created.uuid, new_contents)

        # Verify
        retrieved = self.driver.retrieve(self.store, created.uuid)
        self.assertEqual(retrieved.uuid, created.uuid)
        self.assertEqual(retrieved.name, expected_name)
        self.assertEqual(type(created.created_at), datetime)
        self.assertEqual(created.updated_at, None)

        # Original and retrieved have not been updated
        self.assertEqual(retrieved.contents, original_contents)
        self.assertEqual(created.version, 1)
        self.assertEqual(retrieved.version, 1)

        # Updated has a new version, and new contents
        self.assertEqual(updated.contents, new_contents)
        self.assertEqual(updated.version, 2)
        self.assertEqual(type(updated.created_at), datetime)
        self.assertEqual(updated.updated_at, None)

    def test_update_no_versioning(self):

        # Setup
        store = DeploymentPlanStore(self.driver)
        expected_name = "swift.yaml"
        original_contents = "YAML"
        created = self.driver.create(store, expected_name, original_contents)

        # Test
        new_contents = "YAML2"
        updated = self.driver.update(store, created.uuid, new_contents)

        # Verify
        self.assertEqual(updated.uuid, created.uuid)
        self.assertEqual(updated.name, expected_name)
        self.assertEqual("YAML2", updated.contents)
        self.assertEqual(updated.version, None)

        self.assertEqual(type(created.created_at), datetime)
        self.assertEqual(created.updated_at, None)
        self.assertEqual(type(updated.created_at), datetime)
        self.assertEqual(type(updated.updated_at), datetime)

    def test_update_invalid_uuid(self):

        # Setup
        update_call = partial(self.driver.update, self.store, "uuid", "YAML2")

        # Test & Verify
        self.assertRaises(UnknownUUID, update_call)

    @patch('tuskar.storage.drivers.sqlalchemy.SQLAlchemyDriver._generate_uuid')
    def test_delete(self, mock_uuid):

        # Setup
        expected_uuid = 'b4b85dc2-0b0a-48ed-a56c-e4d582fd1473'
        expected_name = "swift.yaml"
        contents = "YAML"
        mock_uuid.return_value = expected_uuid
        self.driver.create(self.store, expected_name, contents)

        # Test
        result = self.driver.delete(self.store, expected_uuid)

        # Verify
        self.assertEqual(None, result)
        retrieve_call = partial(
            self.driver.retrieve,
            self.store, expected_uuid
        )
        self.assertRaises(UnknownUUID, retrieve_call)

    def test_delete_invalid(self):
        self.assertRaises(
            UnknownUUID, self.driver.delete, self.store, "uuid")

    def test_list(self):

        name = "swift.yaml"
        template = self.driver.create(self.store, name, "YAML1")

        self.assertEqual(1, len(self.driver.list(self.store)))

        self.driver.update(self.store, template.uuid, "YAML2")

        self.assertEqual(2, len(self.driver.list(self.store)))

    def test_list_only_latest(self):

        # setup
        name = "swift.yaml"
        template = self.driver.create(self.store, name, "YAML1")
        updated = self.driver.update(self.store, template.uuid, "YAML2")

        # test
        listed = self.driver.list(self.store, only_latest=True)

        # verify
        self.assertEqual(1, len(listed))
        self.assertEqual([updated.uuid, ], [t.uuid for t in listed])

    def test_list_only_latest_multi(self):

        # setup
        name = "swift.yaml"
        template1 = self.driver.create(self.store, name, "YAML1")
        template1 = self.driver.update(self.store, template1.uuid, "YAML2")
        template2 = self.driver.create(self.store, "other", "YAML1")

        # test
        listed = self.driver.list(self.store, only_latest=True)

        # verify
        self.assertEqual(2, len(listed))
        self.assertEqual(
            set([template1.uuid, template2.uuid]),
            set(t.uuid for t in listed)
        )

    def test_retrieve_by_name(self):

        # Setup
        create_result = self.driver.create(self.store, "name", "YAML")
        self.driver.update(self.store, create_result.uuid, "YAML2")

        # Test
        retrieved = self.driver.retrieve_by_name(self.store, "name")

        # Verify
        self.assertNotEqual(create_result.uuid, retrieved.uuid)
        self.assertEqual(retrieved.contents, "YAML2")
        self.assertEqual(retrieved.version, 2)

    def test_retrieve_by_name_version(self):

        name = "swift.yaml"

        # Setup
        first = self.driver.create(self.store, name, "YAML1")
        second = self.driver.update(self.store, first.uuid, "YAML2")
        third = self.driver.update(self.store, first.uuid, "YAML3")

        # Test
        retrieved_first = self.driver.retrieve_by_name(self.store, name, 1)
        retrieved_second = self.driver.retrieve_by_name(self.store, name, 2)
        retrieved_third = self.driver.retrieve_by_name(self.store, name, 3)

        # Verify

        self.assertEqual(3, len(self.driver.list(self.store)))

        self.assertEqual(retrieved_first.uuid, first.uuid)
        self.assertEqual(1, retrieved_first.version)
        self.assertEqual("YAML1", retrieved_first.contents)

        self.assertEqual(retrieved_second.uuid, second.uuid)
        self.assertEqual(2, retrieved_second.version)
        self.assertEqual("YAML2", retrieved_second.contents)

        self.assertEqual(retrieved_third.uuid, third.uuid)
        self.assertEqual(3, retrieved_third.version)
        self.assertEqual("YAML3", retrieved_third.contents)

    def test_retrieve_by_name_invalid_name(self):

        retrieve_by_name_call = partial(
            self.driver.retrieve_by_name,
            self.store, "name"
        )
        self.assertRaises(UnknownName, retrieve_by_name_call)

    def test_retrieve_by_name_invalid_version(self):

        self.driver.create(self.store, "name", "YAML")

        retrieve_by_name_call = partial(
            self.driver.retrieve_by_name,
            self.store, "name", 2
        )

        self.assertRaises(UnknownVersion, retrieve_by_name_call)

    def test_retrieve_by_name_other_error(self):
        """Verify that a NoResultFound exception is re-raised (and not
        lost/squashed) if it isn't detected to be due to a missing name or
        version that wasn't found.
        """

        self.driver.create(self.store, "name", "YAML")

        with patch('tuskar.storage.drivers.sqlalchemy.get_session') as mock:

            query_mock = Mock()
            query_mock.query.side_effect = NoResultFound()

            mock.return_value = query_mock

            retrieve_by_name_call = partial(
                self.driver.retrieve_by_name,
                self.store, "name"
            )

            self.assertRaises(NoResultFound, retrieve_by_name_call)