diff options
Diffstat (limited to 'SharedSupport')
| -rw-r--r-- | SharedSupport/Default Bundles/Format SQL.spBundle/command.plist | 14 |
1 files changed, 11 insertions, 3 deletions
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 @@ <key>author</key> <string>Hans-Jörg Bibiko</string> <key>category</key> - <string>Query Editor</string> + <string>Format</string> <key>command</key> <string> + +# 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"> |