similar to: Request for adding an "alias"/"as" to ActiveRecord

I''m trying to figure out how to use ActiveRecord in conjunction with ARel. In particular, I''d like to replace my residual literal SQL with ARel, if only I could see how. Let''s take Article with multiple Versions as an example. With ARel alone, I can find articles with their latest versions like this articles = Article.arel_table versions = Article.arel_table

What is the recommended way to use table aliases with ActiveRecord::Relation these days? In prior versions of Rails, this would work: assume (pseudo code): model A has_many b''s model B ,,, at = B.arel_table atalias = at.alias(at.name + "_1") A.join(:b).join(atalias).where(atalias[:a_id].eq(at[:a_id]).where("b.widget =

I trying to create a select using Arel but I''m passing three parameters, I want to include the parameters only if they are different to nil or blank. Here is my method: def self.advsearch(summary_description, specialties, place) User.joins(:experience,:summary,:information) .where(Information.arel_table[:business].eq(false))

hi, I''ve got the following tables in mysql notation: CREATE TABLE `nodes` ( `id` int(11) NOT NULL auto_increment, `parent_id` int(11) default ''0'', `group_id` int(11) default ''0'', PRIMARY KEY (`id`), ); CREATE TABLE `groups` ( `parent_id` int(11) NOT NULL default ''0'', `id` int(11) NOT NULL auto_increment,

Hi all I want to make copy of current scoped object, then change some stuff in arel_table(i need to change table_alias, because i have complicated query) and arel(SelectManager) def self.do_smth query = scoped.dup puts query.arel_table.object_id == scoped.arel_table.object_id # true end Theoretically i can dup arel(SelectManager) but i can not find how to add table alias to that instance

So I''ve worked through Agile Web Development with Rails and I''m now trying my first little app to get into the swing of things. Its a task tracking app where people can create tasks and assign them to others, and also log time against the tasks. I''m having trouble working out the model relationships. This is what I''ve got so far, but its not right as

Hi, guys I have a puzzle about default_scope. Suppose I have two model: class User < ActiveRecord::Base has_many :blogs default_scope where(deleted_at: nil) end class Blog < ActiveRecord::Base belongs_to :user end I want to produce sqlselect blogs.* from blogs inner join users on users.id = blogs.user_id and users.deleted_at is null And the code Blog.joins(:user), which I think

Really no idea what''s up... class Auction < ActiveRecord::Base has_and_belongs_to_many :categories end class Category < ActiveRecord::Base has_and_belongs_to_many :auctions default_scope order(''title'') scope :active, where(:active => true) end class CategoriesController < ApplicationController respond_to :html, :json # GET /categories/:id

Good afternoon, I am currently migrating an app from rails 2.1 to rails 3 and found a problem that I realized was due to the fact that the BD columns had reserved rails names. I only have read access to BD, so I can''t change the name of columns. The column in question is called "reference" and I''m having a very strange behavior during implementation: 1) initializing /

I want to build an application that has the concept of administrative domains. What I mean by this is that administrators have access to different data, based on what domains they are a member of. The domain strucutre is hierarchical. Here is an example: - MLB - AL - East - Yankees - Red Sox ... + Central + West - NL + East + Central + West Now

hi, can someone help me with understanding, why i can''t get my set_sub_tree method to run correctly and what to do to make it work? when i run the testcase below i get --- D:\ruby\test>ruby test/unit/demo_test.rb Loaded suite test/unit/demo_test Started F Finished in 0.625 seconds. 1) Failure: test_set_sub_tree(DemoTest) [test/unit/demo_test.rb:13]: fails@4. <200> expected

first some background info: I have a blog application that has a comments table with the following columns: id parent_id post_id created_at body here''s my model: class Comment < ActiveRecord::Base belongs_to :post acts_as_tree :order => ''created_at'' def print_children (options={}) before = options[:before] ? options[:before]

I would like to apply logical delete in my application(Instead of permanently deleting a record just have been marked as deleted). I have Added *available* column to all tables with default value *true*. Now I want common place to write the following code for all models. 1. Write the instance method which make ''available'' column value false when user clicks on

Hi, I am doing an eager loading in ruby on rails using below statement ------------------------ Article.find(:all, :include => [:asset, :vote], :conditions=>"assets.parent_id is null", :order=>"stat_final_ranking desc", :limit=>20) --------------------------------------- the above statement resulted in this expensive query.

Hi, Rails 2.3.2 class TestD < ActiveRecord::Base default_scope :limit => 12 named_scope :limit, lambda { |num| { :limit => num} } end ruby script/console >> TestD.all TestD Load (0.7ms) SELECT * FROM "test_ds" LIMIT 12 => [] >> TestD.limit(14) TestD Load (0.3ms) SELECT * FROM "test_ds" LIMIT 12 => [] Any ideas why the default limit

Hello rubyonrails-core, I’ve been looking into possible changes to ActiveRecord / Arel to make it easier to write Rails applications that are free of SQL injection vulnerabilities, and in particular do so in a way that makes it easy for a code reviewer to verify that the app is safe from such bugs. The concern: ----------------- With the ActiveRecord API as is, it’s relatively easy to write

The recent refactoring didn't work properly for new smart pools, so I've cleaned jup the parameter handling for the various pool 'create' actions. Signed-off-by: Scott Seago <sseago at redhat.com> --- src/app/controllers/hardware_controller.rb | 5 +---- src/app/controllers/pool_controller.rb | 6 ++++-- src/app/controllers/resources_controller.rb | 6

Hi all. I have has_and_belongs_to_many association between models: Section and Content. class Section < ActiveRecord::Base acts_as_tree has_and_belongs_to_many :contents belongs_to :default_content, :class_name => ''Content'', :foreign_key => ''default_content_id'', :dependent => :nullify end class Content < ActiveRecord::Base belongs_to

Say I want to gather info from various Models... Files, Folders, and put them into a ''display'' Object DisplayFilesystem that will standarize the info from both tables (for display only)... Class DisplayFilesystem attr_accessor :item_id, :name, :type, :description, :date def initialize @item_id = @name = @type = @description = @date = nil end end So in the code side

Hi Railers, I''ve got a Categories table. I want it to act as a list within the scope of the parent_id AND the site_id. Categories table : id label site_id parent_id So, in my Category class, I have : acts_as_list :scope => ''site_id = #{site_id} AND parent_id = # {parent_id}'' The problem is that when I try to move_up a Category with a parent_id that is null,