Products.SQLAlchemyDA


NameProducts.SQLAlchemyDA JSON
Version 2.2 PyPI version JSON
download
home_pagehttps://github.com/zopefoundation/Products.SQLAlchemyDA
SummaryA generic database adapter for Zope
upload_time2024-02-07 14:19:59
maintainerZope Foundation and Contributors
docs_urlNone
authorAndreas Jung
requires_python>=3.7
licenseZPL 2.1
keywords zope database adapter sqlalchemy
VCS
bugtrack_url
requirements No requirements were recorded.
Travis-CI No Travis.
coveralls test coverage No coveralls.
            .. image:: https://github.com/zopefoundation/Products.SQLAlchemyDA/actions/workflows/tests.yml/badge.svg
        :target: https://github.com/zopefoundation/Products.SQLAlchemyDA/actions/workflows/tests.yml

.. image:: https://coveralls.io/repos/github/zopefoundation/Products.SQLAlchemyDA/badge.svg
        :target: https://coveralls.io/github/zopefoundation/Products.SQLAlchemyDA

.. image:: https://img.shields.io/pypi/v/Products.SQLAlchemyDA.svg
        :target: https://pypi.org/project/Products.SQLAlchemyDA/
        :alt: Current version on PyPI

.. image:: https://img.shields.io/pypi/pyversions/Products.SQLAlchemyDA.svg
        :target: https://pypi.org/project/Products.SQLAlchemyDA/
        :alt: Supported Python versions


Zope ZSQL-SQLAlchemy Integration Wrapper
========================================


About SQLAlchemyDA
------------------

SQLAlchemyDA is a generic database adapter for Zope ZSQL methods, which are
an older/legacy SQL templating feature for executing relational database queries
from with in a Zope to transaction context.

SQLAlchemyDA provides an implementation in the form of a Zope "product" which
wraps `z3c.sqlalchemy <https://pypi.org/project/z3c.sqlalchemy/>`_, so that
database connections are installable as objects in the Zope ZMI. Such
connection objects can be set up to connect to any kind of database backend
supported by SQLAlchemy using a database URI, such as Postgres, MySQL, Oracle,
SQLite, MS-SQL, Firebird, Informix. However, some of these database backends
have not been tested with the SQLAlchemyDA, so your mileage may vary.

In addition to ZSQL support, the SQLAlchemyDA makes it possible to use the
standard SQLAlchemy API within a Zope context and participate in Zope
transactions.

However, if you do not require ZSQL support, and only wish to call 'normal'
SQLAlchemy APIs within Zope transactions, this package adds no value. Instead,
you would be better off trying out `zope.sqlalchemy`, as recommended in the
`Zope book chapter on relational database
connectivity <http://docs.zope.org/zope2/zope2book/RelationalDatabases.html>`_.


Requirements:
-------------

- Zope 4+
- SQLAlchemy >= 0.5.0 (+ database specific low-level Python drivers)
- z3c.sqlalchemy >= 1.5.0

Testing: testfixtures are needed to run tests.


Installation:
-------------

- Download and install SQLAlchemy as egg or from the sources
  from PyPI (pip sqlalchemy). See
    
    http://www.sqlalchemy.org

    for details

- Download and install z3c.sqlalchemy as egg or from the sources 
  from PyPI (pip z3c.sqlalchemy). See

    https://pypi.org/project/z3c.sqlalchemy/

  for details.

- Unpack the archive containing SQLAlchemyDA inside the "Products"
  directory of your Zope instance home.

- After restarting Zope you go to the ZMI and create an instance of
  "SQLAlchemyDA" (as you would create some DA instance)

- Click on the new created SQLAlchemyDA instance within the ZMI
  and configure your database connection through the "Properties" tab.
  The connection parameter 'dsn' must be specified as a valid SQLAlchemy DSN 
  like

         <dbschema>://<username>:<password>@<hostname>/<databasename>

    Example:
        
        postgres://admin:123@localhost:5432/TestDB

- ZSQL methods should see the new DA through the selection widget of available
  database adapters

- NOTE: you must have the low-level Python DB drivers installed in order to 
  access a particular database. See 

        http://www.sqlalchemy.org/docs/dbengine.html#dbengine_supported

  for details.


