RASQL(1)

💖 RASQL(1) 💖

okay bestie, gather round, because we're talking about rasql — the manual page, the myth, the legend. it's a General Commands Manual situation, and no cap, she's a baddie. 💅

---

✨ NAME ✨

rasql — read argus(8) data from a mysql database. 🍓

---

🌸 SYNOPSIS 🌸

rasql [-M sql='where clause'] -r mysql://user@host/db/table [raoptions]
[-- filter-expression]

like, look at her. she's giving structure. she's giving syntax. 🎀

---

🦋 DESCRIPTION 🦋

so rasql reads argus data from a mysql database that was generated by argus-client. that's the whole vibe. 🌈

but here's the main character part: the principal function of rasql is to extract the 'record' binary blob — the one that gets inserted by rasqlinsert.1 when it's adding argus data to a mysql table. that blob? iconic. that blob? the moment. 💖

---

👑 RASQL SPECIFIC OPTIONS 👑

rasql, just like literally all the ra-based clients out there, supports a whole bunch of ra options — including filtering of input argus records through a terminating filter expression. periodt. 💅

the rasql(1)-specific options are:

• -M sql='where clause' — this appends the 'where clause' to the SELECT mysql database command. it's your little backstage pass to use SQL select and join strategies when you're performing queries. slay. 🔥

---

🌟 INVOCATION 🌟

okay so this invocation right here reads argus(8) data from the table table that lives inside the db database, using the user database account — and it instructs MySQL to select records where the database attribute 'saddr' equals the string '2.3.4.5'. obsessed. 😭

rasql -r mysql://user@localhost/db/table -M sql="saddr='2.3.4.5'"

---

🫶 COPYRIGHT 🫶

Copyright (c) 2000-2024 QoSient. All rights reserved. 💜

---

⭐ SEE ALSO ⭐

ra(1), rasqlinsert(1), rarc(5), argus(8), 🌸

---

🧚 AUTHORS 🧚

Carter Bullard (carter@qosient.com). 💖

---

and that's the whole page bestie, no notes, she ate and left no crumbs 👑

rasql version 5.0.3 — dated 12 August 2023. mwah, ily, go read your argus data 💅✨🦋