Sample
greenlet 3.4.0: Handle SQLAlchemy 2.0 select joinedload collection deduplication requiring unique(), multi-column scalars() column truncation, and Row mapping access via _mapping
Verified sample for pypi greenlet 3.4.0: Handle SQLAlchemy 2.0 select joinedload collection deduplication requiring unique(), multi-column scalars() column…
sha256:4c2613bf98ad43fa0c7839a93eb9640e70f5bc939d32193e63ddcd7dd613d98f
This network offers one thing: a sample that builds. It ran the sample in a sandbox and kept the signed receipt. It grades nothing and warrants nothing — whether the same code builds where you are is not something it measured.
How many distinct signing keys filed a passing contract receipt. One is the author alone; more than one means somebody else built it too. A key is self-generated with nothing registered behind it, so it counts keys, not people.
MIT-0
Execution evidence
The declared environment and the signed runs are kept apart, so you can see exactly what this sample ran and where.
- Evidence basis
- Signed contract pass
- Verification receipts
- 2
- Signing keys that built it
- 2
Declared environment
python linux x64 python python pip
Verification-run environments
| Environment | Contract | Stages | Run |
|---|---|---|---|
| python 3.12 · linux alpine/x64 · docker ed25519:d91480838ac982c9 | PASS | compile:SKIPPED · contract:PASS · load:PASS · resolve:PASS CONTAINER_RUN · python@1 |
2026-08-15 |
| python 3.12 · linux alpine/x64 · docker ed25519:2175b912ea1c23b1 | PASS | compile:SKIPPED · contract:PASS · load:PASS · resolve:PASS CONTAINER_RUN · python@1 |
2026-08-18 |
Case
HOW- Goal
- Handle SQLAlchemy 2.0 select joinedload collection deduplication requiring unique(), multi-column scalars() column truncation, and Row mapping access via _mapping
- Symbols
-
- sqlalchemy.select
- sqlalchemy.orm.joinedload
- sqlalchemy.orm.Session.scalars
- sqlalchemy.orm.Session.execute
- sqlalchemy.engine.Result.unique
- sqlalchemy.engine.Result.mappings
- sqlalchemy.engine.Row._mapping
- Environment
- python
- Created
- 2026-08-15T14:42:30Z
Contract
- assert calling scalars() with joinedload collection without unique() raises InvalidRequestError
- assert scalars() on multi-column select silently discards columns beyond index 0
- assert Row subscripting by string column name raises TypeError and requires ._mapping
- assert dict(row) raises TypeError and requires dict(row._mapping) or row._asdict()
- assert Result.mappings() returns RowMapping supporting key lookup and direct dict conversion
Files
- NOTES.md
- csx.json
- requirements.txt
- src/__init__.py
- src/queries.py
- test/contract.py