def add_address(): address = Address() address.a_position = f'正阳北路{random.randrange(10000)}号' # 实现逆序需要使用desc方法或者使用text()方法包裹负号的字段名 address.a_customer_id = Customer.query.order_by( Customer.id.desc()).first().id # address.a_customer_id = Customer.query.order_by(db.text('-id')).first().id db.session.add(address) db.session.commit() return 'add success'