Re-executing query objects without affecting transaction data in an application development framework not providing for creation of multiple instances of the same query object

Abstract

Re-executing query objects without affecting transaction data in an application development framework (ADF) not providing for creation of multiple instances of the same query object. In an embodiment, a query associated with a query object is executed to retrieve a transaction data from a data store, which can be further modified based on user interactions. In response to an indication that the query object is to be re-executed for retrieving the transaction data, a new query object is created using the query (along with any required parameters) retrieved from the original query object. The new query object is executed to retrieve a copy of the transaction data from the data store. According to another aspect, a comparison result is generated for the modified transaction data and the copy.

1. A non-transitory computer readable medium storing executable code which can be executed by one or more processors of a system, said executable code comprising:
 a first set of instructions providing an application development framework (ADF) for executing query objects, wherein each query object specifies a corresponding query and also a corresponding entity object (EO) to be used for storing the results of processing of the corresponding query, 
 wherein an instance of the query object is required for execution of said corresponding query specified in the query object, wherein said ADF does not provide for multiple instances of the same query object; 
 a second set of instructions forming at least a portion of an application executing in the context of said ADF, said application comprising a plurality of query objects including a first query object, wherein said first query object specifies a first query and a first EO, 
 some of said second set of instructions upon processing by said one or more processors cause creation of a first query instance of said first query object, execution of said first query in said first query instance to retrieve a first transaction data from a data store as a first EO instance of said first EO, and to modify said first transaction data to form a modified transaction data in said first EO instance, 
 wherein said ADF does not provide for another instance of said first query object and re-execution of said first query in said first query instance is designed to cause retrieval of said first transaction data again into said first EO instance to thereby overwrite said modified transaction data; and 
 a third set of instructions upon execution by said one or more processors causes said system to perform the actions of:
 retrieve said first query associated with said first query instance along with a first set of parameters required to execute said first query; 
 create a new instance of a new query object using said retrieved first query, wherein said new query object has a different name compared to the name of said first query object and also specifies said first EO; 
 store said retrieved first set of parameters in said new instance of said new query object; and 
 execute said first query in said new instance in the context of said ADF to retrieve another copy of said first transaction data from said data store as a second EO instance of said first EO, 
 whereby said another copy of said first transaction data is retrieved without creating said another instance of said first query object and also without overwriting said modified transaction data in said first EO instance. 
 
 
     
     
       2. The non-transitory computer readable medium of  claim 1 , wherein said first set of parameters are maintained in said first query instance and wherein said retrieve retrieves said first set of parameters from said first query instance. 
     
     
       3. The non-transitory computer readable medium of  claim 2 , wherein said data store comprises a relational database, wherein each row of a first table in said relational database is retrieved into a corresponding instance of the first EO upon execution of said first query specified in said first query object,
 wherein said first transaction data retrieved into said first EO instance and said second EO instance comprises data stored in a first row of said first table in said relational database. 
 
     
     
       4. The non-transitory computer readable medium of  claim 3 , wherein said first query is according to structured query language (SQL). 
     
     
       5. The non-transitory computer readable medium of  claim 1 , wherein said application comprises a code module which generates an indication that said another copy is to be retrieved from said data store and said actions are performed in response to said indication. 
     
     
       6. The non-transitory computer readable medium of  claim 5 , wherein each of said modified transaction data in said first EO instance and said another copy in said second EO instance comprise a same set of attributes, wherein each attribute has an associated value, said code module is designed to perform the further actions of:
 retrieve a first set of values corresponding to said same set of attributes in said modified transaction data and a second set of values corresponding to said same set of attributes in said another copy of said first transaction data; 
 compare said first set of values with the respective ones of said second set of values; and 
 generate a result of comparison for each of said same set of attributes. 
 
     
     
       7. The non-transitory computer readable medium of  claim 6 , wherein said result corresponding to a first attribute indicates an old value and a modified value,
 wherein said old value is contained in said first set of values and said modified value is contained in said second set of values associated with said first attribute, 
 wherein said first attribute is contained in said same set of attributes. 
 
     
     
       8. The non-transitory computer readable medium of  claim 1 , wherein said application is developed using said ADF. 
     
     
       9. The non-transitory computer readable medium of  claim 8 , wherein said application comprises a view layer, a controller layer, a model layer and a business service layer. 
     
     
       10. A digital processing system comprising:
 a processor; 
 a random access memory (RAM); and 
 a machine readable medium storing a first set of instructions, a second set of instructions and a third set of instructions, 
 wherein said first set of instructions when retrieved into said RAM and executed by said processor provides an application development framework (ADF) for executing query objects, wherein each query object specifies a corresponding query and also a corresponding entity object (EO) to be used for storing the results of processing of the corresponding query, 
 wherein an instance of the query object is required for execution of said corresponding query specified in the query object, wherein said ADF does not provide for multiple instances of the same query object; 
 wherein said second set of instructions when retrieved into said RAM and executed by said processor forms at least a portion of an application executing in the context of said ADF, said application comprising a plurality of query objects including a first query object, wherein said first query object specifies a first query and a first EO, 
 some of said second set of instructions upon processing by said processor cause creation of a first query instance of said first query object, execution of said first query in said first query instance to retrieve a first transaction data from a data store as a first EO instance of said first EO, and to modify said first transaction data to form a modified transaction data in said first EO instance, 
 wherein said ADF does not provide for another instance of said first query object and re-execution of said first query in said first query instance is designed to cause retrieval of said first transaction data again into said first EO instance to thereby overwrite said modified transaction data; and 
 wherein said third set of instructions when retrieved into said RAM and executed by said processor causes said digital processing system to perform the actions of:
 retrieve said first query associated with said first query instance along with a first set of parameters required to execute said first query; 
 create a new instance of a new query object using said retrieved first query, wherein said new query object has a different name compared to the name of said first query object and also specifies said first EO; 
 store said retrieved first set of parameters in said new instance of said new query object; and 
 execute said first query in said new instance in the context of said ADF to retrieve another copy of said first transaction data from said data store as a second EO instance of said first EO, 
 whereby said another copy of said first transaction data is retrieved without creating said another instance of said first query object and also without overwriting said modified transaction data in said first EO instance. 
 
 
     
     
       11. The digital processing system of  claim 10 , wherein said first set of parameters are maintained in said first query instance and wherein said retrieve retrieves said first set of parameters from said first query instance. 
     
     
       12. The digital processing system of  claim 11 , wherein said data store comprises a relational database, wherein each row of a first table in said relational database is retrieved into a corresponding instance of the first EO upon execution of said first query specified in said first query object,
 wherein said first transaction data retrieved into said first EO instance and said second EO instance comprises data stored in a first row of said first table in said relational database. 
 
     
     
       13. The digital processing system of  claim 12 , wherein said first query is according to structured query language (SQL). 
     
     
       14. The digital processing system of  claim 10 , wherein said application comprises a code module which generates an indication that said another copy is to be retrieved from said data store and said actions are performed in response to said indication. 
     
     
       15. The digital processing system of  claim 14 , wherein each of said modified transaction data in said first EO instance and said another copy in said second EO instance comprise a same set of attributes, wherein each attribute has an associated value, said code module is designed to perform the further actions of:
 retrieve a first set of values corresponding to said same set of attributes in said modified transaction data and a second set of values corresponding to said same set of attributes in said another copy of said first transaction data; 
 compare said first set of values with the respective ones of said second set of values; and 
 generate a result of comparison for each of said same set of attributes. 
 
     
     
       16. The digital processing system of  claim 15 , wherein said result corresponding to a first attribute indicates an old value and a modified value,
 wherein said old value is contained in said first set of values and said modified value is contained in said second set of values associated with said first attribute, 
 wherein said first attribute is contained in said same set of attributes. 
 
     
     
       17. The digital processing system of  claim 10 , wherein said application is developed using said ADF. 
     
     
       18. The digital processing system of  claim 17 , wherein said application comprises a view layer, a controller layer, a model layer and a business service layer.