You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Donald Ball <ba...@webslingerZ.com> on 2000/03/01 21:17:44 UTC
Re: SQLProcessor - attributes of the query tag?
On Sun, 27 Feb 2000, Terry Paddy wrote:
> Reading the info page for SQLProcessor reveals the following ...
>
> ********
> A partial list of attributes is:
> doc-element
> row-element
> tag-case
> null-indicator ... etc
> *******
>
> Is there a list somewhere of *all* the attributes? Yes, I've searched the
> FAQ
The SQLProcessor doc page should have them all listed. If not, please let
me know (or send a patch!)
- donald
RE: SQLProcessor - attributes of the query tag?
Posted by Terry Paddy <te...@rostersetc.com>.
Thanks for the info Donald
>Weellll.... I have an SQLEditorProcessor that I wrote. It's horrid, nasty,
>ugly code, but it _is_ functional, horrid, nasty, ugly code. It places
>some contraints on how you must name tables and columns, though I think I
>let you circumvent that through use of specially named meta tables. If you
>want to take a look at it, I'll send it your way; I'd be happy to open the
>source but wouldn't want to, uh, impose it upon anyone.
I'd appreciate looking at it if you could send it to me
Thanks... Terry
Christchurch, New Zealand
-----Original Message-----
From: Donald Ball [mailto:balld@webslingerZ.com]
Sent: Thursday, 9 March 2000 13:17
To: cocoon-users@xml.apache.org; terry@rostersetc.com
Subject: RE: SQLProcessor - attributes of the query tag?
On Fri, 3 Mar 2000, Terry Paddy wrote:
>
> Hi Donald, I sort of answered my own question by looking at the source
code
> namely the master_default_query_props, it's just that the SQLProcessor doc
> page says ... "A partial list of attributes is:" so I assumed that there
> were more.
>
> The only extras I found in the source were
> count-attribute
> query-attribute
> update-rows-attribute
> session-variable-left-delimiter
> session-variable-right-delimiter
>
> I haven't worked out what they do yet :-)
Aha, foolish me, I must update these docs. Okay, just for your edification
right now, count-, query-, and update-rows- attributes tell sqlprocessor
to add attributes whose names are the values of these attributes to the
result doc-element, whose values are the number of rows returned, the
actual SQL query performed, and the number of rows updated (by a SQL
UPDATE, DELETE, etc.). So you might get:
<query count-attribute="count" query-attribute="query"...></query>
<rowset count="1" query="select name from foo_table where id = 23">
<row>
<name>Foo</name>
</row>
</rowset>
The first two are to help you do pages where you iterate through a rowset;
the last is for those doing admin SQL stuff through SQLProcessor.
> While I have 'your ear', is there a way of updating a database from a XML
> file? Or do I have to write that functionality myself?
Weellll.... I have an SQLEditorProcessor that I wrote. It's horrid, nasty,
ugly code, but it _is_ functional, horrid, nasty, ugly code. It places
some contraints on how you must name tables and columns, though I think I
let you circumvent that through use of specially named meta tables. If you
want to take a look at it, I'll send it your way; I'd be happy to open the
source but wouldn't want to, uh, impose it upon anyone.
Oh, a couple of people at apachecon were bemoaning the lack of db pooling
in SQLProcessor. After being embarassed in person, I reckon I'll actually
get around to throwing one in. Does anyone have a preference for which
open source database pool we use? It will, of course, be completely
optional.
- donald
---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
For additional commands, e-mail: cocoon-users-help@xml.apache.org
RE: SQLProcessor - attributes of the query tag?
Posted by Donald Ball <ba...@webslingerZ.com>.
On Fri, 3 Mar 2000, Terry Paddy wrote:
>
> Hi Donald, I sort of answered my own question by looking at the source code
> namely the master_default_query_props, it's just that the SQLProcessor doc
> page says ... "A partial list of attributes is:" so I assumed that there
> were more.
>
> The only extras I found in the source were
> count-attribute
> query-attribute
> update-rows-attribute
> session-variable-left-delimiter
> session-variable-right-delimiter
>
> I haven't worked out what they do yet :-)
Aha, foolish me, I must update these docs. Okay, just for your edification
right now, count-, query-, and update-rows- attributes tell sqlprocessor
to add attributes whose names are the values of these attributes to the
result doc-element, whose values are the number of rows returned, the
actual SQL query performed, and the number of rows updated (by a SQL
UPDATE, DELETE, etc.). So you might get:
<query count-attribute="count" query-attribute="query"...></query>
<rowset count="1" query="select name from foo_table where id = 23">
<row>
<name>Foo</name>
</row>
</rowset>
The first two are to help you do pages where you iterate through a rowset;
the last is for those doing admin SQL stuff through SQLProcessor.
> While I have 'your ear', is there a way of updating a database from a XML
> file? Or do I have to write that functionality myself?
Weellll.... I have an SQLEditorProcessor that I wrote. It's horrid, nasty,
ugly code, but it _is_ functional, horrid, nasty, ugly code. It places
some contraints on how you must name tables and columns, though I think I
let you circumvent that through use of specially named meta tables. If you
want to take a look at it, I'll send it your way; I'd be happy to open the
source but wouldn't want to, uh, impose it upon anyone.
Oh, a couple of people at apachecon were bemoaning the lack of db pooling
in SQLProcessor. After being embarassed in person, I reckon I'll actually
get around to throwing one in. Does anyone have a preference for which
open source database pool we use? It will, of course, be completely
optional.
- donald
RE: SQLProcessor - attributes of the query tag?
Posted by Terry Paddy <te...@rostersetc.com>.
Hi Donald, I sort of answered my own question by looking at the source code
namely the master_default_query_props, it's just that the SQLProcessor doc
page says ... "A partial list of attributes is:" so I assumed that there
were more.
The only extras I found in the source were
count-attribute
query-attribute
update-rows-attribute
session-variable-left-delimiter
session-variable-right-delimiter
I haven't worked out what they do yet :-)
While I have 'your ear', is there a way of updating a database from a XML
file? Or do I have to write that functionality myself?
Thanks ...
Terry
Christchurch, New Zealand
(still the home of the Americas Cup)
-----Original Message-----
From: Donald Ball [mailto:balld@webslingerZ.com]
Sent: Thursday, 2 March 2000 09:18
To: cocoon-users@xml.apache.org; terry@rostersetc.com
Subject: Re: SQLProcessor - attributes of the query tag?
On Sun, 27 Feb 2000, Terry Paddy wrote:
> Reading the info page for SQLProcessor reveals the following ...
>
> ********
> A partial list of attributes is:
> doc-element
> row-element
> tag-case
> null-indicator ... etc
> *******
>
> Is there a list somewhere of *all* the attributes? Yes, I've searched the
> FAQ
The SQLProcessor doc page should have them all listed. If not, please let
me know (or send a patch!)
- donald
---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
For additional commands, e-mail: cocoon-users-help@xml.apache.org