# 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 # SEE ALSO # LICENSE This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.