def test_with_invalid_password_raises_exception(self, create_users):

        # Arrange
        from gyaan_auth.exceptions import InvalidPassword
        sql_storage = StorageImplementation()
        username = "******"
        password = "******"

        # Act
        with pytest.raises(InvalidPassword):
            sql_storage.validate_password(username=username, password=password)
    def test_with_valid_password_returns_user_id(self, create_users):

        # Arrange
        sql_storage = StorageImplementation()
        username = "******"
        password = "******"
        expected_response = 1

        # Act
        response = sql_storage.validate_password(
            username=username,
            password=password
        )

        # Assert
        assert response == expected_response