Date: Sat, 2 Dec 2006 19:16:38 GMT From: Roy Boerner<roy.boerner@bsd-crew.de> To: freebsd-gnats-submit@FreeBSD.org Subject: ports/106230: [NEW PORT] databases/squirrel-sql A universal SQL Client Message-ID: <200612021916.kB2JGcoF013312@www.freebsd.org> Resent-Message-ID: <200612021920.kB2JKEXs065126@freefall.freebsd.org>
next in thread | raw e-mail | index | archive | help
>Number: 106230 >Category: ports >Synopsis: [NEW PORT] databases/squirrel-sql A universal SQL Client >Confidential: no >Severity: non-critical >Priority: medium >Responsible: freebsd-ports-bugs >State: open >Quarter: >Keywords: >Date-Required: >Class: change-request >Submitter-Id: current-users >Arrival-Date: Sat Dec 02 19:20:14 GMT 2006 >Closed-Date: >Last-Modified: >Originator: Roy Boerner >Release: FreeBSD 6.1-RELEASE-p10 amd64 >Organization: >Environment: FreeBSD robowork.internal 6.1-RELEASE-p10 FreeBSD 6.1-RELEASE-p10 #3: Sun Oct 15 19:43:51 CEST 2006 robo@robowork.internal:/usr/obj/usr/src/sys/ROBOWORK amd64 >Description: SQuirreL SQL Client is a graphical Java program that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc. WWW: http://www.squirrelsql.org/index.php?page=screenshots >How-To-Repeat: >Fix: Patch attached with submission follows: # This is a shell archive. Save it in a file, remove anything before # this line, and then unpack it by entering "sh file". Note, it may # create directories; files and directories will be owned by you and # have default permissions. # # This archive contains: # # squirrel-sql # squirrel-sql/distinfo # squirrel-sql/Makefile # squirrel-sql/pkg-descr # squirrel-sql/pkg-plist # squirrel-sql/files # squirrel-sql/files/squirrel-sql.sh # squirrel-sql/files/squirrel-sql.in # squirrel-sql/files/squirrel-sql.in~ # echo c - squirrel-sql mkdir -p squirrel-sql > /dev/null 2>&1 echo x - squirrel-sql/distinfo sed 's/^X//' >squirrel-sql/distinfo << 'END-of-squirrel-sql/distinfo' XMD5 (squirrel-sql-2.3.1-standard.tar.gz) = 5a164fcfdae270365fbe1b34e7b215a6 XSHA256 (squirrel-sql-2.3.1-standard.tar.gz) = d3b8bcaee4b72d0108e692f7e6d6fb08544ab303f7738e02b05e43e51a0bb1f9 XSIZE (squirrel-sql-2.3.1-standard.tar.gz) = 7404592 END-of-squirrel-sql/distinfo echo x - squirrel-sql/Makefile sed 's/^X//' >squirrel-sql/Makefile << 'END-of-squirrel-sql/Makefile' X# New ports collection makefile for: squirrel-sql X# Date created: 2006/11/06 X# Whom: Roy Boerner X# X# $FreeBSD$ X# X XPORTNAME=squirrel-sql XPORTVERSION=2.3.1 XCATEGORIES=java databases XMASTER_SITES=${MASTER_SITE_SOURCEFORGE_EXTENDED} XMASTER_SITE_SUBDIR=${PORTNAME} XDISTNAME=squirrel-sql-2.3.1-standard X XMAINTAINER=roy.boerner@bsd-crew.de XCOMMENT=A universal SQL Client X XNO_BUILD=yes XUSE_JAVA=yes XJAVA_VERSION=1.4+ XWRKSRC=${WRKDIR}/SQuirreL SQL Client XDSTDIR=${JAVASHAREDIR}/${PORTNAME} X XSUB_FILES=squirrel-sql X XDESKTOP_ENTRIES="Squirrel-SQL" \ X "${COMMENT}" \ X "${DSTDIR}/icons/acorn.png" \ X "squirrel-sql" \ X "Application;" \ X false X Xpost-extract: X ${RM} -rf "${WRKSRC}"/Uninstaller X ${RM} -rf "${WRKSRC}"/*.bat X ${RM} -rf "${WRKSRC}"/*.sh X Xdo-install: X cd "${WRKSRC}" && ${FIND} . -type d -exec ${MKDIR} ${DSTDIR}/{} \; X cd "${WRKSRC}" && ${FIND} . -type f -not -path "\./bin/" -exec ${INSTALL_DATA} {} ${DSTDIR}/{} \; X ${INSTALL_SCRIPT} ${WRKDIR}/squirrel-sql ${PREFIX}/bin X X.include <bsd.port.mk> END-of-squirrel-sql/Makefile echo x - squirrel-sql/pkg-descr sed 's/^X//' >squirrel-sql/pkg-descr << 'END-of-squirrel-sql/pkg-descr' XSQuirreL SQL Client is a graphical Java program that will allow you to view the Xstructure of a JDBC compliant database, browse the data in tables, issue SQL Xcommands etc. X XWWW: http://www.squirrelsql.org/index.php?page=screenshots END-of-squirrel-sql/pkg-descr echo x - squirrel-sql/pkg-plist sed 's/^X//' >squirrel-sql/pkg-plist << 'END-of-squirrel-sql/pkg-plist' Xbin/squirrel-sql Xshare/java/squirrel-sql/doc/changes.txt Xshare/java/squirrel-sql/doc/faq.html Xshare/java/squirrel-sql/doc/images/add_alias_1.png Xshare/java/squirrel-sql/doc/images/aliases_tool_window_1.png Xshare/java/squirrel-sql/doc/images/chg_driver_1.png Xshare/java/squirrel-sql/doc/images/chg_driver_2.png Xshare/java/squirrel-sql/doc/images/connect_window.png Xshare/java/squirrel-sql/doc/images/createresultwindow.gif Xshare/java/squirrel-sql/doc/images/drivers_tool_window_1.png Xshare/java/squirrel-sql/doc/images/error_st_obj.gif Xshare/java/squirrel-sql/doc/images/global_data_types_1.png Xshare/java/squirrel-sql/doc/images/global_data_types_2.png Xshare/java/squirrel-sql/doc/images/global_general.png Xshare/java/squirrel-sql/doc/images/global_proxy.png Xshare/java/squirrel-sql/doc/images/global_sql.png Xshare/java/squirrel-sql/doc/images/logo.jpg Xshare/java/squirrel-sql/doc/images/logo_1.jpg Xshare/java/squirrel-sql/doc/images/ok_st_obj.gif Xshare/java/squirrel-sql/doc/images/plugins_1.png Xshare/java/squirrel-sql/doc/images/session_1.png Xshare/java/squirrel-sql/doc/images/session_2.png Xshare/java/squirrel-sql/doc/images/session_props_general.png Xshare/java/squirrel-sql/doc/images/session_props_object.png Xshare/java/squirrel-sql/doc/images/session_props_sql.png Xshare/java/squirrel-sql/doc/images/sql_1.png Xshare/java/squirrel-sql/doc/images/sql_2.png Xshare/java/squirrel-sql/doc/images/toolspopup.jpg Xshare/java/squirrel-sql/doc/licences/dean_jones_icons_licence.txt Xshare/java/squirrel-sql/doc/licences/eclipse-icons-licence.html Xshare/java/squirrel-sql/doc/licences/eclipse-icons-licence.txt Xshare/java/squirrel-sql/doc/licences/log4j-licence.txt Xshare/java/squirrel-sql/doc/licences/nano_xml_licence.txt Xshare/java/squirrel-sql/doc/licences/squirrel_licence.txt Xshare/java/squirrel-sql/doc/licences/sun_icons_licence.txt Xshare/java/squirrel-sql/doc/news.txt Xshare/java/squirrel-sql/doc/plugins.html Xshare/java/squirrel-sql/doc/quick_start.html Xshare/java/squirrel-sql/doc/readme.html Xshare/java/squirrel-sql/doc/readme.txt Xshare/java/squirrel-sql/doc/style.css Xshare/java/squirrel-sql/doc/welcome.html Xshare/java/squirrel-sql/icons/acorn.ico Xshare/java/squirrel-sql/icons/acorn.png Xshare/java/squirrel-sql/icons/acorn.xpm Xshare/java/squirrel-sql/lib/commons-cli.jar Xshare/java/squirrel-sql/lib/forms.jar Xshare/java/squirrel-sql/lib/fw.jar Xshare/java/squirrel-sql/lib/log4j.jar Xshare/java/squirrel-sql/lib/nanoxml-2.1.jar Xshare/java/squirrel-sql/log4j.properties Xshare/java/squirrel-sql/plugins/codecompletion.jar Xshare/java/squirrel-sql/plugins/codecompletion/changes.txt Xshare/java/squirrel-sql/plugins/codecompletion/completionpopup.jpg Xshare/java/squirrel-sql/plugins/codecompletion/graph.jpg Xshare/java/squirrel-sql/plugins/codecompletion/licence.txt Xshare/java/squirrel-sql/plugins/codecompletion/readme.html Xshare/java/squirrel-sql/plugins/codecompletion/readme.txt Xshare/java/squirrel-sql/plugins/codecompletion/src.jar Xshare/java/squirrel-sql/plugins/editextras.jar Xshare/java/squirrel-sql/plugins/editextras/changes.txt Xshare/java/squirrel-sql/plugins/editextras/licence.txt Xshare/java/squirrel-sql/plugins/editextras/readme.html Xshare/java/squirrel-sql/plugins/editextras/readme.txt Xshare/java/squirrel-sql/plugins/editextras/src.jar Xshare/java/squirrel-sql/plugins/editextras/toolspopup.jpg Xshare/java/squirrel-sql/plugins/graph.jar Xshare/java/squirrel-sql/plugins/graph/changes.txt Xshare/java/squirrel-sql/plugins/graph/graph.jpg Xshare/java/squirrel-sql/plugins/graph/licence.txt Xshare/java/squirrel-sql/plugins/graph/readme.html Xshare/java/squirrel-sql/plugins/graph/readme.txt Xshare/java/squirrel-sql/plugins/graph/src.jar Xshare/java/squirrel-sql/plugins/graph/zoomprint.jpg Xshare/java/squirrel-sql/plugins/laf.jar Xshare/java/squirrel-sql/plugins/laf/OYOAHA-licence.html Xshare/java/squirrel-sql/plugins/laf/changes.txt Xshare/java/squirrel-sql/plugins/laf/jgoodies-looks-licence.txt Xshare/java/squirrel-sql/plugins/laf/kunststoff_Licence.txt Xshare/java/squirrel-sql/plugins/laf/laf-plugin-licence.txt Xshare/java/squirrel-sql/plugins/laf/lafs/kunststoff.jar Xshare/java/squirrel-sql/plugins/laf/lafs/looks-1.3.1.jar Xshare/java/squirrel-sql/plugins/laf/lafs/metouia.jar Xshare/java/squirrel-sql/plugins/laf/lafs/oalnf.jar Xshare/java/squirrel-sql/plugins/laf/lafs/readme.txt Xshare/java/squirrel-sql/plugins/laf/lafs/skinlf.jar Xshare/java/squirrel-sql/plugins/laf/lafs/swingsetthemes.jar Xshare/java/squirrel-sql/plugins/laf/licences.html Xshare/java/squirrel-sql/plugins/laf/metouia-licence.txt Xshare/java/squirrel-sql/plugins/laf/oyoaha-theme-packs/gradient.otm Xshare/java/squirrel-sql/plugins/laf/oyoaha-theme-packs/readme.txt Xshare/java/squirrel-sql/plugins/laf/readme.html Xshare/java/squirrel-sql/plugins/laf/readme.txt Xshare/java/squirrel-sql/plugins/laf/skin_look_and_feel_licence.txt Xshare/java/squirrel-sql/plugins/laf/skinlf-theme-packs/readme.txt Xshare/java/squirrel-sql/plugins/laf/skinlf-theme-packs/whistlerthemepack.zip Xshare/java/squirrel-sql/plugins/laf/src.jar Xshare/java/squirrel-sql/plugins/readme.txt Xshare/java/squirrel-sql/plugins/sqlbookmark.jar Xshare/java/squirrel-sql/plugins/sqlbookmark/bookmarkspopup.jpg Xshare/java/squirrel-sql/plugins/sqlbookmark/changes.txt Xshare/java/squirrel-sql/plugins/sqlbookmark/licence.txt Xshare/java/squirrel-sql/plugins/sqlbookmark/prefs.jpg Xshare/java/squirrel-sql/plugins/sqlbookmark/readme.html Xshare/java/squirrel-sql/plugins/sqlbookmark/src.jar Xshare/java/squirrel-sql/plugins/sqlbookmark/toolspopup.jpg Xshare/java/squirrel-sql/plugins/sqlscript.jar Xshare/java/squirrel-sql/plugins/sqlscript/changes.txt Xshare/java/squirrel-sql/plugins/sqlscript/creattable.jpg Xshare/java/squirrel-sql/plugins/sqlscript/licence.txt Xshare/java/squirrel-sql/plugins/sqlscript/readme.html Xshare/java/squirrel-sql/plugins/sqlscript/readme.txt Xshare/java/squirrel-sql/plugins/sqlscript/src.jar Xshare/java/squirrel-sql/plugins/sqlscript/toolspopup.jpg Xshare/java/squirrel-sql/plugins/syntax.jar Xshare/java/squirrel-sql/plugins/syntax/changes.txt Xshare/java/squirrel-sql/plugins/syntax/configdlg.jpg Xshare/java/squirrel-sql/plugins/syntax/corrabrev.jpg Xshare/java/squirrel-sql/plugins/syntax/lib/openide-loaders.jar Xshare/java/squirrel-sql/plugins/syntax/lib/openide.jar Xshare/java/squirrel-sql/plugins/syntax/lib/org-netbeans-modules-editor-fold.jar Xshare/java/squirrel-sql/plugins/syntax/lib/org-netbeans-modules-editor-lib.jar Xshare/java/squirrel-sql/plugins/syntax/lib/org-netbeans-modules-editor-util.jar Xshare/java/squirrel-sql/plugins/syntax/lib/org-netbeans-modules-editor.jar Xshare/java/squirrel-sql/plugins/syntax/lib/syntax.jar Xshare/java/squirrel-sql/plugins/syntax/licence.txt Xshare/java/squirrel-sql/plugins/syntax/readme.html Xshare/java/squirrel-sql/plugins/syntax/src.jar Xshare/java/squirrel-sql/plugins/syntax/standard-nbm-license.txt Xshare/java/squirrel-sql/plugins/syntax/toolspopup.jpg Xshare/java/squirrel-sql/squirrel-sql.jar X@dirrm share/java/squirrel-sql/plugins/syntax/lib X@dirrm share/java/squirrel-sql/plugins/syntax X@dirrm share/java/squirrel-sql/plugins/sqlscript X@dirrm share/java/squirrel-sql/plugins/sqlbookmark X@dirrm share/java/squirrel-sql/plugins/laf/skinlf-theme-packs X@dirrm share/java/squirrel-sql/plugins/laf/oyoaha-theme-packs X@dirrm share/java/squirrel-sql/plugins/laf/lafs X@dirrm share/java/squirrel-sql/plugins/laf X@dirrm share/java/squirrel-sql/plugins/graph X@dirrm share/java/squirrel-sql/plugins/editextras X@dirrm share/java/squirrel-sql/plugins/codecompletion X@dirrm share/java/squirrel-sql/plugins X@dirrm share/java/squirrel-sql/lib X@dirrm share/java/squirrel-sql/icons X@dirrm share/java/squirrel-sql/doc/licences X@dirrm share/java/squirrel-sql/doc/images X@dirrm share/java/squirrel-sql/doc X@dirrm share/java/squirrel-sql END-of-squirrel-sql/pkg-plist echo c - squirrel-sql/files mkdir -p squirrel-sql/files > /dev/null 2>&1 echo x - squirrel-sql/files/squirrel-sql.sh sed 's/^X//' >squirrel-sql/files/squirrel-sql.sh << 'END-of-squirrel-sql/files/squirrel-sql.sh' X#! /bin/sh X[ ${JAVA_HOME} ] && JAVA=${JAVA_HOME}/bin/java || JAVA=java X X# Are we running within Cygwin on some version of Windows? Xcygwin=false; Xcase "`uname -s`" in X CYGWIN*) cygwin=true ;; Xesac X X# Squirrel home. XSQUIRREL_SQL_HOME=`dirname "$0"` X X# SQuirreL home in Unix format. Xif $cygwin ; then X UNIX_STYLE_HOME=`cygpath "$SQUIRREL_SQL_HOME"` Xelse X UNIX_STYLE_HOME=$SQUIRREL_SQL_HOME Xfi X X# First entry in classpath is the Squirrel application. XTMP_CP=$UNIX_STYLE_HOME/squirrel-sql.jar X X# Then add all library jars to the classpath. XIFS="" Xfor a in $UNIX_STYLE_HOME/lib/*; do X TMP_CP="$TMP_CP":"$a"; Xdone X X# Now add the system classpath to the classpath. If running X# Cygwin we also need to change the classpath to Windows format. Xif $cygwin ; then X TMP_CP=`cygpath -w -p $TMP_CP` X TMP_CP=$TMP_CP';'$CLASSPATH Xelse X TMP_CP=$TMP_CP:$CLASSPATH Xfi X X#To add translation working directories to your classpath edit and uncomment this line: X#$JAVA -Xmx256m -cp $TMP_CP:<your working dir here> net.sourceforge.squirrel_sql.client.Main --log-config-file $SQUIRREL_SQL_HOME/log4j.properties --squirrel-home $SQUIRREL_SQL_HOME $1 $2 $3 $4 $5 $6 $7 $8 $9 X X#To change the language edit and uncomment this line: X#$JAVA -Xmx256m -cp $TMP_CP:<your working dir here> -Duser.language=<your language here> net.sourceforge.squirrel_sql.client.Main --log-config-file $SQUIRREL_SQL_HOME/log4j.properties --squirrel-home $SQUIRREL_SQL_HOME $1 $2 $3 $4 $5 $6 $7 $8 $9 X X X$JAVA -Xmx256m -cp $TMP_CP net.sourceforge.squirrel_sql.client.Main --log-config-file $SQUIRREL_SQL_HOME/log4j.properties --squirrel-home $SQUIRREL_SQL_HOME $1 $2 $3 $4 $5 $6 $7 $8 $9 X END-of-squirrel-sql/files/squirrel-sql.sh echo x - squirrel-sql/files/squirrel-sql.in sed 's/^X//' >squirrel-sql/files/squirrel-sql.in << 'END-of-squirrel-sql/files/squirrel-sql.in' X#! /bin/sh X X# Squirrel home. XSQUIRREL_SQL_HOME=%%JAVASHAREDIR%%/squirrel-sql X X# First entry in classpath is the Squirrel application. XTMP_CP=$SQUIRREL_SQL_HOME/squirrel-sql.jar X X# Then add all library jars to the classpath. Xfor a in $SQUIRREL_SQL_HOME/lib/*; do X TMP_CP="$TMP_CP":"$a"; Xdone X X# Now add the system classpath to the classpath. XTMP_CP=$TMP_CP:$CLASSPATH X Xjava -cp $TMP_CP net.sourceforge.squirrel_sql.client.Main --log-config-file $SQUIRREL_SQL_HOME/log4j.properties --squirrel-home $SQUIRREL_SQL_HOME $1 $2 $3 $4 $5 $6 $7 $8 $9 END-of-squirrel-sql/files/squirrel-sql.in echo x - squirrel-sql/files/squirrel-sql.in~ sed 's/^X//' >squirrel-sql/files/squirrel-sql.in~ << 'END-of-squirrel-sql/files/squirrel-sql.in~' X#! /bin/sh X X# Squirrel home. XSQUIRREL_SQL_HOME=%%JAVASHAREDIR%%/squirrel-sql X X# First entry in classpath is the Squirrel application. XTMP_CP=$SQUIRREL_SQL_HOME/squirrel-sql.jar X X# Then add all library jars to the classpath. Xfor a in $SQUIRREL_SQL_HOME/lib/*; do X TMP_CP="$TMP_CP":"$a"; Xdone X X# Now add the system classpath to the classpath. XTMP_CP=$TMP_CP:$CLASSPATH X Xjava -cp $TMP_CP net.sourceforge.squirrel_sql.client.Main --log-config-file $SQUIRREL_SQL_HOME/log4j.properties --squirrel-home $SQUIRREL_SQL_HOME $1 $2 $3 $4 $5 $6 $7 $8 $9 END-of-squirrel-sql/files/squirrel-sql.in~ exit >Release-Note: >Audit-Trail: >Unformatted:
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200612021916.kB2JGcoF013312>