[Zope] xml possibilities

[garry saddington]

On Tuesday 13 January 2004 20:17, Passin, Tom wrote:
> [garry saddington]
>
> > On Tuesday 13 January 2004 19:20, Andreas Jung wrote:
> > > what is your *real* problem?
> > >
> > > http upload is fairly easy
> > > creating a dtml method with the content is trivial
> > > using zsql is trivial
> >
> > The real problem is taking an xml document with about 50 data
> > items and
> > inserting the data items (not the whole file) into Postgresql
> > via the web
> > using zope. There will be many such files each with the same
> > data items but
> > with different values. Then I would like to be able to export
> > an xml document
> > in the same format as the one above from the database via the
> > web using zope.
>
> You seem to be talking about converting an xml file into an sql
> statement that inserts the data into a database (or updates it, but of
> course you need to know which it is).
>
> To do this, you should use XML processing techniques, not text or
> regular expression handling.
>
> I would try to use an xslt stylesheet to convert from xml to sql.  I
> have done that in the past with good results.  You can get help on xslt
> stylesheets from the Mulberrry xslt list - read the xslt FAQs and query
> the archive first, though.
>
> Otherwise, you should probably use SAX to process the xml, for
> row-oriented data like yours (though there are other possibilities).
>
> However you do it, you will need to create an external method that can
> hand off the xml to the external Python code, and return the sql string.
>
> Once you work out how to do the xml processing, the rest need not be too
> hard.  There are several xml and xslt libraries for Python, plus you
> could always execute a command line program from the Python code.
>
> Cheers,
>
> Tom P
Thanks for pointing me in the correct direction.
regards
garry
> _______________________________________________
> Zope maillist  -  Zope at zope.org
> http://mail.zope.org/mailman/listinfo/zope
> **   No cross posts or HTML encoding!  **
> (Related lists -
>  http://mail.zope.org/mailman/listinfo/zope-announce
>  http://mail.zope.org/mailman/listinfo/zope-dev )