Test Development Learning Exchange
Learn how to diagnose and permanently fix MySQL character set problems—like garbled Chinese text or missing emoji—by checking current settings, altering databases and tables to utf8mb4, updating the my.cnf configuration, and avoiding common pitfalls, all with clear command examples.
This guide outlines a systematic, shift‑left testing strategy—from early requirement reviews and test‑case design to layered regression automation, rigorous execution, pre‑release quality assessment, and post‑release monitoring—enabling teams to act as effective quality gatekeepers and ensure stable software deliveries.
Learn how to create a local Flask-based mock payment callback server that validates signatures, returns standardized responses for platforms like WeChat and Alipay, includes a recommended project structure, detailed code examples, testing with pytest, and tips for extending functionality and exposing it via ngrok.
This guide walks you through building a full‑stack Python solution for automating payment interface tests, covering workflow validation, status checks, database assertions, third‑party integration, async callbacks, and secure signing, with detailed code examples and best‑practice recommendations.
This guide walks you through configuring Loguru for dev, test, and prod environments, adding dynamic log levels, colorized console output, file rotation, JSON serialization, remote extensions, and packaging the logger as a reusable Python module.
This guide introduces Loguru, a modern Python logging library that replaces the standard logging module with a concise API, automatic coloring, thread‑safe operation, file rotation, JSON output, and extensive configuration options, providing clear examples, advanced settings, testing integration, and best‑practice project structures.
This guide introduces UltraJSON (ujson), a high‑performance C‑based JSON library for Python, covering why it outperforms the built‑in json module, installation steps, core API usage, advanced features, performance benchmarks, typical use cases, and best‑practice encapsulation for enterprise projects.
This guide explains how to use Python's cursor.execute with positional and named placeholders, demonstrates safe practices with SQLite, psycopg2, and SQLAlchemy, and shows how to generate log‑friendly SQL strings while preventing injection attacks.
Learn how to create a modular Python API testing framework using httpx, pytest, and Allure, featuring multi‑environment configuration, synchronous and asynchronous requests, data‑driven and mock testing, comprehensive logging, and automated report generation, plus optional extensions for CI/CD, token authentication, and coverage analysis.
This guide demonstrates how to create a reusable Python testing framework that encapsulates generic API response assertions, database query utilities, supports chainable calls, logging, exception handling, and integrates seamlessly with pytest or unittest, including installation steps, project structure, core code examples, and execution instructions.
