Exemple #1
0
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'