Skip to main content

Alchemytools

This project brings a set of useful tools to be used in any SQLAchemly project.

The idea is to save common problems, for example: Opening/Closing sessions, commiting the sesssin only at the end of the transaction, etc.

Available Tools

Here are all tools available in alchemytools.

Context Managers

managed

This is the basic context manager and it will commit and close your session automatically, at the end of the with block.

with managed(MySessionClass) as session:
    # Do what you need with your session
# Here the session is already closed and commited

If you raise any exception inside the with block, the session will be rolled back and the exception re-raised.

To avoid having all of the function body inside the with block, managed functions as a context manager as well.

@managed(MySessionClass)
def foo(session, *args, **kwargs):
    # Do what you need with your session
    pass

# call as if the session didn't exist:
foo(2, a='b')

The session is opened every time the function is called and closed whenever it returns or raises an exception. Autommit and rollback rules work as normal.

Additional options

auto_flush: Sets the autoflush option on the SQLAlchemy session, defaults fo False

Executing tests
$ python setup.py test

Release files for Alchemytools 0.7.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 Alchemytools 0.7.0
File Size Uploaded
Alchemytools-0.7.0.tar.gz 3.7 kB Details

Release files / Alchemytools-0.7.0.tar.gz

Download URL Alchemytools-0.7.0.tar.gz
Size 3.7 kB
Tags Source
SHA-256 checksum
How to use checksums
3878a60c93904062432c99f9941cf924df66f9f51def25c2100db547d47dcf7c
BLAKE2b-256 checksum
How to use checksums
ddf516f12c3a1e82536f58646f77c5e752a62069f7d0431ff0a65483e7198433
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via Python-urllib/3.6

Release history Release notifications | RSS feed

This release

0.7.0 This release

1 release file

0.5.2

1 release file

0.5.1

1 release file

0.4

2 release files

0.3

1 release file

0.2

1 release file

0.1

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