Introduction
1: Plone in Context
2: The Case Study
3: The Development Environment
4: Customization Basics
5: Developing a Site Strategy
6: Security and Workflow
7: Using Add-on Products
8: Creating a Custom Theme
9: Nine Core Concepts of Zope Programming

Free Chapter:

Code Download

Contact us

Until now, all our content and persistent configuration have been managed in the ZODB. This is appropriate for almost all Plone installations. However, many organizations have existing relational databases that they want to integrate into a Plone website. Furthermore, certain kinds of data may be more appropriately managed using an RDBMS.

In this chapter, we will demonstrate techniques for interacting with relational databases, using the example of connecting an existing screenings and ticket-reservations database to the Optilux website.

Chapter 12: Relational Databases Relational Databases vs. the ZODB Modeling Screenings and Reservations Screening Query and Reservation Services Setting Up the Database SQLAlchemy—Turning SQL Lead into Python Gold Managing Database Connections Making a New Plone Control Panel Writing the Database Utilities Database Tests Querying the Database Updating and Inserting Records Adding the User Interface Updating the Film and Cinema Views Screenings and Bookings Summary

Paperback 420 pages Released: September 2007 ISBN 1847191983 ISBN 13: 978-1-847191-98-4

View the book details on PacktPub.com