##########################
Heimdall - MySQL connector
##########################
.. image:: https://img.shields.io/badge/license-AGPL3.0-informational?logo=gnu&color=success
:target: https://www.gnu.org/licenses/agpl-3.0.html
.. image:: https://www.repostatus.org/badges/latest/active.svg
:target: https://www.repostatus.org/#project-statuses
.. image:: https://img.shields.io/pypi/v/pyheimdall-mysql
:target: https://pypi.org/project/pyheimdall-mysql/
:alt: PyPI Version
.. image:: https://img.shields.io/badge/documentation-api-green
:target: https://datasphere.readthedocs.io/projects/heimdall/
.. image:: https://gitlab.huma-num.fr/datasphere/heimdall/connectors/mysql/badges/main/pipeline.svg
:target: https://gitlab.huma-num.fr/datasphere/heimdall/connectors/mysql/pipelines/latest
.. image:: https://gitlab.huma-num.fr/datasphere/heimdall/connectors/mysql/badges/main/coverage.svg
:target: https://datasphere.gitpages.huma-num.fr/heimdall/connectors/mysql/coverage/index.html
*************
What is this?
*************
`pyHeimdall <https://datasphere.readthedocs.io/projects/heimdall/>`_ 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 <https://pypi.org/project/pyheimdall-mysql/>`_ named ``pyheimdall-mysql``.
You can install it using the `pip <https://pip.pypa.io/en/stable/>`_ package manager:
.. code-block:: bash
pip install pyheimdall-mysql
You can use `pip <https://pip.pypa.io/en/stable/>`_ to either upgrade or uninstall this connector, too:
.. code-block:: bash
pip install --upgrade pyheimdall-mysql
pip uninstall pyheimdall-mysql
Usage
=====
.. code-block:: python
import heimdall
tree = heimdall.getDatabase(
format='sql:mysql',
url='mysql://myusername:mypassword@myhost:myport/mydatabase',
entities=('mytable', 'myothertable', ),
)
heimdall.createDatabase(tree, format='xml:hera', 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 <https://gitlab.huma-num.fr/datasphere/heimdall/python/-/tree/main/src/heimdall/connectors>`_ or `external <https://gitlab.huma-num.fr/datasphere/heimdall/connectors>`_ connector.
*************
Is it tested?
*************
Of course!
Here's `the coverage report <https://datasphere.gitpages.huma-num.fr/heimdall/connectors/mysql/coverage/index.html>`_.
| 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 <https://mariadb.org/>`_.
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 <https://gitlab.huma-num.fr/datasphere/heimdall/python/-/blob/main/CONTRIBUTING.rst>`_
*******
License
*******
`GNU Affero General Public License version 3.0 or later <https://choosealicense.com/licenses/agpl/>`_
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.
Raw data
{
"_id": null,
"home_page": null,
"name": "pyheimdall-mysql",
"maintainer": null,
"docs_url": null,
"requires_python": null,
"maintainer_email": null,
"keywords": "databases, hera, interoperability",
"author": null,
"author_email": "R\u00e9gis Witz <regis.witz@cnrs.fr>",
"download_url": "https://files.pythonhosted.org/packages/a8/85/ff5daaa6a38820f679aa981c014fb2c06cf29007826e1e38c5ef9ed260bf/pyheimdall_mysql-1.0.0.tar.gz",
"platform": null,
"description": "##########################\nHeimdall - MySQL connector\n##########################\n\n.. image:: https://img.shields.io/badge/license-AGPL3.0-informational?logo=gnu&color=success\n :target: https://www.gnu.org/licenses/agpl-3.0.html\n.. image:: https://www.repostatus.org/badges/latest/active.svg\n :target: https://www.repostatus.org/#project-statuses\n.. image:: https://img.shields.io/pypi/v/pyheimdall-mysql\n :target: https://pypi.org/project/pyheimdall-mysql/\n :alt: PyPI Version\n.. image:: https://img.shields.io/badge/documentation-api-green\n :target: https://datasphere.readthedocs.io/projects/heimdall/\n.. image:: https://gitlab.huma-num.fr/datasphere/heimdall/connectors/mysql/badges/main/pipeline.svg\n :target: https://gitlab.huma-num.fr/datasphere/heimdall/connectors/mysql/pipelines/latest\n.. image:: https://gitlab.huma-num.fr/datasphere/heimdall/connectors/mysql/badges/main/coverage.svg\n :target: https://datasphere.gitpages.huma-num.fr/heimdall/connectors/mysql/coverage/index.html\n\n\n*************\nWhat is this?\n*************\n\n`pyHeimdall <https://datasphere.readthedocs.io/projects/heimdall/>`_ is a tool for converting more easily one or more databases from one format to another.\nIt leverages modules called \"connectors\", responsible for conversion of data between specific databases schemas and the HERA format.\n\nThis repository implements a connector to retrieve data from a MySQL database.\nThe implementation doesn't need any intervention on pyHeimdall proper.\n\n\n*****************\nHow can I use it?\n*****************\n\nSetup\n=====\n\nThis MySQL pyHeimdall connector is available as a `PyPI package <https://pypi.org/project/pyheimdall-mysql/>`_ named ``pyheimdall-mysql``.\nYou can install it using the `pip <https://pip.pypa.io/en/stable/>`_ package manager:\n\n.. code-block:: bash\n\n pip install pyheimdall-mysql\n\nYou can use `pip <https://pip.pypa.io/en/stable/>`_ to either upgrade or uninstall this connector, too:\n\n.. code-block:: bash\n\n pip install --upgrade pyheimdall-mysql\n pip uninstall pyheimdall-mysql\n\nUsage\n=====\n\n.. code-block:: python\n\n import heimdall\n\n tree = heimdall.getDatabase(\n format='sql:mysql',\n url='mysql://myusername:mypassword@myhost:myport/mydatabase',\n entities=('mytable', 'myothertable', ),\n )\n heimdall.createDatabase(tree, format='xml:hera', url='mydatabase.xml')\n\nPlease note that you don't need to use ``pyheimdall-mysql`` functions directly.\nAs 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 <https://gitlab.huma-num.fr/datasphere/heimdall/python/-/tree/main/src/heimdall/connectors>`_ or `external <https://gitlab.huma-num.fr/datasphere/heimdall/connectors>`_ connector.\n\n\n*************\nIs it tested?\n*************\n\nOf course!\nHere's `the coverage report <https://datasphere.gitpages.huma-num.fr/heimdall/connectors/mysql/coverage/index.html>`_.\n\n| Please note, however, than this coverage report is produced by a continuous integration (CI).\n This CI relies in part on third party tools which are *not* MySQL, but `MariaDB <https://mariadb.org/>`_.\n 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.\n| 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.\n| In other words, this connector *should* work on your MySQL database, but we can't guarantee it on the long term.\n If you detect an issue, and/or can provide a solution, feel free to contribute!\n\n\nFor an alternative, consider using MariaDB, and the connector ``pyheimdall-mariadb``.\n\n\n*********************\nHow can I contribute?\n*********************\n\nThis project welcomes any feedback or proposal.\nDetails can be accessed `here <https://gitlab.huma-num.fr/datasphere/heimdall/python/-/blob/main/CONTRIBUTING.rst>`_\n\n\n*******\nLicense\n*******\n\n`GNU Affero General Public License version 3.0 or later <https://choosealicense.com/licenses/agpl/>`_\n\nThis 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.\nThe official MySQL website can be found at https://www.mysql.com/.\nThe name MySQL as well as related names, marks, emblems and images, are registered trademarks of Oracle.\n",
"bugtrack_url": null,
"license": "aGPL",
"summary": "MySQL connector for pyHeimdall",
"version": "1.0.0",
"project_urls": {
"Homepage": "https://gitlab.huma-num.fr/datasphere/heimdall/connectors/mysql/",
"Issues": "https://gitlab.huma-num.fr/datasphere/heimdall/python/-/issues"
},
"split_keywords": [
"databases",
" hera",
" interoperability"
],
"urls": [
{
"comment_text": null,
"digests": {
"blake2b_256": "549d10deea99b71ce645ae7cc348ab68695e04d93f89f2b3b3148535217afc20",
"md5": "de33ade0372caf721e4de6e78d810b4e",
"sha256": "00d7f30c5d4d7cf47614012b86a87bb8eb03a31d275055c7f31eb7277612284a"
},
"downloads": -1,
"filename": "pyheimdall_mysql-1.0.0-py2.py3-none-any.whl",
"has_sig": false,
"md5_digest": "de33ade0372caf721e4de6e78d810b4e",
"packagetype": "bdist_wheel",
"python_version": "py2.py3",
"requires_python": null,
"size": 18017,
"upload_time": "2025-01-22T09:29:20",
"upload_time_iso_8601": "2025-01-22T09:29:20.795541Z",
"url": "https://files.pythonhosted.org/packages/54/9d/10deea99b71ce645ae7cc348ab68695e04d93f89f2b3b3148535217afc20/pyheimdall_mysql-1.0.0-py2.py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "a885ff5daaa6a38820f679aa981c014fb2c06cf29007826e1e38c5ef9ed260bf",
"md5": "df98be294b6ff997034f0f98951e6ccd",
"sha256": "573bb8217808b8e3fe647dbd6c38871e33aa6a81c702b077db7978d7e3dbf156"
},
"downloads": -1,
"filename": "pyheimdall_mysql-1.0.0.tar.gz",
"has_sig": false,
"md5_digest": "df98be294b6ff997034f0f98951e6ccd",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 18059,
"upload_time": "2025-01-22T09:29:23",
"upload_time_iso_8601": "2025-01-22T09:29:23.117144Z",
"url": "https://files.pythonhosted.org/packages/a8/85/ff5daaa6a38820f679aa981c014fb2c06cf29007826e1e38c5ef9ed260bf/pyheimdall_mysql-1.0.0.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2025-01-22 09:29:23",
"github": false,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"lcname": "pyheimdall-mysql"
}
JSON