CSV-Based Test Data Automation for Mobile Infrastructure
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Setting up test fixtures for mobile infrastructure-based solutions is challenging due to authority restrictions and complexity in data management, particularly in XML format, which hinders effective test automation and data maintenance, especially during application migration.
Innovation Solution
A test automation method that uses Comma Separated Value (CSV) files to simulate data exchange messages between the server and client, allowing easy maintenance and migration, with a data capturer tool to create and validate test data repositories, and integrates with JUnit for test case management.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If test fixtures are set up using XML format data exchange messages, then data exchange between server and client can be simulated, but data maintenance becomes complex and difficult during application migration
Solution Approach 1:
The patent uses CSV files as a simplified copy representation of the actual XML data exchange messages. Instead of maintaining complex XML structures with full messaging protocols, the invention creates lightweight CSV copies that capture essential data relationships and can be easily edited with standard tools like Excel, thereby maintaining reliability while dramatically improving ease of maintenance
Solution Approach 2:
The patent changes the data format parameter from XML to CSV, transforming the structure from hierarchical markup with nested elements to a flat, comma-separated format. This parameter change enables the use of simple spreadsheet applications for data maintenance while preserving the ability to simulate data exchange messages through controlled conversion processes
2Loss of information
If data is maintained in XML format, then complete data structure information is preserved, but significant efforts are required for data maintenance and migration
Solution Approach 1:
The invention creates simplified CSV copies of the XML data structures that contain only the essential information needed for test data maintenance. These copies can be easily created, modified, and maintained using spreadsheet applications, significantly reducing the time required for data maintenance while preserving the critical data structure information needed for test purposes
Solution Approach 2:
The patent extracts only the essential data elements from the complete XML structure into CSV format, removing unnecessary markup and hierarchical complexity. This extraction process creates a leaner representation that maintains the core data relationships and structure information needed for testing while eliminating the maintenance burden of full XML formatting
3Quantity of substance
If test fixtures are created from server side, then complete data sets can be provided, but complexity and data dependencies make it difficult to set up and reproduce fixed data sets
Solution Approach 1:
The patent segments the test data into separate CSV files organized by functional area or data type, rather than maintaining monolithic server-side data fixtures. This segmentation allows each data set to be independently created, maintained, and reproduced without dealing with the complexity of complete server-side dependencies, while still providing comprehensive test data coverage
Data Source
AI summary
A method for testing a software program creates test data by simulating data exchange messages between a server and a client and stores test data in Comma Separated Value (CSV) files. Data repository files stored in the CSV format can be edited by common tools, like a spreadsheet program, and can be maintained easily. The test automation method provides a data capturer tool so that the data repository could be created based on any existing test environment. The test automation method converts data repository files and simulates messages in order to load data to a mobile infrastructure system and set up data fixtures. The test automation method could be integrated in a build process so that data repository and test cases are validated against any program changes periodically.