- Support libalternatives for 16.0 and newer

- Update to version 2.4.1
  * use more precise foreign key constraints
  * ensure index names do not collide with table names
  * add support for AUTOINCREMENT
  * add --without-tables option
  * Fix transferring composite primary keys when AUTOINCREMENT present
  * add MySQL 8.4 and MariaDB 11.4 support
  * fix passwordless login

OBS-URL: https://build.opensuse.org/package/show/devel:languages:python/python-mysql-to-sqlite3?expand=0&rev=9
This commit is contained in:
2025-06-28 14:33:09 +00:00
committed by Git OBS Bridge
commit 508d3b6b32
9 changed files with 213 additions and 0 deletions

23
.gitattributes vendored Normal file
View File

@@ -0,0 +1,23 @@
## Default LFS
*.7z filter=lfs diff=lfs merge=lfs -text
*.bsp filter=lfs diff=lfs merge=lfs -text
*.bz2 filter=lfs diff=lfs merge=lfs -text
*.gem filter=lfs diff=lfs merge=lfs -text
*.gz filter=lfs diff=lfs merge=lfs -text
*.jar filter=lfs diff=lfs merge=lfs -text
*.lz filter=lfs diff=lfs merge=lfs -text
*.lzma filter=lfs diff=lfs merge=lfs -text
*.obscpio filter=lfs diff=lfs merge=lfs -text
*.oxt filter=lfs diff=lfs merge=lfs -text
*.pdf filter=lfs diff=lfs merge=lfs -text
*.png filter=lfs diff=lfs merge=lfs -text
*.rpm filter=lfs diff=lfs merge=lfs -text
*.tbz filter=lfs diff=lfs merge=lfs -text
*.tbz2 filter=lfs diff=lfs merge=lfs -text
*.tgz filter=lfs diff=lfs merge=lfs -text
*.ttf filter=lfs diff=lfs merge=lfs -text
*.txz filter=lfs diff=lfs merge=lfs -text
*.whl filter=lfs diff=lfs merge=lfs -text
*.xz filter=lfs diff=lfs merge=lfs -text
*.zip filter=lfs diff=lfs merge=lfs -text
*.zst filter=lfs diff=lfs merge=lfs -text

1
.gitignore vendored Normal file
View File

@@ -0,0 +1 @@
.osc

16
_service Normal file
View File

@@ -0,0 +1,16 @@
<services>
<service mode="manual" name="obs_scm">
<param name="url">https://github.com/techouse/mysql-to-sqlite3.git</param>
<param name="scm">git</param>
<param name="revision">v2.4.1</param>
<param name="versionformat">v2.4.1</param>
<param name="changesgenerate">enable</param>
<param name="versionrewrite-pattern">v(.*)</param>
</service>
<service mode="manual" name="set_version"/>
<service mode="buildtime" name="tar"/>
<service mode="buildtime" name="recompress">
<param name="compression">gz</param>
<param name="file">*.tar</param>
</service>
</services>

4
_servicedata Normal file
View File

@@ -0,0 +1,4 @@
<servicedata>
<service name="tar_scm">
<param name="url">https://github.com/techouse/mysql-to-sqlite3.git</param>
<param name="changesrevision">cdee3dad0c8f725820c3fd291397ad5da059e21e</param></service></servicedata>

View File

@@ -0,0 +1,3 @@
version https://git-lfs.github.com/spec/v1
oid sha256:0b71b85f2fc8d264ab010d46ffde860a478f238e57083219d80e8313a102ab36
size 222731

View File

@@ -0,0 +1,3 @@
version https://git-lfs.github.com/spec/v1
oid sha256:bc72449bc1793569f849b1805eb415b9d93a4d5bec121a8ee4999c82b1462514
size 296459

4
mysql-to-sqlite3.obsinfo Normal file
View File

@@ -0,0 +1,4 @@
name: mysql-to-sqlite3
version: 2.4.1
mtime: 1747867841
commit: cdee3dad0c8f725820c3fd291397ad5da059e21e

View File

