Contents

class Upsert
  class MergeFunction
    # @private
    module Sqlite3
      attr_reader :quoted_setter_names
      attr_reader :quoted_selector_names

      def initialize(*)
        super
        @quoted_setter_names = setter_keys.map { |k| connection.quote_ident k }
        @quoted_selector_names = selector_keys.map { |k| connection.quote_ident k }
      end

      def create!
        # not necessary
      end

      def execute(row)
        bind_setter_values = row.setter.values.map { |v| connection.bind_value v }
        bind_selector_values = row.selector.values.map { |v| connection.bind_value v }
        
        insert_or_ignore_sql = %{INSERT OR IGNORE INTO #{quoted_table_name} (#{quoted_setter_names.join(',')}) VALUES (#{Array.new(bind_setter_values.length, '?').join(',')})}
        connection.execute insert_or_ignore_sql, bind_setter_values

        update_sql = %{UPDATE #{quoted_table_name} SET #{quoted_setter_names.map { |qk| "#{qk}=?" }.join(',')} WHERE #{quoted_selector_names.map { |qk| "#{qk}=?" }.join(' AND ')}}
        connection.execute update_sql, (bind_setter_values + bind_selector_values)
      end
    end
  end
end

Version data entries

7 entries across 7 versions & 1 rubygems

Version	Path
upsert-1.1.7	lib/upsert/merge_function/sqlite3.rb
upsert-1.1.6	lib/upsert/merge_function/sqlite3.rb
upsert-1.1.5	lib/upsert/merge_function/sqlite3.rb
upsert-1.1.4	lib/upsert/merge_function/sqlite3.rb
upsert-1.1.3	lib/upsert/merge_function/sqlite3.rb
upsert-1.1.1	lib/upsert/merge_function/sqlite3.rb
upsert-1.1.0	lib/upsert/merge_function/sqlite3.rb