def test_delete_venue_found(self): self.venue_dao.delete(101, self.session) self.session.commit() rows = execute_select(db_filename, 'select * from venues where id = 101') self.assertEqual(0, len(rows))
def test_delete_act_found(self): self.act_dao.delete(303, self.session) self.session.commit() rows = execute_select(db_filename, 'select * from acts where id = 303') self.assertEqual(0, len(rows))
def test_delete_person_found(self): self.person_dao.delete("*****@*****.**", self.session) self.session.commit() rows = execute_select(db_filename, "select * from people where email = '*****@*****.**'") self.assertEqual(0, len(rows))
def test_delete_person_found(self): self.person_dao.delete('*****@*****.**', self.session) self.session.commit() rows = execute_select( db_filename, "select * from people where email = '*****@*****.**'") self.assertEqual(0, len(rows))
def test_add_act_ok(self): act = Act(id=399, title='Joey Alexander', notes='Giant Steps', act_type=1, year=2016) self.act_dao.add(act, self.session) self.session.commit() rows = execute_select(db_filename, 'select * from acts where id = 399') self.assertEqual('Joey Alexander', rows[0][2])
def test_add_venue_ok(self): venue = Venue(id=678, city='London', country='UK', latitude=51.5072, longitude=-0.1275, name='Royal Albert Hall', street_address='Kensington Gore, London SW7 2AP') self.venue_dao.add(venue, self.session) self.session.commit() rows = execute_select(db_filename, 'select * from venues where id = 678') self.assertEqual('Royal Albert Hall', rows[0][5])
def test_add_person_ok(self): person = Person(id=103, city='Wigan', country='UK', post_code='WG7 7FU', street='62 West Wallaby St', email='*****@*****.**', first_name='Wallace', middles='Peter', last_name='Sallis') self.person_dao.add(person, self.session) self.session.commit() rows = execute_select(db_filename, 'select * from people where id = 103') self.assertEqual('Wallace', rows[0][7])
def test_update_act_ok(self): act = Act(id=304, title='Wynton Marsalis', notes='My Favorite Things', act_type=2, year=2015) self.act_dao.update(act, self.session) self.session.commit() rows = execute_select(db_filename, 'select * from acts where id = 304') self.assertEqual('My Favorite Things', rows[0][1]) self.assertEqual('Wynton Marsalis', rows[0][2]) self.assertEqual(2, rows[0][3]) self.assertEqual(2015, rows[0][4])
def test_update_venue_ok(self): venue = Venue(id=678, city='London', country='United Kingdom', latitude=51.5072, longitude=-0.1275, name='Royal Albert Hall', street_address='Kensington Gore, London SW7 2AP') self.venue_dao.update(venue, self.session) self.session.commit() rows = execute_select(db_filename, 'select * from venues where id = 678') self.assertEqual('United Kingdom', rows[0][2])
def test_add_person_ok(self): person = Person( id=103, city="Wigan", country="UK", post_code="WG7 7FU", street="62 West Wallaby St", email="*****@*****.**", first_name="Wallace", middles="Peter", last_name="Sallis", ) self.person_dao.add(person, self.session) self.session.commit() rows = execute_select(db_filename, "select * from people where id = 103") self.assertEqual("Wallace", rows[0][7])
def test_add_user_ok(self): url = 'http://*****:*****@jazz.com", "middles": None, "address": { "country": "USA", "street": "5311 E 1st St", "city": "New York", "post_code": "10012", "state": "NY" }, "first_name": "Miles", "last_name": "Davis" } res = self.testapp.post_json(url, post_body, status=201) rows = execute_select(db_filename, "select * from people where email = '*****@*****.**'") self.assertEqual("Miles", rows[0][7])
def test_add_user_ok(self): url = 'http://*****:*****@jazz.com", "middles": None, "address": { "country": "USA", "street": "5311 E 1st St", "city": "New York", "post_code": "10012", "state": "NY" }, "first_name": "Miles", "last_name": "Davis" } res = self.testapp.post_json(url, post_body, status=201) rows = execute_select( db_filename, "select * from people where email = '*****@*****.**'") self.assertEqual("Miles", rows[0][7])
def test_update_user_ok(self): url = 'http://*****:*****@jazz.com", "middles": "William", "address": { "country": "USA", "street": "123 Cool St", "city": "Chicago", "post_code": "34568", "state": "IL" }, "first_name": "John", "last_name": "Coltrance" } res = self.testapp.put_json(url, put_body, status=202) rows = execute_select(db_filename, "select * from people where email = '*****@*****.**'") self.assertEqual("John", rows[0][7]) self.assertEqual("William", rows[0][9])
def test_update_user_ok(self): url = 'http://*****:*****@jazz.com", "middles": "William", "address": { "country": "USA", "street": "123 Cool St", "city": "Chicago", "post_code": "34568", "state": "IL" }, "first_name": "John", "last_name": "Coltrance" } res = self.testapp.put_json(url, put_body, status=202) rows = execute_select( db_filename, "select * from people where email = '*****@*****.**'") self.assertEqual("John", rows[0][7]) self.assertEqual("William", rows[0][9])