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
% (package, version) ).getresult()
if not exists:
- return false
+ return False
else:
- return true
+ return True
def add_new_comment(package, version, comment, author):
"""
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