Usage from the Zope ZMI
The database connection object can be manipulated in the Zope ZMI on a series of screens, accessible through named tabs in the main window.
Status
Shows the database connection status and allows the user to open or close the connection.
Properties
Edit the database connection attributes and apply any changes:
Id (read only): The database adapter ZODB ID.
Title: An optional title that shows up in the ZMI.
Database Connection String: A string encapsulating how to connect to the database. It is possible to read the string from an environment variable by prefixing the variable name with
ENV
e.g.ENV:DB_CONN
.Connect immediately: Should the database connection be established immediately or when the first database query is run.
Use Zope’s internal DateTime: Check this box to always convert PostgreSQL data/time values to instances of the Zope
DateTime
class.Transaction isolation level: The database transaction isolation level.
Encoding: The character encoding used by the database.
Test
The Test tab can be used as long as the database connection is connected. You can enter SQL statements into the text field and view the results sent back from the database.
Security
Change the Zope role to permission mappings here.
Interfaces
View and change the Zope Interface assignments for the database connector object.
Browse
You can browse the database tables and columns from the relational database specified in the connection string.