Fsdb::F...ml_to_db(3)

okay bestie, welcome to Fsdb::F...ml_to_db(3) — that’s the User Contributed Perl Documentation page for a little XML-to-fsdb converter. It’s giving “niche but iconic,” and we’re gonna read it together. 💖

✨ NAME ✨

xml_to_db — convert a subset of XML into fsdb

🦋 SYNOPSIS 🦋

        xml_to_db -k EntityField <source.xml

🌸 DESCRIPTION 🌸

Okay so this thing converts a very limited subset of XML into Fsdb format. No cap: limited limited.

The input is XML-format (not fsdb). It gets parsed as XML, and each entity of type ENTITYFIELD is extracted as a row. ENTITYFIELD can have multiple components separated by slashes, which lets you walk down the XML tree if necessary. Slay.

The input XML file is assumed to be very simple. All rows are assumed to be sequential in one entity. Anything other than the specified ENTITYFIELD is ignored. The schema is assumed to be defined by the first instances of that field.

The output is two-space-separated fsdb. (Someday more general field separators should be supported — manifesting ✨.) Fsdb fields are a normalized version of the CSV file: spaces are converted to single underscores.

heads up, bestie: this is a very limited subset and the input is assumed to be super simple. It is not a general XML parser vibe check. 💀

🎀 OPTIONS 🎀

• -e EmptyValue or --empty — specify the value newly created columns get.

This module also supports the standard fsdb options:

🌈 standard fsdb options, also supported

• -d — enable debugging output.
• -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:

            <?xml version='1.0' standalone='yes'?>
            <gnuPod>
             <files>
              <file addtime="3389919728" album="Born to Pick" artist="7th Day Buskers" title="Loch Lamor" />
              <file addtime="3389919728" album="Born to Pick" artist="7th Day Buskers" title="The Floods" />
              <file addtime="3389919735" album="Copland Conducts Copland" artist="Aaron Copland" title="Our Town" />
             </files>
             <playlist name="new shows" plid="97241" >
               <regex artist="^(Le Show|This American Life)$" />
             </playlist>
            </gnuPod>

🛠️ Command:

            xml_to_db -k files/file <gnupod.xml

💅 Output:

            #fsdb -F S addtime album artist title
            3389919728  Born to Pick  7th Day Buskers  Loch Lamor
            3389919728  Born to Pick  7th Day Buskers  The Floods
            3389919735  Copland Conducts Copland  Aaron Copland  Our Town
            #   | xml_to_db -k files/file

👀 SEE ALSO 👀

Fsdb.

🧚 CLASS FUNCTIONS 🧚

🌱 new

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

Create a new xml_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.

🔥 _find_entities

$filter->_find_entities

Internal: walk the ENTITYFIELD specification through the XML::Simple data structure. Returns an aref.

🌸 setup

$filter->setup();

Internal: setup, parse headers.

⭐ run

$filter->run();

Internal: run over each row.

👑 AUTHOR and COPYRIGHT 👑

Copyright (C) 2011-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.

---

xoxo bestie, this page is from perl v5.32.1, dated 2024-08-02 💅✨