pip install pony
python
from pony.orm import *
class User(db.Entity):
id = PrimaryKey(int, auto=True)
name = Required(str)
email = Required(str, unique=True)
python
class Order(db.Entity):
id = PrimaryKey(int, auto=True)
user = Required(User)
# ...
python
db.bind(provider='sqlite', filename='database.sqlite', create_db=True)
python
db.generate_mapping(create_tables=True)