System and method for dynamically generating client-side database forms
View Patent ↗In one embodiment, a method includes serving a webpage comprising a reference to a network location of a form-generator client application to a client device. Additionally, the method includes receiving a request from the client device for the form-generator client application and supplying the form-generator client application to the client device. In addition, the method includes receiving a request for an entity schema of at least one database entity of the plurality of database entities. The method further includes transmitting a standardized schema to the loaded form-generator client application so that a client-side database form can be dynamically generated. In addition, the method includes interacting with the dynamically-generated client-side database form to perform one or more persistent storage operations.
1. A method comprising, on a backend computing system comprising at least one server computer:
centrally maintaining a plurality of form-generator client applications;
centrally maintaining a plurality of entity adapters, each entity adapter providing a standard interface to one or more of a plurality of database entities, the plurality of database entities logically representing data stored in a database on the backend computing system;
allowing a user of a client device to select a form-generation category from a plurality of form-generation categories;
identifying a form-generator client application of the plurality of form-generator client applications that is appropriate for the form-generation category;
generating a webpage comprising a reference to a network location of the form-generator client application;
serving the webpage to the client device;
receiving, at the network location, a request from the client device for the form-generator client application;
supplying the form-generator client application to the client device so that the form-generator client application can be loaded on the client device;
receiving, from the loaded form-generator client application, a request for an entity schema of at least one database entity of the plurality of database entities;
acquiring, using an entity adapter of the plurality of entity adapters that is associated with the at least one database entity, a standardized schema for the at least one database entity;
transmitting the standardized schema to the loaded form-generator client application so that a client-side database form can be dynamically generated by the loaded form-generator client application, on the client device, in accordance with a structure of the at least one database entity as represented by the standardized schema;
providing, to the dynamically-generated client-side database form, a web application programming interface (API) for performing a set of persistent storage operations, wherein the web API defines the set of persistent storage operations in terms of hypertext transfer protocol methods;
receiving, via the web API, from the dynamically-generated client-side database form on the client device, one or more persistent storage operations of the set relative to the at least one database entity; and
performing the one or more persistent storage operations in the database relative to the at least one database entity.
2. The method of claim 1 , wherein the web API comprises a RESTful web API.
3. The method of claim 1 , wherein the set of persistent storage operations comprise create, read, update, and delete operations.
4. The method of claim 1 , wherein the set of persistent storage operations are restricted to create, read, update, and delete operations.
5. The method of claim 1 , wherein the identified form-generator client application comprises a form-generator client application of the plurality of form-generator client applications that is mapped to the selected form-generation category.
6. The method of claim 1 , wherein the selected form-generation category is selected from the group consisting of: a name of a particular database, a name of a particular database table, and a functional category of data.
7. The method of claim 1 , wherein the acquiring comprises translating an entity schema of the at least one database entity into the standardized schema.
8. The method of claim 1 , comprising:
translating, via the entity adapter, the one or more persistent storage operations into one or more corresponding calls to the at least one database entity; and
wherein the performing comprises performing the one or more persistent storage operations in the database relative to the at least one database entity using the one or more corresponding calls.
9. The method of claim 1 , wherein the webpage comprises a plurality of initialization parameters for the form-generator client application.
10. An information handling system comprising a processor and memory, wherein the processor and memory in combination are operable to implement a method comprising:
centrally maintaining a plurality of form-generator client applications;
centrally maintaining a plurality of entity adapters, each entity adapter providing a standard interface to one or more of a plurality of database entities, the plurality of database entities logically representing data stored in a database on the backend computing system;
allowing a user of a client device to select a form-generation category from a plurality of form-generation categories;
identifying a form-generator client application of the plurality of form-generator client applications that is appropriate for the form-generation category;
generating a webpage comprising a reference to a network location of the form-generator client application;
serving the webpage to the client device;
receiving, at the network location, a request from the client device for the form-generator client application;
supplying the form-generator client application to the client device so that the form-generator client application can be loaded on the client device;
receiving, from the loaded form-generator client application, a request for an entity schema of at least one database entity of the plurality of database entities;
acquiring, using an entity adapter of the plurality of entity adapters that is associated with the at least one database entity, a standardized schema for the at least one database entity;
transmitting the standardized schema to the loaded form-generator client application so that a client-side database form can be dynamically generated by the loaded form-generator client application, on the client device, in accordance with a structure of the at least one database entity as represented by the standardized schema;
providing, to the dynamically-generated client-side database form, a web application programming interface (API) for performing a set of persistent storage operations, wherein the web API defines the set of persistent storage operations in terms of hypertext transfer protocol methods;
receiving, via the web API, from the dynamically-generated client-side database form on the client device, one or more persistent storage operations of the set relative to the at least one database entity; and
performing the one or more persistent storage operations in the database relative to the at least one database entity.
11. The information handling system of claim 10 , the method wherein the web API comprises a RESTful web API.
12. The information handling system of claim 10 , wherein the set of persistent storage operations comprise create, read, update, and delete operations.
13. The method of claim 10 , wherein the set of persistent storage operations are restricted to create, read, update, and delete operations.
14. The information handling system of claim 10 , wherein the identified form-generator client application comprises a form-generator client application of the plurality of form-generator client applications that is mapped to the selected form-generation category.
15. The information handling system of claim 10 , wherein the selected form-generation category is selected from the group consisting of: a name of a particular database, a name of a particular database table, and a functional category of data.
16. The information handling system of claim 10 , wherein the acquiring comprises translating an entity schema of the at least one database entity into the standardized schema.
17. The information handling system of claim 10 , the method comprising:
translating, via the entity adapter, the one or more persistent storage operations into one or more corresponding calls to the at least one database entity; and
wherein the performing comprises performing the one or more persistent storage operations in the database relative to the at least one database entity using the one or more corresponding calls.
18. The information handling system of claim 10 , wherein the webpage comprises a plurality of initialization parameters for the form-generator client application.
19. A computer-program product comprising a non-transitory computer-usable medium having computer-readable program code embodied therein, the computer-readable program code adapted to be executed to implement a method comprising:
centrally maintaining a plurality of form-generator client applications;
centrally maintaining a plurality of entity adapters, each entity adapter providing a standard interface to one or more of a plurality of database entities, the plurality of database entities logically representing data stored in a database on the backend computing system;
allowing a user of a client device to select a form-generation category from a plurality of form-generation categories;
identifying a form-generator client application of the plurality of form-generator client applications that is appropriate for the form-generation category;
generating a webpage comprising a reference to a network location of the form-generator client application;
serving the webpage to the client device;
receiving, at the network location, a request from the client device for the form-generator client application;
supplying the form-generator client application to the client device so that the form-generator client application can be loaded on the client device;
receiving, from the loaded form-generator client application, a request for an entity schema of at least one database entity of the plurality of database entities;
acquiring, using an entity adapter of the plurality of entity adapters that is associated with the at least one database entity, a standardized schema for the at least one database entity;
transmitting the standardized schema to the loaded form-generator client application so that a client-side database form can be dynamically generated by the loaded form-generator client application, on the client device, in accordance with a structure of the at least one database entity as represented by the standardized schema;
providing, to the dynamically-generated client-side database form, a web application programming interface (API) for performing a set of persistent storage operations, wherein the web API defines the set of persistent storage operations in terms of hypertext transfer protocol methods;
receiving, via the web API, from the dynamically-generated client-side database form on the client device, one or more persistent storage operations of the set relative to the at least one database entity; and
performing the one or more persistent storage operations in the database relative to the at least one database entity.
20. The computer-program product of claim 19 , the method wherein the web API comprises a RESTful web API.