DB_TO_HTML_TABLE(1)

📦
version 3.9 · 3 versions
, in epel 9

🎀 NAME 🎀

okay so bestie, this is db_to_html_table — it converts db to an HTML table. that's the whole gig. iconic behavior honestly 💅

✨ SYNOPSIS ✨

db_to_html_table [-g N] <source.fsdb >dest.html

like, pipe it in, pipe it out, slay 🦋

💖 DESCRIPTION 💖

so what it does is: covert an existing dbtable to an HTML table. (yes, "covert" — that's literally what the page says, we're not touching it, it's part of the lore now 🙈)

the output is a fragment of an HTML page, not the whole thing. we assume you, the user, fill in the rest — head, body, all that ~structure~. main character energy is your job, not ours ✨

  • Input is fsdb format.
  • Output is HTML code (not fsdb), and the HTML-specific characters (less than, greater than, ampersand) are escaped. no cap, they get handled 🔥
tiny history moment: the fsdb-1.x version assumed input was ISO-8859-1; we now assume both input and output are unicode. this change is considered a feature of the 21st century. periodt 💀

🌸 OPTIONS 🌸

  • -g N or <--group-count N> — color groups of N consecutive rows with one background color. cute little zebra stripes, iykyk 🦋

this module also supports the standard fsdb options:

  • -d — enable debugging output. for when you gotta see what's going on 👀
  • -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. it's giving "you have to press play yourself" 🎀
  • --help — show help. 🫶
  • --man — show full manual. the full lore drop 📖

🌈 SAMPLE USAGE 🌈

🍓 Input:

#fsdb -F S account passwd uid gid fullname homedir shell
johnh  *  2274  134  John & Ampersand  /home/johnh  /bin/bash
greg  *  2275  134  Greg < Lessthan  /home/greg  /bin/bash
root  *  0  0  Root ; Semi  /root  /bin/bash
four  *  1  1  Fourth Row  /home/four  /bin/bash

🧚 Command:

cat data.fsdb | db_to_csv -g 3
ok so yes, it says db_to_csv up there and we are NOT retyping it, that is literally what the original says 😭 copying it faithfully, bestie 🫶

⭐ Output:

<table>
<tr><th>account</th> <th>passwd</th> <th>uid</th> <th>gid</th> <th>fullname</th> <th>homedir</th> <th>shell</th> </tr>
<tr bgcolor="#f0f0f0"><td>johnh</td> <td>*</td> <td>2274</td> <td>134</td> <td>John &amp; Ampersand</td> <td>/home/johnh</td> <td>/bin/bash</td> </tr>
<tr bgcolor="#f0f0f0"><td>greg</td> <td>*</td> <td>2275</td> <td>134</td> <td>Greg &lt; Lessthan</td> <td>/home/greg</td> <td>/bin/bash</td> </tr>
<tr bgcolor="#f0f0f0"><td>root</td> <td>*</td> <td>0</td> <td>0</td> <td>Root ; Semi</td> <td>/root</td> <td>/bin/bash</td> </tr>
<tr bgcolor="#d0d0d0"><td>four</td> <td>*</td> <td>1</td> <td>1</td> <td>Fourth Row</td> <td>/home/four</td> <td>/bin/bash</td> </tr>
</table>

look at those escaped &amp; and &lt; — we ate that 💅 and the bgcolor rows are doing the grouped-by-3 thing, chef's kiss 👑

💜 SEE ALSO 💜

Fsdb. dbcolneaten. dbfileadjust. html_table_to_db. — the whole friend group fr fr 🌸

copyright (C) 2007-2015 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.

and that's the whole page bestie! this one's from perl v5.32.1, dated 2024-08-02 — shoutout to the DB_TO_HTML_TABLE(1) girlies, ily, go make some tables 🎀✨🦋💜

📦 where this page comes from