visaplan.plone.sqlwrapper
This package provides a simple generator for SQL statements, which are then executed by a Zope database adapter.
It does not try to implement an object-relational mapper (ORM) but simply helps to create SQL statements.
The purpose of this package is not to provide new functionality but to factor out existing functionality from an existing monolitic Zope product. Thus, it is more likely to lose functionality during further development (as parts of it will be forked out into their own packages, or some functionality may even become obsolete because there are better alternatives in standard Plone components).
There might be some work still necessary to make this product useful for a broader audience; it is currently in use in our monolithic product resp. it’s successors only.
We consider it more likely the successor packages visaplan.tools and visaplan.zope.reldb (see below) to be useful for current use.
Features
Methods:
insert
update
delete
select
query
Implements the Context manager protocol
Examples
This add-on can be seen in action at the following sites:
Contribute
Issue Tracker: https://github.com/visaplan/plone.sqlwrapper/issues
Source Code: https://github.com/visaplan/plone.sqlwrapper
Support
If you are having issues, please let us know; please use the issue tracker mentioned above.
License
The project is licensed under the GPLv2.
See also
visaplan.tools contains an sql module to generate SQL statements like the ones mentioned above, detached from any Zope context
visaplan.zope.reldb contains a copy which follows the SQLAlchemy placeholders convention (:name).
Contributors
Tobias Herp, tobias.herp@visaplan.com
Changelog
1.0.3 (2020-12-16)
Use isort
Fixed Github links
[tobiasherp]
1.0.2 (2020-08-17)
Python 3.3+ compatibility, using six
Dedicated interface module
[tobiasherp]
1.0.1 (2018-11-23)
Declared existing dependencies. [tobiasherp]
1.0 (2018-09-17)
Initial release. [tobiasherp]
1 maintainer
Release files for visaplan.plone.sqlwrapper 1.0.3
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| visaplan.plone.sqlwrapper-1.0.3.tar.gz | 23.1 kB | Details |
Release files / visaplan.plone.sqlwrapper-1.0.3.tar.gz
| Download URL | visaplan.plone.sqlwrapper-1.0.3.tar.gz |
|---|---|
| Size | 23.1 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
25d053645037155e1e73bd1bad707189a32d1a777cada33b004dd97e0ee50d35
|
|
BLAKE2b-256 checksum How to use checksums |
da9852c4faef59522aaaf2d26b093a552a24f51a922576372744b71ee8a64368
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/1.13.0 pkginfo/1.4.2 requests/2.19.0 setuptools/41.0.1 requests-toolbelt/0.8.0 tqdm/4.23.4 CPython/2.7.5
|
