shell
pip install pony
python
from pony import orm
db = orm.Database()
db.bind(provider='mysql', host='localhost', user='root', password='password', database='mydb')
db.generate_mapping(create_tables=True)
python
from pony.orm import *
class User(db.Entity):
id = PrimaryKey(int, auto=True)
name = Required(str)
age = Required(int)
db.generate_mapping(create_tables=True)
python
with db_session:
user = User(name='Alice', age=25)
with db_session:
users = select(u for u in User if u.age >= 18)[:10]
for user in users:
print(user.name, user.age)
with db_session:
user = User[1]
user.age = 26
with db_session:
user = User[1]
user.delete()
