After developing the interface, we need to test the interface we developed. There are many methods for interface testing. You can use interface tools or Python to test. Tools such as Postman or Jmeter that we have learned before, and Python script testing can use Requests + unittest to test.
Test ideas
Functional testing: addition, deletion, modification and query of data
Abnormal testing: unauthorized, abnormal parameters, etc.
Postman test
The test results using the testing tool Postman are as follows:
user interface test
Query all users
Create user
Modify user
delete users
Unauthorized testing
groups interface test
Query all groups data
Modify group data
Delete groups
Requests + Unittest
Create a new test_unittest.py under the api directory. The code is implemented as follows:
tests_unittest.py
import requests
import unittest
class UserTest(unittest.TestCase):
def setUp(self):
self.base_url='http://127.0.0.1:8000/users'
self.auth=('51zxw','zxw20182018')
def test_get_user(self):
r=requests.get(self.base_url + '/1/',auth=self.auth)
result=r.json()
self.assertEqual(result['username'],'51zxw')
self.assertEqual(result['email'],'[email protected]')
def test_add_user(self):
form_data={'username':'zxw222','email':'[email protected]','groups':'http://127.0.0.1:8000/groups/2/'}
r=requests.post(self.base_url + '/',data=form_data,auth=self.auth)
result=r.json()
self.assertEqual(result['username'],'zxw222')
def test_delete_user(self):
r=requests.delete(self.base_url + '/11/',auth=self.auth)
self.assertEqual(r.status_code,204)
def test_update_user(self):
form_data={'email':'[email protected]'}
r=requests.patch(self.base_url + '/2/',auth=self.auth,data=form_data)
result=r.json()
self.assertEqual(result['email'],'[email protected]')
def test_no_auth(self):
r=requests.get(self.base_url)
result=r.json()
self.assertEqual(result['detail'],'Authentication credentials were not provided.')
class GroupTest(unittest.TestCase):
def setUp(self):
self.base_url='http://127.0.0.1:8000/groups'
self.auth=('51zxw','zxw20182018')
def test_group_developer(self):
r=requests.get(self.base_url + '/7/',auth=self.auth)
result=r.json()
self.assertEqual(result['name'],'Developer')
def test_add_group(self):
form_data={'name':'Pm'}
r=requests.post(self.base_url + '/',auth=self.auth,data=form_data)
result=r.json()
self.assertEqual(result['name'],'Pm')
def test_update_group(self):
form_data={'name':'Boss'}
r=requests.patch(self.base_url + '/6/',auth=self.auth,data=form_data)
result=r.json()
self.assertEqual(result['name'],'Boss')
def test_detele_group(self):
r=requests.delete(self.base_url + '/6/',auth=self.auth)
self.assertEqual(r.status_code,204)
if __name__ == '__main__':
unittest.main()
Django comes with test module
Open the tests file under the api directory and write the following test code
tests.py
from django.test import TestCase
import requests
# Create your tests here.
class UserTest(TestCase):
def setUp(self):
self.base_url='http://127.0.0.1:8000/users'
self.auth=('51zxw','xxxxx')
def test_get_user(self):
r=requests.get(self.base_url + '/1/',auth=self.auth)
result=r.json()
self.assertEqual(result['username'],'51zxw')
self.assertEqual(result['email'],'[email protected]')
# @unittest.skip('skip add user')
def test_add_user(self):
form_data={'username':'zxw222','email':'[email protected]','groups':'http://127.0.0.1:8000/groups/2/'}
r=requests.post(self.base_url + '/',data=form_data,auth=self.auth)
result=r.json()
self.assertEqual(result['username'],'zxw222')
# @unittest.skip('skip test_delete_user')
def test_delete_user(self):
r=requests.delete(self.base_url + '/11/',auth=self.auth)
self.assertEqual(r.status_code,204)
def test_update_user(self):
form_data={'email':'[email protected]'}
r=requests.patch(self.base_url + '/2/',auth=self.auth,data=form_data)
result=r.json()
self.assertEqual(result['email'],'[email protected]')
def test_user_already_exists(self):
form_data = {'username': 'zxw222', 'email': '[email protected]', 'groups': 'http://127.0.0.1:8000/groups/2/'}
r = requests.post(self.base_url + '/', data=form_data, auth=self.auth)
result = r.json()
#Expected return value: {"username":["A user with that username already exists."]}
self.assertEqual(result['username'][0], 'A user with that username already exists.')
def test_no_auth(self):
r=requests.get(self.base_url)
result=r.json()
self.assertEqual(result['detail'],'Authentication credentials were not provided.')
class GroupTest(TestCase):
def setUp(self):
self.base_url='http://127.0.0.1:8000/groups'
self.auth=('51zxw','xxxxxx')
def test_group_developer(self):
r=requests.get(self.base_url + '/3/',auth=self.auth)
result=r.json()
self.assertEqual(result['name'],'Pm')
# @unittest.skip('skip test_add_group')
def test_add_group(self):
form_data={'name':'Leader'}
r=requests.post(self.base_url + '/',auth=self.auth,data=form_data)
result=r.json()
self.assertEqual(result['name'],'Leader')
def test_update_group(self):
form_data={'name':'Boss'}
r=requests.patch(self.base_url + '/6/',auth=self.auth,data=form_data)
result=r.json()
self.assertEqual(result['name'],'Boss')
def test_detele_group(self):
r=requests.delete(self.base_url + '/6/',auth=self.auth)
self.assertEqual(r.status_code,204)
Running method: Open cmd and use the following command to run:
D:\django_restful>python manage.py test
The above command tests all use cases by default. If you want to test some use cases, you can use the following command:
Test the specified test class
D:\django_restful>python manage.py test api.tests.UserTest
Test a specific use case
D:\django_restful>python manage.py test api.tests.UserTest.test_get_user
Error reporting related
1. No write permission when migrating the database
File "C:\Users\jli75\AppData\Local\Programs\Python\Python37\lib\site-packages\MySQLdb\connections.py", line 280, in query
_mysql.connection.query(self, query)
django.db.utils.InternalError: (7, "Error on rename of '.\httprunnermanager\#sql-1178_7.frm' to '.\httprunnermanager\djcelery_taskstate.frm' (Errcode: 13 - Permission denied) ")
Reason: It may be that the anti-virus software solves this problem by preventing modification of the frm file. Resolve this issue by disabling on-access scanning in the antivirus threat protection advanced options and setting the antivirus to ignore these extensions
- The previous migration files
migrationswere not cleared when migrating the database.
File "C:\Users\jli75\AppData\Local\Programs\Python\Python37\lib\site-packages\MySQLdb\connections.py", line 280, in query
_mysql.connection.query(self, query)
_mysql_exceptions.OperationalError: (1050, "Table 'djcelery_crontabschedule' already exists")
Solution: Delete the migrations folder.
- setting configuration error
raise MigrationSchemaMissing("Unable to create the django_migrations table (%s)" % exc)
django.db.migrations.exceptions.MigrationSchemaMissing: Unable to create the django_migrations table ((1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(6 ) NOT NULL)' at line 1"))
Solution: Django2.1 no longer supports MySQL5.5 and must be version 5.6 or above. You can use the following command to view the current MySQL version.
mysql -V mysql Ver 8.0.1-dmr for Win64 on x86_64 (MySQL Community Server (GPL))
Study arrangements
As someone who has been there, I also hope that everyone will avoid some detours. If you don’t want to experience the feeling of not being able to find information, no one to answer questions, and giving up after a few days of study, here I will share with you some automation. The test learning resources hope to help you on your way forward. 【Guaranteed 100% Free】
How to obtain documents:
Join my software testing exchange group: 632880530 Get it for free~ (Academic exchanges with fellow experts, and live broadcasts every night to share technical knowledge points)
This document should be the most comprehensive and complete preparation warehouse for friends who want to engage in [software testing]. This warehouse has also accompanied me through the most difficult journey. I hope it can also help you!
All of the above can be shared. You only need to search the vx official account: Programmer Hugo to get it for free