sqlalchemy-login-models
User related data models for a server using SQLAlchemy, and json schemas.
- User class
- User Permissions
- User Settings
Installation
To ensure forward compatibility, the best way to install sqlalchemy-login-models is with make.
make install
JSON Schemas
alchemyjsonschema can convert the SQLAlchemy orm classes in this package into json schemas. To build the schemas, run:
make schemas
This will generate a schema for each table, and write them to sqlalchemy_login_models/schemas/<tablename>.json.
Signature Storage
This package comes with a tool for storing signatures related to the rows in your primary tables. If a row represents a record, then the corresponding signature row will be a signed copy of the same data. This feature can be used in auditing, constructing hash trees, or other proofs.
Example signature table for User
| id | data | user_id |
|---|---|---|
| 1 | "signed bitjws User1" | 1 |
| 2 | "signed bitjws User4" | 4 |
| 3 | "signed bitjws User7" | 7 |
Generate a signature class
The generator is a simple function that takes the declarative to be signed as an argument.
from sqlalchemy_login_models import generate_signature_class
from sqlalchemy_login_models.model import User
# this is a declarative class derived from Base, just like User
UserSig = generate_signature_class(User)
