Use [update_all][1] with the optional second parameter for the condition:

    Model.update_all({ hidden: true }, { phonenum: some_phone_number})


  [1]: http://apidock.com/rails/ActiveRecord/Relation/update_all

The update_all does not allow conditions in rails 3. You can use combination of scope and update_all 

    Model.where(phonenum: some_phone_number).update_all(hidden: true)

Reference: http://m.onkey.org/active-record-query-interface

If you want to trigger callbacks:

    class ActiveRecord::Base
      def self.update_each(updates)
        find_each { |model| model.update(updates) }
      end
    
      def self.update_each!(updates)
        find_each { |model| model.update!(updates) }
      end
    end

Then:

    Model.where(phonenum: some_phone_number).update_each(hidden: true)

Here&#39;s the relevant code.  I&#39;ve confirmed with the alert that the correct number is saved, it&#39;s just not being changed to 2 decimal places. 

    if ($(this).attr(&#39;name&#39;) == &#39;time&#39;) {
    	var value = $(this).val();
    	parseFloat(value).toFixed(2);
    	alert(value);
    	editEntry.time = value;
    }

Why is my toFixed() function not working?

I want to define table which will have 2 TIMESTAMP fields, someting like this:

    CREATE TABLE `msgs` (
        `id` INT PRIMARY KEY AUTO_INCREMENT,
        `msg` VARCHAR(256),
        `ts_create` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
        `ts_update` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
    )

How to do this avoiding error:

    ERROR 1293 (HY000): Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause

Point is to keep desired behavior of `ts_create` and `ts_update` in table schema.

MySQL CURRENT_TIMESTAMP on create and on update

In rails 3, using activerecord, is there a single-query way to set the **:hidden** field to **TRUE** for all records that meet a condition ... say, for example, `:condition =&gt; [ &quot;phonenum = ?&quot;, some_phone_number ]`

If a single query cannot do it, what IS the optimal approach?

Rails 3 + activerecord, the best way to &quot;mass update&quot; a single field for all the records that meet a condition

In rails 3, using activerecord, is there a single-query way to set the :hidden field to TRUE for all records that meet a condition ... say, for example, <code>:condition => [ "phonenum = ?", some_phone_number ]</code>
If a single query cannot do it, what IS the optimal approach?

In my Rails 3 project, I want to send some simple notification emails. I don&#39;t need to make a template for them or do any logic. I just want to fire them off from various places in the system.

If I were doing this in an arbitrary ruby script I would use [pony][1]. However, I&#39;d like to still use the rails mail facilities and configuration, so that I get the same reliability and setup that I have for the rest of the mail in my system.

What&#39;s the most simple way to do this? Ideally there would be some method like 

    ActionMailer.send(:to =&gt; &#39;foo@example.com&#39;, :subject =&gt;&quot;the subject&quot;, :body =&gt;&quot;this is the body&quot;)


  [1]: https://github.com/benprew/pony

How can I send mail with rails without a template?

What is the right way to embed an image into email using Rails?

What is the right way to embed image into email using Rails?

After loading the Rails console, how should I sign in a user?

Devise provides a test helper which can be used in tests and I&#39;ve tried to use in console:

    &gt;&gt; include Devise::TestHelpers
    &gt;&gt; helper.sign_in(User.first)

But I get:

    NoMethodError: undefined method `env&#39; for nil:NilClass

Anyway, I would like to use the real devise helper and not this test helper. Is there any way to achieve this?

How to sign in a user using Devise from a Rails console?

I have trying to access helper methods from a rails 3 mailer in order to access the current user for the session. 

I put the helper :application in my mailer class, which seems to work, except the methods defined therein are not available to my mailer (i get undefined errors). Does anyone know how this is supposed to work?

Here&#39;s my class: 
    
    class CommentMailer &lt; ActionMailer::Base
      default :from =&gt; &quot;Andre Fournier &lt;andre@gfournier.com&gt;&quot;
      
      helper :application
    end

Thanks,
Sean

Access helpers from mailer?

The SO post below is comprehensive, but all three methods described fail to encode for periods.

Post: https://stackoverflow.com/questions/332872/how-to-encode-a-url-in-javascript

For instance, if I run the three methods (i.e., escape, encodeURI, encodeURIComponent), none of them encode periods.

So &quot;food.store&quot; comes out as &quot;food.store,&quot; which breaks the URL.  It breaks the URL because the Rails app cannot recognize the URL as valid and displays the 404 error page.  Perhaps it&#39;s a configuration mistake in the Rails routes file?

What&#39;s the best way to encode periods with Javascript for URLs?

How to encode periods for URLs in Javascript?

If I create a new rails 3 migration with (for example)

    rails g migration tester title:tester user:references

, everything works fine...however if I add a column with something along the lines of:

    rails g migration add_user_to_tester user:references

the reference field is not recognised. In short, the question is: how do I add a referencing column to a rails migration from the command line?





Rails 3 migrations: Adding reference column?

The #new_record? function determines if a record has been saved. But it is always false in the `after_save` hook. Is there a way to determine whether the record is a newly created record or an old one from update? 

I&#39;m hoping not to use another callback such as `before_create` to set a flag in the model or require another query into the db.

Any advice is appreciated. 

Edit: Need to determine it in `after_save` hook, and for my particular use case, there is no `updated_at` or `updated_on` timestamp

How to determine if a record is just created or updated in after_save

Suppose a database contains a field &#39;keywords&#39; and sample records include:
&quot;pipe wrench&quot;
&quot;monkey wrench&quot;
&quot;crescent wrench&quot;
&quot;crescent roll&quot;
&quot;monkey bars&quot;

is there a way in activerecord to find the records where the keyword field contains the substring &quot;crescent&quot;?

(It&#39;s just a quick and dirty lookup for a quick concept prototype)



can you use activerecord to find substring of a field? (quick &amp; dirty keyword finder)

In testing a getter/setter pair in a rails model, I&#39;ve found a good example of behavior I&#39;ve always thought was odd and inconsistent.

In this example I&#39;m dealing with `class Folder &lt; ActiveRecord::Base`.

`Folder belongs_to :parent, :class_name =&gt; &#39;Folder&#39;`

On the getter method, if I use:

    def parent_name
      parent.name
    end

...or...

    def parent_name
      self.parent.name
    end
	
...the result is exactly the same, I get the name of the parent folder. However, in the getter method if I use...

    def parent_name=(name)
      parent = self.class.find_by_name(name)
    end

... parent becomes nil, but if I use...

    def parent_name=(name)
      self.parent = self.class.find_by_name(name)
    end

...then then it works.

So, my question is, why do you need to declare self.method sometimes and why can you just use a local variable?

It seems the need for / use of `self` in ActiveRecord is inconsistent, and I&#39;d like to understand this better so I don&#39;t feel like I&#39;m always guessing whether I need to declare self or not. When should you / should you not use self in ActiveRecord models?

Why isn&#39;t self always needed in ruby / rails / activerecord?

I have a table in a Rails app with hundreds of thousands of records, and they only have a `created_at` timestamp. I&#39;m adding the ability to edit these records, so I want to add an `updated_at` timestamp to the table. In my migration to add the column, I want to update all rows to have the new `updated_at` match the old `created_at`, since that&#39;s the default for newly created rows in Rails. I could do a `find(:all)` and iterate through the records, but that would take hours because of the size of the table. What I really want to do is:

&lt;!-- language: lang-sql --&gt;

    UPDATE table_name SET updated_at = created_at;

Is there a nicer way to do that in a Rails migration using ActiveRecord rather than executing raw SQL?

Content Type	Original Author	Original Content on Stackoverflow
Question	jpw	View Question on Stackoverflow
Solution 1 - Ruby on-Rails	Dogbert	View Answer on Stackoverflow
Solution 2 - Ruby on-Rails	Deepak N	View Answer on Stackoverflow
Solution 3 - Ruby on-Rails	Dorian	View Answer on Stackoverflow

Rails 3 + activerecord, the best way to "mass update" a single field for all the records that meet a condition

Ruby on-Rails Problem Overview

Ruby on-Rails Solutions

Solution 1 - Ruby on-Rails

Solution 2 - Ruby on-Rails

Solution 3 - Ruby on-Rails

MySQL CURRENT_TIMESTAMP on create and on update

Why is my toFixed() function not working?

Attributions