Open this file for each environment and update DATABASE_URL for your database.

Setup database variable for the development environment:

# .env.test
DATABASE_URL="database_type://username:password@localhost/bookshelf_test"

For jdbc urls you can’t set username and password to the left of @ you have to set them as parameters in the url:

After your database variables setup is done you need to create the database and run the migrations before being able to launch a development server.

To setup your test environment database, enter:

Hanami models use ROM as a low-level backend. This means that you can easily use any plugins in your app. For this you need to define a block in your model configuration, add the extension by calling extension on gateway.connection and pass the extension name in:

# config/environment.rb
  model do
      g.connection.extension(:connection_validator)
    end
end