1
# 父表插入记录出错,NotSupportedError: (NotSupportedError) 错误: 无法在关系"nodes"上执行INSERT RETURNING
# HINT: 您需要一个无条件, 且带有RETURNING子句的ON INSERT DO INSTEAD的规则.
model添加属性
__table_args__ = {'implicit_returning':False}
2
conn = db.engine.connect()
statement = '''
INSERT INTO nodes (
name, addr, status, category, area_id, vendor_id, model_id, snmp_port,
snmp_ver, snmp_comm, snmp_wcomm)
VALUES (
%(name)s, %(addr)s, %(status)s, %(category)s, %(area_id)s, %(vendor_id)s, %(model_id)s,
%(snmp_port)s, %(snmp_ver)s, %(snmp_comm)s, %(snmp_wcomm)s
)
'''
parameters = form.data
parameters.update(status=0)
conn.execute(statement,parameters)
db.session.commit()