From c352ef02ae0e81496c9db2b8973a8cdd43669366 Mon Sep 17 00:00:00 2001 From: Bibiko Date: Fri, 14 Jan 2011 16:25:50 +0000 Subject: =?UTF-8?q?=E2=80=A2=20fixed=20issue=20for=20default=20Bundles=20i?= =?UTF-8?q?f=20category=20or=20key=20equivalent=20was=20changed=20by=20the?= =?UTF-8?q?=20user=20=E2=80=A2=20improved=20Format=20SQL=20Bundle=20-=20ad?= =?UTF-8?q?ded=20checking=20for=20empty=20passed=20SQL=20string=20-=20chan?= =?UTF-8?q?ged=20category=20to=20Format?= MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- .../Default Bundles/Format SQL.spBundle/command.plist | 14 +++++++++++--- 1 file changed, 11 insertions(+), 3 deletions(-) (limited to 'SharedSupport/Default Bundles/Format SQL.spBundle') diff --git a/SharedSupport/Default Bundles/Format SQL.spBundle/command.plist b/SharedSupport/Default Bundles/Format SQL.spBundle/command.plist index 219cc2c7..f6472de5 100644 --- a/SharedSupport/Default Bundles/Format SQL.spBundle/command.plist +++ b/SharedSupport/Default Bundles/Format SQL.spBundle/command.plist @@ -5,11 +5,19 @@ author Hans-Jörg Bibiko category - Query Editor + Format command + +# check for empty STDIN +SQL=$(cat) +if [ -z "$SQL" ]; then + echo "No SQL statements passed." + exit $SP_BUNDLE_EXIT_SHOW_AS_TEXT_TOOLTIP +fi + # check if connected to the internet and if server is up -connected=$(/sbin/ping -t 3 -c 1 -on www.dpriver.com 2> /dev/null | grep 'icmp' | wc -l) +connected=$(/sbin/ping -t 5 -c 1 -on www.dpriver.com 2> /dev/null | grep 'icmp' | wc -l) if [ $connected -eq "0" ]; then echo "<font color=red>You are probably not connected to the internet or http://www.dpriver.com/ server is down.</font>" exit $SP_BUNDLE_EXIT_SHOW_AS_HTML_TOOLTIP @@ -81,7 +89,7 @@ cat <<HTML <div id="sqlpanel"> <div id="sp_inputsql"> <textarea id ="inputsql" name="inputsql" cols="1" rows="1" wrap="off"> - `cat` + $SQL </textarea> </div> <div id="sp_submit"> -- cgit v1.2.3