######################################################################## ### 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')
#!/usr/bin/env python # coding=utf-8 __author__ = 'Alexandre Connat' ######################################################################## ### Parse the awards.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/awards_rem.csv' f = open(filename, 'rU') f.seek(0) fields = ['id', 'title', 'date', 'type_code', 'type_id', 'category_id', 'note_id'] reader = csv.DictReader(f, dialect='excel-tab', fieldnames=fields) #here we omit type code because that we want as end input of load data data = [] for row in reader: data.append( (row['id'], row['title'], row['date'], row['type_id'], row['category_id'], row['note_id']) ) Parse.writeRows(data, 'awards')