Stores votes on vitess - #2568
Ticket(s) / Related Merge Requests
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
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
Edited by Mark Harding