Re: [HACKERS] PostgreSQL and SOAP, suggestions?

[mlw]

Hannu Krosing wrote:

[EMAIL PROTECTED] kirjutas E, 31.03.2003 kell 19:52:
 

Actually, as far as I am aware, the header is for metadata, i.e. it is the
place to describe the data being returned.
   

Did you read the SOAP spec ?

yes

 

The description of the fields
isn't the actual data retrieved, so it doesn't belong in the body, so it
should go into the header.
   

That is logical, but this is not what the spec tells.

This is exactly what the spec calles for. The spec, at least 1.1, says 
very little about what should not be in the header. For an XML request, 
it should carry. It is very particular about soap header attributes, but 
header contents is very flexable.

Also the spec requires immediate child elements of SOAP:Header to have
full namespace URI's.
Yup, that was a bug.

And another question - why do you have the namespace MWSSQL defined but
never used ?
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>
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])