python
from pony.orm import *
db = Database()
class User(db.Entity):
name = Required(str)
db.bind(provider='sqlite', filename='database.sqlite', create_db=True)
db.generate_mapping(create_tables=True)
@db_session
def create_user(name):
user = User(name=name)
commit()
return user
create_user("Alice")
python
from pony.orm import *
db = Database()
class User(db.Entity):
name = Required(str)
db.bind(provider='sqlite', filename='database.sqlite', create_db=True)
db.generate_mapping(create_tables=True)
@db_session
def update_user_name(user_id, new_name):
with db_session:
user = User[user_id]
user.name = new_name
commit()
update_user_name(1, "Bob")
python
from pony.orm import *
db = Database()
class User(db.Entity):
name = Required(str)
db.bind(provider='sqlite', filename='database.sqlite', create_db=True)
db.generate_mapping(create_tables=True)
@db_session(isolation='serializable')
def read_user_name(user_id):
with db_session:
user = User[user_id]
return user.name
name = read_user_name(1)
