Design And Implementation Of A Test Database Generation Tool

With the rapid development of information technology, applications of the database areincreasingly widespread. In the testing of large-scale projects, database stored data that programneeded. It is the data source of achieving program features. In process of automated testing,usually need to prepare for the test database, need for handling data in the test database, such asinsert, find, delete, update, and other operations. If it is a large project, the database is related tothe sub-library and sub-table. If performance testing, you need to import or export a largeamount of data in the database. The interactive ways of the test database and automated testingplatform have SQL generates test environment, the hard-coded program, RQP method, SQLgenerates test environment is semi-automatic, and not easy to extend and reuse. Hard-coded istedious and has bad transplanting. RQP method does not provide a strong enough APIs to testers,did not take into account the distributed databases exist, it is impossible to achieve import andexport bulk data, and only for data generation.To the problems of automated testing tools about test database currently, the face of theabove requirements, design, research and development of a test database automated testingtools is needed, the tool is driven by the test script, and achieved automatically inserted,delete, search, update and other operations of database. Realized sub-library and sub-table ofthe database, import and export bulk data of the database, based on the performance andefficiency considerations, realized a database session pool, and the tools provide a powerfuland rich APIs. These features make the automated test tool function better, more stableperformance, faster execution speed. Combine ORM and python object-oriented features,tools adopted ideas and methods of the object-oriented design. This made tools easier to use,convenient, and has a good user experience.Through specific scenarios and validation analysis, in the time of database automationconnection, the tool is through the session pool to achieve efficient database access. Wheninsert, delete and find data, achieving sub-library sub-table, be transparent to the user. Thetool provides a rich API interface well to meet the needs of the user operations of the testdatabase. Finally, through a specific application scenario, prove the tool can be combinedwell with test platform.