Sha256: bd7256e6885896b8cd4193d72fc5b3e74fea7de7b0c006c1e69cfd9230672369
Contents?: true
Size: 1.46 KB
Versions: 8
Compression:
Stored size: 1.46 KB
Contents
require 'minitest_helper'
describe 'ComputedAttribute' do
it 'Apply Join wiht join attribute must generate correct query' do
dataset = db[:users]
computed_attribute = Rasti::DB::ComputedAttribute.new(Sequel[:comments_count][:value]) do |dataset|
subquery = dataset.db.from(:comments)
.select(Sequel[:user_id], Sequel.function('count', :id).as(:value))
.group(:user_id)
.as(:comments_count)
dataset.join_table(:inner, subquery, :user_id => :id)
end
expected_query = "SELECT *, `comments_count`.`value` AS 'value' FROM `users` INNER JOIN (SELECT `user_id`, count(`id`) AS 'value' FROM `comments` GROUP BY `user_id`) AS 'comments_count' ON (`comments_count`.`user_id` = `users`.`id`)"
computed_attribute.apply_join(dataset)
.select_append(computed_attribute.identifier)
.sql
.must_equal expected_query
end
it 'Apply join without join attribute must generate correct query' do
dataset = db[:people]
computed_attribute = Rasti::DB::ComputedAttribute.new Sequel.join([:first_name, ' ', :last_name])
expected_query = "SELECT * FROM `people` WHERE ((`first_name` || ' ' || `last_name`) = 'FULL NAME')"
computed_attribute.apply_join(dataset)
.where(computed_attribute.identifier => 'FULL NAME')
.sql
.must_equal expected_query
end
end
Version data entries
8 entries across 8 versions & 1 rubygems