def setUp(self): table = "entries" db = "../fixtures/test_journal" conn = sqlite3.connect(db) self.ce = rdbrecord.CreateEntry(conn, table, db) self.re = rdbrecord.ReadEntry(conn, table, db) self.ue = rdbrecord.UpdateEntry(conn, table, db) self.de = rdbrecord.ReadEntry(conn, table, db)
def setUp(self): table = "entries" db = "../fixtures/test_journal" sg = sqlitemgr.SQLiteMgr(db) re = rdbrecord.ReadEntry(sg.make_conn(), table, db) self.first_head_comp = [(1, '2017-02-11'), (2, '2017-02-27'), (3, '2017-03-09'), (4, '2017-03-12'), (5, '2017-03-04'), \ (6, '2017-03-15'), (7, '2017-04-04'), (8, '2017-04-12')] self.second_head_comp = [(1, '2017-02-11'), (2, '2017-02-27'), (4, '2017-03-12'), (5, '2017-03-04'), (7, '2017-04-04')] re.head(8) self.first_head = [(i.entry_number, str(i.entry_date)) for i in re.entry_list] self.first_head_result = re.result del re.entry_list[2] del re.entry_list[4] re.head() # just use the default value for the argument to this method self.second_head = [(i.entry_number, str(i.entry_date)) for i in re.entry_list] self.second_head_result = re.result
def setUp(self): table = "entries" db = "../fixtures/test_journal" sg = sqlitemgr.SQLiteMgr(db) conn = sg.make_conn() self.entry_numbers_comp = [ 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15 ] self.re = rdbrecord.ReadEntry(conn, table, db) self.re.all() self.entries = self.re.entry_list self.all_result = self.re.result
def setUp(self): table = "entries" db = "../fixtures/test_journal" sg = sqlitemgr.SQLiteMgr(db) re = rdbrecord.ReadEntry(sg.make_conn(), table, db) self.first_tail_comp = [(8, '2017-04-12'), (9, '2017-04-20'), (10, '2017-04-22'), (11, '2017-04-30'), \ (12, '2017-05-04'), (13, '2017-05-12'), (14, '2017-06-15'), (15, '2017-06-22')] self.second_tail_comp = [(9, '2017-04-20'), (11, '2017-04-30'), (12, '2017-05-04'), (14, '2017-06-15'), (15, '2017-06-22')] re.tail(8) self.first_tail = [(i.entry_number, str(i.entry_date)) for i in re.entry_list] self.first_tail_result = re.result del re.entry_list[2] del re.entry_list[4] re.tail() # just use the default value for the argument to this method self.second_tail = [(i.entry_number, str(i.entry_date)) for i in re.entry_list] self.second_tail_result = re.result
"""
def setUp(self): table = "entries" db = "../fixtures/test_journal" sg = sqlitemgr.SQLiteMgr(db) sg2 = sqlitemgr.SQLiteMgr(db) conn = sg.make_conn() conn2 = sg2.make_conn() sm = sqliteminor.SQLiteMinor(conn2, table) re = rdbrecord.ReadEntry(conn, table, db) self.text_keywords_liberal_comp = [(1, '2017-02-11'), (2, '2017-02-27'), (3, '2017-03-09'), (5, '2017-03-15'), (6, '2017-03-15'), \ (9, '2017-04-20'), (11, '2017-04-30'), (12, '2017-05-04'), (14, '2017-06-15'), (15, '2017-06-22')] self.text_keywords_strict_comp = [(12, '2017-05-04')] self.date_member_comp = [(3, '2017-03-09'), (4, '2017-03-12'), (5, '2017-03-15'), (6, '2017-03-15')] self.date_search_comp = [(5, '2017-03-15'), (6, '2017-03-15')] """ Database searches """ re.entry_list = [ ] # clear out the entry_list to force ReadEntry to read from the database re.search(["entry_text", "entry_keywords"], ["%Odhinn%", "%Aesir%"]) self.text_keywords_liberal_db_result = re.result self.text_keywords_liberal_db = get_results(re.entry_list) re.entry_list = [] re.search(["entry_text", "entry_keywords"], ["%Odhinn%", "%Aesir%"], None, "has-all") self.text_keywords_strict_db_result = re.result self.text_keywords_strict_db = get_results(re.entry_list) re.entry_list = [] re.search("entry_date", "03", "month") self.date_member_db_result = re.result self.date_member_db = get_results(re.entry_list) re.entry_list = [] re.search(["entry_date"], ["2017-03-15"]) self.date_search_db_result = re.result self.date_search_db = get_results(re.entry_list) """ entry_list searches """ re.entry_list = setup_db_objects.populate_entry_object_list( sm) #re-populate the entry_list of the ReadEntry object with all #the entries from the database re.search(["entry_text", "entry_keywords"], ["Odhinn", "Aesir"]) self.text_keywords_liberal_el_result = re.result self.text_keywords_liberal_el = get_results(re.entry_list) re.entry_list = setup_db_objects.populate_entry_object_list(sm) re.search(["entry_text", "entry_keywords"], ["Odhinn", "Aesir"], None, "has-all") self.text_keywords_strict_el_result = re.result self.text_keywords_strict_el = get_results(re.entry_list) re.entry_list = setup_db_objects.populate_entry_object_list(sm) re.search("entry_date", "03", "month") self.date_member_el_result = re.result self.date_member_el = get_results(re.entry_list) re.entry_list = setup_db_objects.populate_entry_object_list(sm) re.search(["entry_date"], ["2017-03-15"]) self.date_search_el_result = re.result self.date_search_el = get_results(re.entry_list)
def setUp(self): table = "entries" db = "../fixtures/test_journal" sg = sqlitemgr.SQLiteMgr(db) conn = sg.make_conn() re = rdbrecord.ReadEntry(conn, table, db) """ range of entries by number tests """ self.first_range_call_comp = [(2, '2017-02-27'), (3, '2017-03-09'), (4, '2017-03-12'), (5, '2017-03-04'), (6, '2017-03-15'), \ (7, '2017-04-04'), (8, '2017-04-12'), (9, '2017-04-20')] self.second_range_call_comp = [(2, '2017-02-27'), (3, '2017-03-09'), (4, '2017-03-12'), (6, '2017-03-15'), (7, '2017-04-04'), (9, '2017-04-20')] re.range( "entry_number", 2, 9 ) # get a range of entries from the database of entry_numbers 2 thru 9 self.first_range_call = [(i.entry_number, str(i.entry_date)) for i in re.entry_list] self.first_range_call_result = re.result del re.entry_list[ 3] # delete a couple of entries from the ReadEntry object's entry_list del re.entry_list[5] re.range( "entry_number", 2, 9 ) # get a range of entries from ReadEntry object's entry_list of entry_numbers 2 thru 9 self.second_range_call = [(i.entry_number, str(i.entry_date)) for i in re.entry_list] self.second_range_call_result = re.result """ range of entries by date tests """ re.entry_list = [ ] # start over by clearing out the ReadEntry object's entry_list self.first_range_call_date_comp = [(3, '2017-03-09'), (4, '2017-03-12'), (6, '2017-03-15'), (7, '2017-04-04'), (8, '2017-04-12'), \ (9, '2017-04-20'), (10, '2017-04-22'), (11, '2017-04-30'), (12, '2017-05-04')] self.second_range_call_date_comp = [(3, '2017-03-09'), (4, '2017-03-12'), (6, '2017-03-15'), (8, '2017-04-12'), (9, '2017-04-20'), \ (10, '2017-04-22'), (12, '2017-05-04')] re.range("entry_date", "2017-03-09", "2017-05-05") self.first_range_call_date = [(i.entry_number, str(i.entry_date)) for i in re.entry_list] self.first_range_call_date_result = re.result del re.entry_list[3] del re.entry_list[6] re.range("entry_date", "2017-03-09", "2017-05-05") self.second_range_call_date = [(i.entry_number, str(i.entry_date)) for i in re.entry_list] self.second_range_call_date_result = re.result