Fsdb::F...ct_to_db(3)

🎀 NAME 🎀

okay so this is sqlselect_to_db, and it lives on the Fsdb::F...ct_to_db(3) page from the User Contributed Perl Documentation. It’s giving “convert MySQL or MariaDB selected tables to fsdb” energy 💅

✨ SYNOPSIS ✨

sqlselect_to_db <source.sqlselect_table >dest.fsdb

💖 DESCRIPTION 💖

Converts a MySQL or MariaDB tables to Fsdb format.

The input is 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.)

This module also supports the standard fsdb options:

🫶 standard fsdb options 🫶

• -d — Enable debugging output. spill the debugging tea, bestie 🫖
• -i or --input InputSource — Read from InputSource, typically a file name, or "-" for standard input, or (if in Perl) a IO::Handle, Fsdb::IO or Fsdb::BoundedQueue objects.
• -o or --output OutputDestination — Write to OutputDestination, typically a file name, or "-" for standard output, or (if in Perl) a IO::Handle, Fsdb::IO or Fsdb::BoundedQueue objects.
• --autorun or --noautorun — By default, programs process automatically, but Fsdb::Filter objects in Perl do not run until you invoke the run() method. The --(no)autorun option controls that behavior within Perl.
• --help — Show help.
• --man — Show full manual.

---

🌈 SAMPLE USAGE 🌈

🌸 Input 🌸

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

🎀 Command 🎀

sqlselect_to_db

💫 Output 💫

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

🦋 SEE ALSO 🦋

Fsdb. db_to_csv.

👑 CLASS FUNCTIONS 👑

💅 new 💅

$filter = new Fsdb::Filter::csv_to_db(@arguments);

Create a new csv_to_db object, taking command-line arguments.

💅 set_defaults 💅

$filter->set_defaults();

Internal: set up defaults.

💅 parse_options 💅

$filter->parse_options(@ARGV);

Internal: parse command-line arguments.

💅 setup 💅

$filter->setup();

Internal: setup, parse headers.

💅 run 💅

$filter->run();

Internal: run over each rows.

💜 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.

---

mwah 💋 that’s the page! footer tea: perl v5.32.1, dated 2024-08-02, and it’s the Fsdb::F...ct_to_db(3) page. go be iconic, bestie ✨🫶