Sha256: 5dc7d35d4a166a181337a0606e844c6eceb518d21203ddefdd90a8092a245d6d
Contents?: true
Size: 1.8 KB
Versions: 11
Compression:
Stored size: 1.8 KB
Contents
# models
class User < ActiveRecord::Base
has_many :authorships
has_many :readerships
has_many :books_authored, :through => :authorships, :source => :book
has_many :books_read, :through => :readerships, :source => :book
has_many :addresses, :class_name => 'User::Address'
def readers
User.joins(:books_read => :authors).where(:authors_books => {:id => self})
end
scope :by_name, order(:name)
scope :by_read_count, lambda {
cols = if connection.adapter_name == "PostgreSQL"
column_names.map { |column| %{"users"."#{column}"} }.join(", ")
else
'"users"."id"'
end
group(cols).select("count(readerships.id) AS read_count, #{cols}").order('read_count DESC')
}
end
class Authorship < ActiveRecord::Base
belongs_to :user
belongs_to :book
end
class Readership < ActiveRecord::Base
belongs_to :user
belongs_to :book
end
class Book < ActiveRecord::Base
has_many :authorships
has_many :readerships
has_many :authors, :through => :authorships, :source => :user
has_many :readers, :through => :readerships, :source => :user
end
# a model that is a descendant of AR::Base but doesn't directly inherit AR::Base
class Admin < User
end
# a model with namespace
class User::Address < ActiveRecord::Base
belongs_to :user
end
#migrations
class CreateAllTables < ActiveRecord::Migration
def self.up
create_table(:gem_defined_models) { |t| t.string :name; t.integer :age }
create_table(:users) {|t| t.string :name; t.integer :age}
create_table(:books) {|t| t.string :title}
create_table(:readerships) {|t| t.integer :user_id; t.integer :book_id }
create_table(:authorships) {|t| t.integer :user_id; t.integer :book_id }
create_table(:user_addresses) {|t| t.string :street; t.integer :user_id }
end
end
ActiveRecord::Migration.verbose = false
CreateAllTables.up
Version data entries
11 entries across 11 versions & 4 rubygems