Programming language independent software testing environment
Provided are systems and methods for programming language independent application development via test data stored in a database. In one example, the method includes receiving a database command from an application, the database command including a location and an access request for data at the location, determining if the application is operating in a test mode, and accessing data from a database based on the database command, wherein the accessing data comprises accessing test data stored in a test data storage based on the location included in the database command if the application is operating in the test mode, and accessing real data stored in a real data storage based on the location included in the database command if the application is not operating in test mode.
1. A computing system comprising:
a database comprising hardware that includes a test data storage and a real data storage; and
an access determination manager implemented within the database, the access determination manager configured to:
receive a database command from an application written in a first programming language, the database command comprising a table identifier that identifies a name of a first table that is routable within the real data storage and identifies a name of a second table that is routable within the test data storage and which shares a same name as the first table,
determine that the application written in the first programming language is operating in a test mode,
route an access request to the second table in the test data storage based on the table identifier in the database command,
receive a second database command from an application written in a second programming language that is different than the first programming language, where the second database command comprises the table identifier,
determine that the application written in the second programming language is operating in the test mode, and
route a second access request to the second table in the test data storage based on the table identifier.
2. The computing system of claim 1 , wherein the test data storage comprises table names that mirror table names of the real data storage, and the table identifier included in the database command corresponds to a table name that is accessible in both the test data storage and the real data storage.
3. The computing system of claim 1 , wherein the database command further comprises at least one of a row and column identifier.
4. The computing system of claim 1 , wherein the database comprises a programming language independent database in which the second table in the test data storage is accessible by an SQL command from applications written in different programming languages.
5. The computing system of claim 4 , wherein the second table in the test data storage is accessible by an application that is written in Java and an application that is written in Advanced Business Application Programming (ABAP).
6. The computing system of claim 1 , wherein the access determination manager is configured to determine that the database is operating in the test mode based on a parameter that is transferred from the application written in the first programming language to the database.
7. The computing system of claim 1 , wherein the access determination manager is configured to determine that the database is operating in the test mode based on at least one of a user associated with the application written in the first programming language and a system associated with the application written in the first programming language.
8. The computing system of claim 1 , wherein the access determination manager is configured to determine that the application written in the first programming language is operating in the test mode based on a table included in the location of the database command.
9. The computing system of claim 1 , wherein the database comprises a table corresponding to the table identifier, and the table includes a real data persistency and a test data persistency that mirrors the real data persistency.
10. A method comprising:
receiving, via at least one of a circuit and a logic implemented within a database, a database command from an application written in a first programming language, the database command comprising a table identifier that identifies a name of a first table that is routable within a real data storage and identifies a name of a second table that is routable within a test data storage and which shares a same name as the first table;
determining that the application written in the first programming language is operating in a test mode;
routing an access request to the second table in the test data storage based on the table identifier in the database command,
receiving a second database command from an application written in a second programming language that is different than the first programming language, where the second database command comprises the table identifier,
determining that the application written in the second programming language is operating in the test mode, and
routing a second access request to the second table in the test data storage based on the table identifier.
11. The method of claim 10 , wherein the test data storage comprises table names that mirror table names of the real data storage, and the table identifier included in the database command corresponds to a table name that is accessible in both the test data storage and the real data storage.
12. The method of claim 10 , wherein the database command further comprises at least one of a row and column identifier.
13. The method of claim 10 , wherein the database comprises a programming language independent database in which the second table in the test data storage is accessible by an SQL command from applications written in different than the first programming languages.
14. The method of claim 13 , wherein the second table in the test data storage is accessible by an application that is written in Java and an application that is written in Advanced Business Application Programming (ABAP).
15. The method of claim 10 , wherein the determining comprises determining that the database is operating in the test mode based on a parameter that is transferred from the application written in the first programming language to the database.
16. The method of claim 10 , wherein the determining comprises determining that the database is operating in the test mode based on at least one of a user associated with the application written in the first programming language and a system associated with the application written in the first programming language.
17. The method of claim 10 , wherein the determining comprises determining that the application written in the first programming language is operating in the test mode based on a table included in the location of the database command.
18. A non-transitory computer readable medium having instructions that when executed cause a computer to perform a method comprising:
receiving, via at least one of a circuit and a logic implemented within a database, a database command from an application written in the first programming language, the database command comprising a table identifier that identifies a name of a first table that is routable within a real data storage and identifies a name of a second table that is routable within a test data storage and which shares a same name as the first table;
determining that the application written in the first programming language is operating in a test mode; and
routing an access request the second table in the test data storage based on the table identifier in the database command,
receiving a second database command from an application written in a second programming language that is different than the first programming language, where the second database command comprises the table identifier,
determining that the application written in the second programming language is operating in the test mode, and
routing a second access request to the second table in the test data storage based on the table identifier.
19. The non-transitory computer-readable medium of claim 18 , wherein the test data storage comprises table names that mirror table names of the real data storage, and the table identifier included in the database command corresponds to a table name that is accessible in both the test data storage and the real data storage.
20. The non-transitory computer-readable medium of claim 18 , wherein the database command further comprises at least one of a row and column identifier.
21. The non-transitory computer-readable medium of claim 18 , wherein the test data storage comprises a programming language independent test database in which the second table in the test data storage is accessible by an SQL command from applications written in different programming languages.