Abstract: Aspects of the disclosure are directed to pre-seeding test databases in a computing environment for software testing. A system manages a pool of pre-seeded databases to serve user devices with different database requirements for their integration testing needs. Pre-seeded databases can be served more efficiently over empty databases that are populated client-side. From a user perspective, databases appear ready instantly, ready for use as part of testing software using the pre-seeded databases as a stand-in for production data. Pre-seeding databases circumvents the issues of wasted time and potential error that are otherwise possible when databases are served and populated client-side. Pre-seeding data mitigates the need to seed the database during test-time, reducing the integration test cycle for software being tested. Aspects of the disclosure provide for real-time restoration of databases by fixing portions of the database in place instead of outright deletion and recreation of an entire database.

Abstract: Aspects of the disclosure are directed to pre-seeding test databases in a computing environment for software testing. A system manages a pool of pre-seeded databases to serve user devices with different database requirements for their integration testing needs. Pre-seeded databases can be served more efficiently over empty databases that are populated client-side. From a user perspective, databases appear ready instantly, ready for use as part of testing software using the pre-seeded databases as a stand-in for production data. Pre-seeding databases circumvents the issues of wasted time and potential error that are otherwise possible when databases are served and populated client-side. Pre-seeding data mitigates the need to seed the database during test-time, reducing the integration test cycle for software being tested. Aspects of the disclosure provide for real-time restoration of databases by fixing portions of the database in place instead of outright deletion and recreation of an entire database.

Abstract: A method of populating a test environment for integration testing of a production database. The production database includes a plurality of tables, and may be represented by a directed acyclic graph (DAG), in which each of the plurality of tables is represented by a respective node of the DAG and schema-level constraints of the plurality of tables are represented by edges of the DAG. The method may involve constructing the DAG, topologically ordering the plurality of tables of the production database according to the DAG, randomly generating test data in accordance with the schema-level constraints of the plurality of tables, and populating the randomly generated test data to the test environment according to the topological ordering of the plurality of tables.

Abstract: A method of copying a production database to a test environment using one or more processors. The production database includes a plurality of tables and one or more constraints indicating interleaving of the plurality of tables. The method involves constructing a directed acyclic graph (DAG) of the plurality of tables, whereby each table is represented by a respective node of the DAG and interleaving of the tables is represented by edges of the DAG, topologically ordering the tables according to the DAG, and copying data from the production database to the test environment according to the topological ordering of the tables.

Abstract: A method of copying a production database to a test environment using one or more processors. The production database includes a plurality of tables and one or more constraints indicating interleaving of the plurality of tables. The method involves constructing a directed acyclic graph (DAG) of the plurality of tables, whereby each table is represented by a respective node of the DAG and interleaving of the tables is represented by edges of the DAG, topologically ordering the tables according to the DAG, and copying data from the production database to the test environment according to the topological ordering of the tables.

Abstract: Aspects of the disclosure are directed to populating test datastores in a computing environment for integration testing. A datastore populator system identifies the datastore relationships between tables of multiple different datastores and populates data according to those identified relationships when the relationships are not explicitly defined by a database schema or documentation. A datastore relationship can refer to data shared across the same or different datastores. Aspects of the disclosure provide for identifying those implicit relationships for populating test datastores for use in testing a service or application, to accurately simulate the interaction between multiple relational datastores. Relationships between values of columns across tables may be referred to as invisible foreign key relationships.

Abstract: A method of copying a production database to a test environment using one or more processors. The production database includes a plurality of tables and one or more constraints indicating interleaving of the plurality of tables. The method involves constructing a directed acyclic graph (DAG) of the plurality of tables, whereby each table is represented by a respective node of the DAG and interleaving of the tables is represented by edges of the DAG, topologically ordering the tables according to the DAG, and copying data from the production database to the test environment according to the topological ordering of the tables.

Abstract: A method of populating a test environment for integration testing of a production database. The production database includes a plurality of tables, and may be represented by a directed acyclic graph (DAG), in which each of the plurality of tables is represented by a respective node of the DAG and schema-level constraints of the plurality of tables are represented by edges of the DAG. The method may involve constructing the DAG, topologically ordering the plurality of tables of the production database according to the DAG, randomly generating test data in accordance with the schema-level constraints of the plurality of tables, and populating the randomly generated test data to the test environment according to the topological ordering of the plurality of tables.

Abstract: A method, non-transitory computer readable medium, and apparatus for facilitating communication of presence information includes establishing a connection with at least one client computing device upon receiving a request for presence information from the client computing device. The request for presence information is inserted into a first queue. A response message is asynchronously obtained from a second queue maintained by a session server. The response message is sent to the client computing device according to the established connection.