oca-cla-bot fails with old commits and old emails

[yajo]

Describe the bug

oca-cla-bot fails when somebody migrates a module that includes commits from an email that had CLA signed back then, but not anymore.

To Reproduce

See:

• [12.0][MIG] website_portal_contact website#882 (comment)
• [15.0][MIG] account_lock_date_update account-financial-tools#1369 (comment)

Expected behavior
My old job email should still pass ✔️ because when I pushed those commits back then, I had the CLA signed with that email.

[rousseldenis]

@yajo I think this is tied to how we do migrations.

IMHO (I'll try to open a discussion soon), migrations should include only migration commits. It's becoming more and more difficult to review migrations.

We should create new main branches from preceding one.

[pedrobaeza]

That procedure was a total pain, as there can be extra commits since the branch creation, and doing a periodical synchronization is also very tedious, provoking at the end also non pure migration PRs.

But you can review a PR with several commits in the current procedure, including the migration commit, very easily clicking on such commit, and GitHub shows the diff related to the migration. What is the problem with it? What is becoming more and more difficult? This procedure also serves for squashing useless administrative commits.

[yajo]

Well, it truly has a security problem, but outside of that I agree that the old process was even worse.

In any case, all of that is outside of the scope. The problem is that the bot complains about email addresses that were CLA-signed back then. It should compare the email and date of the commit, and then complain about those that have no CLA approval within that specific date.

[pedrobaeza]

Yes, I also put the same on #170. @sbidoul @gurneyalex maybe you can check it.

[sbidoul]

I don't think there is anything reasonable we can do to fix the current CLA bot. Long term we may want to move to a paperless and more robust process with, e.g., https://github.com/cla-assistant/cla-assistant.

[pedrobaeza]

@sbidoul we just need to include in the bot with_context(active_test=False) for searching inactive contacts

[gurneyalex]

I just added the context key in the legacy clabot. Let's see if it helps.

[SirTakobi]

Has #209 (comment) fixed the issue? Can this be closed?