Create an api for the classifier system

• create an API for marking a channel with admin feedback
• create an API for getting the summary of a channel's classifier (these stats will be displayed to the admin on the firehose)
• Api endpoints are admin only

Proposed schema from @ramialbatal

• Aggregated counts of:

  1. Active days (in the last 30 days, last 7 days)
  2. Comments written and received (last 30 days, last 7 days, last 1 day)
  3. Channels received comments from the current channel, channels commented on the current channel posts/blogs (last 30 days, last 7 days, last 1 day).
  4. Reminds done by the channel and received (last 30 days, last 7 days, last 1 day)
  5. Channels reminded by the current channel, channels
  6. Votes done by the channel and received (last 30 days, last 7 days, last 1 day)
  7. Boosts (last 30 days, last 7 days, last 1 day) + total tokens during the same periods
  8. Boosts Refund (last 30 days, last 7 days, last 1 day) + total tokens during the same periods
  9. Wire received and sent (last 30 days, last 7 days, last 1 day) + total tokens received and sent in the same periods
  10. Channels received wires from the current channel, Channels sent wires to the current channel
  11. Withdrawals
  12. Channels subscribed to the current channels (Total, in the last 30 days, last 7 days, last 1 day)
  13. Subscriptions (Total, in the last 30 days, last 7 days, last 1 day)
  14. Posts (in the last 30 days, last 7 days)
  15. Blogs (in the last 30 days, last 7 days)

• A list of the most recent 50 comments

• The profile picture

• The banner

• The profile description

Schema from @markeharding

CREATE TABLE classifier_outliers ( user_guid bigint, outlier_values map<timestamp,int>, admin_feedback map<timestamp,int>, PRIMARY KEY(user_guid) );

Waiting on confirmation about oauth

We need to make the api patch and complete so Rami can write all the information and the admins can only update the classifier.