Configuration of SQLAlchemyDA:
------------------------------

- 'dsn' - SQLAlchemy compliant Database Set Name (see www.sqlalchemy.org/docs)

- 'transactional' - uncheck this property if you are working with a non-transactional
   database like older versions of MySQL. Uncheck this property *only* if you see any
   commit() related error. Otherwise leave this property checked. Changing this
   property *requires* a Zope restart.

- 'quoting_style' - affects how strings are quoted in SQL. By default 'standard' 
   quotes strings correctly. Setting the value to 'no-quote' might solve quoting issues
   with some databases.


Using SQLAlchemyDA:
-------------------

SQLAlchemyDA works as a database adapter as documented within "The Zope Book"

https://zope.readthedocs.io/en/latest/zopebook/RelationalDatabases.html

and can be used like any other DA together with ZSQL methods.


Tested with databases:
----------------------

- Postgres 7.4, 8.0-8.2
- SQLite 3.3.X
- Oracle 10g
- MySQL is *only* supported for MySQL databases with transaction support.
  (see also z3c/sqlalchemy/README.txt)
- MSSQL 2008
 

Known issues:
-------------

""" Database connection could not be opened ((ProgrammingError) (1064, You
have an error in your SQL syntax near 'COMMIT .
"""

This bug might appear with older MySQL versions when opening/closing
the connections manually through the ZMI. It should not affect the
functionality of SQLAlchemyDA.
    

Author
------

SQLAlchemyDA was written by Andreas Jung for Haufe Mediengruppe, Freiburg,
Germany and ZOPYX Ltd. & Co. KG, Tuebingen, Germany.


License
-------

SQLAlchemyDA is  licensed under the Zope Public License 2.1. 
See LICENSE.txt.


Credits
-------

Parts of the SQLAlchemyDA V 0.3.X development has been sponsored by Wayne
Volkmuth (renovis.com).

More recent SQLAlchemy support and maintenance sponsored by ZeOmega.com.

CHANGES
=======

Change log
==========

2.2 (2024-02-07)
----------------

- Add missing security declarations on the database adapter class
  to mitigate arbitrary SQL query execution vulnerability.

- Add support for Python 3.12.


2.1 (2023-09-04)
----------------

- Add support for SQLAlchemy 2.0
  (`#16 <https://github.com/zopefoundation/Products.SQLAlchemyDA/issues/16>`_)


2.0 (2023-02-01)
----------------

- Drop support for Python 2.7, 3.5, 3.6.


1.1.0 (2022-12-16)
------------------

- Fix insidious buildout configuration bug for tests against Zope 4.

- Add support for Python 3.10 and 3.11.


1.0.2 (2021-11-02)
------------------

- fix unexpected NoneType return on sql-update
  (`#12 <https://github.com/zopefoundation/Products.SQLAlchemyDA/pull/12>`_)


1.0.1 (2021-05-03)
------------------

- fix test failures under Python 3.5 by pinning SQLAlchemy.
  Pin can be dropped when support for Zope 4 is dropped.

- change package structure to move package code into a ``src`` subfolder


1.0.0 (2020-11-13)
------------------

- add linting configurations and apply results

- Package cleanup

- Add support for Python 3.5-3.9
  (`#8 <https://github.com/zopefoundation/Products.SQLAlchemyDA/pull/8>`_)


0.6.2b3 (2017-04-03)
--------------------
URL fix in add form.


0.6.2b2 (2015-06-24)
--------------------

Workarounds for edge case error conditions looking up or
creating underlying z3c.sqlalchemy ZopeWrapper instances.


0.6.2b1 (2015-06-23)
--------------------

Beta Release: If you try out this version, please provide feedback!

Added public API for use within Zope acquisition context to access
the underlying zc3.sqlalchemy `ZopeWrapper` instance, with added
error handling and logging to deal with situations where Zope
context may have been lost.

Tests now assume a testrunner such as nose or py.test, and
testfixtures has been added as a testing dependency.


0.6.1b1 (2015-06-19)
--------------------

