Apply constraints before inserting and updating TinyDB records.

Method 1:

$ pip install tinydb-constraint 

Method 2:

• Clone the project from GitHub
• Get poetry and poetry install tinydb-constraint --path PATH/TO/TINYDB/CONSTRAINT

>>> from tinydb import TinyDB >>> from tinydb_constraint import ConstraintTable >>> from datetime import datetime >>> TinyDB.table_class = ConstraintTable >>> db = TinyDB('db.json') >>> db.set_schema({ ... 'record_id': int, ... 'modified': datetime ... }) >>> db.schema { 'record_id': Constraint(type_=int, unique=False, not_null=False), 'modified': Constraint(type_=datetime.datetime, unique=False, not_null=False) }

I haven't modified the serialization yet, so datetime type will actually produce datetime.isoformat(), and to set datetime, you have to pass a dateutil.parser.parse()-parsable string.

Database schema is also settable via Constraint object.

>>> from tinydb_constraint import Constraint >>> db.set_schema({ ... 'user_id': Constraint(type_=int, unique=True, not_null=True) ... })

If you want to disable certain string sanitization features, like stripping spaces or checking if string can be converted to datetime, this can be done by setting environmental variables.

TINYDB_SANITIZE=0 TINYDB_DATETIME=0 

• Add ForeignKey constraints.

• tinydb-viewer - View records generated from TinyDB and alike (e.g. list of dictionaries.)