| Subject: | SQLite CSV loader doesnt work |
In the CSV Loader package the driver is lower cased, however SQLite is
checked in original case "SQLite". This should be changed to "sqlite".
my $driver = lc $self->dbh->get_info($GetInfoType{SQL_DBMS_NAME});
--- ETLp-0.03/lib/ETLp/Loader/CSV.pm 2010-11-16 10:15:17.000000000 +0100
+++ ETLp-0.03.patch/lib/ETLp/Loader/CSV.pm 2011-07-01 10:17:21.987454905
+0200
@@ -218,7 +218,7 @@
return "TO_DATE(?, '" . posix2oracle($posix_pattern) . "')";
} elsif ($driver eq 'mysql') {
return "STR_TO_DATE(?,'$posix_pattern')";
- } elsif ($driver eq 'SQLite') {
+ } elsif ($driver eq 'sqlite') {
return '?'
}
ETLpException->throw(error => "Unknown Database Driver: $driver");