http://www.cnblogs.com/evening/archive/2012/04/19/2457440.html
工作需要,将cvm.csv文件中的记录志入数据库, name, owner包含中文,python2.7仅支持unicode,所以文件中读出的中文需要解码(decode)一下,才能写入mysql数据库。
# file cvm.csv
cvm.csv: UTF-8 Unicode text
writedb.py
#!/usr/bin/env python
# -*- coding: utf-8 -*-
from app import db
from app.models import Server
import uuid
with open('cvm.csv', 'r') as f:
for line in f:
sn, name, public, private, owner = line.strip().split(',')
server = Server()
server.uuid = str(uuid.uuid4())
server.sn = sn.decode('utf-8')
server.name = name.decode('utf-8')
server.public = public
server.private = private
server.owner = owner.decode('utf-8')
db.session.add(server)
db.session.commit()