Cached database and synchronization system for providing dynamic linked panels in user interface
A system is configured to provide a dashboard creation system. Panels associated with queries for retrieving information from a database are shown in a user interface. Various other user interfaces show query code, panel display settings, function code, dependencies, etc. Queries in a first query format access a data source. Queries in a second query format access a cache database that is synchronized with the data source.
1. A computer system comprising:
one or more processors configured to execute code to cause the computer system to:
display a user interface comprising:
a first panel and a second panel;
a first menu of event conditions for a user to select;
a second menu of actions for the user to select, wherein the actions are to be taken in response to a selected event condition; and
an event-viewing graph that displays visual indications of relationships between event conditions and actions;
receive a user selection of a first event condition, from the first menu of event conditions, associated with the first panel and the second panel;
receive a user selection of a first action, from the second menu of actions, to be taken in response to the first event condition;
generate code corresponding to the first event condition and the first action;
add the generated code to the user interface in relation to the first panel and the second panel; and
update the event-viewing graph to include a visual indication of a relationship between the first event condition and the first action.
2. The computer system of claim 1 , wherein:
the user interface further comprises a dependency graph,
the dependency graph includes a visual indication of an event-dependent relationship between the first panel and the second panel, and
the one or more processors configured to execute code to further cause the computer system to:
receive a user input, via the dependency graph, selecting an icon representing the first event condition or the first action and modifying at least one of the first event condition or the first action; and
modify the generated code or generate code corresponding to the modifying of the at least one of the first event condition or the first action.
3. The computer system of claim 1 , wherein the one or more processors configured to execute code to further cause the computer system to:
receive a user selection of a second action, from the second menu of actions, to also be taken in response to the first event condition; and
generate code corresponding to the first event condition and the first and second actions.
4. The computer system of claim 3 , wherein either first action or the second action is triggered in response to a number of times that the first event condition has occurred.
5. The computer system of claim 4 , wherein either first action or the second action is triggered further in response to whether or not a second event has occurred.
6. The computer system of claim 1 , wherein the one or more processors configured to execute code to further cause the computer system to:
receive a user selection of a second event condition, from the first menu of event conditions, associated with the second panel;
receive a user selection of a second action, from the second menu of actions, to be taken in response to the second event condition;
generate code corresponding to the second event condition and the second actions; and
add the generated code to the user interface in relation to the second panel,
wherein:
the first action is associated with the second panel, and
the second action is associated with the first panel, creating a circular dependency between the first panel and the second panel.
7. The computer system of claim 6 , wherein the circular dependency is implemented, in the generated code, by at least one of: a watch function, events that trigger opposite to one another's actions, an intermediary event that acts as a state storage.
8. The computer system of claim 6 , wherein:
the user interface further comprises a dependency graph, and
the dependency graph includes a visual indication of the circular dependency between the first panel and the second panel.
9. The computer system of claim 8 , wherein the one or more processors configured to execute code to further cause the computer system to:
receive a user input, via the dependency graph, selecting an icon representing the first event condition or the first action and modifying at least one of the first event condition or the first action; and
modify the generated code or generate code corresponding to the modifying of the at least one of the first event condition or the first action.
10. A computer-implemented method comprising:
displaying a user interface comprising:
a first panel and a second panel;
a first menu of event conditions for a user to select;
a second menu of actions for the user to select, wherein the actions are to be taken in response to a selected event condition; and
an event-viewing graph that displays visual indications of relationships between event conditions and actions;
receiving a user selection of a first event condition, from the first menu of event conditions, associated with the first panel and the second panel;
receiving a user selection of a first action, from the second menu of actions, to be taken in response to the first event condition;
generating code corresponding to the first event condition and the first action;
adding the generated code to the user interface in relation to the first panel and the second panel; and
updating the event-viewing graph to include a visual indication of a relationship between the first event condition and the first action.
11. The computer-implemented method of claim 10 , wherein:
the user interface further comprises a dependency graph,
the dependency graph includes a visual indication of an event-dependent relationship between the first panel and the second panel, and
the computer-implemented method further comprises:
receiving a user input, via the dependency graph, selecting an icon representing the first event condition or the first action and modifying at least one of the first event condition or the first action; and
modifying the generated code or generate code corresponding to the modifying of the at least one of the first event condition or the first action.
12. The computer-implemented method of claim 10 further comprising:
receiving a user selection of a second action, from the second menu of actions, to also be taken in response to the first event condition; and
generating code corresponding to the first event condition and the first and second actions.
13. The computer-implemented method of claim 12 , wherein either first action or the second action is triggered in response to a number of times that the first event condition has occurred.
14. The computer-implemented method of claim 13 , wherein either first action or the second action is triggered further in response to whether or not a second event has occurred.
15. The computer-implemented method of claim 10 , wherein computer-implemented method further comprises:
receiving a user selection of a second event condition, from the first menu of event conditions, associated with the second panel;
receiving a user selection of a second action, from the second menu of actions, to be taken in response to the second event condition;
generating code corresponding to the second event condition and the second actions; and
adding the generated code to the user interface in relation to the second panel,
wherein:
the first action is associated with the second panel, and
the second action is associated with the first panel, creating a circular dependency between the first panel and the second panel.
16. The computer-implemented method of claim 15 , wherein the circular dependency is implemented, in the generated code, by at least one of: a watch function, events that trigger opposite to one another's actions, an intermediary event that acts as a state storage.
17. The computer-implemented method of claim 15 , wherein:
the user interface further comprises a dependency graph, and
the dependency graph includes a visual indication of the circular dependency between the first panel and the second panel.
18. The computer-implemented method of claim 17 further comprising:
receiving a user input, via the dependency graph, selecting an icon representing the first event condition or the first action and modifying at least one of the first event condition or the first action; and
modifying the generated code or generate code corresponding to the modifying of the at least one of the first event condition or the first action.