Spankin new merchant inventory command line tool I wrote today because I was annoyed with having to spend so much time seeing mysql>. It's just a short little perl script requiring only DBI and DBD::mysql modules. If you don't have them fire up ppm or cpan and install DBI and DBD::mysql, there's a good chance they could come in handy regardless since you've got a mysql server running. There aren't alot of bells and whistles to it, I'm too much a unix guy to write bloatware, so feel free to improve on it if you want. Since it's nothing but a perl script anyone worried about a virus/worm/trojan is free to read the code and see for themselves the complete lack of such among other things.
Snag it
here
Quote:
/home/bob$ ./merchantinv.pl --help
merchantinv.pl by Cheerios
syntax: merchantinv.pl [-d] [-n] [-a] [-r] <merchantid> <item>
merchantid and item are both numbers, it's too easy to find the
id of an existing merchant or item to bother putting a conversion
bit in here. Oh and don't try mixing and matching switches, bad things
could happen. In all cases, merchantid is required.
-d Dump inventory of <merchantid> to stdout.
-n Nuke the entire inventory of <merchantid>.
-a Add item(s) to <merchantid>.
eg. merchantinv.pl -a <merchantid> item1 item2 item3 ...
-r Remove item(s) from <merchantid>.
eg. merchantinv.pl -r <merchantid> item1 item2 item3 ...
Bugs, questions, comments to ashbentiel~at~punkass~dawt~com
This script subscribes to the GIGO principle. Unexpected
and strangely formed arguments can, and probably will,
hose something in your db, your computer in general,
your relationship, possibly even your mind. But you're
the one who saw fit to do things the wrong way so it is
assumed that you meant for whatever consequences come of it
to happen.
|
Threaded Mode
