自定义数据库模板生成已有数据库
python manage.py inspectdb --database db_a > models2.py
class Usercbls(models.Model):
username = models.CharField(db_column='UserName', unique=True, max_length=50, blank=True, null=True) # Field name made lowercase.
cbjson = models.JSONField(db_column='CbJson', blank=True, null=True) # Field name made lowercase.
cbsubmittime = models.DateTimeField(db_column='cbSubmitTime', blank=True, null=True) # Field name made lowercase.
class Meta:
managed = False
db_table = 'usercbls'
加入using
Usercbls.objects.using('db_a').all()
前台post传入数据,需要json格式,对fd value转换为string
// 传递到后台,转为字符串进行传递
var fd ={
'bf':[$("#bfOne").val(),$("#bfTwo").val(),$("#bfThree").val(),$("#bfFour").val(),$("#bfFive").val(),$("#bfSix").val(),$("#bfSeven").val(),$("#bfEight").val(),$("#bfNine").val(),$("#bfTen").val()].toString(),
'cbrs':[$("#cbrsOne").val(),$("#cbrsTwo").val(),$("#cbrsThree").val(),$("#cbrsFour").val(),$("#cbrsFive").val(),$("#cbrsSix").val(),$("#cbrsSeven").val(),$("#cbrsEight").val(),$("#cbrsNine").val(),$("#cbrsTen").val()].toString(),
'username':username
}
$.ajax({
type : "post",
url : "indexPost",
dataType : "json", //返回数据形式为json
data : fd,
});
数据进行存储和更新
# 查询用户名是否已经存在
n = Usercbls.objects.using('db_a').filter(username=username)
if len(n) > 0:
# 获取数据并进行更新
oldU = Usercbls.objects.using('db_a').get(username=username)
oldU.cbjson = {'bf':'{}'.format(bf),'cbrs':'{}'.format(cbrs)}
oldU.cbsubmittime=getnowtime()
oldU.save(update_fields=['cbjson','cbsubmittime'],using='db_a')
elif len(n) == 0:
# 插入新数据
newU=Usercbls(username=username, cbjson={'bf':'{}'.format(bf),'cbrs':'{}'.format(cbrs)}, cbsubmittime=getnowtime())
newU.save(using='db_a')
官方参考使用
https://docs.djangoproject.com/zh-hans/3.2/topics/db/multi-db/
博客参考使用
https://www.cnblogs.com/zhangxinqi/p/9094953.html#_label2