我用的數(shù)據(jù)庫版本太低，不能直接存入json，遂將原來json格式的文件轉換成字符串
并用python自帶的方法--eval()恢復成原樣
例如：將列表里套著的字典類型的做處理
mes = [{'alert_settings': {'sms': '1', 'email': '1'}, 'user_id': '1680700'},
{'alert_settings': {'sms': '1', 'email': '1'}, 'user_id': '2857376'},
{'alert_settings': {'sms': '1', 'email': '1'}, 'user_id': '2875386'},
{'alert_settings': {'sms': '1', 'email': '1'}, 'user_id': '2857422'},
{'alert_settings': {'sms': '1', 'email': '1'}, 'user_id': '2881725'},
{'alert_settings': {'sms': '1', 'email': '1', 'voice': '1'}, 'user_id': '2891742'},
{'alert_settings': {'sms': '1', 'email': '1', 'voice': '1'}, 'user_id': '2998655'},
{'alert_settings': {'sms': '1', 'email': '1', 'voice': '1'}, 'user_id': '3265624'},
{'alert_settings': {'sms': '1', 'email': '1', 'voice': '1'}, 'user_id': '33638732'},
{'alert_settings': {'sms': '1', 'email': '1', 'remind': '1', 'voice': '1', 'push': '1'},
'user_id': '3363750'}, {'alert_settings': {'sms': '1', 'email': '1', 'voice': '1'},
'user_id': '337923'}, {'alert_settings': {'voice': '1'}, 'user_id': '34833360'},
{'alert_settings': {'sms': '1', 'email': '1', 'voice': '1'}, 'user_id': '35545633'}]
# 將數(shù)據(jù)轉成字符串格式
str_mes = str(mes)
# 存數(shù)據(jù)庫用 LONGTEXT 這個格式存大文件
# 將數(shù)據(jù)庫拉下的數(shù)據(jù)用 mes_mysql表示 改格式后的數(shù)據(jù)用 new_mes_mysql表示
new_mes_mysql = eval(mes_mysql)
print(type(new_mes_mysql))
會發(fā)現(xiàn)格式是list 豺瘤，然后查看里邊的格式是dict
成功吆倦！
end