Improved safety of non-acquisition public API by making registry no longer
contain Zope Persistent objects; instead storing and returning only the
underlying zc3.sqlalchemy `ZopeWrapper` instances. These objects
are plain Python objects in memory with no Persistent connection to ZODB.
(Thanks to Tres Seaver for the suggestion!)


0.6.0b7 (2015-04-27)
--------------------

This is a more stable beta, with several fixes. It has been tested
with SQLAlchemy 0.9.8, Zope2.13, and Python 2.7.9.

Fixes from beta 1-7 include:

- Manifest now includes the .rst, .txt, and .zpt files required
  for installation via ZMI in Zope2.
- The new `lookup_da` registry was failing to populate after
  Zope restarts; now the registry populates when the DA instance
  unpickles. (TODO: needs test coverage; this feature is not
  as robust as it could be, since the registry could be
  called before unpickling). UPDATE for beta 7: Still no
  test coverage, but after manual testing fixed bug with
  switched key and values in registry.
- Added a new `clear_da_registry` to support test teardown.
- NOTE: Beta6 release was taken from the wrong branch,
  and contained experimental untested code. DO not use beta6.

Some non-public patches to support MSSQL have been tested; please inquire if
interested in having them merged to public code.


0.6.0b (2015-03-23)
-------------------

- Added alternative lookup API to get a handle on SAWrapper instances.  To use
  the new lookup mechanism, see Products.SQLAlchemyDA.da.py and look for the
  function `lookup_da`. This was created to allow avoiding Zope Acquisition as
  a lookup mechanism, and to work around the issue that the underlying
  z3c.sqlalchemy `getSAWrapper` function is non-usable when created by the
  SAWrapper DA. This is because API consumers have no access to the random
  internally generated name ('util_id' attribute) under which the utility
  is registered...at least not without resorting to Acquisition calls.
- Tested with SQLAlchemy 0.7.6, Zope 2.13, and Python 2.7.9, and SQLite.
  Your mileage may vary with other databases and versions, but most likely
  it will run with older versions of Zope and Python as old as 2.5 (running
  tests requires at least Python 2.5). Newer versions of SQLAlchemy will be
  tested for the next release.


0.5.2 (unreleased)
------------------
- Fixed LP #639597

0.5.1 (2010-08-05)
------------------
- fixed typo in type mapping

0.5.0 (2010-05-07)
------------------

- Fixed LP #570208
- Added a method 'add_extra_engine_options' to set additional engine
  options for SQLAlchemy.create_engine.
- Removed SOFTWARE_HOME dependency
- Requires SQLAlchemy >= 0.5.0

0.4.1 (2008-06-01)
------------------

- fixed issue with version.txt file

0.4.0 (2008-01-24)
------------------

- requires z3c.sqlalchemy (2.0.0 or higher)
- requires SQLAlchemy 0.4.4 or higer


0.3.0 (2007-06-10)
------------------

- fixed some security assertions
- added "Test" tab for executing SQL queries directly
- better error handling for ZMI screens
- no longer depending on a pre-registered SQLAlchemy wrapper. SQLAlchemyDA
  now accepts (as any other DA) a DSN as property 'dsn'
- DSN can be passed through the add form
- redirect directly to "Info" tab after creating an instance through the ZMI
- catching some low-level exceptions from the sqlite interface in order to
  make it work with SQLite
- new properties 'transactional' and 'quoting_style'
- improved support for Oracle and MySQL
- SQLAlchemyDA no longer provides access to mapper related functionalities.
  It now acts as a DA for executing SQL statements *only*.
- fixed unregistration code for a wrapper (hopefully works with Zope 2.8 or
  higher)

- updated documentation

0.2.1 (2007-05-06)
------------------

- connections can be closed/opened through the ZMI
- some code cleanup
- fixed a *very* stupid typo causing ZODB conflict errors

0.2.0 (2007-05-05)
------------------

- first public release

0.1.0 (2007-04-30)
------------------

- initial coding

            

