* rename method names (actually in tests)
* rename instance variable @_named_scopes_cache to @_scopes_cache
* rename references in doc comments
* don't touch CHANGELOG :)

[#6022 state:resolved]

When use where more than once on the same column, relation doesn't do an 'or' or 'in' with the values

- persisted? is the API defined in ActiveModel
- makes it easier for extension libraries to conform to ActiveModel APIs
  without concern for whether the extended object is specifically
  ActiveRecord

[#5927 state:committed]
Signed-off-by: NSantiago Pastorino <santiago@wyeworks.com>

use column names as order by complex function parameters, fix for postgresql adapter to correctly remove ASC/DESC
Signed-off-by: NSantiago Pastorino <santiago@wyeworks.com>

Fixes queries using limits and punctuation in order, removes order("col1, col2") usage in favor of order(["col1", "col2"})

[#4597 state:committed]

while declaring default_scope

Also added test for unscoped using block style with four different
combinations
Signed-off-by: NJosé Valim <jose.valim@gmail.com>

added a test for relation which checks intersection between a relation and an array works in both directions
Signed-off-by: NMikel Lindsaar <raasdnil@gmail.com>

order that is declared first has highest priority in all cases.

Here are some examples.

Car.order('name desc').find(:first, :order => 'id').name

Car.named_scope_with_order.named_scope_with_another_order

Car.order('id DESC').scoping do
  Car.find(:first, :order => 'id asc')
end

No special treatment to with_scope or scoping.

Also note that if default_scope declares an order then the order
declared in default_scope has the highest priority unless
with_exclusive_scope is used.
Signed-off-by: NSantiago Pastorino <santiago@wyeworks.com>

Signed-off-by: NJosé Valim <jose.valim@gmail.com>

code gardening: we have assert_(nil|blank|present), more concise, with better default failure messages - let's use them

Signed-off-by: NJosé Valim <jose.valim@gmail.com>

Signed-off-by: NJosé Valim <jose.valim@gmail.com>

[#5153 state:resolved]
Signed-off-by: NJosé Valim <jose.valim@gmail.com>

Add scoping and unscoped as the syntax to replace the old with_scope and with_exclusive_scope. A few examples:

* with_scope now should be scoping:

Before:

  Comment.with_scope(:find => { :conditions => { :post_id => 1 } }) do
    Comment.first #=> SELECT * FROM comments WHERE post_id = 1
  end

After:

  Comment.where(:post_id => 1).scoping do
    Comment.first #=> SELECT * FROM comments WHERE post_id = 1
  end

* with_exclusive_scope now should be unscoped:

  class Post < ActiveRecord::Base
    default_scope :published => true
  end

  Post.all #=> SELECT * FROM posts WHERE published = true

Before:

  Post.with_exclusive_scope do
    Post.all #=> SELECT * FROM posts
  end

After:

  Post.unscoped do
    Post.all #=> SELECT * FROM posts
  end

Notice you can also use unscoped without a block and it will return an anonymous scope with default_scope values:

  Post.unscoped.all #=> SELECT * FROM posts

Signed-off-by: NJosé Valim <jose.valim@gmail.com>

[#4972 state:committed]
Signed-off-by: NJosé Valim <jose.valim@gmail.com>

[#4972]
Signed-off-by: NJosé Valim <jose.valim@gmail.com>

[#4841 state:committed]

[#4882 state:resolved]
Signed-off-by: NJosé Valim <jose.valim@gmail.com>