From 82fd1755fc423b8c5838f487961507570ede81da Mon Sep 17 00:00:00 2001 From: asau Date: Mon, 20 Jul 2015 20:19:16 +0000 Subject: Import SQL Workbench/J build 117 as 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. Features: * Edit, insert and delete data directly in the query result. * Powerful export command to write text files (aka "CSV"), XML, HTML or SQL (including BLOB data). All user tables can be exported into a directory with a single command. Export files can be compressed "on-the-fly". * Powerful text, XML and spreadsheet import. A set of files (including compressed files) can be imported from a directory with a single command. Foreign key constraints are detected to insert the data in the correct order. * Compare two database schemas for differences. The XML output can be transformed into the approriate SQL ALTER statements using XSLT. * Compare the data of two database and generate the necessary SQL statements to migrate one to the other. * Supports running SQL scripts in batch mode. * Supports running in console mode. * Search text in procedure, view and other sources using a SQL command or a GUI. * Search for data across all columns in all tables using a SQL command or a GUI. * Reformatting (Pretty-Print) of SQL Statements. * Select rows from related tables according to their foreign key definitions. * Tooltips for INSERT statements to show the corresponding value or column. * Copy data directly between to database servers using a SQL command or a GUI. * Macros (aka aliases) for frequently used SQL statements. * Variable substitution in SQL statements including smart prompting for values (can be combined with macros). * Auto completion for tables and columns in SQL statements. * Display database objects and their definitions. * Display table source. * Display view, procedure and trigger source code. * Display foreign key constraints between tables. * Full support for BLOB data in query results, SQL statements, export and import. * SQLWorkbench/J is free for almost everyone (published under a modified the Apache 2.0 license). --- databases/sql-workbench/DESCR | 50 +++++++++++++++++++++++ databases/sql-workbench/Makefile | 31 +++++++++++++++ databases/sql-workbench/PLIST | 85 ++++++++++++++++++++++++++++++++++++++++ databases/sql-workbench/distinfo | 5 +++ 4 files changed, 171 insertions(+) create mode 100644 databases/sql-workbench/DESCR create mode 100644 databases/sql-workbench/Makefile create mode 100644 databases/sql-workbench/PLIST create mode 100644 databases/sql-workbench/distinfo (limited to 'databases/sql-workbench') diff --git a/databases/sql-workbench/DESCR b/databases/sql-workbench/DESCR new file mode 100644 index 00000000000..e94740b092a --- /dev/null +++ b/databases/sql-workbench/DESCR @@ -0,0 +1,50 @@ +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. + +Features: + + * Edit, insert and delete data directly in the query result. + * Powerful export command to write text files (aka "CSV"), + XML, HTML or SQL (including BLOB data). All user tables + can be exported into a directory with a single command. + Export files can be compressed "on-the-fly". + * Powerful text, XML and spreadsheet import. A set of files + (including compressed files) can be imported from a directory + with a single command. Foreign key constraints are detected + to insert the data in the correct order. + * Compare two database schemas for differences. The XML output + can be transformed into the approriate SQL ALTER statements + using XSLT. + * Compare the data of two database and generate the necessary + SQL statements to migrate one to the other. + * Supports running SQL scripts in batch mode. + * Supports running in console mode. + * Search text in procedure, view and other sources using a SQL + command or a GUI. + * Search for data across all columns in all tables using a SQL + command or a GUI. + * Reformatting (Pretty-Print) of SQL Statements. + * Select rows from related tables according to their foreign + key definitions. + * Tooltips for INSERT statements to show the corresponding + value or column. + * Copy data directly between to database servers using a SQL + command or a GUI. + * Macros (aka aliases) for frequently used SQL statements. + * Variable substitution in SQL statements including smart + prompting for values (can be combined with macros). + * Auto completion for tables and columns in SQL statements. + * Display database objects and their definitions. + * Display table source. + * Display view, procedure and trigger source code. + * Display foreign key constraints between tables. + * Full support for BLOB data in query results, SQL statements, + export and import. + * SQLWorkbench/J is free for almost everyone (published under + a modified the Apache 2.0 license). diff --git a/databases/sql-workbench/Makefile b/databases/sql-workbench/Makefile new file mode 100644 index 00000000000..1cacb15ade0 --- /dev/null +++ b/databases/sql-workbench/Makefile @@ -0,0 +1,31 @@ +# $NetBSD: Makefile,v 1.1.1.1 2015/07/20 20:19:16 asau Exp $ + +PKGNAME= sql-workbench-117 +DISTNAME= Workbench-Build117 +CATEGORIES= databases +MASTER_SITES= http://www.sql-workbench.net/ +EXTRACT_SUFX= .zip + +MAINTAINER= asau@inbox.ru +HOMEPAGE= http://www.sql-workbench.net/ +COMMENT= JDBC-based cross-platform SQL query tool. + +EXTRACT_DIR= $(WRKSRC) + +USE_JAVA= run +USE_JAVA2= 7 + +INSTALLATION_DIRS= bin share/$(PKGBASE) + +pre-extract: + mkdir -p $(WRKSRC) + +do-build: + printf "#!/bin/sh\n$(PKG_JAVA_HOME)/bin/java -Dvisualvm.display.name=SQLWorkbench -Xmx512m -jar $(PREFIX)/share/$(PKGBASE)/sqlworkbench.jar \$${1:+\"\$$@\"}\n" > $(WRKDIR)/sqlworkbench.sh + +do-install: + cd $(WRKSRC) && pax -rwpm . $(DESTDIR)$(PREFIX)/share/$(PKGBASE) + $(INSTALL_SCRIPT) $(WRKDIR)/sqlworkbench.sh $(DESTDIR)$(PREFIX)/bin/sqlworkbench + +.include "../../mk/java-vm.mk" +.include "../../mk/bsd.pkg.mk" diff --git a/databases/sql-workbench/PLIST b/databases/sql-workbench/PLIST new file mode 100644 index 00000000000..fc52aa779b9 --- /dev/null +++ b/databases/sql-workbench/PLIST @@ -0,0 +1,85 @@ +@comment $NetBSD: PLIST,v 1.1.1.1 2015/07/20 20:19:16 asau Exp $ +bin/sqlworkbench +share/sql-workbench/LICENSE +share/sql-workbench/SQLWorkbench-Manual.pdf +share/sql-workbench/SQLWorkbench.desktop +share/sql-workbench/SQLWorkbench.exe +share/sql-workbench/SQLWorkbench.vbs +share/sql-workbench/SQLWorkbench64.exe +share/sql-workbench/history.html +share/sql-workbench/log4j.xml +share/sql-workbench/manual/annotations.html +share/sql-workbench/manual/command-copy.html +share/sql-workbench/manual/command-export.html +share/sql-workbench/manual/command-import.html +share/sql-workbench/manual/compare-commands.html +share/sql-workbench/manual/console-mode.html +share/sql-workbench/manual/data-pumper.html +share/sql-workbench/manual/dbexplorer.html +share/sql-workbench/manual/dbms-specific.html +share/sql-workbench/manual/editor-bookmarks.html +share/sql-workbench/manual/editor.html +share/sql-workbench/manual/history.html +share/sql-workbench/manual/html-publish.css +share/sql-workbench/manual/images/CopyProfile16.gif +share/sql-workbench/manual/images/Delete16.gif +share/sql-workbench/manual/images/ExecuteSel16.gif +share/sql-workbench/manual/images/NewFolder16.gif +share/sql-workbench/manual/images/NewProfile16.gif +share/sql-workbench/manual/images/Open16.gif +share/sql-workbench/manual/images/Remove16.gif +share/sql-workbench/manual/images/caution.png +share/sql-workbench/manual/images/colfilter16.gif +share/sql-workbench/manual/images/filter16.gif +share/sql-workbench/manual/images/important.png +share/sql-workbench/manual/images/note.png +share/sql-workbench/manual/information.html +share/sql-workbench/manual/install.html +share/sql-workbench/manual/ix01.html +share/sql-workbench/manual/jdbc-setup.html +share/sql-workbench/manual/license.html +share/sql-workbench/manual/macros.html +share/sql-workbench/manual/options.html +share/sql-workbench/manual/profiles.html +share/sql-workbench/manual/settings.html +share/sql-workbench/manual/shortcuts.html +share/sql-workbench/manual/troubleshooting.html +share/sql-workbench/manual/understand-alternate-delim.html +share/sql-workbench/manual/using-fk.html +share/sql-workbench/manual/using-scripting.html +share/sql-workbench/manual/using-variables.html +share/sql-workbench/manual/using.html +share/sql-workbench/manual/wb-commands.html +share/sql-workbench/manual/workbench-manual-single.html +share/sql-workbench/manual/workbench-manual.html +share/sql-workbench/sqlwbconsole.cmd +share/sql-workbench/sqlwbconsole.exe +share/sql-workbench/sqlwbconsole.sh +share/sql-workbench/sqlwbconsole64.exe +share/sql-workbench/sqlworkbench.cmd +share/sql-workbench/sqlworkbench.jar +share/sql-workbench/sqlworkbench.sh +share/sql-workbench/workbench32.png +share/sql-workbench/xslt/jdbctypes2oracle.xslt +share/sql-workbench/xslt/liquibase_common.xslt +share/sql-workbench/xslt/wbdiff2derby.xslt +share/sql-workbench/xslt/wbdiff2html.xslt +share/sql-workbench/xslt/wbdiff2liquibase.xslt +share/sql-workbench/xslt/wbdiff2mssql.xslt +share/sql-workbench/xslt/wbdiff2oracle.xslt +share/sql-workbench/xslt/wbdiff2pg.xslt +share/sql-workbench/xslt/wbdiff2simple_html.xslt +share/sql-workbench/xslt/wbexport2dbunit.xslt +share/sql-workbench/xslt/wbexport2dbunitflat.xslt +share/sql-workbench/xslt/wbexport2insert.xslt +share/sql-workbench/xslt/wbexport2lbinsert.xslt +share/sql-workbench/xslt/wbexport2text.xslt +share/sql-workbench/xslt/wbreport2benerator.xslt +share/sql-workbench/xslt/wbreport2ctl.xslt +share/sql-workbench/xslt/wbreport2html.xslt +share/sql-workbench/xslt/wbreport2liquibase.xslt +share/sql-workbench/xslt/wbreport2liquibase_multi.xslt +share/sql-workbench/xslt/wbreport2oracle.xslt +share/sql-workbench/xslt/wbreport2pg.xslt +share/sql-workbench/xslt/wbreport2proc.xslt +share/sql-workbench/xslt/wbreport2wiki.xslt diff --git a/databases/sql-workbench/distinfo b/databases/sql-workbench/distinfo new file mode 100644 index 00000000000..8e2114079d5 --- /dev/null +++ b/databases/sql-workbench/distinfo @@ -0,0 +1,5 @@ +$NetBSD: distinfo,v 1.1.1.1 2015/07/20 20:19:16 asau Exp $ + +SHA1 (Workbench-Build117.zip) = c948a6ab4eb57637a05c28dd5228c5a939152261 +RMD160 (Workbench-Build117.zip) = 42cd165d00f99d931e38fb40f60c365ba73f83fc +Size (Workbench-Build117.zip) = 5483109 bytes -- cgit v1.2.3