Feat/channel boost views #2506

Ticket(s) / Related Merge Requests

#2506 (closed)

Summary of Changes

• Added new pulsar subscription to consume activity's views related to a boost
• added logic in cronjob to calculate and issue revenue share deposits for views served by the boost partner on boosts that completed within the last 24 hours.

Testing Considerations

Check #2506 (comment 1311304869)

Deployment Considerations

• Add new db table

CREATE TABLE IF NOT EXISTS boost_partner_views
(
    served_by_user_guid bigint NOT NULL,
    boost_guid bigint NOT NULL,
    views int NOT NULL,
    view_date timestamp NOT NULL,
    PRIMARY KEY (served_by_user_guid, boost_guid, view_date)
) ENGINE=InnoDB;

ALTER TABLE boosts
    ADD completed_timestamp timestamp DEFAULT NULL
    AFTER approved_timestamp;
ALTER TABLE boosts
ADD INDEX completed_timestamp (completed_timestamp) USING BTREE;

Regression Scope

Platform Affected (web, mobile, etc)

Developer Testing Completed

Screenshots / Screen Recording

#2506 (comment 1311304869)

Does this impact

• Localization
• Dark/light mode
• Guest mode

Definition of Done Checklist

• The Acceptance Criteria has been met
• Code is tested: Testing includes unit/spec, E2E/automated and manual testing
• Merge requests description has been filled out