python
from pony.orm import *
class Customer(db.Entity):
name = Required(str)
age = Required(int)
db = Database()
db.bind(provider='sqlite', filename='database.sqlite', create_db=True)
db.generate_mapping(create_tables=True)
with db_session:
query = select(c for c in Customer).order_by(Customer.age)
result = query[:]
for customer in result:
print(customer.name, customer.age)
python
with db_session:
query = select(c for c in Customer if c.age >= 18)
result = query[:]
for customer in result:
print(customer.name, customer.age)
