Refactor
:my
=>
'code'
Codes
Refactorings
Popular
Best
Submit
Spam
Account
Logout
Login
JavaScript doesn't seem to be activated, expect things to be ugly and sloppy!
More Jobs
Recent
Closure scoping issue
Parse HTTP Accept headers
Int32 Quick Parser
Find the file with the highest mtime in a directory
While loop to get unique value
ruby metaprogramming
includes_all?
Expanding input list using jQuery
Streamline attaching onPaste behavior to fields
Which is more readable? Math.* or if (...)
Popular
Int32 Quick Parser
ruby metaprogramming
includes_all?
Find the file with the highest mtime in a directory
Parse HTTP Accept headers
Closure scoping issue
While loop to get unique value
Command Pattern from Head First Design Patterns book.
Which is more readable? Math.* or if (...)
Streamline attaching onPaste behavior to fields
Pastable version of
Constructing a search query
<div style="overflow:auto;border:solid 1px #ccc;background:#000;color:#F8F8F8"> <div class="section"> <pre style="float:left;margin:0 10px;border-right:0;color:#666;">1 2 3 4 5 6 7 8 9 10 11 12 13</pre> <pre class="sunburst"><span style="color:#E28964;">def</span> <span style="color:#89BDFF;">construct_search_query</span> query <span style="color:#E28964;">=</span> <span style="color:#65B042;"><span style="color:#65B042;">'</span>*<span style="color:#65B042;">'</span></span> query <span style="color:#E28964;"><<</span> <span style="color:#65B042;"><span style="color:#65B042;">'</span>AND (<span style="color:#65B042;">'</span></span> <span style="color:#E28964;"><<</span> params[<span style="color:#3387CC;"><span style="color:#3387CC;">:</span>search_all</span>] <span style="color:#E28964;"><<</span> <span style="color:#65B042;"><span style="color:#65B042;">'</span>)<span style="color:#65B042;">'</span></span> <span style="color:#E28964;">if</span> params[<span style="color:#3387CC;"><span style="color:#3387CC;">:</span>search_all</span>] <span style="color:#E28964;">&&</span> params[<span style="color:#3387CC;"><span style="color:#3387CC;">:</span>search_all</span>].<span style="color:#89BDFF;">length</span> <span style="color:#E28964;">></span> <span style="color:#3387CC;">3</span> query <span style="color:#E28964;"><<</span> <span style="color:#65B042;"><span style="color:#65B042;">'</span> AND (<span style="color:#65B042;">'</span></span> <span style="color:#E28964;"><<</span> params[<span style="color:#3387CC;"><span style="color:#3387CC;">:</span>search_any</span>].<span style="color:#89BDFF;">split</span>(<span style="color:#65B042;"><span style="color:#65B042;">'</span> <span style="color:#65B042;">'</span></span>).<span style="color:#89BDFF;">join</span>(<span style="color:#65B042;"><span style="color:#65B042;">'</span>OR<span style="color:#65B042;">'</span></span>) <span style="color:#E28964;"><<</span><span style="color:#65B042;"><span style="color:#65B042;">'</span>)<span style="color:#65B042;">'</span></span> <span style="color:#E28964;">if</span> params[<span style="color:#3387CC;"><span style="color:#3387CC;">:</span>search_any</span>] <span style="color:#E28964;">&&</span> params[<span style="color:#3387CC;"><span style="color:#3387CC;">:</span>search_any</span>].<span style="color:#89BDFF;">length</span> <span style="color:#E28964;">></span> <span style="color:#3387CC;">3</span> query<span style="color:#E28964;"><<</span> <span style="color:#65B042;"><span style="color:#65B042;">'</span> AND (\"<span style="color:#65B042;">'</span></span> <span style="color:#E28964;"><<</span> params[<span style="color:#3387CC;"><span style="color:#3387CC;">:</span>search_exact</span>] <span style="color:#E28964;"><<</span><span style="color:#65B042;"><span style="color:#65B042;">'</span>\")<span style="color:#65B042;">'</span></span> <span style="color:#E28964;">if</span> params[<span style="color:#3387CC;"><span style="color:#3387CC;">:</span>search_exact</span>] <span style="color:#E28964;">&&</span> params[<span style="color:#3387CC;"><span style="color:#3387CC;">:</span>search_exact</span>].<span style="color:#89BDFF;">length</span> <span style="color:#E28964;">></span> <span style="color:#3387CC;">3</span> query <span style="color:#E28964;"><<</span> <span style="color:#65B042;"><span style="color:#65B042;">'</span> AND NOT (<span style="color:#65B042;">'</span></span> <span style="color:#E28964;"><<</span> params[<span style="color:#3387CC;"><span style="color:#3387CC;">:</span>search_exclude</span>] <span style="color:#E28964;"><<</span><span style="color:#65B042;"><span style="color:#65B042;">'</span>)<span style="color:#65B042;">'</span></span> <span style="color:#E28964;">if</span> params[<span style="color:#3387CC;"><span style="color:#3387CC;">:</span>search_exclude</span>] <span style="color:#E28964;">&&</span> params[<span style="color:#3387CC;"><span style="color:#3387CC;">:</span>search_exclude</span>].<span style="color:#89BDFF;">length</span> <span style="color:#E28964;">></span> <span style="color:#3387CC;">3</span> query <span style="color:#E28964;"><<</span> <span style="color:#65B042;"><span style="color:#65B042;">'</span> AND (title:<span style="color:#65B042;">'</span></span> <span style="color:#E28964;"><<</span> params[<span style="color:#3387CC;"><span style="color:#3387CC;">:</span>search_title</span>] <span style="color:#E28964;"><<</span><span style="color:#65B042;"><span style="color:#65B042;">'</span>)<span style="color:#65B042;">'</span></span> <span style="color:#E28964;">if</span> params[<span style="color:#3387CC;"><span style="color:#3387CC;">:</span>search_title</span>] <span style="color:#E28964;">&&</span> params[<span style="color:#3387CC;"><span style="color:#3387CC;">:</span>search_title</span>].<span style="color:#89BDFF;">length</span> <span style="color:#E28964;">></span> <span style="color:#3387CC;">3</span> query <span style="color:#E28964;"><<</span> <span style="color:#65B042;"><span style="color:#65B042;">'</span> AND (author_names:<span style="color:#65B042;">'</span></span> <span style="color:#E28964;"><<</span> params[<span style="color:#3387CC;"><span style="color:#3387CC;">:</span>search_author</span>] <span style="color:#E28964;"><<</span><span style="color:#65B042;"><span style="color:#65B042;">'</span>)<span style="color:#65B042;">'</span></span> <span style="color:#E28964;">if</span> params[<span style="color:#3387CC;"><span style="color:#3387CC;">:</span>search_author</span>] <span style="color:#E28964;">&&</span> params[<span style="color:#3387CC;"><span style="color:#3387CC;">:</span>search_author</span>].<span style="color:#89BDFF;">length</span> <span style="color:#E28964;">></span> <span style="color:#3387CC;">3</span> query <span style="color:#E28964;"><<</span> <span style="color:#65B042;"><span style="color:#65B042;">'</span> AND (publisher_name:<span style="color:#65B042;">'</span></span> <span style="color:#E28964;"><<</span> params[<span style="color:#3387CC;"><span style="color:#3387CC;">:</span>search_publisher</span>] <span style="color:#E28964;"><<</span><span style="color:#65B042;"><span style="color:#65B042;">'</span>)<span style="color:#65B042;">'</span></span> <span style="color:#E28964;">if</span> params[<span style="color:#3387CC;"><span style="color:#3387CC;">:</span>search_publisher</span>] <span style="color:#E28964;">&&</span> params[<span style="color:#3387CC;"><span style="color:#3387CC;">:</span>search_publisher</span>].<span style="color:#89BDFF;">length</span> <span style="color:#E28964;">></span><span style="color:#3387CC;">3</span> query <span style="color:#E28964;"><<</span> <span style="color:#65B042;"><span style="color:#65B042;">'</span> AND (description:<span style="color:#65B042;">'</span></span> <span style="color:#E28964;"><<</span> params[<span style="color:#3387CC;"><span style="color:#3387CC;">:</span>search_description</span>] <span style="color:#E28964;"><<</span><span style="color:#65B042;"><span style="color:#65B042;">'</span>)<span style="color:#65B042;">'</span></span> <span style="color:#E28964;">if</span> params[<span style="color:#3387CC;"><span style="color:#3387CC;">:</span>search_description</span>] <span style="color:#E28964;">&&</span> params[<span style="color:#3387CC;"><span style="color:#3387CC;">:</span>search_description</span>].<span style="color:#89BDFF;">length</span> <span style="color:#E28964;">></span> <span style="color:#3387CC;">3</span> query <span style="color:#E28964;"><<</span> <span style="color:#65B042;"><span style="color:#65B042;">'</span> AND (tags:<span style="color:#65B042;">'</span></span> <span style="color:#E28964;"><<</span> params[<span style="color:#3387CC;"><span style="color:#3387CC;">:</span>search_tags</span>] <span style="color:#E28964;"><<</span><span style="color:#65B042;"><span style="color:#65B042;">'</span>)<span style="color:#65B042;">'</span></span> <span style="color:#E28964;">if</span> params[<span style="color:#3387CC;"><span style="color:#3387CC;">:</span>search_tags</span>] <span style="color:#E28964;">&&</span> params[<span style="color:#3387CC;"><span style="color:#3387CC;">:</span>search_tags</span>].<span style="color:#89BDFF;">length</span> <span style="color:#E28964;">></span> <span style="color:#3387CC;">3</span> <span style="color:#E28964;">return</span> query <span style="color:#E28964;">end</span> </pre> </div> </div> <a href="http://refactormycode.com/codes/353-construct-search-query" style="color:#fff" title="As seen on RefactorMyCode.com"><img alt="Small_logo" src="http://refactormycode.com/images/small_logo.gif" style="border:0" /></a>