1Fsdb::Filter::sqlselectU_steor_dCbo(n3t)ributed Perl DocFusmdebn:t:aFtiilotner::sqlselect_to_db(3)
2
3
4

NAME

6       sqlselect_to_db - convert MySQL or MariaDB selected tables to fsdb
7

SYNOPSIS

9           sqlselect_to_db <source.sqlselect_table >dest.fsdb
10

DESCRIPTION

12       Converts a MySQL or MariaDB tables to Fsdb format.
13
14       The input is not fsdb.  The first non-box row is taken to be the names
15       of the columns.
16
17       The output is two-space-separated fsdb.  (Someday more general field
18       separators should be supported.)
19
20       This module also supports the standard fsdb options:
21
22       -d  Enable debugging output.
23
24       -i or --input InputSource
25           Read from InputSource, typically a file name, or "-" for standard
26           input, or (if in Perl) a IO::Handle, Fsdb::IO or Fsdb::BoundedQueue
27           objects.
28
29       -o or --output OutputDestination
30           Write to OutputDestination, typically a file name, or "-" for
31           standard output, or (if in Perl) a IO::Handle, Fsdb::IO or
32           Fsdb::BoundedQueue objects.
33
34       --autorun or --noautorun
35           By default, programs process automatically, but Fsdb::Filter
36           objects in Perl do not run until you invoke the run() method.  The
37           "--(no)autorun" option controls that behavior within Perl.
38
39       --help
40           Show help.
41
42       --man
43           Show full manual.
44

SAMPLE USAGE

46   Input:
47           +----------------+---------------+--------------------+------+-------------------------+
48           | username       | firstname     | lastname           | id   | email                   |
49           +----------------+---------------+--------------------+------+-------------------------+
50           | johnh          | John          | Heidemann          |  134 | johnh@isi.edu           |
51           +----------------+---------------+--------------------+------+-------------------------+
52           1 row in set (0.01 sec)
53
54   Command:
55           sqlselect_to_db
56
57   Output:
58           #fsdb -F S username firstname lastname id email
59           johnh  John  Heidemann  134  johnh@isi.edu
60           #   | sqlselect_to_db
61

SEE ALSO

63       Fsdb.  db_to_csv.
64

CLASS FUNCTIONS

66   new
67           $filter = new Fsdb::Filter::csv_to_db(@arguments);
68
69       Create a new csv_to_db object, taking command-line arguments.
70
71   set_defaults
72           $filter->set_defaults();
73
74       Internal: set up defaults.
75
76   parse_options
77           $filter->parse_options(@ARGV);
78
79       Internal: parse command-line arguments.
80
81   setup
82           $filter->setup();
83
84       Internal: setup, parse headers.
85
86   run
87           $filter->run();
88
89       Internal: run over each rows.
90
92       Copyright (C) 2014-2018 by John Heidemann <johnh@isi.edu>
93
94       This program is distributed under terms of the GNU general public
95       license, version 2.  See the file COPYING with the distribution for
96       details.
97
98
99
100perl v5.32.1                      2021-01-27  Fsdb::Filter::sqlselect_to_db(3)
Impressum