# $Id$

PNAME="mysql"
PVER="5.5.40"
PBUILD="r1"

SPLIT_PACKAGES="mysql-libs mysql-clients mysql"

PCAT="dev-db"
HOMEPAGE="http://www.mysql.com/"

COMMON_DEPEND=">= sys-libs/zlib-1.2
	>= sys-libs/libstdc++-4.8
	>= dev-libs/openssl-1.0.1
	>= sys-apps/tcp-wrappers-7"
SDEPEND="${COMMON_DEPEND}
	>= virtual/sed"

SRCFILE="${PNAME}-${PVER}.tar.gz"
SRCDIR="${BUILDDIR}/${PNAME}-${PVER}"

# support variable pname in postinstall
myPNAME="${PNAME}"
SPECIAL_VARS="myPNAME"

sminclude mtools cmake systemd

SRC_URI=(
	ftp://ftp.mysql.com/pub/${PNAME}/src/${SRCFILE}
	http://ftp.gwdg.de/pub/misc/${PNAME}/Downloads/MySQL-${PVER%.*}/${SRCFILE}
	mirror://${PNAME}/${SRCFILE}
	mirror://${PNAME}/mysql.tmpfile
	mirror://${PNAME}/mysqld.service
	mirror://${PNAME}/mysqld.socket
	mirror://${PNAME}/${PNAME}-5.5.19-cnf-defaults.patch
)

UP2DATE="updatecmd http://dev.mysql.com/ | grep GA | sed 's:.*\]\([0-9].*\)\ GA.*:\1:;q'"

split_info_mysql-libs()
{
	DESCRIPTION="MySQL client libraries"
	DEPEND="${COMMON_DEPEND}"	
	PROVIDE="virtual/mysql-libs"
}

split_info_mysql-clients()
{
	DESCRIPTION="MySQL client utilities."
	DEPEND="== dev-db/mysql-libs-${PVER}"
	PROVIDE="virtual/mysql-clients"
}

split_info_mysql()
{
	DESCRIPTION="MySQL is a SQL (Structured Query Language) database server."
	DEPEND="== dev-db/mysql-clients-${PVER}"
	PROVIDE="virtual/mysql"
}

pkg_setup()
{
	# warn about /proc in chroot environments
	[[ ! -d /proc/sys ]] && die "Please make sure /proc is mounted in chroot-environments."

	preinstall_mysql
}

src_prepare()
{
	munpack ${SRCFILE} || die
	cd ${SRCDIR}

	# apply our configuration
	mpatch ${PNAME}-5.5.19-cnf-defaults.patch || die

	# fix broken install logic:
	# always defaults to ./bin/my_print_default, using STANDARTLAYOUT
	# see srcdir/cmake/install_layout.cmake and srcdir/scripts/CMakeLists.txt
	sed -i 's:SET(prefix "."):SET(prefix "${CMAKE_INSTALL_PREFIX}"):' scripts/CMakeLists.txt || die
}

