method

build_insert_sql

Importance_0
v7.0.0 - Show latest stable - 0 notes - Class: AbstractMysqlAdapter
build_insert_sql(insert) public

No documentation

This method has no description. You can help the Ruby on Rails community by adding new notes.

Hide source
# File activerecord/lib/active_record/connection_adapters/abstract_mysql_adapter.rb, line 538
      def build_insert_sql(insert) # :nodoc:
        sql = +"INSERT #{insert.into} #{insert.values_list}"

        if insert.skip_duplicates?
          no_op_column = quote_column_name(insert.keys.first)
          sql << " ON DUPLICATE KEY UPDATE #{no_op_column}=#{no_op_column}"
        elsif insert.update_duplicates?
          sql << " ON DUPLICATE KEY UPDATE "
          if insert.raw_update_sql?
            sql << insert.raw_update_sql
          else
            sql << insert.touch_model_timestamps_unless { |column| "#{column}<=>VALUES(#{column})" }
            sql << insert.updatable_columns.map { |column| "#{column}=VALUES(#{column})" }.join(",")
          end
        end

        sql
      end
Register or log in to add new notes.