Update status to support blocked state - Githubissues

cofacts / rumors-db

Scripts for managing rumors db

MIT License

5 stars 11 forks source link

Update status to support blocked state #55

Closed MrOrz closed 2 years ago

MrOrz commented 2 years ago

Spec

Specification: https://g0v.hackmd.io/0Cv5hmmAQYyW8SJdXvfdtw#Delete-reply-requests---blocking-user-from-submitting-visible-contents
Maps to milestone 1, schema changes: https://g0v.hackmd.io/rf0A7MRfTOC613QZmFehQA?both#1st-milestone-data-prep

Changes

add status field to replyRequest, aritcleReplyFeedbacks and articleCategoryFeedbacks
- add migration script to populate the status field above
Add blockedReason to users

Migration steps

Times are calculated using production backup in 2021

1. Reload index for newly added fields

npm run reload -- articlecategoryfeedbacks # several seconds
npm run reload -- articlereplyfeedbacks # 2 mins
npm run reload -- replyrequests # 1 min
npm run reload -- users # 1 min

2. Update script

npx babel-node db/migrations/202110-fill-statuses.js