Project Date
moviegram-test 09 Jan 2024, 15:56

Tag Report

Steps Scenarios Features
Tag Passed Failed Skipped Pending Undefined Total Passed Failed Total Duration Status
@smoke 290 0 0 0 0 290 12 0 12 18.141 Passed
Tags: @smoke
7.503
* print 'test' 0.001
15:56:31.631 karate.env system property was: qa 
15:56:31.635 [print] test 
* def deletereview = call read('classpath:tests/services/reviewdelete.feature') 1.224
tests/services/reviewdelete.feature 0.000
> * print 'Inside get review service' 0.001
15:56:31.651 [print] Inside get review service 
> Given url baseUrl + 'deletereviews?revid=' + revid 0.010
> And header Cookie = 'JSESSIONID=' + sessionvalue + '; Domain=localhost' 0.000
> When method delete 1.198
15:56:32.530 request:
1 > DELETE http://localhost:8085/deletereviews?revid=20
1 > Cookie: JSESSIONID=; Domain=localhost
1 > Host: localhost:8085
1 > Connection: Keep-Alive
1 > User-Agent: Apache-HttpClient/4.5.13 (Java/1.8.0_231)
1 > Accept-Encoding: gzip,deflate


15:56:32.855 response time in milliseconds: 287
1 < 200
1 < Vary: Origin
1 < Vary: Access-Control-Request-Method
1 < Vary: Access-Control-Request-Headers
1 < Content-Type: text/plain;charset=UTF-8
1 < Content-Length: 33
1 < Date: Tue, 09 Jan 2024 22:56:32 GMT
1 < Keep-Alive: timeout=60
1 < Connection: keep-alive
1 < Set-Cookie: JSESSIONID=2A07EC9F7A6FC5B371D0F7BDE0E8C929; Domain=localhost
This is not your review to delete
> Then status 200 0.000
* karate.log(deletereview) 0.003
15:56:32.864 {
  "baseUrl": "http://localhost:8085/",
  "responseHeaders": {
    "Vary": [
      "Origin",
      "Access-Control-Request-Method",
      "Access-Control-Request-Headers"
    ],
    "Content-Type": [
      "text/plain;charset=UTF-8"
    ],
    "Content-Length": [
      "33"
    ],
    "Date": [
      "Tue, 09 Jan 2024 22:56:32 GMT"
    ],
    "Keep-Alive": [
      "timeout=60"
    ],
    "Connection": [
      "keep-alive"
    ],
    "Set-Cookie": [
      "JSESSIONID=2A07EC9F7A6FC5B371D0F7BDE0E8C929; Domain=localhost"
    ]
  },
  "DbUtils": "util.DBUtils",
  "response": "This is not your review to delete",
  "dbconfig": {
    "username": "sbarlowc_iClient",
    "password": "B0ttle5@",
    "url": "jdbc:mysql://samuelrbarlow.com:3306/sbarlowc_Moviegram_QA",
    "driverClassName": "com.mysql.jdbc.Driver"
  },
  "smoke": [
    {
      "Scenario": "Login Happy Path",
      "revid": "20",
      "respStatus": "200",
      "failedrevdelete": "This is not your review to delete",
      "usernamefore2e": "testuserc",
      "passwordfore2e": "test",
      "fullnamefore2e": "Test%20User",
      "imdbid": "tt11858890",
      "revrating": "2.0",
      "revdesc": "It was okay actually"
    }
  ],
  "responseStatus": 200,
  "db": "util.DBUtils@17b0a5cd",
  "sessionvalue": ""
}
 
* karate.log(deletereview.responseHeaders) 0.002
15:56:32.866 {
  "Vary": [
    "Origin",
    "Access-Control-Request-Method",
    "Access-Control-Request-Headers"
  ],
  "Content-Type": [
    "text/plain;charset=UTF-8"
  ],
  "Content-Length": [
    "33"
  ],
  "Date": [
    "Tue, 09 Jan 2024 22:56:32 GMT"
  ],
  "Keep-Alive": [
    "timeout=60"
  ],
  "Connection": [
    "keep-alive"
  ],
  "Set-Cookie": [
    "JSESSIONID=2A07EC9F7A6FC5B371D0F7BDE0E8C929; Domain=localhost"
  ]
}
 
* karate.log(sessionvalue) 0.001
15:56:32.868  
* def sessionvalue = deletereview.responseHeaders['Set-Cookie'][0].split('=')[1].split(';')[0].trim() 0.046
15:56:32.868 over-writing existing variable 'sessionvalue' with new value: deletereview.responseHeaders['Set-Cookie'][0].split('=')[1].split(';')[0].trim()
* assert deletereview.responseStatus == respStatus 0.000
* assert deletereview.response == failedrevdelete 0.000
* def sessioncheck = call read('classpath:tests/services/sessioncheck.feature') 0.018
tests/services/sessioncheck.feature 0.000
> * print 'Inside get review service' 0.001
15:56:32.926 [print] Inside get review service 
> Given url baseUrl + 'session' 0.000
> And header Cookie = 'JSESSIONID=' + sessionvalue + '; Domain=localhost' 0.001
> When method get 0.006
15:56:32.930 request:
1 > GET http://localhost:8085/session
1 > Cookie: JSESSIONID=2A07EC9F7A6FC5B371D0F7BDE0E8C929; Domain=localhost
1 > Host: localhost:8085
1 > Connection: Keep-Alive
1 > User-Agent: Apache-HttpClient/4.5.13 (Java/1.8.0_231)
1 > Accept-Encoding: gzip,deflate


15:56:32.934 response time in milliseconds: 3
1 < 200
1 < Vary: Origin
1 < Vary: Access-Control-Request-Method
1 < Vary: Access-Control-Request-Headers
1 < Content-Length: 0
1 < Date: Tue, 09 Jan 2024 22:56:32 GMT
1 < Keep-Alive: timeout=60
1 < Connection: keep-alive

> Then status 200 0.000
* karate.log(sessioncheck.response) 0.001
15:56:32.936  
* assert sessioncheck.responseStatus == respStatus 0.000
* match sessioncheck.response == '' 0.006
* def register = call read('classpath:tests/services/sessionregister.feature') 0.328
tests/services/sessionregister.feature 0.000
> * print 'Inside get review service' 0.000
15:56:32.953 [print] Inside get review service 
> Given url baseUrl + 'register?username=' + usernamefore2e + '&password=' + passwordfore2e + '&fullname=' + fullnamefore2e + '&aboutme=undefined' 0.001
> And header Cookie = 'JSESSIONID=' + sessionvalue + '; Domain=localhost' 0.000
> When method post 0.317
15:56:32.956 request:
1 > POST http://localhost:8085/register?username=testuserc&password=test&fullname=Test%20User&aboutme=undefined
1 > Cookie: JSESSIONID=2A07EC9F7A6FC5B371D0F7BDE0E8C929; Domain=localhost
1 > Host: localhost:8085
1 > Connection: Keep-Alive
1 > User-Agent: Apache-HttpClient/4.5.13 (Java/1.8.0_231)
1 > Accept-Encoding: gzip,deflate


15:56:33.272 response time in milliseconds: 316
1 < 200
1 < Vary: Origin
1 < Vary: Access-Control-Request-Method
1 < Vary: Access-Control-Request-Headers
1 < Content-Length: 0
1 < Date: Tue, 09 Jan 2024 22:56:32 GMT
1 < Keep-Alive: timeout=60
1 < Connection: keep-alive

> Then status 200 0.000
* karate.log(register.response) 0.001
15:56:33.274  
* assert register.responseStatus == respStatus 0.000
* def login = call read('classpath:tests/services/sessionlogin.feature') 0.148
tests/services/sessionlogin.feature 0.000
> * print 'Inside get review service' 0.000
15:56:33.280 [print] Inside get review service 
> Given url baseUrl + 'login?username=' + usernamefore2e + '&password=' + passwordfore2e 0.000
> And header Cookie = 'JSESSIONID=' + sessionvalue + '; Domain=localhost' 0.000
> When method post 0.142
15:56:33.282 request:
1 > POST http://localhost:8085/login?username=testuserc&password=test
1 > Cookie: JSESSIONID=2A07EC9F7A6FC5B371D0F7BDE0E8C929; Domain=localhost
1 > Host: localhost:8085
1 > Connection: Keep-Alive
1 > User-Agent: Apache-HttpClient/4.5.13 (Java/1.8.0_231)
1 > Accept-Encoding: gzip,deflate


