from pony.ormimport *

db = Database()

class Person(db.Entity):

name = Required(str)

age = Required(int)

cars = Set('Car')

class Car(db.Entity):

make = Required(str)

model = Required(str)

owner = Required(Person)

# show(Person)

# show(Car)

db.bind(provider='postgres',user='postgres',password='rcc@123',host="127.0.0.1",database="allentestdb")

db.generate_mapping(create_tables=True)

set_sql_debug(True)

# p1 = Person(name='John', age=20)

# p2 = Person(name='Mary', age=22)

# p3 = Person(name='Bob', age=30)

# c1 = Car(make='Toyota', model='Prius', owner=p2)

# c2 = Car(make='Ford', model='Explorer', owner=p3)

# commit()

# @db_session

# def print_person_name(person_id):

#    p = Person[person_id]

#    print(p.name)

#

# @db_session

# def add_car(person_id, make, model):

#    Car(make=make,model=model, owner=Person[person_id])

#

#插入语句下面,使用db_session方式可以插入数据

with db_session:

p = Person(name='John', age=20)

Car(make='Audi', model='R8', owner=p)

p2 = Person(name='Mary', age=22)

Car(make='Toyota', model='Prius', owner=p2)

p3 = Person(name='Bob', age=30)

Car(make='Ford', model='Explorer', owner=p3)