Code completion for object relational mapping query language (OQL) queries

• US 8,429,601 B2
• Filed: 11/29/2007
• Issued: 04/23/2013
• Est. Priority Date: 11/29/2007
• Status: Active Grant

• Current Assignee: Red Hat, Inc. (International Business Machines Corporation)
• Original Assignee: Red Hat, Inc. (International Business Machines Corporation)
• Inventors: Andersen, Max Rydahl
• Primary Examiner(s): Dao, Thuy
• Assistant Examiner(s): Wang, Ben C
• Application Number:
  US11/947,711
• Publication Number:
  US 20090144696A1
• Time in Patent Office: 1,972 Days
• Field of Search: None
• US Class Current: 717/109
• CPC Class Codes: G06F 16/289 Object oriented databases
• CPC Class Codes: G06F 8/24 Object-oriented

Abstract

Techniques for developing database applications are described herein. According to one embodiment, an object-relational mapping (ORM) query language (OQL) statement is received via a first window which is entered from a user for querying an underlying database, where the OQL statement is written in a customized query language that is incompatible with the underlying database. In response, a SQL statement compatible with the underlying database is dynamically displayed in a second window, where the SQL statement is automatically translated from the OQL statement displayed in the first window. Other methods and apparatuses are also described.

Claims

1. A computer-implemented method, comprising:

performing error checking on a first query string to query an underlying database when receiving the first query string via a first querying-related window in a graphical user interface (GUI), wherein the first query string is written in a customized structured query language (SQL) and is incompatible with the underlying database;

translating, by a processing device, the first query string from customized SQL to a second query string that is a SQL statement written in standard SQL, the second query string being compatible with the underlying database;

displaying in a second querying-related window in the same GUI the second query string that is compatible with the underlying database, wherein executing the second query string queries the underlying database to create query results; and

displaying in a third querying-related window in the same GUI a result of executing the second query string against the underlying database,

wherein the first querying-related window, the second querying-related window, and the third querying-related window are displayed at a same time within a single instance of the same GUI comprising a plurality of querying-related windows.

2. The method of claim 1, wherein the second query string that is compatible with the underlying database is concurrently displayed in the second querying-related window in the GUI when receiving the first query string that is incompatible with the underlying database via the first querying-related window in the same GUI.

3. The method of claim 2, further comprising:

indicating that an error is detected using a squiggly line with a different color in the first querying-related window.

4. The method of claim 1, further comprising:

in response to an activation of a control associated with the first querying-related window in the GUI, executing the second query string against the underlying database.

5. The method of claim 4, further comprising:

receiving a selection of a result item of the result displayed in the third querying-related window in the GUI; and

in response to the selection, displaying in a fourth querying-related window in the same GUI one or more properties associated with the selected result item.

6. The method of claim 5, further comprising in response to an input from a user, displaying in a fifth querying-related window in the same GUI one or more parameters associated with the first query string.

7. The method of claim 6, wherein the first querying-related window, the second querying-related window, the third querying-related window, the fourth querying-related window, and the fifth querying-related window are displayed within a single instance of the same GUI comprising a plurality of querying-related windows.

8. A non-transitory machine-readable medium having instructions stored therein, which when executed by a processing device, cause the processing device to perform a method, the method comprising:

performing, by the processing device, error checking on a first query string to query an underlying database when receiving the first query string via a first querying-related window in a graphical user interface (GUI), wherein the first query string is written in a customized structured query language (SQL) and is incompatible with the underlying database;

translating, by the processing device, the first query string from customized SQL to a second query string that is a SQL statement written in standard SQL, the second query string being compatible with the underlying database;

displaying in a second querying-related window in the same GUI the second query string that is compatible with the underlying database, wherein executing the second query string queries the underlying database to create query results; and

displaying in a third querying-related window in the same GUI a result of executing the second query string against the underlying database,

wherein the first querying-related window, the second querying-related window, and the third querying-related window are displayed at a same time within a single instance of the same GUI comprising a plurality of querying-related windows.

