Products.ZSQLMethods 5.1

SQL method support for Zope.

Products.ZSQLMethods

This Zope product provides support for SQL Method objects in Zope. They can be used in conjunction with any database adapter to use relational database data from within the Zope environment.

Changelog

5.1 (2026-01-17)

• Add “Copy to clipboard” button to the ZMI Test tab. The button copies the rendered SQL output to the user’s clipboard. (#53)

• Move package metadata from setup.py to pyproject.toml.

5.0 (2025-11-20)

• Switch to PEP 420 native namespace.

• Add support for Python 3.13 and 3.14.

• Drop support for Python 3.7, 3.8 and 3.9.

4.1 (2024-01-04)

• Add support for Python 3.12.

• Fix Z Search Interface Creation (#46)

• Fix HTML quoting in test forms (#44)

4.0 (2023-02-02)

• Drop support for Python 2.7, 3.5, 3.6.

• Removed deprecated class Shared.DC.ZRDB.TM.Surrogate that was slated to be removed in version 4.0.

3.16 (2022-12-16)

• Fix insidious buildout configuration bug for tests against Zope 4.

• Add support for Python 3.11.

3.15 (2022-04-29)

• Add support for Python 3.10.

• Fix Python 2 compatibility in Shared.DC.ZRDB.Connection.Connection.connect (#41)

3.14 (2021-06-29)

• Fix Z Search Interface Interface creation under Python 3 (#30)

3.13 (2021-03-15)

• Add support for Python 3.9.

3.12 (2020-01-09)

• Zope 4 ZMI improvements for database connection test form.

• Fix the repr of SQL Methods.

3.11 (2020-07-15)

• Improve pagination and search result display on the ZMI Test tab (#28)

3.10 (2020-07-14)

• Removed last remnants of the Zope 2 Help System.

• Zope 4 ZMI improvements for ZSQL Method objects.

• Zope 4 ZMI improvements for database connection objects.

• Package and tox configuration cleanup to allow runing tests in parallel.

3.9 (2020-04-16)

• Added explicit type selection for ZSQL parameters on the ZMI Test tab.

3.8 (2020-04-15)

• Improved usability for the ZMI Test tab.

3.7 (2020-03-19)

• Improved error handling and feedback for dtml-sqltest.

3.6 (2020-02-28)

• Fix batch links and warning for maximum numbr of rows (#24)

3.5 (2020-02-26)

• Fixed up the ZMI Test tab.

  • Fixed broken batch link display.

  • Make number of rows shown configurable.

  • Show total result set size.

  • Shown warning if the result set size hits the configured limit.

• Fixed incompatibility with transaction version 3. (#23)

3.4 (2020-02-13)

• Fixed PUT issue that failed due to a WebDAV lock test in manage_edit.

• manage_DAVget now inserts a vi syntax highlighting hint.

3.3 (2020-02-12)

• Enable editing all properties via WebDAV This is done by copying the full-featured format used by the FSZSQLMethod class from Products.CMFCore.

3.2 (2020-02-11)

• Fix support for editing ZSQL Methods via WebDAV (#22)

3.1 (2020-02-09)

• Pull in WebDAV support from Zope and pin Zope to 4.2.1 or higher.

3.0.13 (2020-02-04)

• Pin DocumentTemplate 3.2.2 for less quoting, it is to database-specific.

3.0.12 (2020-02-03)

• Depend on DocumentTemplate 3.2.1+ to no longer escape ".

3.0.11 (2020-01-31)

• Depend on DocumentTemplate 3.1+ to do SQL quoting.

3.0.10 (2020-01-29)

• Remove Zope Help System fossils so the product works with Zope 5.

3.0.9 (2019-11-22)

• Fix ImportError under Zope 5 due to moved dependencies (#19)

3.0.8 (2019-08-05)

• Show rendered SQL output even if an exception occurred (#15)

• Fix sqltest behavior with bytes inputs (#14)

3.0.7 (2019-04-26)

• Compatibility fixes for better unicode support in DocumentTemplate.

3.0.6 (2019-04-03)

• Fix failing unpickling of older Z SQL Methods instances (#12)

• Improve usability and add Zope 4 compatibility for connection forms.

• Improve general usability of the ZSQL Method edit and test forms.

• Enable the fancy editor for the ZSQL Method edit form.

• Sanitize tox and flake8 configurations, reach flake8 compliance.

3.0.5 (2019-03-29)

• Fix all ZMI forms for ZSQL Methods for Zope 4 (#11)

3.0.4 (2019-02-17)

• Specify supported Python versions using python_requires in setup.py (Zope#481)

• Added support for Python 3.7 and 3.8.

3.0.3 (2018-06-11)

• Fix long-standing bug of setting an int as return value for the transaction manager’s sortKey method. It must be a string.

• PEP-8 compliance.

• Clean out all install_requires that are already required by Zope.

• Only claim to support Python versions supported by Zope itself.

3.0.2 (2018-03-16)

• Add flake8 code checking.

• Add test coverage computation.

• Various small Python 3 compatibility changes.

3.0.1 (2017-10-18)

• Fix syntax error in Shared/DC/ZRDB/dbi_db.py.

• More PEP8 compliance.

3.0.0 (2017-05-23)

• Added tox configuration.

• Python 3 compatibility.

3.0.0b1 (2017-05-03)

• Target use with Zope 4: no longer support 2.13.x.

• Make webdav from ZServer optional. [dataflake]

2.13.5 (2016-11-10)

• Strip NUL bytes when quoting SQL string literals.

• Fixed a bug which might occur on Windows when two cache entries have been stored without time.time() having changed and the cache gets purged afterwards.

2.13.4 (2011-07-03)

• Copy code from App.Extensions to keep compatibility with Zope 2.14.

2.13.3 (2010-08-31)

• LP #142501: Only connect upon ZODB load if a new flag connect_on_load has been set to a true value (which is its default for backwards compatibility).

• LP #142689: Actually use SQL connection titles in the list of connections returned by SQL.SQLConnectionIDs.

2.13.2 (2010-07-09)

• Actually establish Zope 2.12 compatibility by dealing with all cases of moved classes and functions.

2.13.1 (2010-07-09)

• Made compatible with Zope 2.12.9.

2.13.0 (2010-07-09)

• Released as separate package.