odm2datamodels is a Python package that provides a set of object-relational mapping (ORM) data models for the Observations Data Model Version 2.1. This data models are built of the SQLAlchemy and provide a convenient way of interfacing with an ODM2.1 database.
The primary is the ODM2DataModels class, which once instantiated, provides access to the set of ORM ODM2.1 data models and an instance of an ODM2Engine which provide utility function to perform basic Create, Read, Update, Delete operations as well are read execution of custom SQLQueries constructed using a SQLAlchemy Select object or Query Object
pip install odm2datamodels
The build files are also available on our github repository
Conda install is not presently supported, though we are looking to expand support to include Conda in the near future.
Presently very limited testing has been conducted and has primarily been through an implementation of a REST API with limited coverage of selected data models. Further expanding and automating testing is an area for future updates.
These data models have only been validated for a PostgreSQL database running a deployment of the ODM2.1 schema.