数据库的字典转换成insert语句
ls = [(k, v) for k, v in dict_mailbox_info.items() if v is not None]
keys = ','.join([i[0] for i in ls])
values = ','.join(repr(i[1]) for i in ls)
sql = "insert into mailbox (" + keys + ") values (" + values + ")"
数据库的字典转换成insert语句
ls = [(k, v) for k, v in dict_mailbox_info.items() if v is not None]
keys = ','.join([i[0] for i in ls])
values = ','.join(repr(i[1]) for i in ls)
sql = "insert into mailbox (" + keys + ") values (" + values + ")"