def setUp(self):
"""
Reads an arbitrary number of mail messages and
stores them in a brand new messages table.
"""
self.conn = msc.Connect(**loginInfo)
self.curs = self.conn.cursor()
self.curs.execute("DROP TABLE IF EXISTS {0}".format(TBLNM))
self.conn.commit()
curs.execute(TBLDEF)
conn.commit()
files = glob(FILESPEC)
self.msgIds = {} # Keyed by messageId
self.messageIds = {} # Keyed by id
self.msgdates = []
self.rowcount = 0
for f in files:
ff = open(f)
text = ff.read()
msg = message_from_string(text)
iD = self.msgIds[msg['message-id']] = maildb.store(msg, self.conn, self.curs, TBLNM)
self.messageIds[iD] = msg['message-id']
date = msg['date']
self.msgdates.append(datetime.datetime.fromtimestamp(mktime_tz(parsedate_tz(date))))
self.rowcount += 1 # Assuming no duplicated Message-IDs
ff.close()
def setUp(self):
"""
Reads an arbitrary number of mail messages and
stores them in a brand new messages table.
DANGER: Any existing message table WILL be lost.
"""
curs.execute("DROP TABLE IF EXISTS message")
conn.commit()
curs.execute(TBLDEF)
conn.commit()
files = glob(FILESPEC)
print(files)
self.msgids = {} # Keyed by message_id
self.message_ids = {} # keyed by id
self.msgdates = []
self.rowcount = 0
for f in files:
print("File is: ", f)
ff = open(f)
text = ff.read()
ff.close()
msg = message_from_string(text)
idx = self.msgids[msg['message-id']] = maildb.store(msg)
self.message_ids[id] = msg['message-id']
date = msg['date']
self.msgdates.append(datetime.datetime.fromtimestamp(mktime_tz(parsedate_tz(date))))
self.rowcount += 1 # assuming no duplicated Message-IDs
def setUp(self):
"""
Reads an arbitrary number of mail messages and
stores them in a brand new messages table.
DANGER: Any existing message table WILL be lost.
"""
curs.execute("DROP TABLE IF EXISTS message")
conn.commit()
curs.execute(TBLDEF)
conn.commit()
files = glob(FILESPEC)
self.msgids = {} # Keyed by message_id
self.message_ids = {} # keyed by id
self.msgdates = []
self.rowcount = 0
for f in files:
ff = open(f)
text = ff.read()
msg = message_from_string(text)
id = self.msgids[msg['message-id']] = maildb.store(msg)
self.message_ids[id] = msg['message-id']
date = msg['date']
self.msgdates.append(datetime.datetime.fromtimestamp(mktime_tz(parsedate_tz(date))))
self.rowcount += 1 # Assuming no duplicated Message-IDs
def setUp(self):
"""
Reads an arbitrary number of mail messages and
stores them in a brand new message table.
DANGER: Any existing message table WILL be lost.
"""
#print("just about to drop table...")
curs.execute("DROP TABLE IF EXISTS message")
conn.commit()
#print("table dropped")
#print("just about to execute TBLDEF")
#print("cursor: ", curs, " conn: ", conn)
curs.execute(TBLDEF)
conn.commit()
#print("TBLDEF executed")
#print("about to populate self.msgids and self.message_ids")
files = glob(FILESPEC)
self.msgids = {} # Keyed by message_id
self.message_ids = {} # Keyed by id
for f in files:
ff = open(f)
text = ff.read()
msg = message_from_string(text)
id = self.msgids[msg['message-id']] = maildb.store(msg)
self.message_ids[id] = msg['message-id']
#close(ff) # try this out to remove warning
print("last line of setUp()")
def setUp(self):
"""
Reads an arbitrary number of mail messages and
stores them in a brand new message table.
DANGER: Any existing message table WILL be lost.
"""
#print("just about to drop table...")
curs.execute("DROP TABLE IF EXISTS message")
conn.commit()
#print("table dropped")
#print("just about to execute TBLDEF")
#print("cursor: ", curs, " conn: ", conn)
curs.execute(TBLDEF)
conn.commit()
#print("TBLDEF executed")
#print("about to populate self.msgids and self.message_ids")
files = glob(FILESPEC)
self.msgids = {} # Keyed by message_id
self.message_ids = {} # Keyed by id
for f in files:
ff = open(f)
text = ff.read()
msg = message_from_string(text)
id = self.msgids[msg['message-id']] = maildb.store(msg)
self.message_ids[id] = msg['message-id']
#close(ff) # try this out to remove warning
print("last line of setUp()")
def setUp(self):
"""
Reads arbitrary number of email messages and stores them
in a brand new message table.
Destroys any previous table named message.
"""
curs.execute("DROP TABLE IF EXISTS message")
conn.commit()
print("preparing for committing TBLDEF")
curs.execute(TBLDEF)
conn.commit()
print("TBLDEF should be complete")
print("preparing for globFILESPEC")
files = glob(FILESPEC)
self.msgids = {}
self.message_ids = {}
for f in files:
ff = open(f)
text = ff.read()
msg = message_from_string(text)
print("gonna store msg...")
id = self.msgids[msg['message-id']] = maildb.store(msg)
self.message_ids[id] = msg['message-id']
print("maildb.store() run on messages, messages loaded...")
print("cursor commit run...")
def setUp(self):
"""
Reads an arbitrary number of mail messages and
stores them in a brand new messages table.
DANGER: Any existing message table WILL be lost.
"""
curs.execute("DROP TABLE IF EXISTS message")
conn.commit()
curs.execute(TBLDEF)
conn.commit()
self.msgids = {} # Keyed by message_id
self.message_ids = {} # keyed by id
self.msgdates = []
self.rowcount = 0
message_template = """
Date: {0}
From: [email protected]
To: {1}<{2}>
Message-Id: <{3}>
This is a test message.
"""
format_string = "%a, %d %b %Y %H:%M:%S %z"
msgDate = STARTTIME
delta = timedelta(1) # create a time delta of one day
msgid = make_msgid("com.example.oreilly.python")
for day in range(DAYCOUNT):
for msgRecipientName, msgRecipientAddress in RECIPIENTS:
text = message_template.format(msgDate.strftime(format_string),msgRecipientName,msgRecipientAddress, msgid )
print("text is :", text)
msg = message_from_string(text)
print("message is:", msg)
id = self.msgids[msg['message-id']] = maildb.store(msg)
self.message_ids[id] = msgid
self.rowcount += 1 #Assuming no duplicated Message-IDs
self.msgdates.append(msgDate)
msgDate = msgDate + delta #add the timedelta to date
def setUp(self):
"""
reads an arbitrary number of mail messages and
stores them in a brand new messages table.
Danger: any existing message table will be lost.
"""
curs.execute("drop table if exists message")
conn.commit()
curs.execute(TBLDEF)
conn.commit()
files = glob(FILESPEC)
self.msgids = {} #Keyed by message_id
self.message_ids = {} # keyed by id
for f in files:
srcfile = os.path.abspath(f)
print(srcfile)
shutil.copy(srcfile, 'V:\\workspace')
ff = open(f)
text = ff.read()
msg = message_from_string(text)
id = self.msgids[msg['message-id']] = maildb.store(msg)
self.message_ids[id] = msg['message-id']
def setUp(self):
"""
reads an arbitrary number of mail messages and
stores them in a brand new messages table.
Danger: any existing message table will be lost.
"""
curs.execute("drop table if exists message")
conn.commit()
curs.execute(TBLDEF)
conn.commit()
files = glob(FILESPEC)
self.msgids = {} #Keyed by message_id
self.message_ids = {} # keyed by id
for f in files:
srcfile = os.path.abspath(f)
print(srcfile)
shutil.copy(srcfile, 'V:\\workspace')
ff = open(f)
text = ff.read()
msg = message_from_string(text)
id = self.msgids[msg['message-id']] = maildb.store(msg)
self.message_ids[id] = msg['message-id']