15:56:33.422 response time in milliseconds: 139
1 < 200
1 < Vary: Origin
1 < Vary: Access-Control-Request-Method
1 < Vary: Access-Control-Request-Headers
1 < Content-Type: application/json
1 < Transfer-Encoding: chunked
1 < Date: Tue, 09 Jan 2024 22:56:32 GMT
1 < Keep-Alive: timeout=60
1 < Connection: keep-alive
{"profileid":40,"fullname":"Test User","pwd":"$2a$10$D9ehlw3Zt.4oW6OZV2VvIOAtRSLHXL2RtS0MMATu9TMnYOF0.utAq","username":"testuserc","aboutme":"undefined"}
> Then status 200 0.000
* karate.log(login.response) 0.001
15:56:33.424 {
  "profileid": 40,
  "fullname": "Test User",
  "pwd": "$2a$10$D9ehlw3Zt.4oW6OZV2VvIOAtRSLHXL2RtS0MMATu9TMnYOF0.utAq",
  "username": "testuserc",
  "aboutme": "undefined"
}
 
* assert login.responseStatus == respStatus 0.001
* def sessioncheck2 = call read('classpath:tests/services/sessioncheck.feature') 0.012
tests/services/sessioncheck.feature 0.000
> * print 'Inside get review service' 0.000
15:56:33.432 [print] Inside get review service 
> Given url baseUrl + 'session' 0.000
> And header Cookie = 'JSESSIONID=' + sessionvalue + '; Domain=localhost' 0.000
> When method get 0.004
15:56:33.433 request:
1 > GET http://localhost:8085/session
1 > Cookie: JSESSIONID=2A07EC9F7A6FC5B371D0F7BDE0E8C929; Domain=localhost
1 > Host: localhost:8085
1 > Connection: Keep-Alive
1 > User-Agent: Apache-HttpClient/4.5.13 (Java/1.8.0_231)
1 > Accept-Encoding: gzip,deflate


15:56:33.436 response time in milliseconds: 3
1 < 200
1 < Vary: Origin
1 < Vary: Access-Control-Request-Method
1 < Vary: Access-Control-Request-Headers
1 < Content-Type: application/json
1 < Transfer-Encoding: chunked
1 < Date: Tue, 09 Jan 2024 22:56:32 GMT
1 < Keep-Alive: timeout=60
1 < Connection: keep-alive
{"profileid":40,"fullname":"Test User","pwd":"$2a$10$D9ehlw3Zt.4oW6OZV2VvIOAtRSLHXL2RtS0MMATu9TMnYOF0.utAq","username":"testuserc","aboutme":"undefined"}
> Then status 200 0.000
* karate.log(sessioncheck2.response.username) 0.001
15:56:33.439 testuserc 
* assert sessioncheck2.responseStatus == respStatus 0.001
* match sessioncheck2.response.username == usernamefore2e 0.000
* def savereview1 = call read('classpath:tests/services/reviewsave.feature') 0.262
tests/services/reviewsave.feature 0.000
> * print 'Inside get review service' 0.000
15:56:33.448 [print] Inside get review service 
> Given url baseUrl + 'savereviews' 0.000
> And header Cookie = 'JSESSIONID=' + sessionvalue + '; Domain=localhost' 0.000
> And request { movieid: '#(imdbid)', revrating: '#(revrating)', revdesc: '#(revdesc)' } 0.002
> When method post 0.251
15:56:33.526 request:
1 > POST http://localhost:8085/savereviews
1 > Cookie: JSESSIONID=2A07EC9F7A6FC5B371D0F7BDE0E8C929; Domain=localhost
1 > Content-Type: application/json; charset=UTF-8
1 > Content-Length: 75
1 > Host: localhost:8085
1 > Connection: Keep-Alive
1 > User-Agent: Apache-HttpClient/4.5.13 (Java/1.8.0_231)
1 > Accept-Encoding: gzip,deflate
{"revrating":"2.0","revdesc":"It was okay actually","movieid":"tt11858890"}

15:56:33.703 response time in milliseconds: 177
1 < 200
1 < Vary: Origin
1 < Vary: Access-Control-Request-Method
1 < Vary: Access-Control-Request-Headers
1 < Content-Type: text/plain;charset=UTF-8
1 < Content-Length: 7
1 < Date: Tue, 09 Jan 2024 22:56:33 GMT
1 < Keep-Alive: timeout=60
1 < Connection: keep-alive
Success
> Then status 200 0.000
* karate.log(savereview1.response) 0.001
15:56:33.705 Success 
* assert savereview1.responseStatus == respStatus 0.000
* def savereview2 = call read('classpath:tests/services/reviewsave.feature') 0.197
tests/services/reviewsave.feature 0.000
> * print 'Inside get review service' 0.017
15:56:33.731 [print] Inside get review service 
> Given url baseUrl + 'savereviews' 0.000
> And header Cookie = 'JSESSIONID=' + sessionvalue + '; Domain=localhost' 0.000
> And request { movieid: '#(imdbid)', revrating: '#(revrating)', revdesc: '#(revdesc)' } 0.000
> When method post 0.170
15:56:33.733 request:
1 > POST http://localhost:8085/savereviews
1 > Cookie: JSESSIONID=2A07EC9F7A6FC5B371D0F7BDE0E8C929; Domain=localhost
1 > Content-Type: application/json; charset=UTF-8
1 > Content-Length: 75
1 > Host: localhost:8085
1 > Connection: Keep-Alive
1 > User-Agent: Apache-HttpClient/4.5.13 (Java/1.8.0_231)
1 > Accept-Encoding: gzip,deflate
{"revrating":"2.0","revdesc":"It was okay actually","movieid":"tt11858890"}

15:56:33.901 response time in milliseconds: 168
1 < 200
1 < Vary: Origin
1 < Vary: Access-Control-Request-Method
1 < Vary: Access-Control-Request-Headers
1 < Content-Type: text/plain;charset=UTF-8
1 < Content-Length: 7
1 < Date: Tue, 09 Jan 2024 22:56:33 GMT
1 < Keep-Alive: timeout=60
1 < Connection: keep-alive
Success
> Then status 200 0.000
* karate.log(savereview2.response) 0.001
15:56:33.903 Success 
* assert savereview2.responseStatus == respStatus 0.000
* def revusername = usernamefore2e 0.000
* def test = call read('classpath:tests/services/reviewsbyuser.feature') 0.198
tests/services/reviewsbyuser.feature 0.000
> * print 'Inside get review service' 0.000
15:56:33.912 [print] Inside get review service 
> Given url baseUrl + 'reviewsbyuser?username=' + revusername 0.000
> When method get 0.190
15:56:33.913 request:
1 > GET http://localhost:8085/reviewsbyuser?username=testuserc
1 > Host: localhost:8085
1 > Connection: Keep-Alive
1 > User-Agent: Apache-HttpClient/4.5.13 (Java/1.8.0_231)
1 > Accept-Encoding: gzip,deflate


15:56:34.103 response time in milliseconds: 189
1 < 200
1 < Vary: Origin
1 < Vary: Access-Control-Request-Method
1 < Vary: Access-Control-Request-Headers
1 < Content-Type: application/json
1 < Transfer-Encoding: chunked
1 < Date: Tue, 09 Jan 2024 22:56:33 GMT
1 < Keep-Alive: timeout=60
1 < Connection: keep-alive
[{"revrating":2.0,"revid":61,"revdesc":"It was okay actually","movieid":"tt11858890","userid":40},{"revrating":2.0,"revid":62,"revdesc":"It was okay actually","movieid":"tt11858890","userid":40}]
* karate.log(test.response) 0.004
15:56:34.108 {
  "revrating": 2.0,
  "revid": 61,
  "revdesc": "It was okay actually",
  "movieid": "tt11858890",
  "userid": 40
}
 {
  "revrating": 2.0,
  "revid": 62,
  "revdesc": "It was okay actually",
  "movieid": "tt11858890",
  "userid": 40
}
 
