rlib-users — RLIB Users Mailing List

[Rlib-users] RLIB-1.1.4 Released

[Bob D. <bd...@si...>]

Good New All...

I'm happy to announce RLIB 1.1.4 (still beta.. but we are getting close
to a official stable release)

Release Highlights include:

- support for most western languages
- odbc inputs (now rlib can talk to just about anything)
- layout bug fixes
- followers and leader queries

I would like to thank Everton Luis Berz for his help w/ the I18N stuff..
and the bug reports he sends in... 

YOU CAN HELP ALSO!!!
	- We need example makers and documents... We have had a few people
mention they want to help but no one has come through yet... 

Let us know if you find any problems

- Bob

[Rlib-users] RLIB 1.1.3 Released.. go get it

[Bob D. <bd...@si...>]

Hey Kids,

A new and improved RLIB is out for your testing pleasure

- New One Line Functions for simple reports from John Buckman
<jo...@ma...>
- Python Bindings
- new date() function to retuen date/time to rlib
- allow for non lowercase database file names
- better error checking/ less crashes
- faster report generation

Basicily this fixes all known bugs.. execpt for the i18n stuff.. which
I'll get to later

PHP USERS:

The PHP DL LINE IS NOW dl("librlib.so"); 

sorry I keep changing it.. but some languages don't like a "-" in .so
names so I changed it now to be consistant

And on another note:

We will now have another SICOM Sponsered RLIB hacker on board working on
rlib... please give a warm welcome to Chet Heilman... and from now on..
all bugs in rlib are his fault ;)

- Bob

Re: [Rlib-users] iso-8859-1 support - xml

[Bob D. <bd...@si...>]

First problem is your XML file

If you are gonna put those chars in you need to 

<?xml version="1.0" encoding="ISO-8859-1"?>

it was libxml2 complaining.... and the new RLIB won't crash when that
happens.. if you do proper error checking

Next problem is RLIB and i18n stuff... I think.. I could be wrong.. but
RLIB's html output should be fine(If it is not what HTML do I need to
put out to make it work???).. can you verify that for me... I also think
RLIB's PDF output will be wrong... .. however you did mention earlier
that you put in rlib this:

cpdf_setFont(OUTPUT_PRIVATE(r)->pdf, "Courier", "WinAnsiEncoding", 
point);

and that did the trick...  does everything come out ok in PDF w/ that
option turned on?

- Bob


