Database Testing Guide

hitspec run tests/ --allow-db

### Create user
POST {{baseUrl}}/users
Content-Type: application/json

{"name": "John", "email": "john@example.com"}

>>>
expect status 201
<<<

>>>db sqlite:./test.db
SELECT * FROM users WHERE email = 'john@example.com'
<<<

>>>
expect db.rows length 1
expect db.rows[0].name == "John"
expect db.rows[0].email == "john@example.com"
<<<

sqlite://./test.db
sqlite:./relative/path.db
sqlite:///absolute/path.db

postgres://username:password@localhost:5432/mydb
postgres://username:password@localhost:5432/mydb?sslmode=disable

mysql://username:password@localhost:3306/mydb

POST {{baseUrl}}/orders
Content-Type: application/json

{"product": "Widget", "quantity": 5}

>>>
expect status 201
<<<

>>>db {{dbUrl}}
SELECT COUNT(*) as count FROM orders WHERE product = 'Widget'
<<<

>>>
expect db.rows[0].count == 1
<<<

DELETE {{baseUrl}}/users/1

>>>
expect status 204
<<<

>>>db {{dbUrl}}
SELECT COUNT(*) as count FROM user_sessions WHERE user_id = 1
<<<

>>>
expect db.rows[0].count == 0
<<<

PUT {{baseUrl}}/users/1
Content-Type: application/json

{"name": "  John Doe  "}

>>>
expect status 200
<<<

>>>db {{dbUrl}}
SELECT name FROM users WHERE id = 1
<<<

>>>
expect db.rows[0].name == "John Doe"
<<<