#NEWLINE# def get_comments_by_id( self , bug_id ) : #NEWLINE# #INDENT# result = list ( [ ] ) #NEWLINE# cursor = self . sql_cnx . cursor ( ) #NEWLINE# when_row = 'bug_when' #NEWLINE# who_row = 'who' #NEWLINE# text_row = 'thetext' #NEWLINE# request = ( 'SELECT %s, %s, %s FROM longdescs WHERE bug_id = %s' % ( when_row , who_row , text_row , str ( bug_id ) ) ) #NEWLINE# cursor . execute ( request ) #NEWLINE# for row in request : #NEWLINE# #INDENT# comment = BzComment ( ( time . mktime ( row [ when_row ] . timetuple ( ) ) + ( 1e-06 * row [ when_row ] . microsecond ) ) ) #NEWLINE# comment . reporter = self . get_user_by_id ( row [ who_row ] ) #NEWLINE# comment . content = row [ text_row ] #NEWLINE# result . append ( comment ) #NEWLINE# #UNINDENT# return result