def query(self, query_string):
""" get all the rows in the db """
self.cursor.execute(query_string)
result_list = self.cursor.fetchall()
for r in result_list:
date = r['first_date']
subj = r['subject']
body = r['message_body']
text = subj + ' ' + body
node = GnomeDataObject(GnomeDataObject.MAIL)
node.setDate(date)
node.setEvent(text)
node.setRSN(-1) #-1 indicates no RSN retrieved
self.store_tokens(node)
self.cursor.close()
def parse_line(self):
""" parse the entries in the log file, add them to the list of GDOs"""
#entries = self.f.getElementsByTagName('logentry')
iter = self.f.getiterator('logentry')
for entry in iter:
revNum = entry.attrib.get('revision')
strdate = entry.find('date').text
strdate = strdate[0:19] #this removes the milliseconds and TZ info
date = datetime.strptime(strdate, '%Y-%m-%dT%H:%M:%S')
try:
msg = entry.find('msg').text
except AttributeError:
msg = ""
n = GnomeDataObject(GnomeDataObject.SVN)
n.setDate(date)
n.setRSN(revNum)
n.setEvent(msg)
self.store_tokens(n)
def startElement(self, name, attrs):
self.current = name
if name == "bug_id": # the high-level element
self.isBugId = True
if name == "comment":
self.isComment = True
self.saveLine = ""
if self.isProduct:
self.gdo = GnomeDataObject(GnomeDataObject.BUG) # a new GDO
self.gdo.setRSN(
self.bug_number) # approximate, might be off by a few
if name == 'product':
pass
if name == 'text':
self.buffer = '' #an empty buffer for each text element
if name == 'bug_when':
self.buffer = '' #an empty buffer for each text element
