This is a sample Rails app for PostgreSQL nontrivial query testing.
It implements core associations and robust seed data so you can jump in and test some queries.
There are also some advanced, commonly needed query scopes you can learn from (like selecting last book of every author).
- Make sure you have
PostgreSQL ~> 9.6
set up as the relational database - Consult the gemfile, set up needed Ruby version and bundler
bundle
to install needed gems- Consult
config/database_example.yml
to make your ownconfig/database.yml
file - Set up database contents with
rake db:create db:migrate db:seed
You have rspec and factory girl with core factories set up to use as you please.
Alternatively, you can perform raw queries on the seeded development database by running rails dbconsole
and then some SQL.
As of 2017-10-15 this repo implements RSpec profiling to determine how fast different setup strategies are. See the writeup.
$ rspec spec/setup_benchmark.rb
# and look at the output of spec/group_profiling_results.csv
You will probably want to just fork this repo and hack on the copy however you like.
If, however, you think that this core repo could use an update, open an issue and we will come to an agreement on what to do. โญ