SQL statements generator for Zope SQL adapters
Project description
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]
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
File details
Details for the file visaplan.plone.sqlwrapper-1.0.3.tar.gz.
File metadata
- Download URL: visaplan.plone.sqlwrapper-1.0.3.tar.gz
- Upload date:
- Size: 23.1 kB
- Tags: Source
- Uploaded using 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
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | 25d053645037155e1e73bd1bad707189a32d1a777cada33b004dd97e0ee50d35 |
|
| MD5 | 9b3926a8d9d838628b46cfdd271d87bd |
|
| BLAKE2b-256 | da9852c4faef59522aaaf2d26b093a552a24f51a922576372744b71ee8a64368 |