src_compile()
{
	cd ${SRCDIR}

	# fixes some issues
	export CFLAGS="${CFLAGS} -fno-exceptions -fno-strict-aliasing -DBIG_JOINS=1 -fomit-frame-pointer"
	export CXXFLAGS="${CXXFLAGS} -felide-constructors -fno-rtti -fno-implicit-templates -fno-strict-aliasing -DBIG_JOINS=1 "

	# fix PIC issues
	export CFLAGS="${CFLAGS} -fPIC"
	export CXXFLAGS="${CXXFLAGS} -fPIC"

	cmake_configure \
		-DWITH_COMMENT="Magellan MySQL ${PVER}-${PBUILD}" \
		$(cmake_install BINDIR bin) \
		$(cmake_install SBINDIR sbin) \
		$(cmake_install DOCDIR share/doc/${PNAME}) \
		$(cmake_install DOCREADMEDIR share/doc/${PNAME}) \
		$(cmake_install INCLUDEDIR include/${PNAME}) \
		$(cmake_install INFODIR share/info) \
		$(cmake_install LIBDIR $(mlibdir)/${PNAME}) \
		$(cmake_install MANDIR share/man) \
		$(cmake_install MYSQLDATADIR /var/lib/${PNAME}) \
		$(cmake_install MYSQLSHAREDIR share/${PNAME}) \
		$(cmake_install MYSQLTESTDIR share/${PNAME}/mysql-test) \
		$(cmake_install PLUGINDIR $(mlibdir)/${PNAME}/plugin) \
		$(cmake_install SCRIPTDIR bin) \
		$(cmake_install SQLBENCHDIR share/${PNAME}) \
		$(cmake_install SUPPORTFILESDIR /usr/share/${PNAME}) \
		$(cmake_opt SYSCONFDIR /etc/${PNAME}) \
		$(cmake_opt MYSQL_USER mysql) \
		$(cmake_opt MYSQL_UNIX_ADDR /run/${PNAME}/mysqld.sock) \
		$(cmake_opt ENABLED_LOCAL_INFILE ON) \
		$(cmake_opt EXTRA_CHARSETS all) \
		$(cmake_opt DEFAULT_CHARSET utf8) \
		$(cmake_opt DEFAULT_COLLATION utf8_general_ci) \
		$(cmake_without READLINE) \
		$(cmake_with ZLIB system) \
		$(cmake_with SSL system) \
		$(cmake_with LIBWRAP) \
		$(cmake_with EMBEDDED_SERVER) \
		$(cmake_with INNOBASE_STORAGE_ENGINE) \
		$(cmake_with PARTITION_STORAGE_ENGINE) \
		$(cmake_without EXAMPLE_STORAGE_ENGINE) \
		$(cmake_without ARCHIVE_STORAGE_ENGINE) \
		$(cmake_without BLACKHOLE_STORAGE_ENGINE) \
		$(cmake_without FEDERATED_STORAGE_ENGINE) \
		$(cmake_without UNIT_TESTS) \
		|| die

	mmake || die
}

src_install_mysql-libs()
{
	cd ${SRCDIR}

	# install only includes and clients libraries
	local i
	for i in include libmysql libmysqld libservices
	do
		mmake -C ${i} DESTDIR=${BINDIR} install || die
	done

	# symlink client libs to libdir
	pushd ${BINDIR}/usr/$(mlibdir) || die
	for i in mysql/libmysqlclient{,_r}.so*
	do
		mlink ${i} /usr/$(mlibdir) || die
	done
	popd

	# mysql-config
	minstallexec scripts/mysql_config || die

	# man-pages
	for i in mysql_config mysql_client_test_embedded mysqltest_embedded
	do
		minstallman man/${i}.1 || die
	done
}

src_install_mysql-clients()
{
	cd ${SRCDIR}
	mmake -C client DESTDIR=${BINDIR} install || die

	# some common symlinks
	for i in mysqlanalyze mysqlrepair mysqloptimize
	do
		mlink mysqlcheck /usr/bin/${i} || die
	done

	# man-pages
	local i
	for i in mysql mysqladmin mysqlcheck mysqldump mysqlimport mysqlshow mysqlslap
	do
		minstallman man/${i}.1 || die
	done

	# provided by mysql
	mdelete /usr/bin/mysql_upgrade || die
	mdelete /usr/bin/mysqlbinlog || die
	mdelete /usr/bin/mysqltest || die
}

