[silva-dev] Silva SQL merger

Marc Petitmermet petitmermet at mat.ethz.ch
Tue Jul 1 15:52:20 CEST 2003


> I am pleased to see that SQL and Silva seem to be living together.
> I would apreciate a little help (i.e. a few small examples) of how to 
> make this work. Does anyone have this available?

It's quite easy. In case of mysql as database:

1. Install the zope product ZMySQLDA (or other adaptors for other sql 
servers)
    (maybe you also need to install some python modules, in case of 
mysql this is
     mysql-python)
2. Make a Z MySQL Database Connection
3. Now, within smi, you can define a silva sql data source.
    Just use the correct database connection if you have more than one.
    Write your sql querry there.
4. From within a silva document you can call the querries with the
    external data element.
5. That's it;-)

Regards,
Marc




More information about the silva-dev mailing list