Database Assertions

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

### Create a user
# @name createUser
# @tags db

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 {{dbUrl}}
SELECT * FROM users WHERE id = {{createUser.userId}}
<<<

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

### Update user email
# @name updateUser
# @depends createUser
# @tags db

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

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

>>>
expect status 200
<<<

>>>db {{dbUrl}}
SELECT email FROM users WHERE id = {{createUser.userId}}
<<<

>>>
expect db.rows[0].email == "john.doe@newdomain.com"
<<<

### Delete user
# @depends updateUser
# @tags db

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

>>>
expect status 204
<<<

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

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

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