method

join_to_update

Ruby on Rails latest stable (v6.1.7.7) - 0 notes - Class: ActiveRecord::ConnectionAdapters::DatabaseStatements

1.0.0
1.1.6
1.2.6
2.0.3
2.1.0
2.2.1
2.3.8
3.0.0
3.0.9
3.1.0 (0)
3.2.1 (0)
3.2.8 (0)
3.2.13 (0)
4.0.2 (0)
4.1.8 (0)
4.2.1 (0)
4.2.7 (0)
4.2.9 (0)
5.0.0.1 (0)
5.1.7 (0)
5.2.3 (0)
6.0.0
6.1.3.1
6.1.7.7
7.0.0
7.1.3.2
What's this?

Method deprecated or moved

This method is deprecated or moved on the latest stable version. The last existing version (v5.2.3) is shown here.

join_to_update(update, select, key) public

The default strategy for an UPDATE with joins is to use a subquery. This doesn’t work on MySQL (even when aliasing the tables), but MySQL allows using JOIN directly in an UPDATE statement, so in the MySQL adapters we redefine this to do that.

Show source

# File activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb, line 422
      def join_to_update(update, select, key) # :nodoc:
        subselect = subquery_for(key, select)

        update.where key.in(subselect)
      end

join_to_update

Related methods

Method deprecated or moved

Flowdock - Team Inbox With Chat for Software Developers