Bypassing database automations
Methods, storage systems and computer program products implement embodiments of the present invention for controlling execution of automations that are associated with a table in a database. To implement these embodiments, respective bypass flags are defined in the automations, and an input indicating a bypass setting is received. In response to initiating execution of process for managing the table, the bypass flags are compared to the bypass setting so as to determine whether to permit or to bypass each given automation. Finally, during execution of the process, execution of the permitted automations is allowed, and execution of the bypassed automations is prevented.
1. A method for controlling execution of automations that are associated with a table in a database, the method comprising:
defining respective bypass flags in the automations;
receiving one or more inputs indicating respective bypass settings for a plurality of processes for managing the table, including at least a first bypass setting for a first process and a second bypass setting, different from the first bypass setting for a second process;
initiating execution of each of the first and second processes for managing the table;
responsively to initiation of the execution of each of the first and second processes, comparing the bypass flags to each of the first and second bypass settings so as to determine whether to permit or to bypass each given automation; and
during the execution of the first and second processes, allowing the execution of the permitted automations, and preventing execution of the bypassed automations including:
during the execution of the first process, allowing the execution of a given automation having a given bypass flag that matches the first bypass setting; and
during the execution of the second process, preventing the execution of the given automation when the given bypass flag does not match the second bypass setting.
2. The method according to claim 1 , wherein managing the table comprises loading data to the table.
3. The method according to claim 2 , wherein the data comprises a first format, wherein the records comprise a second format, and wherein loading the data comprises converting the data from the first format to the second format.
4. The method according to claim 2 , wherein loading the data into records of the table comprises copying the data from a first instance of the table to a second instance of the table.
5. The method according to claim 1 , wherein managing the table comprises deleting data from the table.
6. The method according to claim 1 , wherein managing the table comprises modifying data in the table.
7. The method according to claim 1 , wherein the given automation a comprises performing validation.
8. The method according to claim 1 , wherein the given automation comprises executing a trigger.
9. The method according to claim 1 , wherein the given automation comprises presenting a user interface element.
10. An apparatus for controlling execution of automations that are associated with a table in a database, the apparatus comprising:
a memory configured to store a plurality of processes for managing the table, including at least a first process and a second process; and
a processor configured:
to define respective bypass flags in the automations,
to receive one or more inputs indicating respective bypass settings for the plurality of processes for managing the table, including at least a first bypass setting for the first process and a second bypass setting, different from the first bypass setting for the second process,
to load and initiate execution, from the memory, of each of the first and second processes for managing the table,
responsively to initiation of the execution of each of the first and second processes, to compare the bypass flags to each of the first and second bypass settings so as to determine whether to permit or to bypass each given automation, and
during the execution of the first and second processes, to allow the execution of the permitted automations and prevent execution of the bypassed automations including:
during the execution of the first process, allowing the execution of a given automation having a given bypass flag that matches the first bypass setting; and
during the execution of the second process, preventing the execution of the given automation when the given bypass flag does not match the second bypass setting.
11. The apparatus according to claim 10 , wherein the processor is configured to manage the table by loading data to the table.
12. The apparatus according to claim 11 , wherein the data comprises a first format, wherein the records comprise a second format, and wherein the processor is configured to load the data by converting the data from the first format to the second format.
13. The apparatus according to claim 11 , wherein the processor is configured to load the data into records of the table by copying the data from a first instance of the table to a second instance of the table.
14. The apparatus according to claim 10 , wherein the processor is configured to manage the table by deleting data from the table.
15. The apparatus according to claim 10 , wherein the processor is configured to manage the table by modifying data in the table.
16. The apparatus according to claim 10 , wherein the given automation comprises performing a validation.
17. The apparatus according to claim 10 , wherein the given automation comprises executing a trigger.
18. The apparatus according to claim 10 , wherein the given automation comprises presenting a user interface element.
19. A computer software product for controlling execution of automations that are associated with a table in a database, the product comprising a non-transitory computer-readable medium, in which program instructions are stored, which instructions, when read by a computer, cause the computer:
to define respective bypass flags in the automations;
to receive one or more inputs indicating respective bypass settings for a plurality of processes for managing the table, including at least a first bypass setting for a first process and a second bypass setting, different from the first bypass setting for a second process;
to initiate execution of each of the first and second processes for managing the table;
responsively to initiation of the execution of each of the first and second processes, to compare the bypass flags to each of the first and second bypass settings so as to determine whether to permit or to bypass each given automation; and
during the execution of the first and second processes, to allow the execution of the permitted automations and to prevent execution of the bypassed automations including:
during the execution of the first process, allowing the execution of a given automation having a given bypass flag that matches the first bypass setting; and
during the execution of the second process, preventing the execution of the given automation when the given bypass flag does not match the second bypass setting.