When AMO starts importing personas, we'll have to compare all the strings in each Persona between the AMO and personas databases to make sure they're in sync. I'd rather not check all 60,000 personas every time, so a last_modified column would be super helpful for ensuring we only do useful work. We're going into code freeze on 10/13. Thanks!
Can you do it out of the log table? We log every approval, edit approval and delete, which are the three triggers you care about.
That could probably work. What would the query look like to get all the persona ids that were updated since yesterday?
select distinct(id) from log where (action = 'EditApproved' or action = 'Approved' or action = 'Pulled') and date > date_sub(NOW(), interval 1 day);
Thanks! Pulled means that I should remove AMO's copy of the persona, right?
Status: NEW → RESOLVED
Last Resolved: 9 years ago
Resolution: --- → FIXED
Yes. If it goes back in, it'll have a followup "Approved"
Product: Mozilla Labs → Mozilla Labs Graveyard
You need to log in before you can comment on or make changes to this bug.