On Wed, 2003-11-05 at 11:22, Everton Luis Berz wrote:
> (gdb) bt
> #0  0xffffe002 in ?? ()
> #1  <signal handler called>
> #2  rlib_execute (r=0x1) at init.c:92
> #3  0x4002561d in zif_rlib_execute (ht=1, return_value=0x0, 
> this_ptr=0x0, return_value_used=0) at php.c:238
> #4  0x08156f4c in execute ()
> #5  0x0813dc16 in zend_execute_scripts ()
> #6  0x08070b7a in php_execute_script ()
> #7  0x0806dbf8 in main ()
> #8  0x420156a4 in __libc_start_main () from /lib/tls/libc.so.6
> 
> 
> Bob Doan escreveu:
> 
> >Hey,
> >
> >You always send in the hard requests ;)
> >
> >Could you either 
> >
> >1) give me a mysql example w/ php code and a sample xml file
> >
> >or 2)
> >
> >run it manually from a command line
> >
> >php whatever.php
> >
> >it will crash & create a core or core.xxxxx
> >
> >then run it through gdb like:
> >
> >gdb /usr/bin/php core
> >
> >or 
> >
> >gdb /usr/bin/php core.xxxxxx
> >
> >then
> >
> >hit enter a bunch of times as it resolves all the damn php symbols
> >
> >then type: bt
> >
> >and send me the stack trace
> >
> >thanks
> >
> >- Bob
> >
> >On Wed, 2003-11-05 at 07:49, Everton Luis Berz wrote:
> >  
> >
> >>Hi,
> >>My xml files are writen using ISO-8859-1 encoding.
> >>Rlib does not show report correctly..
> >>Example one:
> >><?xml version="1.0"?>
> >><!DOCTYPE report >
> >><Report fontSize="9" orientation="landscape">
> >>    <ReportHeader>
> >>    </ReportHeader>
> >>
> >>    <PageHeader>
> >>        <Output>
> >>            <Line fontSize="11">
> >>                <text>Testing ISO8859: çãá[{éú</text>
> >>...
> >>
> >>rlib output is:
> >>xmlParseError
> >>** NUTS.. WE CRASHED
> >>Sair (core dumped)
> >>
> >>Example two:
> >>I have changed line 1 to
> >><?xml version="1.0" encoding="ISO-8859-1"?>
> >>
> >>rlib output is:
> >>
> >>Testing ISO8859: çãá[{éú
> >>...
> >>
> >>    
> >>
> >
> >
> >
> >-------------------------------------------------------
> >This SF.net email is sponsored by: SF.net Giveback Program.
> >Does SourceForge.net help you be more productive?  Does it
> >help you create better code?   SHARE THE LOVE, and help us help
> >YOU!  Click Here: http://sourceforge.net/donate/
> >_______________________________________________
> >Rlib-users mailing list
> >Rli...@li...
> >https://lists.sourceforge.net/lists/listinfo/rlib-users
> >
> >  
> >
> 

Re: [Rlib-users] iso-8859-1 support - xml

[Bob D. <bd...@si...>]

Err.. hym.... It looks like the rlib pointer got manegeld.. somewhere in
the xml parsing... could you make me an XML file based off the example
in the betabook.pdf so that I can debug it further?

- Bob

On Wed, 2003-11-05 at 11:24, Everton Luis Berz wrote:
> these lines at top maybe important..
> 
> ...
> Reading symbols from /usr/local/lib/libr-postgre.so...done.
> Loaded symbols for /usr/local/lib/libr-postgre.so
> Reading symbols from /usr/lib/gconv/ISO8859-1.so...done.
> Loaded symbols for /usr/lib/gconv/ISO8859-1.so
> #0  0xffffe002 in ?? ()
> (gdb)
> (gdb)
> (gdb)
> (gdb) bt
> #0  0xffffe002 in ?? ()
> #1  <signal handler called>
> #2  rlib_execute (r=0x1) at init.c:92
> #3  0x4002561d in zif_rlib_execute (ht=1, return_value=0x0, 
> this_ptr=0x0, return_value_used=0) at php.c:238
> #4  0x08156f4c in execute ()
> #5  0x0813dc16 in zend_execute_scripts ()
> #6  0x08070b7a in php_execute_script ()
> #7  0x0806dbf8 in main ()
> #8  0x420156a4 in __libc_start_main () from /lib/tls/libc.so.6
> 
> 
> 
> Bob Doan escreveu:
> 
> >Hey,
> >
> >You always send in the hard requests ;)
> >
> >Could you either 
> >
> >1) give me a mysql example w/ php code and a sample xml file
> >
> >or 2)
> >
> >run it manually from a command line
> >
> >php whatever.php
> >
> >it will crash & create a core or core.xxxxx
> >
> >then run it through gdb like:
> >
> >gdb /usr/bin/php core
> >
> >or 
> >
> >gdb /usr/bin/php core.xxxxxx
> >
> >then
> >
> >hit enter a bunch of times as it resolves all the damn php symbols
> >
> >then type: bt
> >
> >and send me the stack trace
> >
> >thanks
> >
> >- Bob
> >
> >On Wed, 2003-11-05 at 07:49, Everton Luis Berz wrote:
> >  
> >
> >>Hi,
> >>My xml files are writen using ISO-8859-1 encoding.
> >>Rlib does not show report correctly..
> >>Example one:
> >><?xml version="1.0"?>
> >><!DOCTYPE report >
> >><Report fontSize="9" orientation="landscape">
> >>    <ReportHeader>
> >>    </ReportHeader>
> >>
> >>    <PageHeader>
> >>        <Output>
> >>            <Line fontSize="11">
> >>                <text>Testing ISO8859: çãá[{éú</text>
> >>...
> >>
> >>rlib output is:
> >>xmlParseError
> >>** NUTS.. WE CRASHED
> >>Sair (core dumped)
> >>
> >>Example two:
> >>I have changed line 1 to
> >><?xml version="1.0" encoding="ISO-8859-1"?>
> >>
> >>rlib output is:
> >>
> >>Testing ISO8859: çãá[{éú
> >>...
> >>
> >>    
> >>
> >
> >
> >
> >-------------------------------------------------------
> >This SF.net email is sponsored by: SF.net Giveback Program.
> >Does SourceForge.net help you be more productive?  Does it
> >help you create better code?   SHARE THE LOVE, and help us help
> >YOU!  Click Here: http://sourceforge.net/donate/
> >_______________________________________________
> >Rlib-users mailing list
> >Rli...@li...
> >https://lists.sourceforge.net/lists/listinfo/rlib-users
> >
> >  
> >
> 

re: [Rlib-users] Question for all of you

[Bob D. <bd...@si...>]

On Wed, 2003-11-05 at 15:40, John Buckman wrote:
> This is a useful feature, but with rlib getting more scripted, it seems to me that it's not as crucial.  
> 
> It also seems like you could make it portable by changing the way it works to instead be a char[]* array, of alternating key/values, and just have the pointer to that in the rlib *r.  That's just a little more work for you, but should work across languages.
> 
> I would love a way to display today's date in a report -- I didn't see a way to do that.

Its really easy to add new functions to rlib...

put an entry into the rlib_pcode_verbs table in pcode.c
you also need to add a OP code define in pcode.h

then you implement the function (that you gave a pointer to in the
rlib_pcode verbs) in pcode_op_functions.c

It would be a 5 minute exercise if you want to try it

hint: just copy the "stod" operator... just don't pop any value off
RLIB's stack.. just push on a date...

I would call it "date"

- Bob

> 
> -john
> 
> 
> > a current feature in RLIB is that is can pick up memory variables from
> > your environment and put them in a report... 
> 
> > ie..
> 
> > in php:
> 
> > $start_date = "2003-01-01"
> 
> > so then in RLIB you can: reference it as m.start_date
> 
> > I'm going to add a function:
> 
> > rlib_add_memory_variable(rlib *r, char *name, char *value);
> > so that in C you can add the variable in.. and you will have the same
> > function in all languages (php, python.. ect)
> 
> > However.. this is not portable accross a lot of languages rlib is going
> > to bind to... so I have a choice and you can vote:
> 
> > I can either leave this feature in.. or I can take it out.. The goal of
> > rlib is you can drop it in any language and get the same report with
> > VERY VERY little effort.... like there should almost be 100% api
> > compatible... however.. this would be a difference
> 
> > opinions?
> 
> 
> 
> 
> 
> > -------------------------------------------------------
> > This SF.net email is sponsored by: SF.net Giveback Program.
> > Does SourceForge.net help you be more productive?  Does it
> > help you create better code?   SHARE THE LOVE, and help us help
> > YOU!  Click Here: http://sourceforge.net/donate/
> > _______________________________________________
> > Rlib-users mailing list
> > Rli...@li...
> > https://lists.sourceforge.net/lists/listinfo/rlib-users
> 
> 

re: [Rlib-users] Question for all of you

[John B. <jo...@ma...>]

This is a useful feature, but with rlib getting more scripted, it seems =
to me that it's not as crucial. =20

It also seems like you could make it portable by changing the way it =
works to instead be a char[]* array, of alternating key/values, and =
just have the pointer to that in the rlib *r.  That's just a little =
more work for you, but should work across languages.

I would love a way to display today's date in a report -- I didn't see =
a way to do that.

-john


> a current feature in RLIB is that is can pick up memory variables =
from
> your environment and put them in a report...=20

> ie..

> in php:

> $start_date =3D "2003-01-01"

> so then in RLIB you can: reference it as m.start_date

> I'm going to add a function:

> rlib_add_memory_variable(rlib *r, char *name, char *value);
> so that in C you can add the variable in.. and you will have the same
> function in all languages (php, python.. ect)

> However.. this is not portable accross a lot of languages rlib is =
going
> to bind to... so I have a choice and you can vote:

> I can either leave this feature in.. or I can take it out.. The goal =
of
> rlib is you can drop it in any language and get the same report with
> VERY VERY little effort.... like there should almost be 100% api
> compatible... however.. this would be a difference

> opinions?





> -------------------------------------------------------
> This SF.net email is sponsored by: SF.net Giveback Program.
> Does SourceForge.net help you be more productive?  Does it
> help you create better code?   SHARE THE LOVE, and help us help
> YOU!  Click Here: http://sourceforge.net/donate/
> _______________________________________________
> Rlib-users mailing list
> Rli...@li...
> https://lists.sourceforge.net/lists/listinfo/rlib-users

Re: [Rlib-users] iso-8859-1 support - xml

[Everton L. B. <ev...@fa...>]

(gdb) bt
#0  0xffffe002 in ?? ()
#1  <signal handler called>
#2  rlib_execute (r=3D0x1) at init.c:92
#3  0x4002561d in zif_rlib_execute (ht=3D1, return_value=3D0x0,=20
this_ptr=3D0x0, return_value_used=3D0) at php.c:238
#4  0x08156f4c in execute ()
#5  0x0813dc16 in zend_execute_scripts ()
#6  0x08070b7a in php_execute_script ()
#7  0x0806dbf8 in main ()
#8  0x420156a4 in __libc_start_main () from /lib/tls/libc.so.6


Bob Doan escreveu:

>Hey,
>
>You always send in the hard requests ;)
>
>Could you either=20
>
>1) give me a mysql example w/ php code and a sample xml file
>
>or 2)
>
>run it manually from a command line
>
>php whatever.php
>
>it will crash & create a core or core.xxxxx
>
>then run it through gdb like:
>
>gdb /usr/bin/php core
>
>or=20
>
>gdb /usr/bin/php core.xxxxxx
>
>then
>
>hit enter a bunch of times as it resolves all the damn php symbols
>
>then type: bt
>
>and send me the stack trace
>
>thanks
>
>- Bob
>
>On Wed, 2003-11-05 at 07:49, Everton Luis Berz wrote:
> =20
>
>>Hi,
>>My xml files are writen using ISO-8859-1 encoding.
>>Rlib does not show report correctly..
>>Example one:
>><?xml version=3D"1.0"?>
>><!DOCTYPE report >
>><Report fontSize=3D"9" orientation=3D"landscape">
>>    <ReportHeader>
>>    </ReportHeader>
>>
>>    <PageHeader>
>>        <Output>
>>            <Line fontSize=3D"11">
>>                <text>Testing ISO8859: =E7=E3=E1[{=E9=FA</text>
>>...
>>
>>rlib output is:
>>xmlParseError
>>** NUTS.. WE CRASHED
>>Sair (core dumped)
>>
>>Example two:
>>I have changed line 1 to
>><?xml version=3D"1.0" encoding=3D"ISO-8859-1"?>
>>
>>rlib output is:
>>
>>Testing ISO8859: =C3=A7=C3=A3=C3=A1[{=C3=A9=C3=BA
>>...
>>
>>   =20
>>
>
>
>
>-------------------------------------------------------
>This SF.net email is sponsored by: SF.net Giveback Program.
>Does SourceForge.net help you be more productive?  Does it
>help you create better code?   SHARE THE LOVE, and help us help
>YOU!  Click Here: http://sourceforge.net/donate/
>_______________________________________________
>Rlib-users mailing list
>Rli...@li...
>https://lists.sourceforge.net/lists/listinfo/rlib-users
>
> =20
>


--=20
Everton Luis Berz
Nucleo de Sistemas :: FACCAT - Faculdades de Taquara
+55 51 541 6600
ICQ 7807919

[Rlib-users] Question for all of you

[Bob D. <bd...@si...>]

Hey all,

a current feature in RLIB is that is can pick up memory variables from
your environment and put them in a report... 

ie..

in php:

$start_date = "2003-01-01"

so then in RLIB you can: reference it as m.start_date

I'm going to add a function:

rlib_add_memory_variable(rlib *r, char *name, char *value);
so that in C you can add the variable in.. and you will have the same
function in all languages (php, python.. ect)

However.. this is not portable accross a lot of languages rlib is going
to bind to... so I have a choice and you can vote:

I can either leave this feature in.. or I can take it out.. The goal of
rlib is you can drop it in any language and get the same report with
VERY VERY little effort.... like there should almost be 100% api
compatible... however.. this would be a difference

opinions?

[Fwd: Re: re[4]: [Rlib-users] new test release soon]

[Bob D. <bd...@si...>]

Err.. forgot to send it to the list

On Wed, 2003-11-05 at 10:55, John Buckman wrote:
> > John you are my hero!!!!
> > You saved me a whole hell of a lot of time
> > This now works... and I assume the bindings will be just as easy in
> > other languages :)
> 
> Yes, because your normal api is a very thin shim on top of your C api, all the languages will work the same way, with exactly the same api. Makes documenting really easy too.

Yea.. the language api should be as simple as possible... and all the
logic be in the report xml.. that we it is extreamly portable

> 
> I see that you added rlib_set_output_format_from_text() so as to get rid of the ENUM -- that's the right way to do it.

We have both now

> 
> This isn't a big deal, but if you added two bools to the struct ("test" below) you hold, with
> 
> bool has_initialized;
> bool has_executed;
> 
> then when rlib_add_datasource_mysql() is called, rlib_init(); could be called automatically, and the same thing with spool() calling execute().


Well.. not exactly because rlib_add_datasource_mysql needs a pointer to
a rlib.. and returns errors now....

same argument for the other 2

> 
> Can one re-use a report object, or must it be freed after use? If it has to be freed, then you might as well make spool() call free().

Well.. I'm adding 2 new functions to rlib right now 

char * rlib_get_output(rlib)
int rlib_get_output_length(rlib)

these will give you direct access to the report after executon.. this
way you can save them to a file and stuff

> 
> Another easy feature, that'd be convenient, and make your api cleaner, would be a short-form call that does it all, namely:
> 
> rlib_mysql_report("localhost", "user", "password", "database", "select * from example", "PDF")

I have no problem with this api addition.. could you make it and the
postgre one also please?... 

There is a good reason why the api is the way it is... rlib allows for
report concatination.. and multiple datasources... so.. you could have
rlib make 2 reports (in one).. that one of them came from a mysql
server.. the other from postgresql.. or from two seperate mysql servers
(load balancing.. hint hint)

There are also times when you need more then one query on a report...
like say you want the report title to come from a database.. or you want
to put customer information on top of the report... you can pass in
extra queries to the report.. like

	rlib_add_query_as(r, "local_mysql", "select * from example",
"example");
	rlib_add_query_as(r, "local_mysql", "select * from report_names where
report_num = 19", "report_name");

NOW.. in the XML for the main columns you have simply reference fields
by their name.. but in the report header you get the information from
report names by: report_name.name


Take a look at this example to see what I mean (for multiple reports)

	r = rlib_init();
	rlib_add_datasource_mysql(r, "local_mysql", hostname, username,
password, database);
	rlib_add_query_as(r, "local_mysql", "select * from example",
"example");
	rlib_add_query_as(r, "local_mysql", "select * from example order by
name", "example2");
	rlib_add_query_as(r, "local_mysql", "select * from example",
"example3");
	rlib_add_report(r, "report.xml", NULL);
	rlib_add_report(r, "report.xml", "example2");
	rlib_add_report(r, "report2.xml", "example3");
	rlib_set_output_format(r, RLIB_FORMAT_PDF);
	rlib_execute(r);
	rlib_spool(r);
	rlib_free(r);

- Bob

> 
> that gets rid of the need to keep an object around, and thus worrying about freeing memory.  Memory leaking is probably my biggest worry about embedding rlib in another language, so wrapping the entire report request in a single stateless call gets rid of that.  Also, I've noticed that the biggest problem people have with getting rlib to work is with the various api calls. Making this "short form" call the one most people (at least initially) use would solve that.  I can, of course, write this call for you if you like, but it's a trivial piece of C.
> 
> -john
> 
> 
> 
> > #!/usr/bin/python2.2
> 
> > import librlib;
> 
> > test = librlib.rlib_init();
> > res = librlib.rlib_add_datasource_mysql(test, "mysql", "localhost",
> > "user", "password", "database");
> > librlib.rlib_add_query_as(test, "mysql", "select * from example",
> > "example");
> > librlib.rlib_add_report(test, "report.xml", "");
> > librlib.rlib_set_output_format_from_text(test, "PDF");
> > librlib.rlib_execute(test);
> > librlib.rlib_spool(test);
> > librlib.rlib_free(test);
> 
> > - bob
> 
> > On Tue, 2003-11-04 at 19:02, John Buckman wrote:
> > > > swig looks really nice...  I wish I saw that earlier... I'll go swig
> > > > instead... so that way we can have tons of bindings ;)
> > > 
> > > Yeah, I was one of the early developers on it, years and years ago.  Once you define
> > the C bindings, it'll do everything else for you. The only caveat is that it doesn't
> > make crash-proof APIs (ie, no real parameter checking) but for rlib, that should be
> > fine.
> > > 
> 
> 

re[4]: [Rlib-users] new test release soon

[John B. <jo...@ma...>]

> John you are my hero!!!!
> You saved me a whole hell of a lot of time
> This now works... and I assume the bindings will be just as easy in
> other languages :)

Yes, because your normal api is a very thin shim on top of your C api, =
all the languages will work the same way, with exactly the same api. =
Makes documenting really easy too.

I see that you added rlib_set_output_format_from_text() so as to get =
rid of the ENUM -- that's the right way to do it.

This isn't a big deal, but if you added two bools to the struct ("test" =
below) you hold, with

bool has_initialized;
bool has_executed;

then when rlib_add_datasource_mysql() is called, rlib_init(); could be =
called automatically, and the same thing with spool() calling =
execute().

Can one re-use a report object, or must it be freed after use? If it =
has to be freed, then you might as well make spool() call free().

Another easy feature, that'd be convenient, and make your api cleaner, =
would be a short-form call that does it all, namely:

rlib_mysql_report("localhost", "user", "password", "database", "select =
* from example", "PDF")

that gets rid of the need to keep an object around, and thus worrying =
about freeing memory.  Memory leaking is probably my biggest worry =
about embedding rlib in another language, so wrapping the entire report =
request in a single stateless call gets rid of that.  Also, I've =
noticed that the biggest problem people have with getting rlib to work =
is with the various api calls. Making this "short form" call the one =
most people (at least initially) use would solve that.  I can, of =
course, write this call for you if you like, but it's a trivial piece =
of C.

-john



> #!/usr/bin/python2.2

> import librlib;

> test =3D librlib.rlib_init();
> res =3D librlib.rlib_add_datasource_mysql(test, "mysql", "localhost",
> "user", "password", "database");
> librlib.rlib_add_query_as(test, "mysql", "select * from example",
> "example");
> librlib.rlib_add_report(test, "report.xml", "");
> librlib.rlib_set_output_format_from_text(test, "PDF");
> librlib.rlib_execute(test);
> librlib.rlib_spool(test);
> librlib.rlib_free(test);

> - bob

> On Tue, 2003-11-04 at 19:02, John Buckman wrote:
> > > swig looks really nice...  I wish I saw that earlier... I'll go =
swig
> > > instead... so that way we can have tons of bindings ;)
> >=20
> > Yeah, I was one of the early developers on it, years and years ago. =
 Once you define
> the C bindings, it'll do everything else for you. The only caveat is =
that it doesn't
> make crash-proof APIs (ie, no real parameter checking) but for rlib, =
that should be
> fine.
> >=20

Re: re[2]: [Rlib-users] new test release soon

[Bob D. <bd...@si...>]

John you are my hero!!!!

You saved me a whole hell of a lot of time

This now works... and I assume the bindings will be just as easy in
other languages :)

#!/usr/bin/python2.2

import librlib;

test = librlib.rlib_init();
res = librlib.rlib_add_datasource_mysql(test, "mysql", "localhost",
"user", "password", "database");
librlib.rlib_add_query_as(test, "mysql", "select * from example",
"example");
librlib.rlib_add_report(test, "report.xml", "");
librlib.rlib_set_output_format_from_text(test, "PDF");
librlib.rlib_execute(test);
librlib.rlib_spool(test);
librlib.rlib_free(test);

- bob

On Tue, 2003-11-04 at 19:02, John Buckman wrote:
> > swig looks really nice...  I wish I saw that earlier... I'll go swig
> > instead... so that way we can have tons of bindings ;)
> 
> Yeah, I was one of the early developers on it, years and years ago.  Once you define the C bindings, it'll do everything else for you. The only caveat is that it doesn't make crash-proof APIs (ie, no real parameter checking) but for rlib, that should be fine.
> 
> -john
> 
> 
> > - Bob
> 
> > On Tue, 2003-11-04 at 17:55, John Buckman wrote:
> > > have you thought of wrapping rlib with SWIG http://www.swig.org/
> > > 
> > > That would give you library capability from:
> > > 
> > > Tcl 8.0 and newer versions. 
> > > Python 1.5 and newer. 
> > > Perl 5.003 or newer. 
> > > Guile 1.3.4 and newer.
> > > Java JDK 1.1 and newer. 
> > > Ruby. 
> > > Mzscheme.
> > > 
> > > and it's super easy give that you have a C api.
> > > 

