def save(self, db):
# Do date conversion
if self.id: #Already exists in database
sql = "UPDATE feeds set url=%s, etag=%s, last_modified=%s, error=%s where id=%s"
else: #New feed
self.id = uuid.uuid1()
sql = "INSERT INTO feeds (url, etag, last_modified, error, id) VALUES (%s,%s,%s,%s,%s);"
self.execute(db, sql,
(self.url, self.etag, self.fixDate(self.lastModified),
self.error, self.id))
def save(self, db):
if not self.body and not self.title:
raise TypeError("A message must contain a body and/or title.")
self.body = self.body or ""
self.title = self.title or ""
if self.id: #Already exists in database
sql = """UPDATE messages set feed_id=%s, syndication_id=%s,
title=%s, body=%s, media_type=%s, created_at=%s, updated_at=%s
where id=%s"""
else: #New feed
self.id = uuid.uuid1()
sql = "INSERT INTO messages (" + self.FIELD_STRING + ") VALUES (%s,%s,%s,%s,%s,%s,%s,%s);"
args = (self.feedID, self.syndicationID, self.title,
self.body, self.mediaType, self.fixDate(self.createdAt),
self.fixDate(self.updatedAt), self.id)
self.execute(db, sql, args)
