def test_find_by_email(self, mock_query: Mock) -> None:
expected = Invitation(id=123)
filter_by = mock_query.return_value.filter_by
first = filter_by.return_value.first
first.return_value = expected
result = Invitation.find_by_email('name-xyz', None)
filter_by.assert_called_once_with(email='name-xyz')
first.assert_called_once_with()
assert result == expected
def test_find_by_email_with_id(self, mock_query: Mock) -> None:
expected = Invitation(id=123)
filter_by = mock_query.return_value.filter_by
filter = filter_by.return_value.filter
first = filter.return_value.first
first.return_value = expected
result = Invitation.find_by_email('name-xyz', 654)
filter_by.assert_called_once_with(email='name-xyz')
filter.assert_called_once_with(_BinaryExpressionMatcher(Invitation.id != 654))
first.assert_called_once_with()
assert result == expected