def save_to_db(self, publications):
storage = Storage()
storage.connect()
self.print_unicode(
u"Saving publications for author {0} - {1} to db...".format(
self.author_id, self.author_name))
map(
lambda publication: self.save_publication_to_db(
publication, storage), publications)
storage.disconnect()
def update_entry_in_db(self, publication, update_values):
publication_id = publication['ID']
publication_title = publication['Title']
self.print_unicode(
u"Updating publication {0} - {1} as in database...".format(
publication_id, publication_title))
storage = Storage()
storage.connect()
publications_table = meta.tables['ms_academic_publications']
query = sqlalchemy.update(publications_table).where(publications_table.c.publication_id == publication_id)\
.values(update_values)
print query
storage.execute(query)
storage.disconnect()
def save_to_db(self, authors):
storage = Storage()
storage.connect()
print "Saving authors to db..."
map(lambda author: self.save_author_to_db(author, storage), authors)
storage.disconnect()
