Contents

require File.expand_path(File.dirname(__FILE__) + "/spec_helper")
require 'ledger_web/report'

describe LedgerWeb::Report do
  describe "#from_query" do
    it "should run the query" do

      LedgerWeb::Report.session = {:from => '2012/01/01', :to => '2012/01/01'}

      load_fixture('small')

      report = LedgerWeb::Report.from_query("select count(1) as foo from ledger")
      rows = []
      report.each_row do |row|
        rows << row
      end

      rows[0][0][0].should eq(5)
      rows[0][0][1].should eq(LedgerWeb::Field.new('foo', 'number', 'pull-right'))
    end
  end

  describe "#pivot" do
    it "should create the correct fields" do
      LedgerWeb::Report.session = {:from => '2012/01/01', :to => '2012/01/01'}
      load_fixture('small')

      report = LedgerWeb::Report.from_query("select xtn_month, account, sum(amount) from ledger group by xtn_month, account")
      report = report.pivot("account", "asc")

      report.fields.should eq([
        string_field('xtn_month'),
        number_field('Assets:Checking'),
        number_field('Assets:Savings'),
        number_field('Equity:Opening Balances'),
        number_field('Expenses:Lunch')
      ])
      
    end

    it "should put the values in the right place" do
      LedgerWeb::Report.session = {:from => '2012/01/01', :to => '2012/01/01'}
      load_fixture('small')

      report = LedgerWeb::Report.from_query("select xtn_month, account, sum(amount)::integer from ledger group by xtn_month, account")
      report = report.pivot("account", "asc")

      report.rows.should eq([
        [Date.new(2012,1,1), 190, 100, -300, 10]
      ])
    end
  end
end

Version data entries

2 entries across 2 versions & 1 rubygems

Version	Path
ledger_web-1.4.4	test/report_spec.rb
ledger_web-1.4.3	test/report_spec.rb