Contents

module Ridgepole
  class ExternalSqlExecuter
    def initialize(script, logger)
      @script = script
      @logger = logger
    end

    def execute(sql)
      cmd = Shellwords.join([@script, sql, JSON.dump(ActiveRecord::Base.connection_config)])
      @logger.info("Execute #{@script}")
      script_basename = File.basename(@script)

      Open3.popen3(cmd) do |stdin, stdout, stderr, wait_thr|
        stdin.close_write
        files = [stdout, stderr]

        begin
          until files.empty?
            ready = IO.select(files)

            next unless ready
            readable = ready[0]

            readable.each do |f|
              begin
                data = f.read_nonblock(1024)
                next if data.nil?
                data.chomp!

                if f == stderr
                  @logger.warn("[WARNING] #{script_basename}: #{data}")
                else
                  @logger.info("#{script_basename}: #{data}")
                end
              rescue EOFError
                files.delete f
              end
            end
          end
        rescue EOFError # rubocop:disable Lint/HandleExceptions
          # nothing to do
        end

        raise "`#{@script}` execution failed" unless wait_thr.value.success?
      end
    end
  end
end

Version data entries

4 entries across 4 versions & 1 rubygems

Version	Path
ridgepole-0.7.4	lib/ridgepole/external_sql_executer.rb
ridgepole-0.7.3	lib/ridgepole/external_sql_executer.rb
ridgepole-0.7.3.beta3	lib/ridgepole/external_sql_executer.rb
ridgepole-0.7.3.beta2	lib/ridgepole/external_sql_executer.rb