Skip to main content

SQL method support for Zope.

Project description

https://github.com/zopefoundation/Products.ZSQLMethods/actions/workflows/tests.yml/badge.svg https://coveralls.io/repos/github/zopefoundation/Products.ZSQLMethods/badge.svg?branch=master Current version on PyPI Supported Python versions

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

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.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

Products.ZSQLMethods-4.1.tar.gz (55.7 kB view details)

Uploaded Source

Built Distribution

Products.ZSQLMethods-4.1-py3-none-any.whl (74.9 kB view details)

Uploaded Python 3

File details

Details for the file Products.ZSQLMethods-4.1.tar.gz.

File metadata

  • Download URL: Products.ZSQLMethods-4.1.tar.gz
  • Upload date:
  • Size: 55.7 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/4.0.2 CPython/3.11.7

File hashes

Hashes for Products.ZSQLMethods-4.1.tar.gz
Algorithm Hash digest
SHA256 dfd23684fdd9d8076045efba45a9e77d7c9841ea80c315b0e4a57300f464ad8f
MD5 22915a49be114bfec8f47f7870641fdb
BLAKE2b-256 e6c0061e7ac9223aabb6b6aa3a4f0a7400ae8a00cc7391b1735f72e3379f5d79

See more details on using hashes here.

File details

Details for the file Products.ZSQLMethods-4.1-py3-none-any.whl.

File metadata

File hashes

Hashes for Products.ZSQLMethods-4.1-py3-none-any.whl
Algorithm Hash digest
SHA256 e00fcc9bd9f93cd75d09e6f054e7e1206efd084eb42cf0288074c6358986a108
MD5 f11361c734558cef377e695feeec3510
BLAKE2b-256 833d46f4ef2a13543b5360b86846f1a03fa6409b20271b8465164c9f2be8fbe0

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page