Example #1
0
 def test_add_activity(self):
     # Positive
     # Add user
     db = AmmDB(password)
     dur = random.randint(0, 10000)
     skil = random.randint(0, 4)
     nplayers = random.randint(0, 10000)
     db.add_activity('test_activity', skil,
                     datetime.datetime(2017, 4, 13, 18, 36, 49), dur,
                     nplayers, 0, 1, 25, 9, Decimal('0.0000'),
                     Decimal('0.0000'))
     observed = db.get_activity(name='test_activity',
                                skill=skil,
                                duration=dur,
                                numplayers=nplayers,
                                category=25,
                                available=1)
     #We have no way of determining id from add activity so we cannot check this against expected
     del (observed[0])['id']
     expected = ({
         'available': 1,
         'category': 25,
         'datetime': datetime.datetime(2017, 4, 13, 18, 36, 49),
         'duration': dur,
         'latitude': Decimal('0.0000'),
         'leader': 9,
         'longitude': Decimal(0.0000),
         'name': 'test_activity',
         'numplayers': nplayers,
         'private': 0,
         'skill': skil
     }, )
     self.assertEqual(observed, expected)
Example #2
0
    def test_get_user(self):
        # Positive
        db = AmmDB(password)
        passwd = b'$2b$12$Z2OaKVc39OH6duIxaKFnkefKztlq7oPiYpzdNHfSwQDvBRfFjVCJ6'
        observed = db.get_user(9,
                               fn='test',
                               email='*****@*****.**',
                               phone='5555555555',
                               ln='test',
                               uname='test',
                               operator='AND',
                               exact=False)
        expected = ({
            'suspension': None,
            'admin': 0,
            'uname': 'test',
            'passwd': passwd,
            'email': '*****@*****.**',
            'id': 9,
            'phone': '5555555555',
            'fn': 'test',
            'ln': 'test'
        }, )
        self.assertEqual(observed, expected)

        # Negative
        observed = db.get_user('-1', 'bad', '*****@*****.**', '-11111111', 'bad',
                               'bad', 'AND', False)
        expected = ()
        self.assertEqual(observed, expected)
Example #3
0
 def test_add_user(self):
     # Positive
     db = AmmDB()
     db.add_user('test', '*****@*****.**', 'test', 'test', 'test', 0, '1234567890')
     passwd = b'$2b$12$Z2OaKVc39OH6duIxaKFnkefKztlq7oPiYpzdNHfSwQDvBRfFjVCJ6'
     observed = db.get_user(9, 'test', '*****@*****.**', '1234567890', 'test', 'test', 'AND', False)
     expected = ({'suspension': None, 'admin': 0, 'email': '*****@*****.**', 'uname': 'test', 'passwd': passwd, 'id': 9, 'phone': '1234567890', 'ln': 'test', 'fn': 'test'},)
     self.assertEqual(observed, expected)
Example #4
0
    def test_get_activity_type(self):
        # positive
        db = AmmDB(self.password)
        observed = db.get_activity_type('25', 'Arts and Crafts', 'AND')
        expected = ({'id': 25, 'name': 'Arts and Crafts'},)
        self.assertEqual(observed, expected)

        # negative
        observed = db.get_activity_type('0', 'Invalid', 'AND')
        expected = ()
        self.assertEqual(observed, expected)
Example #5
0
    def test_get_activity_type(self):
        # positive
        db = AmmDB(password)
        observed = db.get_activity_type('25', 'Arts and Crafts', 'AND')
        expected = ({'id': 25, 'name': 'Arts and Crafts'}, )
        self.assertEqual(observed, expected)

        # negative
        observed = db.get_activity_type('0', 'Invalid', 'AND')
        expected = ()
        self.assertEqual(observed, expected)
Example #6
0
    def test_get_activity(self):
        # Positive
        db = AmmDB(self.password)
        observed = db.get_activity(1, 'testName', 4, 1, 3, 1, 25, 9, 'AND')
        expected = ({'id': 1, 'name': 'testName', 'numplayers': 3, 'available': 1, 'skill': 4, 'category': 25, 'longitude': Decimal('0.0000'), 'datetime': datetime.datetime(2017, 4, 13, 18, 36, 49), 'private': 0, 'latitude': Decimal('0.0000'), 'leader': 9, 'duration': 1},)
        self.assertEqual(observed, expected)

        # Negative
        observed = db.get_activity(0, 'badName', 4, 1, 3, 1, 25, 9, 'AND')
        expected = ()
        self.assertEqual(observed, expected)
