Stores votes on vitess - #2568

Ticket(s) / Related Merge Requests

#2568 (closed)

Summary of Changes

Votes will now be stored on Vitess

Testing Considerations

Vote on some posts and verify they are saved. Deletes are marked softly for future support of rate limiting.

select * from minds_votes ORDER BY updated_timestamp DESC;

Deployment Considerations

New table needs deploying.

CREATE TABLE IF NOT EXISTS minds_votes
(
    user_guid bigint NOT NULL,
    entity_guid bigint NOT NULL,
    entity_type text NOT NULL,
    direction int NOT NULL,
    deleted boolean NOT NULL DEFAULT FALSE,
    created_timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    updated_timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (user_guid, entity_guid, direction)
) ENGINE=InnoDB;

Regression Scope

Existing votes break.

Platform Affected (web, mobile, etc)

API

Developer Testing Completed

@markharding 👍

Screenshots / Screen Recording

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