aboutsummaryrefslogtreecommitdiffstats
path: root/SharedSupport/Default Bundles
diff options
context:
space:
mode:
Diffstat (limited to 'SharedSupport/Default Bundles')
-rw-r--r--SharedSupport/Default Bundles/Format SQL.spBundle/command.plist14
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&gt; /dev/null | grep 'icmp' | wc -l)
+connected=$(/sbin/ping -t 5 -c 1 -on www.dpriver.com 2&gt; /dev/null | grep 'icmp' | wc -l)
if [ $connected -eq "0" ]; then
echo "&lt;font color=red&gt;You are probably not connected to the internet or http://www.dpriver.com/ server is down.&lt;/font&gt;"
exit $SP_BUNDLE_EXIT_SHOW_AS_HTML_TOOLTIP
@@ -81,7 +89,7 @@ cat &lt;&lt;HTML
&lt;div id="sqlpanel"&gt;
&lt;div id="sp_inputsql"&gt;
&lt;textarea id ="inputsql" name="inputsql" cols="1" rows="1" wrap="off"&gt;
- `cat`
+ $SQL
&lt;/textarea&gt;
&lt;/div&gt;
&lt;div id="sp_submit"&gt;