{ "info": { "author": "Klemen Tu\u0161ar", "author_email": "techouse@gmail.com", "bugtrack_url": null, "classifiers": [ "Development Status :: 5 - Production/Stable", "Environment :: Console", "Intended Audience :: Developers", "Intended Audience :: End Users/Desktop", "Intended Audience :: System Administrators", "License :: OSI Approved :: MIT License", "Operating System :: OS Independent", "Programming Language :: Python", "Programming Language :: Python :: 2", "Programming Language :: Python :: 2.7", "Programming Language :: Python :: 3", "Programming Language :: Python :: 3.5", "Programming Language :: Python :: 3.6", "Programming Language :: Python :: 3.7", "Programming Language :: Python :: 3.8", "Programming Language :: Python :: Implementation :: CPython", "Topic :: Database" ], "description": "[![PyPI](https://img.shields.io/pypi/v/mysql-to-sqlite3)](https://pypi.org/project/mysql-to-sqlite3/)\n[![Downloads](https://pepy.tech/badge/mysql-to-sqlite3)](https://pepy.tech/project/mysql-to-sqlite3)\n[![PyPI - Python Version](https://img.shields.io/pypi/pyversions/mysql-to-sqlite3)](https://pypi.org/project/mysql-to-sqlite3/)\n[![GitHub license](https://img.shields.io/github/license/techouse/mysql-to-sqlite3)](https://github.com/techouse/mysql-to-sqlite3/blob/master/LICENSE)\n[![Code style: black](https://img.shields.io/badge/code%20style-black-000000.svg)](https://github.com/ambv/black)\n[![Codacy Badge](https://api.codacy.com/project/badge/Grade/64aae8e9599746d58d277852b35cc2bd)](https://www.codacy.com/manual/techouse/mysql-to-sqlite3?utm_source=github.com&utm_medium=referral&utm_content=techouse/mysql-to-sqlite3&utm_campaign=Badge_Grade)\n[![Build Status](https://travis-ci.org/techouse/mysql-to-sqlite3.svg?branch=master)](https://travis-ci.org/techouse/mysql-to-sqlite3)\n[![codecov](https://codecov.io/gh/techouse/mysql-to-sqlite3/branch/master/graph/badge.svg)](https://codecov.io/gh/techouse/mysql-to-sqlite3)\n[![GitHub stars](https://img.shields.io/github/stars/techouse/mysql-to-sqlite3.svg?style=social&label=Star&maxAge=2592000)](https://github.com/techouse/mysql-to-sqlite3/stargazers)\n\n\n# MySQL to SQLite3\n\n#### A simple Python tool to transfer data from MySQL to SQLite 3.\n\nThis is the long overdue complimentary tool to my [SQLite3 to MySQL](https://github.com/techouse/sqlite3-to-mysql). It \ntransfers all data from a MySQL database to a SQLite3 database.\n\n### How to run\n\n```bash\npip install mysql-to-sqlite3\nmysql2sqlite --help\n```\n\n### Usage\n```\nUsage: mysql2sqlite [OPTIONS]\n\nOptions:\n -f, --sqlite-file PATH SQLite3 database file [required]\n -d, --mysql-database TEXT MySQL database name [required]\n -u, --mysql-user TEXT MySQL user [required]\n -p, --mysql-password TEXT MySQL password\n -h, --mysql-host TEXT MySQL host. Defaults to localhost.\n -P, --mysql-port INTEGER MySQL port. Defaults to 3306.\n -c, --chunk INTEGER Chunk reading/writing SQL records\n -l, --log-file PATH Log file\n -V, --vacuum Use the VACUUM command to rebuild the SQLite\n database file, repacking it into a minimal amount\n of disk space\n --use-buffered-cursors Use MySQLCursorBuffered for reading the MySQL\n database. This can be useful in situations where\n multiple queries, with small result sets, need to\n be combined or computed with each other.\n --help Show this message and exit.\n```\n\n### Testing\nIn order to run the test suite run these commands using a Docker MySQL image.\n\n**Requires a running Docker instance!**\n\n- using Python 2.7\n```bash\ngit clone https://github.com/techouse/mysql-to-sqlite3\ncd mysql-to-sqlite3\nvirtualenv -p $(which python2) env\nsource env/bin/activate\npip install -e .\npip install -r requirements_dev.txt\ntox\n```\n\n- using Python 3.5+\n```bash\ngit clone https://github.com/techouse/mysql-to-sqlite3\ncd mysql-to-sqlite3 \npython3 -m venv env\nsource env/bin/activate\npip install -e .\npip install -r requirements_dev.txt\ntox\n```\n\n", "description_content_type": "text/markdown", "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/techouse/mysql-to-sqlite3", "keywords": "", "license": "MIT", "maintainer": "", "maintainer_email": "", "name": "mysql-to-sqlite3", "package_url": "https://pypi.org/project/mysql-to-sqlite3/", "platform": "", "project_url": "https://pypi.org/project/mysql-to-sqlite3/", "project_urls": { "Homepage": "https://github.com/techouse/mysql-to-sqlite3", "Source": "https://github.com/techouse/mysql-to-sqlite3" }, "release_url": "https://pypi.org/project/mysql-to-sqlite3/1.2.8/", "requires_dist": [ "Click (>=7.0)", "mysql-connector-python (>=8.0.18)", "pytimeparse (>=1.1.8)", "python-slugify (>=3.0.3)", "simplejson (>=3.16.0)", "six (>=1.12.0)", "tqdm (>=4.35.0)" ], "requires_python": ">=2.7, !=3.0.*, !=3.1.*, !=3.2.*, !=3.3.*, !=3.4.*", "summary": "A simple Python tool to transfer data from MySQL to SQLite 3", "version": "1.2.8" }, "last_serial": 5971886, "releases": { "1.2.2": [ { "comment_text": "", "digests": { "md5": "de4dfb35b9280ff8fae98d6dcab9de56", "sha256": "1b24a36aa5d636c037c6fc7b11f4e585e1d6bbb1b53ae56808db1854d6e4ec56" }, "downloads": -1, "filename": "mysql-to-sqlite3-1.2.2.tar.gz", "has_sig": false, "md5_digest": "de4dfb35b9280ff8fae98d6dcab9de56", "packagetype": "sdist", "python_version": "source", "requires_python": ">=2.7, !=3.0.*, !=3.1.*, !=3.2.*, !=3.3.*, !=3.4.*, !=3.8.*", "size": 8272, "upload_time": "2019-08-31T12:49:15", "url": "https://files.pythonhosted.org/packages/30/8a/5972e09f60b3df27d121221b78c141235538e55edb2834453cb0557fa7c7/mysql-to-sqlite3-1.2.2.tar.gz" } ], "1.2.3": [ { "comment_text": "", "digests": { "md5": "29ee78a3dd946bf2ff90bc872663fd96", "sha256": "c2d69438f38f82776d5e3487e4f9c0ca41e0ffa35cee1a04ab755d1f302bb1ec" }, "downloads": -1, "filename": "mysql-to-sqlite3-1.2.3.tar.gz", "has_sig": false, "md5_digest": "29ee78a3dd946bf2ff90bc872663fd96", "packagetype": "sdist", "python_version": "source", "requires_python": ">=2.7, !=3.0.*, !=3.1.*, !=3.2.*, !=3.3.*, !=3.4.*, !=3.8.*", "size": 9427, "upload_time": "2019-09-02T09:01:12", "url": "https://files.pythonhosted.org/packages/4a/f2/b073eed7459501e5d11806abd2bb4ac6b3fbc6bcd3a1e558d0cdb85ef793/mysql-to-sqlite3-1.2.3.tar.gz" } ], "1.2.4": [ { "comment_text": "", "digests": { "md5": "ec1bb33b57bae07fded97481937e1281", "sha256": "e2a067324aad735da3f3ab82685dbb111c298f641c0ec73274415bd1aa3a1173" }, "downloads": -1, "filename": "mysql-to-sqlite3-1.2.4.tar.gz", "has_sig": false, "md5_digest": "ec1bb33b57bae07fded97481937e1281", "packagetype": "sdist", "python_version": "source", "requires_python": ">=2.7, !=3.0.*, !=3.1.*, !=3.2.*, !=3.3.*, !=3.4.*, !=3.8.*", "size": 9291, "upload_time": "2019-09-02T11:36:18", "url": "https://files.pythonhosted.org/packages/8d/25/4f6f3804cd111ba8459ab9fb971767343ff8e711317d88ccbe8469b4f311/mysql-to-sqlite3-1.2.4.tar.gz" } ], "1.2.5": [ { "comment_text": "", "digests": { "md5": "9ee7844f021503b06a87aadbe392568b", "sha256": "44aa37a465b364a5d057bdb8125d6447e2e7f3dcc7bb3faf1d09b4e2b3c5f8ab" }, "downloads": -1, "filename": "mysql-to-sqlite3-1.2.5.tar.gz", "has_sig": false, "md5_digest": "9ee7844f021503b06a87aadbe392568b", "packagetype": "sdist", "python_version": "source", "requires_python": ">=2.7, !=3.0.*, !=3.1.*, !=3.2.*, !=3.3.*, !=3.4.*, !=3.8.*", "size": 9699, "upload_time": "2019-09-05T13:03:10", "url": "https://files.pythonhosted.org/packages/d7/fa/60ae92eb72cbb3e95dd8fea43677324786ae42883163ea998c20795e477f/mysql-to-sqlite3-1.2.5.tar.gz" } ], "1.2.6": [ { "comment_text": "", "digests": { "md5": "33478e374b884d25f5d93af563677abc", "sha256": "b5967c3cb73e44a24b43134c4baf4e637b679c142651ff7b07cb670368ddb6f7" }, "downloads": -1, "filename": "mysql-to-sqlite3-1.2.6.tar.gz", "has_sig": false, "md5_digest": "33478e374b884d25f5d93af563677abc", "packagetype": "sdist", "python_version": "source", "requires_python": ">=2.7, !=3.0.*, !=3.1.*, !=3.2.*, !=3.3.*, !=3.4.*, !=3.8.*", "size": 18898, "upload_time": "2019-09-05T13:05:09", "url": "https://files.pythonhosted.org/packages/74/b8/1635d443c4749a7daa159f03fe9db5b399b2153e67ba991c83e970087ba8/mysql-to-sqlite3-1.2.6.tar.gz" } ], "1.2.7": [ { "comment_text": "", "digests": { "md5": "42fe511bdbb169f96f9c7ce3c7f1679d", "sha256": "67c419a211c899618ad243eee24ce3baa826486b725de1232e74c96e05f825fc" }, "downloads": -1, "filename": "mysql-to-sqlite3-1.2.7.tar.gz", "has_sig": false, "md5_digest": "42fe511bdbb169f96f9c7ce3c7f1679d", "packagetype": "sdist", "python_version": "source", "requires_python": ">=2.7, !=3.0.*, !=3.1.*, !=3.2.*, !=3.3.*, !=3.4.*, !=3.8.*", "size": 19142, "upload_time": "2019-09-05T22:18:00", "url": "https://files.pythonhosted.org/packages/54/e2/683f620ef7ce410b3dc17d089a67321d9bb262b473b96229b479085c6722/mysql-to-sqlite3-1.2.7.tar.gz" } ], "1.2.8": [ { "comment_text": "", "digests": { "md5": "f48c504f349dbcb46b5020c63366fc87", "sha256": "55cf5349496cb6fc50949a1b7f760450b31d48c25f0688c156f1b15a99407b29" }, "downloads": -1, "filename": "mysql_to_sqlite3-1.2.8-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "f48c504f349dbcb46b5020c63366fc87", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": ">=2.7, !=3.0.*, !=3.1.*, !=3.2.*, !=3.3.*, !=3.4.*", "size": 10360, "upload_time": "2019-10-14T14:36:42", "url": "https://files.pythonhosted.org/packages/3a/95/f99aa52a5555b990efd31f9d08549184793a5c8f92f320af6d9130c71dd8/mysql_to_sqlite3-1.2.8-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "b027dd2dab5927b37e72acd78f9f2bbd", "sha256": "ad8779471e779b98194ba5ee8a9cf7c718613cb1208ae4b8275eebdbee910578" }, "downloads": -1, "filename": "mysql-to-sqlite3-1.2.8.tar.gz", "has_sig": false, "md5_digest": "b027dd2dab5927b37e72acd78f9f2bbd", "packagetype": "sdist", "python_version": "source", "requires_python": ">=2.7, !=3.0.*, !=3.1.*, !=3.2.*, !=3.3.*, !=3.4.*", "size": 19185, "upload_time": "2019-10-14T14:36:44", "url": "https://files.pythonhosted.org/packages/30/e6/399c07eccd305033b97a0abd65a4f7965c4f86c317e140005ff880da3e7b/mysql-to-sqlite3-1.2.8.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "f48c504f349dbcb46b5020c63366fc87", "sha256": "55cf5349496cb6fc50949a1b7f760450b31d48c25f0688c156f1b15a99407b29" }, "downloads": -1, "filename": "mysql_to_sqlite3-1.2.8-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "f48c504f349dbcb46b5020c63366fc87", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": ">=2.7, !=3.0.*, !=3.1.*, !=3.2.*, !=3.3.*, !=3.4.*", "size": 10360, "upload_time": "2019-10-14T14:36:42", "url": "https://files.pythonhosted.org/packages/3a/95/f99aa52a5555b990efd31f9d08549184793a5c8f92f320af6d9130c71dd8/mysql_to_sqlite3-1.2.8-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "b027dd2dab5927b37e72acd78f9f2bbd", "sha256": "ad8779471e779b98194ba5ee8a9cf7c718613cb1208ae4b8275eebdbee910578" }, "downloads": -1, "filename": "mysql-to-sqlite3-1.2.8.tar.gz", "has_sig": false, "md5_digest": "b027dd2dab5927b37e72acd78f9f2bbd", "packagetype": "sdist", "python_version": "source", "requires_python": ">=2.7, !=3.0.*, !=3.1.*, !=3.2.*, !=3.3.*, !=3.4.*", "size": 19185, "upload_time": "2019-10-14T14:36:44", "url": "https://files.pythonhosted.org/packages/30/e6/399c07eccd305033b97a0abd65a4f7965c4f86c317e140005ff880da3e7b/mysql-to-sqlite3-1.2.8.tar.gz" } ] }