AA
но наверное все равно улчше райзнуть ж, да?
describe 'valid simple query' do
let!(:user){create :user, role: :user, email: 'im@gmail.com'}
subject do
str = "id eq '1'"
filter = FilterParser::FilterGenerator.new(str).generate_filter
query = filter.apply_filter User
query
end
it 'should have one user' do
expect(subject.size).to eq 1
end
it 'should have email of user' do
expect(subject.first.email).to eq user.email
end
end
describe 'valid composite query' do
let!(:user){create :user, role: :user, email: 'im@gmail.com'}
let!(:another_user){create :user, role: :user, email: 'jo@gmail.com'}
subject do
str = "(id ne '99') and (email eq 'jo@gmail.com')"
filter = FilterParser::FilterGenerator.new(str).generate_filter
query = filter.apply_filter User
query
end
it 'should have email of another_user' do
expect(subject.first.email).to eq another_user.email
end
end
describe 'valid composite query 2' do
let!(:user){create :user, id: 97}
let!(:second_user){create :user, id: 98}
let!(:third_user){create :user, id: 99}
subject do
str = "id eq '97' or id eq '98' and id lt '50' or id gt '20' and id ne '99'"
filter = FilterParser::FilterGenerator.new(str).generate_filter
query = filter.apply_filter User
query
end
it 'should have email of another_user' do
expect(subject.first.id).to eq user.id
end
end
describe 'invalid query_string' do
it 'should raise error ' do
query_string = "(id eq '1)"
expect{
FilterParser::FilterGenerator.new(query_string).generate_filter
}.to raise_error(Parslet::ParseFailed)
end
it 'should raise error ' do
query_string = "(id eq 1)"
expect{
FilterParser::FilterGenerator.new(query_string).generate_filter
}.to raise_error(Parslet::ParseFailed)
end
it 'should raise error ' do
query_string = "id gg '1'"
expect{
FilterParser::FilterGenerator.new(query_string).generate_filter
}.to raise_error(Parslet::ParseFailed)
end
it 'should raise error ' do
query_string = "(id eq '1') or and eq 55"
expect{
FilterParser::FilterGenerator.new(query_string).generate_filter
}.to raise_error(Parslet::ParseFailed)
end
it 'should raise error ' do
query_string = "(id! eq '1)"
expect{
FilterParser::FilterGenerator.new(query_string).generate_filter
}.to raise_error(Parslet::ParseFailed)
end
it 'should raise error ' do
query_string = "(id eq '1'"
expect{
FilterParser::FilterGenerator.new(query_string).generate_filter
}.to raise_error(Parslet::ParseFailed)
end
it 'should raise error ' do
query_string = "(id eq '1' or) ne '2'"
expect{
FilterParser::FilterGenerator.new(query_string).generate_filter
}.to raise_error(Parslet::ParseFailed)
end
end
describe 'valid query_string, but invaid expression' do
subject do
query_string = "non_existing_field_name eq '5'"
filter = FilterParser::FilterGenerator.new(query_string).generate_filter
query = filter.apply_filter User
query.first
end
it 'should raise error ' do
expect{ subject }.to raise_exception(ActiveRecord::StatementInvalid)
end
end