For integration testing and the testing of endpoints I have previously indicated I am going to use a bash script of curl commands to achieve this. The first iteration of the script is given below:<\/p>\n\n\n\n
#!\/bin\/sh\n\n#URI's\nbaseURI=\"http:\/\/localhost:8080\/kupassessments\/\"\ncreate=\"account\/create\/\"\n\n#test the index url\nresponseIndexPage=$(curl --write-out \"%{http_code}\\n\" --silent --output \/dev\/null $baseURI) 2>\/dev\/null\n#test the creation of an account\nresponseAccountCreation=$(curl --write-out \"%{http_code}\\n\" --silent --data \"username=Boot&email=boot@r-a-w.org\" --output \/dev\/null $baseURI$create) 2>\/dev\/null\necho Bash Script Test of KUPassessments\n#result of testing the index page\necho Index Page response: $responseIndexPage\necho Create AccountResponse: $responseAccountCreation\n<\/code><\/pre>\n\n\n\nThe resulting output is:<\/p>\n\n\n\n
Bash Script Test of KUPassessments
Index Page response: 200
Create AccountResponse: 404<\/p>\n\n\n\n
The 404 is because the query does not contain any data. I also will have run a an SQL script to reset the database. <\/p>\n\n\n\n
The database is cleared using the following script ClearAccountTestingData.sql<\/p>\n\n\n\n
delete from accounts where username='boot';\n<\/code><\/pre>\n\n\n\nThis needs to be run each time the bash script starts to ensure that the database is in a state that is expected for the tests. However this needs the location of the script to be included. So it may be best to execute the the SQL from the testing bash script.<\/p>\n\n\n\n
Now I have noticed that the second error is not, in fact due to the data already existing but the fact that the request is incorrect. From searching round the request needs to be rewritten so it sends the request in json. <\/p>\n\n\n\n
<\/p>\n\n\n\n
resources:<\/h3>\n\n\n\n- https:\/\/www.shellhacks.com\/mysql-run-query-bash-script-linux-command-line\/<\/a><\/li><\/ul>\n\n\n\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
For integration testing and the testing of endpoints I have previously indicated I am going to use a bash script of curl commands to achieve this. The first iteration of the script is given below: The resulting output is: Bash Script Test of KUPassessments Index Page response: 200 Create AccountResponse: 404 The 404 is because … Continue reading KUP Assessments – Bash scripts to test endpoints<\/span>