ORM database Store Extension for API Testing
This project provides an ORM-based database store extension for API testing, simplifying data storage and retrieval operations. It supports various databases including SQLite, MySQL, PostgreSQL, TDengine, and others, making it versatile for different testing environments.
- Simplified database operations using ORM.
- Integration with API testing frameworks.
- Support for multiple databases (SQLite, MySQL, PostgreSQL, TDengine, etc.).
To use this extension in your API testing project, follow these steps:
- Install the necessary dependencies.
- Configure the database connection settings.
- Integrate the extension into your API tests.
You can quickly set up a MySQL-compatible database using TiUP Playground:
-
Install TiUP (if not already installed):
curl --proto '=https' --tlsv1.2 -sSf https://tiup.io/install.sh | sh source ~/.profile
-
Start a TiDB (MySQL-compatible) cluster:
tiup playground
This will launch a local TiDB cluster with default settings.
-
Connect to TiDB using the MySQL client:
mysql -h 127.0.0.1 -P 4000 -u root
Now you can create databases, tables, and run SQL queries as you would with MySQL.
For more details, see the TiUP Playground documentation.
Run the command apt-get install build-essential libsqlite3-dev
if you meet the sqlite errors.