Skip to main content

Description

Z SQL methods provide a caching mechanism that can greatly reduce the number of database accesses.

If, however, the database is changed dynamically, the cache must be used with caution as otherwise stale query results may be returned.

Cache controled SQL methods (CCSQLMethods) are derived from Z SQL methods. In addition to the normal Z SQL methods, a cache controlled SQL method implements the functions flushCache() and flushCacheEntry(REQUEST=None, **kw). flushCache flushes the complete cache associated with the method. flushCacheEntry flushes the query specified by its arguments. The query is determined in the same way as in __call__. This allows explicit cache control and allows for much better cache utilization.

Note that flushCache works reliably across multiple ZEO client processes while flushCacheEntry takes effect only in a single process.

Cache controled SQL methods are also available as an CMF FSZSQLMethod derivative. They are registered with the filename extension ccsql.

History

Version 2.0

  • moved over to PyPI

  • works for Zope 2.11 (and possible above)

Version 1.0

made Zope 2.8 compatible.

Metadata

Release files for Products.CCSQLMethods 2.0

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for Products.CCSQLMethods 2.0
File Size Uploaded
Products.CCSQLMethods-2.0.tar.gz 7.8 kB Details

Release files / Products.CCSQLMethods-2.0.tar.gz

Download URL Products.CCSQLMethods-2.0.tar.gz
Size 7.8 kB
Tags Source
SHA-256 checksum
How to use checksums
c071937a0865394ebde6bbd4814a4127d4873942e36254dc47a4f66b566bbcc2
BLAKE2b-256 checksum
How to use checksums
65d95e9dd30f9c80a479830aae52e19ff40f9b590b10e1793a9668748d1c71d6
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No

Release history Release notifications | RSS feed

This release

2.0 This release

1 release file

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page