Rapid application development for database-aware applications
First Claim
Patent Images
1. A method to programmatically generate source code for a software application to connect to a database, comprising:
- responsive to receiving a selection of a database connection specifying a database and a set of connection parameters of the database connection, establishing a connection to the database;
retrieving a data model of the database, the data model comprising a set of database elements;
displaying the set of database elements;
responsive to receiving a selection of a database element from the set of database elements, generating a first source code to access the selected database element, comprising;
generating a first portion of the first source code to create a connection to selected database;
mapping at least one host variable to a column of the selected database element;
generating a first database statement to access the selected database element using the at least one mapped host variable; and
embedding the first database statement in a second portion of the first source code; and
storing the first source code within a project associated with the software application.
1 Assignment
0 Petitions
Accused Products
Abstract
Embodiments of the invention provide application development tools that allow developers to rapidly build database-aware applications and database unit tests. Embodiments of the invention support multiple scenarios for database-aware application development, including beginning from a database table and automatically creating application code to access the table, beginning from an existing database query, beginning from existing application code that accesses a database, and hybrids or variations of these approaches.
-
Citations
24 Claims
-
1. A method to programmatically generate source code for a software application to connect to a database, comprising:
-
responsive to receiving a selection of a database connection specifying a database and a set of connection parameters of the database connection, establishing a connection to the database; retrieving a data model of the database, the data model comprising a set of database elements; displaying the set of database elements; responsive to receiving a selection of a database element from the set of database elements, generating a first source code to access the selected database element, comprising; generating a first portion of the first source code to create a connection to selected database; mapping at least one host variable to a column of the selected database element; generating a first database statement to access the selected database element using the at least one mapped host variable; and embedding the first database statement in a second portion of the first source code; and storing the first source code within a project associated with the software application. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8)
-
-
9. A computer program product comprising a computer useable storage medium having a computer readable program, wherein the computer readable program when executed on a computer causes the computer to perform an operation comprising:
-
responsive to receiving a selection of a database connection specifying a database and a set of connection parameters of the database connection, establishing a connection to the database; retrieving a data model of the database, the data model comprising a set of database elements; displaying the set of database elements; responsive to receiving a selection of a database element from the set of database elements, generating a first source code to access the selected database element, comprising; generating a first portion of the first source code to create a connection to selected database; mapping at least one host variable to a column of the selected database element; generating a first database statement to access the selected database element using the at least one mapped host variable; and embedding the first database statement in a second portion of the first source code; and storing the first source code within a project associated with the software application. - View Dependent Claims (10, 11, 12, 13, 14, 15, 16)
-
-
17. A system, comprising:
-
a processor; and a memory containing an integrated development environment (IDE) tool configured to generate source code for a database-aware software application by performing an operation, comprising; responsive to receiving a selection of a database connection specifying a database and a set of connection parameters of the database connection, establishing a connection to the database; retrieving a data model of the database, the data model comprising a set of database elements; displaying the set of database elements; responsive to receiving a selection of a database element from the set of database elements, generating a first source code to access the selected database element, comprising; generating a first portion of the first source code to create a connection to selected database; mapping at least one host variable to a column of the selected database element; generating a first database statement to access the selected database element using the at least one mapped host variable; and embedding the first database statement in a second portion of the first source code; and storing the first source code within a project associated with the software application. - View Dependent Claims (18, 19, 20, 21, 22, 23, 24)
-
Specification