Displaying 20 results from an estimated 1000 matches similar to: "ActiveRecord instead of direct sql execution"
2008 Jan 02
3
Submitted a patch, got pluses, what now?
Hello Rails people,
I submitted a patch recently to get rid of an annoying exception raised when
an AR
object is created - http://dev.rubyonrails.org/ticket/10556 , had some
people review it,
got some pluses... What am I supposed to do now?
Can anybody advise or just review the patch and take care of the issue?
Thanks!
--
Best regards,
Yuri Leikind
2004 Jul 20
7
radiobuttons are weird in 1.2.x series
Hello all,
Run groupbox.rb example in any of the two alpha versions and
click the radiobutton in the upper right group box (those named Hilvesum 1,
Hilversum 2, etc). You''ll notice that once a radiobutton is checked,
it remains checked when some other radiobutton is checked.
What''s the reason?
Thank you.
--
Best regards,
Yuri Leikind
2008 May 08
1
Eager loading of association extensions
Hello all,
Is it possible to do eager loading of association extensions?
That is, the following code produces one SQL query:
cat = ProductCategory.find(:first, :include => :pricing_rules)
cat.pricing_rules
But if in ProductCategory I have an association extension like this:
has_many :pricing_rules do
def applicable()
find(:all).select(&:applicable?)
end
end
the
2007 May 10
5
Pagination has many through problems
I have searched for days for an example that demonstrates what i would
like to do, and this morning i thought i''d worked it out, but
no....here''s what i have:
Controller
==========
class ProfilesController < ApplicationController
def friends
current_user.profile.friends
end
def list_friends
@profile_pages, @profiles = paginate( friends, :per_page => 10)
end
end
2009 Oct 05
11
Unable to install plugins from github
Hi All,
My operating system is FC11...I tried to install will_paginate from
github directly like this -
script/plugin install git://github.com/mislav/will_paginate.git
But I get an error saying
[ckkashyap@KingCobra test_plugin]$ script/plugin install
git://github.com/mislav/will_paginate.git
Plugin not found: ["git://github.com/mislav/will_paginate.git"]
I have git on my machine - I
2008 Jul 02
3
update_all not changing updated_at
Hi everyone-
Model.update_all works and changes the records, but it''s not changing
the updated_at field. Am I doing something wrong or is this by
design?
Thanks,
Dino
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to
2006 Jun 01
2
update_all broken in postgres?
Hi
has anyone managed to use update_all with rails on postgres?
In my setup, it does not work:
>> @keyword.update_all(myupdates)
NoMethodError: undefined method `update_all'' for #<Keyword:0xb7ac4670>
from
/home/lib/ruby/gems/1.8/gems/activerecord-1.14.0/lib/active_record/base.rb:1786:in
`method_missing''
from (irb):14
I checked that the base.rb
2007 Sep 07
6
ActiveRecord::Base#update_all expected behaviour
Hi
I noticed that if in my code I use the following:
Photo.update_all("title = ''Ruby rocks'' ", "id IN (#{@photo_ids})")
All my objects are properly updated but none of the filters/callbacks
are triggered. Is that what''s expected?
I have a before_update filter set on the Photo class and it gets
totally ignored, I guess the only way to solve this
2007 Oct 12
2
missing attribute: reorder
I am trying to use an integer object as a flag item for displaying a
link on a page called reorder that is a column in my PlanProcedures
table.
I''m getting an error that says
The Header is NoMethodError in Manage_plan_procedures#list
missing attribute: reorder
Here is what my model looks like:
>> PlanProcedure.column_names
=> ["id", "plan_id",
2007 Sep 21
1
Temporary disabling after_update
Hi,
I am trying to replace my old database trigger with ActiveRecord
callbacks in rails.
I have a model like following:
class Action < ActiveRecord::Base
belongs_to :inquiry
def after_update
#clean up all action associated with the inquiry.
Action.update_all("latest = ''''", ["inquiry_id = ?",
self.inquiry_id])
#find the latest action
2006 Jul 06
4
update_all Not Incrementing lock_version
Shouldn''t update_all be updating lock_version? As you can see from my
console session below, it is upating the record (changed running
attribute to true and returned 1 to show 1 recored was updated). But it
did not increment lock_version. And optimistic locking is working
correctly otherwise. As you can see below, lock version = 562 before
and after the update_all call but it is
2006 Apr 11
6
Reduce Number of Queries When Using ActiveRecord
I have a controller method called update_all that grabs parameters for about
30 form fields and saves them to the database. My current code looks to see
if there is a string in params[] for each form field (two fields for each
SelfEvaluationItem) and saves the updated self_evaluation_answer if a string
is available. Since this is iterated code, I am almost certain that this
generates 30 or so
2009 Jun 07
17
ActiveRecord Classes
I''m having a little trouble with understanding how to work out the
schematic for some of my classes using ActiveRecord when a file is in my
lib directory:
Brief example:
Here''s the outline of the files in use:
....app
........controllers
............application_controller.rb
............rushing_offenses_controller.rb
........models
............rushing_offense.rb
....lib
2006 Jan 23
4
ActionRecord: how to update many records in one statement
Hello,
I am trying to edit and update all records of table ?intersts? (id,
name, description) on one page and has no good idea how to do it right,
when updating one record per page it?s ok The question is: what
statement instead Interest.update_all(params[:interest]) in controller
need to use to successfully update the database table by data passing to
controller in parameter ?interest??
2007 May 10
2
Dynamic counter?
Hi,
In a form I have a text area T and a disable text field C (for
counter).
C must show dynamically how many characters have been typed in T.
Should
I go in for a Javascript solution (or Ajax) or is there any other
way?
Thanks,
Ram.
--
Posted via http://www.ruby-forum.com/.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are
2007 May 20
2
Newbie question - self.var OR @var in ActiveRecord
I started learning rails by following the agile way. It comes to the
point where it puzzles me.
class Puzzle < ActiveRecord::Base
# virtual var, not existing in the database
def var
@var
end
def var=(foo)
@var= foo
@var_in_database = @var + 1 # var_in_database exists in database
end
end
Then when I do a save of this model it does nothing. I know that if I
instead put
2005 Mar 10
10
Some Basic Questions
Sorry I can''t access IRC from work so I hope you don''t mind me asking my newbie
questions here:
1) I have the following code:
@post = Post.find(@params[''id''])
@comments = Comment.find_all "post_id = #@params[''id'']", "created_on ASC"
And I am have problems with the second line. I want to pass the id from my post
to the
2006 Mar 24
6
Should counter_cache fields be saved in the database?
As far as I can tell, the counter_cache option on a belongs_to model
doesn''t actually save anything in the database. For example, I have
the following models:
class Parent < ActiveRecord::Base
has_many :children,
:conditions => "deleted_at IS NULL"
end
class Child < ActiveRecord::Base
belongs_to :parent, :counter_cache => true
end
With the following
2006 Aug 05
10
Converting mysql to postgres
Hi,
Anyone got any cool tricks for converting a Rails site (in this case,
a typo installation) from a mysql database to a postgresql database?
I''ve got it almost working -- I''m doing a SQL dump from mysql and
loading it into postgres. However, mysql does booleans as a tinyint
with 0 = false and 1 = true. When I try to import that into a
postgres database that expects booleans
2006 Feb 07
1
displaying foreign keys help request
Hi ..
(I seem to be having some problems getting my posts to the list for some
reason. Sorry if you see this as a repost).
A conceptual question this time.
I have the relation:
member (m)---(1) member_type
The schema looks something like this (simplified + PGSQL)
create table member_types (
id serial,
info varchar( 20 ) not null,
primary key( id