module Ruport::Format

  class SQL < Plugin

    attr_accessor :dbh

    def build_table_body
      src = Ruport::Config.source(:default)
      @dbh = DBI.connect(src.dsn, src.user, src.password)

      data.each do |r|
        output << "insert into #{@options.table_name} "
        output << "(#{@data.column_names.join(',')}) "
        output << "values (#{build_sql_values(r)});\n"
      end

      dbh.disconnect
    end

    def build_sql_values(row)
      row.map {|v| @dbh.quote(v) }.join(',')
    end

    def method_missing(message, *args)
      @options.send(message, *args)
    end

    Ruport::Renderer::Table.add_format self, :sql
  end
end