mysql-shell-client 0.9.0

Python client for MySQL Shell

MySQL Shell Python client

MySQL Shell is an advanced client for MySQL Server that allow system administrator to perform both cluster and instance level operations, using a single binary.

This project provides a Python client to perform the most common set of operations, in addition to a set of predefined queries to cover most of the common use-cases.

🧑‍💻 Usage

1. Install MySQL Shell.

2. Install the package from PyPi:

   pip install mysql-shell-client
   

3. Import and build the executors:

   from mysql_shell.executors import LocalExecutor
   from mysql_shell.models import ConnectionDetails
   
   cluster_conn = ConnectionDetails(
       username="...",
       password="...",
       host="...",
       port="...",
   )
   instance_conn = ConnectionDetails(
       username="...",
       password="...",
       host="...",
       port="...",
   )
   
   cluster_executor = LocalExecutor(cluster_conn, "mysqlsh")
   instance_executor = LocalExecutor(instance_conn, "mysqlsh")
   

4. Import and build the query builders [optional]:

   from mysql_shell.builders import CharmLockingQueryBuilder
   
   # This is just an example
   builder = CharmLockingQueryBuilder("mysql", "locking")
   query = builder.build_table_creation_query()
   rows = instance_executor.execute_sql(query)
   

5. Import and build the clients:

   from mysql_shell.builders.quoting import StringQueryQuoter
   from mysql_shell.clients import MySQLClusterClient, MySQLInstanceClient
   
   quoter = StringQueryQuoter()
   
   cluster_client = MySQLClusterClient(cluster_executor, quoter)
   instance_client = MySQLInstanceClient(instance_executor, quoter)
   

🔧 Development

Dependencies

In order to install all the development packages:

poetry install --all-extras

Linting

All Python files are linted using Ruff, to run it:

tox -e lint

Testing

Project testing is performed using Pytest, to run them:

tox -e unit

export MYSQL_DATABASE="test"
export MYSQL_USERNAME="root"
export MYSQL_PASSWORD="root_pass"
export MYSQL_SHELL_PATH="mysqlsh"

sudo --preserve-env docker compose -f compose/mysql-8.0.yaml up --wait && tox -e integration
sudo --preserve-env docker compose -f compose/mysql-8.0.yaml down

Release

Commits can be tagged to create releases of the package, in order to do so:

1. Bump up the version within the pyproject.toml file.
2. Add a new section to the CHANGELOG.md.
3. Commit + push the changes.
4. Trigger the release workflow.