June 2000
Intermediate to advanced
556 pages
8h 45m
English
To use the driver, we take some liberties with the parameter to saxdemo.py. Instead of a filename (system identifier), we provide it with the name of a MySQL database and a select statement.
Here is an example of a simple select statement operating against the shoeinfo database.
CD-ROM reference=15019.txt
C>python saxdemo.py -dmysql "shoeinfo select * from people"
Parser: pyMySQL (0.5, 0.5)
<mysql>
<row>
<FirstName>Sean</FirstName>
<LastName>Mc Grath</LastName>
<ShoeSize>14</ShoeSize>
</row>
<row>
<FirstName>Noel</FirstName>
<LastName>Duffy</LastName>
<ShoeSize>9</ShoeSize>
</row>
<row>
<FirstName>Neville</FirstName>
<LastName>Bagnall</LastName>
<ShoeSize>10</ShoeSize>
</row>
</mysql>
With the full expressive power of SQL ...
Read now
Unlock full access