######################################################################## ### Parse the titles.csv file, and import data to the MySQL database ### ######################################################################## import Database as DB import Parse as Parse import csv # Parse data from csv file filename = '../CSV/titles_rem.csv' f = open(filename, 'rU') f.seek(0) fields = ['id', 'title', 'translator', 'synopsis', 'note_id', 'series_id', 'series_nb', 'story_length', 'story_type', 'parent', 'language_id', 'title_graphic'] reader = csv.DictReader(f, dialect='excel-tab', fieldnames=fields) data = [] for row in reader: title_graphic = Parse.booleanize2(row['title_graphic']) data.append( (row['id'], row['title'], row['translator'], row['synopsis'], row['note_id'], row['series_id'], row['series_nb'], row['story_length'], row['story_type'], row['parent'], row['language_id'], title_graphic) ) Parse.writeRows(data, 'titles')