let data:{
avatar: "/profile/b67a9b900e3a.png",
deptId: 100,
email: 123@163.com,
idcard: null,
idcardType: null,
identification: "1",
lang: "zh_CN",
sex: "1"
}
let keys = Object.keys(data);
let valsList = Object.values(data);
let valSql = "";
valsList.forEach((item, index)=>{
if (index === 0) {
valSql += `${item}`
}
else {
valSql += `,${item}`
}
})
let sql = `insert into ${table} (${keys.join(",")}) values (${valSql});`
按照以上代码,sqlite 插入用户信息提示报错
解决报错:
使用JSON.stringify把保存的value 转字符串后解决。。。
item = typeof item === 'string'?JSON.stringify(item):item;