* def reviews = db.readRows('SELECT * FROM reviews WHERE revid IN (' + test.response[0].revid + ',' + test.response[1].revid + ')') 0.434
* karate.log(reviews.length) 0.001
15:56:34.543 2 
* assert reviews.length == 2 0.000
* def revid = test.response[0].revid 0.000
* def deletereview1 = call read('classpath:tests/services/reviewdelete.feature') 0.276
tests/services/reviewdelete.feature 0.000
> * print 'Inside get review service' 0.000
15:56:34.550 [print] Inside get review service 
> Given url baseUrl + 'deletereviews?revid=' + revid 0.000
> And header Cookie = 'JSESSIONID=' + sessionvalue + '; Domain=localhost' 0.000
> When method delete 0.268
15:56:34.553 request:
1 > DELETE http://localhost:8085/deletereviews?revid=61
1 > Cookie: JSESSIONID=2A07EC9F7A6FC5B371D0F7BDE0E8C929; Domain=localhost
1 > Host: localhost:8085
1 > Connection: Keep-Alive
1 > User-Agent: Apache-HttpClient/4.5.13 (Java/1.8.0_231)
1 > Accept-Encoding: gzip,deflate


15:56:34.819 response time in milliseconds: 266
1 < 200
1 < Vary: Origin
1 < Vary: Access-Control-Request-Method
1 < Vary: Access-Control-Request-Headers
1 < Content-Type: text/plain;charset=UTF-8
1 < Content-Length: 7
1 < Date: Tue, 09 Jan 2024 22:56:34 GMT
1 < Keep-Alive: timeout=60
1 < Connection: keep-alive
Success
> Then status 200 0.000
* karate.log(deletereview1.response) 0.001
15:56:34.822 Success 
* assert deletereview1.responseStatus == respStatus 0.000
* match deletereview1.response == 'Success' 0.000
* def test = call read('classpath:tests/services/reviewsbyuser.feature') 0.122
tests/services/reviewsbyuser.feature 0.000
> * print 'Inside get review service' 0.000
15:56:34.823 over-writing existing variable 'test' with new value: call read('classpath:tests/services/reviewsbyuser.feature')
15:56:34.831 [print] Inside get review service 
> Given url baseUrl + 'reviewsbyuser?username=' + revusername 0.000
> When method get 0.113
15:56:34.832 request:
1 > GET http://localhost:8085/reviewsbyuser?username=testuserc
1 > Host: localhost:8085
1 > Connection: Keep-Alive
1 > User-Agent: Apache-HttpClient/4.5.13 (Java/1.8.0_231)
1 > Accept-Encoding: gzip,deflate


15:56:34.945 response time in milliseconds: 112
1 < 200
1 < Vary: Origin
1 < Vary: Access-Control-Request-Method
1 < Vary: Access-Control-Request-Headers
1 < Content-Type: application/json
1 < Transfer-Encoding: chunked
1 < Date: Tue, 09 Jan 2024 22:56:34 GMT
1 < Keep-Alive: timeout=60
1 < Connection: keep-alive
[{"revrating":2.0,"revid":62,"revdesc":"It was okay actually","movieid":"tt11858890","userid":40}]
* karate.log(test.response) 0.000
15:56:34.947 {
  "revrating": 2.0,
  "revid": 62,
  "revdesc": "It was okay actually",
  "movieid": "tt11858890",
  "userid": 40
}
 
* karate.log(test.response.length) 0.001
15:56:34.948 1 
* assert test.response.length == 1 0.000
* def logout = call read('classpath:tests/services/sessionlogout.feature') 0.014
tests/services/sessionlogout.feature 0.000
> * print 'Inside get review service' 0.000
15:56:34.955 [print] Inside get review service 
> Given url baseUrl + 'logout' 0.000
> And header Cookie = 'JSESSIONID=' + sessionvalue + '; Domain=localhost' 0.000
> When method get 0.003
15:56:34.957 request:
1 > GET http://localhost:8085/logout
1 > Cookie: JSESSIONID=2A07EC9F7A6FC5B371D0F7BDE0E8C929; Domain=localhost
1 > Host: localhost:8085
1 > Connection: Keep-Alive
1 > User-Agent: Apache-HttpClient/4.5.13 (Java/1.8.0_231)
1 > Accept-Encoding: gzip,deflate


15:56:34.959 response time in milliseconds: 2
1 < 200
1 < Vary: Origin
1 < Vary: Access-Control-Request-Method
1 < Vary: Access-Control-Request-Headers
1 < Content-Length: 0
1 < Date: Tue, 09 Jan 2024 22:56:34 GMT
1 < Keep-Alive: timeout=60
1 < Connection: keep-alive

> Then status 200 0.000
* karate.log(logout.response) 0.001
15:56:34.963  
* assert logout.responseStatus == respStatus 0.000
* def sessioncheck3 = call read('classpath:tests/services/sessioncheck.feature') 0.021
tests/services/sessioncheck.feature 0.000
> * print 'Inside get review service' 0.001
15:56:34.975 [print] Inside get review service 
> Given url baseUrl + 'session' 0.000
> And header Cookie = 'JSESSIONID=' + sessionvalue + '; Domain=localhost' 0.000
> When method get 0.004
15:56:34.977 request:
1 > GET http://localhost:8085/session
1 > Cookie: JSESSIONID=2A07EC9F7A6FC5B371D0F7BDE0E8C929; Domain=localhost
1 > Host: localhost:8085
1 > Connection: Keep-Alive
1 > User-Agent: Apache-HttpClient/4.5.13 (Java/1.8.0_231)
1 > Accept-Encoding: gzip,deflate


15:56:34.979 response time in milliseconds: 2
1 < 200
1 < Vary: Origin
1 < Vary: Access-Control-Request-Method
1 < Vary: Access-Control-Request-Headers
1 < Content-Length: 0
1 < Date: Tue, 09 Jan 2024 22:56:34 GMT
1 < Keep-Alive: timeout=60
1 < Connection: keep-alive
1 < Set-Cookie: JSESSIONID=C4EB818344F0385517C5613A82DB4776; Domain=localhost

> Then status 200 0.000
* karate.log(sessioncheck3.response) 0.000
15:56:34.986  
* assert test.responseStatus == respStatus 0.000
* match sessioncheck.response == '' 0.000
* def login = call read('classpath:tests/services/sessionlogin.feature') 0.148
tests/services/sessionlogin.feature 0.000
> * print 'Inside get review service' 0.000
15:56:34.987 over-writing existing variable 'login' with new value: call read('classpath:tests/services/sessionlogin.feature')
15:56:35.002 [print] Inside get review service 
> Given url baseUrl + 'login?username=' + usernamefore2e + '&password=' + passwordfore2e 0.000
> And header Cookie = 'JSESSIONID=' + sessionvalue + '; Domain=localhost' 0.000
> When method post 0.126
15:56:35.004 request:
1 > POST http://localhost:8085/login?username=testuserc&password=test
1 > Cookie: JSESSIONID=2A07EC9F7A6FC5B371D0F7BDE0E8C929; Domain=localhost
1 > Host: localhost:8085
1 > Connection: Keep-Alive
1 > User-Agent: Apache-HttpClient/4.5.13 (Java/1.8.0_231)
1 > Accept-Encoding: gzip,deflate


