aboutsummaryrefslogtreecommitdiffstats
path: root/SharedSupport/Default Bundles/Format SQL.spBundle
diff options
context:
space:
mode:
authorBibiko <bibiko@eva.mpg.de>2011-01-14 14:27:03 +0000
committerBibiko <bibiko@eva.mpg.de>2011-01-14 14:27:03 +0000
commit1a824b893dbc02ad5ce962d4ec33aeff765bdb5f (patch)
tree729ca732e703af9b936b35d425c1319a985a9010 /SharedSupport/Default Bundles/Format SQL.spBundle
parentf47f65ca4590c24b2e16ceb8147f8ba5b7d7186c (diff)
downloadsequelpro-1a824b893dbc02ad5ce962d4ec33aeff765bdb5f.tar.gz
sequelpro-1a824b893dbc02ad5ce962d4ec33aeff765bdb5f.tar.bz2
sequelpro-1a824b893dbc02ad5ce962d4ec33aeff765bdb5f.zip
• added "Format SQL" as default Bundle to scope Input Field/Query Editor which make usage of an online service to validate and format the current query or selection
Diffstat (limited to 'SharedSupport/Default Bundles/Format SQL.spBundle')
-rw-r--r--SharedSupport/Default Bundles/Format SQL.spBundle/command.plist184
1 files changed, 184 insertions, 0 deletions
diff --git a/SharedSupport/Default Bundles/Format SQL.spBundle/command.plist b/SharedSupport/Default Bundles/Format SQL.spBundle/command.plist
new file mode 100644
index 00000000..219cc2c7
--- /dev/null
+++ b/SharedSupport/Default Bundles/Format SQL.spBundle/command.plist
@@ -0,0 +1,184 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
+<plist version="1.0">
+<dict>
+ <key>author</key>
+ <string>Hans-Jörg Bibiko</string>
+ <key>category</key>
+ <string>Query Editor</string>
+ <key>command</key>
+ <string>
+# 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)
+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
+fi
+
+# send SQL to www.dpriver.com and replace the formatted SQL string in first responder; if a parser error occurred
+# show error message and try to jump to the error
+cat &lt;&lt;HTML
+&lt;!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"&gt;
+&lt;html&gt;
+&lt;head&gt;
+ &lt;base href="http://www.dpriver.com/pp/"&gt;
+ &lt;title&gt;Connecting www.dpriver.com&lt;/title&gt;
+ &lt;script&gt;
+ function lookForResult() {
+ if(document.all.outputsql.value.length &gt; 8) {
+ if(document.all.errorhint.style.display == "inline") {
+ var errormes = document.all.outputsql.value;
+ var re = /.*?\(\d+\s*,\s*(\d+)\).*/;
+ re.exec(errormes);
+ var pos = parseInt(RegExp.\$1) - 1;
+ re = /.*?(\d+).*/;
+ re.exec('$SP_SELECTED_TEXT_RANGE');
+ var offset = parseInt(RegExp.\$1);
+ pos = pos + offset;
+ alert(document.all.outputsql.value);
+ window.system.setSelectedTextRange(pos+'');
+ } else {
+ var txt = document.all.outputsql.value;
+ var len = txt.length;
+ window.system.setSelectedTextRange('$SP_SELECTED_TEXT_RANGE');
+ window.system.insertText(txt.slice(0,len-2));
+ }
+ window.system.closeHTMLOutputWindow();
+ } else {
+ setTimeout("lookForResult()",50);
+ }
+ }
+
+ function waitForResult() {
+ window.system.suppressExceptionAlert();
+ setTimeout("lookForResult()",50);
+ }
+ &lt;/script&gt;
+ &lt;script language="JavaScript" type="text/javascript" src="pp.js"&gt;&lt;/script&gt;
+&lt;/head&gt;
+&lt;body onload='window.resizeTo(300,200);SQLFMT.format(document.all.sp_submit);waitForResult()'&gt;
+&lt;div id="retvalues"&gt;&lt;/div&gt;
+&lt;p&gt;&lt;b&gt;Copyright &amp;copy; 2001-2010 Gudu Software&lt;br&gt;All Rights Reserved&lt;br&gt;&lt;a href="mailto:support@dpriver.com"&gt;Contact US&lt;/a&gt;&lt;/b&gt;&lt;/p&gt;
+&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;
+&lt;p align=right&gt;Please wait…&lt;/p&gt;
+&lt;div class="page-container-1" style="display:none;"&gt;
+ &lt;div id="container"&gt;
+ &lt;div id="wrapper"&gt;
+ &lt;div id="content"&gt;
+ &lt;form id="SqlFmtForm" name="frm_sqlformat" method="post" action="/cgi-bin/ppserver" onsubmit="return false;"&gt;
+ &lt;div id="secondpanel"&gt;
+ &lt;div id="sp_database"&gt;
+ &lt;label class="desc" style="display:inline;"&gt;Database&lt;/label&gt;
+ &lt;select name="dbvendor"&gt;
+ &lt;option value="mysql" selected&gt;MySQL&lt;/option&gt;
+ &lt;/select&gt;
+ &lt;label class="desc" style="display:inline;padding:0 0 0px 40px; border:0px solid;"&gt;Output:&lt;/label&gt;
+ &lt;select name="outputfmt"&gt;
+ &lt;option value="SQL" selected&gt;SQL(Text)&lt;/option&gt;
+ &lt;/select&gt;
+ &lt;/div&gt;
+ &lt;/div&gt;
+ &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`
+ &lt;/textarea&gt;
+ &lt;/div&gt;
+ &lt;div id="sp_submit"&gt;
+ &lt;input type="button" id="btnformat" name="print" value="Format SQL" onclick="SQLFMT.format(this)" value="Format SQL"&gt;
+ &lt;label style="display:none;"&gt;(Time used: &lt;span id="timestamp"&gt;0&lt;/span&gt; seconds)&lt;/label&gt;
+ &lt;/div&gt;
+ &lt;div id="sp_submit" style="text-align:left;"&gt;
+ &lt;/div&gt;
+ &lt;label id="errorhint" class="desc" style="color:#DF0000 !important;display:none;"&gt;
+ Can't format input sql, make sure there is no syntax error and select correct database.
+ &lt;a href="" style="display:none;"&gt;OR Report a bug of this sql beautifier&lt;/a&gt;
+ &lt;/label&gt;
+ &lt;iframe id="ioutputsql" &gt;&lt;/iframe&gt;
+ &lt;div id="sp_outputsql" style="display:none;"&gt;
+ &lt;textarea id = "outputsql" name="outputsql" cols="80" rows="15" wrap="off" &gt;
+ &lt;/textarea&gt;
+ &lt;/div&gt;
+ &lt;div id="sp_errormsg" style="display:none;"&gt;
+ Error message goes to here!
+ &lt;/div&gt;
+ &lt;/div&gt;
+ &lt;div id="formatoptions"&gt;
+ &lt;select name="keywordcs"&gt;
+ &lt;option value="Uppercase" selected &gt;Uppercase&lt;/option&gt;
+ &lt;option value="Lowercase" &gt;Lowercase&lt;/option&gt;
+ &lt;option value="InitCap" &gt;InitCap&lt;/option&gt;
+ &lt;option value="Unchanged" &gt;Unchanged&lt;/option&gt;
+ &lt;/select&gt;
+ &lt;select name="identifiercs"&gt;
+ &lt;option value="Uppercase" &gt;Uppercase&lt;/option&gt;
+ &lt;option value="Lowercase" selected &gt;Lowercase&lt;/option&gt;
+ &lt;option value="InitCap" &gt;InitCap&lt;/option&gt;
+ &lt;option value="Unchanged" &gt;Unchanged&lt;/option&gt;
+ &lt;option value="initcapeachword" &gt;Init cap each word&lt;/option&gt;
+ &lt;/select&gt;
+ &lt;select name="functioncs"&gt;
+ &lt;option value="Uppercase" &gt;Uppercase&lt;/option&gt;
+ &lt;option value="Lowercase" &gt;Lowercase&lt;/option&gt;
+ &lt;option value="InitCap" selected &gt;InitCap&lt;/option&gt;
+ &lt;option value="Unchanged" &gt;Unchanged&lt;/option&gt;
+ &lt;/select&gt;
+ &lt;input type="radio" name="lnbrwithcomma" value="after" checked &gt; After
+ &lt;input type="radio" name="lnbrwithcomma" value="before" &gt; Before
+ &lt;input type="radio" name="lnbrwithcomma" value= "beforewithspace" &gt; Before with space
+ &lt;input type="radio" name="liststyle" value="stack" checked&gt;Stacked
+ &lt;input type="radio" name="liststyle" value="nostack"&gt;Not Stacked
+ &lt;input type="radio" name="salign" value="sleft" checked&gt; Align left
+ &lt;input type="radio" name="salign" value="sright" &gt; Align right
+ &lt;input type="checkbox" name="andorunderwhere" value="yes" checked&gt; And/Or under Where
+ &lt;input type="checkbox" name="removelnbr" value="yes" checked&gt; Remove Linebreak before beautify
+ &lt;input type="checkbox" name="trimquotechar" value="yes"&gt; Trim Quoted Char of Each Line quoted char of eachline: &lt;input type="text" name="quotechar" value= "&amp;#34" size = 5 &gt;
+ &lt;input type="checkbox" name="compactmode" value="yes"&gt; Compact the output of sql output
+ &lt;input type="text" name="maxlenincm" value= "80" size = 5 &gt;
+ &lt;/div&gt;
+ &lt;input type="hidden" name="clientid" value="4149-9094-8133-2031" /&gt;
+ &lt;/form&gt;
+ &lt;/div&gt;
+ &lt;/div&gt;
+ &lt;/div&gt;
+&lt;/div&gt;
+
+&lt;/body&gt;
+&lt;/html&gt;
+HTML
+</string>
+ <key>contact</key>
+ <string>znvy@ovovxb.qr</string>
+ <key>description</key>
+ <string>Send the current query or selection to www.dpriver.com and replace the current query or selection of the first responder by the server's formatted output. If a parser error occurred alert that error and tries to jump to the error location.
+
+Version 1.0</string>
+ <key>input</key>
+ <string>selectedtext</string>
+ <key>input_fallback</key>
+ <string>currentquery</string>
+ <key>internalKeyEquivalent</key>
+ <dict>
+ <key>characters</key>
+ <string>T</string>
+ <key>keyCode</key>
+ <integer>17</integer>
+ <key>modifierFlags</key>
+ <integer>1835008</integer>
+ </dict>
+ <key>keyEquivalent</key>
+ <string>^~@t</string>
+ <key>name</key>
+ <string>Format SQL</string>
+ <key>output</key>
+ <string>showashtml</string>
+ <key>scope</key>
+ <string>inputfield</string>
+ <key>tooltip</key>
+ <string>Send query or selection to www.dpriver.com to insert the SQL statement formatted</string>
+ <key>uuid</key>
+ <string>36E1F94D-D6C4-460A-A663-C694AF85E099</string>
+ <key>isDefaultBundle</key>
+ <true/>
+</dict>
+</plist>