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.