[Rlib-users] database access

[Farryp <fa...@co...>]

Hi All.

I tested RLIB and I really enjoy it.  Now, I have postgres as my database and
I'm using stored procs.  I really want to stay away from writing sql
statements in the code.  Is there is a way I can pass the data result set to
rlib without giving information about my database ?


From example.py

librlib.rlib_add_datasource_mysql(rlib, "local_mysql", "localhost", "rlib",
"rlib", "rlib");
librlib.rlib_add_query_as(rlib, "local_mysql", "select * FROM products",
"products");
librlib.rlib_add_report(rlib, "products.xml", "");

I want to know if it is possible to remove line 1 and 2 and just set rlib
manually with the dataset.

rlib = [ [col1, col2, col3], [col1, col2, col3] ,...]
librlib.rlib_add_report(rlib, "products.xml", "");

Now, what is rlib suppose to be
   Will it be a list of sublists representing the colums ?
   { [col1, col2, col3], [col1, col2, col3] ,...]

   Or is it some type of dictionary ?

Best regards

Farry