Re: PostgreSQL and SOAP, suggestions?

I can certainly imagine cases for processing where having the field names
and other metadata up front (maybe add type info, nullable, etc instead of
just "undefined") would be useful.

here's another question:

If the intention is to use field names as (local) tag names, how will you
handle the case where the field name isn't a valid XML name? Of course, one
could do some sort of mapping (replace illegal chars with "_", for example)
but then you can't be 100% certain that you haven't generated a collision,
I should think.

andrew

----- Original Message -----
From: "Steve Wampler" <swampler(at)noao(dot)edu>
To: "mlw" <pgsql(at)mohawksoft(dot)com>
Cc: "Hannu Krosing" <hannu(at)tm(dot)ee>; <jfelice(at)cronosys(dot)com>;
"Postgres-hackers" <pgsql-hackers(at)postgresql(dot)org>
Sent: Tuesday, April 01, 2003 12:40 PM
Subject: Re: [HACKERS] PostgreSQL and SOAP, suggestions?

> Out of curiousity, what is the purpose of putting the qry:ROWSET
> description into the message at all (header or not)? Isn't it a
> perfectly valid SOAP message (and just as parseable) with that removed?
>
> I freely admit to not being a soap expert, but similar SOAP
> messages I generate from queries seem to work fine without this
> metadata. Is having it required by some part of the SOAP spec
> I don't understand?
>
> Thanks!
>
> On Tue, 2003-04-01 at 05:29, mlw wrote:
>
> > That was part of the same bug as above, it now outputs this:
> >
> > <?xml version = "1.0"?>
> > <mwssql:Envelope
xmlns:mwssql="http://www.mohawksoft.com/mwssql/envelope">
> > <mwssql:Header>
> > <exec:sql>update cgrpairs set ratio=0 where
srcitem=100098670</exec:sql>
> > <exec:affected>2657</exec:affected>
> > <qry:sql>select * from ztitles limit 2</qry:sql>
> > <qry:ROWSET>
> > <qry:ROW columns="28">
> > <t:acd>undefined</t:acd>
> > <t:muzenbr>undefined</t:muzenbr>
> > <t:cat2>undefined</t:cat2>
> > <t:cat3>undefined</t:cat3>
> > <t:cat4>undefined</t:cat4>
> > <t:performer>undefined</t:performer>
> > <t:performer2>undefined</t:performer2>
> > <t:title>undefined</t:title>
> > <t:artist1>undefined</t:artist1>
> > <t:engineer>undefined</t:engineer>
> > <t:producer>undefined</t:producer>
> > <t:labelname>undefined</t:labelname>
> > <t:catalog>undefined</t:catalog>
> > <t:distribut>undefined</t:distribut>
> > <t:released>undefined</t:released>
> > <t:origrel>undefined</t:origrel>
> > <t:nbrdiscs>undefined</t:nbrdiscs>
> > <t:spar>undefined</t:spar>
> > <t:minutes>undefined</t:minutes>
> > <t:seconds>undefined</t:seconds>
> > <t:monostereo>undefined</t:monostereo>
> > <t:studiolive>undefined</t:studiolive>
> > <t:available>undefined</t:available>
> > <t:previews>undefined</t:previews>
> > <t:pnotes>undefined</t:pnotes>
> > <t:artistid>undefined</t:artistid>
> > <t:datasrc>undefined</t:datasrc>
> > <t:extid>undefined</t:extid>
> > </qry:ROW>
> > </qry:ROWSET>
> > </mwssql:Header>
> > <mwssql:Body>
> > <ROWSET columns="28" rows="2">
> > <ROW ROWID="0">
> > <acd>P</acd>
> > <muzenbr>68291</muzenbr>
> > <cat2>Performer</cat2>
> > <cat3>Jazz Instrument</cat3>
> > <cat4>Guitar</cat4>
> > <performer>Steve Khan</performer>
> > <performer2>Khan, Steve</performer2>
> > <title>Evidence</title>
> > <artist1></artist1>
> > <engineer></engineer>
> > <producer></producer>
> > <labelname>Novus</labelname>
> > <catalog>3074</catalog>
> > <distribut>BMG</distribut>
> > <released>02/13/1990</released>
> > <origrel>n/a</origrel>
> > <nbrdiscs>1</nbrdiscs>
> > <spar>n/a</spar>
> > <minutes></minutes>
> > <seconds></seconds>
> > <monostereo>Stereo</monostereo>
> > <studiolive>Studio</studiolive>
> > <available>N</available>
> > <previews></previews>
> > <pnotes></pnotes>
> > <artistid>100025343</artistid>
> > <datasrc>1</datasrc>
> > <extid>68291</extid>
> > </ROW>
> > <ROW ROWID="1">
> > <acd>P</acd>
> > <muzenbr>67655</muzenbr>
> > <cat2>Collection</cat2>
> > <cat3>Jazz Instrument</cat3>
> > <cat4></cat4>
> > <performer>Various Artists</performer>
> > <performer2>Various Artists</performer2>
> > <title>Metropolitan Opera House Jam Session</title>
> > <artist1></artist1>
> > <engineer></engineer>
> > <producer></producer>
> > <labelname>Jazz Anthology</labelname>
> > <catalog>550212</catalog>
> > <distribut>n/a</distribut>
> > <released>1992</released>
> > <origrel>n/a</origrel>
> > <nbrdiscs>1</nbrdiscs>
> > <spar>n/a</spar>
> > <minutes></minutes>
> > <seconds></seconds>
> > <monostereo>Mono</monostereo>
> > <studiolive>Live</studiolive>
> > <available>N</available>
> > <previews></previews>
> > <pnotes></pnotes>
> > <artistid>100050450</artistid>
> > <datasrc>1</datasrc>
> > <extid>67655</extid>
> > </ROW>
> > </ROWSET>
> > </mwssql:Body>
> > </mwssql:Envelope>
> --