src_install_mysql()
{
	cd ${SRCDIR}
	mmake DESTDIR=${BINDIR} install || die

	# remove all unneeded stuff
	local i
	# dirs
	for i in sql-bench mysql-test
	do
		if [[ -d ${BINDIR}/usr/share/${PNAME}/${i} ]]
		then
			mdelete -r /usr/share/${PNAME}/${i} || die
		fi
	done
	if [[ -d ${BINDIR}/usr/data ]]
	then
		mdelete -r /usr/data || die
	fi
	# files
	for i in share/${PNAME}/mysql-log-rotate \
		share/${PNAME}/mysql.server* \
		share/${PNAME}/binary-configure* \
		share/${PNAME}/my-*.cnf \
		share/${PNAME}/mi_test_all* \
		bin/comp_err \
		share/man/man1/mysql-test-run.pl.1
	do
		if [[ -f ${BINDIR}/usr/${i} ]]
		then
			mdelete /usr/${i} || die
		fi
	done

	# provided by mysql-libs
	mdelete /usr/bin/mysql_config || die
	mdelete /usr/bin/mysql_client_test_embedded || die
	mdelete /usr/bin/mysqltest_embedded || die
	mdelete /usr/$(mlibdir)/${PNAME}/libmysql\* || die
	mdelete -r /usr/include/ || die
	mdelete /usr/share/man/man1/mysql_config.1 || die
	mdelete /usr/share/man/man1/mysql_client_test_embedded.1 || die
	mdelete /usr/share/man/man1/mysqltest_embedded.1 || die

	# provided by mysql-clients
	mdelete /usr/bin/mysql || die
	mdelete /usr/bin/mysqladmin || die
	mdelete /usr/bin/mysqlcheck || die
	mdelete /usr/bin/mysqldump || die
	mdelete /usr/bin/mysqlimport || die
	mdelete /usr/bin/mysqlshow || die
	mdelete /usr/bin/mysqlslap || die
	mdelete /usr/share/man/man1/mysql.1 || die
	mdelete /usr/share/man/man1/mysqladmin.1 || die
	mdelete /usr/share/man/man1/mysqlcheck.1 || die
	mdelete /usr/share/man/man1/mysqldump.1 || die
	mdelete /usr/share/man/man1/mysqlimport.1 || die
	mdelete /usr/share/man/man1/mysqlshow.1 || die
	mdelete /usr/share/man/man1/mysqlslap.1 || die

	# needed directories
	mkeepdir /var/lib/${PNAME} || die
	mchown mysql:mysql /var/lib/${PNAME} || die
	mchmod 0750 /var/lib/${PNAME} || die

	mkeepdir /run/${PNAME} || die
	mchown mysql:mysql /run/${PNAME} || die

	mkeepdir /var/log/${PNAME} || die
	mchown mysql:mysql /var/log/${PNAME} || die

	minstalldocs ChangeLog COPYING EXCEPTIONS-CLIENT README || die
	minstalldocs support-files/my-*.cnf support-files/magic || die
	minstalldocs support-files/ndb-config-2-node.ini || die

	# install a default my.cnf
	minstalldir /etc/${PNAME} || die
	minstallfile support-files/my-medium.cnf /etc/${PNAME}/my.cnf || die

	# systemd specific
	minstalltmp mysql.tmpfile mysql.conf || die
	minstallunit mysqld.service mysqld.service || die
	minstallunit mysqld.socket || die
}

preinstall_mysql()
{
	# adding mysql user
	mgroupadd -o "-g 60" mysql
	museradd -o "-u 60 -g mysql -d /dev/null -s /bin/false" mysql
}

postinstall_mysql()
{
	# create a database if none exists
	if [[ ! -d /var/lib/${myPNAME}/mysql ]]
	then
		echo "Creating the mysql database ..."
		mysql_install_db --user=mysql
		chown -R mysql:mysql /var/lib/${myPNAME}
		chmod 0750 /var/lib/${myPNAME}

		echo
		echo "Warning: The administrator password is empty!"
		echo "Please make sure to set one with following command:"
		echo "   mysqladmin -u root password <new-password>"
		echo
	fi

	# start the daemon - systemd
	mstartunit mysqld.socket
	mstartunit mysqld.service
}

postremove_mysql()
{
	if [ ! -f /usr/sbin/mysqld ]
	then
		# systemd
		mstopunit mysqld.service
		mstopunit mysqld.socket
	fi
}