Masayuki Matsuki

NAME

DBIx::CSVDumper - dumping database (DBI) data into a CSV.

SYNOPSIS

  use DBIx::CSVDumper;
  my $dbh = DBI->connect(...);
  my $dumper = DBIx::CSVDumper->new(
    csv_args  => {
      binary          => 1,
      always_quote    => 1,
      eol             => "\r\n",
    },
    encoding    => 'utf-8',
  );
  
  my $sth = $dbh->prepare('SELECT * FROM item');
  $sth->execute;
  $dumper->dump(
    sth     => $sth,
    file    => 'tmp/hoge.csv',
  );

DESCRIPTION

DBIx::CSVDumper is a module for dumping database (DBI) data into a CSV.

CONSTRUCTOR

new
  my $dumper = DBIx::CSVDumper->new(%args);

Create new dumper object. %args is a hash with object parameters. Currently recognized keys are:

csv_args
  csv_args => {
    binary          => 1,
    always_quote    => 1,
    eol             => "\r\n",
  },
  (default: same as above)
encoding
  encoding => 'cp932',
  (default: utf-8)

METHOD

dump
  $dumper->dump(%args);

Dump CSV file. %args is a hash with parameters. Currently recognized keys are:

sth
  sth => $sth
  (required)

the value is a DBI::st object. execute method should be called beforehand or automatically called with DBI 1.41 or newer and no bind parameters.

file
  file => $file

string of file name.

fh
  fh => $fh

file handle. args file or fh is required.

encoding
  enocding => 'euc-jp',
  (default: $dumper->encoding)

encoding.

csv_obj
encoding

AUTHOR

Masayuki Matsuki <y.songmu@gmail.com>

SEE ALSO

LICENSE

This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.