def test_us03_03():
execute_test('us03_03.ged', conn)
assert user_story_03.get_rows(conn) == [
('US03_T03_I01', '2000-01-01', '1990-01-01'),
('US03_T03_I02', '2000-01-01', '1990-01-01'),
('US03_T03_I03', '2000-01-01', '1990-01-01')
]
def test_us02_04():
execute_test('us02_04.ged', conn)
assert user_story_02.get_rows(conn) == [
('US02_T04_I01', '2000-01-01', '1000-01-01'),
('US02_T04_I02', '2000-01-01', '1000-01-01'),
('US02_T04_I03', '2000-01-01', '1000-01-01')
]
def test_us05_05():
execute_test('us05_05.ged', conn)
assert user_story_05.get_rows(conn) == [
('US05_T05_I02', '2000-01-01', '1990-01-01'),
('US05_T05_I04', '2000-01-01', '1990-01-01'),
('US05_T05_I06', '2000-01-01', '1990-01-01')
]
def main():
#set up the database
conn = sqlite3.connect('megatron.db')
reset_db(conn)
#fill the database with our entire test suite as one file first
execute_test('optimus_prime.ged', conn)
#instantiate all of our tests and fire them
stories = []
stories.append(us01.UserStory01())
stories.append(us02.UserStory02())
stories.append(us03.UserStory03())
stories.append(us04.UserStory04())
stories.append(us05.UserStory05())
stories.append(us06.UserStory06())
stories.append(us07.UserStory07())
stories.append(us08.UserStory08())
stories.append(us09.UserStory09())
stories.append(us10.UserStory10())
stories.append(us12.UserStory12())
stories.append(us13.UserStory13())
stories.append(us15.UserStory15())
stories.append(us16.UserStory16())
stories.append(us18.UserStory18())
stories.append(us21.UserStory21())
stories.append(us23.UserStory23())
stories.append(us24.UserStory24())
stories.append(us27.UserStory27())
stories.append(us28.UserStory28())
stories.append(us29.UserStory29())
stories.append(us30.UserStory30())
stories.append(us31.UserStory31())
stories.append(us32.UserStory32())
stories.append(us33.UserStory33())
stories.append(us34.UserStory34())
stories.append(us35.UserStory35())
stories.append(us36.UserStory36())
stories.append(us38.UserStory38())
stories.append(us39.UserStory39())
stories.append(us41.UserStory41())
stories.append(us42.UserStory42())
for story in stories:
story.fire(conn)
def test_us31_02():
execute_test('us31_02.ged', conn)
assert user_story_31.get_rows(conn) == [('US31_T02_I01', '58'),
('US31_T02_I02', '58')]
def test_us39_06():
execute_test('us39_06.ged', conn)
assert user_story_39.get_rows(conn) == []
def test_us09_02():
execute_test('us09_02.ged', conn)
assert user_story_09.get_rows(conn) == [('US09_T02_F01', 'US09_T02_I01',
'US09_T02_I02', 'Husband')]
def test_us38_05():
execute_test('us38_05.ged', conn)
assert user_story_38.get_rows(conn) == [('US38_T05_I01', '2000-12-05')]
def test_us35_02():
execute_test('us35_02.ged', conn)
assert user_story_35.get_rows(conn) == [('US35_T02_I01', '2018-11-01', '0')
]
def test_us12_03():
execute_test('us12_03.ged', conn)
assert user_story_12.get_rows(conn) == [('US12_T03_I02', 'US12_T03_I03')]
def test_us12_04():
execute_test('us12_04.ged', conn)
assert user_story_12.get_rows(conn) == [('US12_T04_I02', 'US12_T04_I03'),
('US12_T04_I02', 'US12_T04_I04'),
('US12_T04_I02', 'US12_T04_I05')]
def test_us30_03():
execute_test('us30_03.ged', conn)
assert user_story_30.get_rows(conn) == [('US30_T03_I01', ),('US30_T03_I02', )]
def test_us12_02():
execute_test('us12_02.ged', conn)
assert user_story_12.get_rows(conn) == []
def test_us30_02():
execute_test('us30_02.ged', conn)
assert user_story_30.get_rows(conn) == [('US30_T02_I01', )]
def test_us09_05():
execute_test('us09_05.ged', conn)
assert user_story_09.get_rows(conn) == [
('US09_T05_F01', 'US09_T05_I01', 'US09_T05_I03', 'Husband'),
('US09_T05_F01', 'US09_T05_I01', 'US09_T05_I02', 'Wife')
]
def test_us09_04():
execute_test('us09_04.ged', conn)
assert user_story_09.get_rows(conn) == [('US09_T04_F01', 'US09_T04_I01',
'US09_T04_I02', 'Wife')]
def test_us31_05():
execute_test('us31_05.ged', conn)
assert user_story_31.get_rows(conn) == []
def test_us28_02():
execute_test('us28_02.ged', conn)
assert user_story_28.get_rows(conn) == ['US28_T02_I01 (28)']
def test_us38_01():
execute_test('us38_01.ged', conn)
assert user_story_38.get_rows(conn) == []
def test_us28_03():
execute_test('us28_03.ged', conn)
assert user_story_28.get_rows(conn) == [
'US28_T03_I01 (28), US28_T03_I02 (27)',
'US28_T03_I03 (28), US28_T03_I04 (27)'
]
def test_US41_03():
execute_test('us41_03.ged', conn)
assert user_story_41.get_rows(conn) == [('1990-01-01')]
def test_us03_04():
execute_test('us03_04.ged', conn)
assert user_story_03.get_rows(conn) == []
def test_us35_03():
execute_test('us35_03.ged', conn)
assert user_story_35.get_rows(conn) == []
def test_us34_07():
execute_test('us34_07.ged',conn)
assert user_story_34.get_rows(conn) == [('US34_T07_I01','10','US34_T07_I02','50')]
def test_us28_05():
execute_test('us28_05.ged', conn)
assert user_story_28.get_rows(conn) == ['']
def test_us23_04():
execute_test('us23_04.ged', conn)
assert user_story_23.get_rows(conn) == [('US23_T04_I01', 'US23_T04_I02'),
('US23_T04_I01', 'US23_T04_I03'),
('US23_T04_I02', 'US23_T04_I03')]
def test_us34_06():
execute_test('us34_06.ged',conn)
assert user_story_34.get_rows(conn) == [('US34_T06_I01', '10', 'US34_T06_I02','50'),('US34_T06_I03', '50','US34_T06_I04','10')]
def test_us28_01():
execute_test('us28_01.ged', conn)
assert user_story_28.get_rows(conn) == [
'US28_T01_I01 (28), US28_T01_I02 (27)'
]
def test_us34_08():
execute_test('us34_08.ged',conn)
assert user_story_34.get_rows(conn) == []
def test_us39_01():
execute_test('us39_01.ged', conn)
assert user_story_39.get_rows(conn) == [('US39_T01_F01', '2000-12-05')]
