Processing database queries embedded in application source code from within integrated development environment tool
First Claim
Patent Images
1. A computer-implemented method to debug database statements embedded in program source code, during development of the program source code and prior to successfully compiling the program source code, the computer-implemented method comprising:
- updating a graphical user interface (GUI) of an integrated development environment (IDE) tool during development of the program source code, wherein the GUI of the IDE tool is updated based on user input specifying to modify the program source code;
upon detecting modification of the program source code to include a database statement embedded as a text string in the program source code, causing evaluation of the embedded database statement, wherein the embedded database statement contains a plurality of syntax elements of different types, of which a first syntax element is auto-completed by the IDE tool without requiring user input explicitly specifying the entirety of the first syntax element, thereby avoiding any syntactic error in the first syntax element, wherein the IDE tool visually distinguishes different types of syntax elements from one another via different syntax colors for display;
upon identification of a semantic error in a second of the plurality of syntax elements during evaluation of the embedded database statement, generating output visually conveying the identified semantic error and one or more auto-proposed fixes applicable, upon user selection via the IDE tool, to correct the identified semantic error, thereby improving a measure of efficiency of debugging the embedded database statement; and
subsequent to correction of the identified semantic error, and responsive to receiving a request to compile the program source code, compiling the program source code in order to generate an application for execution, wherein the program source code is successfully compiled only upon identifying no compilation error in the program source code and no syntactic error and no semantic error in the embedded database statement;
wherein the IDE tool is configured to identify;
(i) at least one syntactic error comprising a misspelled keyword and (ii) at least one semantic error comprising an incorrect table name or an incorrect column name.
1 Assignment
0 Petitions
Accused Products
Abstract
Embodiments of the invention provide database integration within an integrated development environment (IDE) tool for displaying database structure and other database information, query editing and execution, and error detection for database statements embedded in program source code. Embodiments of the invention integrate database connectivity and error detection into the IDE tool, thereby potentially reducing the time required for database-aware application development.
134 Citations
24 Claims
-
1. A computer-implemented method to debug database statements embedded in program source code, during development of the program source code and prior to successfully compiling the program source code, the computer-implemented method comprising:
-
updating a graphical user interface (GUI) of an integrated development environment (IDE) tool during development of the program source code, wherein the GUI of the IDE tool is updated based on user input specifying to modify the program source code; upon detecting modification of the program source code to include a database statement embedded as a text string in the program source code, causing evaluation of the embedded database statement, wherein the embedded database statement contains a plurality of syntax elements of different types, of which a first syntax element is auto-completed by the IDE tool without requiring user input explicitly specifying the entirety of the first syntax element, thereby avoiding any syntactic error in the first syntax element, wherein the IDE tool visually distinguishes different types of syntax elements from one another via different syntax colors for display; upon identification of a semantic error in a second of the plurality of syntax elements during evaluation of the embedded database statement, generating output visually conveying the identified semantic error and one or more auto-proposed fixes applicable, upon user selection via the IDE tool, to correct the identified semantic error, thereby improving a measure of efficiency of debugging the embedded database statement; and subsequent to correction of the identified semantic error, and responsive to receiving a request to compile the program source code, compiling the program source code in order to generate an application for execution, wherein the program source code is successfully compiled only upon identifying no compilation error in the program source code and no syntactic error and no semantic error in the embedded database statement; wherein the IDE tool is configured to identify;
(i) at least one syntactic error comprising a misspelled keyword and (ii) at least one semantic error comprising an incorrect table name or an incorrect column name. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13)
-
-
14. A computer program product comprising a non-transitory computer-readable medium having a program executable to perform an operation to debug database statements embedded in program source code, during development of the program source code and prior to successfully compiling the program source code, the operation comprising:
-
updating a graphical user interface (GUI) of an integrated development environment (IDE) tool during development of the program source code, wherein the GUI of the IDE tool is updated based on user input specifying to modify the program source code; upon detecting modification of the program source code to include a database statement embedded as a text string in the program source code, causing evaluation of the embedded database statement, wherein the embedded database statement contains a plurality of syntax elements of different types, of which a first syntax element is auto-completed by the IDE tool without requiring user input explicitly specifying the entirety of the first syntax element, thereby avoiding any syntactic error in the first syntax element, wherein the IDE tool visually distinguishes different types of syntax elements from one another via different syntax colors for display; upon identification of a semantic error in a second of the plurality of syntax elements during evaluation of the embedded database statement, generating output visually conveying the identified semantic error and one or more auto-proposed fixes applicable, upon user selection via the IDE tool, to correct the identified semantic error, thereby improving a measure of efficiency of debugging the embedded database statement; and subsequent to correction of the identified semantic error, and responsive to receiving a request to compile the program source code, compiling the program source code in order to generate an application for execution, wherein the program source code is successfully compiled only upon identifying no compilation error in the program source code and no syntactic error and no semantic error in the embedded database statement; wherein the IDE tool is configured to identify;
(i) at least one syntactic error comprising a misspelled keyword and (ii) at least one semantic error comprising an incorrect table name or an incorrect column name. - View Dependent Claims (15, 16, 17, 18, 19)
-
-
20. A system to debug database statements embedded in program source code, during development of the program source code and prior to successfully compiling the program source code, the system comprising:
-
one or more computer processors; a memory containing a program which, when executed by the one or more computer processors, performs an operation comprising; updating a graphical user interface (GUI) of an integrated development environment (IDE) tool during development of the program source code, wherein the GUI of the IDE tool is updated based on user input specifying to modify the program source code; upon detecting modification of the program source code to include a database statement embedded as a text string in the program source code, causing evaluation of the embedded database statement, wherein the embedded database statement contains a plurality of syntax elements of different types, of which a first syntax element is auto-completed by the IDE tool without requiring user input explicitly specifying the entirety of the first syntax element, thereby avoiding any syntactic error in the first syntax element, wherein the IDE tool visually distinguishes different types of syntax elements from one another via different syntax colors for display; upon identification of a semantic error in a second of the plurality of syntax elements during evaluation of the embedded database statement, generating output visually conveying the identified semantic error and one or more auto-proposed fixes applicable, upon user selection via the IDE tool, to correct the identified semantic error, thereby improving a measure of efficiency of debugging the embedded database statement; and subsequent to correction of the identified semantic error, and responsive to receiving a request to compile the program source code, compiling the program source code in order to generate an application for execution, wherein the program source code is successfully compiled only upon identifying no compilation error in the program source code and no syntactic error and no semantic error in the embedded database statement; wherein the IDE tool is configured to identify;
(i) at least one syntactic error comprising a misspelled keyword and (ii) at least one semantic error comprising an incorrect table name or an incorrect column name. - View Dependent Claims (21, 22, 23, 24)
-
Specification