Database Assertions

@baseUrl = http://localhost:3000
@dbUrl = sqlite://./test.db

### Create a user
# @name createUser
# @tags db
# @db {{dbUrl}}

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

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

>>>
expect status 201
expect body.id exists
<<<

>>>capture
userId from body.id
<<<

>>>db
SELECT name, email FROM users WHERE id = {{createUser.userId}}
expect name == "John Doe"
expect email == "john@example.com"
<<<

### Update user email
# @name updateUser
# @depends createUser
# @tags db
# @db {{dbUrl}}

PUT {{baseUrl}}/users/{{createUser.userId}}
Content-Type: application/json

{
  "email": "john.doe@newdomain.com"
}

>>>
expect status 200
<<<

>>>db
SELECT email FROM users WHERE id = {{createUser.userId}}
expect email == "john.doe@newdomain.com"
<<<

### Delete user
# @depends updateUser
# @tags db
# @db {{dbUrl}}

DELETE {{baseUrl}}/users/{{createUser.userId}}

>>>
expect status 204
<<<

>>>db
SELECT COUNT(*) as count FROM users WHERE id = {{createUser.userId}}
expect count == 0
<<<

hitspec run examples/database-assertions.http --allow-db --env dev