copy sql command

    def call
      @conn.exec(ERB.new(erb_template).result(binding))
    end

    private

    def post_initialize(args)
      @iam_role = ENV['iam_role']
      @conn = Database::Adapter.conn
      @directory = Model.to_s.underscore
      @bucket_name = ENV['bucket_name']
    end

    def erb_template
      <<-SQL
        <% TABLES.each do |table| %>
          copy <%= table %>_copy
          from 's3://<%= "#{bucket_name}/#{@directory}/#{id}" %>/<%= table %>.txt.'
          iam_role '<%= @iam_role %>'
          region 'ap-northeast-1'
          blanksasnull
          emptyasnull
          GZIP
          delimiter '\t'
          NULL AS 'NULL'
          ;
        <% end %>
      SQL
    end