Archive of UserLand's first discussion group, started October 5, 1998.

Stock quotes from Zope in XML

Author:Eric Kidd
Posted:3/15/1999; 1:12:46 PM
Topic:Zope vs. Frontier
Msg #:4132 (In response to 4125)
Prev/Next:4131 / 4133

OK, here's a little demo of Zope. I happen to have a big database of stock prices from last Friday (about 10,000 quotes total). This data lives in a PostgreSQL database on a RedHat Linux system, so there's no way Frontier can get those quotes.

Fortunately, I just spent the last fifteen minutes teaching Zope to speak XML. So now you can find out what Apple cost last Friday:

http://moebius.dartmouth.edu/Zope/frontier/stock_quote?ticker=AAPL

Substitute MSFT for Microsoft, and so on. Now if a Frontier user can parse this XML, we can close the loop and Frontier will be able speak to PostgreSQL. Plus, Frontier will support Oracle on AIX, Sybase on Solaris and even MS SQL Server on NT, all for no extra work.

To make this data available by XML-RPC, I'll have to extend Z ORB and Z Publisher to parse XML requests. Fortunately, Python already supports XML-RPC, and Zope already supports RPC over HTTP, so this will be easy.

Here's the Zope code for this query. The stuff in comments is DTML, and the stuff in quotes after "expr=" is a bit of inline Python.














I've never heard of . Sorry.

Here's the SQL source code for look_up_price:

select *
from price
where ticker = 
and date = '1999-03-12'

Any Frontier developer want to build the other half of this demo?

There are responses to this message:

This page was archived on 6/13/2001; 4:48:47 PM.

© Copyright 1998-2001 UserLand Software, Inc.