search for: construct_sql

I can submit a patch, but wanted to confirm I''m looking at this right... The docs indicate that if you specify a has_many association with :finder_sql, but no :counter_sql, it constructs the appropriate counter sql by substituting the SELECT clause. But has_many_association.rb doesn''t seem to do that -- it just passes Base#count_by_sql the finder_sql, which doesn''t

...for Table A using various callbacks, after_create, after_save, before_create. Trying to set the table_b attribute to a new Table B instance and have table_b''s foreign key be the id the table_a object being created. However, i kept running into exceptions "undefined method ''construct_sql''. I checked my dev log and saw there was an INSERT query for table_b just after table_a''s INSERT, which is what i wanted. But it dies right after. Why is that? So do i need to just call table_a_inst.table_b = Table_B.new() table_a_inst.save everytime i want to create a Table_A...

...ve_record/reflection.rb:125:in `send'' from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/reflection.rb:125:in `klass'' from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/associations/has_many_association.rb:194:in `construct_sql'' ... 30 levels... from /Users/sparta/Projects/work/idastudios/ff/vendor/plugins/rspec/lib/spec/runner/option_parser.rb:154:in `parse'' from /Users/sparta/Projects/work/idastudios/ff/vendor/plugins/rspec/lib/spec/runner/option_parser.rb:88:in `create_behavio...

...s/1.8/gems/activerecord-1.13.2/lib/active_record/base.rb:1198:in `id'' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/base.rb:1209:in `quoted_id'' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/associations/has_many_association.rb:169:in `construct_sql'' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/associations/has_many_association.rb:8:in `initialize'' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/associations.rb:753:in `new'' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.1...

...mber < Person end Adding an Address to a Member results in the addressable_type column equaling "Person" when it should be "Member". Looking in ActiveRecord::Associations::AssociationProxy#set_belongs_to_association_for and ActiveRecord::Associations:: HasManyAssociation#construct_sql it''s clear why. >From ActiveRecord::Associations::AssociationProxy#set_belongs_to_association_for: record["#{@reflection.options[:as]}_type"] = @owner.class.base_class.name.to_s Removing the call to base_class results in the behavior I expected. I did this by patching th...

...ble_stack=PropertyVariableStack.new end When this ran, I could trace all the correct SQL being generated in the logs, but it raised an error: test_sample(TestPropertyLoader) [Z:/sics/test/tc_property_loader.rb:66]: Exception raised: Class: <NoMethodError> Message: <"undefined method `construct_sql'' for #<PropertyVariableStack:0x2c77d0 8>"> Can anyone tell me why this is? & maybe advise on how to achieve what I''m after? Thanks in advance, doug.

...orphic association using a lookup hash which maps an integer to a class name. Storing a TINYINT unsigned is waaaaay more efficient than storing a string like "SomeActiveRecordModel" over and over again. Looking in the association proxy classes for has_one and has_many, I see: def construct_sql case when @reflection.options[:as] @finder_sql = "#{@reflection.quoted_table_name}.#{@reflection.options[:as]}_id = #{@owner.quoted_id} AND " + "#{@reflection.quoted_table_name}.#{@reflection.options[:as]}_type = #{@owner.class.quote_...

.../activerecord-2.2.0/lib/active_record/reflection.rb:151:in `klass'' /Library/Ruby/Gems/1.8/gems/activerecord-2.2.0/lib/active_record/reflection.rb:182:in `quoted_table_name'' /Library/Ruby/Gems/1.8/gems/activerecord-2.2.0/lib/active_record/associations/has_many_association.rb:91:in `construct_sql'' /Library/Ruby/Gems/1.8/gems/activerecord-2.2.0/lib/active_record/associations/association_collection.rb:21:in `initialize'' /Library/Ruby/Gems/1.8/gems/activerecord-2.2.0/lib/active_record/associations.rb:1289:in `new'' /Library/Ruby/Gems/1.8/gems/activerecord-2.2.0/lib/ac...

...LS_ROOT}/vendor/rails/activerecord/lib/active_record/ reflection.rb:125:in `send'' #{RAILS_ROOT}/vendor/rails/activerecord/lib/active_record/ reflection.rb:125:in `klass'' #{RAILS_ROOT}/vendor/rails/activerecord/lib/active_record/ associations/has_many_association.rb:174:in `construct_sql'' #{RAILS_ROOT}/vendor/rails/activerecord/lib/active_record/ associations/has_many_association.rb:6:in `initialize'' #{RAILS_ROOT}/vendor/rails/activerecord/lib/active_record/ associations.rb:998:in `new'' #{RAILS_ROOT}/vendor/rails/activerecord/lib/active_record...

Three tables: users: id clients: id admin_contacts: user_id, client_id class Client has_many :admin_contacts has_many :contacts, :through => :admin_contacts, :foreign_key => :user_id, :class_name => ''User'' end I added the :contacts for ease of use of grabbing the user objects associated with the admin_contact. This all works great, I can grab the Users that

...e/framework/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/reflection.rb:129:in `table_name'' /Applications/Locomotive2/Bundles/rmagickRailsMar2007_i386.locobundle/framework/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/associations/has_one_association.rb:67:in `construct_sql'' /Applications/Locomotive2/Bundles/rmagickRailsMar2007_i386.locobundle/framework/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/associations/has_one_association.rb:6:in `initialize'' /Applications/Locomotive2/Bundles/rmagickRailsMar2007_i386.locobundle/framework/lib/r...