radar/twist-v2

View on GitHub
backend/db/migrate/20190403215406_update_book_notes_view.rb

Summary

Maintainability
A
30 mins
Test Coverage
ROM::SQL.migration do
  change do
    view_query = self[:notes]
    .join(:elements, id: :element_id)
    .join(:chapters, id: :chapter_id)
    .join(:commits, id: :commit_id)
    .join(:branches, id: :branch_id)
    .select_all(:notes)
    .select_append(Sequel[:branches][:book_id])

    drop_view :book_notes
    create_view :book_notes, view_query
  end
end