ports/106230: [NEW PORT] databases/squirrel-sql A universal SQL Client

Roy Boerner roy.boerner at bsd-crew.de
Sat Dec 2 19:20:22 UTC 2006 

>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 at 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 at 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 at dirrm share/java/squirrel-sql/plugins/syntax/lib
X at dirrm share/java/squirrel-sql/plugins/syntax
X at dirrm share/java/squirrel-sql/plugins/sqlscript
X at dirrm share/java/squirrel-sql/plugins/sqlbookmark
X at dirrm share/java/squirrel-sql/plugins/laf/skinlf-theme-packs
X at dirrm share/java/squirrel-sql/plugins/laf/oyoaha-theme-packs
X at dirrm share/java/squirrel-sql/plugins/laf/lafs
X at dirrm share/java/squirrel-sql/plugins/laf
X at dirrm share/java/squirrel-sql/plugins/graph
X at dirrm share/java/squirrel-sql/plugins/editextras
X at dirrm share/java/squirrel-sql/plugins/codecompletion
X at dirrm share/java/squirrel-sql/plugins
X at dirrm share/java/squirrel-sql/lib
X at dirrm share/java/squirrel-sql/icons
X at dirrm share/java/squirrel-sql/doc/licences
X at dirrm share/java/squirrel-sql/doc/images
X at dirrm share/java/squirrel-sql/doc
X at 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:

More information about the freebsd-ports-bugs mailing list