view release on metacpan or  search on metacpan

bin/dbiloader  view on Meta::CPAN

dbiloader - A tiny script to load CSV/TSV contents into a database table via DBI

=head1 VERSION

version v0.0.2

=head1 SYNOPSIS

dbiloader C<-h>

dbiloader [C<-c>] [C<-t E<lt>separatorE<gt>>] [C<-u E<lt>usernameE<gt>>] [C<-p E<lt>passwordE<gt>>] C<E<lt>connectionE<gt>> C<E<lt>tableE<gt>> [C<E<lt>schemaE<gt>>] [C<E<lt>filesE<gt>>...]

  # Read TSV and load into mytable in SQLite database t.db
  dbiloader -t '\t' dbi:SQLite:t.db mytable data.txt

  # Clear mytable, read CSV (default), and load into mytable in SQLite database t.db
  dbiloader -c dbi:SQLite:t.db mytable data.txt

  # Drop mytalbe if exists, create mytable, read CSV (default), and load into mytable in SQLite database t.db
  dbiloader dbi:SQLite:t.db mytable '(key INTEGER PRIMARY KEY, value INTEGER)' data.txt

bin/dbiloader  view on Meta::CPAN

NOTE that field separation is currently done by just a C<split>. Thus, quoting is not correctly handled.

=head2 C<-c>

Clear the specified table before contents loading.

=head2 C<-u E<lt>usernameE<gt>>

Specify username.

=head2 C<-p E<lt>passwordE<gt>>

Specify password.

=head2 C<E<lt>connectionE<gt>>

Specify DBI connection string.

=head2 C<E<lt>tableE<gt>>

Specify table name.

=head2 C<E<lt>schemaE<gt>>