9. The non-transitory medium of claim 8, wherein the second query string that is compatible with the underlying database is concurrently displayed in the second querying-related window in the GUI when receiving the first query string that is incompatible with the underlying database via the first querying-related window in the same GUI.

10. The non-transitory medium of claim 9, wherein the method further comprises:

indicating that an error is detected using a squiggly line with a different color in the first querying-related window.

11. The non-transitory medium of claim 8, wherein the method further comprises:

in response to an activation of a control associated with the first querying-related window in the GUI, executing the second query string against the underlying database.

12. The non-transitory medium of claim 11, wherein the method further comprises:

receiving a selection of a result item of the result displayed in the third querying-related window in the GUI; and

in response to the selection, displaying in a fourth querying-related window in the same GUI one or more properties associated with the selected result item.

13. The non-transitory medium of claim 12, wherein the method further comprises in response to an input from a user, displaying in a fifth querying-related window in the same GUI one or more parameters associated with the first query string.

14. The non-transitory medium of claim 13, wherein the first querying-related window, the second querying-related window, the third querying-related window, the fourth querying-related window, and the fifth querying-related window are displayed within a single instance of the same GUI comprising a plurality of querying-related windows.

15. A computer-implemented method, comprising:

receiving a selection of a query string via a first querying-related window in a graphical user interface (GUI) of an application, the first querying-related window for editing cross-platform programming language compatible query strings, wherein the selected query string is incompatible with a cross-platform programming language;

in response to receiving a selection of an editor, replicating, by a processing device, the selected query string into a second querying-related window for editing customized query strings using the selected editor and to enable a user to execute the customized query strings within the second querying-related window;

translating a first query string received via the first querying-related window to a second query string that is compatible with an underlying database;

displaying in a third querying-related window the second query string that is compatible with the underlying database; and

displaying in a fourth querying-related window a result of executing the second query string against the underlying database, wherein the first querying-related window, the second querying-related window, the third querying-related window and the fourth querying-related window are displayed at a same time within a single instance of the GUI, the GUI comprising a plurality of querying-related windows.

16. The method of claim 15, wherein the second querying-related window is part of a criteria editor.

17. The method of claim 15, further comprising:

performing error checking on the first query string when receiving the first query string via the second querying-related window in the GUI, wherein the first query string is incompatible with an underlying database and the first query string is an object-relational mapping (ORM) query language (OQL) statement to query the underlying database, and wherein the second query string is a structured query language (SQL) statement.

18. The method of claim 17, further comprising:

indicating that an error is detected using a squiggly line with a different color in the first querying-related window.

19. The method of claim 18, further comprising:

in response to an activation of a control associated with the second querying-related window in the GUI, executing the SQL statement against the underlying database.

20. The method of claim 19, further comprising:

receiving a selection of a result item of the result displayed in the fourth querying-related window in the GUI; and

in response to the selection, displaying in a fifth querying-related window in the same GUI one or more properties associated with the selected result item.

21. A system comprising:

a processing device; and

a memory coupled to the processing device and storing instructions that, when executed by the processing device, cause the processing device to;

perform error checking on a first query string to query an underlying database when receiving the first query string via a first querying-related window in a graphical user interface (GUI), wherein the first query string is written in a customized structured query language (SQL) and is incompatible with the underlying database,

translate the first query string from customized SQL to a second query string that is a SQL statement written in standard SQL, wherein the second query string is compatible with the underlying database,

display in a second querying-related window in the same GUI the second query string that is compatible with the underlying database, wherein executing the second query string queries the underlying database to create query results, and

display in a third querying-related window in the same GUI a result of executing the second query string against the underlying database,

wherein the first querying-related window, the second querying-related window, and the third querying-related window are displayed at a same time within a single instance of the same GUI comprising a plurality of querying-related windows.

22. The system of claim 21, wherein the second query string that is compatible with the underlying database is concurrently displayed in the second querying-related window in the GUI when receiving the first query string that is incompatible with the underlying database via the first querying-related window in the same GUI.