python
from pony.orm import *
python
db = Database()
db.bind(provider='sqlite', filename='database.sqlite', create_db=True)
python
class User(db.Entity):
name = Required(str)
email = Required(str, unique=True)
age = Required(int)
python
db.generate_mapping(create_tables=True)
python
@db_session
def create_user(name, email, age):
user = User(name=name, email=email, age=age)
commit()
python
@db_session
def get_all_users():
users = select(u for u in User)
return users
python
@db_session
def update_user_email(user_id, new_email):
user = User.get(id=user_id)
user.email = new_email
commit()
python
@db_session
def delete_user(user_id):
User[user_id].delete()
commit()
