<?xml version="1.0" encoding="windows-1252"?>
<node id="680807" title="Re: The future of Text::CSV_XS - TODO" created="2008-04-16 10:23:43" updated="2008-04-16 06:23:43">
<type id="11">
note</type>
<author id="200365">
Tux</author>
<data>
<field name="doctext">
&lt;code&gt;
  file: $CPAN/authors/id/H/HM/HMBRAND/Text-CSV_XS-0.42.tgz
  size: 86136 bytes
   md5: 1cf4491f48965793f1e31fc74159f20f
 
We can do MAGIC now!
 
Dumping the content of a database ($dbh) table ($tbl) to CSV:
 
  my $csv = Text::CSV_XS-&gt;new ({ binary =&gt; 1, eol =&gt; $/ });
  open my $fh, "&gt;", "$tbl.csv" or die "$tbl.csv: $!";
  my $sth = $dbh-&gt;prepare ("select * from $tbl");
  $sth-&gt;execute;
  $csv-&gt;print ($fh, $sth-&gt;{NAME_lc});
  while (my $row = $sth-&gt;fetch) {
      $csv-&gt;print ($fh, $row);
      }
  close $fh;
 
2008-04-16  0.42 - H.Merijn Brand
 
        * Generate META.yml myself. I won't use Build.PL
        * Array-refs now accept scalars with magic:
          $csv-&gt;print (*STDOUT, $sth-&gt;{NAME_lc});
        * More/better examples
        * Added t/76_magic.t
&lt;/code&gt;
&lt;!-- Node text goes above. Div tags should contain sig only --&gt;
&lt;div class="pmsig"&gt;&lt;div class="pmsig-200365"&gt;
&lt;br /&gt;
Enjoy, Have FUN! H.Merijn
&lt;/div&gt;&lt;/div&gt;</field>
<field name="root_node">
617577</field>
<field name="parent_node">
617577</field>
</data>
</node>
