Skip to main content

This module implements a simple ORM for basic operations in SQLite databases.

The module is derived from a working example of the active record pattern created by Chris Mitchell to supplement a talk given at the Oregon Academy of Sciences meeting on January 26, 2011.

The original example is published on GitHub as

https://github.com/ChrisTM/Active-Record-Example-for-a-Gradebook

and the code is understood to be freely available under the MIT license as above.

The original code has been modified so that

  • The column names in the selected table are obtained automatically by introspection of the database.
  • The primary key column is no longer required to be 'pk'.
  • Errors are reported via a dialog box.

Running gradebookExample.py demonstrates queries equivalent to Chris Mitchell's original tests.

More complex usage in conjunction with active-list-mc is demonstrated in TreeViewDbExampleAll.py. This program requires the Chinook database, chinook.db from which it uses the 'employees' table.

Metadata

Release files for active-record-mc 0.7.1

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

Source distribution (sdist)

Source distribution for active-record-mc 0.7.1
File Size Uploaded Provenance
active_record_mc-0.7.1.tar.gz 5.5 kB Without provenance Details

Built distribution (wheel)

Table of built distributions (wheels) for active-record-mc 0.7.1
File Interpreter ABI Platform
active_record_mc-0.7.1-py3-none-any.whl Python 3 none any Details

Total release size: 12.2 kB

Release files / active_record_mc-0.7.1.tar.gz

Download URL active_record_mc-0.7.1.tar.gz
Size 5.5 kB
Tags Source
SHA-256 checksum
How to use checksums
2f843938614187ecd60547519ee509ab61f45f8bc354e08833ccd60559a0b1f8
BLAKE2b-256 checksum
How to use checksums
1b1300d7892296c3e45975029fd08d101162d97a6f7e32a7108aa6c72109c162
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/5.0.0 CPython/3.12.3

Release files / active_record_mc-0.7.1-py3-none-any.whl

Download URL active_record_mc-0.7.1-py3-none-any.whl
Size 6.7 kB
Tags Python 3
SHA-256 checksum
How to use checksums
9345e4bb6fdbfe47a3fdc38f5eee8b948b87e3954ffe52115ad5e1a5877d2258
BLAKE2b-256 checksum
How to use checksums
542a3f3a401bfd7c4a2ff00c7aae7108d95fc69ff8bf793f779d5d7fe68dda41
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/5.0.0 CPython/3.12.3

Security for active-record-mc 0.7.1

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