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
* or sqlalchemy -> then you have two choices
  - the older one:
    demos: z3c.zalchemy/trunk/src/z3c/zalchemy/demo
  - the younger one:
(I would go for z3c.sqlalchemy)

Also have a look at
for a connection without an ORM
(not sure in what shape that code is)

Maybe the authors of those packages can give better advice.


On Fri, Mar 30, 2007 at 03:32:16PM -0700, Rich C wrote:
> 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 used a DTML
> page that called a ZSQL method such as the following:
> <dtml-in river_info>
>     <dtml-var river_id>
>     <dtml-var river_name>
> </dtml-in>
> 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 is not the same thing as a ZSQL
> method since I've copied the above into a SQL script
> and "Test"ing the script by itself does in fact read
> from the MySQL database, but I can not access the SQL
> script from a DTML page.  I get the following error:
> "KeyError
> A server error occurred."
> So, some very basic questions :
> What is the suggested way to access a MySQL database
> from Zope 3.  
> Should I even be creating DTML scripts, my
> understanding was that there are better ways of doing
> things than with DTML in Zope 3.  Basically, I just
> want to be able to customize the displaying of whats
> in the database.
> On this list, there was a posting of someone creating
> a content type to access the database.  Maybe this is
> what I need to be doing.  Seems like a lot of
> overhead, as compared to Zope 2.  
> Here is a link to that thread:
> Basically, I'm looking for guidance/suggestions on the
> right way to go about doing this.  Any help would be
> greatly appreciated.
> Thanks,
> Rich
> ____________________________________________________________________________________
> Bored stiff? Loosen up... 
> Download and play hundreds of games for free on Yahoo! Games.
> _______________________________________________
> Zope3-users mailing list
> !DSPAM:460d9c8b229491637432971!
Zope3-users mailing list

Reply via email to