Skip to main content

ccflow-db

ccflow models for database access

Build Status codecov License PyPI

Overview

ccflow-db provides public, domain-neutral database callable models and publishers for ccflow workflows. It owns connection configuration, SQL execution, tabular reads, bulk writes, transaction handling, upsert/merge patterns, database-backed cache adapters, and Hydra config groups exposed through the lerna plugin entry point.

It should stay generic across domains and database backends. Domain schemas, provider-specific assumptions, and application deployment conventions belong outside this package.

Current Status

  • Implemented: package scaffold, version metadata, SQLiteConfig, parameterized SQLiteQueryModel, SQLiteKeyExistsModel, SQLiteTableWriteModel for append, replace, and primary-key upsert writes, byte-oriented SQLiteCacheStore for use with ccflow-etl cache format models, and the cache=sqlite config group.
  • Partial: SQLite uses the Python standard library as the first local backend; broad SQLAlchemy-style engine/session management and backend extras remain future work.
  • Missing: dataframe reads, chunked writes, dry-run SQL rendering, merge helpers beyond SQLite upsert, and non-SQLite integration tests.

Dependency Contract

  • Depends on ccflow for callable model and publisher interfaces.
  • Depends on ccflow-etl for cache format/result contracts.
  • Uses sqlite3 for the first local backend and may add a broader abstraction layer such as SQLAlchemy plus optional backend extras later.
  • Must not depend on finance packages or application-specific packages.

Test Convention

Default tests should use SQLite or in-memory database fixtures. Backend-specific tests such as Postgres should be opt-in and skipped unless the required environment variables are set.

Metadata

Release files for ccflow-db 0.1.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 ccflow-db 0.1.1
File Size Uploaded Provenance Actions
ccflow_db-0.1.1.tar.gz 12.0 kB Without provenance Details for ccflow_db-0.1.1.tar.gz

Built distribution (wheel)

Table of built distributions (wheels) for ccflow-db 0.1.1
File Interpreter ABI Platform Actions
ccflow_db-0.1.1-py3-none-any.whl Python 3 none any Details for ccflow_db-0.1.1-py3-none-any.whl

Total release size: 24.8 kB

Release files / ccflow_db-0.1.1.tar.gz

Download URL ccflow_db-0.1.1.tar.gz
Size 12.0 kB
Tags Source
SHA-256 checksum
How to use checksums
5a1d74ebc96eeca64ad8082c85df1391bcf36df694507889a52ab16cb701fb54
BLAKE2b-256 checksum
How to use checksums
cb8a6fdc9d346b639391360c8d2d1b62266e2e52834999782b9281f856a873bd
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/7.0.0 CPython/3.12.15

Release files / ccflow_db-0.1.1-py3-none-any.whl

Download URL ccflow_db-0.1.1-py3-none-any.whl
Size 12.8 kB
Tags Python 3
SHA-256 checksum
How to use checksums
e63f46bdca6a5bb75985ce5efd1b5fcacc7d1533076b1c689352e2f9124d128f
BLAKE2b-256 checksum
How to use checksums
4e0f66bb53a278074064ae17bb1635792e6a62c4ab6923f2bfd601ebf3502123
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/7.0.0 CPython/3.12.15

Security for ccflow-db 0.1.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.

To learn more about protecting yourself from malicious actors, visit our package security documentation.

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