Rails5 based boilerplate for restful API server including admin page
run following commands in postgreSQL client eg. psql
CREATE USER <yourdbuser> CREATEDB PASSWORD '<userdbpassword>';
$ bundle install
$ rails db:create
$ rails db:migrate
$ rails db:seed
$ rails s
create a user having only select privileges for the blazer
\connect <userdbname>;
BEGIN;
CREATE ROLE <blazeruser> LOGIN PASSWORD '<blazeruserpassword>';
GRANT CONNECT ON DATABASE <userdbname> TO <blazeruser>;
GRANT USAGE ON SCHEMA public TO <blazeruser>;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO <blazeruser>;
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO <blazeruser>;
COMMIT;
specify db connect information for production
ENV["BLAZER_DATABASE_URL"] = "postgres://user:password@hostname:5432/database"
after install docker
docker-compose build
docker-compose run app rails db:create
docker-compose run app rails db:migrate
docker-compose up
after creating test database defined in config/database.yml
$ rspec [spec file path]
or
$ rake