15:56:35.129 response time in milliseconds: 125
1 < 200
1 < Vary: Origin
1 < Vary: Access-Control-Request-Method
1 < Vary: Access-Control-Request-Headers
1 < Content-Type: application/json
1 < Transfer-Encoding: chunked
1 < Date: Tue, 09 Jan 2024 22:56:34 GMT
1 < Keep-Alive: timeout=60
1 < Connection: keep-alive
1 < Set-Cookie: JSESSIONID=2CBACD5DC75F7A35B3879358977427AD; Domain=localhost
{"profileid":40,"fullname":"Test User","pwd":"$2a$10$D9ehlw3Zt.4oW6OZV2VvIOAtRSLHXL2RtS0MMATu9TMnYOF0.utAq","username":"testuserc","aboutme":"undefined"}
> Then status 200 0.000
* def sessionvalue = login.responseHeaders['Set-Cookie'][0].split('=')[1].split(';')[0].trim() 0.001
15:56:35.136 over-writing existing variable 'sessionvalue' with new value: login.responseHeaders['Set-Cookie'][0].split('=')[1].split(';')[0].trim()
* karate.log(login.response) 0.000
15:56:35.137 {
  "profileid": 40,
  "fullname": "Test User",
  "pwd": "$2a$10$D9ehlw3Zt.4oW6OZV2VvIOAtRSLHXL2RtS0MMATu9TMnYOF0.utAq",
  "username": "testuserc",
  "aboutme": "undefined"
}
 
* assert test.responseStatus == respStatus 0.000
* def sessioncheck6 = call read('classpath:tests/services/sessioncheck.feature') 0.038
tests/services/sessioncheck.feature 0.000
> * print 'Inside get review service' 0.000
15:56:35.160 [print] Inside get review service 
> Given url baseUrl + 'session' 0.000
> And header Cookie = 'JSESSIONID=' + sessionvalue + '; Domain=localhost' 0.000
> When method get 0.003
15:56:35.162 request:
1 > GET http://localhost:8085/session
1 > Cookie: JSESSIONID=2CBACD5DC75F7A35B3879358977427AD; Domain=localhost
1 > Host: localhost:8085
1 > Connection: Keep-Alive
1 > User-Agent: Apache-HttpClient/4.5.13 (Java/1.8.0_231)
1 > Accept-Encoding: gzip,deflate


15:56:35.164 response time in milliseconds: 2
1 < 200
1 < Vary: Origin
1 < Vary: Access-Control-Request-Method
1 < Vary: Access-Control-Request-Headers
1 < Content-Type: application/json
1 < Transfer-Encoding: chunked
1 < Date: Tue, 09 Jan 2024 22:56:34 GMT
1 < Keep-Alive: timeout=60
1 < Connection: keep-alive
{"profileid":40,"fullname":"Test User","pwd":"$2a$10$D9ehlw3Zt.4oW6OZV2VvIOAtRSLHXL2RtS0MMATu9TMnYOF0.utAq","username":"testuserc","aboutme":"undefined"}
> Then status 200 0.000
* karate.log(sessioncheck6.response.username) 0.001
15:56:35.177 testuserc 
* assert sessioncheck6.responseStatus == respStatus 0.000
* match sessioncheck6.response.username == usernamefore2e 0.000
* def login = call read('classpath:tests/services/sessionunregister.feature') 0.314
tests/services/sessionunregister.feature 0.000
> * print 'Inside get review service' 0.000
15:56:35.178 over-writing existing variable 'login' with new value: call read('classpath:tests/services/sessionunregister.feature')
15:56:35.208 [print] Inside get review service 
> Given url baseUrl + 'unregister' 0.000
> And header Cookie = 'JSESSIONID=' + sessionvalue + '; Domain=localhost' 0.000
> When method delete 0.254
15:56:35.209 request:
1 > DELETE http://localhost:8085/unregister
1 > Cookie: JSESSIONID=2CBACD5DC75F7A35B3879358977427AD; Domain=localhost
1 > Host: localhost:8085
1 > Connection: Keep-Alive
1 > User-Agent: Apache-HttpClient/4.5.13 (Java/1.8.0_231)
1 > Accept-Encoding: gzip,deflate


15:56:35.463 response time in milliseconds: 253
1 < 200
1 < Vary: Origin
1 < Vary: Access-Control-Request-Method
1 < Vary: Access-Control-Request-Headers
1 < Content-Length: 0
1 < Date: Tue, 09 Jan 2024 22:56:34 GMT
1 < Keep-Alive: timeout=60
1 < Connection: keep-alive

> Then status 200 0.000
* karate.log(login.response) 0.000
15:56:35.493  
* assert test.responseStatus == respStatus 0.000
* def sessioncheck4 = call read('classpath:tests/services/sessioncheck.feature') 0.131
tests/services/sessioncheck.feature 0.000
> * print 'Inside get review service' 0.000
15:56:35.565 [print] Inside get review service 
> Given url baseUrl + 'session' 0.000
> And header Cookie = 'JSESSIONID=' + sessionvalue + '; Domain=localhost' 0.000
> When method get 0.002
15:56:35.567 request:
1 > GET http://localhost:8085/session
1 > Cookie: JSESSIONID=2CBACD5DC75F7A35B3879358977427AD; Domain=localhost
1 > Host: localhost:8085
1 > Connection: Keep-Alive
1 > User-Agent: Apache-HttpClient/4.5.13 (Java/1.8.0_231)
1 > Accept-Encoding: gzip,deflate


15:56:35.569 response time in milliseconds: 1
1 < 200
1 < Vary: Origin
1 < Vary: Access-Control-Request-Method
1 < Vary: Access-Control-Request-Headers
1 < Content-Length: 0
1 < Date: Tue, 09 Jan 2024 22:56:34 GMT
1 < Keep-Alive: timeout=60
1 < Connection: keep-alive
1 < Set-Cookie: JSESSIONID=9126D6619ADE287208EC0FB1BBCE30DD; Domain=localhost

> Then status 200 0.000
* karate.log(sessioncheck4.response) 0.001
15:56:35.628  
* assert test.responseStatus == respStatus 0.000
* match sessioncheck.response == '' 0.000
* def test = call read('classpath:tests/services/reviewsbyuser.feature') 0.326
tests/services/reviewsbyuser.feature 0.000
> * print 'Inside get review service' 0.000
15:56:35.628 over-writing existing variable 'test' with new value: call read('classpath:tests/services/reviewsbyuser.feature')
15:56:35.765 [print] Inside get review service 
> Given url baseUrl + 'reviewsbyuser?username=' + revusername 0.000
> When method get 0.076
15:56:35.767 request:
1 > GET http://localhost:8085/reviewsbyuser?username=testuserc
1 > Host: localhost:8085
1 > Connection: Keep-Alive
1 > User-Agent: Apache-HttpClient/4.5.13 (Java/1.8.0_231)
1 > Accept-Encoding: gzip,deflate


15:56:35.841 response time in milliseconds: 74
1 < 200
1 < Vary: Origin
1 < Vary: Access-Control-Request-Method
1 < Vary: Access-Control-Request-Headers
1 < Content-Length: 0
1 < Date: Tue, 09 Jan 2024 22:56:35 GMT
1 < Keep-Alive: timeout=60
1 < Connection: keep-alive

* karate.log(test.response) 0.000
15:56:35.954  
* karate.log(test.response.length) 0.000
15:56:35.955 0 
* assert test.response.length == 0 0.000
Tags: @smoke
2.374
* print 'test' 0.001
15:56:31.649 karate.env system property was: qa 
15:56:31.652 [print] test 
* def test = call read('classpath:tests/services/moviesearch.feature') 1.177
tests/services/moviesearch.feature 0.000
> * print 'Inside get review service' 0.001
15:56:31.668 [print] Inside get review service 
> Given url baseUrl + 'movies?moviename=' + filmtitle + '&movieyear=' + filmyear 0.000
> When method get 1.159
15:56:32.530 request:
1 > GET http://localhost:8085/movies?moviename=star%20trek&movieyear=2009
1 > Host: localhost:8085
1 > Connection: Keep-Alive
1 > User-Agent: Apache-HttpClient/4.5.13 (Java/1.8.0_231)
1 > Accept-Encoding: gzip,deflate


