{ "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/sqlite3-to-mysql)](https://pypi.org/project/sqlite3-to-mysql/)\n[![Downloads](https://pepy.tech/badge/sqlite3-to-mysql)](https://pepy.tech/project/sqlite3-to-mysql)\n[![PyPI - Python Version](https://img.shields.io/pypi/pyversions/sqlite3-to-mysql)](https://pypi.org/project/sqlite3-to-mysql/)\n[![GitHub license](https://img.shields.io/github/license/techouse/sqlite3-to-mysql)](https://github.com/techouse/sqlite3-to-mysql/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/d33b59d35b924711aae9418741a923ae)](https://www.codacy.com/manual/techouse/sqlite3-to-mysql?utm_source=github.com&utm_medium=referral&utm_content=techouse/sqlite3-to-mysql&utm_campaign=Badge_Grade)\n[![Build Status](https://travis-ci.org/techouse/sqlite3-to-mysql.svg?branch=master)](https://travis-ci.org/techouse/sqlite3-to-mysql)\n[![codecov](https://codecov.io/gh/techouse/sqlite3-to-mysql/branch/master/graph/badge.svg)](https://codecov.io/gh/techouse/sqlite3-to-mysql)\n[![GitHub stars](https://img.shields.io/github/stars/techouse/sqlite3-to-mysql.svg?style=social&label=Star&maxAge=2592000)](https://github.com/techouse/sqlite3-to-mysql/stargazers)\n\n\n# SQLite3 to MySQL\n\n#### A simple Python tool to transfer data from SQLite 3 to MySQL.\n\nI originally wrote this simple program as a standalone script and published it\nas a [gist](https://gist.github.com/techouse/4deb94eee58a02d104c6) as an answer\nto this [Stack Overflow question](https://stackoverflow.com/questions/18671/quick-easy-way-to-migrate-sqlite3-to-mysql/32243979#32243979).\nSince then quite some people have taken interest in it since it's so simple and\neffective. Therefore I finally moved my lazy bones and made a GitHub repository :octopus:.\n\n### How to run\n\n```bash\npip install sqlite3-to-mysql\nsqlite3mysql --help\n```\n\n### Usage\n```\nUsage: sqlite3mysql [OPTIONS]\n\nOptions:\n -f, --sqlite-file PATH SQLite3 db 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 --mysql-integer-type TEXT MySQL default integer field type. Defaults to\n INT(11).\n --mysql-string-type TEXT MySQL default string field type. Defaults to\n VARCHAR(255).\n -c, --chunk INTEGER Chunk reading/writing SQL records\n -l, --log-file PATH Log file\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/sqlite3-to-mysql\ncd sqlite3-to-mysql\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/sqlite3-to-mysql\ncd sqlite3-to-mysql \npython3 -m venv env\nsource env/bin/activate\npip install -e .\npip install -r requirements_dev.txt\ntox\n```\n\n### Note\nAfter a __LONG__ time I finally found the time to write the complimentary script to transfer\n[MySQL to SQLite3](https://github.com/techouse/mysql-to-sqlite3). Check it out :)\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/sqlite3-to-mysql", "keywords": "", "license": "MIT", "maintainer": "", "maintainer_email": "", "name": "sqlite3-to-mysql", "package_url": "https://pypi.org/project/sqlite3-to-mysql/", "platform": "", "project_url": "https://pypi.org/project/sqlite3-to-mysql/", "project_urls": { "Homepage": "https://github.com/techouse/sqlite3-to-mysql", "Source": "https://github.com/techouse/sqlite3-to-mysql" }, "release_url": "https://pypi.org/project/sqlite3-to-mysql/1.2.15/", "requires_dist": [ "Click (>=7.0)", "mysql-connector-python (>=8.0.18)", "pytimeparse (>=1.1.8)", "six (>=1.12.0)", "simplejson (>=3.16.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 SQLite 3 to MySQL", "version": "1.2.15" }, "last_serial": 5971923, "releases": { "1.2.10": [ { "comment_text": "", "digests": { "md5": "50be9804fb2f02d5d287e9225961981d", "sha256": "affaed8c26cbc6fabd04db4542003fe70656d86adae35369500e8c49f97c026c" }, "downloads": -1, "filename": "sqlite3-to-mysql-1.2.10.tar.gz", "has_sig": false, "md5_digest": "50be9804fb2f02d5d287e9225961981d", "packagetype": "sdist", "python_version": "source", "requires_python": ">=2.7, !=3.0.*, !=3.1.*, !=3.2.*, !=3.3.*, !=3.4.*, !=3.8.*", "size": 19545, "upload_time": "2019-09-03T22:10:49", "url": "https://files.pythonhosted.org/packages/35/c7/6c591afdb92ffbb31ddbcba3ba6a5bf9cf5682c281358269b107b399eb9e/sqlite3-to-mysql-1.2.10.tar.gz" } ], "1.2.11": [ { "comment_text": "", "digests": { "md5": "0faeacceb642a0d0729c6f50040d8e80", "sha256": "10482dfab596c05e5291a84855ce461fbd7d6c540be7ea2fa87a6132b842975f" }, "downloads": -1, "filename": "sqlite3-to-mysql-1.2.11.tar.gz", "has_sig": false, "md5_digest": "0faeacceb642a0d0729c6f50040d8e80", "packagetype": "sdist", "python_version": "source", "requires_python": ">=2.7, !=3.0.*, !=3.1.*, !=3.2.*, !=3.3.*, !=3.4.*, !=3.8.*", "size": 19503, "upload_time": "2019-09-05T12:44:07", "url": "https://files.pythonhosted.org/packages/cc/7f/69d335471b073582f59585d915471a670fd81d4a3a992e38fa4a169db243/sqlite3-to-mysql-1.2.11.tar.gz" } ], "1.2.12": [ { "comment_text": "", "digests": { "md5": "c92367045986c74eb478dba2b8a579d0", "sha256": "200c9c549d4b51fb35d71dd52263c790ee472abe5fdd60f86e571de8da8c869d" }, "downloads": -1, "filename": "sqlite3-to-mysql-1.2.12.tar.gz", "has_sig": false, "md5_digest": "c92367045986c74eb478dba2b8a579d0", "packagetype": "sdist", "python_version": "source", "requires_python": ">=2.7, !=3.0.*, !=3.1.*, !=3.2.*, !=3.3.*, !=3.4.*, !=3.8.*", "size": 20405, "upload_time": "2019-09-06T08:23:08", "url": "https://files.pythonhosted.org/packages/bf/05/27fcd5dc03d878d0bd4749b6acb2efc495eb183ac0e74f8433b5385ff9a9/sqlite3-to-mysql-1.2.12.tar.gz" } ], "1.2.13": [ { "comment_text": "", "digests": { "md5": "ddccf44bd90b7eab3fb74af348b53f25", "sha256": "d9888ba06540df4653265b324c227591ec37b0b036c183df9342ef89a03e5e35" }, "downloads": -1, "filename": "sqlite3-to-mysql-1.2.13.tar.gz", "has_sig": false, "md5_digest": "ddccf44bd90b7eab3fb74af348b53f25", "packagetype": "sdist", "python_version": "source", "requires_python": ">=2.7, !=3.0.*, !=3.1.*, !=3.2.*, !=3.3.*, !=3.4.*, !=3.8.*", "size": 20719, "upload_time": "2019-09-16T12:59:52", "url": "https://files.pythonhosted.org/packages/f0/e0/9e8d27b827fcf111a23f5d47de0cd69614d352d81809d509095236abf8cb/sqlite3-to-mysql-1.2.13.tar.gz" } ], "1.2.14": [ { "comment_text": "", "digests": { "md5": "126463e5701a3e1223d4bfe1bbf296cf", "sha256": "6f4366e57f3c27b7c8fffb081cd9cd76263e9b0972b3e4a45d8966d147d6abf8" }, "downloads": -1, "filename": "sqlite3_to_mysql-1.2.14-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "126463e5701a3e1223d4bfe1bbf296cf", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": ">=2.7, !=3.0.*, !=3.1.*, !=3.2.*, !=3.3.*, !=3.4.*", "size": 10919, "upload_time": "2019-10-14T14:35:26", "url": "https://files.pythonhosted.org/packages/9b/88/70bdb232dffb53844e94e88baedc33c8dd0d9b9f063e19d202a3df1c5166/sqlite3_to_mysql-1.2.14-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "bc6fcd9709e884472e54c1166ec9ba46", "sha256": "5a884ee0afc6cbdc083054c6537afa3b851eb3f7278d2da54a5d06b54d364a63" }, "downloads": -1, "filename": "sqlite3-to-mysql-1.2.14.tar.gz", "has_sig": false, "md5_digest": "bc6fcd9709e884472e54c1166ec9ba46", "packagetype": "sdist", "python_version": "source", "requires_python": ">=2.7, !=3.0.*, !=3.1.*, !=3.2.*, !=3.3.*, !=3.4.*", "size": 20853, "upload_time": "2019-10-14T14:35:27", "url": "https://files.pythonhosted.org/packages/6b/14/5b6f2687b680fe87c2782553aa3f43898aa80158ac1fbb94d30b890bea1d/sqlite3-to-mysql-1.2.14.tar.gz" } ], "1.2.15": [ { "comment_text": "", "digests": { "md5": "279b82972a2df61c43076288dcf7e625", "sha256": "26dd93fad4350a10ecca777c9e299f6cdf33296d1e9359360df6431b2167c029" }, "downloads": -1, "filename": "sqlite3_to_mysql-1.2.15-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "279b82972a2df61c43076288dcf7e625", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": ">=2.7, !=3.0.*, !=3.1.*, !=3.2.*, !=3.3.*, !=3.4.*", "size": 10667, "upload_time": "2019-10-14T14:42:09", "url": "https://files.pythonhosted.org/packages/2c/27/57b2f673e87e9b3cbbbb205da211191f815e685f2694fb25ca53a027cd5d/sqlite3_to_mysql-1.2.15-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "6996b0ac60fd88260619cfd373f35d8b", "sha256": "4efcb2f8c853f2d397dc58d1a1c0e6f08c33eff1094ff00279891bfade6234bb" }, "downloads": -1, "filename": "sqlite3-to-mysql-1.2.15.tar.gz", "has_sig": false, "md5_digest": "6996b0ac60fd88260619cfd373f35d8b", "packagetype": "sdist", "python_version": "source", "requires_python": ">=2.7, !=3.0.*, !=3.1.*, !=3.2.*, !=3.3.*, !=3.4.*", "size": 20327, "upload_time": "2019-10-14T14:42:11", "url": "https://files.pythonhosted.org/packages/58/07/8b5eee19520f64da5ee4f021d8c9decb207798e0fa67775989341cef0ad0/sqlite3-to-mysql-1.2.15.tar.gz" } ], "1.2.4": [ { "comment_text": "", "digests": { "md5": "a580e9c683de699e1c72ba107d9c14ef", "sha256": "462fa996d2c28c1070e1adfd32fafeaf164ce83fed21dd82d0dd40e137e0aec7" }, "downloads": -1, "filename": "sqlite3-to-mysql-1.2.4.tar.gz", "has_sig": false, "md5_digest": "a580e9c683de699e1c72ba107d9c14ef", "packagetype": "sdist", "python_version": "source", "requires_python": ">=2.7, !=3.0.*, !=3.1.*, !=3.2.*, !=3.3.*, !=3.4.*", "size": 8329, "upload_time": "2019-08-31T00:06:01", "url": "https://files.pythonhosted.org/packages/55/f4/4858574b7350b278e8ee57dcb5aa0c8fabdb99c7fd5210a43b00f9441d2f/sqlite3-to-mysql-1.2.4.tar.gz" } ], "1.2.5": [ { "comment_text": "", "digests": { "md5": "0a96eeb20409a37d802d618076341510", "sha256": "4492f929fdc1e3d0d235dd4de83938a3159e46e8e7b3f8b1e91e97cda6867ec1" }, "downloads": -1, "filename": "sqlite3-to-mysql-1.2.5.tar.gz", "has_sig": false, "md5_digest": "0a96eeb20409a37d802d618076341510", "packagetype": "sdist", "python_version": "source", "requires_python": ">=2.7, !=3.0.*, !=3.1.*, !=3.2.*, !=3.3.*, !=3.4.*, !=3.8.*", "size": 8634, "upload_time": "2019-08-31T00:25:40", "url": "https://files.pythonhosted.org/packages/ee/a7/822b2f29a7e51ce4ab12256ae20f019424310b1031b585c0fc6661e59816/sqlite3-to-mysql-1.2.5.tar.gz" } ], "1.2.6": [ { "comment_text": "", "digests": { "md5": "321e49301a2583190d4deb2d854d89c5", "sha256": "d45236db5b860ecd96b4bfaae73b87b5a8e75a046212f2d95f5d5cc43aeec3b5" }, "downloads": -1, "filename": "sqlite3-to-mysql-1.2.6.tar.gz", "has_sig": false, "md5_digest": "321e49301a2583190d4deb2d854d89c5", "packagetype": "sdist", "python_version": "source", "requires_python": ">=2.7, !=3.0.*, !=3.1.*, !=3.2.*, !=3.3.*, !=3.4.*, !=3.8.*", "size": 9219, "upload_time": "2019-09-02T16:29:32", "url": "https://files.pythonhosted.org/packages/14/1c/8bb3adaaea98d79226a82edd23cb39ef11a169f4d6df9516725b8e5d66aa/sqlite3-to-mysql-1.2.6.tar.gz" } ], "1.2.7": [ { "comment_text": "", "digests": { "md5": "3e115eeb5e9fa8b5ac843c8be7694a3a", "sha256": "ed3fac6349e79aa39bef1b40de8f133da1a711e3eee0c4db483192e3585cfc30" }, "downloads": -1, "filename": "sqlite3-to-mysql-1.2.7.tar.gz", "has_sig": false, "md5_digest": "3e115eeb5e9fa8b5ac843c8be7694a3a", "packagetype": "sdist", "python_version": "source", "requires_python": ">=2.7, !=3.0.*, !=3.1.*, !=3.2.*, !=3.3.*, !=3.4.*, !=3.8.*", "size": 10486, "upload_time": "2019-09-02T22:57:27", "url": "https://files.pythonhosted.org/packages/f4/8f/831d98b385987c4dea90c1c3e0a347e81bd7a9c97b955a948cd73a5c2e03/sqlite3-to-mysql-1.2.7.tar.gz" } ], "1.2.8": [ { "comment_text": "", "digests": { "md5": "a0dda8e190d5c2f414d1bc9362b87e75", "sha256": "f4b37183b9a688d98b502acf5ef5883c1cb4c93751968c197fe3181382873a47" }, "downloads": -1, "filename": "sqlite3-to-mysql-1.2.8.tar.gz", "has_sig": false, "md5_digest": "a0dda8e190d5c2f414d1bc9362b87e75", "packagetype": "sdist", "python_version": "source", "requires_python": ">=2.7, !=3.0.*, !=3.1.*, !=3.2.*, !=3.3.*, !=3.4.*, !=3.8.*", "size": 10513, "upload_time": "2019-09-03T06:02:33", "url": "https://files.pythonhosted.org/packages/76/3e/4572ef7d1aaca52d7eea10bc554a0015ead9dca5f6fe5ba992244f665d4f/sqlite3-to-mysql-1.2.8.tar.gz" } ], "1.2.9": [ { "comment_text": "", "digests": { "md5": "7596043b9f14030f0c728a0cc30d0cc1", "sha256": "0739a363babc770a9ace05ee2835a75ceaa094e69ba9265c2f84a579541e213a" }, "downloads": -1, "filename": "sqlite3-to-mysql-1.2.9.tar.gz", "has_sig": false, "md5_digest": "7596043b9f14030f0c728a0cc30d0cc1", "packagetype": "sdist", "python_version": "source", "requires_python": ">=2.7, !=3.0.*, !=3.1.*, !=3.2.*, !=3.3.*, !=3.4.*, !=3.8.*", "size": 10607, "upload_time": "2019-09-03T08:11:27", "url": "https://files.pythonhosted.org/packages/ca/9f/bf80286c8f55d5a3b32a644c726e3e06fb1d99f49301ffc07f89da2574b4/sqlite3-to-mysql-1.2.9.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "279b82972a2df61c43076288dcf7e625", "sha256": "26dd93fad4350a10ecca777c9e299f6cdf33296d1e9359360df6431b2167c029" }, "downloads": -1, "filename": "sqlite3_to_mysql-1.2.15-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "279b82972a2df61c43076288dcf7e625", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": ">=2.7, !=3.0.*, !=3.1.*, !=3.2.*, !=3.3.*, !=3.4.*", "size": 10667, "upload_time": "2019-10-14T14:42:09", "url": "https://files.pythonhosted.org/packages/2c/27/57b2f673e87e9b3cbbbb205da211191f815e685f2694fb25ca53a027cd5d/sqlite3_to_mysql-1.2.15-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "6996b0ac60fd88260619cfd373f35d8b", "sha256": "4efcb2f8c853f2d397dc58d1a1c0e6f08c33eff1094ff00279891bfade6234bb" }, "downloads": -1, "filename": "sqlite3-to-mysql-1.2.15.tar.gz", "has_sig": false, "md5_digest": "6996b0ac60fd88260619cfd373f35d8b", "packagetype": "sdist", "python_version": "source", "requires_python": ">=2.7, !=3.0.*, !=3.1.*, !=3.2.*, !=3.3.*, !=3.4.*", "size": 20327, "upload_time": "2019-10-14T14:42:11", "url": "https://files.pythonhosted.org/packages/58/07/8b5eee19520f64da5ee4f021d8c9decb207798e0fa67775989341cef0ad0/sqlite3-to-mysql-1.2.15.tar.gz" } ] }