DBIx::CSV - Generate CSV from SQL query result
This document describes version 0.004 of DBIx::CSV (from Perl distribution DBIx-CSV), released on 2018-12-07.
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");
"alice","pvt","123456"
Generating all rows (with header):
print $dbh->selectall_csv("SELECT * FROM member");
"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;
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.
Please visit the project's homepage at https://metacpan.org/release/DBIx-CSV.
Source repository is at https://github.com/perlancar/perl-DBIx-CSV.
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.
DBI::Format, particularly DBI::Format::CSV
DBIx::CSVDumper
DBIx::TextTableAny which has a similar interface as this module and offers multiple output formats.
perlancar <perlancar@cpan.org>
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.
To install DBIx::CSV, copy and paste the appropriate command in to your terminal.
cpanm
cpanm DBIx::CSV
CPAN shell
perl -MCPAN -e shell install DBIx::CSV
For more information on module installation, please visit the detailed CPAN module installation guide.