0 views collected around this technical thread.
This article demonstrates how to wrap MySQL database connections, create reusable assertion functions, parameterize test cases, validate JSON responses, and integrate logging with Loguru to build a maintainable and efficient Pytest‑based API automation framework.
This article demonstrates how the MySQL LIKE clause can give misleading results when filtering triggers, walks through a step‑by‑step lab that creates tables and triggers, shows the pitfalls of LIKE, and presents a safer WHERE‑based method for retrieving trigger definitions.
This article introduces five common Python automated testing scenarios—unit testing, API testing, web UI testing, performance testing, and database testing—providing clear explanations and complete code examples to help developers improve software quality and stability.
Database testing ensures data integrity, security, and quality by validating data mapping, ACID properties, schema, triggers, stored procedures, and field constraints through both manual and automated methods, using SQL queries, CRUD operations, and specialized tools to verify that applications interact correctly with underlying databases.
This article documents a practical test of MySQL Enterprise Backup 4.0, examining whether the tool can perform remote physical backups using the --host option, describing the test environment, commands, observed behaviours for both local and remote scenarios, and the conclusions drawn from the results.
The article describes a prototype system that automatically discovers bugs in large distributed databases by instrumenting code, generating massive SQL test cases, statistically analyzing execution paths, visualizing suspicious blocks, and integrating insights from academic papers to guide future debugging and testing efforts.
This article provides a comprehensive overview of the MySQL Test Run (MTR) framework, detailing its two-part architecture consisting of Perl scripts for control flow and C++ binaries for test execution, along with the complete execution process and framework design.
This guide introduces the dbdeployer tool, walks through its installation on macOS/Linux, shows how to configure sandbox paths, download MySQL binaries, and deploy various MySQL topologies such as single nodes, master‑slave replication, and group replication with one‑click commands.
This article explains how to leverage simple Bash shell scripts to automate database testing tasks such as creating, inserting, updating, and monitoring tables in MySQL, providing step‑by‑step guidance, code examples, and best practices for efficient test automation.
This article explains how to use Bash shell scripts on Linux to automate MySQL database testing tasks such as creating tables, inserting, updating, and monitoring dynamic database states, providing step‑by‑step code examples and execution instructions for efficient test automation.