擅长:python、mysql、java
<p>我有两张桌子,一张是隐形的另一张是客户信息。在本例中,userInfoId是clientInfo表中的forign键。所以我首先保存userInfo,然后用userInfo id保存clientInfo</p>
<p>在这里我使用烧瓶,棉花糖,烧瓶棉花糖,棉花糖sqlalchemy,sqlalchemy,flask sqlalchemy。在</p>
<p>我就是这样做的</p>
<pre><code>try:
userInfo = UserInfo(
userId=dataUserInfo['mobile'],
password=dataUserInfo['password'],
userTypeName='client')
db.session.add(userInfo)
db.session.commit() # save userInfo in database
dbUserInfoResult = userInfoDto.dump(userInfo).data # get userInfo id from database
print('dbUserInfoResult.data.id: ', dbUserInfoResult['id'])
clientInfo = ClientInfo(name=dataClintInfo['name'],
mobileCountryCode=dataClintInfo['mobileCountryCode'],
mobile=dataClintInfo['mobile'],
email=dataClintInfo['email'] if 'email' in dataClintInfo else None,
userInfoId=dbUserInfoResult['id'])
db.session.add(clientInfo)
db.session.commit()
except Exception:
db.session.rollback()
</code></pre>