15:56:32.828 response time in milliseconds: 298
1 < 200
1 < Vary: Origin
1 < Vary: Access-Control-Request-Method
1 < Vary: Access-Control-Request-Headers
1 < Content-Type: application/json
1 < Transfer-Encoding: chunked
1 < Date: Tue, 09 Jan 2024 22:56:32 GMT
1 < Keep-Alive: timeout=60
1 < Connection: keep-alive
{"Year":"2009","imdbID":"tt0796366","Poster":"https:\/\/m.media-amazon.com\/images\/M\/MV5BMjE5NDQ5OTE4Ml5BMl5BanBnXkFtZTcwOTE3NDIzMw@@._V1_SX300.jpg","Title":"Star Trek"}
> Then status 200 0.000
* karate.log(test.response) 0.001
15:56:32.831 {
  "Year": "2009",
  "imdbID": "tt0796366",
  "Poster": "https://m.media-amazon.com/images/M/MV5BMjE5NDQ5OTE4Ml5BMl5BanBnXkFtZTcwOTE3NDIzMw@@._V1_SX300.jpg",
  "Title": "Star Trek"
}
 
* assert test.responseStatus == respStatus 0.000
* match test.response.imdbID == imdbID 0.031
Tags: @smoke
1.922
* print 'test' 0.001
15:56:31.717 karate.env system property was: qa 
15:56:31.720 [print] test 
* def test = call read('classpath:tests/services/movieposter.feature') 0.958
tests/services/movieposter.feature 0.000
> * print 'Inside get review service' 0.005
15:56:31.732 [print] Inside get review service 
> Given url baseUrl + 'movieposter?imdbID=' + imdbID 0.001
> When method get 0.943
15:56:32.535 request:
1 > GET http://localhost:8085/movieposter?imdbID=tt0796366
1 > Host: localhost:8085
1 > Connection: Keep-Alive
1 > User-Agent: Apache-HttpClient/4.5.13 (Java/1.8.0_231)
1 > Accept-Encoding: gzip,deflate


15:56:32.676 response time in milliseconds: 134
1 < 200
1 < Vary: Origin
1 < Vary: Access-Control-Request-Method
1 < Vary: Access-Control-Request-Headers
1 < Content-Type: application/json
1 < Transfer-Encoding: chunked
1 < Date: Tue, 09 Jan 2024 22:56:32 GMT
1 < Keep-Alive: timeout=60
1 < Connection: keep-alive
{"Year":"2009","imdbID":"tt0796366","Poster":"https:\/\/m.media-amazon.com\/images\/M\/MV5BMjE5NDQ5OTE4Ml5BMl5BanBnXkFtZTcwOTE3NDIzMw@@._V1_SX300.jpg","Title":"Star Trek"}
* karate.log(test.response) 0.005
15:56:32.684 {
  "Year": "2009",
  "imdbID": "tt0796366",
  "Poster": "https://m.media-amazon.com/images/M/MV5BMjE5NDQ5OTE4Ml5BMl5BanBnXkFtZTcwOTE3NDIzMw@@._V1_SX300.jpg",
  "Title": "Star Trek"
}
 
* assert test.responseStatus == respStatus 0.004
* assert test.response.imdbID == imdbID 0.001
* assert test.response.Poster == moviePoster 0.000
Tags: @smoke
1.083
* print 'test' 0.000
15:56:32.874 karate.env system property was: qa 
15:56:32.878 [print] test 
* def test = call read('classpath:tests/services/reviewsbyone.feature') 0.107
tests/services/reviewsbyone.feature 0.000
> * print 'Inside get review service' 0.001
15:56:32.886 [print] Inside get review service 
> Given url baseUrl + 'reviewsbyone?revid=' + revid 0.002
> When method get 0.096
15:56:32.891 request:
1 > GET http://localhost:8085/reviewsbyone?revid=20
1 > Host: localhost:8085
1 > Connection: Keep-Alive
1 > User-Agent: Apache-HttpClient/4.5.13 (Java/1.8.0_231)
1 > Accept-Encoding: gzip,deflate


15:56:32.984 response time in milliseconds: 92
1 < 200
1 < Vary: Origin
1 < Vary: Access-Control-Request-Method
1 < Vary: Access-Control-Request-Headers
1 < Content-Type: application/json
1 < Transfer-Encoding: chunked
1 < Date: Tue, 09 Jan 2024 22:56:32 GMT
1 < Keep-Alive: timeout=60
1 < Connection: keep-alive
{"revrating":10.0,"revid":20,"revdesc":"This is my absolute favorite MCU movie. Tom Holland does a great job with the role, and I feel like the MCU has a bad habit of making every conflict have the entire universe at stake. In this movie, it's more grounded which I find more relatable. The conflict matters but isn't the fabric of reality itself, the hero is fun and the villain is fantastic. Highly recommend even if you're not a big super hero person.","movieid":"tt2250912","userid":4}
* karate.log(test.response) 0.001
15:56:32.986 {
  "revrating": 10.0,
  "revid": 20,
  "revdesc": "This is my absolute favorite MCU movie. Tom Holland does a great job with the role, and I feel like the MCU has a bad habit of making every conflict have the entire universe at stake. In this movie, it's more grounded which I find more relatable. The conflict matters but isn't the fabric of reality itself, the hero is fun and the villain is fantastic. Highly recommend even if you're not a big super hero person.",
  "movieid": "tt2250912",
  "userid": 4
}
 
* def reviews = db.readRows('SELECT * FROM reviews') 0.868
* karate.log(reviews[0].revid) 0.002
15:56:33.857 20 
* def queriedrevid = revid 0.000
* assert test.responseStatus == respStatus 0.000
* assert test.response.revid == queriedrevid 0.000
Tags: @smoke
1.117
* print 'test' 0.000
15:56:32.991 karate.env system property was: qa 
15:56:32.993 [print] test 
* karate.log(baseUrl) 0.001
15:56:32.994 http://localhost:8085/ 
* def test = call read('classpath:tests/services/reviewsforhome.feature') 0.258
tests/services/reviewsforhome.feature 0.000
> * print 'Inside get review service' 0.000
15:56:33.002 [print] Inside get review service 
> Given url baseUrl + 'getreviews' 0.000
> When method get 0.249
15:56:33.004 request:
1 > GET http://localhost:8085/getreviews
1 > Host: localhost:8085
1 > Connection: Keep-Alive
1 > User-Agent: Apache-HttpClient/4.5.13 (Java/1.8.0_231)
1 > Accept-Encoding: gzip,deflate


