Is your plugin hosted on GitHub? Make sure to press the "fetch" button next to the repository field to fetch your plugin's info from GitHub rather than typing it all in.

Repository

Name

Home Page

Short description
Simplify query options with association automation and improve inner join for activerecord of rails

Description
Feature ======= 1. single name string decribe associations 2. support to mix inner join and outer join with any order 3. auto remove duplicated joins from other association in different depth 4. support :conditions, :order, :group 5. auto merge to original :include, :joins Install ======= ruby script/plugin install http://rquerypad.rubyforge.org/svn/trunk/rquerypad or ruby script/plugin install http://rquerypad.googlecode.com/svn/trunk/rquerypad Example ======= suppose the asscociations of User <-> Thread <-> Reply is 1:N:N @users = User.find(:all, :group => ["threads.created_at", "name"]) generate: [:all, {:group=>"threads.created_at, users.name", :include=>[:threads]}] @users = User.find(:all, :conditions => ["threads_.replies.title = ?", "rquerypad"]) generate: [:all, {:inner_joins=>["threads"], :conditions=>["replies.title = ?", "rquerypad"], :include=>[{:threads=>:replies}]}] #note: the :inner_joints is processed by rquerypad before sending sql to database @users = User.find(:all, :conditions => ["threads.replies.title = ? and threads.id = ?", "rquerypad", 1]) generate: [:all, {:conditions=>["replies.title = ? and threads.id = ?", "rquerypad", 1], :include=>[{:threads=>:replies}]}] #note: single "threads" was removed from includes Setup ======= #to set debug model, in rails initialized script $RQUERYPAD_DEBUG = true #to support rails 1.2.6, in rails initialized script, such as environment.rb #default support rails 2.0 $RQUERYPAD_RAILS = "1.2" Test ======= Note: current migrate script works only in rails 2.0 1.Prepare the test depends on sqlite3 database, the following code should be add into your database.yml and place rquerypad.rb(copy from test.rb) in config/environment rquerypad: adapter: sqlite3 database: vendor/plugins/rquerypad/test/db.rquerypad timeout: 5000 2.database migrate execute the following script rake migrate 3.start test execute the following script rake

Description format
RDoc MarkDown Textile

License
Ruby's Rails' (MIT) GPL LGPL BSD Apache Artistic PublicDomain BSD-type Free-Trial Free-but-Restricted OpenSource Proprietary Shareware Source-available-proprietary Commercial

Category
Assets Controllers Internationalization Misc. Enhancements Model Rails Engines Searching and Queries Security Statistics and Logs Testing View Extensions