WIP: Use a new table for user contribution stats

What does this MR do?

It defers the user contribution stats to a new table, instead of the events table.

Are there points in the code the reviewer needs to double check?

Why was this MR needed?

This will allow down sizing the events table.

Screenshots (if relevant)

Does this MR meet the acceptance criteria?

• Changelog entry added
• Documentation created/updated
• API support added
• Tests
  • Added for this feature/bug
  • All builds are passing
• Conform by the merge request performance guides
• Conform by the style guides
• Branch has no merge conflicts with master (if it does - rebase it please)
• Squashed related commits together

What are the relevant issue numbers?

#22623 (moved)

app/models/user_contribution.rb

+class UserContribution < ActiveRecord::Base
+  belongs_to :user
+
+  def self.calculate_for(date)
+    UserContribution.connection.execute <<-EOF
+      INSERT INTO user_contributions (user_id, date, contributions)
+      SELECT author_id, '#{date.strftime('%Y-%m-%d')}', count(*) AS contributions
+      FROM events
+      WHERE created_at >= '#{date.beginning_of_day}'
+      AND created_at <= '#{date.end_of_day}'
+      AND author_id IS NOT NULL
+      AND (
+        (
+          target_type in ('MergeRequest', 'Issue')
+          AND action in (
+            #{Event::CREATED},
+            #{Event::PUSHED},
+            #{Event::CLOSED},
+            #{Event::MERGED}
+          )
+        )
+        OR (target_type = 'Note' AND action = #{Event::COMMENTED})
+      )
+      GROUP BY author_id
+    EOF
+  end
+end