Example #7
0
    def test_get_user(self):
        # Positive
        db = AmmDB(self.password)
        passwd = b'$2b$12$Z2OaKVc39OH6duIxaKFnkefKztlq7oPiYpzdNHfSwQDvBRfFjVCJ6'
        observed = db.get_user(9, fn='test', email='*****@*****.**', phone='5555555555', ln='test', uname='test', operator='AND', exact=False)
        expected = ({'suspension': None, 'admin': 0, 'uname': 'test', 'passwd': passwd, 'email': '*****@*****.**', 'id': 9, 'phone': '5555555555', 'fn': 'test', 'ln': 'test'},)
        self.assertEqual(observed, expected)

        # Negative
        observed = db.get_user('-1', 'bad', '*****@*****.**', '-11111111', 'bad', 'bad', 'AND', False)
        expected = ()
        self.assertEqual(observed, expected)
Example #8
0
    def test_get_user_activity(self):
        # Positive
        db = AmmDB()
        #looks like we are missing private_application in the DB
        #observed = db.get_user_activity(9, 25, '', 'AND')
        #expected = ()
        #self.assertEqual(observed, expected)

        # Negative
        observed = db.get_user_activity(-1, 25, '', 'AND')
        expected = ()
        self.assertEqual(observed, expected)
Example #9
0
 def test_add_activity(self):
     # Positive
     # Add user
     db = AmmDB(self.password)
     dur = random.randint(0, 10000)
     skil = random.randint(0,4)
     nplayers = random.randint(0, 10000)
     db.add_activity('test_activity', skil, datetime.datetime(2017, 4, 13, 18, 36, 49), dur, nplayers, 0, 1, 25, 9, Decimal('0.0000'), Decimal('0.0000'))
     observed = db.get_activity(name='test_activity', skill=skil, duration=dur, numplayers=nplayers, category=25, available=1)
     #We have no way of determining id from add activity so we cannot check this against expected
     del (observed[0])['id']
     expected = ({'available': 1, 'category': 25, 'datetime': datetime.datetime(2017, 4, 13, 18, 36, 49), 'duration': dur, 'latitude': Decimal('0.0000'), 'leader': 9, 'longitude': Decimal(0.0000), 'name': 'test_activity', 'numplayers': nplayers, 'private': 0, 'skill': skil},)
     self.assertEqual(observed, expected)
Example #10
0
    def test_add_user(self):
        # Positive
        db = AmmDB(self.password)
        usrname = str(random.randint(1000, 9999))
        mail = str(random.randint(1000, 9999)) + '@example.com'
        passwd = 'asdf'
        db.add_user(fn='test1', email=mail, uname=usrname, ln='test', passwd=passwd, admin=0, phone='5555555555')
        observed = db.check_uname_exist(usrname)
        self.assertTrue(observed)

        # Negative, add duplicate username, should not add
        observed = db.add_user(fn='test1', email='*****@*****.**', uname=usrname, ln='test', passwd=passwd, admin=0, phone='5555555555')
        expected = 'Username exists'
        self.assertTrue(observed, expected)
Example #11
0
    def test_edit_user(self):
        # Positive
        db = AmmDB(password)
        passwd = b'$2b$12$Z2OaKVc39OH6duIxaKFnkefKztlq7oPiYpzdNHfSwQDvBRfFjVCJ6'
        #random.seed()
        #randomfn = random.randint(1, 100)
        #randomln = random.randint(1, 100)
        db.edit_user(9, '*****@*****.**', 'test', 'test', passwd, '5555555555')
        observed = db.get_user(9, 'test', '*****@*****.**', '5555555555',
                               'test', 'test')
        expected = ({
            'admin': 0,
            'email': '*****@*****.**',
            'fn': 'test',
            'id': 9,
            'ln': 'test',
            'passwd':
            b'$2b$12$Z2OaKVc39OH6duIxaKFnkefKztlq7oPiYpzdNHfSwQDvBRfFjVCJ6',
            'phone': '5555555555',
            'suspension': None,
            'uname': 'test'
        }, )
        self.assertEqual(observed, expected)

        # Negative, trying to edit a user that does not exist
        db.edit_user(0, '*****@*****.**', 'test', 'test', passwd, '5555555555')
        observed = db.get_user(0, 'test', '*****@*****.**', '5555555555',
                               'test', 'test')
        expected = ()
        self.assertEqual(observed, expected)
