All pastes #500092 Raw Edit

Stuff

public text v1 · immutable
·published 2007-05-21 13:06 UTC
rendered paste body
foreach $table (@tables) {

        print "Export de la table $table.\n";

        open OUT,">$table.CSV";
        my @hcolonnes = ();
        my @col_lines  = @{$dbh->selectall_arrayref("select cname from col where tname='$table' order by colno")};
        foreach $colonne (@col_lines) {
                push @hcolonnes, @$colonne[0];
        }
        $colonnes = join "$sep",@hcolonnes;
        my $requete = "select ".(join ",",@hcolonnes)." from $table";


        print OUT "$colonnes\n";

        # Requetage de la base
        my $line;
        my @vals = @{$dbh->selectall_arrayref($requete)};
        foreach $line (@vals) {
                        print OUT join ("$sep",@$line);
                        print OUT "\n";
                }
        close OUT;
}