halfORM
⚠️ BREAKING CHANGE in v0.18 — psycopg2 → psycopg 3
halfORM 0.18 drops psycopg2 and requires psycopg 3.
pip uninstall psycopg2-binary pip install "psycopg[binary]"If you use custom psycopg2 adapters in your own code, rewrite them with the psycopg 3
Dumper/LoaderAPI. See the full migration notes in CHANGELOG.md.psycopg2 users: the 0.17.x branch is maintained for psycopg2 and receives bug fixes.
halfORM is a database-first ORM for PostgreSQL. You write the schema in SQL; halfORM introspects it at runtime and gives you Python objects to work with your data. No migrations, no code generation.
The central idea: a Relation object is a predicate. It describes the
logical condition that rows must satisfy to belong to the relation. Its
extension — the set of rows that currently satisfy the predicate in the
database — is what you read, update, or delete.
Install
pip install half_orm
Configure
# ~/.half_orm/blog
[database]
name = blog
user = alice
password = secret
host = localhost
Usage
from half_orm.model import Model
blog = Model('blog')
Post = blog.get_relation_class('blog.post')
Author = blog.get_relation_class('blog.author')
# Insert
alice = Author(
first_name='Alice', last_name='Martin', email='alice@example.com'
).ho_insert()
# Query — Author(last_name='Martin') is the predicate "is an author named Martin"
for row in Author(last_name='Martin').ho_select('id', 'email'):
print(row)
# Update a singleton (predicate identifies exactly one row)
Author(id=alice['id']).ho_assert_is_singleton().ho_update(email='alice@newdomain.com')
# Delete
Author(id=alice['id']).ho_assert_is_singleton().ho_delete()
Documentation
License
halfORM is licensed under the GPL-3.0 license.
1 maintainer
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Filter files by name, interpreter, ABI, and platform.
If you're not sure about the file name format, learn more about wheel file names.
Copy a direct link to the current filters
File details
Details for the file half_orm-0.18.13.tar.gz.
File metadata
- Download URL: half_orm-0.18.13.tar.gz
- Upload date:
- Size: 65.6 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via:
twine/6.1.0 CPython/3.8.19
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
e660e163ea04bc5575feea8fca18de4f1afbfac15ec2a44badaeeb38f2b1ab45
|
|
| MD5 |
334702c3bc880233247a996a14a11eca
|
|
| BLAKE2b-256 |
ae079eecc4a74ec15cf6677c0e1e41dde6161538f9f851b095d1500d1127dc35
|
File details
Details for the file half_orm-0.18.13-py3-none-any.whl.
File metadata
- Download URL: half_orm-0.18.13-py3-none-any.whl
- Upload date:
- Size: 62.2 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via:
twine/6.1.0 CPython/3.8.19
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
0c3537856bd839882aed7b9d7a7d0faa5ce15ff2aedfc712979f6c04b9a5d24e
|
|
| MD5 |
63f8d65f99609d88019d2aaae3ebb81e
|
|
| BLAKE2b-256 |
e7a70e4e11c30e98e0e60ee2f2c24fe875f1ad79e3d4cf1bb8d487a194a2805b
|