15:56:33.253 response time in milliseconds: 247
1 < 200
1 < Vary: Origin
1 < Vary: Access-Control-Request-Method
1 < Vary: Access-Control-Request-Headers
1 < Content-Type: application/json
1 < Transfer-Encoding: chunked
1 < Date: Tue, 09 Jan 2024 22:56:32 GMT
1 < Keep-Alive: timeout=60
1 < Connection: keep-alive
[{"revrating":10.0,"revid":20,"revdesc":"This is my absolute favorite MCU movie. Tom Holland does a great job with the role, and I feel like the MCU has a bad habit of making every conflict have the entire universe at stake. In this movie, it's more grounded which I find more relatable. The conflict matters but isn't the fabric of reality itself, the hero is fun and the villain is fantastic. Highly recommend even if you're not a big super hero person.","movieid":"tt2250912","userid":4},{"revrating":1.0,"revid":21,"revdesc":"This is really a prime example of super hero movies gone wrong. Super half baked CGI and some really weird plot turns. I wish I was exaggerating when I said that HULK fights mutant poodles in this movie but somehow it's come to this.","movieid":"tt0286716","userid":4},{"revrating":8.0,"revid":22,"revdesc":"This movie was so fun, the stunts and action scenes were absolutely on the pinnacle of what films can accomplish in this day and age. That said I thought the plot was pretty nonsense. The main conflict was difficult to grasp and straining the limits of believability. However I put this movie right next to Avatar 2 in my list of movies that are breathtaking to watch if you try to disregard the reasons that things are happening.","movieid":"tt9603212","userid":4},{"revrating":10.0,"revid":25,"revdesc":"One of the most brilliant movies ever made! Cast perfectly. A brilliant homage to horror movie history while embracing timeless humor. ","movieid":"tt0072431","userid":5},{"revrating":4.0,"revid":26,"revdesc":"This movie had a lot going for it. The actors did a great job and some of the dialogue was really captivating and made you think about how fragile civilization is and how dangerous human nature can be. However the pacing really held it back and a significant lack of believability in the scenarios they give you really made me struggle to enjoy it. It was also about an hour too long in my humble opinion.","movieid":"tt10545296","userid":4},{"revrating":10.0,"revid":28,"revdesc":"Perhaps the pinnacle of Michael Bay\u2019s achievements. Or at least the best Transformers movie by far. Don\u2019t think about it too much.","movieid":"tt0418279","userid":6},{"revrating":8.0,"revid":29,"revdesc":"Very good, absolutely jaw dropping CGI but littered with some odd plot points and low brow humor that holds it back a little in my opinion.","movieid":"tt0418279","userid":4},{"revrating":7.0,"revid":30,"revdesc":"I have mixed feelings about this one. They did a lot right and Colin Farrell as the Penguin was an absolutely beautiful thing. The tone was great and the music was absolutely phenomenal. That said there was a really long part at the end that felt a little bit tacked on. And a few things felt odd, like batman in full costume hanging out with a bunch of cops like a cringey comic con nerd. A great watch though despite the things holding it back.","movieid":"tt1877830","userid":4},{"revrating":7.0,"revid":31,"revdesc":"It's a bit overly melodramatic in places and takes all the silly elements a bit too seriously, but it deserves a great amount of praise for being the ultimate Friday the 13th movie. It absolutely respects every bit of Friday the 13th \"lore\" that came before and enhances it in every way. As much as people love the original 3 Friday the 13th movies, they are NOT good movies! This 4th entry is actually the first good entry in the franchise AND it respects it's... Let's say... Silly audience, but elevates it all without abandoning them. In my opinion, they deserve high praise for that! Also, let's talk about the absolute shining stars of this film! Corey Feldman plays Tommy wonderfully and the movie deserves an extra half star, at least, for Crispin Glover alone! What a glorious performance! \"Hey Ted! Where the hell's the corkscrew??\"","movieid":"tt0087298","userid":7},{"revrating":9.0,"revid":32,"revdesc":"This movie transcends its franchise completely, and is, for some strange reason, the first movie to truly allow itself to accept the absurdity of its world. I think this is the only entry to contain 0 nudity and it's still SIGNIFICANTLY more fun than the rest combined! This movie is an absolute banger front to back! It's almost a parody of its own franchise while also giving us the most brutal and menacing Jason and is the ONLY entry in the ENTIRE franchise that made me feel something!! I was genuinely concerned for the characters! I was actually upset (borderline angry) about some of the deaths and fearing others because they had real characters in this movie and those characters made choices that made me care! For the first time I actually didn't want Jason to kill!! He literally became a truly bad guy for the first time! Crazy that it took 6 entries for this crap! Awesome movie! If you want to watch 1 entry in this franchise, this is absolutely the 1!!","movieid":"tt0091080","userid":7}]
> Then status 200 0.000
* karate.log(test.response) 0.001
15:56:33.255 {
  "revrating": 10.0,
  "revid": 20,
  "revdesc": "This is my absolute favorite MCU movie. Tom Holland does a great job with the role, and I feel like the MCU has a bad habit of making every conflict have the entire universe at stake. In this movie, it's more grounded which I find more relatable. The conflict matters but isn't the fabric of reality itself, the hero is fun and the villain is fantastic. Highly recommend even if you're not a big super hero person.",
  "movieid": "tt2250912",
  "userid": 4
}
 {
  "revrating": 1.0,
  "revid": 21,
  "revdesc": "This is really a prime example of super hero movies gone wrong. Super half baked CGI and some really weird plot turns. I wish I was exaggerating when I said that HULK fights mutant poodles in this movie but somehow it's come to this.",
  "movieid": "tt0286716",
  "userid": 4
}
 {
  "revrating": 8.0,
  "revid": 22,
  "revdesc": "This movie was so fun, the stunts and action scenes were absolutely on the pinnacle of what films can accomplish in this day and age. That said I thought the plot was pretty nonsense. The main conflict was difficult to grasp and straining the limits of believability. However I put this movie right next to Avatar 2 in my list of movies that are breathtaking to watch if you try to disregard the reasons that things are happening.",
  "movieid": "tt9603212",
  "userid": 4
}
 {
  "revrating": 10.0,
  "revid": 25,
  "revdesc": "One of the most brilliant movies ever made! Cast perfectly. A brilliant homage to horror movie history while embracing timeless humor. ",
  "movieid": "tt0072431",
  "userid": 5
}
 {
  "revrating": 4.0,
  "revid": 26,
  "revdesc": "This movie had a lot going for it. The actors did a great job and some of the dialogue was really captivating and made you think about how fragile civilization is and how dangerous human nature can be. However the pacing really held it back and a significant lack of believability in the scenarios they give you really made me struggle to enjoy it. It was also about an hour too long in my humble opinion.",
  "movieid": "tt10545296",
  "userid": 4
}
 {
  "revrating": 10.0,
  "revid": 28,
  "revdesc": "Perhaps the pinnacle of Michael Bay\u2019s achievements. Or at least the best Transformers movie by far. Don\u2019t think about it too much.",
  "movieid": "tt0418279",
  "userid": 6
}
 {
  "revrating": 8.0,
  "revid": 29,
  "revdesc": "Very good, absolutely jaw dropping CGI but littered with some odd plot points and low brow humor that holds it back a little in my opinion.",
  "movieid": "tt0418279",
  "userid": 4
}
 {
  "revrating": 7.0,
  "revid": 30,
  "revdesc": "I have mixed feelings about this one. They did a lot right and Colin Farrell as the Penguin was an absolutely beautiful thing. The tone was great and the music was absolutely phenomenal. That said there was a really long part at the end that felt a little bit tacked on. And a few things felt odd, like batman in full costume hanging out with a bunch of cops like a cringey comic con nerd. A great watch though despite the things holding it back.",
  "movieid": "tt1877830",
  "userid": 4
}
 {
  "revrating": 7.0,
  "revid": 31,
  "revdesc": "It's a bit overly melodramatic in places and takes all the silly elements a bit too seriously, but it deserves a great amount of praise for being the ultimate Friday the 13th movie. It absolutely respects every bit of Friday the 13th \"lore\" that came before and enhances it in every way. As much as people love the original 3 Friday the 13th movies, they are NOT good movies! This 4th entry is actually the first good entry in the franchise AND it respects it's... Let's say... Silly audience, but elevates it all without abandoning them. In my opinion, they deserve high praise for that! Also, let's talk about the absolute shining stars of this film! Corey Feldman plays Tommy wonderfully and the movie deserves an extra half star, at least, for Crispin Glover alone! What a glorious performance! \"Hey Ted! Where the hell's the corkscrew??\"",
  "movieid": "tt0087298",
  "userid": 7
}
 {
  "revrating": 9.0,
  "revid": 32,
  "revdesc": "This movie transcends its franchise completely, and is, for some strange reason, the first movie to truly allow itself to accept the absurdity of its world. I think this is the only entry to contain 0 nudity and it's still SIGNIFICANTLY more fun than the rest combined! This movie is an absolute banger front to back! It's almost a parody of its own franchise while also giving us the most brutal and menacing Jason and is the ONLY entry in the ENTIRE franchise that made me feel something!! I was genuinely concerned for the characters! I was actually upset (borderline angry) about some of the deaths and fearing others because they had real characters in this movie and those characters made choices that made me care! For the first time I actually didn't want Jason to kill!! He literally became a truly bad guy for the first time! Crazy that it took 6 entries for this crap! Awesome movie! If you want to watch 1 entry in this franchise, this is absolutely the 1!!",
  "movieid": "tt0091080",
  "userid": 7
}
 
* def reviews = db.readRows('SELECT * FROM reviews WHERE revid = ' + test.response[0].revid) 0.599
* karate.log(reviews) 0.001
15:56:33.856 {
  "revid": 20,
  "userid": 4,
  "movieid": "tt2250912",
  "revrating": 10,
  "revdesc": "This is my absolute favorite MCU movie. Tom Holland does a great job with the role, and I feel like the MCU has a bad habit of making every conflict have the entire universe at stake. In this movie, it's more grounded which I find more relatable. The conflict matters but isn't the fabric of reality itself, the hero is fun and the villain is fantastic. Highly recommend even if you're not a big super hero person."
}
 
