squeel

squeel copied to clipboard

Sifters seem to be great for a single model only. I'm trying to use one model's sifters in another model, but I can't seem to know how to do it,...

bostrom

like_any [] fails in Rails 4.2.1 with Ruby 2.2.1

2

`Contact.where{ email.like_any([]) }.to_sql` raises `RuntimeError: unsupported: NilClass` I'd submit a pull if I knew where that code was, but I don't see any tests for `like_any`. Can someone point me...

codenamev

How to have join with additional ON clauses

2

Hi, I'd like to generate a query like: ``` SELECT * FROM user LEFT OUTER JOIN user_deal_notification ON user_deal_notification.user_id == user.id AND user_deal_notification.deal_id = 1234 WHERE user_deal_notification.id IS NOT NULL...

ioquatix

activerecord 4.2 issue

1

Hi, i realize rails 4.2 is using arel 6.0.0, and its seems to be incompatible with squeel right?

u007

Rails 4.2.3 bug

4

We just discovered a bug after upgrading to Rails 4.2.3 in the following scope: ``` scope :can_have_dns_records, -> { where { (dns_zone == true) | ((value == nil) & (domain_id.not_in(Subdomain.where(dns_zone:...

hannesfostie

A bit of context: Our system tracks users' **achievements**. These may have other achievements as **conditions** (to track prerequisites). A resource which `has_many` conditions is called a **conditional**. There are...

dariusf

Filter using a model array?

1

I'm trying to filter results based on an array of models I have 4 models: Venues, Facility, Availability and Activities. This is the squeel I put together to return Availabilities:...

simkessy

Support for Postgres JSON functions and operators

1

I can't find the subject in documentation or source code. Is it supported? http://www.postgresql.org/docs/9.4/static/functions-json.html

flowerett

Hello, I'm looking how to perform the SQL command "SELECT FOR UPDATE" with squeel in Rails 3.2. http://www.postgresql.org/docs/9.2/static/sql-select.html Could you please advise ? Many Thanks,

bluebird-communication

functions do not allow predicates as arguments

1

I have the following scope: ``` def self.ready_to_be_reauthorized with_state( :delivered ). online. joins { order_items.product_inventory.product }. having { bool_and( order_items.weight.not_eq( nil ) | product.catch_weight.eq( false ) ) }. group {...

mckinnsb