blob: bd1dfa4750dadea47b9224013281ec986cf74ae8 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
require 'helper'
describe Arel::Nodes::Extract do
it "should extract field" do
table = Arel::Table.new :users
table[:timestamp].extract('date').to_sql.must_be_like %{
EXTRACT(DATE FROM "users"."timestamp")
}
end
describe "as" do
it 'should alias the extract' do
table = Arel::Table.new :users
table[:timestamp].extract('date').as('foo').to_sql.must_be_like %{
EXTRACT(DATE FROM "users"."timestamp") AS foo
}
end
end
end
|