ColumnScope¶ ↑

Selecting only specified columns can safe you resources and processing time.

I wrote this plugin because I do this all the time and I don’t want to cripple my code anymore.

ColumnScope is build on top of NamedScope so it only works with Ruby on Rails 2.1+.

Examples:¶ ↑

Item.selects(:name).proxy_options[:select] # => '"items"."name"'

content = 'Foo Bar Baz'

Item.create :name => 'foo', :value => 1, :content => content
Item.create :name => 'bar', :value => 2, :content => content
Item.create :name => 'baz', :value => 3, :content => content

Item.selects(:name).values.all :order => 'id' # => %w[foo bar baz]

# use a shortcut to retrieve values of name and content distinct
Item.select_first :distinct_name__content # => ['foo', content]

# without shortcut
Item.selects(:name, :content).uniq!.values.first # => ['foo', content]

# reject named columns in scope :a_named_scope and select only the values
Item.a_named_scope.rejects(:content).values.all # => [[1, 'foo', 1], ...]

See test/column_scope_test.rb for more examples.

Install (rails):¶ ↑

$ script/plugin install git://github.com/boof/column_scope.git

# alternativly:
$ cd vendor/plugins
$ git clone git://github.com/boof/column_scope.git

Copyright © 2008 Florian Aßmann, released under the MIT license