blob: 3b6a7314a287dc926369ca4017348b21c8cd6fff (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
|
require 'spec_helper'
module Arel
describe Expression do
before do
@relation = Table.new(:users)
@attribute = @relation[:id]
end
describe '#to_sql' do
it "manufactures sql with the expression and alias" do
sql = Count.new(@attribute, :alias).to_sql
adapter_is :mysql do
sql.should be_like(%Q{COUNT(`users`.`id`) AS `alias`})
end
adapter_is :oracle do
sql.should be_like(%Q{COUNT("USERS"."ID") AS "ALIAS"})
end
adapter_is_not :mysql, :oracle do
sql.should be_like(%Q{COUNT("users"."id") AS "alias"})
end
end
end
end
end
|