Reset

When doing end-to-end testing on a system like this, it's always a bit annoying to have to manually reset the state of the database. For example, the register command fails if you run it again with the same username because the user already exists.

That's the behavior we want, but we have to manually reset the database each time we run tests.

Assignment

Let's add a command to our CLI that will reset the database to a blank state. This will make development much easier for us (although probably not useful in production... maybe even disastrous).

Add a new query to the database that deletes all the users in the users table. Generate the Go code with sqlc generate. Use the :exec tag in the comment.
Add a new command called reset that calls the query. Report back to the user about whether or not it was successful with an appropriate exit code.

Run and submit the CLI tests.

The Boot.dev CLI requires you to be signed in to submit your solution!

Copy/paste one of the following commands into your terminal:

Run

bootdev run 6619ebf8-44ab-4a2b-a536-0b17d116c15e

Submit

bootdev run 6619ebf8-44ab-4a2b-a536-0b17d116c15e -s

Run the CLI commands to test your solution.

go run . reset
- Expecting exit code: 0
go run . register kahya
- Expecting exit code: 0
go run . register kahya
- Expecting exit code: 1
go run . reset
- Expecting exit code: 0
go run . register kahya
- Expecting exit code: 0

Using the Bootdev CLI

The Bootdev CLI is the only way to submit your solution for this type of lesson. We need to be able to run commands in your environment to verify your solution.

You can install it here. It's a Go program hosted on GitHub, so you'll need Go installed as well. Instructions are on the GitHub page.