%define build_java 0
%define build_autotools 1
# commandline overrides:
# rpm -ba|--rebuild --with 'xxx'
%{?_with_java: %{expand: %%global build_java 1}}
%{?_without_java: %{expand: %%global build_java 0}}
%{?_with_autotools: %{expand: %%global build_autotools 1}}
%{?_without_autotools: %{expand: %%global build_autotools 0}}
%define r_ver r12
%define ma_realversion 1.2.12
%define qb_realversion 1.2.12
%define wb_realversion 1.1.10
%define libname %mklibname 0
Summary: GUI Tools for MySQL 5.0 - common files
Name: mysql-gui-tools
Group: Databases
Version: 5.0
Release: %mkrel 1.%{r_ver}.1
License: GPL
URL: http://www.mysql.com/products/tools/
Source: ftp://ftp.sunet.se/pub/databases/relational/mysql/Downloads/MySQLGUITools/%{name}-%{version}%{r_ver}.tar.gz
Patch0: mysql-gui-tools-mdv_conf.diff
Patch1: mysql-gui-tools-drop_borked_tests.diff
BuildRequires: autoconf2.5
BuildRequires: expat-devel
BuildRequires: file
BuildRequires: gettext-devel
BuildRequires: glib2-devel
BuildRequires: glibmm2.4-devel
BuildRequires: gtk2-devel
BuildRequires: gtkmm2.4-devel
BuildRequires: ImageMagick
BuildRequires: libext2fs-devel
BuildRequires: libglade2.0-devel >= 2.5
BuildRequires: libsigc++2.0-devel
BuildRequires: libslang-devel
BuildRequires: libxml2-devel
%if %mdkversion < 200700
BuildRequires: libgtkhtml-3.6-devel
BuildRequires: liblua-devel >= 5.0.2
BuildRequires: Mesa-devel
BuildRequires: MesaGLU-devel
%else
BuildRequires: libfcgi-devel
BuildRequires: libgtkhtml-3.14-devel
BuildRequires: libtool
BuildRequires: lua5.0-devel
BuildRequires: mesagl-devel
BuildRequires: mesaglu-devel
%endif
%if %{build_java}
BuildRequires: junit
BuildRequires: java-gcj-compat-devel
BuildRequires: jpackage-utils
%endif
BuildRequires: MySQL-devel >= 5.0
BuildRequires: ncurses-devel
BuildRequires: pcre-devel >= 5.0
BuildRequires: pkgconfig
BuildRequires: python-devel
BuildRequires: readline-devel
BuildRequires: termcap-devel
BuildRequires: libgnomeprint-devel >= 2.2.0
BuildRoot: %{_tmppath}/%{name}-%{version}-%{release}-root
%description
GUI Tools for MySQL 5.0 is a suite of applications written for developing and
managing MySQL servers.
This package contains data files and libraries for MySQL GUI Tools. Actual
applications are in packages mysql-administrator, mysql-query-browser and
mysql-workbench
%package -n mysql-administrator
Summary: Administration tool for MySQL 5.0
Group: Databases
Requires: mysql-gui-tools = %{version}
%description -n mysql-administrator
MySQL Administrator is a powerful graphical administration console that enables
you to easily administer your MySQL environment and gain significantly better
visibility into how your databases are operating. MySQL Administrator now
integrates database management and maintenance into a single, seamless
environment, with a clear and intuitive graphical user interface.
This is MySQL Administrator %{ma_realversion}.
%package -n mysql-query-browser
Summary: Query shell for MySQL 5.0
Group: Databases
Requires: mysql-gui-tools = %{version}
%description -n mysql-query-browser
MySQL Query Browser is a GUI tool for executing SQL queries. It will display
the result in a list where you can edit its contents and save. It has several
auxiliar features to facilitate work, such as query "bookmarking", query
history, syntax highlighting and online help.
This is MySQL QueryBrowser %{qb_realversion}.
%package -n mysql-workbench
Summary: Extensible modeling tool for MySQL 5.0
Group: Databases
Requires: mysql-gui-tools = %{version}
%description -n mysql-workbench
MySQL Workbench is modeling tool that allows you to design and generate MySQL
databases graphically.
MySQL Workbench requires OpenGL and a 3D accelerated graphics card with at
least 16MB of memory.
This is MySQL Workbench %{wb_realversion}.
%prep
%setup -q -n %{name}-%{version}%{r_ver}
%patch0 -p1
%patch1 -p0
%if %{build_java}
%if %mdkversion >= 200700
# remove binary-only jars from filesystem
%{__rm} mysql-gui-common/res/java/jtds-1.2.jar
%{__rm} mysql-gui-common/res/java/junit.jar
%{__ln_s} %{_javadir}/junit.jar mysql-gui-common/res/java/junit.jar
%{__rm} mysql-gui-common/res/java/mysql-connector-java-5.0.4-bin.jar
%{__rm} mysql-gui-common/res/java/sapdbc-7_6_00_12_4339.jar
# remove references to binary jars from java Makefile
%{__perl} -pi -e 's/^javalib_DATA=.*/javalib_DATA=/' mysql-gui-common/source/java/Makefile.{am,in}
%endif
%endif
# strip away annoying ^M
find . -type f|xargs file|grep 'CRLF'|cut -d: -f1|xargs perl -p -i -e 's/\r//'
find . -type f|xargs file|grep 'text'|cut -d: -f1|xargs perl -p -i -e 's/\r//'
%build
# gui-common
pushd mysql-gui-common
%if %{build_autotools}
sh ./autogen.sh \
--prefix=%{_prefix} \
--bindir=%{_bindir} \
--sbindir=%{_sbindir} \
--sysconfdir=%{_sysconfdir} \
--datadir=%{_datadir} \
--includedir=%{_includedir} \
--libdir=%{_libdir} \
--libexecdir=%{_libexecdir} \
--localstatedir=%{_localstatedir} \
--mandir=%{_mandir} \
--enable-grt \
--enable-python-modules \
%if %mdkversion >= 200700
--enable-fastcgi \
%if %{build_java}
--enable-java-modules \
--with-java-includes=%{java_home}/include \
%else
--disable-java-modules \
%endif
%endif
--enable-readline \
--enable-canvas
%endif
%configure2_5x \
--enable-grt \
--enable-python-modules \
%if %mdkversion >= 200700
--enable-fastcgi \
%if %{build_java}
--enable-java-modules \
--with-java-includes=%{java_home}/include \
%else
--disable-java-modules \
%endif
%endif
--enable-readline \
--enable-canvas
%make
popd
# administrator
pushd mysql-administrator
%if %{build_autotools}
sh ./autogen.sh \
--prefix=%{_prefix} \
--bindir=%{_bindir} \
--sbindir=%{_sbindir} \
--sysconfdir=%{_sysconfdir} \
--datadir=%{_datadir} \
--includedir=%{_includedir} \
--libdir=%{_libdir} \
--libexecdir=%{_libexecdir} \
--localstatedir=%{_localstatedir} \
--mandir=%{_mandir}
%endif
%configure2_5x
%make
popd
# query-browser
pushd mysql-query-browser
%if %{build_autotools}
sh ./autogen.sh \
--prefix=%{_prefix} \
--bindir=%{_bindir} \
--sbindir=%{_sbindir} \
--sysconfdir=%{_sysconfdir} \
--datadir=%{_datadir} \
--includedir=%{_includedir} \
--libdir=%{_libdir} \
--libexecdir=%{_libexecdir} \
--localstatedir=%{_localstatedir} \
--mandir=%{_mandir} \
%if %mdkversion < 200700
--with-gtkhtml=libgtkhtml-3.6
%else
--with-gtkhtml=libgtkhtml-3.14
%endif
%endif
%configure2_5x \
%if %mdkversion < 200700
--with-gtkhtml=libgtkhtml-3.6
%else
--with-gtkhtml=libgtkhtml-3.14
%endif
%make
popd
# workbench
pushd mysql-workbench
%if %{build_autotools}
sh ./autogen.sh \
--prefix=%{_prefix} \
--bindir=%{_bindir} \
--sbindir=%{_sbindir} \
--sysconfdir=%{_sysconfdir} \
--datadir=%{_datadir} \
--includedir=%{_includedir} \
--libdir=%{_libdir} \
--libexecdir=%{_libexecdir} \
--localstatedir=%{_localstatedir} \
--mandir=%{_mandir}
%endif
%configure2_5x
%make
popd
%install
rm -rf %{buildroot}
%makeinstall_std -C mysql-gui-common
# fix some menu entries and stuff...
install -d %{buildroot}%{_miconsdir}
install -d %{buildroot}%{_iconsdir}
install -d %{buildroot}%{_liconsdir}
install -d %{buildroot}%{_menudir}
################################################################################
# mysql-administrator
%makeinstall_std -C mysql-administrator
cat > %{buildroot}%{_menudir}/mysql-administrator <<EOF
?package(mysql-administrator): \
command="%{_bindir}/mysql-administrator" \
section="More Applications/Databases" \
icon="mysql-administrator.png" \
needs="x11" \
kde_filename="mysql-administrator" \
title="MySQL Administrator" \
longtitle="Administration tool for MySQL 5.0" \
xdg="true"
EOF
rm -f %{buildroot}%{_datadir}/applications/MySQLAdministrator.desktop
cat > %{buildroot}%{_datadir}/applications/mysql-administrator.desktop << EOF
[Desktop Entry]
Name=MySQL Administrator
Comment=MySQL Administration Tool
Exec=%{_bindir}/mysql-administrator
Terminal=false
Type=Application
Icon=mysql-administrator.png
Categories=X-MandrivaLinux-MoreApplications-Databases;GTK;Database;Development;Application
EOF
# make some icons
convert %{buildroot}%{_datadir}/mysql-gui/MySQLIcon_Admin_48x48.png -resize 16x16 %{buildroot}%{_miconsdir}/mysql-administrator.png
convert %{buildroot}%{_datadir}/mysql-gui/MySQLIcon_Admin_48x48.png -resize 32x32 %{buildroot}%{_iconsdir}/mysql-administrator.png
convert %{buildroot}%{_datadir}/mysql-gui/MySQLIcon_Admin_48x48.png -resize 48x48 %{buildroot}%{_liconsdir}/mysql-administrator.png
%find_lang mysql-administrator --all-name
################################################################################
# mysql-query-browser
%makeinstall_std -C mysql-query-browser
cat > %{buildroot}%{_menudir}/mysql-query-browser <<EOF
?package(mysql-query-browser): \
command="%{_bindir}/mysql-query-browser" \
section="More Applications/Databases" \
icon="mysql-query-browser.png" \
needs="x11" \
kde_filename="mysql-query-browser" \
title="MySQL Query Browser" \
longtitle="Query shell for MySQL 5.0" \
xdg="true"
EOF
rm -f %{buildroot}%{_datadir}/applications/MySQLQueryBrowser.desktop
cat > %{buildroot}%{_datadir}/applications/mysql-query-browser.desktop << EOF
[Desktop Entry]
Name=MySQL Query Browser
Comment=MySQL Query Tool
Exec=%{_bindir}/mysql-query-browser
Terminal=false
Type=Application
Icon=mysql-query-browser.png
Categories=X-MandrivaLinux-MoreApplications-Databases;GTK;Database;Development;Application
EOF
# make some icons
convert %{buildroot}%{_datadir}/mysql-gui/MySQLIcon_QueryBrowser_48x48.png -resize 16x16 %{buildroot}%{_miconsdir}/mysql-query-browser.png
convert %{buildroot}%{_datadir}/mysql-gui/MySQLIcon_QueryBrowser_48x48.png -resize 32x32 %{buildroot}%{_iconsdir}/mysql-query-browser.png
convert %{buildroot}%{_datadir}/mysql-gui/MySQLIcon_QueryBrowser_48x48.png -resize 48x48 %{buildroot}%{_liconsdir}/mysql-query-browser.png
%find_lang mysql-query-browser --all-name
################################################################################
# mysql-workbench
%makeinstall_std -C mysql-workbench
cat > %{buildroot}%{_menudir}/mysql-workbench <<EOF
?package(mysql-workbench): \
command="%{_bindir}/mysql-workbench" \
section="More Applications/Databases" \
icon="mysql-workbench.png" \
needs="x11" \
kde_filename="mysql-workbench" \
title="MySQL Workbench" \
longtitle="MySQL Database Design Tool" \
xdg="true"
EOF
rm -f %{buildroot}%{_datadir}/applications/MySQLWorkbench.desktop
cat > %{buildroot}%{_datadir}/applications/mysql-workbench.desktop << EOF
[Desktop Entry]
Name=MySQL Workbench
Comment=MySQL Database Design Tool
Exec=%{_bindir}/mysql-workbench
Terminal=false
Type=Application
Icon=mysql-workbench.png
Categories=X-MandrivaLinux-MoreApplications-Databases;GTK;Database;Development;Application
EOF
# make some icons
convert %{buildroot}%{_datadir}/mysql-gui/MySQLIcon_Workbench_48x48.png -resize 16x16 %{buildroot}%{_miconsdir}/mysql-workbench.png
convert %{buildroot}%{_datadir}/mysql-gui/MySQLIcon_Workbench_48x48.png -resize 32x32 %{buildroot}%{_iconsdir}/mysql-workbench.png
convert %{buildroot}%{_datadir}/mysql-gui/MySQLIcon_Workbench_48x48.png -resize 48x48 %{buildroot}%{_liconsdir}/mysql-workbench.png
%post -n mysql-administrator
%update_menus
%postun -n mysql-administrator
%clean_menus
%post -n mysql-query-browser
%update_menus
%postun -n mysql-query-browser
%clean_menus
%post -n mysql-workbench
%update_menus
%postun -n mysql-workbench
%clean_menus
%clean
rm -rf %{buildroot}
%files
%defattr(-, root, root)
%doc mysql-gui-common/COPYING
%doc mysql-gui-common/README
%doc mysql-gui-common/README.translating
%dir %{_datadir}/mysql-gui
%{_datadir}/mysql-gui/common/*
%if %mdkversion >= 200700
%if %{build_java}
%{_libdir}/mysql-gui/libmyx_grt_java*
%endif
%endif
%files -n mysql-administrator -f mysql-administrator.lang
%defattr(-, root, root)
%doc mysql-administrator/ChangeLog
%doc mysql-administrator/COPYING
%doc mysql-administrator/res/FAQ
%attr(0755,root,root) %{_bindir}/mabackup
%attr(0755,root,root) %{_bindir}/mysql-administrator
%attr(0755,root,root) %{_bindir}/mysql-administrator-bin
%dir %{_datadir}/mysql-gui/administrator
%{_datadir}/mysql-gui/MySQLIcon_Admin*
%{_datadir}/mysql-gui/administrator/*
%{_datadir}/applications/mysql-administrator.desktop
%{_menudir}/mysql-administrator
%{_iconsdir}/mysql-administrator.png
%{_liconsdir}/mysql-administrator.png
%{_miconsdir}/mysql-administrator.png
%files -n mysql-query-browser -f mysql-query-browser.lang
%defattr(-, root, root)
%doc mysql-query-browser/COPYING
%doc mysql-query-browser/res/ChangeLog
%dir %{_datadir}/mysql-gui/query-browser
%{_datadir}/mysql-gui/query-browser/*
%attr(0755,root,root) %{_bindir}/mysql-query-browser
%attr(0755,root,root) %{_bindir}/mysql-query-browser-bin
%{_datadir}/mysql-gui/MySQLIcon_Query*
%{_datadir}/applications/mysql-query-browser.desktop
%{_menudir}/mysql-query-browser
%{_iconsdir}/mysql-query-browser.png
%{_liconsdir}/mysql-query-browser.png
%{_miconsdir}/mysql-query-browser.png
%files -n mysql-workbench
%defattr(-, root, root)
%doc mysql-workbench/COPYING
%doc mysql-workbench/ChangeLog
%doc mysql-workbench/README.linux
%attr(0755,root,root) %{_bindir}/mysql-workbench
%attr(0755,root,root) %{_bindir}/mysql-workbench-bin
%dir %{_datadir}/mysql-gui/workbench
%{_datadir}/mysql-gui/MySQLIcon_Workbench*
%{_datadir}/mysql-gui/workbench/*
%{_datadir}/applications/mysql-workbench.desktop
%{_menudir}/mysql-workbench
%{_iconsdir}/mysql-workbench.png
%{_liconsdir}/mysql-workbench.png
%{_miconsdir}/mysql-workbench.png
%changelog
* Tue May 15 2007 Oden Eriksson <oeriksson@mandriva.com> 5.0-1.r12.1mdv2008.0
+ Revision: 26869
- 5.0r12
* Wed Apr 04 2007 Oden Eriksson <oeriksson@mandriva.com> 5.0-1.r11.1mdv2007.1
+ Revision: 150588
- 5.0r11
* Wed Mar 14 2007 Oden Eriksson <oeriksson@mandriva.com> 5.0-1.r10.2mdv2007.1
+ Revision: 143621
- build it against libgtkhtml-3.14
* Sun Mar 04 2007 Oden Eriksson <oeriksson@mandriva.com> 5.0-1.r10.1mdv2007.1
+ Revision: 132103
- make it build (P1) and make it possible to skip the autopoo mangling
- 5.0r10
* Sun Jan 21 2007 Oden Eriksson <oeriksson@mandriva.com> 5.0-0.3.r9.1mdv2007.1
+ Revision: 111409
- increase release (0.3.x)
- 5.0r9
- rediffed P0
- make it backportable again (java)
* Sun Jan 07 2007 David Walluck <walluck@mandriva.org> 5.0-0.2.r8.4mdv2007.1
+ Revision: 105121
- BuildRequires: java-gcj-compat-devel
- enable java support
* Thu Dec 21 2006 Oden Eriksson <oeriksson@mandriva.com> 5.0-0.2.r8.3mdv2007.1
+ Revision: 101086
- make it backportable for cs4
- use www-browser instead of gnome-www-browser in MAdministrator.cc
* Thu Dec 21 2006 Oden Eriksson <oeriksson@mandriva.com> 5.0-0.2.r8.2mdv2007.1
+ Revision: 101004
- fix release
- 5.0r8
* Fri Dec 08 2006 Oden Eriksson <oeriksson@mandriva.com> 5.0-0.2.r6.1mdv2007.1
+ Revision: 93645
- added the remaining missing build deps
- rebuilt due to build system flux
- added libext2fs-devel as a build dep
- fix deps
- added mysql-gui-tools-mdv_conf.diff (P0) to set some mdv defaults
- Import mysql-gui-tools
* Thu Dec 07 2006 Oden Eriksson <oeriksson@mandriva.com> 5.0-0.1.r6.1mdv2007.1
- 5.0r6
- initial Mandriva package
- merged spec file stuff from the mysql-administrator and mysql-query-browser packages
