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