Database Testing Guide

hitspec run tests/ --allow-db

### Create user
# @db sqlite:./test.db
POST {{baseUrl}}/users
Content-Type: application/json

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

>>>
expect status 201
<<<

>>>db
SELECT COUNT(*) AS count, name, email FROM users WHERE email = 'john@example.com'
expect count == 1
expect name == "John"
expect 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

# @db {{dbUrl}}
POST {{baseUrl}}/orders
Content-Type: application/json

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

>>>
expect status 201
<<<

>>>db
SELECT COUNT(*) as count FROM orders WHERE product = 'Widget'
expect count == 1
<<<

# @db {{dbUrl}}
DELETE {{baseUrl}}/users/1

>>>
expect status 204
<<<

>>>db
SELECT COUNT(*) as count FROM user_sessions WHERE user_id = 1
expect count == 0
<<<

# @db {{dbUrl}}
PUT {{baseUrl}}/users/1
Content-Type: application/json

{"name": "  John Doe  "}

>>>
expect status 200
<<<

>>>db
SELECT name FROM users WHERE id = 1
expect name == "John Doe"
<<<