System, method, and computer program for preventing user mistakes when making database changes
As described herein, a system, method, and computer program are provided for preventing user mistakes when making database changes. In use, a user command to modify a database is received. The user command is validated against a plurality of predefined business rules. One or more actions are conditionally performed before executing the user command, based on a result of the validating.
1. A non-transitory computer-readable media storing computer instructions which when executed by one or more processors of a device cause the device to:
receive a user command to modify a database;
validate the user command against a plurality of predefined business rules, wherein the plurality of predefined business rules include at least one of:
at least one rule that requires a latest version of user commands, or
at least one rule that requires a number of rows expected by the user to be changed as a result of executing the user command to match a number of actual rows that will be changed as a result of executing the user command; and
perform one or more actions before executing the user command, based on a result of the validating.
2. The non-transitory computer-readable media of claim 1 , wherein a syntax of the user command is validated before validating the user command against the plurality of predefined business rules.
3. The non-transitory computer-readable media of claim 1 , wherein the plurality of predefined business rules further include at least one rule that requires a “where” clause for user commands.
4. The non-transitory computer-readable media of claim 3 , wherein when the result of the validating indicates that the user command does not include a “where” clause, then the one or more actions include issuing an alert that the user command that the missing “where” clause will cause the user command to impact an entire table of the database.
5. The non-transitory computer-readable media of claim 4 , wherein when the result of the validating indicates that the user command does not include a “where” clause, then the one or more actions further include preventing execution of the user command.
6. The non-transitory computer-readable media of claim 1 , wherein the plurality of predefined business rules include the at least one rule that requires the latest version of user commands.
7. The non-transitory computer-readable media of claim 6 , wherein when the result of the validating indicates that the user command does not match a latest executed version of the user command, then the one or more actions include issuing an alert that the user command was previously commented or modified.
8. The non-transitory computer-readable media of claim 7 , wherein when the result of the validating indicates that the user command does not match a latest executed version of the user command, then the one or more actions further include providing an option to the user to proceed with the latest executed version of the user command.
9. The non-transitory computer-readable media of claim 1 , wherein the plurality of predefined business rules further include at least one rule that limits a number of rows allowed to be changed by execution of any particular user command.
10. The non-transitory computer-readable media of claim 9 , wherein when the result of the validating indicates that execution of the user command will change a number of rows that exceeds the limit, then the one or more actions include preventing the execution of the user command.
11. The non-transitory computer-readable media of claim 1 , wherein the plurality of predefined business rules include the at least one rule that requires the number of rows expected by the user to be changed as the result of executing the user command to match the number of actual rows that will be changed as the result of executing the user command.
12. The non-transitory computer-readable media of claim 11 , wherein the number of rows expected by the user to be changed as a result of executing the user command are input by the user in association with the user command.
13. The non-transitory computer-readable media of claim 12 , wherein when the result of the validating indicates that the number of rows expected by the user to be changed as a result of executing the user command does not match the number of actual rows that will be changed as a result of executing the user command, then the one or more actions include issuing an alert indicating the mismatch between the number of rows expected by the user to be changed and the number of actual rows that will be changed.
14. The non-transitory computer-readable media of claim 13 , wherein when the result of the validating indicates that the number of rows expected by the user to be changed as a result of executing the user command does not match the number of actual rows that will be changed as a result of executing the user command, then the one or more actions further include preventing the execution of the user command.
15. The non-transitory computer-readable media of claim 1 , wherein the one or more actions include at least temporarily preventing execution of the user command.
16. The non-transitory computer-readable media of claim 1 , further comprising:
when the user command is executed, automatically back up rows of the database impacted by the user command before committing changes to the rows of the database impacted by the user command.
17. The non-transitory computer-readable media of claim 1 , further comprising:
when the user command is executed, store an indication of the user command in a history of user commands.
18. The non-transitory computer-readable media of claim 1 , further comprising:
when the user command is executed, issue a notification of a number of rows impacted by the user command.
19. A method, comprising:
at a computer system:
receiving a user command to modify a database;
validating the user command against a plurality of predefined business rules, wherein the plurality of predefined business rules include at least one of:
at least one rule that requires a latest version of user commands, or
at least one rule that requires a number of rows expected by the user to be changed as a result of executing the user command to match a number of actual rows that will be changed as a result of executing the user command; and
performing one or more actions before executing the user command, based on a result of the validating.
20. A system, comprising:
a non-transitory memory storing instructions; and
one or more processors in communication with the non-transitory memory that execute the instructions to:
receive a user command to modify a database;
validate the user command against a plurality of predefined business rules;
perform one or more actions before executing the user command, based on a result of the validating; and
when the user command is executed, at least one of:
automatically back up rows of the database impacted by the user command before committing changes to the rows of the database impacted by the user command, or
issue a notification of a number of rows impacted by the user command.