Example #12
0
    def test_get_user_activity(self):
        # Positive
        db = AmmDB(password)
        #looks like we are missing private_application in the DB
        #we're not missing private_application, it was removed from UserActivity
        #a few weeks ago because it is not needed in UserActivity because private is
        #already stored in Activity, similarly to datetime from earlier
        observed = db.get_user_activity(9, 1, 'AND')
        expected = ({'activityid': 1, 'userid': 9}, )
        self.assertEqual(observed, expected)

        # Negative
        observed = db.get_user_activity(-1, 25, 'AND')
        expected = ()
        self.assertEqual(observed, expected)
Example #13
0
    def test_get_user_activity(self):
        # Positive
        db = AmmDB(self.password)
        #looks like we are missing private_application in the DB
        #we're not missing private_application, it was removed from UserActivity
        #a few weeks ago because it is not needed in UserActivity because private is
        #already stored in Activity, similarly to datetime from earlier
        observed = db.get_user_activity(9, 1, 'AND')
        expected = ({'activityid': 1, 'userid' : 9},)
        self.assertEqual(observed, expected)

        # Negative
        observed = db.get_user_activity(-1, 25, 'AND')
        expected = ()
        self.assertEqual(observed, expected)
Example #14
0
    def test_add_user(self):
        # Positive
        db = AmmDB(password)
        usrname = str(random.randint(1000, 9999))
        mail = str(random.randint(1000, 9999)) + '@example.com'
        passwd = 'asdf'
        db.add_user(fn='test1',
                    email=mail,
                    uname=usrname,
                    ln='test',
                    passwd=passwd,
                    admin=0,
                    phone='5555555555')
        observed = db.check_uname_exist(usrname)
        self.assertTrue(observed)

        # Negative, add duplicate username, should not add
        observed = db.add_user(fn='test1',
                               email='*****@*****.**',
                               uname=usrname,
                               ln='test',
                               passwd=passwd,
                               admin=0,
                               phone='5555555555')
        expected = 'Username exists'
        self.assertTrue(observed, expected)
Example #15
0
    def test_edit_user(self):
        # Positive
        db = AmmDB(self.password)
        passwd=b'$2b$12$Z2OaKVc39OH6duIxaKFnkefKztlq7oPiYpzdNHfSwQDvBRfFjVCJ6'
        #random.seed()
        #randomfn = random.randint(1, 100)
        #randomln = random.randint(1, 100)
        db.edit_user(9, '*****@*****.**', 'test', 'test', passwd, '5555555555')
        observed = db.get_user(9, 'test', '*****@*****.**', '5555555555', 'test', 'test')
        expected = ({'admin': 0,'email': '*****@*****.**','fn': 'test','id': 9,'ln': 'test','passwd': b'$2b$12$Z2OaKVc39OH6duIxaKFnkefKztlq7oPiYpzdNHfSwQDvBRfFjVCJ6','phone': '5555555555','suspension': None,'uname': 'test'},)
        self.assertEqual(observed, expected)

        # Negative, trying to edit a user that does not exist
        db.edit_user(0, '*****@*****.**', 'test', 'test', passwd, '5555555555')
        observed = db.get_user(0, 'test', '*****@*****.**', '5555555555', 'test', 'test')
        expected = ()
        self.assertEqual(observed, expected)
Example #16
0
    def test_get_where_stmnt(self):
        db = AmmDB(self.password)
        observed = db.get_where_stmnt("", "testCol", "testVal", "", 'like')
        expected = "WHERE testCol LIKE '%testVal%' "
        self.assertEqual(observed, expected)

        observed = db.get_where_stmnt("", "testCol", "testVal", "", '')
        expected = "WHERE testCol = 'testVal'"
        self.assertEqual(observed, expected)

        observed = db.get_where_stmnt("testWhere", "testCol", "testVal", ">", 'like')
        expected = " > testCol LIKE '%testVal%' "
        self.assertEqual(observed, expected)

        observed = db.get_where_stmnt("testWhere", "testCol", "testVal", ">", '')
        expected = " > testCol = 'testVal'"
        self.assertEqual(observed, expected)
Example #17
0
 def test_check_uname_exist(self):
     db = AmmDB(password)
     self.assertTrue(db.check_uname_exist("test"), True)
Example #18
0
 def test_check_email_exist(self):
     db = AmmDB(password)
     self.assertTrue(db.check_email_exist("*****@*****.**"), True)
Example #19
0
 def test_conn_check(self):
     db = AmmDB(password)
     self.assertFalse(db.conn.closed, self)
Example #20
0
 def test_check_email_exist(self):
     db = AmmDB(self.password)
     self.assertTrue(db.check_email_exist("*****@*****.**"), True)
Example #21
0
 def test_check_uname_exist(self):
     db = AmmDB(self.password)
     self.assertTrue(db.check_uname_exist("test"), True)