kw_tools/choozmo/mail_list_imp_csv.py

import time
from cv2 import line
import dataset
import os
import codecs

db = dataset.connect('mysql://choozmo:pAssw0rd@db.ptt.cx:3306/seo?charset=utf8mb4')
table=db['mail_list']

fr=codecs.open(r'C:\Users\jared\Downloads\meettaipei.csv','r','utf-8')
lines=fr.readlines()
fr.close()

for l in lines:
    l=l.replace('\n','').replace('\r','')
    elmts=l.split(',')
    body={'title':elmts[0],'email':elmts[1],'enabled':1}
    print(body)
    table.insert(body)