search

stopstalk / stopstalk-deployment

Stop stalking and start StopStalking :wink:
https://www.stopstalk.com
MIT License
313 stars 96 forks source link

Handle cases when it get's invalid #282

Open raj454raj opened 6 years ago

raj454raj commented 6 years ago

At present the retrieval script marks handles invalid but they don't delete the submissions from the submission table for the previously valid handle.

Sayak9495 commented 6 years ago

Hi @raj454raj , can you explain the problem little more? (my understanding is - if a user first gives a valid handle, all his submissions get recorded under table submission. Afterward, he changes it to some other handle then the previous submissions under that handle name needs to be deleted from 'submission' table).

raj454raj commented 6 years ago

So for example: https://www.stopstalk.com/user/profile/tanujkhattar The current codeforces handle of the user is tanujkhattar. Now this handle is invalid because the user has changed it to Baba and hence we made an entry in invalid_handle table for tanujkhattar. At this point in submission retrieval, we also need to delete the codeforces submissions with previously valid handle.