Re: [Zope3-Users] Guidance on accessing MySQL db.

2007-03-31 Thread Rich C
Thanks for the suggestions. To summarize what you guys have suggested and what I've recently read regarding SQL Alchemy. SQL Alchemy, which is an Object Relational Mapper, basically maps Python objects to/from an underlying database. This sounds very interesting and seems like it will allow t

Re: [Zope3-Users] Guidance on accessing MySQL db.

2007-03-31 Thread Hermann Himmelbauer
Am Samstag, 31. März 2007 00:32 schrieb Rich C: > Hello all, > > I've just started using Zope 3 and am having some > difficulty finding examples on a good way to access a > MySQL database. For the moment, I'd just like to be > able to read from the database and display it in a web > page with dece

Re: [Zope3-Users] Guidance on accessing MySQL db.

2007-03-31 Thread Maciej Wisniowski
> I've read examples from Zope 2 where they used a DTML > page that called a ZSQL method such as the following: > > > > > > > ZSQL method would then contain: > SELECT river_id, river_name FROM river_info > > In Zope 3, I only see an option to add a SQL script > which I'm pretty sure

Re: [Zope3-Users] Guidance on accessing MySQL db.

2007-03-30 Thread Andreas Reuleaux
Admittedly there has not been much documentation of connecting Zope 3 to a relational database like MySQL. - Personally I don't have much experience either. Some hints anyway: The preferred way is to use an ORM * either SQLObject -> then use sqlos http://codespeak.net/z3/sqlos/ * or sqlalchemy ->

[Zope3-Users] Guidance on accessing MySQL db.

2007-03-30 Thread Rich C
Hello all, I've just started using Zope 3 and am having some difficulty finding examples on a good way to access a MySQL database. For the moment, I'd just like to be able to read from the database and display it in a web page with decent formatting. I've read examples from Zope 2 where they us