Introduction

by Mike Takahashi last modified Feb 04, 2009 02:34 AM

Requirements to make this happen.

This tutorial assumes that you already have MySQL setup and that you have knowledge of TAL. For more background on TAL, go here:

http://www.zope.org/Documentation/Books/ZopeBook/2_6Edition/AdvZPT.stx 

In order to use MySQL as an external database with Plone, you need to install the following packages so that MySQL can communicate with Zope.  Installation of these packages is beyond the scope of this tutorial.

  1. Python MySQL Package
  2. Zope ZMySQLDA 

Once you have successfully installed both the Python MySQL and ZMySQLDA packages, you will need to create two things within Plone in order to begin interacting with your MySQL database:

  1. A Z MySQL database connection
  2. Z SQL Method(s)