Arel_table rails

Address.where( Address.arel_table[:created_at].lt( 5.days.ago ) ).to_sql
# SELECT "addresses".* FROM "addresses"  WHERE ("addresses"."created_at" < '2016-12-13 03:31:23.911914')

Source: rollout.io

Arel_table rails

veg = Arel::Table.new(:vegetables)
query = veg[:created_at].gteq( 5.days.ago ).and(
  veg[:color].eq("green").or(
    veg[:gardener].eq("Susan")
  )
)
query.to_sql
#  "vegetables"."created_at" >= '2016-12-13 03:54:28.575342'
#    AND ("vegetables"."color" = 'green' OR "vegetables"."gardener" = 'Susan')
Vegetable.where( query )

Source: rollout.io

Similar codes

1 vote400 views1 answer
Ruby filter
Ruby
0 vote456 views1 answer
Self referencing association in ruby on rails
Ruby
0 vote373 views1 answer
Rails transactions
Ruby
1 vote326 views1 answer
Run task rails
Ruby
0 vote361 views1 answer
Rails g model references
Ruby
0 vote354 views1 answer
Rails localhost https
Ruby
0 vote397 views1 answer
Rails 6 TypeError: $(...).tooltip is not a function
Ruby
1 vote346 views1 answer
Ruby comments
Ruby
0 vote368 views1 answer
Ruby remove last element of string
Ruby
0 vote355 views1 answer
Expect actionmailer base nullmail
Ruby