New port: databases/sql-workbench

SQL Workbench/J is a free, DBMS-independent, cross-platform SQL
query tool. It is written in Java and should run on any operating
system that provides a Java Runtime Environment.

Its main focus is on running SQL scripts (either interactively or
as a batch) and export/import features. Graphical query building
or more advanced DBA tasks are not the focus and are not planned.

WWW: http://www.sql-workbench.net/

PR:		202116
Submitted by:	Aldis Berjoza <graudeejs@inbox.lv>

5 files changed, 92 insertions, 0 deletions

diff --git a/databases/sql-workbench/Makefile b/databases/sql-workbench/Makefile
new file mode 100644
index 000000000000..f812f3bc3a5c
--- /dev/null
+++ b/databases/sql-workbench/Makefile
@@ -0,0 +1,41 @@
+# Created by: Aldis Berjoza <graudeejs@gmail.com>
+# $FreeBSD$
+
+PORTNAME=	sql-workbench
+PORTVERSION=	118
+CATEGORIES=	databases java
+MASTER_SITES=	http://www.sql-workbench.net/ \
+	http://www.sql-workbench.net/archive/
+DISTNAME=	Workbench-Build${PORTVERSION}
+
+MAINTAINER=	graudeejs@gmail.com
+COMMENT=	DBMS-independent, cross-platform SQL query tool
+
+LICENSE=	APACHE20
+
+USES=		desktop-file-utils zip
+
+USE_JAVA=	yes
+JAVA_VERSION=	1.8+
+NO_BUILD=	yes
+
+WRKSRC=		${WRKDIR}
+
+OPTIONS_DEFINE=	DOCS MYSQL_JDBC PGSQL_JDBC ORACLE_JDBC
+ORACLE_JDBC_RUN_DEPENDS=${JAVALIBDIR}/ojdbc-10.2.0.5.jar:${PORTSDIR}/databases/jdbc-oracle10g
+MYSQL_JDBC_RUN_DEPENDS=	${JAVALIBDIR}/mysql-connector-java.jar:${PORTSDIR}/databases/mysql-connector-java
+PGSQL_JDBC_RUN_DEPENDS=	${JAVALIBDIR}/postgresql.jar:${PORTSDIR}/databases/postgresql-jdbc
+
+pre-install:
+	@${ECHO} "#!/bin/sh" > ${WRKSRC}/new_sqlworkbench.sh
+	@${ECHO} "${PREFIX}/bin/java -Dvisualvm.display.name=SQLWorkbench -Xmx512m -jar ${JAVAJARDIR}/sqlworkbench.jar" >> ${WRKSRC}/new_sqlworkbench.sh
+
+do-install:
+	(cd ${WRKSRC}/xslt && ${COPYTREE_SHARE} . ${STAGEDIR}${DATADIR}/xslt)
+	${INSTALL_DATA} ${WRKSRC}/SQLWorkbench-Manual.pdf ${STAGEDIR}${DOCSDIR}
+	${INSTALL_DATA} ${WRKSRC}/sqlworkbench.jar ${STAGEDIR}${JAVAJARDIR}
+	${INSTALL_DATA} ${WRKSRC}/SQLWorkbench.desktop ${STAGEDIR}${PREFIX}/share/applications
+	${INSTALL_DATA} ${WRKSRC}/workbench32.png ${STAGEDIR}${PREFIX}/share/pixmaps
+	${INSTALL_SCRIPT} ${WRKSRC}/new_sqlworkbench.sh ${STAGEDIR}${PREFIX}/bin/sqlworkbench
+
+.include <bsd.port.mk>
diff --git a/databases/sql-workbench/distinfo b/databases/sql-workbench/distinfo
new file mode 100644
index 000000000000..f3b3eb07402a
--- /dev/null
+++ b/databases/sql-workbench/distinfo
@@ -0,0 +1,2 @@
+SHA256 (Workbench-Build118.zip) = dcd1374af03db93f83a0025e605a9bf459d3b1212d48cce92fc9d1fa6ed8bad6
+SIZE (Workbench-Build118.zip) = 6517929
diff --git a/databases/sql-workbench/files/patch-SQLWorkbench.desktop b/databases/sql-workbench/files/patch-SQLWorkbench.desktop
new file mode 100644
index 000000000000..c7d2384550be
--- /dev/null
+++ b/databases/sql-workbench/files/patch-SQLWorkbench.desktop
@@ -0,0 +1,11 @@
+--- SQLWorkbench.desktop.orig	2015-08-05 22:10:56 UTC
++++ SQLWorkbench.desktop
+@@ -2,7 +2,7 @@
+ Comment=
+ Comment[en_US]=
+ Encoding=UTF-8
+-Exec=java -jar sqlworkbench.jar
++Exec=sqlworkbench
+ GenericName=Workbench
+ GenericName[en_US]=SQL Workbench/J
+ Icon=workbench32.png
diff --git a/databases/sql-workbench/pkg-descr b/databases/sql-workbench/pkg-descr
new file mode 100644
index 000000000000..4ad7b005c91b
--- /dev/null
+++ b/databases/sql-workbench/pkg-descr
@@ -0,0 +1,9 @@
+SQL Workbench/J is a free, DBMS-independent, cross-platform SQL
+query tool. It is written in Java and should run on any operating
+system that provides a Java Runtime Environment.
+
+Its main focus is on running SQL scripts (either interactively or
+as a batch) and export/import features. Graphical query building
+or more advanced DBA tasks are not the focus and are not planned.
+
+WWW: http://www.sql-workbench.net/
diff --git a/databases/sql-workbench/pkg-plist b/databases/sql-workbench/pkg-plist
new file mode 100644
index 000000000000..61898d751277
--- /dev/null
+++ b/databases/sql-workbench/pkg-plist
@@ -0,0 +1,29 @@
+bin/sqlworkbench
+share/applications/SQLWorkbench.desktop
+%%PORTDOCS%%%%DOCSDIR%%
+%%JAVAJARDIR%%/sqlworkbench.jar
+share/pixmaps/workbench32.png
+%%DATADIR%%/xslt/jdbctypes2oracle.xslt
+%%DATADIR%%/xslt/liquibase_common.xslt
+%%DATADIR%%/xslt/wbdiff2derby.xslt
+%%DATADIR%%/xslt/wbdiff2html.xslt
+%%DATADIR%%/xslt/wbdiff2liquibase.xslt
+%%DATADIR%%/xslt/wbdiff2mssql.xslt
+%%DATADIR%%/xslt/wbdiff2oracle.xslt
+%%DATADIR%%/xslt/wbdiff2pg.xslt
+%%DATADIR%%/xslt/wbdiff2simple_html.xslt
+%%DATADIR%%/xslt/wbexport2dbunit.xslt
+%%DATADIR%%/xslt/wbexport2dbunitflat.xslt
+%%DATADIR%%/xslt/wbexport2insert.xslt
+%%DATADIR%%/xslt/wbexport2lbinsert.xslt
+%%DATADIR%%/xslt/wbexport2text.xslt
+%%DATADIR%%/xslt/wbreport2benerator.xslt
+%%DATADIR%%/xslt/wbreport2confluence.xslt
+%%DATADIR%%/xslt/wbreport2ctl.xslt
+%%DATADIR%%/xslt/wbreport2html.xslt
+%%DATADIR%%/xslt/wbreport2liquibase.xslt
+%%DATADIR%%/xslt/wbreport2liquibase_multi.xslt
+%%DATADIR%%/xslt/wbreport2oracle.xslt
+%%DATADIR%%/xslt/wbreport2pg.xslt
+%%DATADIR%%/xslt/wbreport2pg_cleanupora.xslt
+%%DATADIR%%/xslt/wbreport2proc.xslt