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 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']