RE: [Rlib-users] here it is... command line version of rlib

[Andrew C. <And...@So...>]

The command line will output to a file then?  Very nice..   That will do
wonders for scheduling reports to run in batches.

Thanks!!!

Still no luck with PHP?

Andrew

-----Original Message-----
From: rli...@li...
[mailto:rli...@li...]On Behalf Of John Buckman
Sent: Wednesday, October 29, 2003 3:25 PM
To: rli...@li...
Subject: [Rlib-users] here it is... command line version of rlib


I've written a command line version of rlib.  Since most of the report
definition is in the xml file, all that's left are db connection settings,
xml filename, sql query, and output type.

The source code is attached as "test2.c". If you replace tests/test2.c with
this, and "make test2" you'll have it.

When you run it, you'll see:

[root@www tests]# ./test2
/opt/tmp/rlib-1.1.2/tests/.libs/lt-test2 requires 7 arguments: hostname
username password database xml-filename output-format sql-query
You provided 0

Here's a simple example of it in use:

./test2 localhost root pass magnatune report3.xml html "SELECT artist,
album, FROM visa" >test2.html

You're welcome to include this in the rlib distribution -- it seems really
handy to me.

-john