Skip to content

Instantly share code, notes, and snippets.

@mgreenly
Created May 14, 2011 03:23
Show Gist options
  • Save mgreenly/971885 to your computer and use it in GitHub Desktop.
Save mgreenly/971885 to your computer and use it in GitHub Desktop.
datatable spec
require 'spec_helper'
describe 'Data tables subclasses' do
# it 'should work' do
# Order.create!(:order_number => 32)
# data_table = OrdersIndex.new
# params = {}
# json = data_table.query(params).json
# json['aaRecords'][0][0].should == 32
# end
it 'should select two fields' do
class OrdersSimple < DataTable
set_model Order
column :order_number
column :memo
end
orders = Order.arel_table
OrdersSimple.new.sql.should == Order.select(orders[:order_number]).select(orders[:memo]).to_sql
OrdersSimple.relation.should == Order.select(orders[:order_number]).select(orders[:memo])
#OrdersSimple.relation.should == Order.select([:order_number, :memo])
end
it 'should handle a simple join' do
class OrdersSimple < DataTable
set_model Order
column :memo
join :customer
end
orders = Order.arel_table
customers = Customer.arel_table
OrdersSimple.new.sql.should == Order.select(orders[:memo]).joins(:customer).to_sql
OrdersSimple.relation.should == Order.select(orders[:memo]).joins(:customer)
end
it 'should handle a join with an inner column' do
class OrdersSimple < DataTable
set_model Order
column :memo
join :customer do
column :first_name
end
end
orders = Order.arel_table
customers = Customer.arel_table
OrdersSimple.new.sql.should == Order.select(orders[:memo]).joins(:customer).select(customers[:first_name]).to_sql
OrdersSimple.relation.should == Order.select(orders[:memo]).joins(:customer).select(customers[:first_name])
end
# Next: Better way to keep track of joins (a stack of classes? reflect on associations to get real table name).
#
end
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment