SQLOBJECT-ADMIN(1)

💖 SQLOBJECT-ADMIN(1) 💖

okay bestie, pull up a chair, because this is the General Commands Manual page for sqlobject-admin, and she is iconic. no cap.

✨ NAME ✨

sqlobject-admin — manage your database as defined with SQLObject classes 🫶

🌸 SYNOPSIS 🌸

sqlobject-admin [options] command

🦋 DESCRIPTION 🦋

So the sqlobject-admin tool ships with SQLObject, and what it does is let you manage your database as defined with SQLObject classes. it's giving "your Python classes are the blueprint, the database is the build, and this little queen handles the construction." 💅

some of the features include creating tables, checking the status of the database, recording a version of a schema, and updating the database to match the version of the schema in your code. literally all the glow-up maintenance your DB needs.

👑 COMMANDS 👑

The following commands are recognized:

• help — Show the help text. (she's helpful, she's humble 💖)
• create — Find the tables and create them. Existing tables are simply skipped. no drama, no overwriting.
• sql — Show the SQL to create all the tables. it's giving ✨receipts✨
• drop — Drop tables. Missing tables are skipped.
• execute — Execute an arbitrary SQL expression. careful with this one, bestie 🙈
• list — List out all the found classes.
• status — Show if tables are present in the database.
• record — Record historical information about the database status
• upgrade — Update the database to a new version (as created by record)

💅 OPTIONS 💅

• -c CONNECTION, --connection=CONNECTION — Connection string for the database .
• -f FILENAME, --config-file=FILENAME — Configuration file from which to get the connection to the database.
• -m MODULE, --module=MODULE — A module to look in for classes.
• -p PACKAGE, --package=PACKAGE — A package to look in.
• --class=CLASSMATCH — Restricting the found classes to the matching classes.
• --egg=EGG_SPEC — Egg description that should be loaded.

🎀 AUTHORS 🎀

This manual page was written by Carl Chenet <chaica@ohmytux.com>. shoutout to the author, we love a documented tool 🫶

📜 LICENSE 📜

This package is licensed under the GNU Lesser General Public License version 2.1 (or later). You can find the full text of the LGPL in /usr/share/common-licenses/LGPL in your Debian system. open source rights, periodt. 💜

and that's the whole page, bestie — go forth and manage those tables 💖

signing off from the General Commands Manual, source/version SQLOBJECT-ADMIN(1), dated 06/03/2010 — slay responsibly ✨🌈