====================================
PyAMS SQLAlchemy integration package
====================================
.. contents::
What is PyAMS?
==============
PyAMS (Pyramid Application Management Suite) is a small suite of packages written for applications
and content management with the Pyramid framework.
**PyAMS** is actually mainly used to manage web sites through content management applications (CMS,
see PyAMS_content package), but many features are generic and can be used inside any kind of web
application.
All PyAMS documentation is available on `ReadTheDocs <https://pyams.readthedocs.io>`_; source code
is available on `Gitlab <https://gitlab.com/pyams>`_ and pushed to `Github
<https://github.com/py-ams>`_. Doctests are available in the *doctests* source folder.
What is PyAMS SQLAlchemy?
=========================
SQLALchemy is a very common ORM package for Python. As PyAMS relies on ZODB connections, this
package provides components which can be used to define SQL "sessions" through management
interface, which are then integrated into main transactions using a two-phases commit manager.
This package also provides optional features to extend PyAMS_scheduler package with new tasks
which can launch SQL commands.
Changelog
=========
2.1.0
-----
- updated syntax of settings used for dynamic schemas names
- added support for global schema name replacement using a single alias
2.0.3
-----
- updated SQLAlchemy columns getter in test form
- Sonar scanner version reset
2.0.2
-----
- updated task scheduler interfaces
2.0.1
-----
- updated modal forms title
2.0.0
-----
- upgraded to Pyramid 2.0 and SQLAlchemy 2.0
1.4.1
-----
- added support for Python 3.11
- updated doctest
1.4.0
-----
- allow usage of dynamic text formatters into scheduler SQL tasks
1.3.6
-----
- use new status on scheduler task execution failure
1.3.5
-----
- PyAMS_security interfaces refactoring
- added support for Python 3.10
1.3.4
-----
- handle session commit when query doesn't return any result
- updated SQLAlchemy task add/edit forms editor size
- added doctests
1.3.3
-----
- use new context base add action
1.3.2
-----
- renamed permission constant
1.3.1
-----
- use IUniqueID adapter "oid" value instead of adapter when creating new engine
- updated "back" link target in engines container view
1.3.0
-----
- added SQLAlchemy connections manager label adapter
- updated add and edit forms title
- updated package include scan
1.2.3
-----
- use IObjectLabel interface instead of ITableElementName
1.2.2
-----
- updated forms AJAX renderers
- Pylint cleanups
1.2.1
-----
- added missing "context" argument to permission check
- updated add menus registration for last release of PyAMS_zmi package
1.2.0
-----
- added option to disable two-phases commit on any SQLALchemy engine
- added Pyramid setting to manage connections management thread; this setting can also be used
to disable this thread completely
1.1.0
-----
- removed support for Python < 3.7
1.0.0
-----
- initial release
Raw data
{
"_id": null,
"home_page": "https://pyams.readthedocs.io",
"name": "pyams-alchemy",
"maintainer": null,
"docs_url": null,
"requires_python": null,
"maintainer_email": null,
"keywords": "Pyramid PyAMS",
"author": "Thierry Florac",
"author_email": "tflorac@ulthar.net",
"download_url": "https://files.pythonhosted.org/packages/eb/f8/e4e127203670aa915ba388e637bd1367a4209c1df4052bf997b40c8bd575/pyams_alchemy-2.1.0.tar.gz",
"platform": null,
"description": "====================================\nPyAMS SQLAlchemy integration package\n====================================\n\n.. contents::\n\n\nWhat is PyAMS?\n==============\n\nPyAMS (Pyramid Application Management Suite) is a small suite of packages written for applications\nand content management with the Pyramid framework.\n\n**PyAMS** is actually mainly used to manage web sites through content management applications (CMS,\nsee PyAMS_content package), but many features are generic and can be used inside any kind of web\napplication.\n\nAll PyAMS documentation is available on `ReadTheDocs <https://pyams.readthedocs.io>`_; source code\nis available on `Gitlab <https://gitlab.com/pyams>`_ and pushed to `Github\n<https://github.com/py-ams>`_. Doctests are available in the *doctests* source folder.\n\n\nWhat is PyAMS SQLAlchemy?\n=========================\n\nSQLALchemy is a very common ORM package for Python. As PyAMS relies on ZODB connections, this\npackage provides components which can be used to define SQL \"sessions\" through management\ninterface, which are then integrated into main transactions using a two-phases commit manager.\n\nThis package also provides optional features to extend PyAMS_scheduler package with new tasks\nwhich can launch SQL commands.\n\n\nChangelog\n=========\n\n2.1.0\n-----\n - updated syntax of settings used for dynamic schemas names\n - added support for global schema name replacement using a single alias\n\n2.0.3\n-----\n - updated SQLAlchemy columns getter in test form\n - Sonar scanner version reset\n\n2.0.2\n-----\n - updated task scheduler interfaces\n\n2.0.1\n-----\n - updated modal forms title\n\n2.0.0\n-----\n - upgraded to Pyramid 2.0 and SQLAlchemy 2.0\n\n1.4.1\n-----\n - added support for Python 3.11\n - updated doctest\n\n1.4.0\n-----\n - allow usage of dynamic text formatters into scheduler SQL tasks\n\n1.3.6\n-----\n - use new status on scheduler task execution failure\n\n1.3.5\n-----\n - PyAMS_security interfaces refactoring\n - added support for Python 3.10\n\n1.3.4\n-----\n - handle session commit when query doesn't return any result\n - updated SQLAlchemy task add/edit forms editor size\n - added doctests\n\n1.3.3\n-----\n - use new context base add action\n\n1.3.2\n-----\n - renamed permission constant\n\n1.3.1\n-----\n - use IUniqueID adapter \"oid\" value instead of adapter when creating new engine\n - updated \"back\" link target in engines container view\n\n1.3.0\n-----\n - added SQLAlchemy connections manager label adapter\n - updated add and edit forms title\n - updated package include scan\n\n1.2.3\n-----\n - use IObjectLabel interface instead of ITableElementName\n\n1.2.2\n-----\n - updated forms AJAX renderers\n - Pylint cleanups\n\n1.2.1\n-----\n - added missing \"context\" argument to permission check\n - updated add menus registration for last release of PyAMS_zmi package\n\n1.2.0\n-----\n - added option to disable two-phases commit on any SQLALchemy engine\n - added Pyramid setting to manage connections management thread; this setting can also be used\n to disable this thread completely\n\n1.1.0\n-----\n - removed support for Python < 3.7\n\n1.0.0\n-----\n - initial release\n",
"bugtrack_url": null,
"license": "ZPL",
"summary": "PyAMS SQLAlchemy extension",
"version": "2.1.0",
"project_urls": {
"Homepage": "https://pyams.readthedocs.io"
},
"split_keywords": [
"pyramid",
"pyams"
],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "540831e20f81fcc119f65ae4bd28d945d2564f3d3946841e350fd70cb644b860",
"md5": "9cead6bb710718eb315b8d208db3db1c",
"sha256": "026d9975c590f16bc651ff4468f9741b7ec8a578bbc1ee9a7f77ff8aaa830fd5"
},
"downloads": -1,
"filename": "pyams_alchemy-2.1.0-py3-none-any.whl",
"has_sig": false,
"md5_digest": "9cead6bb710718eb315b8d208db3db1c",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": null,
"size": 41492,
"upload_time": "2024-09-15T15:59:20",
"upload_time_iso_8601": "2024-09-15T15:59:20.854657Z",
"url": "https://files.pythonhosted.org/packages/54/08/31e20f81fcc119f65ae4bd28d945d2564f3d3946841e350fd70cb644b860/pyams_alchemy-2.1.0-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "ebf8e4e127203670aa915ba388e637bd1367a4209c1df4052bf997b40c8bd575",
"md5": "6df182035dbf7db87bd7028ad1dac9f9",
"sha256": "2cb7986e75f0295eb859987fde98fb5ee4f04140c4a01d4faf3aee7becbc7039"
},
"downloads": -1,
"filename": "pyams_alchemy-2.1.0.tar.gz",
"has_sig": false,
"md5_digest": "6df182035dbf7db87bd7028ad1dac9f9",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 24457,
"upload_time": "2024-09-15T15:59:22",
"upload_time_iso_8601": "2024-09-15T15:59:22.568700Z",
"url": "https://files.pythonhosted.org/packages/eb/f8/e4e127203670aa915ba388e637bd1367a4209c1df4052bf997b40c8bd575/pyams_alchemy-2.1.0.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-09-15 15:59:22",
"github": false,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"lcname": "pyams-alchemy"
}