From Code to Community: Sponsoring The Perl and Raku Conference 2025 Learn more

 / 
DBIx-CSV-0.004
River stage one • 1 direct dependent • 1 total dependent
/ DBIx::CSV

NAME

DBIx::CSV - Generate CSV from SQL query result

VERSION

This document describes version 0.004 of DBIx::CSV (from Perl distribution DBIx-CSV), released on 2018-12-07.

SYNOPSIS


            

              
              
use DBI;
use DBIx::CSV;
my $dbh = DBI->connect("dbi:mysql:database=mydb", "someuser", "somepass");

Generating a row of CSV (with header):


            

              
              
print $dbh->selectrow_csv("SELECT * FROM member");

Sample result:


            

              
              
"Name","Rank","Serial"
"alice","pvt","123456"

Generating a row of CSV (without header):


            

              
              
print $dbh->selectrow_csv_noheader("SELECT * FROM member");

Sample result:


            

              
              
"alice","pvt","123456"

Generating all rows (with header):


            

              
              
print $dbh->selectall_csv("SELECT * FROM member");

Sample result:


            

              
              
"Name","Rank","Serial"
"alice","pvt","123456"
"bob","cpl","98765321"
"carol","brig gen","8745"

Generating all rows (without header):


            

              
              
print $dbh->selectall_csv_noheader("SELECT * FROM member");

Statement handle versions:


            

              
              
print $sth->fetchrow_csv;
print $sth->fetchrow_csv_noheader;
print $sth->fetchall_csv;
print $sth->fetchall_csv_noheader;

DESCRIPTION

This package is a thin glue between DBI and DBIx::TextTableAny (which in turn is a thin glue to Text::Table::Any). It adds the following methods to database handle:


            

              
              
selectrow_csv
selectall_csv
selectrow_csv_noheader
selectall_csv_noheader

as well as the following methods to statement handle:


            

              
              
fetchrow_csv
fetchall_csv
fetchrow_csv_noheader
fetchall_csv_noheader

The methods send the result of query to Text::Table::Any (using the Text::Table::CSV backend) and return the rendered CSV data.

In essence, this is an easy, straightforward way produce CSV data from SQL query.

HOMEPAGE

Please visit the project's homepage at https://metacpan.org/release/DBIx-CSV.

SOURCE

Source repository is at https://github.com/perlancar/perl-DBIx-CSV.

BUGS

Please report any bugs or feature requests on the bugtracker website https://rt.cpan.org/Public/Dist/Display.html?Name=DBIx-CSV

When submitting a bug or request, please include a test-file or a patch to an existing test-file that illustrates the bug or desired feature.

SEE ALSO

DBI::Format, particularly DBI::Format::CSV

DBIx::CSVDumper

DBIx::TextTableAny which has a similar interface as this module and offers multiple output formats.

AUTHOR

perlancar <perlancar@cpan.org>

COPYRIGHT AND LICENSE

This software is copyright (c) 2018 by perlancar@cpan.org.

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