def imapPage():
#folder = request.args.get('folder','')
#if (folder == ''):
# folder="All Mail"
email = request.cookies.get('email')
accesskey = request.cookies.get('ak')
if email != "" and accesskey != "":
try:
server = IMAPClient('imap.gmail.com', use_uid=True, ssl=True)
server.oauth2_login(email, accesskey)
except Exception, e:
print "oauth2_login ERROR??"
print e.__doc__
print e.message
return "oauth2_login Error. Remove cookies and try again"
#GET FOLDERS
folders = server.list_folders()
stri="";
for folderx in folders:
print folderx
if 'SPAM' not in folderx[2].upper() and 'JUNK' not in folderx[2].upper() and folderx[2].upper()!='[GMAIL]':
print "entered"
folder=folderx[2]
stri = stri + "\n"+str(folderx[0])+'|'+str(folderx[1])+'|'+str(folderx[2]);
select_info = 0
try:
select_info = server.select_folder(folder, readonly=True)
except Exception, e:
print "MAILBOX ERROR??"
print e.__doc__
print e.message
continue
#print select_info
#messages = server.search(['SINCE 05-Feb-2014 NOT FROM \"facebook\"'])
messages = server.search(['SINCE 17-Feb-2014'])
#print "-"
#print messages
#print "-"
response = server.fetch(messages, ['X-GM-MSGID', 'X-GM-THRID', 'FLAGS', 'INTERNALDATE', 'ENVELOPE'])
for msgid, data in response.iteritems():
#print "==========="
#print data['FLAGS']
#print data['INTERNALDATE']
#print data['ENVELOPE']
#print data['BODY[HEADER]']
'''
The fields of the envelope structure are in the following order: date, subject, from, sender, reply-to, to, cc, bcc, in-reply-to, and message-id.
The date, subject, in-reply-to, and message-id fields are strings.
The from, sender, reply-to, to, cc, and bcc fields are parenthesized lists of address structures.
'''
##
#Making proper data structure for Envelope
##
env = {}
env['date']= data['ENVELOPE'][0]
env['subject']= data['ENVELOPE'][1]
env['in-reply-to']= data['ENVELOPE'][8]
env['message-id']= data['ENVELOPE'][9]
env['from']= ParseAddressStructure(data['ENVELOPE'][2])
env['sender']= ParseAddressStructure(data['ENVELOPE'][3])
env['reply-to']= ParseAddressStructure(data['ENVELOPE'][4])
env['to']= ParseAddressStructure(data['ENVELOPE'][5])
env['cc']= ParseAddressStructure(data['ENVELOPE'][6])
env['bcc']= ParseAddressStructure(data['ENVELOPE'][7])
em = Email(email, data['X-GM-MSGID'],data['X-GM-THRID'],env['subject'], data['INTERNALDATE'], env['in-reply-to'])
try:
db.session.add(em)
db.session.flush()
except IntegrityError:
db.session.rollback()
#print "Duplicate Ignored\n"
addEmailAddrToDd(db, email, data['X-GM-MSGID'], 'from', env['from'] )
addEmailAddrToDd(db, email, data['X-GM-MSGID'], 'sender', env['sender'] )
addEmailAddrToDd(db, email, data['X-GM-MSGID'], 'reply-to', env['reply-to'] )
addEmailAddrToDd(db, email, data['X-GM-MSGID'], 'to', env['to'] )
addEmailAddrToDd(db, email, data['X-GM-MSGID'], 'cc', env['cc'] )
addEmailAddrToDd(db, email, data['X-GM-MSGID'], 'bcc', env['bcc'] )
# Or for parsing headers in a string, use:
#headers = Parser().parsestr(data['BODY[HEADER]'])
# Now the header items can be accessed as a dictionary:
#print 'To: %s' % headers['to']
#print 'From: %s' % headers['from']
#print 'Subject: %s' % headers['Subject']
#print 'Date: %s' % headers['date']
#print "+++++++"
db.session.commit()