* karate.log(reviews[0].movieid) 0.000
15:56:33.857 tt2250912 
* karate.log(test.response[0].movieid) 0.001
15:56:33.858 tt2250912 
* assert reviews[0].movieid == test.response[0].movieid 0.000
* assert test.responseStatus == respStatus 0.000
Tags: @smoke
0.841
* print 'test' 0.000
15:56:33.070 karate.env system property was: qa 
15:56:33.071 [print] test 
* def test = call read('classpath:tests/services/reviewsbymovie.feature') 0.063
tests/services/reviewsbymovie.feature 0.000
> * print 'Inside get review service' 0.000
15:56:33.078 [print] Inside get review service 
> Given url baseUrl + 'reviewsbymovie?imdbid=' + imdbid 0.000
> When method get 0.055
15:56:33.080 request:
1 > GET http://localhost:8085/reviewsbymovie?imdbid=tt0418279
1 > Host: localhost:8085
1 > Connection: Keep-Alive
1 > User-Agent: Apache-HttpClient/4.5.13 (Java/1.8.0_231)
1 > Accept-Encoding: gzip,deflate


15:56:33.134 response time in milliseconds: 53
1 < 200
1 < Vary: Origin
1 < Vary: Access-Control-Request-Method
1 < Vary: Access-Control-Request-Headers
1 < Content-Type: application/json
1 < Transfer-Encoding: chunked
1 < Date: Tue, 09 Jan 2024 22:56:32 GMT
1 < Keep-Alive: timeout=60
1 < Connection: keep-alive
[{"revrating":10.0,"revid":28,"revdesc":"Perhaps the pinnacle of Michael Bay\u2019s achievements. Or at least the best Transformers movie by far. Don\u2019t think about it too much.","movieid":"tt0418279","userid":6},{"revrating":8.0,"revid":29,"revdesc":"Very good, absolutely jaw dropping CGI but littered with some odd plot points and low brow humor that holds it back a little in my opinion.","movieid":"tt0418279","userid":4}]
> Then status 200 0.000
* karate.log(test.response) 0.001
15:56:33.136 {
  "revrating": 10.0,
  "revid": 28,
  "revdesc": "Perhaps the pinnacle of Michael Bay\u2019s achievements. Or at least the best Transformers movie by far. Don\u2019t think about it too much.",
  "movieid": "tt0418279",
  "userid": 6
}
 {
  "revrating": 8.0,
  "revid": 29,
  "revdesc": "Very good, absolutely jaw dropping CGI but littered with some odd plot points and low brow humor that holds it back a little in my opinion.",
  "movieid": "tt0418279",
  "userid": 4
}
 
* def reviews = db.readRows('SELECT * FROM reviews WHERE movieid = "' + imdbid + '"') 0.718
* assert reviews[0].movieid == test.response[0].movieid 0.001
* assert test.responseStatus == respStatus 0.000
Tags: @smoke
0.665
* print 'test' 0.000
15:56:33.326 karate.env system property was: qa 
15:56:33.327 [print] test 
* def test = call read('classpath:tests/services/reviewsbyuser.feature') 0.119
tests/services/reviewsbyuser.feature 0.000
> * print 'Inside get review service' 0.000
15:56:33.333 [print] Inside get review service 
> Given url baseUrl + 'reviewsbyuser?username=' + revusername 0.000
> When method get 0.112
15:56:33.335 request:
1 > GET http://localhost:8085/reviewsbyuser?username=sbarlowc
1 > Host: localhost:8085
1 > Connection: Keep-Alive
1 > User-Agent: Apache-HttpClient/4.5.13 (Java/1.8.0_231)
1 > Accept-Encoding: gzip,deflate


15:56:33.445 response time in milliseconds: 110
1 < 200
1 < Vary: Origin
1 < Vary: Access-Control-Request-Method
1 < Vary: Access-Control-Request-Headers
1 < Content-Type: application/json
1 < Transfer-Encoding: chunked
1 < Date: Tue, 09 Jan 2024 22:56:32 GMT
1 < Keep-Alive: timeout=60
1 < Connection: keep-alive
[{"revrating":10.0,"revid":20,"revdesc":"This is my absolute favorite MCU movie. Tom Holland does a great job with the role, and I feel like the MCU has a bad habit of making every conflict have the entire universe at stake. In this movie, it's more grounded which I find more relatable. The conflict matters but isn't the fabric of reality itself, the hero is fun and the villain is fantastic. Highly recommend even if you're not a big super hero person.","movieid":"tt2250912","userid":4},{"revrating":1.0,"revid":21,"revdesc":"This is really a prime example of super hero movies gone wrong. Super half baked CGI and some really weird plot turns. I wish I was exaggerating when I said that HULK fights mutant poodles in this movie but somehow it's come to this.","movieid":"tt0286716","userid":4},{"revrating":8.0,"revid":22,"revdesc":"This movie was so fun, the stunts and action scenes were absolutely on the pinnacle of what films can accomplish in this day and age. That said I thought the plot was pretty nonsense. The main conflict was difficult to grasp and straining the limits of believability. However I put this movie right next to Avatar 2 in my list of movies that are breathtaking to watch if you try to disregard the reasons that things are happening.","movieid":"tt9603212","userid":4},{"revrating":4.0,"revid":26,"revdesc":"This movie had a lot going for it. The actors did a great job and some of the dialogue was really captivating and made you think about how fragile civilization is and how dangerous human nature can be. However the pacing really held it back and a significant lack of believability in the scenarios they give you really made me struggle to enjoy it. It was also about an hour too long in my humble opinion.","movieid":"tt10545296","userid":4},{"revrating":8.0,"revid":29,"revdesc":"Very good, absolutely jaw dropping CGI but littered with some odd plot points and low brow humor that holds it back a little in my opinion.","movieid":"tt0418279","userid":4},{"revrating":7.0,"revid":30,"revdesc":"I have mixed feelings about this one. They did a lot right and Colin Farrell as the Penguin was an absolutely beautiful thing. The tone was great and the music was absolutely phenomenal. That said there was a really long part at the end that felt a little bit tacked on. And a few things felt odd, like batman in full costume hanging out with a bunch of cops like a cringey comic con nerd. A great watch though despite the things holding it back.","movieid":"tt1877830","userid":4}]
* karate.log(test.response[0].revid) 0.001
15:56:33.448 20 
* def reviews = db.readRows('SELECT * FROM reviews WHERE revid IN (' + test.response[0].revid + ',' + test.response[1].revid + ',' + test.response[2].revid + ')') 0.425
* karate.log(reviews.length) 0.003
15:56:33.877 3 
* assert reviews.length == 3 0.000
* assert test.responseStatus == respStatus 0.000
Tags: @smoke
1.225
* print 'test' 0.000
15:56:33.862 karate.env system property was: qa 
15:56:33.863 [print] test 
* def test = call read('classpath:tests/services/allusers.feature') 0.392
tests/services/allusers.feature 0.000
> * print 'Inside get review service' 0.000
15:56:33.867 [print] Inside get review service 
> Given url baseUrl + 'all' 0.000
> When method get 0.386
15:56:33.869 request:
1 > GET http://localhost:8085/all
1 > Host: localhost:8085
1 > Connection: Keep-Alive
1 > User-Agent: Apache-HttpClient/4.5.13 (Java/1.8.0_231)
1 > Accept-Encoding: gzip,deflate


