Ejemplo n.º 1
0
    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))
Ejemplo n.º 2
0
    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))
Ejemplo n.º 3
0
    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))
Ejemplo n.º 4
0
    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))
Ejemplo n.º 5
0
    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])
Ejemplo n.º 6
0
    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))
Ejemplo n.º 7
0
    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])
Ejemplo n.º 8
0
    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])
Ejemplo n.º 9
0
    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])
Ejemplo n.º 10
0
    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])
Ejemplo n.º 11
0
    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])
Ejemplo n.º 12
0
    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])
Ejemplo n.º 14
0
    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])