import time
import types
import utils
+import pg
from binary import Binary
################################################################################
"""
comments = []
- query = projectB.query(""" SELECT version, comment, author
+ query = projectB.query(""" SELECT version, comment, author, notedate
FROM new_comments
- WHERE package = '%s' """ % (package))
+ WHERE package = '%s'
+ ORDER BY notedate
+ """ % (package))
for row in query.getresult():
- comments.append("\nAuthor: %s\nVersion: %s\n\n%s\n" % (row[2], row[0], row[1]))
+ comments.append("\nAuthor: %s\nVersion: %s\nTimestamp: %s\n\n%s\n" % (row[2], row[0], row[3], row[1]))
comments.append("-"*72)
return comments
projectB.query(""" INSERT INTO new_comments (package, version, comment, author)
VALUES ('%s', '%s', '%s', '%s')
- """ % (package, version, comment, author) )
+ """ % (package, version, pg.escape_string(comment), pg.escape_string(author)))
return