15:56:34.254 response time in milliseconds: 385
1 < 200
1 < Vary: Origin
1 < Vary: Access-Control-Request-Method
1 < Vary: Access-Control-Request-Headers
1 < Content-Type: application/json
1 < Transfer-Encoding: chunked
1 < Date: Tue, 09 Jan 2024 22:56:33 GMT
1 < Keep-Alive: timeout=60
1 < Connection: keep-alive
[{"profileid":4,"fullname":"Sam Barlow","pwd":"$2a$10$gvvz2d2PYcgA5kMLoca60uxWCFAfAvN6qV3xl8gYTZb3y46fPxUc.","username":"sbarlowc","aboutme":"undefined"},{"profileid":5,"fullname":"Jeff Barlow","pwd":"$2a$10$0mhm8RTvvvGd79fcEJqN.ezsT.ER9QIU2UKGx.hixGvFEsk8OHnUS","username":"Jelvetica","aboutme":"undefined"},{"profileid":6,"fullname":"Bryce Corning ","pwd":"$2a$10$46l68n\/kf0st3e8FLKpZp.0mTjtTUzBYL84FKznGKZU3z7v61NRse","username":"Corndog55","aboutme":"undefined"},{"profileid":7,"fullname":"James Cluff","pwd":"$2a$10$wJZCd9ik15NeFh9czNvNiuRxUXWq.Dqg3cAc70KjT0WgqPb5KRb86","username":"cyanoticsamurai","aboutme":"undefined"},{"profileid":40,"fullname":"Test User","pwd":"$2a$10$D9ehlw3Zt.4oW6OZV2VvIOAtRSLHXL2RtS0MMATu9TMnYOF0.utAq","username":"testuserc","aboutme":"undefined"}]
> Then status 200 0.000
* karate.log(test.response[0].profileid) 0.001
15:56:34.257 4 
* def users = db.readRows('SELECT * FROM userprofiles WHERE profileid IN (' + test.response[0].profileid + ',' + test.response[1].profileid + ',' + test.response[2].profileid + ')') 0.441
* karate.log(users.length) 0.001
15:56:34.700 3 
* assert users.length == 3 0.001
* assert test.responseStatus == respStatus 0.000
Tags: @smoke
0.628
* print 'test' 0.000
15:56:33.881 karate.env system property was: qa 
15:56:33.882 [print] test 
* def test = call read('classpath:tests/services/userbyname.feature') 0.060
tests/services/userbyname.feature 0.000
> * print 'Inside get review service' 0.000
15:56:33.888 [print] Inside get review service 
> Given url baseUrl + 'userbyname?username=' + textuname 0.000
> When method get 0.053
15:56:33.891 request:
1 > GET http://localhost:8085/userbyname?username=sbarlowc
1 > Host: localhost:8085
1 > Connection: Keep-Alive
1 > User-Agent: Apache-HttpClient/4.5.13 (Java/1.8.0_231)
1 > Accept-Encoding: gzip,deflate


15:56:33.942 response time in milliseconds: 50
1 < 200
1 < Vary: Origin
1 < Vary: Access-Control-Request-Method
1 < Vary: Access-Control-Request-Headers
1 < Content-Type: application/json
1 < Transfer-Encoding: chunked
1 < Date: Tue, 09 Jan 2024 22:56:33 GMT
1 < Keep-Alive: timeout=60
1 < Connection: keep-alive
4
* karate.log(test.response) 0.000
15:56:33.944 4 
* def user = db.readRows('SELECT * FROM userprofiles WHERE profileid = "' + test.response + '"') 0.509
* karate.log(user) 0.001
15:56:34.456 {
  "profileid": 4,
  "username": "sbarlowc",
  "pwd": "$2a$10$gvvz2d2PYcgA5kMLoca60uxWCFAfAvN6qV3xl8gYTZb3y46fPxUc.",
  "fullname": "Sam Barlow",
  "aboutme": "undefined"
}
 
* assert test.responseStatus == respStatus 0.000
* assert test.response == user[0].profileid 0.000
Tags: @smoke
0.586
* print 'test' 0.000
15:56:34.114 karate.env system property was: qa 
15:56:34.115 [print] test 
* def test = call read('classpath:tests/services/userbyid.feature') 0.056
tests/services/userbyid.feature 0.000
> * print 'Inside get review service' 0.000
15:56:34.120 [print] Inside get review service 
> Given url baseUrl + 'namebyuser?userid=' + textuid 0.000
> When method get 0.050
15:56:34.123 request:
1 > GET http://localhost:8085/namebyuser?userid=4
1 > Host: localhost:8085
1 > Connection: Keep-Alive
1 > User-Agent: Apache-HttpClient/4.5.13 (Java/1.8.0_231)
1 > Accept-Encoding: gzip,deflate


15:56:34.171 response time in milliseconds: 48
1 < 200
1 < Vary: Origin
1 < Vary: Access-Control-Request-Method
1 < Vary: Access-Control-Request-Headers
1 < Content-Type: text/plain;charset=UTF-8
1 < Content-Length: 21
1 < Date: Tue, 09 Jan 2024 22:56:33 GMT
1 < Keep-Alive: timeout=60
1 < Connection: keep-alive
{"uname":"sbarlowc"}
* karate.log(test.response) 0.000
15:56:34.172 {
  "uname": "sbarlowc"
}
 
* def user = db.readRows('SELECT * FROM userprofiles WHERE profileid = "' + textuid + '"') 0.474
* karate.log(user) 0.001
15:56:34.647 {
  "profileid": 4,
  "username": "sbarlowc",
  "pwd": "$2a$10$gvvz2d2PYcgA5kMLoca60uxWCFAfAvN6qV3xl8gYTZb3y46fPxUc.",
  "fullname": "Sam Barlow",
  "aboutme": "undefined"
}
 
* assert test.responseStatus == respStatus 0.000
* assert test.response.uname == user[0].username 0.000
Tags: @smoke
0.100
* print 'test' 0.000
15:56:34.202 karate.env system property was: qa 
15:56:34.203 [print] test 
* def test = call read('classpath:tests/services/useravailable.feature') 0.051
tests/services/useravailable.feature 0.000
> * print 'Inside get review service' 0.000
15:56:34.209 [print] Inside get review service 
> Given url baseUrl + 'checkuser?username=' + textuname 0.000
> When method post 0.044
15:56:34.211 request:
1 > POST http://localhost:8085/checkuser?username=sbarlowc
1 > Host: localhost:8085
1 > Connection: Keep-Alive
1 > User-Agent: Apache-HttpClient/4.5.13 (Java/1.8.0_231)
1 > Accept-Encoding: gzip,deflate


15:56:34.254 response time in milliseconds: 43
1 < 200
1 < Vary: Origin
1 < Vary: Access-Control-Request-Method
1 < Vary: Access-Control-Request-Headers
1 < Content-Type: application/json
1 < Transfer-Encoding: chunked
1 < Date: Tue, 09 Jan 2024 22:56:33 GMT
1 < Keep-Alive: timeout=60
1 < Connection: keep-alive
true
> Then status 200 0.000
* karate.log(test.response) 0.000
15:56:34.256 true 
* assert test.responseStatus == respStatus 0.000
* assert test.response == returned 0.000
Tags: @smoke
0.092
* print 'test' 0.000
15:56:34.261 karate.env system property was: qa 
15:56:34.262 [print] test 
* def test = call read('classpath:tests/services/useravailable.feature') 0.048
tests/services/useravailable.feature 0.000
> * print 'Inside get review service' 0.000
15:56:34.267 [print] Inside get review service 
> Given url baseUrl + 'checkuser?username=' + textuname 0.000
> When method post 0.042
15:56:34.269 request:
1 > POST http://localhost:8085/checkuser?username=ffsadjyuuiouong
1 > Host: localhost:8085
1 > Connection: Keep-Alive
1 > User-Agent: Apache-HttpClient/4.5.13 (Java/1.8.0_231)
1 > Accept-Encoding: gzip,deflate


15:56:34.310 response time in milliseconds: 41
1 < 200
1 < Vary: Origin
1 < Vary: Access-Control-Request-Method
1 < Vary: Access-Control-Request-Headers
1 < Content-Type: application/json
1 < Transfer-Encoding: chunked
1 < Date: Tue, 09 Jan 2024 22:56:33 GMT
1 < Keep-Alive: timeout=60
1 < Connection: keep-alive
false
> Then status 200 0.000
* karate.log(test.response) 0.000
15:56:34.311 false 
* assert test.responseStatus == respStatus 0.000
* assert test.response == returned 0.000