Skip to main content

Opyration

SQL and Python should be simple right? Sometimes code is better than extensive explanation - see snippets below:

from opyration import Operation


pool = ...  # in production use an asyncpg|aiomysql Pool()


# example 1
op = Operation('customers', ...).select().where(location='California', age__gt=18)
await op.run()


# example 2
op = Operation('products', ...)
op.select()
op..where(username='; drop customers')
assert op.sql = 'SELECT * FROM products WHERE id = $1'

Installling

Install with pip

$ pip install opyration

More Examples


from opyration import Operation

op = Operation()
op.update(username='new username').where(id='1ea-455-bc0-88a')

# to run in sync mode use: op.runs()
await op.run()  # async

Contributing

For guidance on how to make contributions to opyration, see the Contribution Guidelines

Metadata

Release files for opyration 0.2.6

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for opyration 0.2.6
File Size Uploaded Provenance
opyration-0.2.6.tar.gz 4.3 kB Without provenance Details

Built distribution (wheel)

Table of built distributions (wheels) for opyration 0.2.6
File Interpreter ABI Platform
opyration-0.2.6-py3-none-any.whl Python 3 none any Details

Total release size: 10.1 kB

Release files / opyration-0.2.6.tar.gz

Download URL opyration-0.2.6.tar.gz
Size 4.3 kB
Tags Source
SHA-256 checksum
How to use checksums
843d3ad6a0d148b246fc31ef2d12eb6a44796e93ae7426c2e0520b43658dc738
BLAKE2b-256 checksum
How to use checksums
c71d6725353b8ba5a2473346f818f360a5f161965cf0fac12c7143c33b3c2597
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via poetry/2.1.3 CPython/3.12.3 Linux/6.14.0-32-generic

Release files / opyration-0.2.6-py3-none-any.whl

Download URL opyration-0.2.6-py3-none-any.whl
Size 5.8 kB
Tags Python 3
SHA-256 checksum
How to use checksums
d3b42ba918de41e2a32f96811626e4c9e71892d7eb1a21ac315f44796b7d92bb
BLAKE2b-256 checksum
How to use checksums
7016e5472759ae93e4af646d3e37c852f608e0a7bce8c643e1943b033c2313f8
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via poetry/2.1.3 CPython/3.12.3 Linux/6.14.0-32-generic

Security for opyration 0.2.6

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

No provenance found

None of the files in this release were uploaded with provenance metadata.

A note on package security

PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.

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