Switch into the postgres user or simply fire up the postgresql client with the postgres role.
$ psql -U postgres
Create a role for the app
create role dude_expenses with createdb superuser login password '123456';
You need to create the new role as a superuser in order to be able to enable specific database extensions. If you have an existing user you have to alter the role with
alter role dude_expenses superuser;
Using the newly created role, create a database for development.
$ createdb -U dude_expenses -h localhost dude_expenses_development;
All app migrations live in db/migrate. You should execute them using the configuration you created above.
$ psql -h localhost -U dude_expenses -d dude_expenses_development
> create table...
In order to access /expenses resources you must provide a valid JWT token in the Authorization header.
You can obtain a valid token by authenticating first. Use the authentication endpoint and provide a valid email and password.
$ curl -i -X POST https://dudeexpenses.com/users/authenticate -d '{ "email": "homer@simpsons.com", "password": "123456" }'
$ curl -i -H "Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ1c2VyX2lkIjoiMTMifQ.Ss0Cr47S6-V99R0E1dy_Tax8yPICiYS0SPDX4HLMD-2" https://dudeexpenses.com/expenses