async def persist(email: str, password_hash: str) -> User:
values = {"email": email, "password_hash": password_hash}
query = Model.insert().values(**values)
last_record_id = await database.execute(query)
return User.parse_obj({**values, "id": last_record_id})
async def fetch(id_: int) -> Optional[User]:
query = Model.select().where(Model.c.id == id_)
result = await database.fetch_one(query)
return User.parse_obj(dict(result)) if result else None
async def fetch_by_email(email: str) -> Optional[User]:
query = Model.select().where(Model.c.email == email)
result = await database.fetch_one(query)
return User.parse_obj(dict(result)) if result else None