Adds a 'status' column to the rule table, showing the publication status of a rule. (It'll also, eventually, show archived status.)
The UUID column is removed to make room for it, which satisfies the user story I want to not have to worry about secondary rule information (ie. ID). You can still search by UUID.
@Fweddi if this has a painful overlap with your 'archived' feature, let's chat, it might be simpler for me to rebase this on top of your work!
How to test
The automated tests should pass, and give us some confidence the query is correct.
Load rules from the sheet into the management system with 'refresh rules'. They should all be live.
Create a new new rule. It should be marked draft.
Publish the rule, following the instructions in #324. It should now be marked live.
What does this change?
Adds a 'status' column to the rule table, showing the publication status of a rule. (It'll also, eventually, show archived status.)
The UUID column is removed to make room for it, which satisfies the user story
I want to not have to worry about secondary rule information (ie. ID). You can still search by UUID.@Fweddi if this has a painful overlap with your 'archived' feature, let's chat, it might be simpler for me to rebase this on top of your work!
How to test