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)