The Python CRUD SDK for SiennaGridDB: it stores Sienna OpenAPI SDK objects
(power-openapi-models) in a SiennaGridDB SQLite database. Today it implements create
(insert); read, update and delete come next. It is not a general database client: use
SQLite directly for anything else. The SQL comes from the bundled insert manifest; this
package only binds values.
from power_openapi_models.document import read_document
import sienna_griddb_tools as griddb
conn = griddb.create_database("system.sqlite")
report = griddb.insert_document(conn, read_document("system.json"))
print(report.to_json()) # inserted / skipped_fields / unsupported- Fields GridDB has no column for yet are counted in
report.skipped_fields, not written. Passstrict=Trueto raise instead. - Cost payloads must be in
NATURAL_UNITS; the database rejects anything else. - CLI:
python3 -m sienna_griddb_tools build system.json system.sqlite. - A portfolio, its base system first, each with its time series:
griddb.insert_file(conn, "portfolio_dir"), orbuild portfolio_dir out.sqlite.