Class: BomDB::Export::Verses

Inherits:
Export::Base
  • Object
show all
Defined in:
lib/bomdb/export/verses.rb

Instance Method Summary collapse

Instance Method Details

#export_json ⇒ Object 



6
7
8
9
10
11
12
13
14
15
16
17
 
# File 'lib/bomdb/export/verses.rb', line 6

def export_json
  verses = []
  @db[:verses].join(:books, :book_id => :book_id).
    where(:verse_heading => nil).
    order(:book_sort, :verse_chapter).
    select_group(:book_name, :verse_chapter).
    select_append{ Sequel.as(max(:verse_number), :count) }. 
  each do |v|
    verses << { book: v[:book_name], chapter: v[:verse_chapter], verses: v[:count] }
  end
  Export::Result.new(success: true, body: JSON.pretty_generate(verses))
end