##################################################################################
import Database as DB
import Parse as Parse
import csv
# Parse data from csv file
filename = 'Books/award_categories.csv'
f = open(filename, 'rU')
f.seek(0)
fields = ['id', 'name', 'type_id', 'order', 'note_id']
reader = csv.DictReader(f, dialect='excel-tab', fieldnames=fields)
data = []
for row in reader:
order = Parse.nullize(row['order'])
note_id = Parse.nullize(row['note_id'])
data.append( (row['id'], row['name'], row['type_id'], order, note_id) )
# Insert data into Database
# db = DB.Database('db4free.net','group8','toto123', 'cs322')
#
# sql = 'INSERT INTO Awards (id, title, date, type_id, category_id, note_id) VALUES (%s, %s, %s, %s, %s, %s);'
# db.insertMany(sql, to_db)
import Parse as Parse
import csv
# Parse data from csv file
filename = 'Books/webpages.csv'
f = open(filename, 'rU')
f.seek(0)
fields = ['id', 'author_id', 'publisher_id', 'url', 'publication_series_id', 'title_id', 'award_type_id', 'title_series_id', 'award_category_id']
reader = csv.DictReader(f, dialect='excel-tab', fieldnames=fields)
data = []
for row in reader:
author_id = Parse.nullize(row['author_id'])
publisher_id = Parse.nullize(row['publisher_id'])
publication_series_id = Parse.nullize(row['publication_series_id'])
title_id = Parse.nullize(row['title_id'])
award_type_id = Parse.nullize(row['award_type_id'])
title_series_id = Parse.nullize(row['title_series_id'])
award_category_id = Parse.nullize(row['award_category_id'])
url = Parse.nullize(row['url'])
data.append( (row['id'], author_id, publisher_id, publication_series_id, title_id, award_type_id, title_series_id, award_category_id, url) )
# Insert data into Database
# db = DB.Database('db4free.net','group8','toto123', 'cs322')
#
