diff options
| -rw-r--r-- | SharedSupport/Default Bundles/Format SQL.spBundle/command.plist | 184 |
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> /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 +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 <<HTML +<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"> +<html> +<head> + <base href="http://www.dpriver.com/pp/"> + <title>Connecting www.dpriver.com</title> + <script> + function lookForResult() { + if(document.all.outputsql.value.length > 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); + } + </script> + <script language="JavaScript" type="text/javascript" src="pp.js"></script> +</head> +<body onload='window.resizeTo(300,200);SQLFMT.format(document.all.sp_submit);waitForResult()'> +<div id="retvalues"></div> +<p><b>Copyright &copy; 2001-2010 Gudu Software<br>All Rights Reserved<br><a href="mailto:support@dpriver.com">Contact US</a></b></p> +<br><br><br><br><br> +<p align=right>Please wait…</p> +<div class="page-container-1" style="display:none;"> + <div id="container"> + <div id="wrapper"> + <div id="content"> + <form id="SqlFmtForm" name="frm_sqlformat" method="post" action="/cgi-bin/ppserver" onsubmit="return false;"> + <div id="secondpanel"> + <div id="sp_database"> + <label class="desc" style="display:inline;">Database</label> + <select name="dbvendor"> + <option value="mysql" selected>MySQL</option> + </select> + <label class="desc" style="display:inline;padding:0 0 0px 40px; border:0px solid;">Output:</label> + <select name="outputfmt"> + <option value="SQL" selected>SQL(Text)</option> + </select> + </div> + </div> + <div id="sqlpanel"> + <div id="sp_inputsql"> + <textarea id ="inputsql" name="inputsql" cols="1" rows="1" wrap="off"> + `cat` + </textarea> + </div> + <div id="sp_submit"> + <input type="button" id="btnformat" name="print" value="Format SQL" onclick="SQLFMT.format(this)" value="Format SQL"> + <label style="display:none;">(Time used: <span id="timestamp">0</span> seconds)</label> + </div> + <div id="sp_submit" style="text-align:left;"> + </div> + <label id="errorhint" class="desc" style="color:#DF0000 !important;display:none;"> + Can't format input sql, make sure there is no syntax error and select correct database. + <a href="" style="display:none;">OR Report a bug of this sql beautifier</a> + </label> + <iframe id="ioutputsql" ></iframe> + <div id="sp_outputsql" style="display:none;"> + <textarea id = "outputsql" name="outputsql" cols="80" rows="15" wrap="off" > + </textarea> + </div> + <div id="sp_errormsg" style="display:none;"> + Error message goes to here! + </div> + </div> + <div id="formatoptions"> + <select name="keywordcs"> + <option value="Uppercase" selected >Uppercase</option> + <option value="Lowercase" >Lowercase</option> + <option value="InitCap" >InitCap</option> + <option value="Unchanged" >Unchanged</option> + </select> + <select name="identifiercs"> + <option value="Uppercase" >Uppercase</option> + <option value="Lowercase" selected >Lowercase</option> + <option value="InitCap" >InitCap</option> + <option value="Unchanged" >Unchanged</option> + <option value="initcapeachword" >Init cap each word</option> + </select> + <select name="functioncs"> + <option value="Uppercase" >Uppercase</option> + <option value="Lowercase" >Lowercase</option> + <option value="InitCap" selected >InitCap</option> + <option value="Unchanged" >Unchanged</option> + </select> + <input type="radio" name="lnbrwithcomma" value="after" checked > After + <input type="radio" name="lnbrwithcomma" value="before" > Before + <input type="radio" name="lnbrwithcomma" value= "beforewithspace" > Before with space + <input type="radio" name="liststyle" value="stack" checked>Stacked + <input type="radio" name="liststyle" value="nostack">Not Stacked + <input type="radio" name="salign" value="sleft" checked> Align left + <input type="radio" name="salign" value="sright" > Align right + <input type="checkbox" name="andorunderwhere" value="yes" checked> And/Or under Where + <input type="checkbox" name="removelnbr" value="yes" checked> Remove Linebreak before beautify + <input type="checkbox" name="trimquotechar" value="yes"> Trim Quoted Char of Each Line quoted char of eachline: <input type="text" name="quotechar" value= "&#34" size = 5 > + <input type="checkbox" name="compactmode" value="yes"> Compact the output of sql output + <input type="text" name="maxlenincm" value= "80" size = 5 > + </div> + <input type="hidden" name="clientid" value="4149-9094-8133-2031" /> + </form> + </div> + </div> + </div> +</div> + +</body> +</html> +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> |