diff options
| -rw-r--r-- | .gitignore | 1 | ||||
| -rw-r--r-- | python-sqlite3-to-mysql.spec | 338 | ||||
| -rw-r--r-- | sources | 1 |
3 files changed, 340 insertions, 0 deletions
@@ -0,0 +1 @@ +/sqlite3-to-mysql-1.4.16.tar.gz diff --git a/python-sqlite3-to-mysql.spec b/python-sqlite3-to-mysql.spec new file mode 100644 index 0000000..91adaa5 --- /dev/null +++ b/python-sqlite3-to-mysql.spec @@ -0,0 +1,338 @@ +%global _empty_manifest_terminate_build 0 +Name: python-sqlite3-to-mysql +Version: 1.4.16 +Release: 1 +Summary: A simple Python tool to transfer data from SQLite 3 to MySQL +License: MIT +URL: https://github.com/techouse/sqlite3-to-mysql +Source0: https://mirrors.nju.edu.cn/pypi/web/packages/a6/f2/a5626e7ad017978edd4bfaa93f777c96afd6fb0fdc97aa0b444621e87cda/sqlite3-to-mysql-1.4.16.tar.gz +BuildArch: noarch + +Requires: python3-pytimeparse +Requires: python3-six +Requires: python3-simplejson +Requires: python3-tqdm +Requires: python3-packaging +Requires: python3-tabulate +Requires: python3-Unidecode +Requires: python3-Click +Requires: python3-mysql-connector-python +Requires: python3-backports-datetime-fromisoformat +Requires: python3-tabulate +Requires: python3-Unidecode +Requires: python3-Click +Requires: python3-mysql-connector-python + +%description +[](https://pypi.org/project/sqlite3-to-mysql/) +[](https://pepy.tech/project/sqlite3-to-mysql) +[](https://pypi.org/project/sqlite3-to-mysql/) +[](https://img.shields.io/static/v1?label=MySQL&message=5.6+|+5.7+|+8.0&color=2b5d80) +[](https://img.shields.io/static/v1?label=MariaDB&message=10.0+|+10.1+|+10.2+|+10.3+|+10.4+|+10.5&color=C0765A) +[](https://github.com/techouse/sqlite3-to-mysql/blob/master/LICENSE) +[](CODE-OF-CONDUCT.md) +[](https://github.com/ambv/black) +[](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) +[](https://github.com/techouse/sqlite3-to-mysql/actions?query=workflow%3ATest) +[](https://codecov.io/gh/techouse/sqlite3-to-mysql) +[](https://github.com/techouse/sqlite3-to-mysql/stargazers) + + +# SQLite3 to MySQL + +#### A simple Python tool to transfer data from SQLite 3 to MySQL. + +I originally wrote this simple program as a standalone script and published it +as a [gist](https://gist.github.com/techouse/4deb94eee58a02d104c6) as an answer +to this [Stack Overflow question](https://stackoverflow.com/questions/18671/quick-easy-way-to-migrate-sqlite3-to-mysql/32243979#32243979). +Since then quite some people have taken interest in it since it's so simple and +effective. Therefore I finally moved my lazy bones and made a GitHub repository :octopus:. + +### How to run + +```bash +pip install sqlite3-to-mysql +sqlite3mysql --help +``` + +### Usage +``` +Usage: sqlite3mysql [OPTIONS] + + Transfer SQLite to MySQL using the provided CLI options. + +Options: + -f, --sqlite-file PATH SQLite3 database file [required] + -t, --sqlite-tables TUPLE Transfer only these specific tables (space + separated table names). Implies --without- + foreign-keys which inhibits the transfer of + foreign keys. + -X, --without-foreign-keys Do not transfer foreign keys. + -W, --ignore-duplicate-keys Ignore duplicate keys. The default behavior + is to create new ones with a numerical + suffix, e.g. 'exising_key' -> + 'existing_key_1' + -d, --mysql-database TEXT MySQL database name [required] + -u, --mysql-user TEXT MySQL user [required] + -p, --prompt-mysql-password Prompt for MySQL password + --mysql-password TEXT MySQL password + -h, --mysql-host TEXT MySQL host. Defaults to localhost. + -P, --mysql-port INTEGER MySQL port. Defaults to 3306. + -S, --skip-ssl Disable MySQL connection encryption. + -i, --mysql-insert-method [UPDATE|IGNORE|DEFAULT] + MySQL insert method. DEFAULT will throw + errors when encountering duplicate records; + UPDATE will update existing rows; IGNORE + will ignore insert errors. Defaults to + IGNORE. + -E, --mysql-truncate-tables Truncates existing tables before inserting + data. + --mysql-integer-type TEXT MySQL default integer field type. Defaults + to INT(11). + --mysql-string-type TEXT MySQL default string field type. Defaults to + VARCHAR(255). + --mysql-text-type [MEDIUMTEXT|TEXT|TINYTEXT|LONGTEXT] + MySQL default text field type. Defaults to + TEXT. + --mysql-charset TEXT MySQL database and table character set + [default: utf8mb4] + --mysql-collation TEXT MySQL database and table collation + -T, --use-fulltext Use FULLTEXT indexes on TEXT columns. Will + throw an error if your MySQL version does + not support InnoDB FULLTEXT indexes! + --with-rowid Transfer rowid columns. + -c, --chunk INTEGER Chunk reading/writing SQL records + -l, --log-file PATH Log file + -q, --quiet Quiet. Display only errors. + --debug Debug mode. Will throw exceptions. + --version Show the version and exit. + --help Show this message and exit. +``` + + +%package -n python3-sqlite3-to-mysql +Summary: A simple Python tool to transfer data from SQLite 3 to MySQL +Provides: python-sqlite3-to-mysql +BuildRequires: python3-devel +BuildRequires: python3-setuptools +BuildRequires: python3-pip +%description -n python3-sqlite3-to-mysql +[](https://pypi.org/project/sqlite3-to-mysql/) +[](https://pepy.tech/project/sqlite3-to-mysql) +[](https://pypi.org/project/sqlite3-to-mysql/) +[](https://img.shields.io/static/v1?label=MySQL&message=5.6+|+5.7+|+8.0&color=2b5d80) +[](https://img.shields.io/static/v1?label=MariaDB&message=10.0+|+10.1+|+10.2+|+10.3+|+10.4+|+10.5&color=C0765A) +[](https://github.com/techouse/sqlite3-to-mysql/blob/master/LICENSE) +[](CODE-OF-CONDUCT.md) +[](https://github.com/ambv/black) +[](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) +[](https://github.com/techouse/sqlite3-to-mysql/actions?query=workflow%3ATest) +[](https://codecov.io/gh/techouse/sqlite3-to-mysql) +[](https://github.com/techouse/sqlite3-to-mysql/stargazers) + + +# SQLite3 to MySQL + +#### A simple Python tool to transfer data from SQLite 3 to MySQL. + +I originally wrote this simple program as a standalone script and published it +as a [gist](https://gist.github.com/techouse/4deb94eee58a02d104c6) as an answer +to this [Stack Overflow question](https://stackoverflow.com/questions/18671/quick-easy-way-to-migrate-sqlite3-to-mysql/32243979#32243979). +Since then quite some people have taken interest in it since it's so simple and +effective. Therefore I finally moved my lazy bones and made a GitHub repository :octopus:. + +### How to run + +```bash +pip install sqlite3-to-mysql +sqlite3mysql --help +``` + +### Usage +``` +Usage: sqlite3mysql [OPTIONS] + + Transfer SQLite to MySQL using the provided CLI options. + +Options: + -f, --sqlite-file PATH SQLite3 database file [required] + -t, --sqlite-tables TUPLE Transfer only these specific tables (space + separated table names). Implies --without- + foreign-keys which inhibits the transfer of + foreign keys. + -X, --without-foreign-keys Do not transfer foreign keys. + -W, --ignore-duplicate-keys Ignore duplicate keys. The default behavior + is to create new ones with a numerical + suffix, e.g. 'exising_key' -> + 'existing_key_1' + -d, --mysql-database TEXT MySQL database name [required] + -u, --mysql-user TEXT MySQL user [required] + -p, --prompt-mysql-password Prompt for MySQL password + --mysql-password TEXT MySQL password + -h, --mysql-host TEXT MySQL host. Defaults to localhost. + -P, --mysql-port INTEGER MySQL port. Defaults to 3306. + -S, --skip-ssl Disable MySQL connection encryption. + -i, --mysql-insert-method [UPDATE|IGNORE|DEFAULT] + MySQL insert method. DEFAULT will throw + errors when encountering duplicate records; + UPDATE will update existing rows; IGNORE + will ignore insert errors. Defaults to + IGNORE. + -E, --mysql-truncate-tables Truncates existing tables before inserting + data. + --mysql-integer-type TEXT MySQL default integer field type. Defaults + to INT(11). + --mysql-string-type TEXT MySQL default string field type. Defaults to + VARCHAR(255). + --mysql-text-type [MEDIUMTEXT|TEXT|TINYTEXT|LONGTEXT] + MySQL default text field type. Defaults to + TEXT. + --mysql-charset TEXT MySQL database and table character set + [default: utf8mb4] + --mysql-collation TEXT MySQL database and table collation + -T, --use-fulltext Use FULLTEXT indexes on TEXT columns. Will + throw an error if your MySQL version does + not support InnoDB FULLTEXT indexes! + --with-rowid Transfer rowid columns. + -c, --chunk INTEGER Chunk reading/writing SQL records + -l, --log-file PATH Log file + -q, --quiet Quiet. Display only errors. + --debug Debug mode. Will throw exceptions. + --version Show the version and exit. + --help Show this message and exit. +``` + + +%package help +Summary: Development documents and examples for sqlite3-to-mysql +Provides: python3-sqlite3-to-mysql-doc +%description help +[](https://pypi.org/project/sqlite3-to-mysql/) +[](https://pepy.tech/project/sqlite3-to-mysql) +[](https://pypi.org/project/sqlite3-to-mysql/) +[](https://img.shields.io/static/v1?label=MySQL&message=5.6+|+5.7+|+8.0&color=2b5d80) +[](https://img.shields.io/static/v1?label=MariaDB&message=10.0+|+10.1+|+10.2+|+10.3+|+10.4+|+10.5&color=C0765A) +[](https://github.com/techouse/sqlite3-to-mysql/blob/master/LICENSE) +[](CODE-OF-CONDUCT.md) +[](https://github.com/ambv/black) +[](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) +[](https://github.com/techouse/sqlite3-to-mysql/actions?query=workflow%3ATest) +[](https://codecov.io/gh/techouse/sqlite3-to-mysql) +[](https://github.com/techouse/sqlite3-to-mysql/stargazers) + + +# SQLite3 to MySQL + +#### A simple Python tool to transfer data from SQLite 3 to MySQL. + +I originally wrote this simple program as a standalone script and published it +as a [gist](https://gist.github.com/techouse/4deb94eee58a02d104c6) as an answer +to this [Stack Overflow question](https://stackoverflow.com/questions/18671/quick-easy-way-to-migrate-sqlite3-to-mysql/32243979#32243979). +Since then quite some people have taken interest in it since it's so simple and +effective. Therefore I finally moved my lazy bones and made a GitHub repository :octopus:. + +### How to run + +```bash +pip install sqlite3-to-mysql +sqlite3mysql --help +``` + +### Usage +``` +Usage: sqlite3mysql [OPTIONS] + + Transfer SQLite to MySQL using the provided CLI options. + +Options: + -f, --sqlite-file PATH SQLite3 database file [required] + -t, --sqlite-tables TUPLE Transfer only these specific tables (space + separated table names). Implies --without- + foreign-keys which inhibits the transfer of + foreign keys. + -X, --without-foreign-keys Do not transfer foreign keys. + -W, --ignore-duplicate-keys Ignore duplicate keys. The default behavior + is to create new ones with a numerical + suffix, e.g. 'exising_key' -> + 'existing_key_1' + -d, --mysql-database TEXT MySQL database name [required] + -u, --mysql-user TEXT MySQL user [required] + -p, --prompt-mysql-password Prompt for MySQL password + --mysql-password TEXT MySQL password + -h, --mysql-host TEXT MySQL host. Defaults to localhost. + -P, --mysql-port INTEGER MySQL port. Defaults to 3306. + -S, --skip-ssl Disable MySQL connection encryption. + -i, --mysql-insert-method [UPDATE|IGNORE|DEFAULT] + MySQL insert method. DEFAULT will throw + errors when encountering duplicate records; + UPDATE will update existing rows; IGNORE + will ignore insert errors. Defaults to + IGNORE. + -E, --mysql-truncate-tables Truncates existing tables before inserting + data. + --mysql-integer-type TEXT MySQL default integer field type. Defaults + to INT(11). + --mysql-string-type TEXT MySQL default string field type. Defaults to + VARCHAR(255). + --mysql-text-type [MEDIUMTEXT|TEXT|TINYTEXT|LONGTEXT] + MySQL default text field type. Defaults to + TEXT. + --mysql-charset TEXT MySQL database and table character set + [default: utf8mb4] + --mysql-collation TEXT MySQL database and table collation + -T, --use-fulltext Use FULLTEXT indexes on TEXT columns. Will + throw an error if your MySQL version does + not support InnoDB FULLTEXT indexes! + --with-rowid Transfer rowid columns. + -c, --chunk INTEGER Chunk reading/writing SQL records + -l, --log-file PATH Log file + -q, --quiet Quiet. Display only errors. + --debug Debug mode. Will throw exceptions. + --version Show the version and exit. + --help Show this message and exit. +``` + + +%prep +%autosetup -n sqlite3-to-mysql-1.4.16 + +%build +%py3_build + +%install +%py3_install +install -d -m755 %{buildroot}/%{_pkgdocdir} +if [ -d doc ]; then cp -arf doc %{buildroot}/%{_pkgdocdir}; fi +if [ -d docs ]; then cp -arf docs %{buildroot}/%{_pkgdocdir}; fi +if [ -d example ]; then cp -arf example %{buildroot}/%{_pkgdocdir}; fi +if [ -d examples ]; then cp -arf examples %{buildroot}/%{_pkgdocdir}; fi +pushd %{buildroot} +if [ -d usr/lib ]; then + find usr/lib -type f -printf "/%h/%f\n" >> filelist.lst +fi +if [ -d usr/lib64 ]; then + find usr/lib64 -type f -printf "/%h/%f\n" >> filelist.lst +fi +if [ -d usr/bin ]; then + find usr/bin -type f -printf "/%h/%f\n" >> filelist.lst +fi +if [ -d usr/sbin ]; then + find usr/sbin -type f -printf "/%h/%f\n" >> filelist.lst +fi +touch doclist.lst +if [ -d usr/share/man ]; then + find usr/share/man -type f -printf "/%h/%f.gz\n" >> doclist.lst +fi +popd +mv %{buildroot}/filelist.lst . +mv %{buildroot}/doclist.lst . + +%files -n python3-sqlite3-to-mysql -f filelist.lst +%dir %{python3_sitelib}/* + +%files help -f doclist.lst +%{_docdir}/* + +%changelog +* Mon May 15 2023 Python_Bot <Python_Bot@openeuler.org> - 1.4.16-1 +- Package Spec generated @@ -0,0 +1 @@ +20193960709546aac1f69d2be8c1088a sqlite3-to-mysql-1.4.16.tar.gz |