Raw data

            {
    "_id": null,
    "home_page": "https://github.com/zopefoundation/Products.SQLAlchemyDA",
    "name": "Products.SQLAlchemyDA",
    "maintainer": "Zope Foundation and Contributors",
    "docs_url": null,
    "requires_python": ">=3.7",
    "maintainer_email": "zope-dev@zope.dev",
    "keywords": "Zope Database adapter SQLAlchemy",
    "author": "Andreas Jung",
    "author_email": "info@zopyx.com",
    "download_url": "https://files.pythonhosted.org/packages/1e/ca/01af90049cfde405767fb996bc880ad26729f9aa67644c7801d3099d3d4a/Products.SQLAlchemyDA-2.2.tar.gz",
    "platform": null,
    "description": ".. image:: https://github.com/zopefoundation/Products.SQLAlchemyDA/actions/workflows/tests.yml/badge.svg\n        :target: https://github.com/zopefoundation/Products.SQLAlchemyDA/actions/workflows/tests.yml\n\n.. image:: https://coveralls.io/repos/github/zopefoundation/Products.SQLAlchemyDA/badge.svg\n        :target: https://coveralls.io/github/zopefoundation/Products.SQLAlchemyDA\n\n.. image:: https://img.shields.io/pypi/v/Products.SQLAlchemyDA.svg\n        :target: https://pypi.org/project/Products.SQLAlchemyDA/\n        :alt: Current version on PyPI\n\n.. image:: https://img.shields.io/pypi/pyversions/Products.SQLAlchemyDA.svg\n        :target: https://pypi.org/project/Products.SQLAlchemyDA/\n        :alt: Supported Python versions\n\n\nZope ZSQL-SQLAlchemy Integration Wrapper\n========================================\n\n\nAbout SQLAlchemyDA\n------------------\n\nSQLAlchemyDA is a generic database adapter for Zope ZSQL methods, which are\nan older/legacy SQL templating feature for executing relational database queries\nfrom with in a Zope to transaction context.\n\nSQLAlchemyDA provides an implementation in the form of a Zope \"product\" which\nwraps `z3c.sqlalchemy <https://pypi.org/project/z3c.sqlalchemy/>`_, so that\ndatabase connections are installable as objects in the Zope ZMI. Such\nconnection objects can be set up to connect to any kind of database backend\nsupported by SQLAlchemy using a database URI, such as Postgres, MySQL, Oracle,\nSQLite, MS-SQL, Firebird, Informix. However, some of these database backends\nhave not been tested with the SQLAlchemyDA, so your mileage may vary.\n\nIn addition to ZSQL support, the SQLAlchemyDA makes it possible to use the\nstandard SQLAlchemy API within a Zope context and participate in Zope\ntransactions.\n\nHowever, if you do not require ZSQL support, and only wish to call 'normal'\nSQLAlchemy APIs within Zope transactions, this package adds no value. Instead,\nyou would be better off trying out `zope.sqlalchemy`, as recommended in the\n`Zope book chapter on relational database\nconnectivity <http://docs.zope.org/zope2/zope2book/RelationalDatabases.html>`_.\n\n\nRequirements:\n-------------\n\n- Zope 4+\n- SQLAlchemy >= 0.5.0 (+ database specific low-level Python drivers)\n- z3c.sqlalchemy >= 1.5.0\n\nTesting: testfixtures are needed to run tests.\n\n\nInstallation:\n-------------\n\n- Download and install SQLAlchemy as egg or from the sources\n  from PyPI (pip sqlalchemy). See\n    \n    http://www.sqlalchemy.org\n\n    for details\n\n- Download and install z3c.sqlalchemy as egg or from the sources \n  from PyPI (pip z3c.sqlalchemy). See\n\n    https://pypi.org/project/z3c.sqlalchemy/\n\n  for details.\n\n- Unpack the archive containing SQLAlchemyDA inside the \"Products\"\n  directory of your Zope instance home.\n\n- After restarting Zope you go to the ZMI and create an instance of\n  \"SQLAlchemyDA\" (as you would create some DA instance)\n\n- Click on the new created SQLAlchemyDA instance within the ZMI\n  and configure your database connection through the \"Properties\" tab.\n  The connection parameter 'dsn' must be specified as a valid SQLAlchemy DSN \n  like\n\n         <dbschema>://<username>:<password>@<hostname>/<databasename>\n\n    Example:\n        \n        postgres://admin:123@localhost:5432/TestDB\n\n- ZSQL methods should see the new DA through the selection widget of available\n  database adapters\n\n- NOTE: you must have the low-level Python DB drivers installed in order to \n  access a particular database. See \n\n        http://www.sqlalchemy.org/docs/dbengine.html#dbengine_supported\n\n  for details.\n\n\nConfiguration of SQLAlchemyDA:\n------------------------------\n\n- 'dsn' - SQLAlchemy compliant Database Set Name (see www.sqlalchemy.org/docs)\n\n- 'transactional' - uncheck this property if you are working with a non-transactional\n   database like older versions of MySQL. Uncheck this property *only* if you see any\n   commit() related error. Otherwise leave this property checked. Changing this\n   property *requires* a Zope restart.\n\n- 'quoting_style' - affects how strings are quoted in SQL. By default 'standard' \n   quotes strings correctly. Setting the value to 'no-quote' might solve quoting issues\n   with some databases.\n\n\nUsing SQLAlchemyDA:\n-------------------\n\nSQLAlchemyDA works as a database adapter as documented within \"The Zope Book\"\n\nhttps://zope.readthedocs.io/en/latest/zopebook/RelationalDatabases.html\n\nand can be used like any other DA together with ZSQL methods.\n\n\nTested with databases:\n----------------------\n\n- Postgres 7.4, 8.0-8.2\n- SQLite 3.3.X\n- Oracle 10g\n- MySQL is *only* supported for MySQL databases with transaction support.\n  (see also z3c/sqlalchemy/README.txt)\n- MSSQL 2008\n \n\nKnown issues:\n-------------\n\n\"\"\" Database connection could not be opened ((ProgrammingError) (1064, You\nhave an error in your SQL syntax near 'COMMIT .\n\"\"\"\n\nThis bug might appear with older MySQL versions when opening/closing\nthe connections manually through the ZMI. It should not affect the\nfunctionality of SQLAlchemyDA.\n    \n\nAuthor\n------\n\nSQLAlchemyDA was written by Andreas Jung for Haufe Mediengruppe, Freiburg,\nGermany and ZOPYX Ltd. & Co. KG, Tuebingen, Germany.\n\n\nLicense\n-------\n\nSQLAlchemyDA is  licensed under the Zope Public License 2.1. \nSee LICENSE.txt.\n\n\nCredits\n-------\n\nParts of the SQLAlchemyDA V 0.3.X development has been sponsored by Wayne\nVolkmuth (renovis.com).\n\nMore recent SQLAlchemy support and maintenance sponsored by ZeOmega.com.\n\nCHANGES\n=======\n\nChange log\n==========\n\n2.2 (2024-02-07)\n----------------\n\n- Add missing security declarations on the database adapter class\n  to mitigate arbitrary SQL query execution vulnerability.\n\n- Add support for Python 3.12.\n\n\n2.1 (2023-09-04)\n----------------\n\n- Add support for SQLAlchemy 2.0\n  (`#16 <https://github.com/zopefoundation/Products.SQLAlchemyDA/issues/16>`_)\n\n\n2.0 (2023-02-01)\n----------------\n\n- Drop support for Python 2.7, 3.5, 3.6.\n\n\n1.1.0 (2022-12-16)\n------------------\n\n- Fix insidious buildout configuration bug for tests against Zope 4.\n\n- Add support for Python 3.10 and 3.11.\n\n\n1.0.2 (2021-11-02)\n------------------\n\n- fix unexpected NoneType return on sql-update\n  (`#12 <https://github.com/zopefoundation/Products.SQLAlchemyDA/pull/12>`_)\n\n\n1.0.1 (2021-05-03)\n------------------\n\n- fix test failures under Python 3.5 by pinning SQLAlchemy.\n  Pin can be dropped when support for Zope 4 is dropped.\n\n- change package structure to move package code into a ``src`` subfolder\n\n\n1.0.0 (2020-11-13)\n------------------\n\n- add linting configurations and apply results\n\n- Package cleanup\n\n- Add support for Python 3.5-3.9\n  (`#8 <https://github.com/zopefoundation/Products.SQLAlchemyDA/pull/8>`_)\n\n\n0.6.2b3 (2017-04-03)\n--------------------\nURL fix in add form.\n\n\n0.6.2b2 (2015-06-24)\n--------------------\n\nWorkarounds for edge case error conditions looking up or\ncreating underlying z3c.sqlalchemy ZopeWrapper instances.\n\n\n0.6.2b1 (2015-06-23)\n--------------------\n\nBeta Release: If you try out this version, please provide feedback!\n\nAdded public API for use within Zope acquisition context to access\nthe underlying zc3.sqlalchemy `ZopeWrapper` instance, with added\nerror handling and logging to deal with situations where Zope\ncontext may have been lost.\n\nTests now assume a testrunner such as nose or py.test, and\ntestfixtures has been added as a testing dependency.\n\n\n0.6.1b1 (2015-06-19)\n--------------------\n\nImproved safety of non-acquisition public API by making registry no longer\ncontain Zope Persistent objects; instead storing and returning only the\nunderlying zc3.sqlalchemy `ZopeWrapper` instances. These objects\nare plain Python objects in memory with no Persistent connection to ZODB.\n(Thanks to Tres Seaver for the suggestion!)\n\n\n0.6.0b7 (2015-04-27)\n--------------------\n\nThis is a more stable beta, with several fixes. It has been tested\nwith SQLAlchemy 0.9.8, Zope2.13, and Python 2.7.9.\n\nFixes from beta 1-7 include:\n\n- Manifest now includes the .rst, .txt, and .zpt files required\n  for installation via ZMI in Zope2.\n- The new `lookup_da` registry was failing to populate after\n  Zope restarts; now the registry populates when the DA instance\n  unpickles. (TODO: needs test coverage; this feature is not\n  as robust as it could be, since the registry could be\n  called before unpickling). UPDATE for beta 7: Still no\n  test coverage, but after manual testing fixed bug with\n  switched key and values in registry.\n- Added a new `clear_da_registry` to support test teardown.\n- NOTE: Beta6 release was taken from the wrong branch,\n  and contained experimental untested code. DO not use beta6.\n\nSome non-public patches to support MSSQL have been tested; please inquire if\ninterested in having them merged to public code.\n\n\n0.6.0b (2015-03-23)\n-------------------\n\n- Added alternative lookup API to get a handle on SAWrapper instances.  To use\n  the new lookup mechanism, see Products.SQLAlchemyDA.da.py and look for the\n  function `lookup_da`. This was created to allow avoiding Zope Acquisition as\n  a lookup mechanism, and to work around the issue that the underlying\n  z3c.sqlalchemy `getSAWrapper` function is non-usable when created by the\n  SAWrapper DA. This is because API consumers have no access to the random\n  internally generated name ('util_id' attribute) under which the utility\n  is registered...at least not without resorting to Acquisition calls.\n- Tested with SQLAlchemy 0.7.6, Zope 2.13, and Python 2.7.9, and SQLite.\n  Your mileage may vary with other databases and versions, but most likely\n  it will run with older versions of Zope and Python as old as 2.5 (running\n  tests requires at least Python 2.5). Newer versions of SQLAlchemy will be\n  tested for the next release.\n\n\n0.5.2 (unreleased)\n------------------\n- Fixed LP #639597\n\n0.5.1 (2010-08-05)\n------------------\n- fixed typo in type mapping\n\n0.5.0 (2010-05-07)\n------------------\n\n- Fixed LP #570208\n- Added a method 'add_extra_engine_options' to set additional engine\n  options for SQLAlchemy.create_engine.\n- Removed SOFTWARE_HOME dependency\n- Requires SQLAlchemy >= 0.5.0\n\n0.4.1 (2008-06-01)\n------------------\n\n- fixed issue with version.txt file\n\n0.4.0 (2008-01-24)\n------------------\n\n- requires z3c.sqlalchemy (2.0.0 or higher)\n- requires SQLAlchemy 0.4.4 or higer\n\n\n0.3.0 (2007-06-10)\n------------------\n\n- fixed some security assertions\n- added \"Test\" tab for executing SQL queries directly\n- better error handling for ZMI screens\n- no longer depending on a pre-registered SQLAlchemy wrapper. SQLAlchemyDA\n  now accepts (as any other DA) a DSN as property 'dsn'\n- DSN can be passed through the add form\n- redirect directly to \"Info\" tab after creating an instance through the ZMI\n- catching some low-level exceptions from the sqlite interface in order to\n  make it work with SQLite\n- new properties 'transactional' and 'quoting_style'\n- improved support for Oracle and MySQL\n- SQLAlchemyDA no longer provides access to mapper related functionalities.\n  It now acts as a DA for executing SQL statements *only*.\n- fixed unregistration code for a wrapper (hopefully works with Zope 2.8 or\n  higher)\n\n- updated documentation\n\n0.2.1 (2007-05-06)\n------------------\n\n- connections can be closed/opened through the ZMI\n- some code cleanup\n- fixed a *very* stupid typo causing ZODB conflict errors\n\n0.2.0 (2007-05-05)\n------------------\n\n- first public release\n\n0.1.0 (2007-04-30)\n------------------\n\n- initial coding\n",
    "bugtrack_url": null,
    "license": "ZPL 2.1",
    "summary": "A generic database adapter for Zope",
    "version": "2.2",
    "project_urls": {
        "Homepage": "https://github.com/zopefoundation/Products.SQLAlchemyDA",
        "Issue Tracker": "https://github.com/zopefoundation/Products.SQLAlchemyDA/issues",
        "Sources": "https://github.com/zopefoundation/Products.SQLAlchemyDA"
    },
    "split_keywords": [
        "zope",
        "database",
        "adapter",
        "sqlalchemy"
    ],
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "217b5333db5ed5992121b26812d9c9649fca33cbf5407e2ffbdae30cc6aee956",
                "md5": "54249ad5a3414a7990b445f4931894e8",
                "sha256": "fcb8bc737c77af9a42d45467c7186bd0762958ebd71f402669ae8a33f09256ad"
            },
            "downloads": -1,
            "filename": "Products.SQLAlchemyDA-2.2-py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "54249ad5a3414a7990b445f4931894e8",
            "packagetype": "bdist_wheel",
            "python_version": "py3",
            "requires_python": ">=3.7",
            "size": 19813,
            "upload_time": "2024-02-07T14:19:57",
            "upload_time_iso_8601": "2024-02-07T14:19:57.437431Z",
            "url": "https://files.pythonhosted.org/packages/21/7b/5333db5ed5992121b26812d9c9649fca33cbf5407e2ffbdae30cc6aee956/Products.SQLAlchemyDA-2.2-py3-none-any.whl",
            "yanked": false,
            "yanked_reason": null
        },
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "1eca01af90049cfde405767fb996bc880ad26729f9aa67644c7801d3099d3d4a",
                "md5": "491447138ee38a110ee0a3f9e9ad47e7",
                "sha256": "af5b502d1f5b5ca1229445d00ddca62560261213fb4c5184ad9d935e5f3bcbbf"
            },
            "downloads": -1,
            "filename": "Products.SQLAlchemyDA-2.2.tar.gz",
            "has_sig": false,
            "md5_digest": "491447138ee38a110ee0a3f9e9ad47e7",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": ">=3.7",
            "size": 23375,
            "upload_time": "2024-02-07T14:19:59",
            "upload_time_iso_8601": "2024-02-07T14:19:59.062655Z",
            "url": "https://files.pythonhosted.org/packages/1e/ca/01af90049cfde405767fb996bc880ad26729f9aa67644c7801d3099d3d4a/Products.SQLAlchemyDA-2.2.tar.gz",
            "yanked": false,
            "yanked_reason": null
        }
    ],
    "upload_time": "2024-02-07 14:19:59",
    "github": true,
    "gitlab": false,
    "bitbucket": false,
    "codeberg": false,
    "github_user": "zopefoundation",
    "github_project": "Products.SQLAlchemyDA",
    "travis_ci": false,
    "coveralls": false,
    "github_actions": true,
    "tox": true,
    "lcname": "products.sqlalchemyda"
}
        
Elapsed time: 3.10543s