New package, bug #126170

(Portage version: 2.1.6.4/cvs/Linux 2.6.28-gentoo i686)

4 files changed, 133 insertions, 0 deletions

diff --git a/dev-db/sqldeveloper/ChangeLog b/dev-db/sqldeveloper/ChangeLog
new file mode 100644
index 000000000000..41685bb0cd8a
--- /dev/null
+++ b/dev-db/sqldeveloper/ChangeLog
@@ -0,0 +1,10 @@
+# ChangeLog for dev-db/sqldeveloper
+# Copyright 1999-2009 Gentoo Foundation; Distributed under the GPL v2
+# $Header: /var/cvsroot/gentoo-x86/dev-db/sqldeveloper/ChangeLog,v 1.1 2009/01/18 05:28:01 bluebird Exp $
+
+*sqldeveloper-1.5.3.5783 (18 Jan 2009)
+
+  18 Jan 2009; Friedrich Oslage <bluebird@gentoo.org> +files/sqldeveloper,
+  +metadata.xml, +sqldeveloper-1.5.3.5783.ebuild:
+  New package, bug #126170
+
diff --git a/dev-db/sqldeveloper/files/sqldeveloper b/dev-db/sqldeveloper/files/sqldeveloper
new file mode 100644
index 000000000000..603501ab2108
--- /dev/null
+++ b/dev-db/sqldeveloper/files/sqldeveloper
@@ -0,0 +1,8 @@
+#!/bin/bash
+# Copyright 1999-2009 Gentoo Foundation
+# Distributed under the terms of the GNU General Public License v2
+
+# skip their stupid [ -f `which java` ] test, which will always fail on Gentoo
+export APP_SKIP_J2SE_TEST=1
+
+cd /opt/sqldeveloper/sqldeveloper/bin && bash sqldeveloper $@
diff --git a/dev-db/sqldeveloper/metadata.xml b/dev-db/sqldeveloper/metadata.xml
new file mode 100644
index 000000000000..c6119ad4ec46
--- /dev/null
+++ b/dev-db/sqldeveloper/metadata.xml
@@ -0,0 +1,15 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE pkgmetadata SYSTEM "http://www.gentoo.org/dtd/metadata.dtd">
+<pkgmetadata>
+	<herd>no-herd</herd>
+	<maintainer>
+		<email>bluebird@gentoo.org</email>
+		<name>Friedrich Oslage</name>
+	</maintainer>
+	<longdescription>Oracle SQL Developer is a free and fully supported
+	graphical tool for database development. With SQL Developer, you can browse
+	database objects, run SQL statements and SQL scripts, and edit and debug
+	PL/SQL statements. You can also run any number of provided reports, as well
+	as create and save your own. SQL Developer enhances productivity and
+	simplifies your database development tasks.</longdescription>
+</pkgmetadata>
diff --git a/dev-db/sqldeveloper/sqldeveloper-1.5.3.5783.ebuild b/dev-db/sqldeveloper/sqldeveloper-1.5.3.5783.ebuild
new file mode 100644
index 000000000000..17c3d4fd2b86
--- /dev/null
+++ b/dev-db/sqldeveloper/sqldeveloper-1.5.3.5783.ebuild
@@ -0,0 +1,100 @@
+# Copyright 1999-2009 Gentoo Foundation
+# Distributed under the terms of the GNU General Public License v2
+# $Header: /var/cvsroot/gentoo-x86/dev-db/sqldeveloper/sqldeveloper-1.5.3.5783.ebuild,v 1.1 2009/01/18 05:28:01 bluebird Exp $
+
+EAPI="2"
+
+inherit eutils versionator
+
+MY_PV="$(get_version_component_range 4)"
+
+DESCRIPTION="Oracle SQL Developer is a graphical tool for database development"
+HOMEPAGE="http://www.oracle.com/technology/products/database/sql_developer/"
+SRC_URI="${PN}-${MY_PV}-no-jre.zip"
+RESTRICT="fetch"
+
+LICENSE="OTN"
+SLOT="0"
+KEYWORDS="~amd64 ~x86"
+IUSE="mssql mysql sybase"
+
+DEPEND="mssql? ( dev-java/jtds )
+	mysql? ( dev-java/jdbc-mysql )
+	sybase? ( dev-java/jtds )"
+RDEPEND=">=virtual/jdk-1.5.0
+	${DEPEND}"
+
+S="${WORKDIR}/${PN}"
+
+pkg_nofetch() {
+	eerror "Please go to"
+	eerror "	${HOMEPAGE}"
+	eerror "and download"
+	eerror "	Oracle SQL Developer for other platforms"
+	eerror "		${SRC_URI}"
+	eerror "and move it to ${DISTDIR}"
+}
+
+src_prepare() {
+	# we don't need these, do we?
+	find ./ -iname "*.exe" -or -iname "*.dll" -exec rm {} \;
+}
+
+src_configure() {
+	# they both use jtds, enabling one of them also enables the other one
+	if use mssql && ! use sybase; then
+		einfo "You requested MSSQL support, this also enables Sybase support."
+	fi
+	if use sybase && ! use mssql; then
+		einfo "You requested Sybase support, this also enables MSSQL support."
+	fi
+
+	if use mssql || use sybase; then
+		jtds_version="$(best_version dev-java/jtds)"
+		jtds_version="${jtds_version/dev-java\/jtds-/}"
+		jtds_version="${jtds_version/-*/}"
+
+		if [ ! -e "${ROOT}/usr/share/jtds-${jtds_version}/lib/jtds.jar" ]; then
+			eerror "$(best_version dev-java/jtds) does not provide jtds.jar!"
+			die "Cannot find jtds.jar"
+		fi
+
+		echo "AddJavaLibFile /usr/share/jtds-${jtds_version}/lib/jtds.jar" \
+			>> sqldeveloper/bin/sqldeveloper.conf
+	fi
+
+	if use mysql; then
+		if [ ! -e "${ROOT}"/usr/share/jdbc-mysql/lib/jdbc-mysql.jar ]; then
+			eerror "$(best_version jdbc-mysql) does not provide jdbc-mysql.jar!"
+			die "Cannot find jdbc-mysql.jar"
+		fi
+
+		echo "AddJavaLibFile /usr/share/jdbc-mysql/lib/jdbc-mysql.jar" \
+			>> sqldeveloper/bin/sqldeveloper.conf
+	fi
+}
+
+src_install() {
+	dodir /opt/${PN}
+	cp -r {BC4J,dvt,ide,j2ee,jdbc,jdev,jlib,lib,rdbms,${PN},timingframework} \
+		"${D}"/opt/${PN}/ || die "Install failed"
+
+	dobin "${FILESDIR}"/${PN} || die "Install failed"
+
+	mv icon.png ${PN}-32x32.png
+	mv raptor_image.jpg ${PN}-48x48.jpg
+	doicon ${PN}-32x32.png ${PN}-48x48.jpg
+	make_desktop_entry ${PN} "Oracle SQL Developer" ${PN}-32x32
+
+	dodoc relnotes.html
+}
+
+pkg_postinst() {
+	if ! has_version dev-db/oracle-instantclient-basic; then
+		echo
+		einfo "You can connect to Oracle databases using the Basic"
+		einfo "connection type. If you want to use TNS based connections please"
+		einfo "also install dev-db/oracle-instantclient-basic."
+		echo
+	fi
+}