@@ -0,0 +1,49 @@
-------------------------------------------------------------------
Sat Jun 28 14:05:13 UTC 2025 - Enno Gotthold <egotthold@suse.com>
- Support libalternatives for 16.0 and newer
- Update to version 2.4.1
* use more precise foreign key constraints
* ensure index names do not collide with table names
* add support for AUTOINCREMENT
* add --without-tables option
* Fix transferring composite primary keys when AUTOINCREMENT present
* add MySQL 8.4 and MariaDB 11.4 support
* fix passwordless login
-------------------------------------------------------------------
Thu Aug 29 09:04:05 UTC 2024 - pgajdos@suse.com
- does not require python-six for build
-------------------------------------------------------------------
Fri Dec 29 15:08:13 UTC 2023 - egotthold@suse.com
- Update to version v2.1.6:
* [FIX] fix invalid column_type error message
* [CHORE] publish first containerized release
* [FIX] throw more comprehensive error messages when translating column types
* [CHORE] add support for Python 3.12
* [CHORE] bump minimum version of MySQL Connector/Python to 8.2.0
* [CHORE] drop support for Python 3.7
-------------------------------------------------------------------
Thu Jul 22 08:23:34 UTC 2021 - Enno Gotthold <egotthold@suse.com>
- Use python-click instead of non existent python-Click as a requirement
-------------------------------------------------------------------
Wed Jul 21 18:05:12 UTC 2021 - Enno Gotthold <egotthold@suse.com>
- Update to version 1.4.3
- Use obscpio instead of .tar.gz
-------------------------------------------------------------------
Mon Jan 4 12:34:51 UTC 2021 - Enno Gotthold <egotthold@suse.com>
- Update to version 1.3.6
-------------------------------------------------------------------
Tue Dec 1 19:14:43 UTC 2020 - Enno Gotthold <egotthold@suse.com>
- Initial packaging of the tool (1.3.5)

View File

@@ -0,0 +1,110 @@
#
# spec file for package python-mysql-to-sqlite3
#
# Copyright (c) 2025 SUSE LLC
#
# All modifications and additions to the file contributed by third parties
# remain the property of their copyright owners, unless otherwise agreed
# upon. The license for this file, and modifications and additions to the
# file, is the same license as for the pristine package itself (unless the
# license for the pristine package is not an Open Source License, in which
# case the license is the MIT License). An "Open Source License" is a
# license that conforms to the Open Source Definition (Version 1.9)
# published by the Open Source Initiative.
# Please submit bugfixes or comments via https://bugs.opensuse.org/
#
%define short_name mysql-to-sqlite3
%define skip_python2 1
%if 0%{?suse_version} > 1500
%bcond_without libalternatives
%else
%bcond_with libalternatives
%endif
Name: python-mysql-to-sqlite3
Version: 2.4.1
Release: 0
Summary: A simple Python tool to transfer data from MySQL to SQLite 3
License: MIT
URL: https://github.com/techouse/mysql-to-sqlite3
Source: %{short_name}-%{version}.tar.gz
# libalternative
%if %{with libalternatives}
Requires: alts
BuildRequires: alts
%else
Requires(post): update-alternatives
Requires(postun): update-alternatives
%endif
# Package Requirements
BuildRequires: %{python_module hatchling}
BuildRequires: %{python_module SQLAlchemy-Utils}
BuildRequires: %{python_module SQLAlchemy}
BuildRequires: %{python_module docker}
BuildRequires: %{python_module factory_boy}
BuildRequires: %{python_module pip}
BuildRequires: %{python_module pytest}
BuildRequires: %{python_module setuptools}
BuildRequires: docker
BuildRequires: python-rpm-macros
# SECTION test requirements
BuildRequires: %{python_module click >= 8.1.3}
BuildRequires: %{python_module mysql-connector-python >= 9.0.0}
BuildRequires: %{python_module python-slugify >= 7.0.0}
BuildRequires: %{python_module pytimeparse >= 1.1.8}
BuildRequires: %{python_module simplejson >= 3.19.0}
BuildRequires: %{python_module tabulate}
BuildRequires: %{python_module tqdm >= 4.65.0}
# /SECTION
BuildRequires: fdupes
Requires: python-click >= 8.1.3
Requires: python-mysql-connector-python >= 9.0.0
Requires: python-python-dateutil
Requires: python-python-slugify >= 7.0.0
Requires: python-pytimeparse2
Requires: python-simplejson >= 3.19.0
Requires: python-tabulate
Requires: python-tqdm >= 4.65.0
Requires: python-types-python-dateutil
Requires: python-typing_extensions
BuildArch: noarch
%python_subpackages
%description
A simple Python tool to transfer data from MySQL to SQLite 3
%prep
%setup -q -n mysql-to-sqlite3-%{version}
%build
%pyproject_wheel
%install
%pyproject_install
%python_clone -a %{buildroot}%{_bindir}/mysql2sqlite
%python_expand %fdupes %{buildroot}%{$python_sitelib}
# We cannot execute the tests here due to python-mysql-connector-python missing
# the C-extension.
%pre
# removing old update-alternatives entries
%python_libalternatives_reset_alternative mysql2sqlite
%post
%python_install_alternative mysql2sqlite
%postun
%python_uninstall_alternative mysql2sqlite
%files %{python_files}
%doc README.md
%license LICENSE
%python_alternative %{_bindir}/mysql2sqlite
%{python_sitelib}/mysql_to_sqlite3
%{python_sitelib}/mysql_to_sqlite3-%{version}*-info
%changelog