pyheimdall-mysql 1.1.0

MySQL connector for pyHeimdall

What is this?

pyHeimdall is a tool for converting more easily one or more databases from one format to another. It leverages modules called “connectors”, responsible for conversion of data between specific databases schemas and the HERA format.

This repository implements a connector to retrieve data from a MySQL database. The implementation doesn’t need any intervention on pyHeimdall proper.

How can I use it?

Setup

This MySQL pyHeimdall connector is available as a PyPI package named pyheimdall-mysql. You can install it using the pip package manager:

pip install pyheimdall-mysql

You can use pip to either upgrade or uninstall this connector, too:

pip install --upgrade pyheimdall-mysql
pip uninstall pyheimdall-mysql

Usage

import heimdall

tree = heimdall.getDatabase(
        format='sql:mysql',
        url='mysql://myusername:mypassword@myhost:myport/mydatabase',
        entities=('mytable', 'myothertable', ),
        )
heimdall.createDatabase(tree, format='hera:xml', url='mydatabase.xml')

Please note that you don’t need to use pyheimdall-mysql functions directly. As long as the package is installed on your system, pyHeimdall will automatically discover its features and allow you to use them as long as any other default or external connector.

Is it tested?

Of course! Here’s the coverage report.

Please note, however, than this coverage report is produced by a continuous integration (CI). This CI relies in part on third party tools which are not MySQL, but MariaDB. At the time of writing, MySQL and MariaDB still have a lot in common, but this may not be the case when you’ll read these lines.

Moreover, as time goes by, the MySQL tools used by our CI will become outdated, and we don’t plan to maintain them up to date as, still at the time of writing, it’s becoming increasingly difficult to easily deploy MySQL instead of MariaDB, and the existing ways are subject to Oracle’s whim.

In other words, this connector should work on your MySQL database, but we can’t guarantee it on the long term. If you detect an issue, and/or can provide a solution, feel free to contribute!

For an alternative, consider using MariaDB, and the connector pyheimdall-mariadb.

How can I contribute?

This project welcomes any feedback or proposal. Details can be accessed here

License

GNU Affero General Public License version 3.0 or later

This project is not affiliated, associated, authorized, endorsed by, or in any way officially connected with MySQL or Oracle, or any of its subsidiaries or its affiliates. The official MySQL website can be found at https://www.mysql.com/. The name MySQL as well as related names, marks, emblems and images, are registered trademarks of Oracle.