## START: Set by rpmautospec
## (rpmautospec version 0.8.1)
## RPMAUTOSPEC: autorelease, autochangelog
%define autorelease(e:s:pb:n) %{?-p:0.}%{lua:
    release_number = 2;
    base_release_number = tonumber(rpm.expand("%{?-b*}%{!?-b:1}"));
    print(release_number + base_release_number - 1);
}%{?-e:.%{-e*}}%{?-s:.%{-s*}}%{!?-n:%{?dist}}
## END: Set by rpmautospec

Name:       mysql-workbench-community
Version:    8.0.43
Release:    %autorelease
Summary:    A MySQL visual database modeling, administration, development and migration tool
Group:      Applications/Databases
Vendor:     Oracle Corporation
License:    GPL-2.0-only
URL:        http://wb.mysql.com
Source0:    %{name}-%{version}-src.tar.gz
Source1:    antlr-4.13.2-complete.jar
# https://github.com/mysql/mysql-workbench/pull/48
# https://bugs.mysql.com/bug.php?id=117171
# 'pipes' has been removed from Python standard library
Patch:      pipes.patch

BuildRequires:  antlr4
BuildRequires:  antlr4-cpp-runtime-devel
BuildRequires:  boost-devel
BuildRequires:  cmake
BuildRequires:  gcc-c++
BuildRequires:  gdal-devel
BuildRequires:  gtk3-devel
BuildRequires:  gtkmm3.0-devel
BuildRequires:  jasper-devel
BuildRequires:  java-21-openjdk-headless
BuildRequires:  libiodbc-devel
BuildRequires:  libsecret-devel
BuildRequires:  libuuid-devel
BuildRequires:  libxml2-devel
BuildRequires:  libzip-devel
BuildRequires:  make
BuildRequires:  mesa-libGL-devel
BuildRequires:  mysql8.0-devel
BuildRequires:  mysql-connector-cpp-devel
BuildRequires:  pcre-devel
BuildRequires:  proj-devel
BuildRequires:  python3-devel
BuildRequires:  rapidjson-devel
BuildRequires:  sqlite-devel
BuildRequires:  swig
BuildRequires:  tar
BuildRequires:  vsqlitepp-devel

Requires:   gdal
Requires:   gnome-keyring
Suggests:   mysql8.0-server

%description
MySQL Workbench is a unified visual tool for database architects, developers,
and DBAs. MySQL Workbench provides data modeling, SQL development, and
comprehensive administration tools for server configuration, user
administration, backup, and much more. MySQL Workbench is available on
Windows, Linux and Mac OS X.


%prep
%autosetup -p1 -n %{name}-%{version}-src

cp %SOURCE1 %{_builddir}

# Don't fail on warnings
sed -r -i 's/ \-Werror//g' CMakeLists.txt

# Replace `SWIG_Python_AppendOutput` with `SWIG_AppendOutput` for
# compatibility with SWIG 4.3.x
sed -r \
    -e 's/SWIG_Python_AppendOutput/SWIG_AppendOutput/g' \
    -i library/forms/swig/mforms.i library/forms/swig/cairo.i


%build
# Lower fortification level. At level 3 - the default - Workbench crashes
# with SEGFAULT when parsing SQL statements.
%define _fortify_level 2

%cmake \
       -DCMAKE_BUILD_TYPE=RelWithDebInfo \
       -DREAL_EXECUTABLE_DIR=%{_libexecdir}/mysql-workbench \
       -DBoost_NO_BOOST_CMAKE=ON \
       -DIODBC_INCLUDE_PATH=%{_includedir} \
       -DIODBC_CONFIG_PATH=%{_bindir}/iodbc-config \
       -DANTLR4_INCLUDE_DIR=%{_includedir} \
       -DANTLR4_LIBRARIES="-L%{_libdir} -lantlr4-runtime" \
       -DANTLR_JAR_PATH=%{_builddir} \
       -DMySQLCppConn_INCLUDE_DIR=%{_includedir}/jdbc 

%cmake_build


%install
%cmake_install

rm -fvr %{buildroot}/usr/share/doc/mysql-workbench*

find %{buildroot}%{_libdir}/mysql-workbench -name \*.a  -exec rm {} \; -print
find %{buildroot}%{_libdir}/mysql-workbench -name \*.la -exec rm {} \; -print

find %{buildroot} -name \*.sh -exec chmod a+x {} \; -print
chmod a+x %{buildroot}%{_datadir}/mysql-workbench/mysqlwbmeb.py

%py3_shebang_fix %{buildroot}/*

# Provide required symlink or workbench will error when connecting
# https://bugs.mysql.com/bug.php?id=47238
# https://bugs.mysql.com/bug.php?id=48507
ln -s $(find %{_libdir} -name libmysqlclient\* | grep -E 'so\.[0-9]+$') \
      %{buildroot}%{_libdir}/mysql-workbench/libmysqlclient_r.so


%post
touch --no-create %{_datadir}/icons/hicolor || :
if [ -x %{_bindir}/gtk-update-icon-cache ]; then
   %{_bindir}/gtk-update-icon-cache --quiet %{_datadir}/icons/hicolor || :
fi

if [ -x %{_bindir}/update-desktop-database ]; then
    %{_bindir}/update-desktop-database
fi

if [ -x %{_bindir}/update-mime-database ]; then
    %{_bindir}/update-mime-database %{_datadir}/mime 2>&1 > /dev/null || :
fi


%postun
touch --no-create %{_datadir}/icons/hicolor || :
if [ -x %{_bindir}/gtk-update-icon-cache ]; then
   %{_bindir}/gtk-update-icon-cache --quiet %{_datadir}/icons/hicolor || :
fi

if [ -x %{_bindir}/update-desktop-database ]; then
    %{_bindir}/update-desktop-database
fi

if [ -x %{_bindir}/update-mime-database ]; then
    %{_bindir}/update-mime-database %{_datadir}/mime 2>&1 > /dev/null || :
fi


%files
%defattr(0644, root, root, 0755)
%doc README.md
%license License.txt

%attr(0755,root,root) %{_bindir}/mysql-workbench
%attr(0755,root,root) %{_bindir}/wbcopytables

%dir %{_libexecdir}/mysql-workbench
%attr(0755,root,root) %{_libexecdir}/mysql-workbench/mysql-workbench-bin
%attr(0755,root,root) %{_libexecdir}/mysql-workbench/wbcopytables-bin

%{_libdir}/mysql-workbench

%{_datadir}/mysql-workbench
%{_datadir}/icons/hicolor/*/mimetypes/*
%{_datadir}/icons/hicolor/*/apps/*
%{_datadir}/mime-info/*
%{_datadir}/mime/packages/*
%{_datadir}/applications/*.desktop


%changelog
## START: Generated by rpmautospec
* Tue Oct 21 2025 Sandro <devel@penguinpee.nl> - 8.0.43-2
- Lower fortification level

* Sat Oct 18 2025 Sandro <devel@penguinpee.nl> - 8.0.43-1
- Update to 8.0.43
- Apply patch replacing deprecated `pipes` module

* Fri Oct 17 2025 Sandro <devel@penguinpee.nl> - 8.0.42-3
- Build against MySQL 8.0

* Wed Sep 03 2025 Sandro <devel@penguinpee.nl> - 8.0.42-2
- Add symlink to libmysqlclient as workaround

* Wed Sep 03 2025 Sandro <devel@penguinpee.nl> - 8.0.42-1
- Initial package
## END: Generated by rpmautospec