Skip to main content

seamm_datastore

Project description

SEAMM Datastore

GitHub Actions Build Status codecov

This repository contains the SQLAlchemy models for the SEAMM datastore as well as some associated utilities such as dumping to JSON and checking permissions. These database models and permissions system were developed to be used inside a flask application context in the SEAMM Dashboard. However, you may use this package as a stand-alone (outside of flask) with limited permissions capabilities.

Quickstart

This package contains SQLAlchemy models for the SEAMM datastore. The following gives an example of how to connect to a database in memory. You can switch the database by providing a different database URI.

import seamm_datastore

# Create a database session
connection = seamm_datastore.connect("sqlite:///:memory:")

This will create a sqlite database stored in memory. Using initialize=True will result in a new database being created. You may substitute a different database URI in place of sqlite:///memory. When connecting to a database on disk, you will need to specify an additional argument, initialize=True, if creating a new database.

To login, use the login method. Your username is determined automatically by your username when running connect if initialize is True. An admin user is also create which you can use to login (username=admin, password=admin).

connection.login(username="YOUR_USERNAME", password="default")

To import a datastore at a particular location, do:

connection.import_datastore(FILEPATH)

To use the sample data in this repository,

jobs, projects = connection.import_datastore("seamm_datastore/data/Projects")

JSON data of the added jobs and projects will be returned.

The SEAMMDatastore class has bound database models and a SQLAlchemy session factory which you can work with. These can be interacted with the same as other sqlalchemy models. To retrieve jobs for which you have "read" permissions from the database, use the bound SQLAlchemy models:

jobs = connection.Job.permissions_query("read").all()

To dump to json:

from seamm_datastore.database.schema import JobSchema

# Create job schema
jobs_schema = JobSchema(many=True)

# To retrieve all users in db
all_jobs = connection.Job.permissions_query("read").all()

jobs_json = jobs_schema.dump(all_jobs)

Permissions

The SEAMM datastore has a permissions system built in using flask-authorize for authorization. This provides a "permissions" entry on each resource table (Jobs, Flowcharts, and Projects) where permissions for "owner", "group" and "world". The SEAMM datastore also has capabilities to set "special permissions" for users or groups on specific projects.

Permissions are not automatically enforced when working directly with database models. In the SEAMM Dashboard, permissions are enforced with authentication (verifying the user is who they say they are) using [flask-jwt-extended] and authorization using flask-authorize.

To use the permissions checking mechanisms of flask authorize outside of a flask app, use the helper function here seamm_datastore.SEAMMDatastore.

Copyright

Copyright (c) 2021, Jessica A. Nash (The Molecular Sciences Software Institute)

Acknowledgements

Project based on the Computational Molecular Science Python Cookiecutter version 1.5.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

seamm_datastore-2024.6.2.tar.gz (95.9 kB view details)

Uploaded Source

Built Distribution

seamm_datastore-2024.6.2-py2.py3-none-any.whl (90.2 kB view details)

Uploaded Python 2 Python 3

File details

Details for the file seamm_datastore-2024.6.2.tar.gz.

File metadata

  • Download URL: seamm_datastore-2024.6.2.tar.gz
  • Upload date:
  • Size: 95.9 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/5.0.0 CPython/3.12.3

File hashes

Hashes for seamm_datastore-2024.6.2.tar.gz
Algorithm Hash digest
SHA256 d1eb0d0a1909b4670c3115c2bb82522a30e0302a525e23d1b97fca6632478492
MD5 583b4d45b52d3542ebd00c1367839620
BLAKE2b-256 3fafe11e20876aba446e81b60872ba9214fc4990a4a63b915c40c4691ed5ab5e

See more details on using hashes here.

File details

Details for the file seamm_datastore-2024.6.2-py2.py3-none-any.whl.

File metadata

File hashes

Hashes for seamm_datastore-2024.6.2-py2.py3-none-any.whl
Algorithm Hash digest
SHA256 337829b17e8b598831784fa071321b6b7ade5bd818f94503ff14ed451e335268
MD5 ce39cc041e52dfd8090448238c37fd94
BLAKE2b-256 907d4e6f6838df470b6341eb8abdf6e8381c9b2d9b5ef140647742d220aa31a1

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page