Implement filtering

[jabbany]

We want to have a scheduled job (daily) that does the following, in order:

1. For each channel (user), grab all new comments from YouTube between the last sync and current sync. Save all the new comments into our db
2. For each grabbed comment, loop through each filter in each filter group:
   1. If a match is encountered, based on the match, put the comment into a corresponding bin for action (nothing, delete, review, report, block)
   2. Increment 2 stats counters: (1) "how many comments caught by this filter today" and (2) "how many comments were applied this action today")
3. Batch execute action bins via the Youtube API

[streams1]

When using YouTube API: May need different permissions (will need to look into that).
For actions delete comment specifically: keep track of number of comments deleted for specific filter and store the text of the deleted comment in table. Consider how comments in the graph will be represented. May need a separate graph to show active + inactive comments (deleted) + daily frequency.
More specific set of actions may also be needed for Block Commenter depending on its behavior in testing. Perhaps store the list in a separate table, foreign key = user youtube id.

[jabbany]

• Use API to grab new comments into our db
• Apply filter actions
• Store stats