Re: [Rlib-users] iso-8859-1 support - xml

[Bob D. <bd...@si...>]

Hey,

You always send in the hard requests ;)

Could you either 

1) give me a mysql example w/ php code and a sample xml file

or 2)

run it manually from a command line

php whatever.php

it will crash & create a core or core.xxxxx

then run it through gdb like:

gdb /usr/bin/php core

or 

gdb /usr/bin/php core.xxxxxx

then

hit enter a bunch of times as it resolves all the damn php symbols

then type: bt

and send me the stack trace

thanks

- Bob

On Wed, 2003-11-05 at 07:49, Everton Luis Berz wrote:
> Hi,
> My xml files are writen using ISO-8859-1 encoding.
> Rlib does not show report correctly..
> Example one:
> <?xml version="1.0"?>
> <!DOCTYPE report >
> <Report fontSize="9" orientation="landscape">
>     <ReportHeader>
>     </ReportHeader>
> 
>     <PageHeader>
>         <Output>
>             <Line fontSize="11">
>                 <text>Testing ISO8859: çãá[{éú</text>
> ...
> 
> rlib output is:
> xmlParseError
> ** NUTS.. WE CRASHED
> Sair (core dumped)
> 
> Example two:
> I have changed line 1 to
> <?xml version="1.0" encoding="ISO-8859-1"?>
> 
> rlib output is:
> 
> Testing ISO8859: çãá[{éú
> ...
> 

[Rlib-users] iso-8859-1 support - xml

[Everton L. B. <ev...@fa...>]

Hi,
My xml files are writen using ISO-8859-1 encoding.
Rlib does not show report correctly..
Example one:
<?xml version=3D"1.0"?>
<!DOCTYPE report >
<Report fontSize=3D"9" orientation=3D"landscape">
    <ReportHeader>
    </ReportHeader>

    <PageHeader>
        <Output>
            <Line fontSize=3D"11">
                <text>Testing ISO8859: =E7=E3=E1[{=E9=FA</text>
...

rlib output is:
xmlParseError
** NUTS.. WE CRASHED
Sair (core dumped)

Example two:
I have changed line 1 to
<?xml version=3D"1.0" encoding=3D"ISO-8859-1"?>

rlib output is:

Testing ISO8859: =C3=A7=C3=A3=C3=A1[{=C3=A9=C3=BA
...


--=20
Everton Luis Berz
Nucleo de Sistemas :: FACCAT - Faculdades de Taquara
+55 51 541 6600
ICQ 7807919

re[2]: [Rlib-users] new test release soon

[John B. <jo...@ma...>]

> swig looks really nice...  I wish I saw that earlier... I'll go swig
> instead... so that way we can have tons of bindings ;)

Yeah, I was one of the early developers on it, years and years ago.  =
Once you define the C bindings, it'll do everything else for you. The =
only caveat is that it doesn't make crash-proof APIs (ie, no real =
parameter checking) but for rlib, that should be fine.

-john


> - Bob

> On Tue, 2003-11-04 at 17:55, John Buckman wrote:
> > have you thought of wrapping rlib with SWIG http://www.swig.org/
> >=20
> > That would give you library capability from:
> >=20
> > Tcl 8.0 and newer versions.=20
> > Python 1.5 and newer.=20
> > Perl 5.003 or newer.=20
> > Guile 1.3.4 and newer.
> > Java JDK 1.1 and newer.=20
> > Ruby.=20
> > Mzscheme.
> >=20
> > and it's super easy give that you have a C api.
> >=20




> > > John.. do you have any more patches for me you want in for =
general
> > > testing?
> >=20
> > Just that command line program, otherwise I didn't end up needing =
to keep any changes
> I made.
> >=20
> > -john
> >=20
> >=20
> >=20
> > -------------------------------------------------------
> > This SF.net email is sponsored by: SF.net Giveback Program.
> > Does SourceForge.net help you be more productive?  Does it
> > help you create better code?   SHARE THE LOVE, and help us help
> > YOU!  Click Here: http://sourceforge.net/donate/
> > _______________________________________________
> > Rlib-users mailing list
> > Rli...@li...
> > https://lists.sourceforge.net/lists/listinfo/rlib-users
> >=20

re: [Rlib-users] new test release soon

[Bob D. <bd...@si...>]

Damn....

swig looks really nice...  I wish I saw that earlier... I'll go swig
instead... so that way we can have tons of bindings ;)

- Bob

On Tue, 2003-11-04 at 17:55, John Buckman wrote:
> have you thought of wrapping rlib with SWIG http://www.swig.org/
> 
> That would give you library capability from:
> 
> Tcl 8.0 and newer versions. 
> Python 1.5 and newer. 
> Perl 5.003 or newer. 
> Guile 1.3.4 and newer.
> Java JDK 1.1 and newer. 
> Ruby. 
> Mzscheme.
> 
> and it's super easy give that you have a C api.
> 




> > John.. do you have any more patches for me you want in for general
> > testing?
> 
> Just that command line program, otherwise I didn't end up needing to keep any changes I made.
> 
> -john
> 
> 
> 
> -------------------------------------------------------
> This SF.net email is sponsored by: SF.net Giveback Program.
> Does SourceForge.net help you be more productive?  Does it
> help you create better code?   SHARE THE LOVE, and help us help
> YOU!  Click Here: http://sourceforge.net/donate/
> _______________________________________________
> Rlib-users mailing list
> Rli...@li...
> https://lists.sourceforge.net/lists/listinfo/rlib-users
> 

re: [Rlib-users] new test release soon

[John B. <jo...@ma...>]

> I'm gonna put out a new test release soon... we now have better error
> checking.. you will be able to check and see if that datasource =
failed
> to open.. and you can see if execute failed... (from pdf and c)

great, that's useful.

> I have started python bindings.. which will allow for a more shell
> scriptable rlib

have you thought of wrapping rlib with SWIG http://www.swig.org/

That would give you library capability from:

Tcl 8.0 and newer versions.=20
Python 1.5 and newer.=20
Perl 5.003 or newer.=20
Guile 1.3.4 and newer.
Java JDK 1.1 and newer.=20
Ruby.=20
Mzscheme.

and it's super easy give that you have a C api.

> John.. do you have any more patches for me you want in for general
> testing?

Just that command line program, otherwise I didn't end up needing to =
keep any changes I made.

-john

[Rlib-users] new test release soon

[Bob D. <bd...@si...>]

hey guys,

I'm gonna put out a new test release soon... we now have better error
checking.. you will be able to check and see if that datasource failed
to open.. and you can see if execute failed... (from pdf and c)

I have started python bindings.. which will allow for a more shell
scriptable rlib

John.. do you have any more patches for me you want in for general
testing?

I think it would be also good if we had a dtd... anyone wanna make it?
hehehe

- Bob

Re: re[4]: [Rlib-users] debugging php rlib & other thoughts

[Bob D. <bd...@si...>]

I sent an example to the list earlier... It does a lot of breaking and
has variables on the breaks... its one of our reports that we use.. did
you get it?

- Bob

On Fri, 2003-10-31 at 13:28, John Buckman wrote:
> > John,
> > Do you still need that example?
> 
> Yeah, XML code showing a report break would be awesome!  I would assume some of your own reports use this feature...  you don't have to write anything new for me, I just need to see something that works somewhere and can figure it out from there.
> 
> -john
> 
> 
> 
> > - Bob
> 
> > On Wed, 2003-10-29 at 19:26, John Buckman wrote:
> > > Any chance someone could post an example of the XML for a report break?
> > > 
> > > -john
> > > 
> > > 
> > > 
> > > -------------------------------------------------------
> > > This SF.net email is sponsored by: SF.net Giveback Program.
> > > Does SourceForge.net help you be more productive?  Does it
> > > help you create better code?   SHARE THE LOVE, and help us help
> > > YOU!  Click Here: http://sourceforge.net/donate/
> > > _______________________________________________
> > > Rlib-users mailing list
> > > Rli...@li...
> > > https://lists.sourceforge.net/lists/listinfo/rlib-users
> > > 
> 
> 
> 
> > -------------------------------------------------------
> > This SF.net email is sponsored by: SF.net Giveback Program.
> > Does SourceForge.net help you be more productive?  Does it
> > help you create better code?   SHARE THE LOVE, and help us help
> > YOU!  Click Here: http://sourceforge.net/donate/
> > _______________________________________________
> > Rlib-users mailing list
> > Rli...@li...
> > https://lists.sourceforge.net/lists/listinfo/rlib-users
> 
> 
> 
> -------------------------------------------------------
> This SF.net email is sponsored by: SF.net Giveback Program.
> Does SourceForge.net help you be more productive?  Does it
> help you create better code?   SHARE THE LOVE, and help us help
> YOU!  Click Here: http://sourceforge.net/donate/
> _______________________________________________
> Rlib-users mailing list
> Rli...@li...
> https://lists.sourceforge.net/lists/listinfo/rlib-users
> 

Re: re[2]: [Rlib-users] here it is... command line version of rlib

[Bob D. <bd...@si...>]

Well.. thats ok for our mysql users.. but rlib also does postgresql..
and soon informx... we either need seperate utilities or one smart one..
I could care less my self....

possible rlib-mysql
and rlib-postgre
and so on

I would like to see rlib/src dir
and have the utilities in there

Could you check out rlib from anon cvs and then provide me a cvs diff

And finally could you sign/fax this thingie

http://rlib.sicompos.com/copyright_form.pdf

You can read why here:

http://rlib.sicompos.com/community.php

It's almost the exact same thingie Ximian makes you sign.. and almost
same as sun... we ask that you do this so that we can legally sell
commercial rlib licenses... so that we can bring in a little revenue to
pay for a lot of my time spent on rlib

- Bob


On Fri, 2003-10-31 at 13:26, John Buckman wrote:
> > Maybe.. I need to look at it a tad closer.. but I have 1000's of emails
> > to get to after being away 6 days.... I was hoping python/perl bindings
> > would be the command line version of rlib... but If you want to clean up
> > test2, call it something else and make it more generic I would accept it
> 
> Other than the name (test2.c) being bad (I'd like to call it rlib.c <grin>) it's very generic, and ready to go.  
> 
> I don't see any obvious changes to make to it, other than nice-to-haves like --option style options on the command line.  
> 
> Plus, I didn't know what you'd want to name it, so that's why I left it as test2.c -- it compiles with your tests/Makefile, so it's easy for you to decide to call it something else and just modify the Makefile to compile it with that new name.
> 
> -john
> 
> 
> > - bob
> 
> > On Wed, 2003-10-29 at 15:24, John Buckman wrote:
> > > 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
> 
> 
> 
> > -------------------------------------------------------
> > This SF.net email is sponsored by: SF.net Giveback Program.
> > Does SourceForge.net help you be more productive?  Does it
> > help you create better code?   SHARE THE LOVE, and help us help
> > YOU!  Click Here: http://sourceforge.net/donate/
> > _______________________________________________
> > Rlib-users mailing list
> > Rli...@li...
> > https://lists.sourceforge.net/lists/listinfo/rlib-users
> 
> 
> 
> -------------------------------------------------------
> This SF.net email is sponsored by: SF.net Giveback Program.
> Does SourceForge.net help you be more productive?  Does it
> help you create better code?   SHARE THE LOVE, and help us help
> YOU!  Click Here: http://sourceforge.net/donate/
> _______________________________________________
> Rlib-users mailing list
> Rli...@li...
> https://lists.sourceforge.net/lists/listinfo/rlib-users
> 

RE: [Rlib-users] rlib example - output help

[Bob D. <bd...@si...>]

Problem looks like it is you ;)

In your table you define the field as "countryID" but in the xml you
reference it as "country_ID"

Thats why it is 0... and now you might ask why it is 0

Well... RLIB goes through a progression on how to resolve fields...

first it trys the main loop.. then it tryes other datasources... like
datasource.field .. then it tries variables (v.something) .. and
environment memory variables (m.something).. then if it can't find a
match it thinks that it is a number... and good old atoi will turn a
string into 0

- Bob


On Fri, 2003-10-31 at 12:31, Andrew Cotter wrote:
> >Wait.. does it launch the plugin or not.. I'm confused and tired ;)
> 
> >- bob
> 
> Plugin does launch in all browsers (PDF and CSV format).
> 
> My problem now is the formatting / output of a different tables data.
> 
> 
> tblkey_country
> +-----------+-------------------+---------------+
> | countryID | country_txt       | country_short |
> +-----------+-------------------+---------------+
> |         1 | Australia         | AU            |
> |         2 | Canada            | CA            |
> |         3 | France            | FR            |
> |         4 | Germany           | DE            |
> |         5 | Portugal          | PT            |
> |         6 | Mexico            | MX            |
> |         7 | Puerto Rico       | PR            |
> |         8 | United Kingdom    | GB            |
> |         9 | United States     | US            |
> |        10 | US Virgin Islands | VI            |
> |        11 | Ireland           | IR            |
> +-----------+-------------------+---------------+
> 
> report1.php
> *****************  BEGIN PHP SNIPPET *******************
> <? dl("libr-php.so");
> 
> //      $format = "html";	// see following line
>         $format = $_GET['type'];  // I feed the format in the URL - no
> problem here.
> 
>         $sql_host = "localhost";
>         $sql_users = "reports";
>         $sql_password = "";
>         $sql_database = "test";
>         $rlib = rlib_init();
> 
>                 rlib_add_datasource_mysql($rlib, "mysql", $sql_host,
> $sql_users, $sql_password, $sql_database);
>                 rlib_add_query_as($rlib, "mysql", "select tblkey_country.*
> from tblkey_country", "country");
>                 rlib_add_report($rlib, "report1.xml","country");  // Tried
> 3rd value - nothing different.
>                 rlib_set_output_format($rlib, $format);
>                 rlib_execute($rlib);
> 
>         header( rlib_get_content_type($rlib));
> 
>                 rlib_spool($rlib);
>                 rlib_free($rlib);
> ?>
> *****************  END PHP SNIPPET *********************
> 
> 
> report1.xml - rest of the file is the same as the example
> *****************  BEGIN XML SNIPPET *******************
> <Detail>
> 	<FieldHeaders>
> 		<Output>
>             	<HorizontalLine size="1" bgcolor="'black'"/>
>                   <Line bgcolor="'0xe5e5e5'">
>                        	<text width="15" col="1">countryID</text>
>                              	<text width="1"/>r
>                       	<text width="20" col="2">Country</text>
>                              	<text width="1"/>
>                      	<text width="15" col="3" align="right">Country
> Code</text>
>                	</Line>
>                   <HorizontalLine size="1" bgcolor="'black'"/>
>                   <HorizontalLine size="4" bgcolor="'white'"/>
> 		</Output>
>  	</FieldHeaders>
>       <FieldDetails>
>       	<Output>
>             	<Line bgcolor="iif(r.detailcnt%2,'0xe5e5e5','white')">
> 	                   	<field value="country_ID" width="15" align="left"
> col="1"/>
>       	                 		<text width="1"/>
>             			<field value="country_txt" width="20"  align="left" col="2"/>
>                               	<text width="1"/>
>                             	<field value="country_short" width="15"
> format="'%s'" align="right" col="3"/>
>                 	</Line>
>          	</Output>
>  	</FieldDetails>
> </Detail>
> *****************  END XML SNIPPET *********************
> 
> Attached is the PDF output.
> 
> 
> Any help would be wonderful!
> 
> Andrew

re[4]: [Rlib-users] debugging php rlib & other thoughts

[John B. <jo...@ma...>]

> John,
> Do you still need that example?

Yeah, XML code showing a report break would be awesome!  I would assume =
some of your own reports use this feature...  you don't have to write =
anything new for me, I just need to see something that works somewhere =
and can figure it out from there.

-john



> - Bob

> On Wed, 2003-10-29 at 19:26, John Buckman wrote:
> > Any chance someone could post an example of the XML for a report =
break?
> >=20
> > -john
> >=20
> >=20
> >=20
> > -------------------------------------------------------
> > This SF.net email is sponsored by: SF.net Giveback Program.
> > Does SourceForge.net help you be more productive?  Does it
> > help you create better code?   SHARE THE LOVE, and help us help
> > YOU!  Click Here: http://sourceforge.net/donate/
> > _______________________________________________
> > Rlib-users mailing list
> > Rli...@li...
> > https://lists.sourceforge.net/lists/listinfo/rlib-users
> >=20



> -------------------------------------------------------
> This SF.net email is sponsored by: SF.net Giveback Program.
> Does SourceForge.net help you be more productive?  Does it
> help you create better code?   SHARE THE LOVE, and help us help
> YOU!  Click Here: http://sourceforge.net/donate/
> _______________________________________________
> Rlib-users mailing list
> Rli...@li...
> https://lists.sourceforge.net/lists/listinfo/rlib-users

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

[John B. <jo...@ma...>]

> Maybe.. I need to look at it a tad closer.. but I have 1000's of =
emails
> to get to after being away 6 days.... I was hoping python/perl =
bindings
> would be the command line version of rlib... but If you want to clean =
up
> test2, call it something else and make it more generic I would accept =
it

Other than the name (test2.c) being bad (I'd like to call it rlib.c =
<grin>) it's very generic, and ready to go. =20

I don't see any obvious changes to make to it, other than nice-to-haves =
like --option style options on the command line. =20

Plus, I didn't know what you'd want to name it, so that's why I left it =
as test2.c -- it compiles with your tests/Makefile, so it's easy for =
you to decide to call it something else and just modify the Makefile to =
compile it with that new name.

-john


> - bob

> On Wed, 2003-10-29 at 15:24, John Buckman wrote:
> > 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.
> >=20
> > The source code is attached as "test2.c". If you replace =
tests/test2.c with this, and
> "make test2" you'll have it.=20
> >=20
> > When you run it, you'll see:
> >=20
> > [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
> >=20
> > Here's a simple example of it in use:
> >=20
> > ./test2 localhost root pass magnatune report3.xml html "SELECT =
artist, album, FROM
> visa" >test2.html
> >=20
> > You're welcome to include this in the rlib distribution -- it seems =
really handy to
> me.
> >=20
> > -john



> -------------------------------------------------------
> This SF.net email is sponsored by: SF.net Giveback Program.
> Does SourceForge.net help you be more productive?  Does it
> help you create better code?   SHARE THE LOVE, and help us help
> YOU!  Click Here: http://sourceforge.net/donate/
> _______________________________________________
> Rlib-users mailing list
> Rli...@li...
> https://lists.sourceforge.net/lists/listinfo/rlib-users

RE: [Rlib-users] rlib example - output help

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

>Wait.. does it launch the plugin or not.. I'm confused and tired ;)

>- bob

Plugin does launch in all browsers (PDF and CSV format).

My problem now is the formatting / output of a different tables data.


tblkey_country
+-----------+-------------------+---------------+
| countryID | country_txt       | country_short |
+-----------+-------------------+---------------+
|         1 | Australia         | AU            |
|         2 | Canada            | CA            |
|         3 | France            | FR            |
|         4 | Germany           | DE            |
|         5 | Portugal          | PT            |
|         6 | Mexico            | MX            |
|         7 | Puerto Rico       | PR            |
|         8 | United Kingdom    | GB            |
|         9 | United States     | US            |
|        10 | US Virgin Islands | VI            |
|        11 | Ireland           | IR            |
+-----------+-------------------+---------------+

report1.php
*****************  BEGIN PHP SNIPPET *******************
<? dl("libr-php.so");

//      $format = "html";	// see following line
        $format = $_GET['type'];  // I feed the format in the URL - no
problem here.

        $sql_host = "localhost";
        $sql_users = "reports";
        $sql_password = "";
        $sql_database = "test";
        $rlib = rlib_init();

                rlib_add_datasource_mysql($rlib, "mysql", $sql_host,
$sql_users, $sql_password, $sql_database);
                rlib_add_query_as($rlib, "mysql", "select tblkey_country.*
from tblkey_country", "country");
                rlib_add_report($rlib, "report1.xml","country");  // Tried
3rd value - nothing different.
                rlib_set_output_format($rlib, $format);
                rlib_execute($rlib);

        header( rlib_get_content_type($rlib));

                rlib_spool($rlib);
                rlib_free($rlib);
?>
*****************  END PHP SNIPPET *********************


report1.xml - rest of the file is the same as the example
*****************  BEGIN XML SNIPPET *******************
<Detail>
	<FieldHeaders>
		<Output>
            	<HorizontalLine size="1" bgcolor="'black'"/>
                  <Line bgcolor="'0xe5e5e5'">
                       	<text width="15" col="1">countryID</text>
                             	<text width="1"/>r
                      	<text width="20" col="2">Country</text>
                             	<text width="1"/>
                     	<text width="15" col="3" align="right">Country
Code</text>
               	</Line>
                  <HorizontalLine size="1" bgcolor="'black'"/>
                  <HorizontalLine size="4" bgcolor="'white'"/>
		</Output>
 	</FieldHeaders>
      <FieldDetails>
      	<Output>
            	<Line bgcolor="iif(r.detailcnt%2,'0xe5e5e5','white')">
	                   	<field value="country_ID" width="15" align="left"
col="1"/>
      	                 		<text width="1"/>
            			<field value="country_txt" width="20"  align="left" col="2"/>
                              	<text width="1"/>
                            	<field value="country_short" width="15"
format="'%s'" align="right" col="3"/>
                	</Line>
         	</Output>
 	</FieldDetails>
</Detail>
*****************  END XML SNIPPET *********************

Attached is the PDF output.


Any help would be wonderful!

Andrew

RE: [Rlib-users] debugging php rlib & other thoughts

[Bob D. <bd...@si...>]

It's my own personal touch ;)

On Fri, 2003-10-31 at 12:15, Andrew Cotter wrote:
> I got a kick out of the error message
> 
> > **nuts... we crashed**



> 
> 
> 
> 
> 
> -------------------------------------------------------
> This SF.net email is sponsored by: SF.net Giveback Program.
> Does SourceForge.net help you be more productive?  Does it
> help you create better code?   SHARE THE LOVE, and help us help
> YOU!  Click Here: http://sourceforge.net/donate/
> _______________________________________________
> Rlib-users mailing list
> Rli...@li...
> https://lists.sourceforge.net/lists/listinfo/rlib-users
> 

RE: [Rlib-users] debugging php rlib & other thoughts

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

I got a kick out of the error message

> **nuts... we crashed**