#!/usr/bin/perl

#
# sql_to_db.pm
# Copyright (C) 2014-2018 by John Heidemann <johnh@isi.edu>
#
# This program is distributed under terms of the GNU general
# public license, version 2.  See the file COPYING
# in $dblib for details.
#


=head1 NAME

sqlselect_to_db - convert MySQL or MariaDB selected tables to fsdb

=head1 SYNOPSIS

    sqlselect_to_db <source.sqlselect_table >dest.fsdb

=head1 DESCRIPTION

Converts a MySQL or MariaDB tables to Fsdb format.

The input is I<not> fsdb.
The first non-box row is taken to be the names of the columns.

The output is two-space-separated fsdb.
(Someday more general field separators should be supported.)

=for comment
begin_standard_fsdb_options

This module also supports the standard fsdb options:

=over 4

=item B<-d>

Enable debugging output.

=item B<-i> or B<--input> InputSource

Read from InputSource, typically a file name, or C<-> for standard input,
or (if in Perl) a IO::Handle, Fsdb::IO or Fsdb::BoundedQueue objects.

=item B<-o> or B<--output> OutputDestination

Write to OutputDestination, typically a file name, or C<-> for standard output,
or (if in Perl) a IO::Handle, Fsdb::IO or Fsdb::BoundedQueue objects.

=item B<--autorun> or B<--noautorun>

By default, programs process automatically,
but Fsdb::Filter objects in Perl do not run until you invoke
the run() method.
The C<--(no)autorun> option controls that behavior within Perl.

=item B<--help>

Show help.

=item B<--man>

Show full manual.

=back

=for comment
end_standard_fsdb_options


=head1 SAMPLE USAGE

=head2 Input:

    +----------------+---------------+--------------------+------+-------------------------+
    | username       | firstname     | lastname           | id   | email                   |
    +----------------+---------------+--------------------+------+-------------------------+
    | johnh          | John          | Heidemann          |  134 | johnh@isi.edu           |
    +----------------+---------------+--------------------+------+-------------------------+
    1 row in set (0.01 sec)

=head2 Command:

    sqlselect_to_db

=head2 Output:

    #fsdb -F S username firstname lastname id email
    johnh  John  Heidemann  134  johnh@isi.edu
    #   | sqlselect_to_db


=head1 SEE ALSO

L<Fsdb>.
L<db_to_csv>.


=cut


# WARNING: This code is derived from sqlselect_to_db.pm; that is the master copy.

use Fsdb::Filter::sqlselect_to_db;
my $f = new Fsdb::Filter::sqlselect_to_db(@ARGV);
$f->setup_run_finish;  # or could just --autorun
exit 0;


=head1 AUTHOR and COPYRIGHT

Copyright (C) 2014-2018 by John Heidemann <johnh@isi.edu>

This program is distributed under terms of the GNU general
public license, version 2.  See the file COPYING
with the distribution for details.

=cut

1;